Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: Shadow03 on February 11, 2009, 10:09:01 AM

Title: !!Error! Table 'ubercow_bbshrine.smf_log_errors' doesn't exist
Post by: Shadow03 on February 11, 2009, 10:09:01 AM
While trying to upgrade from Beta 4 to RC1, I got the following error:

!!Error!
Table 'ubercow_bbshrine.smf_log_errors' doesn't exist



How do I solve this?
Title: Re: !!Error! Table 'ubercow_bbshrine.smf_log_errors' doesn't exist
Post by: karlbenson on February 11, 2009, 11:18:35 AM
It appears somehow that you've lost an default table of smf.

In PHPMYADMIN, inside your database, run the following query
(change smf_ to your forums prefix)


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 tinytext NOT NULL,
  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;


Then try running upgrade again.
Title: Re: !!Error! Table 'ubercow_bbshrine.smf_log_errors' doesn't exist
Post by: greyknight17 on February 27, 2009, 10:19:57 PM
Shadow03, is this issue resolved after running the above query?
Title: Re: !!Error! Table 'ubercow_bbshrine.smf_log_errors' doesn't exist
Post by: Shadow03 on February 28, 2009, 03:42:11 PM
Yes, it worked. Thank you for the support!!!