Webmastersite.net
Register Log In

SQL Error

Title SQL Error
Message Text I am getting an SQL error that usually only happens when viewing the index.php and not being logged in. I get it both in firefox and IE7. It seems to go away when I am logged in. The last major items that I have done is upgrading from previous versions and added a custom URL field. On a side note. I have a cron (has worked for a long time with no error) that removes all the images in the gallery every 24 hours. I noticed that if i check the site the next morning those images will still show up unless I log in. Seems possible that this may be related to the SQL error.

Load time so far: 0.02 seconds.



Query 1: SELECT `name`,`content` FROM wsngallery_settings WHERE id>0 ORDER BY id ASC 

Number of rows is 502 

Load time so far: 0.03 seconds.



Query 2: SELECT COUNT(id) FROM wsngallery_crons WHERE nextrun < 1221422924

Count is 1

Load time so far: 0.03 seconds.



Query 3: SELECT COUNT(id) FROM wsngallery_email WHERE timesent=0

Count is 0

Load time so far: 0.04 seconds.



Query 4: SELECT `name`,`value` FROM wsngallery_switches WHERE id>0 

Number of rows is 102 

Load time so far: 0.04 seconds.



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

Number of rows is 26 

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row
r

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Load time so far: 0.05 seconds.



Query 6: 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`,`cansubmittags`,`candeletetags`,`cansubmitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot`,`shoutsperday`,`validatetrader`,`renewdays`,`renewtimes`,`canviewownfulltrc`,`canviewallfulltrc` FROM wsngallery_membergroups WHERE id>0 

Load time so far: 0.06 seconds.



Query 7: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsngallery_markup WHERE type='smilie' ORDER BY sortorder 

Number of rows is 14 

Load time so far: 0.06 seconds.



Query 8: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsngallery_email WHERE timesent=0 AND inprogress=0 ORDER BY id ASC LIMIT 0,10

Number of rows is 0 

Load time so far: 0.07 seconds.



Query 9: SELECT `memberid`,`starttime`,`time` FROM wsngallery_sessions WHERE time < 1221422024 AND memberid > 0 

Number of rows is 0 

Load time so far: 0.07 seconds.



Query 10: DELETE FROM wsngallery_sessions WHERE time < 1221422024

Load time so far: 0.07 seconds.



Query 11: SELECT `id`,`url`,`ownerid`,`lastfetched`,`validated`,`catid`,`time`,`title`,`description`,`homepage` FROM wsngallery_xmlfeeds WHERE validated=1 AND lastfetched < 1221379724 ORDER BY lastfetched ASC LIMIT 0,1

Number of rows is 0 

Load time so far: 0.07 seconds.



Query 12: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`validated`,`ownerip`,`catid`,`importurl` FROM wsngallery_attachments WHERE importurl != '' ORDER BY id ASC LIMIT 0,1

Number of rows is 0 

Load time so far: 0.07 seconds.



Query 13: 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`,`guestnotify`,`keychecktime`,`notifykeywords`,`positivepct`,`notifytrader` FROM wsngallery_members WHERE banned='' AND notifykeywords != '' AND keychecktime < 1221336524 ORDER BY id ASC LIMIT 0,1

Number of rows is 0 

Load time so far: 0.07 seconds.



Query 14: SELECT `id`,`frequency`,`filename`,`nextrun` FROM wsngallery_crons WHERE nextrun < 1221422924 ORDER BY id ASC LIMIT 0,1

Number of rows is 1 

Load time so far: 0.07 seconds.



Query 15: UPDATE wsngallery_crons SET nextrun='1221509324' WHERE id=11

Load time so far: 0.09 seconds.



Query 16: DELETE FROM wsngallery_links WHERE id>0

Load time so far: 0.09 seconds.



Query 17: DELETE FROM WHERE id>0

Load time so far: 0.09 seconds.


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id>0' at line 1

Query 18: UPDATE wsngallery_categories SET numlinks='0' WHERE id>0

Load time so far: 0.09 seconds.



Query 19: UPDATE wsngallery_categories SET linkshere='0' WHERE id>0

Load time so far: 0.09 seconds.



Query 20: UPDATE wsngallery_categories SET unvalidatedlinks='0' WHERE id>0

Load time so far: 0.09 seconds.



Query 21: UPDATE wsngallery_categories SET totalcomments='0' WHERE id>0

Load time so far: 0.09 seconds.



Query 22: UPDATE wsngallery_categories SET unvalidatedcomments='0' WHERE id>0

Load time so far: 0.09 seconds.



Query 23: UPDATE wsngallery_settings SET content='0' WHERE name='totallinks'

Load time so far: 0.1 seconds.



Query 24: 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`,`sponsorship`,`lastprofileurl`,`lastthreadurl`,`lastposturl`,`defaultnoaccess` FROM wsngallery_categories WHERE id=2 

Load time so far: 0.1 seconds.



Query 25: 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`,`sponsorship`,`lastprofileurl`,`lastthreadurl`,`lastposturl`,`defaultnoaccess` FROM wsngallery_categories WHERE parent=2 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY id DESC,name ASC LIMIT 0,75

Number of rows is 0 

Load time so far: 0.1 seconds.



Query 26: SELECT COUNT(id) FROM wsngallery_links WHERE catid=2 AND validated=1 AND hide=0 AND deleted=0 AND type='regular' AND effectivetime < 1221422924

Count is 0

Load time so far: 0.1 seconds.



Query 27: SELECT `canviewpages` FROM wsngallery_membergroups WHERE id='1' 

Setting cookie with name returnto, value www.grabspace.net/wsngaller...index.php?dorand=1&debug=1 and expiration time 0


Warning: Cannot modify header information - headers already sent by (output started at /home/grabspac/public_html/wsngallery/classes/database.php:249) in /home/grabspac/public_html/wsngallery/includes/commonfuncs.php on line 747

Warning: Cannot modify header information - headers already sent by (output started at /home/
grabspac/public_html/wsngallery/classes/database.php:249) in /home/grabspac/public_html/wsngallery/includes/commonfuncs.php on line 751

Warning: Cannot modify header information - headers already sent by (output started at /home/grabspac/public_html/wsngallery/classes/database.php:249) in /home/grabspac/public_html/wsngallery/end.php on line 71

Load time so far: 0.13 seconds.



Query 28: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM wsngallery_sessions WHERE time > 1221422024 AND (catid=2 AND memberid>0) ORDER BY time DESC LIMIT 0,100

Number of rows is 0 

Load time so far: 0.14 seconds.



Query 29: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM wsngallery_sessions WHERE ip='75.189.148.9' AND memberid=0 

Number of rows is 0 

Creating online with new as new

Query 30: INSERT INTO wsngallery_sessions(`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl`) VALUES('0','http://grabspace.net/wsngallery/index.php?dorand=1&debug=1','1221422924','75.189.148.9','Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506; .NET CLR 1.1.4322)','1221422924','2','0','GrabSpace','','0','0','guest','','','','none','','')

Rating
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5
0/5 based on 0 votes.
Ownership ryanmw2002
Views 1,234 views. Averaging 0 views per day.
Similar Topics
Submission Date Sep 14, 2008 - 3:26 PM