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
Attac your Subs-Members.php here. Also, check is there a smf_log_errors table in your database.
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
Then just run the SMF installation again. It will only recreate this table.
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.
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;
blame the smiley code :P i did not put them there
I know that, but you have option to disable smileys in the post. And yes, your code is correct and it works perfectly. :D
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
dont add the {} replace that whole part with your prefix.
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;
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.
are u some sort of GOD or some thing
how can i thank u guys?
u are awsome
yeah man, lessons are being learned
I'm very glad because you solved your problem. :D And no, we are not Gods. I'm marking this topic as solved.
thx man, very useful
i like u man
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;
Please start a new topic instead of replying in an 8 year old solved thread. Thanks.