WebmasterSite.net: PHP scripts to enable your creativity
WSN Links PHP Directory Software
PHP Scripts Webmaster Links Support Forums


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

Version: Latest?
Example URL: www.showyour.com/photoswap/index.php
printPrint


Page: 1 2

Problem after upgrade
eric0524
Experienced

Usergroup: Member
Joined: Jun 11, 2006
Total Topics: 15
Total Posts: 55
Posted 03/16/07 - 01:54 PM:
quote post
#1
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,fu nds,suspended,alias,expire,ip,inalbum,typeorder,hitsoutips,l astcomment,related,inhidden,viewers,threadviewers,hitsouttem p,hitsintemp,origtype,importance,parentids,timesemailed,thre adclosed,threadposters,lastposterid,lastpostername,ownername ,deleted,deletionreason,movedto,deletedby,timevalidated,file field,savedby,ownerip,url,recipurl,hitsin,recipwith,hitsinip s,timesdead,message,sticky,pollid,posticon,validatedemail,un paid,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,parent ids,numlinks,hide,lastlinktime,custom,lastedit,moderators,he aderinfo,related,numsub,isalbum,type,permissions,subscribers ,subscriber,mixtypes,orderlinks,totalcomments,filetitle,file name,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,l inkcols,dmozpath,sponsorlinks,views,customwrap,deleted,reqli nks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,l astpostername,lastcommenttime,lastthreadid,lastthreadtitle,l inkshere,unvalidatedlinks,unvalidatedcomments,actaslink,coun tposts,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,av atarname,allowemail,albumid,signature,failedattempts,allowus eremail,stylesheet,funds,totalhitsin,notifyoflinks,lastvisit ,timezone,links,rating,pmfolders,notifyofpms,acceptpms,cooki eduration,banned,topics,posts,location,homepage,occupation,b io,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ig nored,isonline,acceptims,adminpermissions,referrer,groupreve rttime,grouprevertto,moderationpm,secondarygroups,linksperpa ge,commentsperpage,shouts,customtitle,shoutban,topicbans,for umbans,visibility,birthdate,lastsession,interests,posteditor ,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastm odnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe ,notifymethod,showavatars,showsigs,warninglevel,chatcolor,tr aderrating,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,canem ail,validatecats,validatecomments,validatelinks,validateedit s,cansubmitlinks,cansubmitcategories,cansubmitcomments,caned itownlinks,caneditowncategories,caneditowncomments,caneditow nprofile,caneditalllinks,caneditallcategories,caneditallcomm ents,caneditallprofiles,candownloadfiles,canupload,canviewip ,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canal ias,cancopy,candeleteown,candeleteall,bytespermem,canviewpag es,candofulledit,candeletecategories,candeletecomments,cande leteowncategories,candeleteowncomments,candeletemembers,cand eleteownmembers,canaliascategories,caneditvotes,numaliases,c anviewvotes,canhideownlinks,canhideowncategories,canhideownc omments,canhidealllinks,canhideallcategories,canhideallcomme nts,canratecomments,canpm,canim,canharddelete,limitpms,limit pmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candel eteownpolls,caneditpolls,caneditownpolls,attachperpost,attac hperpm,canviewshouts,caneditshouts,caneditownshouts,candelet eshouts,candeleteownshouts,cansubmitshouts,canpollvote,custo mtitle,canviewinvisible,namestyle,canpmimportant,canviewmodl og,isleader,cansubmitquotes,validatequotes,candeletequotes,c andeleteownquotes,canreport,canusesearch,attachperlink,valid ateattachments,bulkpms,issupermod,caneditownquotes,canedital lquotes,canviewchat,caneditownevents,caneditallevents,candel eteownevents,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,threadi d,areaname,lastsearch,nopermission,inchat,name,isrobot,lastc hat,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,repla cementclose,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,dest ination,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,r eminded,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/mys ql.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,validate d,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,las teditby,catid,editreason,preventedit,inhidden,deleted,deleti onreason,usernoteon,modnote,filefield,title,deletedby,parent ids,disablesmilies,disablesig,icon,disablewsn,disablehtml,or iginalmessage,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,d eleted,attachment,flag,filefield,important,replyto,replied,s entdeleted,wysihtml

Load time so far: 0.16 seconds.


Load time so far: 0.16 seconds.


