CiviCRM Community Forums (archive)

I tried to upgrade both Drupal (to 6.16) and Civicrm (to 3.1) and apparently confused some of the install and upgrade procedures and messed up my database. I tried reloading a backup and got Drupal to work, pretty much, but when I activate the CiviCRM module, I get the following error message:

          DB Error: no such table

          Database Error Code: Table 'civicrm.civicrm_preferences' doesn't exist, 1146

Is there something I need to run or settings file I can edit to get civicrm.civicrm_preferences to exist. Can I copy it up from my standalone/development version? I can probably learn to used PHPMyAdmin (or whatever my ISP has) and create the table, if that's all it takes, but I have a feeling that there is some other functionality that populates the table.

A little knowledge is a dangerous thing and I have very little. Thanks for any help.

Thanks for the response. I may be too stupid to understand it.
I think I remember that I was going from CiviCRM 3.13 to 3.14. But I have tried so many different things that I think I would just like to totally dump CiviCRM, all its modules and MySQL tables, and start over. I'm going to have to find out what facilities my ISP has for that.
I've tried to find out what the Drupal System Table is and how to modify it, as you suggested, but no luck so far. I tried a Drupal Module called System Table Cleaner, and it just gets rid of the old stuff (and found some CiviCRM sub-modules, but not the main one). I think my problem is that, in all my hacking around, I did eliminate the civicrm_preferences table. So I need to put it back and some of my earlier error messages suggest that an upgrade won't work -- I need a full re-install.
I also need to keep better notes on what I did and what error messages I have gotten.
Anyway, thanks for your help - you were the only one who did.