Webmastersite.net
Register Log In

Problem after upgrade

Title Problem after upgrade
Description SQL Error in al pages and can't open admin
Message Text I can't open the admin area. The gallery itself has mysql errors and not all thumbnails are there. I gues we should start with the admin area? I did www.showyour.com/photoswap/admin/index.php?debug=1 here is the out put. Load time so far: 0.04 seconds. Query: SELECT `name`,`content` FROM wsngallery_settings WHERE id>0 ORDER BY id ASC Load time so far: 0.13 seconds. Query: SELECT `id` FROM wsngallery_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.13 seconds. Query: UPDATE wsngallery_settings SET content='202' WHERE name='highestcatindex' Load time so far: 0.14 seconds. Query: SELECT `name`,`value` FROM wsngallery_switches WHERE id>0 Number of rows is 78 Query: SHOW COLUMNS FROM wsngallery_links Getting field list for table wsngallery_links: id,title,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,notify,downloads,pendingedit,imedit,suspect,funds,suspended,alias,expire,ip,inalbum,typeorder,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsouttemp,hitsintemp,origtype,importance,parentids,timesemailed,threadclosed,threadposters,lastposterid,lastpostername,ownername,deleted,deletionreason,movedto,deletedby,timevalidated,filefield,savedby,ownerip,url,recipurl,hitsin,recipwith,hitsinips,timesdead,message,sticky,pollid,posticon,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime Load time so far: 0.14 seconds. Query: SHOW COLUMNS FROM wsngallery_categories Getting field list for table wsngallery_categories: id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,isalbum,type,permissions,subscribers,subscriber,mixtypes,orderlinks,totalcomments,filetitle,filename,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.14 seconds. Query: SHOW COLUMNS FROM wsngallery_members Getting field list for table wsngallery_members: id,name,comments,time,usergroup,password,ip,totalhits,email,validated,template,language,totalbytes,images,lastattempt,avatarname,allowemail,albumid,signature,failedattempts,allowuseremail,stylesheet,funds,totalhitsin,notifyoflinks,lastvisit,timezone,links,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,topics,posts,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,chatcolor,traderrating,invitessent,validatedemail,newemail,calsub,macros Load time so far: 0.14 seconds. Query: SHOW COLUMNS FROM wsngallery_membergroups Getting field list for table wsngallery_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,bytespermem,canviewpages,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,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,bulkpms,issupermod,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,numinv,allowugspec,validateemails,validatesponsorlinks Load time so far: 0.14 seconds. Query: SHOW COLUMNS FROM wsngallery_email Getting field list for table wsngallery_email: id,to,subject,message,headers,timesent,ip,replacement,mime Load time so far: 0.14 seconds. Query: SHOW COLUMNS FROM wsngallery_sessions Getting field list for table wsngallery_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.15 seconds. Query: SHOW COLUMNS FROM wsngallery_ratings Getting field list for table wsngallery_ratings: id,votevalue,time,memberid,ip,custom,linkid,type Load time so far: 0.15 seconds. Query: SHOW COLUMNS FROM wsngallery_markup Getting field list for table wsngallery_markup: id,type,original,replacement,description,originalclose,replacementclose,sortorder Load time so far: 0.15 seconds. Query: SHOW COLUMNS FROM wsngallery_modlog Getting field list for table wsngallery_modlog: id,topicid,postid,type,nature, reason,moderatorid,source,destination,time,catid,memberid Load time so far: 0.15 seconds. Query: SHOW COLUMNS FROM wsngallery_crons Getting field list for table wsngallery_crons: id,frequency,nextrun,filename,native Load time so far: 0.15 seconds. Query: SHOW COLUMNS FROM wsngallery_calendar Getting field list for table wsngallery_calendar: id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time Load time so far: 0.15 seconds. Query: SHOW COLUMNS FROM wsngallery_helpcategory Getting field list for table wsngallery_helpcategory: id,name,numsubjects,priority Load time so far: 0.15 seconds. Query: SHOW COLUMNS FROM wsngallery_helpitem Getting field list for table wsngallery_helpitem: id,subject,helptext,priority,category Load time so far: 0.15 seconds. Query: SHOW COLUMNS FROM wsngallery_chat Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/vhosts/wwwroot/showyour.com/photoswap/databases/mysql.php on line 19 Getting field list for table wsngallery_chat: Load time so far: 0.15 seconds. Table 'wsn.wsngallery_chat' doesn't exist Query: SHOW COLUMNS FROM wsngallery_im Getting field list for table wsngallery_im: id,toid,fromid,message,time,isread,timeread,deleted Load time so far: 0.15 seconds. Query: SHOW COLUMNS FROM wsngallery_searches Getting field list for table wsngallery_searches: id,value,memberid,catid,time Load time so far: 0.15 seconds. Query: SHOW COLUMNS FROM wsngallery_comments Getting field list for table wsngallery_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.15 seconds. Query: SHOW COLUMNS FROM wsngallery_pm Getting field list for table wsngallery_pm: id,toid,fromid,timeread,message,subject,time,icon,folderid,deleted,attachment,flag,filefield,important,replyto,replied,sentdeleted,wysihtml Load time so far: 0.16 seconds. Load time so far: 0.16 seconds. Query: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM wsngallery_markup WHERE type='wsncode' ORDER BY sortorder Number of rows is 22 Query: SHOW COLUMNS FROM wsngallery_attachments Getting field list for table wsngallery_attachments: id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,ownerip,validated,catid Load time so far: 0.17 seconds. Load time so far: 0.17 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`,`bytespermem`,`canviewpages`,`candofulledit`,`candeletecategories`,`candeletecomments`,`candeleteowncategories`,`candeleteowncomments`,`candeletemembers`,`candeleteownmembers`,`canaliascategories`,`caneditvotes`,`numaliases`,`canviewvotes`,`canhideownlinks`,`canhideowncategories`,`canhideowncomments`,`canhidealllinks`,`canhideallcategories`,`canhideallcomments`,`canratecomments`,`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`,`bulkpms`,`issupermod`,`caneditownquotes`,`caneditallquotes`,`canviewchat`,`caneditownevents`,`caneditallevents`,`candeleteownevents`,`candeleteevents`,`cansubmitevents`,`validateevents`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks` FROM wsngallery_membergroups WHERE id>0 Load time so far: 0.17 seconds. Query: SELECT `id`,`name`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`email`,`validated`,`template`,`language`,`totalbytes`,`images`,`lastattempt`,`avatarname`,`allowemail`,`albumid`,`signature`,`failedattempts`,`allowuseremail`,`stylesheet`,`funds`,`totalhitsin`,`notifyoflinks`,`lastvisit`,`timezone`,`links`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`topics`,`posts`,`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`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`newemail`,`calsub`,`macros` FROM wsngallery_members WHERE id=1 AND validated=1 Load time so far: 0.18 seconds. Query: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsngallery_markup WHERE type='smilie' ORDER BY sortorder Number of rows is 17 Load time so far: 0.2 seconds. Query: SELECT `id`,`title`,`description`,`rating`,`votes`,`validated`,`catid`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`,`ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,`downloads`,`pendingedit`,`imedit`,`suspect`,`funds`,`suspended`,`alias`,`expire`,`ip`,`inalbum`,`typeorder`,`hitsoutips`,`lastcomment`,`related`,`inhidden`,`viewers`,`threadviewers`,`hitsouttemp`,`hitsintemp`,`origtype`,`importance`,`parentids`,`timesemailed`,`threadclosed`,`threadposters`,`lastposterid`,`lastpostername`,`ownername`,`deleted`,`deletionreason`,`movedto`,`deletedby`,`timevalidated`,`filefield`,`savedby`,`ownerip`,`url`,`recipurl`,`hitsin`,`recipwith`,`hitsinips`,`timesdead`,`message`,`sticky`,`pollid`,`posticon`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime` FROM wsngallery_links WHERE validated=0 AND alias=0 AND validatedemail=1 ORDER BY id ASC LIMIT 0,30 Number of rows is 0 Load time so far: 0.22 seconds. Query: SELECT COUNT(id) FROM wsngallery_modlog WHERE memberid>1 and nature='suggested ban' Count is 0 Load time so far: 0.31 seconds. Query: SELECT `content` FROM wsngallery_settings WHERE name='dirurl' The admin panel requires that your browser support frames, since this makes the navigation quicker and easier to use. (Of course, nothing visible to regular visitors ever uses frames.) 29 total queries This page was created in 0.3 seconds Server Status: time since last reboot is 3 days, 23:34, 1 user, load average: 0.01, 0.08, 0.13 closing database connection
Rating
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5
0/5 based on 0 votes.
Ownership eric0524
Views 2,078 views. Averaging 0 views per day.
Similar Topics
Submission Date Mar 16, 2007 - 3:54 PM