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

Classifieds Installation & Upgrades If you're having install or upgrade problems, post here.

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old November 24th, 2005, 01:16 AM   #1 (permalink)
Junior Member
Verified Customer
 
Join Date: Aug 2005
Posts: 28
upgrade 2.42 error

I just upgraded my classifed from 2.41 to 2.42

i have this at the bottom of everypage
the rest of the setup seems fine


Page generated in 0.15870 seconds with 27 queries
1: SELECT u.userid,u.username,u.email,u.password,u.usergroupid,u.timezoneoffset,s.sessionhash,u.salt,u.membergroupids FROM user u LEFT JOIN session s ON s.userid=u.userid WHERE u.userid='7428' (0.00089 sec)
2: SELECT groupid,cpaccess,modaccess,uploadsize,uploads,comments,editpho,editposts,reqmod,highlight,bold,italic FROM class_usergroups WHERE groupid=6 LIMIT 1 (0.00013 sec)
3: SELECT id,ugnoupload,ugnoanno,ugnoview,ugnopost,catname,parent,children,thumbs,header,footer,headtags FROM class_categories (0.00020 sec)
4: SELECT groupid,cpaccess,modaccess,uploadsize,uploads,comments,editpho,editposts,reqmod,highlight,bold,italic FROM class_usergroups WHERE groupid=5 LIMIT 1 (0.00014 sec)
5: SELECT groupid,cpaccess,modaccess,uploadsize,uploads,comments,editpho,editposts,reqmod,highlight,bold,italic FROM class_usergroups WHERE groupid=19 LIMIT 1 (0.00012 sec)
6: SELECT id,user,userid,cat,date,title,price,description,keywords,bigimage,bigimage2,bigimage3,views,approved,rating,extra1,extra2,extra3,extra4,extra5,extra6,disporder,status,isauction,highbidder,maxbid,numbids,enddate,zipcode FROM class_products WHERE id='612' (0.00072 sec)
7: REPLACE INTO class_laston VALUES(25,7428,1132816361) (0.00035 sec)
8: SELECT catname,template,extra1,extra2,extra3,extra4,extra5,extra6 FROM class_categories where id='25' (0.00031 sec)
9: SELECT * FROM class_sort WHERE sortid=1 (0.00006 sec)
10: SELECT id FROM class_products WHERE cat=25 ORDER BY disporder,date DESC (0.00081 sec)
11: SELECT catname,parent,thumbs FROM class_categories WHERE id=25 (0.00010 sec)
12: SELECT catname,parent,thumbs FROM class_categories WHERE id=6 (0.00006 sec)
13: SELECT catname,parent,thumbs FROM class_categories WHERE id=0 (0.00005 sec)
14: REPLACE INTO class_iponline (userid,ipaddr,date,what,item) VALUES ('JustB','71.195.145.76','1132816361','showproduct','25') (0.00058 sec)
15: DELETE FROM class_iponline WHERE date < 1132815761 (0.00018 sec)
16: SELECT id FROM class_products WHERE approved=0 (0.00006 sec)
17: SELECT id, catname, description, catorder, parent, thumbs, children, template FROM class_categories ORDER BY catorder ASC (0.00018 sec)
18: SELECT id FROM class_favorites WHERE product=612 AND userid=7428 (0.00053 sec)
19: SELECT id FROM class_notify WHERE userid=7428 AND product=612 LIMIT 1 (0.00022 sec)
20: UPDATE class_products SET views=views+1 WHERE id=612 (0.00065 sec)
21: SELECT rating,count(*) FROM class_feedback WHERE foruser=4691 GROUP BY rating (0.00009 sec)
22: SELECT id,username,userid,date,comment,approved FROM class_comments WHERE product=612 ORDER BY date ASC (0.00052 sec)
23: SELECT data FROM datastore WHERE title = 'userstats' (0.00008 sec)
24: SELECT SUM(views), count(*) FROM class_products WHERE approved=1 (0.00515 sec)
25: SELECT count(*) FROM class_comments (0.00007 sec)
26: SELECT amt_sold,ads_sold FROM class_stats (0.00005 sec)
justb is offline   Reply With Quote
Old November 24th, 2005, 07:21 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,698
damn okay

In pp-inc.php find this

$showsqldebug = 2;

change to

$showsqldebug = 0;
__________________
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 November 24th, 2005, 10:59 PM   #3 (permalink)
Junior Member
Verified Customer
 
Join Date: Aug 2005
Posts: 28
fixed thanks
justb 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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
upgrade error medieval Classifieds Bug Reports 2 September 29th, 2005 12:47 PM
Upgrade error lighterrr Photopost Pro Installation & Upgrades 2 August 6th, 2005 05:49 AM
Error with upgrade 5.11 lighterrr Photopost Pro Installation & Upgrades 2 June 19th, 2005 08:14 PM
Error on upgrade Tigermoth ReviewPost Installation & Upgrades 10 June 5th, 2005 07:48 PM
After upgrade from 4.8.6 to 5.0.1 I have an error Spike05 Photopost Pro Installation & Upgrades 1 March 14th, 2005 05:33 AM


All times are GMT -5. The time now is 04:06 AM.

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