I was just upgrading my WSNL version 3.14 to the very latest - everything appears to have worked. However, when I first went into the upgrade.php script, it gave the following warnings: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /secure/c/(mywebsiteurl)/links/databases/mysql.php on line 19
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /secure/c/(mywebsiteurl)/links/databases/mysql.php on line 22
Although I went through with the upgrade and it appears to have worked, I am concerned about these error messages and if they are a hidden problem which could cause problems later.
OK, there's something wrong with the database - I'm getting more of these errors, and some information is not displaying correctly such as the latest new member which it says is '2' but when you get information is actually a very old record.
Also - I'm always very worried about security - while I was discovering all these problems there were guests coming onto the site - could they have gained access to members details - or got into anything because the database / system is not right? I have now put the system into maintenance mode - will this prevent further possiblility of anyone getting into the system - including members until we've solved the problems?
Post the debug output (check the box for it on upgrade).
If upgrade.php does not give errors anymore, then nothing's wrong.
wsnl wrote: Also - I'm always very worried about security
Er, if you were worried about security you wouldn't have been using 3.14. I emailed the critical security update notice more than a year ago, anybody using pre-3.3.21 versions (and especially pre 3.3.8 versions) should expect to have been hacked long ago. You should check for any subdirectories where somebody might be hosting illegal content, or suspicious files (like c99.php, that's the most common PHP shell which gives the hackers complete remote control, and was seen used in these exploits).
In general, anyone using any 2 year old software without downloading updates is naturally prone to being hacked... if there isn't a security fix for 2 years it usually means the project is dead, not that there weren't any holes.
Also, of course, upgrades will become less reliable with really old versions like this -- I haven't tested an upgrade from 3.14 in years (and actually I don't have a copy of 3.14) so I don't know what issues it can bring.
could they have gained access to members details
As you can see by looking at your site, no membership details are listed. There's no situation which would call for printing out the database to the screen, regardless of errors, so it never happens.
I have now put the system into maintenance mode
I've no idea what "maintenance mode" is, it must be some sort of host-specific option, but I'm sure it's pointless in this case. A current broken version would be infinitely more secure than what you've been running the last year plus.
The listing of errors can reveal file paths, which some people prefer not to, but letting someone know your file path only helps them in exploiting existing security holes (especially on shared hosts I believe), it doesn't open new ones (I don't mind saying this file is /home/wmaster/public_html/forums/comments.php). You can set debug mode to suppress errors if you wish.
Er, if you were worried about security you wouldn't have been using 3.14. I emailed the critical security update notice more than a year ago, anybody using pre-3.3.21 versions (and especially pre 3.3.8 versions) should expect to have been hacked long ago. You should check for any subdirectories where somebody might be hosting illegal content, or suspicious files (like c99.php, that's the most common PHP shell which gives the hackers complete remote control, and was seen used in these exploits).
Yeah - sorry about that! It's been a while since I took a proper look at the links system! I need to try to get it back up and properly running, and this time I'd like to try and use the paid for system too.
I will attempt to run upgrade.php again and see if it comes up with any errors with the box checked. Are you saying that from your point-of-view, if it doesn't then there's nothing wrong with the function of the system - but there could be a problem with the database, or the layout of the tables becoming mis-aligned? If nothing works, I might attempt a clean install of the links system, and then try to import the database - but I am concerned about doing this because I'm not sure of the settings I should use to save the database file to my computer in order to be able to re-import it back into WSNL.
I've no idea what "maintenance mode" is... Sorry - I probably used the wrong terminology...I meant that I've just checked the box which makes the system display 'The Links Directory is currently offline. Please be patient and check back soon.' and doesn't allow anyone except admin to log in.
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
Load time so far: 0.12 seconds.
Query: UPDATE wsnlinks_settings SET content='206' WHERE name='highestcatindex'
Load time so far: 0.12 seconds.
Query: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0
Number of rows is 72
Query: SHOW COLUMNS FROM wsnlinks_links
Getting field list for table wsnlinks_links: id,title,url,description,rating,votes,validated,recipurl,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,hitsin,voterips,voterids,lastedit,type,filename,filetitle,notify,suspect,downloads,pendingedit,funds,suspended,recipwith,alias,expire,ip,inalbum,typeorder,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,pollid,posticon,savedby,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnlinks_categories
Getting field list for table wsnlinks_categories: 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,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,linksperpage,wysihtml,numonline
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnlinks_members
Getting field list for table wsnlinks_members: id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,images,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel,topics,posts,chatcolor,traderrating,invitessent,validatedemail,calsub,macros
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnlinks_membergroups
Getting field list for table wsnlinks_membergroups: 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,numinv,allowugspec,validateemails,validatesponsorlinks
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnlinks_email
Getting field list for table wsnlinks_email: id,to,subject,message,headers,timesent,ip,replacement,mime
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnlinks_sessions
Getting field list for table wsnlinks_sessions: id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnlinks_ratings
Getting field list for table wsnlinks_ratings: id,votevalue,time,memberid,ip,custom,linkid,type
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnlinks_markup
Getting field list for table wsnlinks_markup: id,type,original,replacement,description,originalclose,replacementclose,sortorder
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnlinks_modlog
Getting field list for table wsnlinks_modlog: id,topicid,postid,type,nature,reason,moderatorid,source,destination,time,catid,memberid
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnlinks_crons
Getting field list for table wsnlinks_crons: id,frequency,nextrun,filename,native
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnlinks_calendar
Getting field list for table wsnlinks_calendar: id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnlinks_im
Getting field list for table wsnlinks_im: id,toid,fromid,message,time,isread,timeread,deleted
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnlinks_searches
Getting field list for table wsnlinks_searches: id,value,memberid,catid,time
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnlinks_comments
Getting field list for table wsnlinks_comments: id,linkid,posterid,postername,message,time,linkname,validated,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,lasteditby,catid,editreason,preventedit,inhidden,deleted,deletionreason,usernoteon,modnote,filefield,title,deletedby,parentids,disablesmilies,disablesig,icon,disablewsn,disablehtml,originalmessage,flagged,wysihtml,unrevised
Load time so far: 0.13 seconds.
Load time so far: 0.13 seconds.
Query: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder
Number of rows is 4
Query: SHOW COLUMNS FROM wsnlinks_attachments
Getting field list for table wsnlinks_attachments: id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid
Load time so far: 0.14 seconds.
Load time so far: 0.14 seconds.
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`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks` FROM wsnlinks_membergroups WHERE id>0
Load time so far: 0.15 seconds.
Query: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`images`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros` FROM wsnlinks_members WHERE id=1 AND validated=1
Load time so far: 0.16 seconds.
Query: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder
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
Query: UNLOCK TABLES
Query: SHOW COLUMNS FROM wsnlinks_links
Getting field list for table wsnlinks_links: id,title,url,description,rating,votes,validated,recipurl,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,hitsin,voterips,voterids,lastedit,type,filename,filetitle,notify,suspect,downloads,pendingedit,funds,suspended,recipwith,alias,expire,ip,inalbum,typeorder,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,pollid,posticon,savedby,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime
Load time so far: 0.18 seconds.
Query: SHOW COLUMNS FROM wsnlinks_categories
Getting field list for table wsnlinks_categories: 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,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,linksperpage,wysihtml,numonline
Load time so far: 0.18 seconds.
Query: SHOW COLUMNS FROM wsnlinks_comments
Getting field list for table wsnlinks_comments: id,linkid,posterid,postername,message,time,linkname,validated,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,lasteditby,catid,editreason,preventedit,inhidden,deleted,deletionreason,usernoteon,modnote,filefield,title,deletedby,parentids,disablesmilies,disablesig,icon,disablewsn,disablehtml,originalmessage,flagged,wysihtml,unrevised
Load time so far: 0.18 seconds.
Query: SHOW COLUMNS FROM wsnlinks_members
Getting field list for table wsnlinks_members: id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,images,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel,topics,posts,chatcolor,traderrating,invitessent,validatedemail,calsub,macros
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_helpcategory
Getting field list for table wsnlinks_helpcategory: id,name,numsubjects,priority
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_helpitem
Getting field list for table wsnlinks_helpitem: id,subject,helptext,priority,category
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_im
Getting field list for table wsnlinks_im: id,toid,fromid,message,time,isread,timeread,deleted
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_pm
Getting field list for table wsnlinks_pm: id,toid,fromid,timeread,message,subject,time,icon,folderid,deleted,attachment,flag,filefield,important,replyto,replied,sentdeleted,wysihtml
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_calendar
Getting field list for table wsnlinks_calendar: id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_trader
Getting field list for table wsnlinks_trader: id,ratingof,ratingby,value,summary,report,time,type,linkid,morecomments
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_invites
Getting field list for table wsnlinks_invites: id,inviter,invitee,time,usergroup,taken,code
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_searches
Getting field list for table wsnlinks_searches: id,value,memberid,catid,time
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_membergroups
Getting field list for table wsnlinks_membergroups: 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,numinv,allowugspec,validateemails,validatesponsorlinks
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_email
Getting field list for table wsnlinks_email: id,to,subject,message,headers,timesent,ip,replacement,mime
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_sessions
Getting field list for table wsnlinks_sessions: id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_ratings
Getting field list for table wsnlinks_ratings: id,votevalue,time,memberid,ip,custom,linkid,type
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_markup
Getting field list for table wsnlinks_markup: id,type,original,replacement,description,originalclose,replacementclose,sortorder
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_modlog
Getting field list for table wsnlinks_modlog: id,topicid,postid,type,nature,reason,moderatorid,source,destination,time,catid,memberid
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_attachments
Getting field list for table wsnlinks_attachments: id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid
Load time so far: 0.23 seconds.
Query: SHOW COLUMNS FROM wsnlinks_crons
Getting field list for table wsnlinks_crons: id,frequency,nextrun,filename,native
Load time so far: 0.23 seconds.
Load time so far: 0.24 seconds.
Query: UPDATE wsnlinks_members SET banned = '' WHERE banned = '0'
Load time so far: 0.26 seconds.
Query: UPDATE wsnlinks_switches SET value='0' WHERE name='chat'
Load time so far: 0.28 seconds.
Query: SELECT `name` FROM wsnlinks_switches WHERE id>0
Number of rows is 72
Load time so far: 0.28 seconds.
Query: SELECT `name`,`content` FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC
3080 links in 9 categories, with 320158 clicks and 0 comments by 1328 members. Directory last updated 23/03/07. Welcome 2, the newest member.
- my problem is with the '2' which has appeared as the newest member - it should be a username I think - this is the reason why I think there could be something wrong with the database - can I fix this so it all works again?
There's no error in what you've posted, so it's fine.
but there could be a problem with the database, or the layout of the tables becoming mis-aligned
No, there's no problem with the database or tables if it gives no errors anymore. An upgrade from a really old version could give errors simply because the current upgrade.php requests data which didn't exist back then. That your upgrade.php no longer gives errors means it added said data.
Welcome 2, the newest member.
Odd, I guess that field must've had been formated differently in 3.14, but if you don't want to wait for the next member to register (which will update it) then Admin -> Maintenance -> Regenerate Counters -> Regenerate Totals will set it properly.
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on Upgrading from 3.14
Member
Usergroup: Customer
Joined: Nov 19, 2003
Total Topics: 21
Total Comments: 35
Hi
I was just upgrading my WSNL version 3.14 to the very latest - everything appears to have worked. However, when I first went into the upgrade.php script, it gave the following warnings:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /secure/c/(mywebsiteurl)/links/databases/mysql.php on line 19
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /secure/c/(mywebsiteurl)/links/databases/mysql.php on line 22
Although I went through with the upgrade and it appears to have worked, I am concerned about these error messages and if they are a hidden problem which could cause problems later.
OK, there's something wrong with the database - I'm getting more of these errors, and some information is not displaying correctly such as the latest new member which it says is '2' but when you get information is actually a very old record.
Also - I'm always very worried about security - while I was discovering all these problems there were guests coming onto the site - could they have gained access to members details - or got into anything because the database / system is not right? I have now put the system into maintenance mode - will this prevent further possiblility of anyone getting into the system - including members until we've solved the problems?
Thank you for your help :-)
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Post the debug output (check the box for it on upgrade).
If upgrade.php does not give errors anymore, then nothing's wrong.
Also - I'm always very worried about security
Er, if you were worried about security you wouldn't have been using 3.14. I emailed the critical security update notice more than a year ago, anybody using pre-3.3.21 versions (and especially pre 3.3.8 versions) should expect to have been hacked long ago. You should check for any subdirectories where somebody might be hosting illegal content, or suspicious files (like c99.php, that's the most common PHP shell which gives the hackers complete remote control, and was seen used in these exploits).
In general, anyone using any 2 year old software without downloading updates is naturally prone to being hacked... if there isn't a security fix for 2 years it usually means the project is dead, not that there weren't any holes.
Also, of course, upgrades will become less reliable with really old versions like this -- I haven't tested an upgrade from 3.14 in years (and actually I don't have a copy of 3.14) so I don't know what issues it can bring.
could they have gained access to members details
As you can see by looking at your site, no membership details are listed. There's no situation which would call for printing out the database to the screen, regardless of errors, so it never happens.
I have now put the system into maintenance mode
I've no idea what "maintenance mode" is, it must be some sort of host-specific option, but I'm sure it's pointless in this case. A current broken version would be infinitely more secure than what you've been running the last year plus.
The listing of errors can reveal file paths, which some people prefer not to, but letting someone know your file path only helps them in exploiting existing security holes (especially on shared hosts I believe), it doesn't open new ones (I don't mind saying this file is /home/wmaster/public_html/forums/comments.php). You can set debug mode to suppress errors if you wish.
There's a list of security tips at scripts.webmastersite.net/w...ues_Notes_and_Tips-64.html
Member
Usergroup: Customer
Joined: Nov 19, 2003
Total Topics: 21
Total Comments: 35
Hi
Er, if you were worried about security you wouldn't have been using 3.14. I emailed the critical security update notice more than a year ago, anybody using pre-3.3.21 versions (and especially pre 3.3.8 versions) should expect to have been hacked long ago. You should check for any subdirectories where somebody might be hosting illegal content, or suspicious files (like c99.php, that's the most common PHP shell which gives the hackers complete remote control, and was seen used in these exploits).
Yeah - sorry about that! It's been a while since I took a proper look at the links system! I need to try to get it back up and properly running, and this time I'd like to try and use the paid for system too.
I will attempt to run upgrade.php again and see if it comes up with any errors with the box checked. Are you saying that from your point-of-view, if it doesn't then there's nothing wrong with the function of the system - but there could be a problem with the database, or the layout of the tables becoming mis-aligned? If nothing works, I might attempt a clean install of the links system, and then try to import the database - but I am concerned about doing this because I'm not sure of the settings I should use to save the database file to my computer in order to be able to re-import it back into WSNL.
I've no idea what "maintenance mode" is...
Sorry - I probably used the wrong terminology...I meant that I've just checked the box which makes the system display 'The Links Directory is currently offline. Please be patient and check back soon.' and doesn't allow anyone except admin to log in.
Thank you for your help.
Member
Usergroup: Customer
Joined: Nov 19, 2003
Total Topics: 21
Total Comments: 35
Hi
For you interest, here's what the upgrade.php script returned when I tried it again:
____________________________________________________________________
Load time so far: 0.11 seconds.
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
Load time so far: 0.12 seconds.
Query: UPDATE wsnlinks_settings SET content='206' WHERE name='highestcatindex'
Load time so far: 0.12 seconds.
Query: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0
Number of rows is 72
Query: SHOW COLUMNS FROM wsnlinks_links
Getting field list for table wsnlinks_links: id,title,url,description,rating,votes,validated,recipurl,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,hitsin,voterips,voterids,lastedit,type,filename,filetitle,notify,suspect,downloads,pendingedit,funds,suspended,recipwith,alias,expire,ip,inalbum,typeorder,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,pollid,posticon,savedby,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnlinks_categories
Getting field list for table wsnlinks_categories: 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,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,linksperpage,wysihtml,numonline
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnlinks_members
Getting field list for table wsnlinks_members: id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,images,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel,topics,posts,chatcolor,traderrating,invitessent,validatedemail,calsub,macros
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnlinks_membergroups
Getting field list for table wsnlinks_membergroups: 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,numinv,allowugspec,validateemails,validatesponsorlinks
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnlinks_email
Getting field list for table wsnlinks_email: id,to,subject,message,headers,timesent,ip,replacement,mime
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnlinks_sessions
Getting field list for table wsnlinks_sessions: id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnlinks_ratings
Getting field list for table wsnlinks_ratings: id,votevalue,time,memberid,ip,custom,linkid,type
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnlinks_markup
Getting field list for table wsnlinks_markup: id,type,original,replacement,description,originalclose,replacementclose,sortorder
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnlinks_modlog
Getting field list for table wsnlinks_modlog: id,topicid,postid,type,nature,reason,moderatorid,source,destination,time,catid,memberid
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnlinks_crons
Getting field list for table wsnlinks_crons: id,frequency,nextrun,filename,native
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnlinks_calendar
Getting field list for table wsnlinks_calendar: id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnlinks_im
Getting field list for table wsnlinks_im: id,toid,fromid,message,time,isread,timeread,deleted
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnlinks_searches
Getting field list for table wsnlinks_searches: id,value,memberid,catid,time
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnlinks_comments
Getting field list for table wsnlinks_comments: id,linkid,posterid,postername,message,time,linkname,validated,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,lasteditby,catid,editreason,preventedit,inhidden,deleted,deletionreason,usernoteon,modnote,filefield,title,deletedby,parentids,disablesmilies,disablesig,icon,disablewsn,disablehtml,originalmessage,flagged,wysihtml,unrevised
Load time so far: 0.13 seconds.
Load time so far: 0.13 seconds.
Query: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder
Number of rows is 4
Query: SHOW COLUMNS FROM wsnlinks_attachments
Getting field list for table wsnlinks_attachments: id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid
Load time so far: 0.14 seconds.
Load time so far: 0.14 seconds.
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`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks` FROM wsnlinks_membergroups WHERE id>0
Load time so far: 0.15 seconds.
Query: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`images`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros` FROM wsnlinks_members WHERE id=1 AND validated=1
Load time so far: 0.16 seconds.
Query: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder
Number of rows is 13
Query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE
Load time so far: 0.16 seconds.
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
Query: UNLOCK TABLES
Query: SHOW COLUMNS FROM wsnlinks_links
Getting field list for table wsnlinks_links: id,title,url,description,rating,votes,validated,recipurl,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,hitsin,voterips,voterids,lastedit,type,filename,filetitle,notify,suspect,downloads,pendingedit,funds,suspended,recipwith,alias,expire,ip,inalbum,typeorder,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,pollid,posticon,savedby,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime
Load time so far: 0.18 seconds.
Query: SHOW COLUMNS FROM wsnlinks_categories
Getting field list for table wsnlinks_categories: 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,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,linksperpage,wysihtml,numonline
Load time so far: 0.18 seconds.
Query: SHOW COLUMNS FROM wsnlinks_comments
Getting field list for table wsnlinks_comments: id,linkid,posterid,postername,message,time,linkname,validated,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,lasteditby,catid,editreason,preventedit,inhidden,deleted,deletionreason,usernoteon,modnote,filefield,title,deletedby,parentids,disablesmilies,disablesig,icon,disablewsn,disablehtml,originalmessage,flagged,wysihtml,unrevised
Load time so far: 0.18 seconds.
Query: SHOW COLUMNS FROM wsnlinks_members
Getting field list for table wsnlinks_members: id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,images,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel,topics,posts,chatcolor,traderrating,invitessent,validatedemail,calsub,macros
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_helpcategory
Getting field list for table wsnlinks_helpcategory: id,name,numsubjects,priority
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_helpitem
Getting field list for table wsnlinks_helpitem: id,subject,helptext,priority,category
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_im
Getting field list for table wsnlinks_im: id,toid,fromid,message,time,isread,timeread,deleted
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_pm
Getting field list for table wsnlinks_pm: id,toid,fromid,timeread,message,subject,time,icon,folderid,deleted,attachment,flag,filefield,important,replyto,replied,sentdeleted,wysihtml
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_calendar
Getting field list for table wsnlinks_calendar: id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_trader
Getting field list for table wsnlinks_trader: id,ratingof,ratingby,value,summary,report,time,type,linkid,morecomments
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_invites
Getting field list for table wsnlinks_invites: id,inviter,invitee,time,usergroup,taken,code
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_searches
Getting field list for table wsnlinks_searches: id,value,memberid,catid,time
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_membergroups
Getting field list for table wsnlinks_membergroups: 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,numinv,allowugspec,validateemails,validatesponsorlinks
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_email
Getting field list for table wsnlinks_email: id,to,subject,message,headers,timesent,ip,replacement,mime
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_sessions
Getting field list for table wsnlinks_sessions: id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_ratings
Getting field list for table wsnlinks_ratings: id,votevalue,time,memberid,ip,custom,linkid,type
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_markup
Getting field list for table wsnlinks_markup: id,type,original,replacement,description,originalclose,replacementclose,sortorder
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_modlog
Getting field list for table wsnlinks_modlog: id,topicid,postid,type,nature,reason,moderatorid,source,destination,time,catid,memberid
Load time so far: 0.19 seconds.
Query: SHOW COLUMNS FROM wsnlinks_attachments
Getting field list for table wsnlinks_attachments: id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid
Load time so far: 0.23 seconds.
Query: SHOW COLUMNS FROM wsnlinks_crons
Getting field list for table wsnlinks_crons: id,frequency,nextrun,filename,native
Load time so far: 0.23 seconds.
Load time so far: 0.24 seconds.
Query: UPDATE wsnlinks_members SET banned = '' WHERE banned = '0'
Load time so far: 0.26 seconds.
Query: UPDATE wsnlinks_switches SET value='0' WHERE name='chat'
Load time so far: 0.28 seconds.
Query: SELECT `name` FROM wsnlinks_switches WHERE id>0
Number of rows is 72
Load time so far: 0.28 seconds.
Query: SELECT `name`,`content` FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC
Administrative account verified... starting upgrade.
Done adding fields.
No new switches need to be added.
Added these items to default:
Done appending languages.
Attempting to CHMOD new templates for you...
Updating stylesheets...
Upgrade complete. Have a look at what changed above, then check your settings in case there are new options you can make use of.
___________________________________________________________
I can't see anything errored out - but I don't really know what I'm looking at here!
Member
Usergroup: Customer
Joined: Nov 19, 2003
Total Topics: 21
Total Comments: 35
Hi
Sorry, one final bit of info:
The front page at the top reads the following:
3080 links in 9 categories, with 320158 clicks and 0 comments by 1328 members. Directory last updated 23/03/07.
Welcome 2, the newest member.
- my problem is with the '2' which has appeared as the newest member - it should be a username I think - this is the reason why I think there could be something wrong with the database - can I fix this so it all works again?
Many thanks for your help - sorry to be a pain!
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
There's no error in what you've posted, so it's fine.
but there could be a problem with the database, or the layout of the tables becoming mis-aligned
No, there's no problem with the database or tables if it gives no errors anymore. An upgrade from a really old version could give errors simply because the current upgrade.php requests data which didn't exist back then. That your upgrade.php no longer gives errors means it added said data.
Welcome 2, the newest member.
Odd, I guess that field must've had been formated differently in 3.14, but if you don't want to wait for the next member to register (which will update it) then Admin -> Maintenance -> Regenerate Counters -> Regenerate Totals will set it properly.