Query: SELECT `id`,`type`,`original`,`replacement`,`description`,`original close`,`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,me mberid,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`,`valid atelinks`,`validateedits`,`cansubmitlinks`,`cansubmitcategor ies`,`cansubmitcomments`,`caneditownlinks`,`caneditowncatego ries`,`caneditowncomments`,`caneditownprofile`,`caneditallli nks`,`caneditallcategories`,`caneditallcomments`,`caneditall profiles`,`candownloadfiles`,`canupload`,`canviewip`,`limitl inks`,`canemailmembers`,`canusehtml`,`limitlinksdaily`,`cana lias`,`cancopy`,`candeleteown`,`candeleteall`,`bytespermem`, `canviewpages`,`candofulledit`,`candeletecategories`,`candel etecomments`,`candeleteowncategories`,`candeleteowncomments` ,`candeletemembers`,`candeleteownmembers`,`canaliascategorie s`,`caneditvotes`,`numaliases`,`canviewvotes`,`canhideownlin ks`,`canhideowncategories`,`canhideowncomments`,`canhidealll inks`,`canhideallcategories`,`canhideallcomments`,`canrateco mments`,`canpm`,`canim`,`canharddelete`,`limitpms`,`limitpms daily`,`canviewdeleted`,`cansubmitpolls`,`candeletepolls`,`c andeleteownpolls`,`caneditpolls`,`caneditownpolls`,`attachpe rpost`,`attachperpm`,`canviewshouts`,`caneditshouts`,`canedi townshouts`,`candeleteshouts`,`candeleteownshouts`,`cansubmi tshouts`,`canpollvote`,`customtitle`,`canviewinvisible`,`nam estyle`,`canpmimportant`,`canviewmodlog`,`isleader`,`cansubm itquotes`,`validatequotes`,`candeletequotes`,`candeleteownqu otes`,`canreport`,`canusesearch`,`attachperlink`,`validateat tachments`,`bulkpms`,`issupermod`,`caneditownquotes`,`canedi tallquotes`,`canviewchat`,`caneditownevents`,`caneditalleven ts`,`candeleteownevents`,`candeleteevents`,`cansubmitevents` ,`validateevents`,`numinv`,`allowugspec`,`validateemails`,`v alidatesponsorlinks` FROM wsngallery_membergroups WHERE id>0

Load time so far: 0.17 seconds.


Query: SELECT `id`,`name`,`comments`,`time`,`usergroup`,`password`,`ip`,`t otalhits`,`email`,`validated`,`template`,`language`,`totalby tes`,`images`,`lastattempt`,`avatarname`,`allowemail`,`album id`,`signature`,`failedattempts`,`allowuseremail`,`styleshee t`,`funds`,`totalhitsin`,`notifyoflinks`,`lastvisit`,`timezo ne`,`links`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,` cookieduration`,`banned`,`topics`,`posts`,`location`,`homepa ge`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`, `timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acce ptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grou prevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,` commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicban s`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`inter ests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modno tes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`or deralbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`s howavatars`,`showsigs`,`warninglevel`,`chatcolor`,`traderrat ing`,`invitessent`,`validatedemail`,`newemail`,`calsub`,`mac ros` 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`,`cat id`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`, `ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,` downloads`,`pendingedit`,`imedit`,`suspect`,`funds`,`suspend ed`,`alias`,`expire`,`ip`,`inalbum`,`typeorder`,`hitsoutips` ,`lastcomment`,`related`,`inhidden`,`viewers`,`threadviewers `,`hitsouttemp`,`hitsintemp`,`origtype`,`importance`,`parent ids`,`timesemailed`,`threadclosed`,`threadposters`,`lastpost erid`,`lastpostername`,`ownername`,`deleted`,`deletionreason `,`movedto`,`deletedby`,`timevalidated`,`filefield`,`savedby `,`ownerip`,`url`,`recipurl`,`hitsin`,`recipwith`,`hitsinips `,`timesdead`,`message`,`sticky`,`pollid`,`posticon`,`valida tedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid `,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`fee dcache`,`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


_____________________
----------------------------
www.saltwatersportswear.com - the largest selection of t-shirts
www.showyour.com/photoswap
Paul
Administrator
Avatar

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 49
Total Posts: 5539
Posted 03/16/07 - 05:53 PM:
quote post
#2
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.

Edited by Paul on 03/16/07 - 05:55 PM
eric0524
Experienced

Usergroup: Member
Joined: Jun 11, 2006
Total Topics: 15
Total Posts: 55
Posted 03/17/07 - 07:50 AM:
quote post
#3
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.

_____________________
----------------------------
www.saltwatersportswear.com - the largest selection of t-shirts
www.showyour.com/photoswap
eric0524
Experienced

