Error In upload too after upgrading: WSN Support

WSN Support » WSN Gallery » Error In upload too after upgrading » Error In upload too after upgrading

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

Version: 2.3.6

Error In upload too after upgrading

eric0524
Experienced

Usergroup: Member
Joined: Jun 11, 2006
Total Topics: 15
Total Posts: 55

Posted 06/20/06 - 02:01 PM:	#1
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
---------------------------- www.saltwatersportswear.com - the largest selection of t-shirts www.showyour.com/photoswap

eric0524
Experienced

Usergroup: Member
Joined: Jun 11, 2006
Total Topics: 15
Total Posts: 55

Posted 06/20/06 - 02:45 PM:	#2
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?
---------------------------- www.saltwatersportswear.com - the largest selection of t-shirts www.showyour.com/photoswap

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5929

Posted 06/21/06 - 06:36 AM:	#3
Doesn't matter as long as it's more than 15 or so.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

You don't have permission to post.

Please login or register.