forum.coppermine-gallery.net

Support => cpg1.6.x Support => cpg1.6 upload => Topic started by: Feri on October 17, 2019, 12:45:23 am

Title: Strange MYSQL error
Post by: Feri on October 17, 2019, 12:45:23 am
Hi guys. I'm having an issue with uploads which worked fine until now. This error comes when I try to upload like 250-300 images at once and then after 150 it just stops with an error code. The error code is the same for multiple files:

Quote
While executing query 'INSERT INTO cpg16x_pictures (aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, title, caption, keywords, approved, user1, user2, user3, user4, pic_raw_ip, pic_hdr_ip, position, guest_token) VALUES ('49', 'userpics/10001/49/', '8471680207_6809fd557b_o~1.png', '365707', '466881', '380', '240', '1571265532', '1', '', '', '', 'YES', '', '', '', '', '', '', '0', '')' in include/picmgmt.inc.php on line 184

database error: 2006 : MySQL server has gone away

Could you guys please help me out, because I've been searching for hours now and nothing relevant has been found yet.  :-[
Title: Re: Strange MYSQL error
Post by: Phill Luckhurst on October 17, 2019, 12:24:14 pm
It is usually the hosting that is the problem with errors like this. Some have strict limits, especially on shared servers, so everyone gets a fair shot at processor and disk time.
Title: Re: Strange MYSQL error
Post by: Feri on October 17, 2019, 04:22:04 pm
I see, and is there any way to bypass that?
Title: Re: Strange MYSQL error
Post by: ron4mac on October 17, 2019, 09:29:09 pm
I see, and is there any way to bypass that?
How about ... not upload so many at one time. ;)