Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Topic started by: arashagha on December 08, 2010, 06:07:05 AM

Title: .smf_log_errors' doesn't exist
Post by: arashagha on December 08, 2010, 06:07:05 AM
hi guys,
i try to delete a member from my forum
but i get this error


خطا در بانک اطلاعاتی: Table '******_******.smf_log_errors' doesn't exist
فایل: /home/*****/public_html/*****/forum/Sources/Subs-Members.php
line: 214

how can i make this .smf_log_errors table so the problem solves
thx
Title: Re: .smf_log_errors' doesn't exist
Post by: Masterd on December 08, 2010, 06:10:28 AM
Attac your Subs-Members.php here. Also, check is there a smf_log_errors table in your database.
Title: Re: .smf_log_errors' doesn't exist
Post by: arashagha on December 08, 2010, 06:17:02 AM
my problem is that . i accidentaly delete the smf_log_errors table
i think by creating it again, it will be solved

so how can i make it again
i will send u the file
Title: Re: .smf_log_errors' doesn't exist
Post by: Masterd on December 08, 2010, 06:18:23 AM
Then just run the SMF installation again. It will only recreate this table.
Title: Re: .smf_log_errors' doesn't exist
Post by: Illori on December 08, 2010, 06:19:04 AM
CREATE TABLE {$db_prefix}log_errors (
  ID_ERROR mediumint(8) unsigned NOT NULL auto_increment,
  logTime 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 '                                ',
  PRIMARY KEY (ID_ERROR),
  KEY logTime (logTime),
  KEY ID_MEMBER (ID_MEMBER),
  KEY ip (ip(16))
) ENGINE=MyISAM;


replace {$db_prefix} with the prefix for YOUR database. run this query in phpmyadmin, it should work without any problem, although I have not tested it.
Title: Re: .smf_log_errors' doesn't exist
Post by: Masterd on December 08, 2010, 06:20:28 AM
Quote from: Illori on December 08, 2010, 06:19:04 AM
CREATE TABLE {$db_prefix}log_errors (
  ID_ERROR mediumint(8) unsigned NOT NULL auto_increment,
  logTime 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 '                                ',
  PRIMARY KEY (ID_ERROR),
  KEY logTime (logTime),
  KEY ID_MEMBER (ID_MEMBER),
  KEY ip (ip(16))
) ENGINE=MyISAM;


replace {$db_prefix} with the prefix for YOUR database. run this query in phpmyadmin, it should work without any problem, although I have not tested it.

You have smileys in that code.

CREATE TABLE {$db_prefix}log_errors (
  ID_ERROR mediumint(8) unsigned NOT NULL auto_increment,
  logTime 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 '                                ',
  PRIMARY KEY (ID_ERROR),
  KEY logTime (logTime),
  KEY ID_MEMBER (ID_MEMBER),
  KEY ip (ip(16))
) ENGINE=MyISAM;
Title: Re: .smf_log_errors' doesn't exist
Post by: Illori on December 08, 2010, 06:21:27 AM
blame the smiley code :P i did not put them there
Title: Re: .smf_log_errors' doesn't exist
Post by: Masterd on December 08, 2010, 06:23:42 AM
I know that, but you have option to disable smileys in the post. And yes, your code is correct and it works perfectly. :D
Title: Re: .smf_log_errors' doesn't exist
Post by: arashagha on December 08, 2010, 06:27:50 AM
dear mastered
:
i put this:

CREATE TABLE {smf_}log_errors (
  ID_ERROR mediumint(8) unsigned NOT NULL auto_increment,
  logTime 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 '                                ',
  PRIMARY KEY (ID_ERROR),
  KEY logTime (logTime),
  KEY ID_MEMBER (ID_MEMBER),
  KEY ip (ip(16))
) ENGINE=MyISAM;


but i get the error:
#1064 - 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 '{smf_}log_errors ( ID_ERROR mediumint(8) unsigned NOT NULL auto_increment, ' at line 1
Title: Re: .smf_log_errors' doesn't exist
Post by: Illori on December 08, 2010, 06:28:26 AM
dont add the {} replace that whole part with your prefix.
Title: Re: .smf_log_errors' doesn't exist
Post by: Masterd on December 08, 2010, 06:29:25 AM
CREATE TABLE smf_log_errors (
  ID_ERROR mediumint(8) unsigned NOT NULL auto_increment,
  logTime 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 '                                ',
  PRIMARY KEY (ID_ERROR),
  KEY logTime (logTime),
  KEY ID_MEMBER (ID_MEMBER),
  KEY ip (ip(16))
) ENGINE=MyISAM;
Title: Re: .smf_log_errors' doesn't exist
Post by: Illori on December 08, 2010, 06:31:07 AM
this reminds me of

Quote from: Illori on December 08, 2010, 05:30:01 AM
dont use {db_prefix} in an sql query that goes in phpmyadmin it will throw an error you must use the actual prefix.

well lesson learned here as well.
Title: Re: .smf_log_errors' doesn't exist
Post by: arashagha on December 08, 2010, 06:32:20 AM
are u some sort of GOD or some thing
how can i thank u guys?

u are awsome
yeah man, lessons are being learned
Title: Re: .smf_log_errors' doesn't exist
Post by: Masterd on December 08, 2010, 06:34:48 AM
I'm very glad because you solved your problem. :D And no, we are not Gods. I'm marking this topic as solved.
Title: Re: .smf_log_errors' doesn't exist
Post by: arashagha on December 08, 2010, 06:39:12 AM
thx man, very useful
i like u man
Title: Re: .smf_log_errors' doesn't exist
Post by: yaf79 on June 01, 2018, 05:16:08 AM
Hello, I have the same problem:

Ð"решка с базаÑ,а данни: Table 'lawsbgco_forum.smf_log_errors' doesn't exist
Файл: /home/lawsbgco/public_html/forum/Sources/Subs-Members.php
Линия: 214

I see that I need to put this code, but dont know where.

cpanel - phpmyadmin - name_forum - Create table - ...and I'm lost...

Please help :)

CREATE TABLE lawsbgco_forum.smf_log_errors (
  ID_ERROR mediumint(8) unsigned NOT NULL auto_increment,
  logTime 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 '                                ',
  PRIMARY KEY (ID_ERROR),
  KEY logTime (logTime),
  KEY ID_MEMBER (ID_MEMBER),
  KEY ip (ip(16))
) ENGINE=MyISAM;
Title: Re: .smf_log_errors' doesn't exist
Post by: Steve on June 01, 2018, 06:56:47 AM
Please start a new topic instead of replying in an 8 year old solved thread. Thanks.