Help: Installation Error: mysql error [1146]

[de-active]

Hi everyone,

Finally I've decided to try out Elxis by attempting to install it and playing around with it but I've encountered some problems upon installation. I followed the instructions forum.elxis.org/index.php?topic=1544.0 from Datahell.

I'm using Windows XP as the local machine with FireFox browser. I have a hosting account with ...

The problems:
1. It says on number 6. Make sure everything is owned by the local user.....
Ehh I didn't do this because I didn't know how? I've changed the  file permissions but how on earth do you change ownership? I'm using the cpanelX to create the mySQL db

mysql Error [1146] : EXECUTE
URI: index.php
Message: Table 'book1_elxisdb.elx_1core_acl_access_lists' doesn't exist
SELECT * FROM elx_1core_acl_access_lists
DB function failed with error number 1146
Table 'book1_elxisdb.elx_1core_acl_access_lists' doesn't exist
mysql Error [1146] : EXECUTE
URI: index.php
Message: Table 'book1_elxisdb.elx_1menu' doesn't exist
SELECT id, link FROM elx_1menu WHERE menutype='mainmenu' AND published='1' AND ((language IS NULL) OR (language LIKE '%english%')) ORDER BY parent, ordering LIMIT 0,1
mysql Error [1146] : EXECUTE
URI: index.php
Message: Table 'book1_elxisdb.elx_1templates_menu' doesn't exist
SELECT template FROM elx_1templates_menu WHERE client_id='0' AND menuid='0'
mysql Error [1146] : EXECUTE
URI: index.php
Message: Table 'book1_elxisdb.elx_1session' doesn't exist
DELETE FROM elx_1session WHERE (time < 1240053704)
mysql Error [1146] : EXECUTE
URI: index.php
Message: Table 'book1_elxisdb.elx_1session' doesn't exist
SELECT * FROM elx_1session WHERE session_id='9f0abf628d085149735ee358a57a9a85'
mysql Error [1146] : EXECUTE
URI: index.php
Message: Table 'book1_elxisdb.elx_1session' doesn't exist
SELECT session_id FROM elx_1session WHERE session_id='1aa243a00565b0a97af5d0c43b2d5b1d'
DB function failed with error number 1146
Table 'book1_elxisdb.elx_1session' doesn't exist
SQL =SELECT session_id FROM elx_1session WHERE session_id='1aa243a00565b0a97af5d0c43b2d5b1d'

I've done two clean fresh installation and the same errors come up, can someone please help? 

I have created a DB and assigned a user to it but and "removed" the installation directory, actually I haven't removed it because I didn't know if the term remove meant "delete", so I just created a new folder and put the installation folder in that    I didn't create the table, because the installation didn't ask me to create them, it just asked to create a DB with username and I though the installation would create the table in the db?

Help please, it is much appreciated it.

[datahell]

Here is a small installation guide

Prepare database
1. Go to your hosting control panel.
2. Create a new and empty database.
3. Create a user and assign him to the newly created database.
4. Go to your database using phpmyadmin and make sure database collation and default charset are utf8_general_ci.

Install Elxis
1. Open your browser and navigate to your site. You will be redirected to the Elxis installer.
2. Fill in all required details and use the db info from the database you just created.
3. Follow the installer instructions till you complete all steps.
4. When finish delete folder installation/

Note 1: You get this error because the database does not exist and the user you use does not have the required privileges to create it. Follow the "Prepare database" guide.
Note 2: "remove" means "delete"

[de-active]

Hi datahell, many many thanks for your response, unfortunately I am still facing the same problems. I tried to follow your guide step by step.

I've created a new db and assigned a new user to the db.

Using phpmyadmin, I've checked the db, but  utf8_general_ci is only for the collation and not utf8_general_ci for the charset. I couldn't find anyway of changing the charset to utf8_general_ci. From the drop down menu it only gives an option of

MySQL connection collation:  utf8_general_ci
MySQL charset:  UTF-8 Unicode (utf8)

I couldn't change the charset to utf8_general_ci ---how do I change this, it doesn't give me the option.

Just two notes:
1. I've deleted the installation files and refreshed my home page and still same error.
2. My original db has 42 tables, so why does the error say the db or table doesn't exist.

[datahell]

I meant collation, no charset, sorry.
So, you created the db and the user. What's next? Did the installation completed successfully?

[de-active]

no still the same problem, i'm willing to give access to anyone, since it's just a test site so no significance at all

[datahell]

Send me if you wish username/password for your control panel and your database. I can try to install Elxis by myself.

[wisdomci]

Please what is the instruction for upgrading from 2008.1 version to 2009?

Thanks

Here is a small installation guide

Prepare database
1. Go to your hosting control panel.
2. Create a new and empty database.
3. Create a user and assign him to the newly created database.
4. Go to your database using phpmyadmin and make sure database collation and default charset are utf8_general_ci.

Install Elxis
1. Open your browser and navigate to your site. You will be redirected to the Elxis installer.
2. Fill in all required details and use the db info from the database you just created.
3. Follow the installer instructions till you complete all steps.
4. When finish delete folder installation/

Note 1: You get this error because the database does not exist and the user you use does not have the required privileges to create it. Follow the "Prepare database" guide.
Note 2: "remove" means "delete"

[datahell]

Upgrade from Elxis 2008.1 to 2009.0 has not yet being released.
It will be released an official patch. Please wait.