Loading...
 
Architecture / Installation

Architecture / Installation


uploading files error

posts: 27

when I upload a file which is bigger than 1M to file galleries,I got an error like
this "Warning: mysql error: MySQL server has gone away in query:
insert into `tiki_files`(`galleryId`,`name`,`description`,`filename`,`filesize`,`filetype`,`data`,`user`,`created`,`downloads`,`path`,`hash`) values(?,?,?,?,?,?,?,?,?,?,?,?)
in /home/tikiwiki-1.8.2/lib/tikidblib.php on line 133
Values:
Array ( 0 => 2 1 => sdafsdf 2 => dfdsfsdfd 3 => ????????.mp3 4 => 3414308 5 => audio/mpeg 6 => l l l l l l l l l ????????????????f???99????????9????)C?????]?5y_6????cX".

if the files is smaller than 1M,it's fine.
why this happen?

I set upload_max to be 20M in php.ini.

thanks.

posts: 2881 United Kingdom

Mysql has a limit of 1Mb for storage.

You can change it my modifing the my.cnf file. Personally if your on this step I would move to filesystem storage. Large objects in the db could lead to speed issues and stability problems, but thats a personal view. I _always_ set to file system for both image and file galleries

Damian

p.s. there are other recent posts with details of what to change in my.cnf wink