Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Upload problem "database error: 2006 : MySQL server has gone away"  (Read 4962 times)

0 Members and 1 Guest are viewing this topic.

dmrow

  • Coppermine newbie
  • Offline Offline
  • Posts: 4

I have a new 1.6.08 installation of Coppermine.  Love it - well, love most of it.   ;)

I've a problem uploading some files.  I have done the various uploading troubleshooting steps, and am now trying simple uploading one file at a time.  When I do, I get this message

While executing query 'SELECT category FROM xp8o_albums WHERE aid='10'' in uniload.php on line 369

database error: 2006 : MySQL server has gone away


Note that the aid value varies from time to time.

I have set the max upload size to 40 MB (way bigger than the pic sizes) and lengthened the various timeout values.

Any ideas what might be causing this, and how to solve?

Many tks

David.
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: Upload problem "database error: 2006 : MySQL server has gone away"
« Reply #1 on: March 11, 2020, 10:31:51 pm »

Have you managed to upload anything? What type of file were you trying to upload? Are you self hosting?

Please follow the guide here and answer the questions above https://documentation.coppermine-gallery.net/en/upload_troubleshooting.htm
Logged
It is a mistake to think you can solve any major problems just with potatoes.

dmrow

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Upload problem "database error: 2006 : MySQL server has gone away"
« Reply #2 on: March 12, 2020, 04:36:54 am »

Hi, Phill

Yes, have managed to upload most of the files.  They are primarily jpg files.  No, I'm using Hostinger to host.

And, yes, have followed the guide you link to.  :)

Many thanks for any further insight you can assist with

David.
Logged

ron4mac

  • Administrator
  • Coppermine addict
  • *****
  • Country: us
  • Offline Offline
  • Posts: 2026
Re: Upload problem "database error: 2006 : MySQL server has gone away"
« Reply #3 on: March 12, 2020, 01:30:25 pm »

Check the output for Phpinfo to see whether max_execution_time or max_input_time are set too short.
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 20 queries.