ElkArte Community Modern, Free, Powerful
Community building forum software

Elkarte can not be installed

November 15, 2013, 05:16:26 am

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 – November 15, 2013, 05:32:11 am

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 #2 – November 15, 2013, 05:57:54 am

What exactly does this mean? 

Re: Elkarte can not be installed

Reply #3 – November 15, 2013, 07:43:32 am

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 #4 – November 15, 2013, 08:31:18 am

Elkarte has to be installed in the domain Here without problems. It is the same server. Only one other master zip

Databases, other software can be installed without problems

Re: Elkarte can not be installed

Reply #5 – November 15, 2013, 10:00:46 am

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 – November 15, 2013, 02:24:32 pm

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 – November 15, 2013, 06:16:02 pm

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 #8 – November 15, 2013, 09:00:26 pm

good! did you use shared hosting or vps @morle800  ?

Re: Elkarte can not be installed

Reply #9 – November 16, 2013, 03:14:05 am

dedicated server (root server)

Re: Elkarte can not be installed

Reply #10 – November 18, 2013, 10:01:26 am

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...

Re: Elkarte can not be installed

Reply #11 – November 19, 2013, 04:14:48 am

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 – November 19, 2013, 10:37:28 am

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 – November 19, 2013, 10:40:30 am

the folder where ElkArte was uploaded is writable? (maybe you test with recursive CHMOD 777)?

Re: Elkarte can not be installed

Reply #14 – November 19, 2013, 10:59:38 am

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 ^ ^