By boomerdan on

I'm just good enough at this thing to be dangerous.

I have created a drupal site on my localhost, however, seem to have compromised some of my DB files. Upon viewing my site, the following errors appear in red at the top of my site:

1) user warning: Table 'densonDB.vocabulary' doesn't exist query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 2 ORDER BY v.weight, t.weight, t.name in /Applications/MAMP/htdocs/densonDB/modules/taxonomy/taxonomy.module on line 617.

2) user warning: Table 'densonDB.vocabulary' doesn't exist query: SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 1 in /Applications/MAMP/htdocs/densonDB/modules/taxonomy/taxonomy.module on line 983.

Also, I cannot login as admin.

I have attempted a restore DB from phpmyadmin. No luck. I then dropped the entire DB and imported my backup and the same error msgs. appear.

Any assistance would be greatly appreciated. Disparaging remarks can be left at the door, I am at your mercy.

Thank you.

⋅ Categories: Drupal 6.x

Comments

Aeternum’s picture

Aeternum commented

If you restored from working db backups, and the problem still exists, I would suggest that the issue is not a fault with the database but with a bad query you are running on the actual site. Have you added any content that runs queries or any modules recently?

Perhaps manually deleting those (obviously taking a full backup of file structure beforehand) would help.

Hope this helps....

boomerdan’s picture

boomerdan commented

Thank you kindly, I will try this. I have dug a decent hole from which to remove myself!