Re: [WebDNA] Upload file to mysql

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113487
interpreted = N
texte = 1082 ------=_Part_9689_751314579.1490102252506 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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 ------=_Part_9689_751314579.1490102252506 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit

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

Characters encoded are NUL (ASCII 0), \n, \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 <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" <webdna@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 (“'”) character.

\"   A double quote (“"”) character.

\b   A backspace character.

\n   A newline (linefeed) character.

\r   A carriage return character.

\t   A tab character.

\Z   ASCII 26 (Control-Z). 

\\   A backslash (“\”) character.

\%   A “%” character. 

\_   A “_” character. 




Kind regards

Stuart Tremain

Pharoah Lane Software

AUSTRALIA

webdna@idfk.com.au





On 21 Mar 2017, at 13:42, <brian@endeavotech.com> <brian@endeavotech.com> wrote:

I added the ; into my convertchars database. Flushed… 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 with a character causing MySQL to fail.

 

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

 

There may be something else as well.

 

Kind regards

 

Stuart Tremain

Pharoah Lane Software

AUSTRALIA

webdna@idfk.com.au

 

 

 

 

 

On 21 Mar 2017, at 12:16, <brian@endeavotech.com> <brian@endeavotech.com> wrote:

 

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

 

 

When I look in the errorlog.txt file, the � characters are the following symbols.

âãÏÓ

 

 

From: Stuart Tremain [mailto:webdna@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 regards

 

Stuart Tremain

Pharoah Lane Software

AUSTRALIA

webdna@idfk.com.au

 

 

 

 

 

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

 

Mysql error.

 

Brian Boegershausen

 

 


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

Brian, when you say it chokes, do you mean that WebDNA stalls or do you get a MySQL error message ?

 

 

Kind regards

 

Stuart Tremain

Pharoah Lane Software

AUSTRALIA

webdna@idfk.com.au

 

 

 

 

 

On 21 Mar 2017, at 11:15, <brian@endeavotech.com> <brian@endeavotech.com> wrote:

 

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.

 

My query writes all the data fields and uploads .txt files, but once I change to a file like a PDF, it chokes.

 

[showif [referer]^file_manager.dna]

[FormVariables]

[showif [name]^filename]

                [text show=F]TheFileNM=[Middle StartAfter=filename="&EndBefore="][name][/middle][/text]

[/showif]

[showif [name]^CPK]

                [text show=F]CPK=[value][/text]

[/showif]

[showif [name]^JPK]

                [text show=F]JPK=[value][/text]

[/showif]

[/FormVariables]

 

[hideif [TheFileNM]=]

[hideif [CPK]=]

[hideif [JPK]=]

[FormVariables]

[showif [name]^"thefile"]

[SQLExecute conn_ref=TheBlueBiller&result_var=UPLOAD_INS]

INSERT INTO UPLOAD

(FILE_ID, COMPANY_ID, CLIENT_ID, JOB_ID, NAME, CONTENT, ROW_ADDED_DTTM)

VALUES ('', '[LOGIN_COMPANY_ID]', '[CPK]', '[JPK]', '[TheFileNM]', '[convertchars db=databases/upload.db][value][/convertchars]', '[date %Y-%m-%d %H:%M:%S]')

[/SQLExecute]

[/showif]

[/FormVariables]

[/hideif]

[/hideif]

[/hideif]

 

[!]========UPLOAD.DB FILE------------[/!]

FROM   TO

'               \'

"              \"

\              \\

%            \%

 

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

 

Hi Brian

 

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

 

Also to be able to insert images that are bigger than 1MB you have to increase the max_allowed_packed option in the server configuration file.

 

I use Navicat to write all my queries and then copy & paset the query into my WebDNA doc. Navicat makes writing & debugging fast.

 

Kind regards

 

Stuart Tremain

Pharoah Lane Software

AUSTRALIA

webdna@idfk.com.au

 

 

 

 

 

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

 

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

 

Brian Boegershausen

 

 

--------------------------------------------------------- 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


 

 

Virus-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://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


 

--------------------------------------------------------- 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


 

 

Virus-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://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


 

 

Virus-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://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

--------------------------------------------------------- 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
--------------------------------------------------------- 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_9689_751314579.1490102252506-- . 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)
1082 ------=_Part_9689_751314579.1490102252506 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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 ------=_Part_9689_751314579.1490102252506 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit

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

Characters encoded are NUL (ASCII 0), \n, \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 <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" <webdna@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 (“'”) character.

\"   A double quote (“"”) character.

\b   A backspace character.

\n   A newline (linefeed) character.

