.smf_log_errors' doesn't exist

Started by arashagha, December 08, 2010, 06:07:05 AM

Previous topic - Next topic

arashagha

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 [nofollow] - New Persian Lang

Masterd

Attac your Subs-Members.php here. Also, check is there a smf_log_errors table in your database.

arashagha

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 [nofollow] - New Persian Lang

Masterd

Then just run the SMF installation again. It will only recreate this table.

Illori

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.

Masterd

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;

Illori

blame the smiley code :P i did not put them there

Masterd

I know that, but you have option to disable smileys in the post. And yes, your code is correct and it works perfectly. :D

arashagha

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
SMFa.ir [nofollow] - New Persian Lang

Illori

dont add the {} replace that whole part with your prefix.

Masterd

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;

Illori

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.

arashagha

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 [nofollow] - New Persian Lang

Masterd

I'm very glad because you solved your problem. :D And no, we are not Gods. I'm marking this topic as solved.

arashagha

SMFa.ir [nofollow] - New Persian Lang

yaf79

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;

Steve

Please start a new topic instead of replying in an 8 year old solved thread. Thanks.
DO NOT pm me for support!

Advertisement: