Re: [WebDNA] Upload file to mysql

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113489
interpreted = N
texte = 1084 ------=_Part_11212_132354502.1490140349373 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Not my favorite solution, but it is working well. I hate mixing languages in the same site. Brian Boegershausen On Tue, Mar 21, 2017 at 7:49 PM -0400, "Stuart Tremain" wrote: Yes, PHP has a nice escape routine. I should write one for WebDNA as I would use it, at the moment I just use G= REP for a few characters. Kind regards Stuart TremainPharoah Lane SoftwareAUSTRALIAwebdna@idfk.com.au On 22 Mar 2017, at 00:17, Brian Boegershausen wrote= : Thank stuart. After a few more painful hours of tinkering, i decided to write the upload/= download pages in php.=20 Works great now. All the escape context is built right in. Not my favorite option, but why reinvent the wheel. Brian Boegershausen From: Stuart Tremain Sent: Monday, March 20, 10:58 PM Subject: Re: [WebDNA] Upload file to mysql To: WebDNA Talk List http://php.net/manual/en/mysqli.real-escape-string.php Characters encoded are=C2=A0NUL (ASCII 0),=20 , \r, \, ', ", and Control-Z. Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au On 21 Mar 2017, at 13:51, Brian Boegershausen wrote= : You think i should [url]ize the string? Then i can look for %0A and things like that. Brian Boegershausen On Mon, Mar 20, 2017 at 10:49 PM -0400, "Stuart Tremain" wrote: I think that is where your problem lies. https://dev.mysql.com/doc/refman/5.7/en/string-literals.html The MySQL manual page for strings says: \0 =C2=A0 An ASCII NUL (0x00) character. \' =C2=A0 A single quote (=E2=80=9C'=E2=80=9D) character. \" =C2=A0 A double quote (=E2=80=9C"=E2=80=9D) character. \b =C2=A0 A backspace character. =C2=A0 A newline (linefeed) character. \r =C2=A0 A carriage return character. \t =C2=A0 A tab character. \Z =C2=A0 ASCII 26 (Control-Z).=C2=A0 \\ =C2=A0 A backslash (=E2=80=9C\=E2=80=9D) character. \% =C2=A0 A =E2=80=9C%=E2=80=9D character.=C2=A0 \_ =C2=A0 A =E2=80=9C_=E2=80=9D character.=C2=A0 Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au On 21 Mar 2017, at 13:42, w= rote: I added the ; into my convertchars database. Flushed=E2=80=A6 still having = an issue. I think I need a bigger list of escape characters=C2=A0L=C2=A0 =C2=A0 =C2=A0 From:=C2=A0Stuart Tremain [mailto:webdna@idfk.com.au]=C2=A0 Sent:=C2=A0Monday, March 20, 2017 9:45 PM To:=C2=A0WebDNA Talk List Subject:=C2=A0Re: [WebDNA] Upload file to mysql=C2=A0 That is a problem with a character causing MySQL to fail.=C2=A0 Looking at your conversion db it looks like you have covered everything exc= ept for ; (semicolon)=C2=A0 There may be something else as well.=C2=A0 Kind regards=C2=A0 Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 On 21 Mar 2017, at 12:16, w= rote:=C2=A0 ERROR TEXT: You have an error in your SQL syntax; check the manual that cor= responds to your MySQL server version for the right syntax to use near ''\%= PDF-1.5 \%=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=C2=A01 0 obj <=C2=A0 =C2=A0 When I look in the errorlog.txt file, the=C2=A0=EF=BF=BD characters=C2=A0ar= e the following symbols. =C3=A2=C3=A3=C3=8F=C3=93=C2=A0 =C2=A0 From:=C2=A0Stuart Tremain [mailto:webdna@idfk.com.au]=C2=A0 Sent:=C2=A0Monday, March 20, 2017 9:03 PM To:=C2=A0WebDNA Talk List Subject:=C2=A0Re: [WebDNA] Upload file to mysql=C2=A0 What is the error ?=C2=A0 Kind regards=C2=A0 Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 On 21 Mar 2017, at 12:00, Brian Boegershausen wrote= :=C2=A0 Mysql error.=C2=A0 Brian Boegershausen=C2=A0 =C2=A0 On Mon, Mar 20, 2017 at 8:59 PM -0400, "Stuart Tremain" wrote: Brian, when you say it chokes, do you mean that WebDNA stalls or do you get= a MySQL error message ?=C2=A0 =C2=A0 Kind regards=C2=A0 Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 On 21 Mar 2017, at 11:15, w= rote:=C2=A0 Hi Stewart, I have my content field set to MEDIUMBLOB which allows for 16mb max files. So far, I am using files around 100kb, so I am not reaching the max yet.=C2= =A0 My query writes all the data fields and uploads .txt files, but once I chan= ge to a file like a PDF, it chokes.=C2=A0 [showif [referer]^file_manager.dna] [FormVariables] [showif [name]^filename] =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 [text show=3DF]TheFileNM=3D[Middle StartAfter=3Dfilename=3D= "&EndBefore=3D"][name][/middle][/text] [/showif] [showif [name]^CPK] =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 [text show=3DF]CPK=3D[value][/text] [/showif] [showif [name]^JPK] =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 [text show=3DF]JPK=3D[value][/text] [/showif] [/FormVariables]=C2=A0 [hideif [TheFileNM]=3D] [hideif [CPK]=3D] [hideif [JPK]=3D] [FormVariables] [showif [name]^"thefile"] [SQLExecute conn_ref=3DTheBlueBiller&result_var=3DUPLOAD_INS] INSERT INTO UPLOAD (FILE_ID, COMPANY_ID, CLIENT_ID, JOB_ID, NAME, CONTENT, ROW_ADDED_DTTM) VALUES ('', '[LOGIN_COMPANY_ID]', '[CPK]', '[JPK]', '[TheFileNM]', '[conver= tchars db=3Ddatabases/upload.db][value][/convertchars]', '[date %Y-%m-%d %H= :%M:%S]') [/SQLExecute] [/showif] [/FormVariables] [/hideif] [/hideif] [/hideif]=C2=A0 [!]=3D=3D=3D=3D=3D=3D=3D=3DUPLOAD.DB FILE------------[/!] FROM=C2=A0=C2=A0 TO '=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 \' "=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 \" \=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 \\ %=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 \%=C2= =A0 From:=C2=A0Stuart Tremain [mailto:webdna@idfk.com.au]=C2=A0 Sent:=C2=A0Monday, March 20, 2017 6:43 PM To:=C2=A0WebDNA Talk List Subject:=C2=A0Re: [WebDNA] Upload file to mysql=C2=A0 Hi Brian=C2=A0 I have not done that, but providing your MySQL field is LONGBLOB all should= work.=C2=A0=C2=A0 Also to be able to insert images that are bigger than 1MB you have to incre= ase the max_allowed_packed option in the server configuration file.=C2=A0 I use Navicat to write all my queries and then copy & paset the query into = my WebDNA doc. Navicat makes writing & debugging fast.=C2=A0 Kind regards=C2=A0 Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 On 21 Mar 2017, at 07:55, Brian Boegershausen wrote= :=C2=A0 Anyone successfully upload a file to a mysql db? I can upload a text file but that is it. Jpg and gif fail. Unbuntu 14 Webdna 8.2 Mysql 5.5=C2=A0 Brian Boegershausen=C2=A0 =C2=A0 --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe,= E-mail to: archives:=C2=A0http://mail.webdna.us/list/talk@webdna.us=C2=A0B= ug Reporting:=C2=A0support@webdna.us =C2=A0=C2=A0 Virus-free.=C2=A0www.avg.com --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe,= E-mail to: archives:=C2=A0http://mail.webdna.us/list/talk@webdna.us=C2=A0B= ug Reporting:=C2=A0support@webdna.us --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list=C2=A0. To unsubsc= ribe, E-mail to:=C2=A0archives:=C2=A0http://mail.webdna.us/list/talk@webdna= ..us=C2=A0Bug Reporting:=C2=A0support@webdna.us =C2=A0 --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe,= E-mail to: archives:=C2=A0http://mail.webdna.us/list/talk@webdna.us=C2=A0B= ug Reporting:=C2=A0support@webdna.us --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe,= E-mail to: archives:=C2=A0http://mail.webdna.us/list/talk@webdna.us=C2=A0B= ug Reporting:=C2=A0support@webdna.us =C2=A0=C2=A0 Virus-free.=C2=A0www.avg.com --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe,= E-mail to: archives:=C2=A0http://mail.webdna.us/list/talk@webdna.us=C2=A0B= ug Reporting:=C2=A0support@webdna.us --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list=C2=A0. To unsubsc= ribe, E-mail to:=C2=A0archives:=C2=A0http://mail.webdna.us/list/talk@webdna= ..us=C2=A0Bug Reporting:=C2=A0support@webdna.us =C2=A0=C2=A0 Virus-free.=C2=A0www.avg.com --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe,= E-mail to: archives:=C2=A0http://mail.webdna.us/list/talk@webdna.us=C2=A0B= ug Reporting:=C2=A0support@webdna.us --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list=C2=A0. To unsubsc= ribe, E-mail to:=C2=A0archives:=C2=A0http://mail.webdna.us/list/talk@webdna= ..us=C2=A0Bug Reporting:=C2=A0support@webdna.us --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe,= E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporti= ng: support@webdna.us -----------------------------------------------------= ---- This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk= @webdna.us Bug Reporting: support@webdna.us --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe,= E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporti= ng: support@webdna.us --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to:=20 archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to:=20 archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us ------=_Part_11212_132354502.1490140349373 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

