Elxis CMS Forum

Support => Installation => Topic started by: interlan on June 14, 2013, 10:25:41

Title: Installation error ver. 4.1
Post by: interlan on June 14, 2013, 10:25:41

Win XP, WAMP local server, PHP 5.4.3.
Created Db in MySQL named elxis. DB check returns -> The database settings are correct.

Submit presses error :
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 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 'ALTER TABLE `elx_acl` ENABLE KEYS */' at line 126' in E:\wamp\www\elxis\includes\libraries\elxis\database.class.php:514 Stack trace: #0 E:\wamp\www\elxis\includes\libraries\elxis\database.class.php(514): PDO->exec('INSERT INTO `el...') #1 E:\wamp\www\elxis\includes\install\install.class.php(70): elxisDatabase->import('E:/wamp/www/elx...') #2 E:\wamp\www\elxis\includes\install\install.php(19): elxisInstaller->process() #3 E:\wamp\www\elxis\includes\loader.php(144): require('E:\wamp\www\elx...') #4 E:\wamp\www\elxis\index.php(18): require('E:\wamp\www\elx...') #5 {main} thrown in E:\wamp\www\elxis\includes\libraries\elxis\database.class.php on line 514

Thanks
Petros

Title: Re: Installation error ver. 4.1
Post by: datahell on June 14, 2013, 10:50:07

Syntax error or access violation: ... near ALTER TABLE

The user you use to connect to the database has no ALTER permission on database tables. Fix it (better provide him ALL previleges).

Title: Re: Installation error ver. 4.1
Post by: interlan on June 14, 2013, 11:05:01

The user has ALL PRIVILAGES + GRANT.
Didn't have this problem again (about 30 DBs in my local installation).

Thanks

 

Title: Re: Installation error ver. 4.1
Post by: datahell on June 14, 2013, 18:51:52

Oooops! You are right!

Replace the file below with the one I attach.
includes/install/data/mysql.sql
Sorry for the trouble!

Title: Re: Installation error ver. 4.1
Post by: interlan on June 16, 2013, 10:22:15

It did the trick!

Thanks a lot

PETROS

Title: Re: Installation error ver. 4.1
Post by: Andres08 on July 22, 2013, 05:18:20

I installed year ago older version, without any problem. Now with  4,1 on another web site install simply can"t work. All I got in mydomain.com/includes/install/
is:

Index of /includes/install

    Parent Directory
    css/
    data/
    inc/
    install.class.php
    install.php

Title: Re: Installation error ver. 4.1
Post by: webgift on July 22, 2013, 12:12:10

Hello Andres08,
Can you please send me a private message with cPanel (or any control panel) of your website hosting package? I am going to complete the installation for you.