Problem after upgrade: WSN Support Forums

Problem after upgrade
SQL Error in al pages and can't open admin

Comments on Problem after upgrade

•eric0524 Experienced Usergroup: Member Joined: Jun 11, 2006 Total Topics: 15 Total Comments: 55	•eric0524 #1 - Quote - Permalink Posted Mar 16, 2007 - 1:54 PM: 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
•Paul developer Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 61 Total Comments: 7867	•Paul #2 - Quote - Permalink Posted Mar 16, 2007 - 5:53 PM: You haven't said what you're upgrading from. I'll guess you're upgrading from 2.x. Open your config.php, find $chattable = 'wsngallery_chat'; and delete that. Then re-run upgrade.php.
•eric0524 Experienced Usergroup: Member Joined: Jun 11, 2006 Total Topics: 15 Total Comments: 55	•eric0524 #3 - Quote - Permalink Posted Mar 17, 2007 - 7:50 AM: I had to come up with a solution quicker so I created a table called wsngallery_chat with one field and the saved it. Now it seems to be working fine, althought I have not done a major test. I run it throught the ringer an let you know if I find anything else.
•eric0524 Experienced Usergroup: Member Joined: Jun 11, 2006 Total Topics: 15 Total Comments: 55	•eric0524 #4 - Quote - Permalink Posted Mar 17, 2007 - 9:15 AM: As I was logged in as admin, I clicked to edit a file that was missing a thumbnail (there are only a few), I didn't make any changes but I clicked save in hopes it would re-create the thumbnail and I got a fatal error. Here is the debug code. Load time so far: 0.05 seconds. Query: SELECT `name`,`content` FROM wsngallery_settings WHERE id>0 ORDER BY id ASC Load time so far: 0.14 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.14 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.15 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.15 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.15 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.15 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.15 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 Getting field list for table wsngallery_chat: name Load time so far: 0.15 seconds. 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.15 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.16 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 Query: LOCK TABLES wsngallery_email WRITE, wsngallery_links WRITE, wsngallery_categories WRITE, wsngallery_members WRITE Load time so far: 0.18 seconds. Query: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsngallery_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10 Number of rows is 0 Query: UNLOCK TABLES Load time so far: 0.22 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 id=1213 LIMIT 0,1 Load time so far: 0.22 seconds. Query: SELECT `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` FROM wsngallery_categories WHERE id=3 Fatal error: Call to a member function on a non-object in /home/vhosts/wwwroot/showyour.com/photoswap/edit.php on line 456
•eric0524 Experienced Usergroup: Member Joined: Jun 11, 2006 Total Topics: 15 Total Comments: 55	•eric0524 #5 - Quote - Permalink Posted Mar 17, 2007 - 10:19 AM: BTW - I did like you said and deleted that part in the config file and then re-ran the upgrade.php but it still has the above problem when I try to edit or regenerate all, not sure where it's crashing in the regenerate but it's the same error. It's only the ne wthumbnails that are not showing up. Also I tried to upload an FLV file and it won't play at all. I have everything installed that the reuiqrments ask for except lame but that should not stop an FLV from playing. It doesn't load the player at all. Do I need to put that code in a template? And if so which ones, I am not understanding the flv instructions completely (maybe has something to do with a St Patties day Biker party last night).
•Paul developer Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 61 Total Comments: 7867	•Paul #6 - Quote - Permalink Posted Mar 18, 2007 - 8:28 AM: I did like you said and deleted that part in the config file It won't be able to add the table if you already have it there, so you'd have to delete it first. The table isn't actually important to WSN Gallery though so it doesn't matter. Fatal error: Call to a member function on a non-object in /home/vhosts/wwwroot/showyour.com/photoswap/edi t.php on line 456 Re-download and overwrite edit.php. I caught that a couple hours after the release but I guess you'd already downloaded it. It's only the ne wthumbnails that are not showing up. Go to the dead thumbnail url and add &debug=1 to the end, post the output. For example thumbnail.php?id=3203&attachid=3153&debug=1 Also I tried to upload an FLV file and it won't play at all. I have everything installed that the reuiqrments ask for except lame but that should not stop an FLV from playing. Not having lame will prevent sound from working. Also, you're supposed to be uploading other file types -- WMV, MOV etc -- and letting it convert to FLV. I haven't tested a direct FLV upload (though I'd think it'd still work). It doesn't load the player at all. Do I need to put that code in a template? Even if ffmpeg weren't working the player outline would still load. I have the player in the "image details" template if you're using the current one, if you're using an older template you'll need to update it.
•eric0524 Experienced Usergroup: Member Joined: Jun 11, 2006 Total Topics: 15 Total Comments: 55	•eric0524 #7 - Quote - Permalink Posted Mar 18, 2007 - 8:41 AM: Here is one that the whole picture ddoes not show up. I will do the thumbnail one in the next message. Load time so far: 0.05 seconds. Query: SELECT `name`,`content` FROM wsngallery_settings WHERE id>0 ORDER BY id ASC Load time so far: 0.14 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.14 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.15 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.15 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.15 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.15 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.15 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 Getting field list for table wsngallery_chat: name Load time so far: 0.15 seconds. 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.15 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.16 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.18 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 id=1273 LIMIT 0,1 Load time so far: 0.19 seconds. Query: SELECT `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` FROM wsngallery_categories WHERE id=4 Query: LOCK TABLES wsngallery_email WRITE, wsngallery_links WRITE, wsngallery_categories WRITE, wsngallery_members WRITE Load time so far: 0.2 seconds. Query: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsngallery_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10 Number of rows is 0 Query: UNLOCK TABLES Setting cookie with name returnto, value www.showyour.com/photoswap/...ts.php?id=1273&debug=1 and duration 0 Warning: Cannot modify header information - headers already sent by (output started at /home/vhosts/wwwroot/showyour.com/photoswap/classes/database.php:248) in /home/vhosts/wwwroot/showyour.com/photoswap/commonfuncs.php on line 713 Warning: Cannot modify header information - headers already sent by (output started at /home/vhosts/wwwroot/showyour.com/photoswap/classes/database.php:248) in /home/vhosts/wwwroot/showyour.com/photoswap/commonfuncs.php on line 717 Load time so far: 0.23 seconds. Query: SELECT `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` FROM wsngallery_comments WHERE linkid=1273 AND validated=1 AND hide=0 AND deleted=0 ORDER BY time ASC LIMIT 0,15 Number of rows is 0 Freeing Resource id #58 Load time so far: 0.23 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 deleted=0 AND validated=1 AND alias=0 AND inalbum=0 AND inhidden=0 AND hide=0 AND MATCH (title) AGAINST('my bra') and id != 1273 LIMIT 0,5 Number of rows is 0 Load time so far: 0.23 seconds. Query: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`ownerip`,`validated`,`catid` FROM wsngallery_attachments WHERE type='link' AND validated=1 AND deleted=0 AND objectid=1273 ORDER BY time ASC Number of rows is 1 Load time so far: 0.24 seconds. Query: SELECT `catid` FROM wsngallery_links WHERE alias=1273 AND validated=1 AND deleted=0 Number of rows is 0 Load time so far: 0.26 seconds. Query: SELECT COUNT(id) FROM wsngallery_comments WHERE linkid=1273 AND deleted=1 Count is 0 Load time so far: 0.26 seconds. Query: SELECT COUNT(id) FROM wsngallery_links WHERE deleted=0 AND validated=1 AND inalbum=0 AND inhidden=0 AND alias=0 AND hide=0 AND MATCH (title) AGAINST('my bra') and id != 1273 Count is 0 Load time so far: 0.26 seconds. Query: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`ownerip`,`validated`,`catid` FROM wsngallery_attachments WHERE deleted=0 AND validated=1 AND type='link' AND objectid='1273' ORDER BY time ASC LIMIT 0,1 Number of rows is 1 Load time so far: 0.27 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=699 Number of rows is 1 Warning: Cannot modify header information - headers already sent by (output started at /home/vhosts/wwwroot/showyour.com/photoswap/classes/database.php:248) in /home/vhosts/wwwroot/showyour.com/photoswap/end.php on line 145 Load time so far: 0.4 seconds. Query: SELECT COUNT(id) FROM wsngallery_links WHERE viewers LIKE '%[END]1[,]%' or viewers LIKE '1[,]%' Count is 507 Load time so far: 0.44 seconds. Query: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility` FROM wsngallery_sessions WHERE time > 1174232292 AND (threadid=1273 AND memberid>0) ORDER BY time DESC LIMIT 0,100 Number of rows is 0 Load time so far: 0.66 seconds. Query: SELECT `inchat`,`lastchat` FROM wsngallery_sessions WHERE memberid=1 LIMIT 0,1 Number of rows is 1 Load time so far: 0.66 seconds. Query: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility` FROM wsngallery_sessions WHERE memberid=1 Number of rows is 1 Load time so far: 0.66 seconds. Query: UPDATE wsngallery_sessions SET id='40018', memberid='1', location='http://www.showyour.com/photoswap/comments.php?id=1273&debug=1', time='1174232352', ip='71.40.151.100', browser='Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2', starttime='1174232256', catid='4', threadid='1273', areaname='Comment on Image', lastsearch='0', nopermission='0', inchat='0', name='admin', isrobot='0', lastchat='0', groupnamestyle='admincolor', acceptims='none', visibility='everyone' WHERE id=40018 <!-- Start Custom Header Information --> <!-- END SMILIES --> Click a smilie to insert it into your message. You may also use WSN Codes in your message. Members currently viewing this image: <!-- END TOPLIST 3 --> Previous Image \| Next Image Category List Tan Lines Wives/Girlfriends Tit Shots Down Blouse Braless Best of the Best Contests- Best blow jobs- Best Ass- Best Tit Shots- Best Shaved Pussy- Best Dildo- Best Bare Upskirts- Best Braless Shot- Best Darkest Lips- Biggest Nipples- Smallest Nipples- Best Tanlines- Longest Nipples Spread um Bare Upskirt Shaved Pussy Big Tits Tit Flashing Videos - Click on File Details and download- DIVX Tittie Flashing Videos- Download FREE DIVX Player- More Tit Shot Video Clips Great body Sexy Clothing Calendar Girl Contest Forums Free Dating/Swaping More Tit Shot Video Clips Self Portraits Sponcer Stuff Strip Screen Savers- Denisa The place to meet people <!-- Start Amatuer Match Local Chicks--> <!-- --> <!-- End amatuer match --> Contact the Administration Admin Control Panel \| Moderator Control Panel 45 total queries This page was created in 0.66 seconds Server Status: time since last reboot is 5 days, 18:23, 1 user, load average: 0.57, 0.23, 0.08 <!-- check ratio --> Downloads = 507 vs Uploads = 437
•eric0524 Experienced Usergroup: Member Joined: Jun 11, 2006 Total Topics: 15 Total Comments: 55	•eric0524 #8 - Quote - Permalink Posted Mar 18, 2007 - 8:42 AM: Here is the thumbnail one: Load time so far: 0.05 seconds. Query: SELECT `name`,`content` FROM wsngallery_settings WHERE id>0 ORDER BY id ASC Load time so far: 0.14 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.14 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.15 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.15 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.15 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.15 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.15 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.16 seconds. Query: SHOW COLUMNS FROM wsngallery_helpcategory Getting field list for table wsngallery_helpcategory: id,name,numsubjects,priority Load time so far: 0.16 seconds. Query: SHOW COLUMNS FROM wsngallery_helpitem Getting field list for table wsngallery_helpitem: id,subject,helptext,priority,category Load time so far: 0.16 seconds. Query: SHOW COLUMNS FROM wsngallery_chat Getting field list for table wsngallery_chat: name Load time so far: 0.16 seconds. 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.16 seconds. Query: SHOW COLUMNS FROM wsngallery_searches Getting field list for table wsngallery_searches: id,value,memberid,catid,time Load time so far: 0.16 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.16 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.18 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.19 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.19 seconds. Query: SELECT `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` FROM wsngallery_categories WHERE id=4 Query: LOCK TABLES wsngallery_email WRITE, wsngallery_links WRITE, wsngallery_categories WRITE, wsngallery_members WRITE Load time so far: 0.2 seconds. Query: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsngallery_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10 Number of rows is 0 Query: UNLOCK TABLES Load time so far: 0.22 seconds. Query: SELECT `id`,`frequency`,`filename`,`nextrun` FROM wsngallery_crons WHERE nextrun < 1174232495 ORDER BY id ASC LIMIT 0,1 Number of rows is 0 Load time so far: 0.22 seconds. Query: SELECT `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` FROM wsngallery_categories WHERE parent=4 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY numlinks DESC,name ASC LIMIT 0,75 Number of rows is 0 Load time so far: 0.23 seconds. Query: SELECT COUNT(id) FROM wsngallery_links WHERE catid=4 AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1174232495 Count is 77 Load time so far: 0.23 seconds. Query: UPDATE wsngallery_categories SET linkshere='77' WHERE id=4 Load time so far: 0.23 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 catid=4 AND hide=0 AND validated=1 AND effectivetime < 1174232495 AND type = '' ORDER BY time DESC,rating ASC LIMIT 0,5 Number of rows is 0 Load time so far: 0.23 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 catid=4 AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1174232495 AND type != '' ORDER BY time DESC,rating ASC LIMIT 0,15 Number of rows is 15 Load time so far: 0.24 seconds. Query: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`ownerip`,`validated`,`catid` FROM wsngallery_attachments WHERE deleted=0 AND validated=1 AND type='link' AND objectid='1273' ORDER BY time ASC LIMIT 0,1 Number of rows is 1 Load time so far: 0.26 seconds. Query: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`ownerip`,`validated`,`catid` FROM wsngallery_attachments WHERE deleted=0 AND validated=1 AND type='link' AND objectid='1181' ORDER BY time ASC LIMIT 0,1 Number of rows is 1 Load time so far: 0.28 seconds. Query: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`ownerip`,`validated`,`catid` FROM wsngallery_attachments WHERE deleted=0 AND validated=1 AND type='link' AND objectid='1177' ORDER BY time ASC LIMIT 0,1 Number of rows is 1 Load time so far: 0.3 seconds. Query: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`ownerip`,`validated`,`catid` FROM wsngallery_attachments WHERE deleted=0 AND validated=1 AND type='link' AND objectid='1176' ORDER BY time ASC LIMIT 0,1 Number of rows is 1 Load time so far: 0.31 seconds. Query: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`ownerip`,`validated`,`catid` FROM wsngallery_attachments WHERE deleted=0 AND validated=1 AND type='link' AND objectid='1175' ORDER BY time ASC LIMIT 0,1 Number of rows is 1 Load time so far: 0.33 seconds. Query: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`ownerip`,`validated`,`catid` FROM wsngallery_attachments WHERE deleted=0 AND validated=1 AND type='link' AND objectid='1060' ORDER BY time ASC LIMIT 0,1 Number of rows is 1 Load time so far: 0.35 seconds. Query: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`ownerip`,`validated`,`catid` FROM wsngallery_attachments WHERE deleted=0 AND validated=1 AND type='link' AND objectid='424' ORDER BY time ASC LIMIT 0,1 Number of rows is 1 Load time so far: 0.37 seconds. Query: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`ownerip`,`validated`,`catid` FROM wsngallery_attachments WHERE deleted=0 AND validated=1 AND type='link' AND objectid='423' ORDER BY time ASC LIMIT 0,1 Number of rows is 1 Load time so far: 0.39 seconds. Query: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`ownerip`,`validated`,`catid` FROM wsngallery_attachments WHERE deleted=0 AND validated=1 AND type='link' AND objectid='421' ORDER BY time ASC LIMIT 0,1 Number of rows is 1 Load time so far: 0.41 seconds. Query: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`ownerip`,`validated`,`catid` FROM wsngallery_attachments WHERE deleted=0 AND validated=1 AND type='link' AND objectid='420' ORDER BY time ASC LIMIT 0,1 Number of rows is 1 Load time so far: 0.43 seconds. Query: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`ownerip`,`validated`,`catid` FROM wsngallery_attachments WHERE deleted=0 AND validated=1 AND type='link' AND objectid='419' ORDER BY time ASC LIMIT 0,1 Number of rows is 1 Load time so far: 0.44 seconds. Query: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`ownerip`,`validated`,`catid` FROM wsngallery_attachments WHERE deleted=0 AND validated=1 AND type='link' AND objectid='210' ORDER BY time ASC LIMIT 0,1 Number of rows is 1 Load time so far: 0.46 seconds. Query: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`ownerip`,`validated`,`catid` FROM wsngallery_attachments WHERE deleted=0 AND validated=1 AND type='link' AND objectid='212' ORDER BY time ASC LIMIT 0,1 Number of rows is 1 Load time so far: 0.48 seconds. Query: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`ownerip`,`validated`,`catid` FROM wsngallery_attachments WHERE deleted=0 AND validated=1 AND type='link' AND objectid='213' ORDER BY time ASC LIMIT 0,1 Number of rows is 1 Load time so far: 0.5 seconds. Query: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`ownerip`,`validated`,`catid` FROM wsngallery_attachments WHERE deleted=0 AND validated=1 AND type='link' AND objectid='215' ORDER BY time ASC LIMIT 0,1 Number of rows is 1 Load time so far: 0.52 seconds. Query: SELECT COUNT(id) FROM wsngallery_links WHERE catid=4 AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1174232495 Count is 77 Load time so far: 0.52 seconds. Query: UPDATE wsngallery_categories SET linkshere='77' WHERE id=4 Setting cookie with name returnto, value index.php?action=displaycat&catid=4 and duration 1174233395 Warning: Cannot modify header information - headers already sent by (output started at /home/vhosts/wwwroot/showyour.com/photoswap/classes/database.php:248) in /home/vhosts/wwwroot/showyour.com/photoswap/commonfuncs.php on line 713 Warning: Cannot modify header information - headers already sent by (output started at /home/vhosts/wwwroot/showyour.com/photoswap/classes/database.php:248) in /home/vhosts/wwwroot/showyour.com/photoswap/commonfuncs.php on line 717 Warning: Cannot modify header information - headers already sent by (output started at /home/vhosts/wwwroot/showyour.com/photoswap/classes/database.php:248) in /home/vhosts/wwwroot/showyour.com/photoswap/end.php on line 145 Load time so far: 0.66 seconds. Query: SELECT COUNT(id) FROM wsngallery_links WHERE viewers LIKE '%[END]1[,]%' or viewers LIKE '1[,]%' Count is 507 Load time so far: 0.7 seconds. Query: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility` FROM wsngallery_sessions WHERE time > 1174232435 AND (catid=4 AND memberid>0) ORDER BY time DESC LIMIT 0,100 Number of rows is 0 Load time so far: 0.96 seconds. Query: SELECT `inchat`,`lastchat` FROM wsngallery_sessions WHERE memberid=1 LIMIT 0,1 Number of rows is 1 Load time so far: 0.96 seconds. Query: SELECT `memberid`,`starttime`,`time` FROM wsngallery_sessions WHERE time < 1174228895 AND memberid > 0 Number of rows is 0 Load time so far: 0.96 seconds. Query: DELETE FROM wsngallery_sessions WHERE time < 1174228895 Load time so far: 0.96 seconds. Query: UPDATE wsngallery_sessions SET starttime=0, time=0 WHERE time < 1174232435 Load time so far: 0.96 seconds. Query: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility` FROM wsngallery_sessions WHERE memberid=1 Number of rows is 1 Load time so far: 0.97 seconds. Query: UPDATE wsngallery_sessions SET id='40018', memberid='1', location='http://www.showyour.com/photoswap/index.php?action=displaycat&catid=4&debug=1', time='1174232495', ip='71.40.151.100', browser='Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2', starttime='1174232256', catid='4', threadid='215', areaname='Down Blouse', lastsearch='0', nopermission='0', inchat='0', name='admin', isrobot='0', lastchat='0', groupnamestyle='admincolor', acceptims='none', visibility='everyone' WHERE id=40018
•Paul developer Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 61 Total Comments: 7867	•Paul #9 - Quote - Permalink Posted Mar 18, 2007 - 9:19 AM: That can't have been a thumbnail debug since it had all your page content on it.
•eric0524 Experienced Usergroup: Member Joined: Jun 11, 2006 Total Topics: 15 Total Comments: 55	•eric0524 #10 - Quote - Permalink Posted Mar 18, 2007 - 9:30 AM: It's the category pages that are missing alot of thumbnails. I tried to do a regenerate everything after it runs for about 15-20 minuts I get: Fatal error: Call to a member function on a non-object in /home/vhosts/wwwroot/showyour.com/photoswap/classes/attachment.php on line 234 You can see the category with the missing thumbnails at http://www.showyour.com/photoswap/index.php?actio... This one is missing the whole page of thumbnails: http://www.showyour.com/photoswap/index.php?actio...
•Paul developer Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 61 Total Comments: 7867	•Paul #11 - Quote - Permalink Posted Mar 20, 2007 - 9:48 AM: www.showyour.com/photoswap/...1189&attachid=1149&debug=1 shows nothing, so there's nothing I can say without access: scripts.webmastersite.net/w...dex.php?section=inspection
•eric0524 Experienced Usergroup: Member Joined: Jun 11, 2006 Total Topics: 15 Total Comments: 55	•eric0524 #12 - Quote - Permalink Posted Mar 20, 2007 - 10:59 AM: Thats the problem it shows nothing..... The newest thumbnails are gone? I can't regenerate because when I grenerate everything it blows up 20 minuts down the road. Do you want me to pm you the admin password? I don't know what else to try?
•Paul developer Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 61 Total Comments: 7867	•Paul #13 - Quote - Permalink Posted Mar 21, 2007 - 3:49 PM: Click the second link in my post above.
•eric0524 Experienced Usergroup: Member Joined: Jun 11, 2006 Total Topics: 15 Total Comments: 55	•eric0524 #14 - Quote - Permalink Posted Mar 21, 2007 - 4:27 PM: I run the site 100% free I accedently bought 2 licences from you. I don't make any money to pay you to fix the upgrade. I found your first bug before you did.
•eric0524 Experienced Usergroup: Member Joined: Jun 11, 2006 Total Topics: 15 Total Comments: 55	•eric0524 #15 - Quote - Permalink Posted Mar 22, 2007 - 4:13 PM: Ok, I am obsessed with getting this bug resolved on regeneration (Fatal error: Call to a member function on a non-object in /home/vhosts/wwwroot/showyour.com/photoswap/classes/attachment.php on line 234) I re-uploaded all the new wsn files accept the logo.png file. Then I re-did the config.php file new with all the parameters and I remarked out the chat part. Then I ran the upgrade, leaving the smiles intaked. The upgrade went fine (again). Then I am still missing thumbnails and missing whole images, the image is there if you click on the image name, it just doen't show up in the page. So I did the regenerate all and got the attachments error. Then I went and did a chmod -R 777 . (in the attachments dir). Then did a regenerate and it crashed again. I don't mind giving you the login and everything I just don't have $40 per hour to pay you for a site that I run that does not make any money, it's just a true completly free site for adult to swap photo's. Do you have a script that I can run that makes sure there is not a permissions issue? The original upgrade was from the version I first bought from you back when ever to 3.0.11 I think it was probably 2.x.x Any help will be greatly appreciited by my 800+ users.

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