Not my favorite solution, but it is= working well.
I hate mixing languages in the same site.

Brian Boegershausen





On Tue, Mar 21, 2017 at 7:49 PM -0400, "Stuart T= remain" <webdna@idfk.com.au> wrote:

Yes= , PHP has a nice escape routine.

I should write one for WebDNA as I would use it, at the moment I = just use GREP for a few characters.

Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA
webdna@idfk.com.au






On= 22 Mar 2017, at 00:17, Brian Boegershausen <brian@endeavotech.com> wrote:

Thank stuart. After a few more painful hours of tinkering, i decided to write the upload/= download pages in php.
Works great now. All the escape context is built right in.
Not my favorite option, but why reinvent the wheel.


Brian Boegershausen



From: Stuart Tremain
Sent: Monday, March 20, 10:58 PM
Subject: Re: [WebDNA] Upload file to mysql
To: WebDNA Talk List

http://php.net/manual/= en/mysqli.real-escape-string.php

Character= s encoded are NUL (ASCII 0), \n, \r, \, ', ", and Contro= l-Z.

Kind regards

Stuart Tremain

Pharoah Lane Software

=

AUSTRALIA

webdna@idfk.com.au





On 21 Mar 2017, at 13:51, B= rian Boegershausen <= brian@endeavotech.com> wrote:

You think= i should [url]ize the string?
Then i can look for %0A and things like that.

= Brian Boegershausen




On Mon, Mar 20, 2017 at 10:49 PM -0400,= "Stuart Tremain" <webd= na@idfk.com.au> wrote:


I think that is where your problem lies.

https://dev.mysql.com/doc/refman/5.7/en/string-literals.html

The MySQL manual page for strings says:

\0   An ASCII NUL (0x00) character.

\'   A single quote (=E2=80=9C'=E2=80=9D) character.

\"=   A double quote (=E2=80=9C"=E2=80=9D) character.

\b &n= bsp; A backspace character.

\n   A newline (linefeed) ch= aracter.

\r   A carriage return character.

\t   A tab character.

\Z   ASCII 26 (Control-Z).&n= bsp;

\\   A backslash (=E2=80=9C\=E2=80=9D) character.

\%   A =E2=80=9C%=E2=80=9D character. 

\_   A =E2=80=9C_=E2=80=9D character. 




Kind rega= rds

Stuart Tremain

Pharoah Lane = Software

AUSTRALIA

webdna@idfk.com.au




On 21 Mar 2017, at 13:42, &= lt;brian@endeavotech.co= m> <brian@end= eavotech.com> wrote:

I added the ; into= my convertchars database. Flushed=E2=80=A6 still having an issue.

I think I need a bigger list of escape characters L

 
 
 

From: Stuart Tremain [mailto:webdna@idfk.com.au] 
Sent: Monday, March 20, 2017 9:45 PM
To: WebDNA Talk List <talk@webdna.us>
Subject: Re: [WebDNA] Upload file to mysql

 =

That is a problem w= ith a character causing MySQL to fail.

 

Looking at your conversion db it looks like yo= u have covered everything except for ; (semicolon)

 

There may be something else as wel= l.

 

Kind re= gards

 

Stua= rt Tremain

Pharoah Lane Software

AUSTRALIA

<= p dir=3D"auto" style=3D"text-align: left; margin-top: 25px; margin-bottom: = 25px; font-family: sans-serif; font-size: 11pt; background-color: white;" c= lass=3D"">webdna@idfk.com.= au

 
 
 
 
 
<= p dir=3D"auto" style=3D"text-align: left; margin-top: 25px; margin-bottom: = 25px; font-family: sans-serif; font-size: 11pt; background-color: white;" c= lass=3D"">On 21 Mar 2017, at 12:16, <brian@endeavotech.com> <brian@endeavotech.com> wrote:

 <= br class=3D"webkit-block-placeholder">

ERROR TEXT: You have= an error in your SQL syntax; check the manual that corresponds to your MyS= QL server version for the right syntax to use near ''\%PDF-1.5 \%=EF=BF=BD= =EF=BF=BD=EF=BF=BD=EF=BF=BD 1 0 obj <

 
 

When I look in the errorlog.txt file, the =EF=BF=BD charac= ters are the following symbols.

=C3=A2=C3=A3=C3=8F=C3=93=

 
 

From: St= uart Tremain [mailto:webdn= a@idfk.com.au] 
Sent: Monday, March 20, 2017 9:03 PM
To: WebDNA Talk List <talk@webdna.us>
Subject: Re: [WebDNA] Upload file to mysql

 =

What is the error ?=

 

Kind re= gards

 

Stua= rt Tremain

Pharoah Lane Software

AUSTRALIA

<= p dir=3D"auto" style=3D"text-align: left; margin-top: 25px; margin-bottom: = 25px; font-family: sans-serif; font-size: 11pt; background-color: white;" c= lass=3D"">webdna@idfk.com.= au

 
 
 
 
 
<= blockquote type=3D"cite" class=3D"">

On 21 Mar 2017, at 12:00, Br= ian Boegershausen <b= rian@endeavotech.com> wrote:

 

Mysql error.

 

Brian Boegershausen

 

 

=

On Mon, Mar 20, 2017 at 8:59 PM -0400, "Stuar= t Tremain" <webdna@idfk= ..com.au> wrote:

<= blockquote type=3D"cite" class=3D"">
Brian, when you say it chokes, do you mean that WebDNA stalls or d= o you get a MySQL error message ?

 
 

= Kind regards

 

Stuart Tremain

Pharoah Lane Software

AUST= RALIA

webdna= @idfk.com.au

 
&nbs= p;
 
 
<= div style=3D"text-align: left; margin-top: 25px; margin-bottom: 25px; font-= family: sans-serif; font-size: 11pt; background-color: white;" class=3D"">&= nbsp;
<= blockquote type=3D"cite" class=3D"">

On 21 Mar 2017, at 11:15, <= ;brian@endeavotech.com<= /a>> <brian@endea= votech.com> wrote:

 
<= /div>

Hi Stewart,

I have my content field set to ME= DIUMBLOB which allows for 16mb max files.

So far, I am using = files around 100kb, so I am not reaching the max yet.

 

My query writes all the data fi= elds and uploads .txt files, but once I change to a file like a PDF, it cho= kes.

 

[show= if [referer]^file_manager.dna]

[FormVariables]

= [showif [name]^filename]

      =           [text show=3DF]TheFi= leNM=3D[Middle StartAfter=3Dfilename=3D"&EndBefore=3D"][name][/middle][= /text]

[/showif]

[showif [name]^CPK]

           &nb= sp;    [text show=3DF]CPK=3D[value][/text]

[/s= howif]

[showif [name]^JPK]

   &n= bsp;            [tex= t show=3DF]JPK=3D[value][/text]

[/showif]

[/For= mVariables]

 

[hideif [TheFileNM]=3D]

[hideif [CPK]=3D]

[hi= deif [JPK]=3D]

[FormVariables]

[showif [name]^"= thefile"]

[SQLExecute conn_ref=3DTheBlueBiller&result_var= =3DUPLOAD_INS]

INSERT INTO UPLOAD

(FILE_ID, COM= PANY_ID, CLIENT_ID, JOB_ID, NAME, CONTENT, ROW_ADDED_DTTM)

VA= LUES ('', '[LOGIN_COMPANY_ID]', '[CPK]', '[JPK]', '[TheFileNM]', '[convertc= hars db=3Ddatabases/upload.db][value][/convertchars]', '[date %Y-%m-%d %H:%= M:%S]')

[/SQLExecute]

[/showif]

[= /FormVariables]

[/hideif]

[/hideif]

[/hideif]

 

[!]=3D=3D=3D=3D=3D=3D=3D=3DUPLOAD.DB FILE------------[/!]

FROM   TO

'     &nbs= p;         \'

" =              \"=

\          = ;    \\

%      &= nbsp;     \%

 

From: Stuart Tremain [mailto:webdna@idfk.com.au]&nb= sp;
Sent: Monday, March 20, 2017 6:43 PM
To: WebDNA Talk List <talk@webdna.us>
Subject: Re: [WebDNA] Upload file to mysql

 =

Hi Brian

 <= br class=3D"webkit-block-placeholder">

I have not done that= , but providing your MySQL field is LONGBLOB all should work. 

&nbs= p;

Also to be able t= o insert images that are bigger than 1MB you have to increase the max_allow= ed_packed option in the server configuration file.

 

I use Navicat to write all my quer= ies and then copy & paset the query into my WebDNA doc. Navicat makes w= riting & debugging fast.

 

Kind regards

 

Stuart Tremain

Pharoah Lane Software

AUSTRALIA

webdna@idfk.com.au

 
 
 
 
 
<= blockquote type=3D"cite" class=3D"">

On 21 Mar 2017, at 07:55, Brian Boegershausen <brian@endeavotech.com> wrote:

=
=  

Anyone succes= sfully upload a file to a mysql db?
I can upload a text file but that is it.
Jpg and gif fail.

Unbuntu 14
Webdna 8.2
Mysql 5.5

 

= Brian Boegershausen

 
<= div style=3D"text-align: left; margin-top: 25px; margin-bottom: 25px; font-= family: sans-serif; font-size: 11pt; background-color: white;" class=3D"">&= nbsp;

--------------= ------------------------------------------- This message is sent to you bec= ause you are subscribed to the mailing list . To unsubscribe, E-mail to: ar= chives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: <= a href=3D"mailto:support@webdna.us" class=3D"">support@webdna.us

<= blockquote type=3D"cite" class=3D"">


 

 

Virus-free. 
www.avg.com

--------------------------------------------------------- This mess= age is sent to you because you are subscribed to the mailing list . To unsu= bscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us = ;Bug Reporting: suppor= t@webdna.us

---------------------------------------------= ------------ This message is sent to you because you are subscribed to the = mailing list . To unsubscribe, E-mail to: archives: http://mail.webdn= a.us/list/talk@webdna.us Bug Reporting: support@webdna.us

<= blockquote type=3D"cite" class=3D"">

 

------------------------------------------------------= --- This message is sent to you because you are subscribed to the mailing l= ist . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdn= a.us Bug Reporting: support@webdna.us

<= blockquote type=3D"cite" class=3D"">


--------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe,= E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Rep= orting: support@webdna= ..us

<= p dir=3D"auto" style=3D"text-align: left; margin-top: 25px; margin-bottom: = 25px; font-family: sans-serif; font-size: 11pt; background-color: white;" c= lass=3D"">
 

 

Vir= us-free. 

www.avg.com

--------------------------= ------------------------------- This message is sent to you because you are= subscribed to the mailing list . To unsubscribe, E-mail to: archives: = ;http://ma= il.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us

----= ----------------------------------------------------- This message is sent = to you because you are subscribed to the mailing list . To unsubscribe= , E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us B= ug Reporting: support@= webdna.us


 

 

Virus-free. 
www= ..avg.com

-------------------= -------------------------------------- This message is sent to you because = you are subscribed to the mailing list . To unsubscribe, E-mail to: archive= s: ht= tp://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This messag= e is sent to you because you are subscribed to the mailing list . To u= nsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us<= /a> Bug Reporting: support@webdna.us


------= --------------------------------------------------- This message is sent to= you because you are subscribed to the mailing list . To unsubscribe, E-mai= l to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us ------------= --------------------------------------------- This message is sent to you b= ecause you are subscribed to the mailing list . To unsubscribe, E-mail to: = archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us
--------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe,= E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webd= na.us
<= br class=3D""> --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us ------=_Part_11212_132354502.1490140349373-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Upload file to mysql (Brian Boegershausen 2017)
  2. Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017)
  3. Re: [WebDNA] Upload file to mysql (Brian Boegershausen 2017)
  4. Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017)
  5. Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017)
  6. Re: [WebDNA] Upload file to mysql (Brian Boegershausen 2017)
  7. Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017)
  8. RE: [WebDNA] Upload file to mysql ( 2017)
  9. Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017)
  10. RE: [WebDNA] Upload file to mysql ( 2017)
  11. Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017)
  12. Re: [WebDNA] Upload file to mysql (Brian Boegershausen 2017)
  13. Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017)
  14. RE: [WebDNA] Upload file to mysql ( 2017)
  15. [BULK] Re: [WebDNA] Upload file to mysql ("WJ Starck, DDS" 2017)
  16. Re: [WebDNA] Upload file to mysql (Stuart Tremain 2017)
  17. [WebDNA] Upload file to mysql (Brian Boegershausen 2017)
1084 ------=_Part_11212_132354502.1490140349373 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Not my favorite solution, but it is working well. I hate mixing languages in the same site. Brian Boegershausen On Tue, Mar 21, 2017 at 7:49 PM -0400, "Stuart Tremain" wrote: Yes, PHP has a nice escape routine. I should write one for WebDNA as I would use it, at the moment I just use G= REP for a few characters. Kind regards Stuart TremainPharoah Lane SoftwareAUSTRALIAwebdna@idfk.com.au On 22 Mar 2017, at 00:17, Brian Boegershausen wrote= : Thank stuart. After a few more painful hours of tinkering, i decided to write the upload/= download pages in php.=20 Works great now. All the escape context is built right in. Not my favorite option, but why reinvent the wheel. Brian Boegershausen From: Stuart Tremain Sent: Monday, March 20, 10:58 PM Subject: Re: [WebDNA] Upload file to mysql To: WebDNA Talk List http://php.net/manual/en/mysqli.real-escape-string.php Characters encoded are=C2=A0NUL (ASCII 0),=20 , \r, \, ', ", and Control-Z. Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au On 21 Mar 2017, at 13:51, Brian Boegershausen wrote= : You think i should [url]ize the string? Then i can look for %0A and things like that. Brian Boegershausen On Mon, Mar 20, 2017 at 10:49 PM -0400, "Stuart Tremain" wrote: I think that is where your problem lies. https://dev.mysql.com/doc/refman/5.7/en/string-literals.html The MySQL manual page for strings says: \0 =C2=A0 An ASCII NUL (0x00) character. \' =C2=A0 A single quote (=E2=80=9C'=E2=80=9D) character. \" =C2=A0 A double quote (=E2=80=9C"=E2=80=9D) character. \b =C2=A0 A backspace character. =C2=A0 A newline (linefeed) character. \r =C2=A0 A carriage return character. \t =C2=A0 A tab character. \Z =C2=A0 ASCII 26 (Control-Z).=C2=A0 \\ =C2=A0 A backslash (=E2=80=9C\=E2=80=9D) character. \% =C2=A0 A =E2=80=9C%=E2=80=9D character.=C2=A0 \_ =C2=A0 A =E2=80=9C_=E2=80=9D character.=C2=A0 Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au On 21 Mar 2017, at 13:42, w= rote: I added the ; into my convertchars database. Flushed=E2=80=A6 still having = an issue. I think I need a bigger list of escape characters=C2=A0L=C2=A0 =C2=A0 =C2=A0 From:=C2=A0Stuart Tremain [mailto:webdna@idfk.com.au]=C2=A0 Sent:=C2=A0Monday, March 20, 2017 9:45 PM To:=C2=A0WebDNA Talk List Subject:=C2=A0Re: [WebDNA] Upload file to mysql=C2=A0 That is a problem with a character causing MySQL to fail.=C2=A0 Looking at your conversion db it looks like you have covered everything exc= ept for ; (semicolon)=C2=A0 There may be something else as well.=C2=A0 Kind regards=C2=A0 Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 On 21 Mar 2017, at 12:16, w= rote:=C2=A0 ERROR TEXT: You have an error in your SQL syntax; check the manual that cor= responds to your MySQL server version for the right syntax to use near ''\%= PDF-1.5 \%=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=C2=A01 0 obj <=C2=A0 =C2=A0 When I look in the errorlog.txt file, the=C2=A0=EF=BF=BD characters=C2=A0ar= e the following symbols. =C3=A2=C3=A3=C3=8F=C3=93=C2=A0 =C2=A0 From:=C2=A0Stuart Tremain [mailto:webdna@idfk.com.au]=C2=A0 Sent:=C2=A0Monday, March 20, 2017 9:03 PM To:=C2=A0WebDNA Talk List Subject:=C2=A0Re: [WebDNA] Upload file to mysql=C2=A0 What is the error ?=C2=A0 Kind regards=C2=A0 Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 On 21 Mar 2017, at 12:00, Brian Boegershausen wrote= :=C2=A0 Mysql error.=C2=A0 Brian Boegershausen=C2=A0 =C2=A0 On Mon, Mar 20, 2017 at 8:59 PM -0400, "Stuart Tremain" wrote: Brian, when you say it chokes, do you mean that WebDNA stalls or do you get= a MySQL error message ?=C2=A0 =C2=A0 Kind regards=C2=A0 Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 On 21 Mar 2017, at 11:15, w= rote:=C2=A0 Hi Stewart, I have my content field set to MEDIUMBLOB which allows for 16mb max files. So far, I am using files around 100kb, so I am not reaching the max yet.=C2= =A0 My query writes all the data fields and uploads .txt files, but once I chan= ge to a file like a PDF, it chokes.=C2=A0 [showif [referer]^file_manager.dna] [formvariables] [showif [name]^filename] =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 [text show=3DF]TheFileNM=3D[Middle StartAfter=3Dfilename=3D= "&EndBefore=3D"][name][/middle][/text] [/showif] [showif [name]^CPK] =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 [text show=3DF]CPK=3D[value][/text] [/showif] [showif [name]^JPK] =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 [text show=3DF]JPK=3D[value][/text] [/showif] [/FormVariables]=C2=A0 [hideif [TheFileNM]=3D] [hideif [CPK]=3D] [hideif [JPK]=3D] [formvariables] [showif [name]^"thefile"] [SQLExecute conn_ref=3DTheBlueBiller&result_var=3DUPLOAD_INS] INSERT INTO UPLOAD (FILE_ID, COMPANY_ID, CLIENT_ID, JOB_ID, NAME, CONTENT, ROW_ADDED_DTTM) VALUES ('', '[LOGIN_COMPANY_ID]', '[CPK]', '[JPK]', '[TheFileNM]', '[conver= tchars db=3Ddatabases/upload.db][value][/convertchars]', '[date %Y-%m-%d %H= :%M:%S]') [/SQLExecute] [/showif] [/FormVariables] [/hideif] [/hideif] [/hideif]=C2=A0 [!]=3D=3D=3D=3D=3D=3D=3D=3DUPLOAD.DB FILE------------[/!] FROM=C2=A0=C2=A0 TO '=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 \' "=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 \" \=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 \\ %=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 \%=C2= =A0 From:=C2=A0Stuart Tremain [mailto:webdna@idfk.com.au]=C2=A0 Sent:=C2=A0Monday, March 20, 2017 6:43 PM To:=C2=A0WebDNA Talk List Subject:=C2=A0Re: [WebDNA] Upload file to mysql=C2=A0 Hi Brian=C2=A0 I have not done that, but providing your MySQL field is LONGBLOB all should= work.=C2=A0=C2=A0 Also to be able to insert images that are bigger than 1MB you have to incre= ase the max_allowed_packed option in the server configuration file.=C2=A0 I use Navicat to write all my queries and then copy & paset the query into = my WebDNA doc. Navicat makes writing & debugging fast.=C2=A0 Kind regards=C2=A0 Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 On 21 Mar 2017, at 07:55, Brian Boegershausen wrote= :=C2=A0 Anyone successfully upload a file to a mysql db? I can upload a text file but that is it. Jpg and gif fail. Unbuntu 14 Webdna 8.2 Mysql 5.5=C2=A0 Brian Boegershausen=C2=A0 =C2=A0 --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe,= E-mail to: archives:=C2=A0http://mail.webdna.us/list/talk@webdna.us=C2=A0B= ug Reporting:=C2=A0support@webdna.us =C2=A0=C2=A0 Virus-free.=C2=A0www.avg.com --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe,= E-mail to: archives:=C2=A0http://mail.webdna.us/list/talk@webdna.us=C2=A0B= ug Reporting:=C2=A0support@webdna.us --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list=C2=A0. To unsubsc= ribe, E-mail to:=C2=A0archives:=C2=A0http://mail.webdna.us/list/talk@webdna= ..us=C2=A0Bug Reporting:=C2=A0support@webdna.us =C2=A0 --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe,= E-mail to: archives:=C2=A0http://mail.webdna.us/list/talk@webdna.us=C2=A0B= ug Reporting:=C2=A0support@webdna.us --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe,= E-mail to: archives:=C2=A0http://mail.webdna.us/list/talk@webdna.us=C2=A0B= ug Reporting:=C2=A0support@webdna.us =C2=A0=C2=A0 Virus-free.=C2=A0www.avg.com --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe,= E-mail to: archives:=C2=A0http://mail.webdna.us/list/talk@webdna.us=C2=A0B= ug Reporting:=C2=A0support@webdna.us --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list=C2=A0. To unsubsc= ribe, E-mail to:=C2=A0archives:=C2=A0http://mail.webdna.us/list/talk@webdna= ..us=C2=A0Bug Reporting:=C2=A0support@webdna.us =C2=A0=C2=A0 Virus-free.=C2=A0www.avg.com --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe,= E-mail to: archives:=C2=A0http://mail.webdna.us/list/talk@webdna.us=C2=A0B= ug Reporting:=C2=A0support@webdna.us --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list=C2=A0. To unsubsc= ribe, E-mail to:=C2=A0archives:=C2=A0http://mail.webdna.us/list/talk@webdna= ..us=C2=A0Bug Reporting:=C2=A0support@webdna.us --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe,= E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporti= ng: support@webdna.us -----------------------------------------------------= ---- This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk= @webdna.us Bug Reporting: support@webdna.us --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe,= E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporti= ng: support@webdna.us --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to:=20 archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to:=20 archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us ------=_Part_11212_132354502.1490140349373 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

