DB error

[flnz400]

Upgraded to 3.7.1, had dup files on my server, dumped them, including config, and now new config file doesn't work. Tried all known values. Anything I can do besides wait for my host to verify?

FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache','userstats','birthdaycach e','maxloggedin','iconcache','eventcache','mailque ue');
MySQL Error : Table 'admin_forum.datastore' doesn't exist
Error Number : 1146
Request Date : Wednesday, June 4th 2008 @ 06:46:25 PM
Error Date : Wednesday, June 4th 2008 @ 06:46:25 PM


Backup through Putty fails as well....

[admin@traverse ~]$ mysql -u admin_admin -p admin_forum < backup63.sql
Enter password:
ERROR 1064 (42000) at line 1158: 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 ''a:310:{s:15:\"0_matches_found\";s:15:\"0 Matches Found\";s:15:\"add_child_style' at line 1
[admin@traverse ~]$

[Steve Machol]

Either your database does not exist, it is missing this table, or you are using a table prefix and you need to add that prefix to the appropriate section in your includes/config.php file.

[flnz400]

I don't know what you mean by prefix for the table. The db is still listed in the cpanel...

admin_forum [/URL] (http://74.53.225.226:2082/frontend/x/sql/deldb.html?db=admin_forum) Users in forum
admin_admin (Privileges: ALL PRIVILEGES) [URL="http://74.53.225.226:2082/frontend/x/sql/deluserfromdb.html?db=admin_forum&user=admin_admin"] (http://74.53.225.226:2082/frontend/x/sql/repairdb.html?db=admin_forum)Connection StringsPerl$dbh = DBI->connect("DBI:mysql:admin_forum:localhost","admin_admin","<PASSWORD HERE>");PHP$dbh=mysql_connect ("localhost", "admin_admin", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("admin_forum");

[Steve Machol]

And what are the table names?

[flnz400]

I don't know. lol I, obviously, am in over my head here.

Does anyone have any recommended resources to learn this stuff (I guess this would be server side?)? I figured like many things, the best way would be by doing. I'm finding not knowing the basics hinders execution dramatically.

[wickedstangs]

Yes I need help too? Is there any basic info someone can share?:eek: