Webmastersite.net
Register Log In

Error on adding category
missing DB tables

Comments on Error on adding category

fusionx
Experienced

Usergroup: Customer
Joined: Jun 18, 2008

Total Topics: 22
Total Comments: 85
fusionx
Posted Aug 17, 2008 - 12:47 PM:

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

fusionx
Experienced

Usergroup: Customer
Joined: Jun 18, 2008

Total Topics: 22
Total Comments: 85
fusionx
Posted Aug 17, 2008 - 5:55 PM:

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.
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Aug 17, 2008 - 6:25 PM:

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.
fusionx
Experienced

Usergroup: Customer
Joined: Jun 18, 2008

Total Topics: 22
Total Comments: 85
fusionx
Posted Aug 18, 2008 - 6:06 AM:

Here's the debug output - feel free to hit http://www.inpanamacity.com and try it out. Debug is turned on.


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

Load time so far: 0.11 seconds.



Number of rows is 8

Creating category with Array as row

Creating category with Array as row

Creating category with Array as row

Creating category with Array as row

Creating category with Array as row

Creating category with Array as row

Creating category with Array as row

Creating category with Array as row

Setting cookie with name returnto, value www.inpanamacity.com/index....ts=&4_caneditalllinks=&4_c and expiration time 0

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
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Aug 19, 2008 - 6:52 AM:

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>.
fusionx
Experienced

Usergroup: Customer
Joined: Jun 18, 2008

Total Topics: 22
Total Comments: 85
fusionx
Posted Aug 19, 2008 - 7:39 AM:

Fixed - thank you

Keep track of the troubleshooting you do (I'll keep track as well) and I'll compensate you for your time.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.