Not my favorite solution, but it is= working well.
I hate mixing languages in the same site.

Brian Boegershausen





On Tue, Mar 21, 2017 at 7:49 PM -0400, "Stuart T= remain" <webdna@idfk.com.au> wrote:

Yes= , PHP has a nice escape routine.

I should write one for WebDNA as I would use it, at the moment I = just use GREP for a few characters.

Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA
webdna@idfk.com.au






On= 22 Mar 2017, at 00:17, Brian Boegershausen <brian@endeavotech.com> wrote:

Thank stuart. After a few more painful hours of tinkering, i decided to write the upload/= download pages in php.
Works great now. All the escape context is built right in.
Not my favorite option, but why reinvent the wheel.


Brian Boegershausen



From: Stuart Tremain
Sent: Monday, March 20, 10:58 PM
Subject: Re: [WebDNA] Upload file to mysql
To: WebDNA Talk List

http://php.net/manual/= en/mysqli.real-escape-string.php

Character= s encoded are NUL (ASCII 0), \n, \r, \, ', ", and Contro= l-Z.

Kind regards

Stuart Tremain

Pharoah Lane Software

=

AUSTRALIA

webdna@idfk.com.au





On 21 Mar 2017, at 13:51, B= rian Boegershausen <= brian@endeavotech.com> wrote:

You think= i should [url]ize the string?
Then i can look for %0A and things like that.

= Brian Boegershausen




