Webmastersite.net
Register Log In

Error In upload too after upgrading
I get an error when anyone trys to upload.

Comments on Error In upload too after upgrading

eric0524
Experienced

Usergroup: Member
Joined: Jun 11, 2006

Total Topics: 15
Total Comments: 55
Posted Jun 20, 2006 - 5:01 PM:

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
eric0524
Experienced

Usergroup: Member
Joined: Jun 11, 2006

Total Topics: 15
Total Comments: 55
Posted Jun 20, 2006 - 5:45 PM:

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?
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Jun 21, 2006 - 9:36 AM:

Doesn't matter as long as it's more than 15 or so.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.