Advertisement:

Author Topic: !!Error! Table 'ubercow_bbshrine.smf_log_errors' doesn't exist  (Read 3313 times)

Offline Shadow03

  • Semi-Newbie
  • *
  • Posts: 62
!!Error! Table 'ubercow_bbshrine.smf_log_errors' doesn't exist
« 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?

Offline karlbenson

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,630
  • Gender: Male
    • Lifeproof
Re: !!Error! Table 'ubercow_bbshrine.smf_log_errors' doesn't exist
« Reply #1 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)

Code: [Select]
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.

Offline greyknight17

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 14,890
  • Gender: Male
    • Kevin's Resource Center
Re: !!Error! Table 'ubercow_bbshrine.smf_log_errors' doesn't exist
« Reply #2 on: February 27, 2009, 10:19:57 PM »
Shadow03, is this issue resolved after running the above query?

Offline Shadow03

  • Semi-Newbie
  • *
  • Posts: 62
Re: !!Error! Table 'ubercow_bbshrine.smf_log_errors' doesn't exist
« Reply #3 on: February 28, 2009, 03:42:11 PM »
Yes, it worked. Thank you for the support!!!