On Mon, Mar 20, 2017 at 10:49 PM -0400,= "Stuart Tremain" <webd= na@idfk.com.au> wrote:


I think that is where your problem lies.

https://dev.mysql.com/doc/refman/5.7/en/string-literals.html

The MySQL manual page for strings says:

\0   An ASCII NUL (0x00) character.

\'   A single quote (=E2=80=9C'=E2=80=9D) character.

\"=   A double quote (=E2=80=9C"=E2=80=9D) character.

\b &n= bsp; A backspace character.

\n   A newline (linefeed) ch= aracter.

\r   A carriage return character.

\t   A tab character.

\Z   ASCII 26 (Control-Z).&n= bsp;

\\   A backslash (=E2=80=9C\=E2=80=9D) character.

\%   A =E2=80=9C%=E2=80=9D character. 

\_   A =E2=80=9C_=E2=80=9D character. 




Kind rega= rds

Stuart Tremain

Pharoah Lane = Software

AUSTRALIA

webdna@idfk.com.au




On 21 Mar 2017, at 13:42, &= lt;brian@endeavotech.co= m> <brian@end= eavotech.com> wrote:

I added the ; into= my convertchars database. Flushed=E2=80=A6 still having an issue.

I think I need a bigger list of escape characters L

 
 
 

From: Stuart Tremain [mailto:webdna@idfk.com.au] 
Sent: Monday, March 20, 2017 9:45 PM
To: WebDNA Talk List <talk@webdna.us>
Subject: Re: [WebDNA] Upload file to mysql

 =

That is a problem w= ith a character causing MySQL to fail.

 

Looking at your conversion db it looks like yo= u have covered everything except for ; (semicolon)

 

There may be something else as wel= l.

 

Kind re= gards

 

Stua= rt Tremain

Pharoah Lane Software

AUSTRALIA

<= p dir=3D"auto" style=3D"text-align: left; margin-top: 25px; margin-bottom: = 25px; font-family: sans-serif; font-size: 11pt; background-color: white;" c= lass=3D"">webdna@idfk.com.= au

 
 
 
 
 
<= p dir=3D"auto" style=3D"text-align: left; margin-top: 25px; margin-bottom: = 25px; font-family: sans-serif; font-size: 11pt; background-color: white;" c= lass=3D"">On 21 Mar 2017, at 12:16, <brian@endeavotech.com> <brian@endeavotech.com> wrote:

 <= br class=3D"webkit-block-placeholder">

ERROR TEXT: You have= an error in your SQL syntax; check the manual that corresponds to your MyS= QL server version for the right syntax to use near ''\%PDF-1.5 \%=EF=BF=BD= =EF=BF=BD=EF=BF=BD=EF=BF=BD 1 0 obj <

 
 

When I look in the errorlog.txt file, the =EF=BF=BD charac= ters are the following symbols.

=C3=A2=C3=A3=C3=8F=C3=93=

 
 

From: St= uart Tremain [mailto:webdn= a@idfk.com.au] 
Sent: Monday, March 20, 2017 9:03 PM
To: WebDNA Talk List <talk@webdna.us>
Subject: Re: [WebDNA] Upload file to mysql

 =

What is the error ?=

 

Kind re= gards

 

Stua= rt Tremain

Pharoah Lane Software

AUSTRALIA

<= p dir=3D"auto" style=3D"text-align: left; margin-top: 25px; margin-bottom: = 25px; font-family: sans-serif; font-size: 11pt; background-color: white;" c= lass=3D"">webdna@idfk.com.= au

 
 
 
 
 
<= blockquote type=3D"cite" class=3D"">

On 21 Mar 2017, at 12:00, Br= ian Boegershausen <b= rian@endeavotech.com> wrote:

 

Mysql error.

 

Brian Boegershausen

 

 

=

On Mon, Mar 20, 2017 at 8:59 PM -0400, "Stuar= t Tremain" <webdna@idfk= ..com.au> wrote:

<= blockquote type=3D"cite" class=3D"">
Brian, when you say it chokes, do you mean that WebDNA stalls or d= o you get a MySQL error message ?

 
 

= Kind regards

 

Stuart Tremain

Pharoah Lane Software

AUST= RALIA

webdna= @idfk.com.au

 
&nbs= p;
 
 
<= div style=3D"text-align: left; margin-top: 25px; margin-bottom: 25px; font-= family: sans-serif; font-size: 11pt; background-color: white;" class=3D"">&= nbsp;
<= blockquote type=3D"cite" class=3D"">

On 21 Mar 2017, at 11:15, <= ;brian@endeavotech.com<= /a>> <brian@endea= votech.com> wrote:

 
<= /div>

Hi Stewart,

I have my content field set to ME= DIUMBLOB which allows for 16mb max files.

So far, I am using = files around 100kb, so I am not reaching the max yet.

 

My query writes all the data fi= elds and uploads .txt files, but once I change to a file like a PDF, it cho= kes.

 

[show= if [referer]^file_manager.dna]

[formvariables]

= [showif [name]^filename]

      =           [text show=3DF]TheFi= leNM=3D[Middle StartAfter=3Dfilename=3D"&EndBefore=3D"][name][/middle][= /text]

[/showif]

[showif [name]^CPK]

           &nb= sp;    [text show=3DF]CPK=3D[value][/text]

[/s= howif]

[showif [name]^JPK]

   &n= bsp;            [tex= t show=3DF]JPK=3D[value][/text]

[/showif]

[/For= mVariables]

 

[hideif [TheFileNM]=3D]

[hideif [CPK]=3D]

[hi= deif [JPK]=3D]