\r   A carriage return character.

\t   A tab character.

\Z   ASCII 26 (Control-Z). 

\\   A backslash (“\”) character.

\%   A “%” character. 

\_   A “_” character. 




Kind regards

Stuart Tremain

Pharoah Lane Software

AUSTRALIA

webdna@idfk.com.au





On 21 Mar 2017, at 13:42, <brian@endeavotech.com> <brian@endeavotech.com> wrote:

I added the ; into my convertchars database. Flushed… 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 with a character causing MySQL to fail.

 

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

 

There may be something else as well.

 

Kind regards

 

Stuart Tremain

Pharoah Lane Software

AUSTRALIA

webdna@idfk.com.au

 

 

 

 

 

On 21 Mar 2017, at 12:16, <brian@endeavotech.com> <brian@endeavotech.com> wrote:

 

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

 

 

When I look in the errorlog.txt file, the � characters are the following symbols.

âãÏÓ

 

 

From: Stuart Tremain [mailto:webdna@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 regards

 

Stuart Tremain

Pharoah Lane Software

AUSTRALIA

webdna@idfk.com.au

 

 

 

 

 

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

 

Mysql error.

 

Brian Boegershausen

 

 


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

Brian, when you say it chokes, do you mean that WebDNA stalls or do you get a MySQL error message ?

 

 

Kind regards

 

Stuart Tremain

Pharoah Lane Software

AUSTRALIA

webdna@idfk.com.au

 

 

 

 

 

On 21 Mar 2017, at 11:15, <brian@endeavotech.com> <brian@endeavotech.com> wrote:

 

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.

 

My query writes all the data fields and uploads .txt files, but once I change to a file like a PDF, it chokes.

 

[showif [referer]^file_manager.dna]

[formvariables]

[showif [name]^filename]

                [text show=F]TheFileNM=[Middle StartAfter=filename="&EndBefore="][name][/middle][/text]

[/showif]

[showif [name]^CPK]

                [text show=F]CPK=[value][/text]

[/showif]

[showif [name]^JPK]

                [text show=F]JPK=[value][/text]

[/showif]

[/FormVariables]

 

[hideif [TheFileNM]=]

[hideif [CPK]=]

[hideif [JPK]=]

[formvariables]

[showif [name]^"thefile"]

[SQLExecute conn_ref=TheBlueBiller&result_var=UPLOAD_INS]

INSERT INTO UPLOAD

(FILE_ID, COMPANY_ID, CLIENT_ID, JOB_ID, NAME, CONTENT, ROW_ADDED_DTTM)

VALUES ('', '[LOGIN_COMPANY_ID]', '[CPK]', '[JPK]', '[TheFileNM]', '[convertchars db=databases/upload.db][value][/convertchars]', '[date %Y-%m-%d %H:%M:%S]')

[/SQLExecute]

[/showif]

[/FormVariables]

[/hideif]

[/hideif]

[/hideif]

 

[!]========UPLOAD.DB FILE------------[/!]

FROM   TO

'               \'

"              \"

\              \\

%            \%

 

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

 

Hi Brian

 

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

 

Also to be able to insert images that are bigger than 1MB you have to increase the max_allowed_packed option in the server configuration file.

 

I use Navicat to write all my queries and then copy & paset the query into my WebDNA doc. Navicat makes writing & debugging fast.

 

Kind regards

 

Stuart Tremain

Pharoah Lane Software

AUSTRALIA

webdna@idfk.com.au

 

 

 

 

 

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

 

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

 

Brian Boegershausen

 

 

--------------------------------------------------------- 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


 

 

Virus-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://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


 

--------------------------------------------------------- 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


 

 

Virus-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://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


 

 

Virus-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://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

--------------------------------------------------------- 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
--------------------------------------------------------- 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_9689_751314579.1490102252506-- . 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:

WC2b12: Yes, Formulas.db is for real (1997) Thanks Grant (1997) WebCat2b15MacPlugin - showing [math] (1997) HTML encoding in URLs (1997) A little syntax help (1997) Overridding E-Mailer (1998) minimalist shopping cart. (1997) Scope of variables in multi include files (2000) eMail volume (2000) Exclamation point (1997) Cancel Subscription (1996) [WebDNA] Small Parsing Problem (2009) Country & Ship-to address & other fields ? (1997) Re:2nd WebCatalog2 Feature Request (1996) Forms Search Questions (1997) Search returns all, not 20 (1997) Can you do this??? and other stuff (1997) Integration? (1999) ShowNext Command (1997) FEW QUESTIONS (1997)