Usergroup: Member
Joined: Jun 11, 2006
Total Topics: 15
Total Posts: 55
Posted 03/17/07 - 09:15 AM:
quote post
#4
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,fu nds,suspended,alias,expire,ip,inalbum,typeorder,hitsoutips,l astcomment,related,inhidden,viewers,threadviewers,hitsouttem p,hitsintemp,origtype,importance,parentids,timesemailed,thre adclosed,threadposters,lastposterid,lastpostername,ownername ,deleted,deletionreason,movedto,deletedby,timevalidated,file field,savedby,ownerip,url,recipurl,hitsin,recipwith,hitsinip s,timesdead,message,sticky,pollid,posticon,validatedemail,un paid,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,parent ids,numlinks,hide,lastlinktime,custom,lastedit,moderators,he aderinfo,related,numsub,isalbum,type,permissions,subscribers ,subscriber,mixtypes,orderlinks,totalcomments,filetitle,file name,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,l inkcols,dmozpath,sponsorlinks,views,customwrap,deleted,reqli nks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,l astpostername,lastcommenttime,lastthreadid,lastthreadtitle,l inkshere,unvalidatedlinks,unvalidatedcomments,actaslink,coun tposts,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,av atarname,allowemail,albumid,signature,failedattempts,allowus eremail,stylesheet,funds,totalhitsin,notifyoflinks,lastvisit ,timezone,links,rating,pmfolders,notifyofpms,acceptpms,cooki eduration,banned,topics,posts,location,homepage,occupation,b io,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ig nored,isonline,acceptims,adminpermissions,referrer,groupreve rttime,grouprevertto,moderationpm,secondarygroups,linksperpa ge,commentsperpage,shouts,customtitle,shoutban,topicbans,for umbans,visibility,birthdate,lastsession,interests,posteditor ,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastm odnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe ,notifymethod,showavatars,showsigs,warninglevel,chatcolor,tr aderrating,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,canem ail,validatecats,validatecomments,validatelinks,validateedit s,cansubmitlinks,cansubmitcategories,cansubmitcomments,caned itownlinks,caneditowncategories,caneditowncomments,caneditow nprofile,caneditalllinks,caneditallcategories,caneditallcomm ents,caneditallprofiles,candownloadfiles,canupload,canviewip ,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canal ias,cancopy,candeleteown,candeleteall,bytespermem,canviewpag es,candofulledit,candeletecategories,candeletecomments,cande leteowncategories,candeleteowncomments,candeletemembers,cand eleteownmembers,canaliascategories,caneditvotes,numaliases,c anviewvotes,canhideownlinks,canhideowncategories,canhideownc omments,canhidealllinks,canhideallcategories,canhideallcomme nts,canratecomments,canpm,canim,canharddelete,limitpms,limit pmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candel eteownpolls,caneditpolls,caneditownpolls,attachperpost,attac hperpm,canviewshouts,caneditshouts,caneditownshouts,candelet eshouts,candeleteownshouts,cansubmitshouts,canpollvote,custo mtitle,canviewinvisible,namestyle,canpmimportant,canviewmodl og,isleader,cansubmitquotes,validatequotes,candeletequotes,c andeleteownquotes,canreport,canusesearch,attachperlink,valid ateattachments,bulkpms,issupermod,caneditownquotes,canedital lquotes,canviewchat,caneditownevents,caneditallevents,candel eteownevents,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,threadi d,areaname,lastsearch,nopermission,inchat,name,isrobot,lastc hat,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,repla cementclose,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,dest ination,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,r eminded,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,validate d,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,las teditby,catid,editreason,preventedit,inhidden,deleted,deleti onreason,usernoteon,modnote,filefield,title,deletedby,parent ids,disablesmilies,disablesig,icon,disablewsn,disablehtml,or iginalmessage,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,d eleted,attachment,flag,filefield,important,replyto,replied,s entdeleted,wysihtml

Load time so far: 0.15 seconds.


Load time so far: 0.16 seconds.


Query: SELECT `id`,`type`,`original`,`replacement`,`description`,`original close`,`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,me mberid,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`,`valid atelinks`,`validateedits`,`cansubmitlinks`,`cansubmitcategor ies`,`cansubmitcomments`,`caneditownlinks`,`caneditowncatego ries`,`caneditowncomments`,`caneditownprofile`,`caneditallli nks`,`caneditallcategories`,`caneditallcomments`,`caneditall profiles`,`candownloadfiles`,`canupload`,`canviewip`,`limitl inks`,`canemailmembers`,`canusehtml`,`limitlinksdaily`,`cana lias`,`cancopy`,`candeleteown`,`candeleteall`,`bytespermem`, `canviewpages`,`candofulledit`,`candeletecategories`,`candel etecomments`,`candeleteowncategories`,`candeleteowncomments` ,`candeletemembers`,`candeleteownmembers`,`canaliascategorie s`,`caneditvotes`,`numaliases`,`canviewvotes`,`canhideownlin ks`,`canhideowncategories`,`canhideowncomments`,`canhidealll inks`,`canhideallcategories`,`canhideallcomments`,`canrateco mments`,`canpm`,`canim`,`canharddelete`,`limitpms`,`limitpms daily`,`canviewdeleted`,`cansubmitpolls`,`candeletepolls`,`c andeleteownpolls`,`caneditpolls`,`caneditownpolls`,`attachpe rpost`,`attachperpm`,`canviewshouts`,`caneditshouts`,`canedi townshouts`,`candeleteshouts`,`candeleteownshouts`,`cansubmi tshouts`,`canpollvote`,`customtitle`,`canviewinvisible`,`nam estyle`,`canpmimportant`,`canviewmodlog`,`isleader`,`cansubm itquotes`,`validatequotes`,`candeletequotes`,`candeleteownqu otes`,`canreport`,`canusesearch`,`attachperlink`,`validateat tachments`,`bulkpms`,`issupermod`,`caneditownquotes`,`canedi tallquotes`,`canviewchat`,`caneditownevents`,`caneditalleven ts`,`candeleteownevents`,`candeleteevents`,`cansubmitevents` ,`validateevents`,`numinv`,`allowugspec`,`validateemails`,`v alidatesponsorlinks` FROM wsngallery_membergroups WHERE id>0

