Install Problem: mysql Error [1146] : EXECUTE

[StenTheMan]

Hello ...

I'm using wampserver 2.0 on my computer. All the Elxis installation steps were performed nicely (the pre-check items were all green/success) but after I delete the installation folder, the page showed this:
----------------------------------------------------------------------------------
mysql Error [1146] : EXECUTE
DB function failed with error number 1146
Table 'elxis.elx_core_acl_access_lists' doesn't exist
mysql Error [1146] : EXECUTE
mysql Error [1146] : EXECUTE
mysql Error [1146] : EXECUTE
mysql Error [1146] : EXECUTE
mysql Error [1146] : EXECUTE
DB function failed with error number 1146
Table 'elxis.elx_session' doesn't exist
SQL =
SELECT session_id FROM elx_session WHERE session_id='b5e647d802510bafef21c0a8891da047'
-------------------------------------------------------------------------------------

I checked the PhpMyAdmin and found out the database elxis were empty. I did even try to import the sql file from \schema folder  but it showed error like this:

Error

MySQL said: 
#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 'INSERT INTO INSERT INTO INSERT INTO INSERT INTO INSERT INTO
INSERT INTO
INSE' at line 1

Here is my configuration file:

<?php
$mosConfig_offline = '0';
$mosConfig_host = 'localhost';
$mosConfig_user = '*****'; --->Edited
$mosConfig_password = '******'; Edited
$mosConfig_db = 'elxis';
$mosConfig_dbprefix = 'elx_';
$mosConfig_dbtype = 'mysql';
$mosConfig_lang = 'english';
$mosConfig_pub_langs = 'english,greek';
$mosConfig_alang =  'english';
$mosConfig_absolute_path = 'C:/wamp/www/cms/elxis';
$mosConfig_live_site = 'http://localhost/cms/elxis';
$mosConfig_sitename = 'Elxis CMS DEMO';
$mosConfig_shownoauth = '0';
$mosConfig_useractivation = '1';
$mosConfig_uniquemail = '1';
$mosConfig_offline_message = 'This site is down for maintenance.<br />Please check back again soon.';
$mosConfig_error_message = 'This site is temporarily unavailable.<br />Please notify the System Administrator';
$mosConfig_debug = '0';
$mosConfig_lifetime = '900';
$mosConfig_MetaDesc = 'elxis - Open Source CMS';
$mosConfig_MetaKeys = 'elxis cms, open source, multilingual, free cms, content managment, rtl compatible, web standards, elxis.org, adodb, xhtml valid';
$mosConfig_MetaTitle = '1';
$mosConfig_MetaAuthor = '1';
$mosConfig_locale = '';
$mosConfig_offset = '-8';
$mosConfig_hideAuthor = '0';
$mosConfig_hideCreateDate = '0';
$mosConfig_hideModifyDate = '0';
$mosConfig_hideRtf = '0';
$mosConfig_hidePdf = '0';
$mosConfig_hidePrint = '0';
$mosConfig_hideEmail = '0';
$mosConfig_enable_log_items = '0';
$mosConfig_enable_log_searches = '0';
$mosConfig_enable_stats = '0';
$mosConfig_sef = '0';
$mosConfig_vote = '0';
$mosConfig_gzip = '0';
$mosConfig_multipage_toc = '1';
$mosConfig_allowUserRegistration = '1';
$mosConfig_link_titles = '0';
$mosConfig_error_reporting = -1;
$mosConfig_register_globals = 0;
$mosConfig_list_limit = '20';
$mosConfig_caching = '0';
$mosConfig_cachepath = 'C:/wamp/www/cms/elxis/cache';
$mosConfig_cachetime = '1200';
$mosConfig_mailer = 'mail';
$mosConfig_mailfrom = '*****@yahoo.com'; --->Edited
$mosConfig_fromname = 'Elxis CMS DEMO';
$mosConfig_sendmail = '/usr/sbin/sendmail';
$mosConfig_smtpauth = '0';
$mosConfig_smtpuser = '';
$mosConfig_smtppass = '';
$mosConfig_smtphost = 'localhost';
$mosConfig_back_button = '0';
$mosConfig_item_navigation = '1';
$mosConfig_secret = 'pz6oHQZPwhkNmtcS';
$mosConfig_pagetitles = '1';
$mosConfig_readmore = '1';
$mosConfig_hits = '1';
$mosConfig_icons = '1';
$mosConfig_favicon = 'favicon.ico';
$mosConfig_fileperms = '';
$mosConfig_dirperms = '';
$mosConfig_helpurl = '';
$mosConfig_ftp = '0';
$mosConfig_ftp_host = '';
$mosConfig_ftp_user = '';
$mosConfig_ftp_pass = '';
$mosConfig_ftp_port = '21';
$mosConfig_ftp_root = '';
$mosConfig_access = '1';
$mosConfig_captcha = '1';
?>


Based on information above, I hope anyone can help me.

All the best,
StenTheMan

[Farhad Sakhaei]

You can't import sql file from that folder , Try to reinstall the Elxis from scratch , Elxis installation does very matters for you ...
Try using another virtual server like XAMPP if you have problem with the current

[StenTheMan]

You can't import sql file from that folder , Try to reinstall the Elxis from scratch , Elxis installation does very matters for you ...
Try using another virtual server like XAMPP if you have problem with the current

Thanks Farhad Sakhaei,

I did perform the installation from the scratch and no error was diplayed. Basically the installation was successful but then when I deleted the installation folder, the entry page showed the errors above.

I can easily install XAMMP but it's not my nature to move out before finding out the solution or at least knowing what's the actual problem.
Wampserver 2.0 comes with Apache Server 2.2.8, PHP 5.2.6 and MySql 5.0.51b.

Still waing for other ideas

Chees

[Ivan Trebješanin]

Hi Stan,

I just installed WAMP 2.0, then Elxis, no problems at all. But, I didn't create new MySQL user, just used root account. If you created new user, maybe you forgot to grant him all permissions.

[StenTheMan]

Hi Stan,

I just installed WAMP 2.0, then Elxis, no problems at all. But, I didn't create new MySQL user, just used root account. If you created new user, maybe you forgot to grant him all permissions.

Hello Ivan,

Yes the new user with all privileges was created since first time I installed Wamp 2.0. Should I just use root with no password instead? Did u use any password? Well, I will give it a try ... Let you know soon

Thanks

[Ivan Trebješanin]

In default installation root password is blank, and I used that account. Everything left default, and works...  I did get some stupid question from Windows firewall, though.

[StenTheMan]

In default installation root password is blank, and I used that account. Everything left default, and works...  I did get some stupid question from Windows firewall, though.

Hmm . . . still no success ...   :'(

[Ivan Trebješanin]

Did you enter something as Database path during installation? If you use MySQL, this field should stay blank...