smf_log_errors' doesn't exist.

[Miker1029]

Hey,

   I'm not sure why I'm getting this, I have recently switched to a VPS from a HOSTED Environment, And Have had Issues with the Control Panel I'm Using, Have Had to do Numerous Re-Installs of the OS/Control Panel/Forum..

AND Have had MAJOR database issues, This is the Closest I've gotten to a Complete Database Import....

Ok, Everything seems to be working, Expect I'm Getting:

Table 'smf2011.smf_log_errors' doesn't exist
File: /home/*******/public_html/Sources/ManageErrors.php
Line: 93

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.11, while your database is at version 2.0.9. The above error might possibly go away if you execute the latest version of upgrade.php.

Now I'm not sure WHY it's Looking for Table "smf2011" as that's the name of my database, I guess it's just letting me know that , that, Is the DB Name, But I have looked and "smf_log_errors" and in-fact is not there...

Not sure Why I did a DB Export with Phpmyadmin (And a Linux mysql dump), So I guess what I'm looking for is just what I need to Re-Insert the proper Table back into the database (Command wise as I'm not that good with SQL Commands) as everything else seems to be working...

Thanks

Mike

[Illori]

smf2011 is the database name, it is shown in the error message as that is how it is accessed.

Code Select Expand

CREATE TABLE smf_log_errors (
  id_error mediumint(8) unsigned NOT NULL auto_increment,
  log_time int(10) unsigned NOT NULL default '0',
  id_member mediumint(8) unsigned NOT NULL default '0',
  ip char(16) NOT NULL default '                ',
  url text NOT NULL,
  message text NOT NULL,
  session char(32) NOT NULL default '                                ',
  error_type char(15) NOT NULL default 'general',
  file varchar(255) NOT NULL default '',
  line mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY (id_error),
  KEY log_time (log_time),
  KEY id_member (id_member),
  KEY ip (ip(16))
) ENGINE=MyISAM;

[Miker1029]

Thank you!

Will Report back.

[Miker1029]

+10, Thank you very much for the fast REPLY!

Solved

Mike