SMF 2.0.19 has been released! Please update. Read more.

Main Menu

Table 'smf.smf_messages' doesn't exist

Started by boinc-australia, August 29, 2020, 04:29:04 AM

Previous topic - Next topic


I did a complete new installation on a new Ubuntu 18-04 dedicated server following these instructions.

  The only difference is that I used the newest version  I also had to install php-mcrypt as it is not in Ubuntu 18.

When I got to the end of the installation I used the ip address to access the forum and I got the error in the heading.  Table 'smf.smf_messages' doesn't exist

As I did not use phpmyadmin in the installation so I installed it and when I enter [nofollow] I get the login screen so I assume it is OK ??

Any help appreciated.


I found what appears to be the answer as I can log into the forum now and it looks as if it is working .

I used the following to create the missing table and insert some data.

After logging into the database using mysql -u root -p
I did the following:

use smf;

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',
  poster_time int(10) unsigned NOT NULL default '0',
  id_member mediumint(8) unsigned NOT NULL default '0',
  id_msg_modified int(10) unsigned NOT NULL default '0',
  subject varchar(255) NOT NULL default '',
  poster_name varchar(255) NOT NULL default '',
  poster_email varchar(255) NOT NULL default '',
  poster_ip varchar(255) NOT NULL default '',
  smileys_enabled tinyint(4) NOT NULL default '1',
  modified_time int(10) unsigned NOT NULL default '0',
  modified_name varchar(255) NOT NULL default '',
  body text NOT NULL,
  icon varchar(16) NOT NULL default 'xx',
  approved tinyint(3) NOT NULL default '1',
  PRIMARY KEY (id_msg),
  UNIQUE topic (id_topic, id_msg),
  UNIQUE id_board (id_board, id_msg),
  UNIQUE id_member (id_member, id_msg),
  KEY approved (approved),
  KEY ip_index (poster_ip(15), id_topic),
  KEY participation (id_member, id_topic),
  KEY show_posts (id_member, id_board),
  KEY id_topic (id_topic),
  KEY id_member_msg (id_member, approved, id_msg),
  KEY current_topic (id_topic, id_msg, id_member, approved),
  KEY related_ip (id_member, poster_ip(15), id_msg)

Then inserted some data.

INSERT INTO smf_messages
   (id_msg, id_msg_modified, id_topic, id_board, poster_time, subject, poster_name, poster_email, poster_ip, modified_name, body, icon)
VALUES (1, 1, 1, 1, UNIX_TIMESTAMP(), 'new subject', 'Simple Machines', '', '', '', 'new message body', 'xx');