database error: WSN Support

WSN Support » WSN Links » database error » database error

database error

Version: 2.56

database error

Moe
Beginner

Usergroup: Customer
Joined: Aug 31, 2003
Total Topics: 2
Total Posts: 3

Posted 06/24/05 - 03:53 PM:	#1
I had to move to a different server, What I did was install 2.56 as a new install, then restored a backup of the data base I had saved from the old server. Do I need to change something. getting this, with debug showing to admin only... 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 FROM wsnlinks_membergroups WHERE id>0 ; Performing query: SELECT id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail FROM wsnlinks_members WHERE id=1 AND validated=1 ; 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 FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 AND isalbum=0 ORDER BY name ASC ; Performing query: SELECT id FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 ; Unknown column 'isalbum' in 'where clause' Number of rows is 26 for Resource id #32 Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/megaloma/public_html/classes/database.php on line 53 Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/megaloma/public_html/classes/database.php on line 53 Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/megaloma/public_html/classes/database.php on line 53

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6339

Posted 06/24/05 - 11:03 PM:	#2
What you installed appears to run on different fields than the database you're using.... particularly there it mentions there's no 'isalbum' category field. Have you tried running upgrade.php? Anyhow, version 2.56 was released December 19th 2003 so here in the middle of 2005 there's not a lot I can say about it.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

You don't have permission to post.

Please login or register.