Load time so far: 0.17 seconds.


Query: SELECT `id`,`name`,`comments`,`time`,`usergroup`,`password`,`ip`,`t otalhits`,`email`,`validated`,`template`,`language`,`totalby tes`,`images`,`lastattempt`,`avatarname`,`allowemail`,`album id`,`signature`,`failedattempts`,`allowuseremail`,`styleshee t`,`funds`,`totalhitsin`,`notifyoflinks`,`lastvisit`,`timezo ne`,`links`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,` cookieduration`,`banned`,`topics`,`posts`,`location`,`homepa ge`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`, `timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acce ptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grou prevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,` commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicban s`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`inter ests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modno tes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`or deralbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`s howavatars`,`showsigs`,`warninglevel`,`chatcolor`,`traderrat ing`,`invitessent`,`validatedemail`,`newemail`,`calsub`,`mac ros` 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`,`cat id`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`, `ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,` downloads`,`pendingedit`,`imedit`,`suspect`,`funds`,`suspend ed`,`alias`,`expire`,`ip`,`inalbum`,`typeorder`,`hitsoutips` ,`lastcomment`,`related`,`inhidden`,`viewers`,`threadviewers `,`hitsouttemp`,`hitsintemp`,`origtype`,`importance`,`parent ids`,`timesemailed`,`threadclosed`,`threadposters`,`lastpost erid`,`lastpostername`,`ownername`,`deleted`,`deletionreason `,`movedto`,`deletedby`,`timevalidated`,`filefield`,`savedby `,`ownerip`,`url`,`recipurl`,`hitsin`,`recipwith`,`hitsinips `,`timesdead`,`message`,`sticky`,`pollid`,`posticon`,`valida tedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid `,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`fee dcache`,`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`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`i salbum`,`type`,`permissions`,`subscribers`,`subscriber`,`mix types`,`orderlinks`,`totalcomments`,`filetitle`,`filename`,` ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcol s`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap` ,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,` levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime `,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedl inks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcat shtml`,`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

_____________________
----------------------------
www.saltwatersportswear.com - the largest selection of t-shirts
www.showyour.com/photoswap
eric0524
Experienced

Usergroup: Member
Joined: Jun 11, 2006
Total Topics: 15
Total Posts: 55
Posted 03/17/07 - 10:19 AM:
quote post
#5
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).

_____________________
----------------------------
www.saltwatersportswear.com - the largest selection of t-shirts
www.showyour.com/photoswap
Paul
Administrator
Avatar

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 49
Total Posts: 5539
Posted 03/18/07 - 08:28 AM:
quote post
#6
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.

Edited by Paul on 03/18/07 - 08:32 AM
eric0524
Experienced

