I followed everthing you said int he last guys post with the same problem. I get the same problem after upgrading. I added the debug command and her is the out put befor and after the page.
13 total queries This page was created in 0.46 seconds Server Status: time since last reboot is 1:41, load average: 0.08, 0.12, 0.10
Downloads = 100 vs Uploads = 399
Load time so far: 0.57 seconds. Performing query: SELECT inchat,lastchat FROM wsngallery_sessions WHERE memberid=1 LIMIT 0,1;
Number of rows is 1 for Resource id #62
Load time so far: 0.57 seconds. Performing query: SELECT memberid,starttime,time FROM wsngallery_sessions WHERE time < 1150838913 AND memberid > 0 ;
Number of rows is 0 for Resource id #63
Load time so far: 0.57 seconds. Performing query: DELETE FROM wsngallery_sessions WHERE time < 1150838913;
Load time so far: 0.57 seconds. Performing query: UPDATE wsngallery_sessions SET starttime=0, time=0 WHERE time < 1150840413;
Load time so far: 0.57 seconds. Performing query: SELECT id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility FROM wsngallery_sessions WHERE memberid=1 ;
Number of rows is 1 for Resource id #64
Load time so far: 0.57 seconds. Performing query: UPDATE wsngallery_sessions SET id='788' WHERE id=788;
Load time so far: 0.57 seconds. Performing query: UPDATE wsngallery_sessions SET memberid='1' WHERE id=788;
Load time so far: 0.57 seconds. Performing query: UPDATE wsngallery_sessions SET location='http://www.showyour.com/photoswap/suggest.php?action=addlink&catid=7&debug=1' WHERE id=788;
Load time so far: 0.57 seconds. Performing query: UPDATE wsngallery_sessions SET time='1150840713' WHERE id=788;
Load time so far: 0.57 seconds. Performing query: UPDATE wsngallery_sessions SET ip='24.73.218.140' WHERE id=788;
Load time so far: 0.57 seconds. Performing query: UPDATE wsngallery_sessions SET browser='Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.4) Gecko/20060508 Firefox/1.5.0.4' WHERE id=788;
Load time so far: 0.57 seconds. Performing query: UPDATE wsngallery_sessions SET starttime='1150840698' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET catid='7' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET threadid='' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET areaname='Suggest New Image' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET lastsearch='0' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET nopermission='0' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET inchat='0' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET name='admin' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET isrobot='0' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET lastchat='0' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET groupnamestyle='admincolor' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET acceptims='none' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET visibility='everyone' WHERE id=788;
closing database connection
{AFTER MAIN PART OF PAGE}
13 total queries This page was created in 0.46 seconds Server Status: time since last reboot is 1:41, load average: 0.08, 0.12, 0.10
Downloads = 100 vs Uploads = 399
Load time so far: 0.57 seconds. Performing query: SELECT inchat,lastchat FROM wsngallery_sessions WHERE memberid=1 LIMIT 0,1;
Number of rows is 1 for Resource id #62
Load time so far: 0.57 seconds. Performing query: SELECT memberid,starttime,time FROM wsngallery_sessions WHERE time < 1150838913 AND memberid > 0 ;
Number of rows is 0 for Resource id #63
Load time so far: 0.57 seconds. Performing query: DELETE FROM wsngallery_sessions WHERE time < 1150838913;
Load time so far: 0.57 seconds. Performing query: UPDATE wsngallery_sessions SET starttime=0, time=0 WHERE time < 1150840413;
Load time so far: 0.57 seconds. Performing query: SELECT id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility FROM wsngallery_sessions WHERE memberid=1 ;
Number of rows is 1 for Resource id #64
Load time so far: 0.57 seconds. Performing query: UPDATE wsngallery_sessions SET id='788' WHERE id=788;
Load time so far: 0.57 seconds. Performing query: UPDATE wsngallery_sessions SET memberid='1' WHERE id=788;
Load time so far: 0.57 seconds. Performing query: UPDATE wsngallery_sessions SET location='http://www.showyour.com/photoswap/suggest.php?action=addlink&catid=7&debug=1' WHERE id=788;
Load time so far: 0.57 seconds. Performing query: UPDATE wsngallery_sessions SET time='1150840713' WHERE id=788;
Load time so far: 0.57 seconds. Performing query: UPDATE wsngallery_sessions SET ip='24.73.218.140' WHERE id=788;
Load time so far: 0.57 seconds. Performing query: UPDATE wsngallery_sessions SET browser='Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.4) Gecko/20060508 Firefox/1.5.0.4' WHERE id=788;
Load time so far: 0.57 seconds. Performing query: UPDATE wsngallery_sessions SET starttime='1150840698' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET catid='7' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET threadid='' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET areaname='Suggest New Image' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET lastsearch='0' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET nopermission='0' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET inchat='0' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET name='admin' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET isrobot='0' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET lastchat='0' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET groupnamestyle='admincolor' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET acceptims='none' WHERE id=788;
Load time so far: 0.58 seconds. Performing query: UPDATE wsngallery_sessions SET visibility='everyone' WHERE id=788;
I added the ownerip varchar to wsngallery_attachments and it seems to work. I first tried to do the add filed and that did not work. One out of two problems down. BTW, how many chars should the ownerip field be?
Comments on Error In upload too after upgrading
Experienced
Usergroup: Member
Joined: Jun 11, 2006
Total Topics: 15
Total Comments: 55
I followed everthing you said int he last guys post with the same problem. I get the same problem after upgrading. I added the debug command and her is the out put befor and after the page.
13 total queries
This page was created in 0.46 seconds
Server Status: time since last reboot is 1:41, load average: 0.08, 0.12, 0.10
Downloads = 100 vs Uploads = 399
Load time so far: 0.57 seconds.
Performing query: SELECT inchat,lastchat FROM wsngallery_sessions WHERE memberid=1 LIMIT 0,1;
Number of rows is 1 for Resource id #62
Load time so far: 0.57 seconds.
Performing query: SELECT memberid,starttime,time FROM wsngallery_sessions WHERE time < 1150838913 AND memberid > 0 ;
Number of rows is 0 for Resource id #63
Load time so far: 0.57 seconds.
Performing query: DELETE FROM wsngallery_sessions WHERE time < 1150838913;
Load time so far: 0.57 seconds.
Performing query: UPDATE wsngallery_sessions SET starttime=0, time=0 WHERE time < 1150840413;
Load time so far: 0.57 seconds.
Performing query: SELECT id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility FROM wsngallery_sessions WHERE memberid=1 ;
Number of rows is 1 for Resource id #64
Load time so far: 0.57 seconds.
Performing query: UPDATE wsngallery_sessions SET id='788' WHERE id=788;
Load time so far: 0.57 seconds.
Performing query: UPDATE wsngallery_sessions SET memberid='1' WHERE id=788;
Load time so far: 0.57 seconds.
Performing query: UPDATE wsngallery_sessions SET location='http://www.showyour.com/photoswap/suggest.php?action=addlink&catid=7&debug=1' WHERE id=788;
Load time so far: 0.57 seconds.
Performing query: UPDATE wsngallery_sessions SET time='1150840713' WHERE id=788;
Load time so far: 0.57 seconds.
Performing query: UPDATE wsngallery_sessions SET ip='24.73.218.140' WHERE id=788;
Load time so far: 0.57 seconds.
Performing query: UPDATE wsngallery_sessions SET browser='Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.4) Gecko/20060508 Firefox/1.5.0.4' WHERE id=788;
Load time so far: 0.57 seconds.
Performing query: UPDATE wsngallery_sessions SET starttime='1150840698' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET catid='7' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET threadid='' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET areaname='Suggest New Image' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET lastsearch='0' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET nopermission='0' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET inchat='0' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET name='admin' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET isrobot='0' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET lastchat='0' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET groupnamestyle='admincolor' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET acceptims='none' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET visibility='everyone' WHERE id=788;
closing database connection
{AFTER MAIN PART OF PAGE}
13 total queries
This page was created in 0.46 seconds
Server Status: time since last reboot is 1:41, load average: 0.08, 0.12, 0.10
Downloads = 100 vs Uploads = 399
Load time so far: 0.57 seconds.
Performing query: SELECT inchat,lastchat FROM wsngallery_sessions WHERE memberid=1 LIMIT 0,1;
Number of rows is 1 for Resource id #62
Load time so far: 0.57 seconds.
Performing query: SELECT memberid,starttime,time FROM wsngallery_sessions WHERE time < 1150838913 AND memberid > 0 ;
Number of rows is 0 for Resource id #63
Load time so far: 0.57 seconds.
Performing query: DELETE FROM wsngallery_sessions WHERE time < 1150838913;
Load time so far: 0.57 seconds.
Performing query: UPDATE wsngallery_sessions SET starttime=0, time=0 WHERE time < 1150840413;
Load time so far: 0.57 seconds.
Performing query: SELECT id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility FROM wsngallery_sessions WHERE memberid=1 ;
Number of rows is 1 for Resource id #64
Load time so far: 0.57 seconds.
Performing query: UPDATE wsngallery_sessions SET id='788' WHERE id=788;
Load time so far: 0.57 seconds.
Performing query: UPDATE wsngallery_sessions SET memberid='1' WHERE id=788;
Load time so far: 0.57 seconds.
Performing query: UPDATE wsngallery_sessions SET location='http://www.showyour.com/photoswap/suggest.php?action=addlink&catid=7&debug=1' WHERE id=788;
Load time so far: 0.57 seconds.
Performing query: UPDATE wsngallery_sessions SET time='1150840713' WHERE id=788;
Load time so far: 0.57 seconds.
Performing query: UPDATE wsngallery_sessions SET ip='24.73.218.140' WHERE id=788;
Load time so far: 0.57 seconds.
Performing query: UPDATE wsngallery_sessions SET browser='Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.4) Gecko/20060508 Firefox/1.5.0.4' WHERE id=788;
Load time so far: 0.57 seconds.
Performing query: UPDATE wsngallery_sessions SET starttime='1150840698' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET catid='7' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET threadid='' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET areaname='Suggest New Image' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET lastsearch='0' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET nopermission='0' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET inchat='0' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET name='admin' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET isrobot='0' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET lastchat='0' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET groupnamestyle='admincolor' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET acceptims='none' WHERE id=788;
Load time so far: 0.58 seconds.
Performing query: UPDATE wsngallery_sessions SET visibility='everyone' WHERE id=788;
closing database connection
Experienced
Usergroup: Member
Joined: Jun 11, 2006
Total Topics: 15
Total Comments: 55
I added the ownerip varchar to wsngallery_attachments and it seems to work. I first tried to do the add filed and that did not work. One out of two problems down. BTW, how many chars should the ownerip field be?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Doesn't matter as long as it's more than 15 or so.