[formvariables]

[showif [name]^"= thefile"]

[SQLExecute conn_ref=3DTheBlueBiller&result_var= =3DUPLOAD_INS]

INSERT INTO UPLOAD

(FILE_ID, COM= PANY_ID, CLIENT_ID, JOB_ID, NAME, CONTENT, ROW_ADDED_DTTM)

VA= LUES ('', '[LOGIN_COMPANY_ID]', '[CPK]', '[JPK]', '[TheFileNM]', '[convertc= hars db=3Ddatabases/upload.db][value][/convertchars]', '[date %Y-%m-%d %H:%= M:%S]')

[/SQLExecute]

[/showif]

[= /FormVariables]

[/hideif]

[/hideif]

[/hideif]

 

[!]=3D=3D=3D=3D=3D=3D=3D=3DUPLOAD.DB FILE------------[/!]

FROM   TO

'     &nbs= p;         \'

" =              \"=

\          = ;    \\

%      &= nbsp;     \%

 

From: Stuart Tremain [mailto:webdna@idfk.com.au]&nb= sp;
Sent: Monday, March 20, 2017 6:43 PM
To: WebDNA Talk List <talk@webdna.us>
Subject: Re: [WebDNA] Upload file to mysql

 =

Hi Brian

 <= br class=3D"webkit-block-placeholder">

I have not done that= , but providing your MySQL field is LONGBLOB all should work. 

&nbs= p;

Also to be able t= o insert images that are bigger than 1MB you have to increase the max_allow= ed_packed option in the server configuration file.

 

I use Navicat to write all my quer= ies and then copy & paset the query into my WebDNA doc. Navicat makes w= riting & debugging fast.

 

Kind regards

 

Stuart Tremain

Pharoah Lane Software

AUSTRALIA

webdna@idfk.com.au

 
 
 
 
 
<= blockquote type=3D"cite" class=3D"">

On 21 Mar 2017, at 07:55, Brian Boegershausen <brian@endeavotech.com> wrote:

=
=  

Anyone succes= sfully upload a file to a mysql db?
I can upload a text file but that is it.
Jpg and gif fail.

Unbuntu 14
Webdna 8.2
Mysql 5.5

 

= Brian Boegershausen

 
<= div style=3D"text-align: left; margin-top: 25px; margin-bottom: 25px; font-= family: sans-serif; font-size: 11pt; background-color: white;" class=3D"">&= nbsp;

--------------= ------------------------------------------- This message is sent to you bec= ause you are subscribed to the mailing list . To unsubscribe, E-mail to: ar= chives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: <= a href=3D"mailto:support@webdna.us" class=3D"">support@webdna.us

<= blockquote type=3D"cite" class=3D"">


 

 

Virus-free. 
www.avg.com

--------------------------------------------------------- This mess= age is sent to you because you are subscribed to the mailing list . To unsu= bscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us = ;Bug Reporting: suppor= t@webdna.us

---------------------------------------------= ------------ This message is sent to you because you are subscribed to the = mailing list . To unsubscribe, E-mail to: archives: http://mail.webdn= a.us/list/talk@webdna.us Bug Reporting: support@webdna.us

<= blockquote type=3D"cite" class=3D"">

 

------------------------------------------------------= --- This message is sent to you because you are subscribed to the mailing l= ist . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdn= a.us Bug Reporting: support@webdna.us

<= blockquote type=3D"cite" class=3D"">


--------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe,= E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Rep= orting: support@webdna= ..us

<= p dir=3D"auto" style=3D"text-align: left; margin-top: 25px; margin-bottom: = 25px; font-family: sans-serif; font-size: 11pt; background-color: white;" c= lass=3D"">
 

 

Vir= us-free. 

www.avg.com

--------------------------= ------------------------------- This message is sent to you because you are= subscribed to the mailing list . To unsubscribe, E-mail to: archives: = ;http://ma= il.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us

----= ----------------------------------------------------- This message is sent = to you because you are subscribed to the mailing list . To unsubscribe= , E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us B= ug Reporting: support@= webdna.us


 

 

Virus-free. 
www= ..avg.com

-------------------= -------------------------------------- This message is sent to you because = you are subscribed to the mailing list . To unsubscribe, E-mail to: archive= s: ht= tp://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This messag= e is sent to you because you are subscribed to the mailing list . To u= nsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us<= /a> Bug Reporting: support@webdna.us


------= --------------------------------------------------- This message is sent to= you because you are subscribed to the mailing list . To unsubscribe, E-mai= l to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us ------------= --------------------------------------------- This message is sent to you b= ecause you are subscribed to the mailing list . To unsubscribe, E-mail to: = archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us
--------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe,= E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webd= na.us<= br class=3D""> --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us ------=_Part_11212_132354502.1490140349373-- . Brian Boegershausen

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Email Formatting (1998) Superfilous Characters (1998) WebCat2b12 - New features for 1.6 users ... (1997) Sort Order on a page search (1997) [WebDNA] Installing WebDNA 7 on OSX Mavericks Server - Instructions (2014) Setting up shop (1997) WebCommerce: Folder organization ? (1997) New Plug-in and Type 11 errors (1997) Search in 2 or more catalogs (1997) Support ?? (1997) Dynamic Pop up menu? (1997) Quit revisited (1997) Database Updates (1997) Sending Mail Confirmation (2002) Normalizing Dates and Phone numbers (2000) [WebDNA] Receive JSON POST (2019) Download Question (1997) [shownext] and sort (1998) Bug? (1997) WebCat2b15MacPlugin - showing [math] (1997)