Usergroup: Member
Joined: Jun 11, 2006
Total Topics: 15
Total Posts: 55
Posted 03/18/07 - 08:41 AM:
quote post
#7
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,fu nds,suspended,alias,expire,ip,inalbum,typeorder,hitsoutips,l astcomment,related,inhidden,viewers,threadviewers,hitsouttem p,hitsintemp,origtype,importance,parentids,timesemailed,thre adclosed,threadposters,lastposterid,lastpostername,ownername ,deleted,deletionreason,movedto,deletedby,timevalidated,file field,savedby,ownerip,url,recipurl,hitsin,recipwith,hitsinip s,timesdead,message,sticky,pollid,posticon,validatedemail,un paid,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,parent ids,numlinks,hide,lastlinktime,custom,lastedit,moderators,he aderinfo,related,numsub,isalbum,type,permissions,subscribers ,subscriber,mixtypes,orderlinks,totalcomments,filetitle,file name,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,l inkcols,dmozpath,sponsorlinks,views,customwrap,deleted,reqli nks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,l astpostername,lastcommenttime,lastthreadid,lastthreadtitle,l inkshere,unvalidatedlinks,unvalidatedcomments,actaslink,coun tposts,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,av atarname,allowemail,albumid,signature,failedattempts,allowus eremail,stylesheet,funds,totalhitsin,notifyoflinks,lastvisit ,timezone,links,rating,pmfolders,notifyofpms,acceptpms,cooki eduration,banned,topics,posts,location,homepage,occupation,b io,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ig nored,isonline,acceptims,adminpermissions,referrer,groupreve rttime,grouprevertto,moderationpm,secondarygroups,linksperpa ge,commentsperpage,shouts,customtitle,shoutban,topicbans,for umbans,visibility,birthdate,lastsession,interests,posteditor ,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastm odnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe ,notifymethod,showavatars,showsigs,warninglevel,chatcolor,tr aderrating,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,canem ail,validatecats,validatecomments,validatelinks,validateedit s,cansubmitlinks,cansubmitcategories,cansubmitcomments,caned itownlinks,caneditowncategories,caneditowncomments,caneditow nprofile,caneditalllinks,caneditallcategories,caneditallcomm ents,caneditallprofiles,candownloadfiles,canupload,canviewip ,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canal ias,cancopy,candeleteown,candeleteall,bytespermem,canviewpag es,candofulledit,candeletecategories,candeletecomments,cande leteowncategories,candeleteowncomments,candeletemembers,cand eleteownmembers,canaliascategories,caneditvotes,numaliases,c anviewvotes,canhideownlinks,canhideowncategories,canhideownc omments,canhidealllinks,canhideallcategories,canhideallcomme nts,canratecomments,canpm,canim,canharddelete,limitpms,limit pmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candel eteownpolls,caneditpolls,caneditownpolls,attachperpost,attac hperpm,canviewshouts,caneditshouts,caneditownshouts,candelet eshouts,candeleteownshouts,cansubmitshouts,canpollvote,custo mtitle,canviewinvisible,namestyle,canpmimportant,canviewmodl og,isleader,cansubmitquotes,validatequotes,candeletequotes,c andeleteownquotes,canreport,canusesearch,attachperlink,valid ateattachments,bulkpms,issupermod,caneditownquotes,canedital lquotes,canviewchat,caneditownevents,caneditallevents,candel eteownevents,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,threadi d,areaname,lastsearch,nopermission,inchat,name,isrobot,lastc hat,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,repla cementclose,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,dest ination,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,r eminded,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,validate d,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,las teditby,catid,editreason,preventedit,inhidden,deleted,deleti onreason,usernoteon,modnote,filefield,title,deletedby,parent ids,disablesmilies,disablesig,icon,disablewsn,disablehtml,or iginalmessage,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,d eleted,attachment,flag,filefield,important,replyto,replied,s entdeleted,wysihtml

Load time so far: 0.15 seconds.


Load time so far: 0.16 seconds.


Query: SELECT `id`,`type`,`original`,`replacement`,`description`,`original close`,`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,me mberid,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`,`valid atelinks`,`validateedits`,`cansubmitlinks`,`cansubmitcategor ies`,`cansubmitcomments`,`caneditownlinks`,`caneditowncatego ries`,`caneditowncomments`,`caneditownprofile`,`caneditallli nks`,`caneditallcategories`,`caneditallcomments`,`caneditall profiles`,`candownloadfiles`,`canupload`,`canviewip`,`limitl inks`,`canemailmembers`,`canusehtml`,`limitlinksdaily`,`cana lias`,`cancopy`,`candeleteown`,`candeleteall`,`bytespermem`, `canviewpages`,`candofulledit`,`candeletecategories`,`candel etecomments`,`candeleteowncategories`,`candeleteowncomments` ,`candeletemembers`,`candeleteownmembers`,`canaliascategorie s`,`caneditvotes`,`numaliases`,`canviewvotes`,`canhideownlin ks`,`canhideowncategories`,`canhideowncomments`,`canhidealll inks`,`canhideallcategories`,`canhideallcomments`,`canrateco mments`,`canpm`,`canim`,`canharddelete`,`limitpms`,`limitpms daily`,`canviewdeleted`,`cansubmitpolls`,`candeletepolls`,`c andeleteownpolls`,`caneditpolls`,`caneditownpolls`,`attachpe rpost`,`attachperpm`,`canviewshouts`,`caneditshouts`,`canedi townshouts`,`candeleteshouts`,`candeleteownshouts`,`cansubmi tshouts`,`canpollvote`,`customtitle`,`canviewinvisible`,`nam estyle`,`canpmimportant`,`canviewmodlog`,`isleader`,`cansubm itquotes`,`validatequotes`,`candeletequotes`,`candeleteownqu otes`,`canreport`,`canusesearch`,`attachperlink`,`validateat tachments`,`bulkpms`,`issupermod`,`caneditownquotes`,`canedi tallquotes`,`canviewchat`,`caneditownevents`,`caneditalleven ts`,`candeleteownevents`,`candeleteevents`,`cansubmitevents` ,`validateevents`,`numinv`,`allowugspec`,`validateemails`,`v alidatesponsorlinks` FROM wsngallery_membergroups WHERE id>0

Load time so far: 0.17 seconds.


