installation mysql

after i uploaded files and changed config.php i went to [localhost] and on second page i got this error.

Could not create tables, database said:

    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 'TYPE=MyISAM' at line 1

Your database user will need to have create table permissions. If you know what the error is (tables already exist, etc.) and want to continue, click the button below.

what can be the problem ?

i tried to install the latest version of phorum.

Generically ...

Install mysql
create a database
create a user (not root) and password
grant the user rights needed to create, read, update, delete tables (there may be more rights required)

Install phorum to some directory.
modify the phorum config.php (username, password, and prefix)
Go to the admin.php and follow prompts.

If you missed one of the above, fix it.

MySQL has made changes over the years to some commands, deprecated some, removed others.
Enable the log file, and find the location for troubleshooting.
MySql has some sql-modes that could prevent older scripts from running as expected.
See [dev.mysql.com] and my.cnf or my.ini


Later versions of MySQL use innodb tables by default, the myisam engine may need to be specifically enabled
Only the search table must be myisam, however later versions of MySQL may prevent this...

Quote
With one exception, the settings in the default option file are commented and have no effect. The exception is that the file sets the sql_mode system variable to NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES.

[dev.mysql.com]

I had the same problem when installing phorum 5.1.25 on XAMPP, which uses MariaDB. It took me a while until I found the solution.

I had to search and replace the string 'TYPE=MyISAM' with 'ENGINE=MyISAM' in all files of phorum.

Hi Alfonso,

version 5.1 is already very, very old...

In our 5.2 version "TYPE" is replaced by "ENGINE".

So, @rian: did you install our latest version? Did you install some additional modules?

Regards
Oliver

---

Using Phorum since 7/2000: forum.langzeittest.de (actual version 5.2.23)
Modules "Made in Germany" for version 5.2: Author_as_Sender, CarCost, Close_Topic, Conceal_Message_Timestamp,
Format_Email, Index_Structure, Mailing_List, Pervasive_Forum, Spritmonitor, Terms_of_Service and German_Language_Files_Package.