Elkarte can not be installed
I wanted elkarte install on a new domain, and I get an error message. The database I've created new, it changes nothing. How can there be? I have taken the latest Masterzip.
Greetings
morle
Re: Elkarte can not be installed
Reply #1 –
Hi, you must grant additional privileges to the mysql username used (specifically ALTER, CREATE and DROP as indicated from the error message).
Re: Elkarte can not be installed
Reply #3 –
the mysql user used for the ElkArte installation needsALTER TABLE, CREATE TABLE and DROP TABLE table privilegues.
German translation: Der MySQL-Benutzer, den du für die Installation benutzt hast hat nicht genügend Rechte innerhalb der Datenbank. Er braucht auf jeden fall ALTER TABLE, CREATE TABLE and DROP TABLE Rechte
Re: Elkarte can not be installed
Reply #5 –
Can you try to move a board in the admin panel and see it if works?
The error is generated if Elk is not able to "fix" the boards order (i.e. run successfully ALTER TABLE {$db_prefix}boards ORDER BY id_board). It is the first time I see this error (but I usually test things with a root mysql account so it's also difficult I catch catch these errors...), so it may be several things.
What version of php and mysql are you using?
Re: Elkarte can not be installed
Reply #6 –
PHP 5.3.3
Active Persistent Links 0
Active Links 0
Client API version 5.1.69
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib64/mysql -lmysqlclient
Settings Local Settings Default Settings
mysql.allow_local_infile On On
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off
Re: Elkarte can not be installed
Reply #7 –
Hi, I have cleared cache and everything else and restarted. Now let elkarte install easily. thanks for the help.
Re: Elkarte can not be installed
Reply #9 –
dedicated server (root server)
Re: Elkarte can not be installed
Reply #11 –
Hi I once again, the newest masterzip've downloaded, and wanted to install it. After Creating the database this error message "Can not find file: 'elkarte_settings' (errno: 2)" Why is that? regards morle800
Operating system is CentOS 6
PHP 5.3.3
Re: Elkarte can not be installed
Reply #12 –
elkarte_settings is not a file, but a database table. O_o
That's an even more weird message error...
I just did a test install, with both root user and a test user with privileges only on designed database, but it worked fine...
Re: Elkarte can not be installed
Reply #13 –
the folder where ElkArte was uploaded is writable? (maybe you test with recursive CHMOD 777)?
Re: Elkarte can not be installed
Reply #14 –
Hello, I have now the subdirectory where I wanted to install elk given CHMOD 777 Now it was no problem. Thank you, and again, one experience richer ^ ^