Query: SELECT `id`,`name`,`comments`,`time`,`usergroup`,`password`,`ip`,`t otalhits`,`email`,`validated`,`template`,`language`,`totalby tes`,`images`,`lastattempt`,`avatarname`,`allowemail`,`album id`,`signature`,`failedattempts`,`allowuseremail`,`styleshee t`,`funds`,`totalhitsin`,`notifyoflinks`,`lastvisit`,`timezo ne`,`links`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,` cookieduration`,`banned`,`topics`,`posts`,`location`,`homepa ge`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`, `timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acce ptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grou prevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,` commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicban s`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`inter ests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modno tes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`or deralbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`s howavatars`,`showsigs`,`warninglevel`,`chatcolor`,`traderrat ing`,`invitessent`,`validatedemail`,`newemail`,`calsub`,`mac ros` 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`,`cat id`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`, `ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,` downloads`,`pendingedit`,`imedit`,`suspect`,`funds`,`suspend ed`,`alias`,`expire`,`ip`,`inalbum`,`typeorder`,`hitsoutips` ,`lastcomment`,`related`,`inhidden`,`viewers`,`threadviewers `,`hitsouttemp`,`hitsintemp`,`origtype`,`importance`,`parent ids`,`timesemailed`,`threadclosed`,`threadposters`,`lastpost erid`,`lastpostername`,`ownername`,`deleted`,`deletionreason `,`movedto`,`deletedby`,`timevalidated`,`filefield`,`savedby `,`ownerip`,`url`,`recipurl`,`hitsin`,`recipwith`,`hitsinips `,`timesdead`,`message`,`sticky`,`pollid`,`posticon`,`valida tedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid `,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`fee dcache`,`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`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`i salbum`,`type`,`permissions`,`subscribers`,`subscriber`,`mix types`,`orderlinks`,`totalcomments`,`filetitle`,`filename`,` ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcol s`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap` ,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,` levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime `,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedl inks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcat shtml`,`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 http://www.showyour.com/photoswap/comments.php?id... 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.p hp 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.p hp on line 717

Load time so far: 0.23 seconds.


Query: SELECT `id`,`linkid`,`posterid`,`postername`,`message`,`time`,`link name`,`validated`,`ip`,`ownerid`,`lastedit`,`type`,`approved `,`votes`,`hide`,`typeorder`,`lasteditby`,`catid`,`editreaso n`,`preventedit`,`inhidden`,`deleted`,`deletionreason`,`user noteon`,`modnote`,`filefield`,`title`,`deletedby`,`parentids `,`disablesmilies`,`disablesig`,`icon`,`disablewsn`,`disable html`,`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`,`cat id`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`, `ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,` downloads`,`pendingedit`,`imedit`,`suspect`,`funds`,`suspend ed`,`alias`,`expire`,`ip`,`inalbum`,`typeorder`,`hitsoutips` ,`lastcomment`,`related`,`inhidden`,`viewers`,`threadviewers `,`hitsouttemp`,`hitsintemp`,`origtype`,`importance`,`parent ids`,`timesemailed`,`threadclosed`,`threadposters`,`lastpost erid`,`lastpostername`,`ownername`,`deleted`,`deletionreason `,`movedto`,`deletedby`,`timevalidated`,`filefield`,`savedby `,`ownerip`,`url`,`recipurl`,`hitsin`,`recipwith`,`hitsinips `,`timesdead`,`message`,`sticky`,`pollid`,`posticon`,`valida tedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid `,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`fee dcache`,`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`,`wi dth`,`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`,`wi dth`,`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`,`t otalhits`,`email`,`validated`,`template`,`language`,`totalby tes`,`images`,`lastattempt`,`avatarname`,`allowemail`,`album id`,`signature`,`failedattempts`,`allowuseremail`,`styleshee t`,`funds`,`totalhitsin`,`notifyoflinks`,`lastvisit`,`timezo ne`,`links`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,` cookieduration`,`banned`,`topics`,`posts`,`location`,`homepa ge`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`, `timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acce ptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grou prevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,` commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicban s`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`inter ests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modno tes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`or deralbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`s howavatars`,`showsigs`,`warninglevel`,`chatcolor`,`traderrat ing`,`invitessent`,`validatedemail`,`newemail`,`calsub`,`mac ros` 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`,`accept ims`,`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`,`accept ims`,`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 --> [img]{TEMPLATESDIR}/images/smilies/swimsperm.gif[/im g] smiling face wink grin cool nod sticking out tongue raised eyebrow confused shocked shaking head disapproval rolling eyes sad mad <!-- 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



_____________________
----------------------------
www.saltwatersportswear.com - the largest selection of t-shirts
www.showyour.com/photoswap
eric0524
Experienced

Usergroup: Member
Joined: Jun 11, 2006
Total Topics: 15
Total Posts: 55
Posted 03/18/07 - 08:42 AM:
quote post
#8
Here is the thumbnail one:


Load time so far: [b]0.05[/b] seconds.


[b]Query:[/b] SELECT `name`,`content` FROM wsngallery_settings WHERE id>0 ORDER BY id ASC

Load time so far: [b]0.14[/b] seconds.


[b]Query:[/b] 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: [b]0.14[/b] seconds.


