Advertisement:

Author Topic: .smf_log_errors' doesn't exist  (Read 3920 times)

Offline arashagha

  • Semi-Newbie
  • *
  • Posts: 14
  • Gender: Male
  • فارسی پرس یعنی ترجمه برترین ها
    • FarsiPress
.smf_log_errors' doesn't exist
« 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
SMFa.ir - New Persian Lang

Offline Masterd

  • SMF Hero
  • ******
  • Posts: 3,920
  • Gender: Male
Re: .smf_log_errors' doesn't exist
« Reply #1 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.

Offline arashagha

  • Semi-Newbie
  • *
  • Posts: 14
  • Gender: Male
  • فارسی پرس یعنی ترجمه برترین ها
    • FarsiPress
Re: .smf_log_errors' doesn't exist
« Reply #2 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
SMFa.ir - New Persian Lang

Offline Masterd

  • SMF Hero
  • ******
  • Posts: 3,920
  • Gender: Male
Re: .smf_log_errors' doesn't exist
« Reply #3 on: December 08, 2010, 06:18:23 AM »
Then just run the SMF installation again. It will only recreate this table.

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 51,270
Re: .smf_log_errors' doesn't exist
« Reply #4 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.

Offline Masterd

  • SMF Hero
  • ******
  • Posts: 3,920
  • Gender: Male
Re: .smf_log_errors' doesn't exist
« Reply #5 on: December 08, 2010, 06:20:28 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.

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

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 51,270
Re: .smf_log_errors' doesn't exist
« Reply #6 on: December 08, 2010, 06:21:27 AM »
blame the smiley code :P i did not put them there

Offline Masterd

  • SMF Hero
  • ******
  • Posts: 3,920
  • Gender: Male
Re: .smf_log_errors' doesn't exist
« Reply #7 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

Offline arashagha

  • Semi-Newbie
  • *
  • Posts: 14
  • Gender: Male
  • فارسی پرس یعنی ترجمه برترین ها
    • FarsiPress
Re: .smf_log_errors' doesn't exist
« Reply #8 on: December 08, 2010, 06:27:50 AM »
dear mastered
:
i put this:

Code: [Select]
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:
Code: [Select]
#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
SMFa.ir - New Persian Lang

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 51,270
Re: .smf_log_errors' doesn't exist
« Reply #9 on: December 08, 2010, 06:28:26 AM »
dont add the {} replace that whole part with your prefix.

Offline Masterd

  • SMF Hero
  • ******
  • Posts: 3,920
  • Gender: Male
Re: .smf_log_errors' doesn't exist
« Reply #10 on: December 08, 2010, 06:29:25 AM »
Code: [Select]
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;

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 51,270
Re: .smf_log_errors' doesn't exist
« Reply #11 on: December 08, 2010, 06:31:07 AM »
this reminds me of

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.

Offline arashagha

  • Semi-Newbie
  • *
  • Posts: 14
  • Gender: Male
  • فارسی پرس یعنی ترجمه برترین ها
    • FarsiPress
Re: .smf_log_errors' doesn't exist
« Reply #12 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
SMFa.ir - New Persian Lang

Offline Masterd

  • SMF Hero
  • ******
  • Posts: 3,920
  • Gender: Male
Re: .smf_log_errors' doesn't exist
« Reply #13 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.

Offline arashagha

  • Semi-Newbie
  • *
  • Posts: 14
  • Gender: Male
  • فارسی پرس یعنی ترجمه برترین ها
    • FarsiPress
Re: .smf_log_errors' doesn't exist
« Reply #14 on: December 08, 2010, 06:39:12 AM »
thx man, very useful
i like u man
SMFa.ir - New Persian Lang

Offline yaf79

  • Newbie
  • *
  • Posts: 5
Re: .smf_log_errors' doesn't exist
« Reply #15 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;

Offline Steve

  • Freak
  • SMF Friend
  • SMF Hero
  • *
  • Posts: 4,500
  • Gender: Male
  • I have not yet begun to procrastinate.
Re: .smf_log_errors' doesn't exist
« Reply #16 on: June 01, 2018, 06:56:47 AM »
Please start a new topic instead of replying in an 8 year old solved thread. Thanks.
Online Manual

Please do not PM me for support.