I used auto upgrade to go from .10 to .11 and while it appeared to successfully upgrade, the return screen after hitting the upgrade button shot out these errors: (relevant location url data removed)
WSN Classifieds 5.0.10 Admin Panel An error occoured at www.reellocations.com/dir/u...pcustomupdates=&fromfree=0 on 2008-10-08 01:48:56. Please relay this data to support. Error #2: 'mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given' in /...../dir/databases/mysqli.php on line 45. Debug info: Query 133: UPDATE wsnclassifieds_settings SET content='id,name,value' WHERE name='switchesfields'
Load time so far: 1.03 seconds. Query 134: UPDATE wsnclassifieds_settings SET content='id,name,uses,link,ownerid,ownerip,deleted' WHERE name='tagsfields'
Load time so far: 1.04 seconds. Query 135: UPDATE wsnclassifieds_settings SET content='id,ratingof,ratingby,value,summary,report,time,type ,linkid,morecomments,validated,response' WHERE name='traderfields'
Load time so far: 1.04 seconds. Query 136: UPDATE wsnclassifieds_settings SET content='id,url,ownerid,lastfetched,validated,catid,time,tit le,description,homepage' WHERE name='xmlfeedsfields'
Load time so far: 1.04 seconds. Query 137: UPDATE wsnclassifieds_settings SET content='id,zip,lat,lon,city,state,country,part' WHERE name='zipcodesfields'
Load time so far: 1.05 seconds. Query 138: UPDATE wsnclassifieds_members SET banned = '' WHERE banned = '0'
Load time so far: 1.05 seconds. Query 139: SELECT id,count(name) AS timesin FROM wsnclassifieds_settings GROUP BY name ORDER BY timesin DESC
Query 140: SELECT `name` FROM wsnclassifieds_switches WHERE id>0
Load time so far: 1.07 seconds. Number of rows is 110
Load time so far: 1.08 seconds. Query 141: UPDATE wsnclassifieds_members SET notifymethod='instant' WHERE notifymethod=''
Query 142: SELECT `name`,`content` FROM wsnclassifieds_settings WHERE type is NULL OR type != 'special'
Load time so far: 1.08 seconds. Number of rows is 471
Load time so far: 5.56 seconds. Query 143: SELECT COUNT(id) FROM wsnclassifieds_links WHERE parentids = ''
An error occoured at www.---.com/dir/upgrade.php...pcustomupdates=&fromfree=0 on 2008-10-08 01:48:56. Please relay this data to support. Error #2: 'mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given' in /----databases/mysqli.php on line 45. Debug info: Query 134: UPDATE wsnclassifieds_settings SET content='id,name,uses,link,ownerid,ownerip,deleted' WHERE name='tagsfields'
Load time so far: 1.04 seconds. Query 135: UPDATE wsnclassifieds_settings SET content='id,ratingof,ratingby,value,summary,report,time,type ,linkid,morecomments,validated,response' WHERE name='traderfields'
Load time so far: 1.04 seconds. Query 136: UPDATE wsnclassifieds_settings SET content='id,url,ownerid,lastfetched,validated,catid,time,tit le,description,homepage' WHERE name='xmlfeedsfields'
Load time so far: 1.04 seconds. Query 137: UPDATE wsnclassifieds_settings SET content='id,zip,lat,lon,city,state,country,part' WHERE name='zipcodesfields'
Load time so far: 1.05 seconds. Query 138: UPDATE wsnclassifieds_members SET banned = '' WHERE banned = '0'
Load time so far: 1.05 seconds. Query 139: SELECT id,count(name) AS timesin FROM wsnclassifieds_settings GROUP BY name ORDER BY timesin DESC
Query 140: SELECT `name` FROM wsnclassifieds_switches WHERE id>0
Load time so far: 1.07 seconds. Number of rows is 110
Load time so far: 1.08 seconds. Query 141: UPDATE wsnclassifieds_members SET notifymethod='instant' WHERE notifymethod=''
Query 142: SELECT `name`,`content` FROM wsnclassifieds_settings WHERE type is NULL OR type != 'special'
Load time so far: 1.08 seconds. Number of rows is 471
Load time so far: 5.56 seconds. Query 143: SELECT COUNT(id) FROM wsnclassifieds_links WHERE parentids = ''
Count is Load time so far: 5.56 seconds. MySQL server has gone away
Query 144: SELECT COUNT(id) FROM wsnclassifieds_attachments WHERE 1=1
Comments on .10 to .11 upgrade - possible errors
Forum Regular
Usergroup: Customer
Joined: Nov 26, 2003
Total Topics: 70
Total Comments: 211
I used auto upgrade to go from .10 to .11 and while it appeared to successfully upgrade, the return screen after hitting the upgrade button shot out these errors: (relevant location url data removed)
WSN Classifieds 5.0.10 Admin Panel
An error occoured at www.reellocations.com/dir/u...pcustomupdates=&fromfree=0 on 2008-10-08 01:48:56. Please relay this data to support. Error #2: 'mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given' in /...../dir/databases/mysqli.php on line 45. Debug info:
Query 133: UPDATE wsnclassifieds_settings SET content='id,name,value' WHERE name='switchesfields'
Load time so far: 1.03 seconds.
Query 134: UPDATE wsnclassifieds_settings SET content='id,name,uses,link,ownerid,ownerip,deleted' WHERE name='tagsfields'
Load time so far: 1.04 seconds.
Query 135: UPDATE wsnclassifieds_settings SET content='id,ratingof,ratingby,value,summary,report,time,type ,linkid,morecomments,validated,response' WHERE name='traderfields'
Load time so far: 1.04 seconds.
Query 136: UPDATE wsnclassifieds_settings SET content='id,url,ownerid,lastfetched,validated,catid,time,tit le,description,homepage' WHERE name='xmlfeedsfields'
Load time so far: 1.04 seconds.
Query 137: UPDATE wsnclassifieds_settings SET content='id,zip,lat,lon,city,state,country,part' WHERE name='zipcodesfields'
Load time so far: 1.05 seconds.
Query 138: UPDATE wsnclassifieds_members SET banned = '' WHERE banned = '0'
Load time so far: 1.05 seconds.
Query 139: SELECT id,count(name) AS timesin FROM wsnclassifieds_settings GROUP BY name ORDER BY timesin DESC
Query 140: SELECT `name` FROM wsnclassifieds_switches WHERE id>0
Load time so far: 1.07 seconds.
Number of rows is 110
Load time so far: 1.08 seconds.
Query 141: UPDATE wsnclassifieds_members SET notifymethod='instant' WHERE notifymethod=''
Query 142: SELECT `name`,`content` FROM wsnclassifieds_settings WHERE type is NULL OR type != 'special'
Load time so far: 1.08 seconds.
Number of rows is 471
Load time so far: 5.56 seconds.
Query 143: SELECT COUNT(id) FROM wsnclassifieds_links WHERE parentids = ''
An error occoured at www.---.com/dir/upgrade.php...pcustomupdates=&fromfree=0 on 2008-10-08 01:48:56. Please relay this data to support. Error #2: 'mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given' in /----databases/mysqli.php on line 45. Debug info:
Query 134: UPDATE wsnclassifieds_settings SET content='id,name,uses,link,ownerid,ownerip,deleted' WHERE name='tagsfields'
Load time so far: 1.04 seconds.
Query 135: UPDATE wsnclassifieds_settings SET content='id,ratingof,ratingby,value,summary,report,time,type ,linkid,morecomments,validated,response' WHERE name='traderfields'
Load time so far: 1.04 seconds.
Query 136: UPDATE wsnclassifieds_settings SET content='id,url,ownerid,lastfetched,validated,catid,time,tit le,description,homepage' WHERE name='xmlfeedsfields'
Load time so far: 1.04 seconds.
Query 137: UPDATE wsnclassifieds_settings SET content='id,zip,lat,lon,city,state,country,part' WHERE name='zipcodesfields'
Load time so far: 1.05 seconds.
Query 138: UPDATE wsnclassifieds_members SET banned = '' WHERE banned = '0'
Load time so far: 1.05 seconds.
Query 139: SELECT id,count(name) AS timesin FROM wsnclassifieds_settings GROUP BY name ORDER BY timesin DESC
Query 140: SELECT `name` FROM wsnclassifieds_switches WHERE id>0
Load time so far: 1.07 seconds.
Number of rows is 110
Load time so far: 1.08 seconds.
Query 141: UPDATE wsnclassifieds_members SET notifymethod='instant' WHERE notifymethod=''
Query 142: SELECT `name`,`content` FROM wsnclassifieds_settings WHERE type is NULL OR type != 'special'
Load time so far: 1.08 seconds.
Number of rows is 471
Load time so far: 5.56 seconds.
Query 143: SELECT COUNT(id) FROM wsnclassifieds_links WHERE parentids = ''
Count is
Load time so far: 5.56 seconds.
MySQL server has gone away
Query 144: SELECT COUNT(id) FROM wsnclassifieds_attachments WHERE 1=1
Upgrade complete.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
MySQL server has gone away
That means your mysql got impatient and left. It ought to stick around more than 6 seconds...