[b]Query:[/b] UPDATE wsngallery_settings SET content='202' WHERE name='highestcatindex'

Load time so far: [b]0.14[/b] seconds.


[b]Query:[/b] SELECT `name`,`value` FROM wsngallery_switches WHERE id>0

Number of rows is 78

[b]Query:[/b] 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: [b]0.15[/b] seconds.


[b]Query:[/b] 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: [b]0.15[/b] seconds.


[b]Query:[/b] 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: [b]0.15[/b] seconds.


[b]Query:[/b] 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: [b]0.15[/b] seconds.


[b]Query:[/b] 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: [b]0.15[/b] seconds.


[b]Query:[/b] 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: [b]0.15[/b] seconds.


[b]Query:[/b] SHOW COLUMNS FROM wsngallery_ratings

Getting field list for table wsngallery_ratings: id,votevalue,time,memberid,ip,custom,linkid,type

Load time so far: [b]0.15[/b] seconds.


[b]Query:[/b] SHOW COLUMNS FROM wsngallery_markup

Getting field list for table wsngallery_markup: id,type,original,replacement,description,originalclose,replacementclose,sortorder

Load time so far: [b]0.15[/b] seconds.


[b]Query:[/b] 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: [b]0.15[/b] seconds.


[b]Query:[/b] SHOW COLUMNS FROM wsngallery_crons

Getting field list for table wsngallery_crons: id,frequency,nextrun,filename,native

Load time so far: [b]0.15[/b] seconds.


[b]Query:[/b] 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: [b]0.16[/b] seconds.


[b]Query:[/b] SHOW COLUMNS FROM wsngallery_helpcategory

Getting field list for table wsngallery_helpcategory: id,name,numsubjects,priority

Load time so far: [b]0.16[/b] seconds.


[b]Query:[/b] SHOW COLUMNS FROM wsngallery_helpitem

Getting field list for table wsngallery_helpitem: id,subject,helptext,priority,category

Load time so far: [b]0.16[/b] seconds.


[b]Query:[/b] SHOW COLUMNS FROM wsngallery_chat

Getting field list for table wsngallery_chat: name

Load time so far: [b]0.16[/b] seconds.


[b]Query:[/b] SHOW COLUMNS FROM wsngallery_im

Getting field list for table wsngallery_im: id,toid,fromid,message,time,isread,timeread,deleted

Load time so far: [b]0.16[/b] seconds.


[b]Query:[/b] SHOW COLUMNS FROM wsngallery_searches

Getting field list for table wsngallery_searches: id,value,memberid,catid,time

Load time so far: [b]0.16[/b] seconds.


[b]Query:[/b] 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: [b]0.16[/b] seconds.


[b]Query:[/b] 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: [b]0.16[/b] seconds.


Load time so far: [b]0.16[/b] seconds.


[b]Query:[/b] SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM wsngallery_markup WHERE type='wsncode' ORDER BY sortorder

Number of rows is 22

[b]Query:[/b] 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: [b]0.17[/b] seconds.


Load time so far: [b]0.17[/b] seconds.


[b]Query:[/b] 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: [b]0.18[/b] seconds.


[b]Query:[/b] 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: [b]0.19[/b] seconds.


[b]Query:[/b] SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsngallery_markup WHERE type='smilie' ORDER BY sortorder

Number of rows is 17

Load time so far: [b]0.19[/b] seconds.


[b]Query:[/b] 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

[b]Query:[/b] LOCK TABLES wsngallery_email WRITE, wsngallery_links WRITE, wsngallery_categories WRITE, wsngallery_members WRITE

Load time so far: [b]0.2[/b] seconds.


[b]Query:[/b] 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

[b]Query:[/b] UNLOCK TABLES

Load time so far: [b]0.22[/b] seconds.


[b]Query:[/b] 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: [b]0.22[/b] seconds.


[b]Query:[/b] 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: [b]0.23[/b] seconds.


[b]Query:[/b] 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: [b]0.23[/b] seconds.


[b]Query:[/b] UPDATE wsngallery_categories SET linkshere='77' WHERE id=4

Load time so far: [b]0.23[/b] seconds.


[b]Query:[/b] 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: [b]0.23[/b] seconds.


[b]Query:[/b] 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: [b]0.24[/b] seconds.


[b]Query:[/b] 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: [b]0.26[/b] seconds.


[b]Query:[/b] 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: [b]0.28[/b] seconds.


[b]Query:[/b] 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: [b]0.3[/b] seconds.


[b]Query:[/b] 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: [b]0.31[/b] seconds.


[b]Query:[/b] 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: [b]0.33[/b] seconds.


[b]Query:[/b] 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: [b]0.35[/b] seconds.


[b]Query:[/b] 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: [b]0.37[/b] seconds.


[b]Query:[/b] 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: [b]0.39[/b] seconds.


[b]Query:[/b] 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: [b]0.41[/b] seconds.


[b]Query:[/b] 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: [b]0.43[/b] seconds.


