I did a complete new installation on a new Ubuntu 18-04 dedicated server following these instructions.
hxxps://websiteforstudents.com/install-simple-machine-forum-on-ubuntu-17-04-17-10-with-apache2-mariadb-and-php/
The only difference is that I used the newest version smf_2-0-17_install.zip. 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 http://158.69.23.50/phpmyadmin 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)
) ENGINE=MyISAM;
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', '
[email protected]', '127.0.0.1', '', 'new message body', 'xx');