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:

[ShowNext] feature in 2.0 (1997) process out of control....... (2002) Plugin or CGI or both (1997) M$loth messes with our sites (again) 2004/02/03 (2004) 2.1b3 --> way slow (1997) WebCatalog can't find database (1997) remotely add + sign (1997) Encrypt Problems (2000) Webdna 5.0 reference documentation (2003) passing cart value (2003) Purchase command error problem (1997) Multiple catalog databases and showcart (1997) Execute Applescript (1997) (2000) Max Record length restated as maybe bug (1997) [Webcat 2]Next (1997) select multiple (1997) [WebDNA] mod_WebDNA_apache2.2.so: mach-0, but wrong architecture (2010) RE: is sku a REQUIRED field on NT (1997) %@#*& back button!!! (1999)