Webmastersite.net
Register Log In

Upgrading from 3.14
Database errors

Comments on Upgrading from 3.14

wsnl
Member

Usergroup: Customer
Joined: Nov 19, 2003

Total Topics: 21
Total Comments: 35
wsnl
Posted Mar 30, 2007 - 12:32 PM:

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 :-)
Paul
developer

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

Total Topics: 61
Total Comments: 7868
Paul
Posted Mar 31, 2007 - 11:37 AM:

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.

There's a list of security tips at scripts.webmastersite.net/w...ues_Notes_and_Tips-64.html
wsnl
Member

Usergroup: Customer
Joined: Nov 19, 2003

Total Topics: 21
Total Comments: 35
wsnl
Posted Apr 01, 2007 - 9:56 AM:

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.
wsnl
Member

Usergroup: Customer
Joined: Nov 19, 2003

Total Topics: 21
Total Comments: 35
wsnl
Posted Apr 01, 2007 - 10:54 AM:

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!
wsnl
Member

Usergroup: Customer
Joined: Nov 19, 2003

Total Topics: 21
Total Comments: 35
wsnl
Posted Apr 01, 2007 - 11:02 AM:

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

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

Total Topics: 61
Total Comments: 7868
Paul
Posted Apr 01, 2007 - 4:33 PM:

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.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



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