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
Hi, you must grant additional privileges to the mysql username used (specifically ALTER, CREATE and DROP as indicated from the error message).
What exactly does this mean? :o
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
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?
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
Hi, I have cleared cache and everything else and restarted. Now let elkarte install easily. thanks for the help.
good! :) did you use shared hosting or vps
@morle800 ?
dedicated server (root server)
mmm...anyway it's curious.
Apparently you were installing it on a database that already contained something (from the image I see one table was ignored, so it means it already existed)
Though...it doesn't make much sense...dunno, completely without ideas, sorry... :(
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
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...
the folder where ElkArte was uploaded is writable? (maybe you test with recursive CHMOD 777)?
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 ^ ^
don't leave it 777 if you don't need that kind of liberal permissions.
Thank you .. had changed it for installation ;)
This seems to be fixed if I'm not wrong.