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 Installation & Upgrades

Photopost Pro Installation & Upgrades If you're having install or upgrade problems

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old March 19th, 2006, 07:02 AM   #1 (permalink)
Junior Member
Verified Customer
 
Join Date: Mar 2006
Posts: 9
MySQL error with pp 5.3

I've been getting these errors and I don't understand where they are coming from. I have pp 5.3 running on Linux. Any help is appreciated.

Quote:
An error was encountered during execution of the query:

SELECT phpbb_users.user_id,phpbb_users.username,phpbb_users.user_email,phpbb_users.user_password,phpbb_users.user_level,phpbb_users.user_timezone,phpbb_themes.template_name FROM phpbb_users
LEFT JOIN phpbb_themes ON phpbb_users.user_style = phpbb_themes.themes_id
WHERE user_id=17

The query returned with an errorcode of:

Lost connection to MySQL server during queryAn error was encountered during execution of the query:

SELECT phpbb_users.user_id,phpbb_users.username,phpbb_users.user_email,phpbb_users.user_password,phpbb_users.user_level,phpbb_users.user_timezone,phpbb_themes.template_name FROM phpbb_users
LEFT JOIN phpbb_themes ON phpbb_users.user_style = phpbb_themes.themes_id
WHERE user_id=17

The query returned with an errorcode of:

Lost connection to MySQL server during query
JR_MCO is offline   Reply With Quote
Old March 19th, 2006, 09:36 AM   #2 (permalink)
Junior Member
Verified Customer
 
Join Date: Sep 2004
Location: Ruhrpott, germany
Posts: 26
there's a problem with the mysql server it seems.
php loses connection with the server during the query.
maybe too few connections allowed or the timeout of the server is set too low...
flint is offline   Reply With Quote
Old March 19th, 2006, 12:05 PM   #3 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,667
Lost connection to MySQL server during query

Yep that says it all. If your on like Powweb or Ipowerweb they limit connections to say 50000 and then shut your mysql down for a number of minutes like 10-15.

You can ask your host about this issue since it is server related.
__________________
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 March 19th, 2006, 02:27 PM   #4 (permalink)
Junior Member
Verified Customer
 
Join Date: Mar 2006
Posts: 9
Thanks, I'll check with godaddy. The site is small so I shouldn't have had too many connections.
JR_MCO 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... Rich Z Photopost Pro Bug Reports 1 August 29th, 2005 09:29 PM
Help!!! Mysql Error tommyxv Photopost Pro Installation & Upgrades 2 May 20th, 2005 08:35 AM
MySQL error... Rich Z Classifieds Bug Reports 28 April 27th, 2005 12:28 PM
HELP! MySQL error scrap32 Photopost Pro Installation & Upgrades 1 November 15th, 2004 12:18 PM
MySQL error orangeflea Photopost Pro Installation & Upgrades 4 September 24th, 2004 07:04 AM


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

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