PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > PhotoPost Pro Support Forums > Photopost Pro Bug Reports

Photopost Pro Bug Reports Post post installation PhotoPost Pro problems here.

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old January 30th, 2007, 09:52 AM   #1 (permalink)
Junior Member
Verified Customer
 
Join Date: Feb 2005
Posts: 10
'Lost connection to MySQL server' when uploading images (bulkupload.php,PP 4.8d)

Our users are getting problems when uploading images to the gallery, getting various errors on different queries, all 'Lost connection to MySQL server during query'.

We've recently split to two servers, one database and one web, on a local 'network'. MySQL uptime is a couple of weeks, so it's not crashing, and it's not happening anywhere else on the site, only when uploading images, and interestingly at the moment they SEEM to always be related to the user database. Browsing, etc, is fine.

Any ideas?

Thanks,

Ollie
BirdForum
thirty6degrees is offline   Reply With Quote
Old January 30th, 2007, 10:12 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,947
Have you ensured you are using all the correct mysql information in the config especially the user database portion?

The error you are describing is one where mysql on the external server can not be connected to which means it is busy or down usually.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old January 30th, 2007, 10:25 AM   #3 (permalink)
Junior Member
Verified Customer
 
Join Date: Feb 2005
Posts: 10
Yep, it's all filled in right, and everything else still works.

It's only happening in this one place, very strange...
thirty6degrees is offline   Reply With Quote
Old January 30th, 2007, 11:36 AM   #4 (permalink)
Junior Member
Verified Customer
 
Join Date: Feb 2005
Posts: 10
Example error:


MySQL error reported!

Script: bulkupload

Query: SELECT userid,username,email,password,usergroupid,timezon eoffset,salt,membergroupids FROM user WHERE userid='14121'

Result: Lost connection to MySQL server during query

Database handle: Resource id #9
thirty6degrees is offline   Reply With Quote
Old January 30th, 2007, 12:13 PM   #5 (permalink)
Junior Member
Verified Customer
 
Join Date: Feb 2005
Posts: 10
Would you be able to look at this if i sent you some more details? What details do you need?
thirty6degrees is offline   Reply With Quote
Old January 30th, 2007, 01:24 PM   #6 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,947
There is not much I can do with an error like this

Lost connection to MySQL server during query

This tells me hands down the connection to mysql is being dropped as in the mysql server is going down. This is a server issue. As long as your user database info is correct as it is entered in your vb config file so should it be entered in our config thats all I can really respond to on this. For any real server issues like this you would need to contact your host and ask them what is up with why your mysql is loosing connection
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Error- lost images and comments rstarke Photopost Pro Bug Reports 6 September 26th, 2006 09:01 AM
Server Error on Uploading Images (1500x1500) sibble Photopost Pro Bug Reports 17 September 4th, 2006 01:42 PM
bulkupload.php issue? glowinggal Photopost Pro Installation & Upgrades 4 February 8th, 2006 08:45 PM
MySQL Connection Problem dmunch Photopost Pro Installation & Upgrades 11 January 15th, 2005 09:08 PM
MySQL error reported! Script: bulkupload janet22 Photopost Pro Installation & Upgrades 19 November 11th, 2004 09:05 PM


All times are GMT -5. The time now is 01:24 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0