or use PhpMyAdmin and create this:
CREATE TABLE - PM_TABLE
pm_id mediumint(10) unsigned NOT NULL auto_increment
pm_type tinyint(2) NOT NULL default '0'
pm_to mediumint(8) NOT NULL default '0'
pm_from mediumint(8) NOT NULL default '0'
pm_subject varchar(255) NOT NULL default ''
pm_text text
pm_date int(11) NOT NULL default '0'
pm_date_rcvd int(11) NOT NULL default '0'
pm_ip varchar(20) NOT NULL default '0'
pm_html tinyint(1) NOT NULL default '0'
pm_bbcode tinyint(1) NOT NULL default '0'
pm_smiles tinyint(1) NOT NULL default '0', KEY `pm_id` (`pm_id`,`pm_to`,`pm_from`)) TYPE=MyISAM"
add in USERS_TABLE
user_pm_inbox int(11) NOT NULL default '0'
user_pm_sentbox int(11) NOT NULL default '0'
user_pm_email tinyint(1) NOT NULL default '1'
user_pm_popup tinyint(1) NOT NULL default '0'
insert in SETTINGS_TABLE
setting_name setting_value
pm 1
pm_inbox 30
pm_sentbox 10
pm_html 0
pm_bbcode 1
pm_img 1
all simple... use phpmyadmin
i have',t the installer file, so i tryed with myspl and wanted to create the tables
so i become the error:
Es scheint einen Fehler in Ihrer MySQL-Abfrage zu geben. Die MySQL-Fehlerausgabe, falls vorhanden, kann Ihnen auch bei der Fehleranalyse helfen.
ERROR: Nicht geschlossene Anführungszeichen @ 551
STR: "
SQL: CREATE TABLE - PM_TABLE
pm_id mediumint(10) unsigned NOT NULL auto_increment
pm_type tinyint(2) NOT NULL default '0'
pm_to mediumint(
NOT NULL default '0'
pm_from mediumint(
NOT NULL default '0'
pm_subject varchar(255) NOT NULL default ''
pm_text text
pm_date int(11) NOT NULL default '0'
pm_date_rcvd int(11) NOT NULL default '0'
pm_ip varchar(20) NOT NULL default '0'
pm_html tinyint(1) NOT NULL default '0'
pm_bbcode tinyint(1) NOT NULL default '0'
pm_smiles tinyint(1) NOT NULL default '0', KEY `pm_id` (`pm_id`,`pm_to`,`pm_from`)) TYPE=MyISAM"
add in USERS_TABLE
user_pm_inbox int(11) NOT NULL default '0'
user_pm_sentbox int(11) NOT NULL default '0'
user_pm_email tinyint(1) NOT NULL default '1'
user_pm_popup tinyint(1) NOT NULL default '0'
insert in SETTINGS_TABLE
setting_name setting_value
pm 1
pm_inbox 30
pm_sentbox 10
pm_html 0
pm_bbcode 1
pm_img 1
.
.
.
.
.
MySQL meldet: Dokumentation
#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 '- PM_TABLE
pm_id mediumint(10) unsigned NOT NULL auto_incremen