2017

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]

          &nb=sp;     [text show=3DF]TheFileNM=3D[Middle =StartAfter=3Dfilename=3D"&EndBefore=3D"][name][/middle][/text]

[/showif]

[showif [name]^CPK]

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

[/showif]

[showif [name]^JPK]

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

[/showif]

[/FormVariables]

 

[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]', '[convertchars =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

'          &n=bsp;    \'

"          &n=bsp;   \"

\          &n=bsp;   \\

%          &n=bsp; \%

 

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 tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us