smf_messages

[Dreamer]

Where is the smf_messages table located at?
I accidently deleted it.

[[darksteel]]

Run Install.php again.

[Dreamer]

Could it be phpmyadmin not letting me install "install.php"?
Because I cant install it.

[[darksteel]]

Yes, but I nees know your smf version to send to you a code to use un PhpMyAdmin.

What SMF version do you use?

darksteel-

[Dreamer]

1.0.5. thanks

[[darksteel]]

Fine, You need add this code in SQL (phpmyadmin):

You must replace {$db_prefix} for your smf prefix.

Code Select Expand

CREATE TABLE {$db_prefix}messages (
  ID_MSG int(10) unsigned NOT NULL auto_increment,
  ID_TOPIC mediumint(8) unsigned NOT NULL default '0',
  ID_BOARD smallint(5) unsigned NOT NULL default '0',
  posterTime int(10) unsigned NOT NULL default '0',
  ID_MEMBER mediumint(8) unsigned NOT NULL default '0',
  subject tinytext NOT NULL default '',
  posterName tinytext NOT NULL default '',
  posterEmail tinytext NOT NULL default '',
  posterIP tinytext NOT NULL default '',
  smileysEnabled tinyint(4) NOT NULL default '1',
  modifiedTime int(10) unsigned NOT NULL default '0',
  modifiedName tinytext,
  body text,
  icon varchar(16) NOT NULL default 'xx',
  PRIMARY KEY (ID_MSG),
  UNIQUE topic (ID_TOPIC, ID_MSG),
  KEY ID_TOPIC (ID_TOPIC),
  KEY ID_BOARD (ID_BOARD),
  KEY ID_MEMBER (ID_MEMBER),
  KEY posterTime (posterTime),
  KEY ipIndex (posterIP(15), ID_TOPIC),
  KEY participation (ID_MEMBER, ID_TOPIC)
) TYPE=MyISAM;

darksteel-

[Dreamer]

I get this error.

Code Select Expand

Error

SQL query:

CREATE TABLE {$db_prefix}messages(
ID_MSG int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
ID_TOPIC mediumint( 8 ) unsigned NOT NULL default '0',
ID_BOARD smallint( 5 ) unsigned NOT NULL default '0',
posterTime int( 10 ) unsigned NOT NULL default '0',
ID_MEMBER mediumint( 8 ) unsigned NOT NULL default '0',
subject tinytext NOT NULL default '',
posterName tinytext NOT NULL default '',
posterEmail tinytext NOT NULL default '',
posterIP tinytext NOT NULL default '',
smileysEnabled tinyint( 4 ) NOT NULL default '1',
modifiedTime int( 10 ) unsigned NOT NULL default '0',
modifiedName tinytext,
body text,
icon varchar( 16 ) NOT NULL default 'xx',
PRIMARY KEY ( ID_MSG ) ,
UNIQUE topic( ID_TOPIC, ID_MSG ) ,
KEY ID_TOPIC( ID_TOPIC ) ,
KEY ID_BOARD( ID_BOARD ) ,
KEY ID_MEMBER( ID_MEMBER ) ,
KEY posterTime( posterTime ) ,
KEY ipIndex( posterIP( 15 ) , ID_TOPIC ) ,
KEY participation( ID_MEMBER, ID_TOPIC )
) TYPE = MYISAM

MySQL said: 
#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 '{$db_prefix}messages (
  ID_MSG int(10) unsigned NOT NULL auto

[Trekkie101]

You must replace {$db_prefix} for your smf prefix.

Check again

[Dreamer]

oh
Where can I change that?
Thanks and sorry

[[darksteel]]

In the SQL code that I post ...

darksteel-

[Dreamer]

Sorry im a little slow...
My prefix is this .. smf_
So what should i put in sql?
Thanks for the help

[JayBachatero]

try this

Code Select Expand


CREATE TABLE smf_messages (
  ID_MSG int(10) unsigned NOT NULL auto_increment,
  ID_TOPIC mediumint(8) unsigned NOT NULL default '0',
  ID_BOARD smallint(5) unsigned NOT NULL default '0',
  posterTime int(10) unsigned NOT NULL default '0',
  ID_MEMBER mediumint(8) unsigned NOT NULL default '0',
  subject tinytext NOT NULL default '',
  posterName tinytext NOT NULL default '',
  posterEmail tinytext NOT NULL default '',
  posterIP tinytext NOT NULL default '',
  smileysEnabled tinyint(4) NOT NULL default '1',
  modifiedTime int(10) unsigned NOT NULL default '0',
  modifiedName tinytext,
  body text,
  icon varchar(16) NOT NULL default 'xx',
  PRIMARY KEY (ID_MSG),
  UNIQUE topic (ID_TOPIC, ID_MSG),
  KEY ID_TOPIC (ID_TOPIC),
  KEY ID_BOARD (ID_BOARD),
  KEY ID_MEMBER (ID_MEMBER),
  KEY posterTime (posterTime),
  KEY ipIndex (posterIP(15), ID_TOPIC),
  KEY participation (ID_MEMBER, ID_TOPIC)
) TYPE=MyISAM;

[Dreamer]

Yeah I had figured it out, thanks though, and thanks everyone.