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 March 2nd, 2008, 08:28 AM   #1 (permalink)
Member
Verified Customer
 
Join Date: Nov 2005
Posts: 124
Question query errors in Photopost

I woke up this morning to find these error messages in my mailbox. I just moved to a new server this week. Any idea what would cause these? Thanks.

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

SELECT id,user,userid,cat,manu,title,bigimage,views FROM rp_products WHERE approved=1 ORDER BY views DESC LIMIT 15

The query returned with an errorcode of:

MySQL server has gone away
Quote:
An error was encountered during execution of the query:

UPDATE rp_cache SET timestamp=1204455074,popularcache='a:0:{}' WHERE id=1

The query returned with an errorcode of:

MySQL server has gone away
Quote:
An error was encountered during execution of the query:

SELECT id,user,userid,cat,manu,title,bigimage,views, id*0+RAND() as rand_col FROM rp_products WHERE approved=1 ORDER BY rand_col DESC LIMIT 15

The query returned with an errorcode of:

MySQL server has gone away
Quote:
An error was encountered during execution of the query:

SELECT id,user,userid,cat,storecat,title,ismature,bigimage,height,width FROM pp_photos WHERE approved=1 AND storecat=0 ORDER BY views DESC LIMIT 35

The query returned with an errorcode of:

MySQL server has gone away
Quote:
An error was encountered during execution of the query:

SELECT id,user,userid,cat,storecat,title,ismature,bigimage,height,width, id*0+RAND() as rand_col FROM pp_photos WHERE approved=1 AND storecat=0 ORDER BY rand_col DESC LIMIT 35

The query returned with an errorcode of:

MySQL server has gone away
Quote:
An error was encountered during execution of the query:

SELECT id,user,userid,cat,storecat,title,ismature,bigimage,height,width, id*0+RAND() as rand_col FROM pp_photos WHERE approved=1 AND storecat=0 ORDER BY rand_col DESC LIMIT 35

The query returned with an errorcode of:

MySQL server has gone away
ncangler is offline   Reply With Quote
Old March 2nd, 2008, 08:51 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 68,069
mysql server has gone away means your mysql server was down while your site was still running so the queries can not be done. Keep an eye on it and if it continues contact your host to see why the mysql server is shutting down.
__________________
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
Using mysqli in vb 3.6 gives PhotoPost errors MrX1 Photopost Pro Installation & Upgrades 5 December 4th, 2007 12:06 PM
Having errors in Photopost jnissen Photopost Pro Bug Reports 1 September 23rd, 2007 09:30 AM
Errors with my Photopost integration gotvtec Photopost Pro Installation & Upgrades 3 September 6th, 2007 11:54 PM
have just installed photopost but have a few errors Nekiw General Discussion 1 August 21st, 2006 12:10 PM
Photopost and PHPBB errors lakerszone Photopost Pro Installation & Upgrades 0 December 23rd, 2004 10:40 AM


All times are GMT -5. The time now is 07:55 AM.

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