Firefox PHP

installation mysql

Posted by rian 
installation mysql
February 26, 2016 02:14PM
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 ?
Re: installation mysql
February 26, 2016 04:51PM
i tried to install the latest version of phorum.
Re: installation mysql
February 27, 2016 10:29PM
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]
Re: installation mysql
September 24, 2016 09:08PM
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.
Re: installation mysql
September 27, 2016 03:43PM
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.
Sorry, only registered users may post in this forum.

Click here to login