Query 3: SELECT `name`,`value` FROM wsnlinks_switches
Load time so far: 0.06 seconds.
Query 4: 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`,`candofulledit`,`candeletecategories`,`candeletecomments`,`candeleteowncategories`,`candeleteowncomments`,`candeletemembers`,`candeleteownmembers`,`canaliascategories`,`canviewpages`,`caneditvotes`,`numaliases`,`canviewvotes`,`canhideownlinks`,`canhideowncategories`,`canhideowncomments`,`canhidealllinks`,`canhideallcategories`,`canhideallcomments`,`canratecomments`,`bytespermem`,`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`,`caneditownquotes`,`caneditallquotes`,`canviewchat`,`caneditownevents`,`caneditallevents`,`candeleteownevents`,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulkpms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks`,`cansubmittags`,`candeletetags`,`cansubmitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot`,`shoutsperday`,`validatetrader`,`renewdays`,`renewtimes`,`canviewownfulltrc`,`canviewallfulltrc` FROM wsnlinks_membergroups
Load time so far: 0.07 seconds.
Query 5: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`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`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader`,`inactiveemail` FROM wsnlinks_members WHERE id = '1' AND validated = 1
Load time so far: 0.08 seconds.
Query 6: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnlinks_email WHERE timesent=0 AND inprogress=0 ORDER BY id ASC LIMIT 0,10
Load time so far: 0.1 seconds.
Number of rows is 0
Query 7: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`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`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader`,`inactiveemail` FROM wsnlinks_members WHERE banned='' AND notifykeywords != '' AND keychecktime < 1218978273 ORDER BY id ASC LIMIT 0,1
Load time so far: 0.11 seconds.
Number of rows is 0
Query 8: SELECT `id`,`frequency`,`filename`,`nextrun` FROM wsnlinks_crons WHERE nextrun < 1219064673 ORDER BY id ASC LIMIT 0,1
Load time so far: 0.11 seconds.
Number of rows is 0
Load time so far: 0.11 seconds.
Query 9: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=0 AND deleted=0 AND hide=0 AND isalbum=0 AND validated=1
Count is 8
Query 10: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`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`,`defaultnoaccess`,`lastthreadurl`,`lastposturl`,`specialurl` FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 AND isalbum=0 AND deleted=0 ORDER BY priority ASC,name ASC LIMIT 0,40
Query 11: SELECT `` FROM etable ORDER BY time DESC LIMIT 0,5
Load time so far: 0.17 seconds.
Table 'inpanama_links.etable' doesn't exist
An error occoured at www.inpanamacity.com/index....ts=&4_caneditalllinks=&4_c on 2008-08-18 13:04:33. Please relay this data to support. Error #2: 'mysql_num_rows(): supplied argument is not a valid MySQL result resource' in /home/inpanama/domains/inpanamacity.com/public_html/databases/mysql.php on line 47. Debug info:
Number of rows is Table 'inpanama_links.etable' doesn't exist
Query 12: SELECT DISTINCT FROM ltable WHERE 1=1 GROUP BY name ORDER BY uses DESC LIMIT 0,10
An error occoured at www.inpanamacity.com/index....ts=&4_caneditalllinks=&4_c on 2008-08-18 13:04:33. Please relay this data to support. Error #2: 'mysql_num_rows(): supplied argument is not a valid MySQL result resource' in /home/inpanama/domains/inpanamacity.com/public_html/databases/mysql.php on line 47. Debug info:
Number of rows is 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 'FROM ltable WHERE 1=1 GROUP BY name ORDER BY uses DESC LIMIT 0,10' at line 1
Query 13: SELECT `` FROM atable ORDER BY rand() ASC LIMIT 0,1
Load time so far: 0.17 seconds.
Table 'inpanama_links.atable' doesn't exist
An error occoured at www.inpanamacity.com/index....ts=&4_caneditalllinks=&4_c on 2008-08-18 13:04:33. Please relay this data to support. Error #2: 'mysql_num_rows(): supplied argument is not a valid MySQL result resource' in /home/inpanama/domains/inpanamacity.com/public_html/databases/mysql.php on line 47. Debug info:
Number of rows is Table 'inpanama_links.atable' doesn't exist
Query 14: SELECT `` FROM ltable ORDER BY time DESC LIMIT 0,20
Load time so far: 0.18 seconds.
Table 'inpanama_links.ltable' doesn't exist
An error occoured at www.inpanamacity.com/index....ts=&4_caneditalllinks=&4_c on 2008-08-18 13:04:33. Please relay this data to support. Error #2: 'mysql_num_rows(): supplied argument is not a valid MySQL result resource' in /home/inpanama/domains/inpanamacity.com/public_html/databases/mysql.php on line 47. Debug info:
Number of rows is Table 'inpanama_links.ltable' doesn't exist
You must have an unclosed form tag in the wrapper or higher in the submit cat template which is thus hijacking the forms below it like the category submission form. You have 23 HTML errors there, including one that mentions an omitted </form>.
Comments on Error on adding category
Experienced
Usergroup: Customer
Joined: Jun 18, 2008
Total Topics: 22
Total Comments: 85
hello,
I'm getting errors when trying to add a catgeory. The errors are
Table dbname.itable does not exist
Table dbname.etable does not exist
Table dbname.atable does not exist
(I removed the DB name)
I'm guessing an update went wrong or something similar.
Is there a schema that will show me what I need to add to the DB to be up to date?
Thanks,
Jeff
Experienced
Usergroup: Customer
Joined: Jun 18, 2008
Total Topics: 22
Total Comments: 85
BTW - happens with adding links as well.
I can add links and cats from Admin with no problems. Adding from the user end causes the errors.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
itable, etable and atable are all nonsense, no tables are anything like that. I'll have to see the site to have any idea what happened.
Experienced
Usergroup: Customer
Joined: Jun 18, 2008
Total Topics: 22
Total Comments: 85
Here's the debug output - feel free to hit http://www.inpanamacity.com and try it out. Debug is turned on.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
The form is submitting to www.inpanamacity.com/?numbe...rapper={CUSTOMWRAPPER}&redirectto={REDIRECTTO}&isalbum=0
You must have an unclosed form tag in the wrapper or higher in the submit cat template which is thus hijacking the forms below it like the category submission form. You have 23 HTML errors there, including one that mentions an omitted </form>.
Experienced
Usergroup: Customer
Joined: Jun 18, 2008
Total Topics: 22
Total Comments: 85
Fixed - thank you
Keep track of the troubleshooting you do (I'll keep track as well) and I'll compensate you for your time.