[b]Query:[/b] 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: [b]0.44[/b] seconds.


[b]Query:[/b] 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: [b]0.46[/b] seconds.


[b]Query:[/b] 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: [b]0.48[/b] seconds.


[b]Query:[/b] 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: [b]0.5[/b] seconds.


[b]Query:[/b] 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: [b]0.52[/b] seconds.


[b]Query:[/b] 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: [b]0.52[/b] seconds.


[b]Query:[/b] UPDATE wsngallery_categories SET linkshere='77' WHERE id=4

Setting cookie with name returnto, value index.php?action=displaycat&catid=4 and duration 1174233395

[b]Warning[/b]: Cannot modify header information - headers already sent by (output started at /home/vhosts/wwwroot/showyour.com/photoswap/classes/database.php:248) in [b]/home/vhosts/wwwroot/showyour.com/photoswap/commonfuncs.php[/b] on line [b]713[/b]

[b]Warning[/b]: Cannot modify header information - headers already sent by (output started at /home/vhosts/wwwroot/showyour.com/photoswap/classes/database.php:248) in [b]/home/vhosts/wwwroot/showyour.com/photoswap/commonfuncs.php[/b] on line [b]717[/b]

[b]Warning[/b]: Cannot modify header information - headers already sent by (output started at /home/vhosts/wwwroot/showyour.com/photoswap/classes/database.php:248) in [b]/home/vhosts/wwwroot/showyour.com/photoswap/end.php[/b] on line [b]145[/b]

Load time so far: [b]0.66[/b] seconds.


[b]Query:[/b] SELECT COUNT(id) FROM wsngallery_links WHERE viewers LIKE '%[END]1[,]%' or viewers LIKE '1[,]%'
Count is 507

Load time so far: [b]0.7[/b] seconds.


[b]Query:[/b] 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: [b]0.96[/b] seconds.


[b]Query:[/b] SELECT `inchat`,`lastchat` FROM wsngallery_sessions WHERE memberid=1 LIMIT 0,1

Number of rows is 1

Load time so far: [b]0.96[/b] seconds.


[b]Query:[/b] SELECT `memberid`,`starttime`,`time` FROM wsngallery_sessions WHERE time < 1174228895 AND memberid > 0

Number of rows is 0

Load time so far: [b]0.96[/b] seconds.


[b]Query:[/b] DELETE FROM wsngallery_sessions WHERE time < 1174228895

Load time so far: [b]0.96[/b] seconds.


[b]Query:[/b] UPDATE wsngallery_sessions SET starttime=0, time=0 WHERE time < 1174232435

Load time so far: [b]0.96[/b] seconds.


[b]Query:[/b] 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: [b]0.97[/b] seconds.


[b]Query:[/b] 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




Edited by Paul on 03/18/07 - 09:14 AM

_____________________
----------------------------
www.saltwatersportswear.com - the largest selection of t-shirts
www.showyour.com/photoswap
Paul
Administrator
Avatar

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 49
Total Posts: 5539
Posted 03/18/07 - 09:19 AM:
quote post
#9
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 Posts: 55
Posted 03/18/07 - 09:30 AM:
quote post
#10
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/attac hment.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...

_____________________
----------------------------
www.saltwatersportswear.com - the largest selection of t-shirts
www.showyour.com/photoswap
Paul
Administrator
Avatar

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 49
Total Posts: 5539
Posted 03/20/07 - 09:48 AM:
quote post
#11
http://www.showyour.com/photoswap/thumbnail.php?i... shows nothing, so there's nothing I can say without access: http://scripts.webmastersite.net/wsngallery/index...
eric0524
Experienced

Usergroup: Member
Joined: Jun 11, 2006
Total Topics: 15
Total Posts: 55
Posted 03/20/07 - 10:59 AM:
quote post
#12
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?

_____________________
----------------------------
www.saltwatersportswear.com - the largest selection of t-shirts
www.showyour.com/photoswap
Paul
Administrator
Avatar

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 49
Total Posts: 5539
Posted 03/21/07 - 03:49 PM:
quote post
#13
Click the second link in my post above.
eric0524
Experienced

Usergroup: Member
Joined: Jun 11, 2006
Total Topics: 15
Total Posts: 55
Posted 03/21/07 - 04:27 PM:
quote post
#14
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.

_____________________
----------------------------
www.saltwatersportswear.com - the largest selection of t-shirts
www.showyour.com/photoswap
eric0524
Experienced

Usergroup: Member
Joined: Jun 11, 2006
Total Topics: 15
Total Posts: 55
Posted 03/22/07 - 04:13 PM:
quote post
#15
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/attac hment.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.

_____________________
----------------------------
www.saltwatersportswear.com - the largest selection of t-shirts
www.showyour.com/photoswap
Search thread for
Download thread as

Page: 1 2



You don't have permission to post.

Please login or register.

   
 
© 2008 Paul Knierim. All rights reserved.