Usergroup: Customer
Joined: Jan 21, 2005
Total Topics: 32
Total Posts: 102
Posted 11/10/07 - 06:19 PM:
#1
Hi,
WSN Links 3.4.6
Site was working fine for few days after i moved host but suddenly this mysql error appears:-
Note: I didn't do anything at all. No changes. was still working fine yesterday. Was it because of suddenly high server load? Comments/details pages are working but index.php, etc are not.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/myhost/public_html/classes/database.php on line 108
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/myhost/public_html/classes/database.php on line 108
Also, i cant get into admin panel as well. Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/myhost/public_html/classes/database.php on line 281
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/myhost/public_html/classes/database.php on line 256
Here is the debug info:-
Load time so far: 0.05 seconds. Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1;
Number of rows is 1 for Resource id #20
Load time so far: 0.06 seconds. Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;
Number of rows is 58 for Resource id #37
Load time so far: 0.06 seconds. Performing query: SELECT id,type,original,replacement,description,originalclose,replacementclose,sortorder FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder ;
Number of rows is 22 for Resource id #40
Load time so far: 0.06 seconds. Performing query: SELECT original,replacement,description,id,sortorder FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder ;
Number of rows is 14 for Resource id #41
Load time so far: 0.07 seconds. Performing query: SELECT id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,attachperlink,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod FROM wsnlinks_membergroups WHERE id>0 ;
Load time so far: 0.07 seconds. Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,alias,catcols,linkcols,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml FROM wsnlinks_categories WHERE validated=1 AND deleted=0 AND hide=0 ;
Number of rows is 1 for Resource id #47
Load time so far: 0.07 seconds. Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;
Load time so far: 0.07 seconds. Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;
Number of rows is 0 for Resource id #48
Load time so far: 0.12 seconds. Performing query: UNLOCK TABLES;
Load time so far: 0.12 seconds. Performing query: SELECT id,frequency,filename,nextrun FROM wsnlinks_crons WHERE nextrun < 1194746172 ORDER BY id ASC LIMIT 0,1;
Number of rows is 0 for Resource id #50
Load time so far: 0.12 seconds. Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,alias,catcols,linkcols,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml FROM wsnlinks_categories WHERE parent=1 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY priority ASC,name ASC LIMIT 0,40;
Number of rows is 0 for Resource id #52
Load time so far: 0.12 seconds. Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,notify,suspect,pendingedit,funds,suspended,alias,expire,ip,inalbum,typeorder,recipurl,hitsin,recipwith,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters,lastposterid,lastpostername,ownername,deleted,deletionreason,movedto,deletedby,timevalidated,filefield,message,sticky,downloads,pollid,posticon,savedby FROM wsnlinks_links WHERE catid=1 AND hide=0 AND deleted=0 AND validated=1 ORDER BY time DESC,title ASC LIMIT 0,9;
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/myhost/public_html/classes/database.php on line 108
Number of rows is for Got error 127 from storage engine
Warning: Cannot modify header information - headers already sent by (output started at /home/myhost/public_html/classes/database.php:276) in /home/myhost/public_html/commonfuncs.php on line 468
Warning: Cannot modify header information - headers already sent by (output started at /home/myhost/public_html/classes/database.php:276) in /home/myhost/public_html/commonfuncs.php on line 472
Warning: Cannot modify header information - headers already sent by (output started at /home/myhost/public_html/classes/database.php:276) in /home/myhost/public_html/end.php on line 142
Load time so far: 0.17 seconds. Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,notify,suspect,pendingedit,funds,suspended,alias,expire,ip,inalbum,typeorder,recipurl,hitsin,recipwith,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters,lastposterid,lastpostername,ownername,deleted,deletionreason,movedto,deletedby,timevalidated,filefield,message,sticky,downloads,pollid,posticon,savedby FROM wsnlinks_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND alias=0 AND inalbum=0 ORDER BY rand() ASC LIMIT 0,3;
Got error 127 from storage engine
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/myhost/public_html/classes/database.php on line 108
Number of rows is for Got error 127 from storage engine
14 total queries This page was created in 0.39 seconds Server Status: time since last reboot is 6:11, load average: 0.82, 1.05, 1.08
Load time so far: 1.02 seconds. Performing query: SELECT memberid,starttime,time FROM wsnlinks_sessions WHERE time < 1194752376 AND memberid > 0 ;
Got error 127 from storage engine
Number of rows is 0 for Resource id #62
Note: I have restarted apache, mysql, even reboot server but its still the same.
Usergroup: Customer
Joined: Jan 21, 2005
Total Topics: 32
Total Posts: 102
Posted 11/10/07 - 09:19 PM:
#3
Solved.
I added a link during the time my domain name propagates to the new server. This one link here messed up the whole database and site. how scary is that. and the effects only come out right after few days? weird
fixed by repairing the links table.
myhost.wsnlinks_links repair warning Number of rows changed from 413 to 412
Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5703
Posted 11/11/07 - 11:37 AM:
#4
3.4.6 is not supported and is guaranteed to die when your host gets around to a modern PHP version. 3.4.7 was the last of the series, but that series was phased out this year so 4.0 is now the legacy series and 4.1 the current series.
Print
MySQL Error
