ElkArte Community

Elk Development => Bug Reports => Exterminated Bugs => Topic started by: morle800 on November 15, 2013, 05:16:26 am

Title: Elkarte can not be installed
Post by: morle800 on 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
Title: Re: Elkarte can not be installed
Post by: kucing on 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).
Title: Re: Elkarte can not be installed
Post by: morle800 on November 15, 2013, 05:57:54 am
What exactly does this mean?  :o
Title: Re: Elkarte can not be installed
Post by: TE on 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
Title: Re: Elkarte can not be installed
Post by: morle800 on November 15, 2013, 08:31:18 am
Elkarte has to be installed in the domain Here (http://ahuby.de/elkate/index.php) without problems. It is the same server. Only one other master zip

Databases, other software can be installed without problems
Title: Re: Elkarte can not be installed
Post by: emanuele on 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?
Title: Re: Elkarte can not be installed
Post by: morle800 on 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
Title: Re: Elkarte can not be installed
Post by: morle800 on 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.
Title: Re: Elkarte can not be installed
Post by: kucing on November 15, 2013, 09:00:26 pm
good! :) did you use shared hosting or vps @morle800  ?
Title: Re: Elkarte can not be installed
Post by: morle800 on November 16, 2013, 03:14:05 am
dedicated server (root server)
Title: Re: Elkarte can not be installed
Post by: emanuele on 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... :(
Title: Re: Elkarte can not be installed
Post by: morle800 on 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
Title: Re: Elkarte can not be installed
Post by: emanuele on 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...
Title: Re: Elkarte can not be installed
Post by: TE on November 19, 2013, 10:40:30 am
the folder where ElkArte was uploaded is writable? (maybe you test with recursive CHMOD 777)?
Title: Re: Elkarte can not be installed
Post by: morle800 on 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 ^ ^
Title: Re: Elkarte can not be installed
Post by: kucing on November 19, 2013, 07:29:41 pm
don't leave it 777 if you don't need that kind of liberal permissions.
Title: Re: Elkarte can not be installed
Post by: morle800 on November 20, 2013, 02:55:18 am
Thank you .. had changed it for installation  ;)
Title: Re: Elkarte can not be installed
Post by: emanuele on November 29, 2013, 04:39:28 pm
This seems to be fixed if I'm not wrong.