Elxis CMS Forum

Support => Installation => Topic started by: lifemaker on October 11, 2007, 15:53:03

Title: Missing db tables
Post by: lifemaker on October 11, 2007, 15:53:03
Hi,

For two days I'm trying to install Elxis to see what I can do with it (at least I can translate it  :) ), unfortunately...

I've created db and user uploaded the files ans set up chmd and configuration.
I receive following error:

DB function failed with error number 1146
Table 'landineu_property.elx_core_acl_access_lists' doesn't existDB function failed with error number 1146
Table 'landineu_property.elx_session' doesn't exist
SQL =
SELECT session_id FROM elx_session WHERE session_id='8022a9f0b74d67c676e6e6175e963301'

As I can follow posts in forum I can sea that there is no tables created.
Could you please tell me how to create required tables.

PHP version 4.4.6
MYSQL - 4.1.22

Thank you in advance for your patience and understanding.
Title: Re: Missing db tables
Post by: Farhad Sakhaei on October 11, 2007, 17:06:54
which options did you select in installation , i think you checked the backup existing database...
Title: Re: Missing db tables
Post by: lifemaker on October 12, 2007, 11:45:40
   I receive this error in very beginning of instalation (stage 1; I even can't see first page).
   I think I'll dlete everithing and start from begining.
   
   Farhad Sakhaei, thnx for your quick reply...
   
Title: Re: Missing db tables
Post by: Farhad Sakhaei on October 12, 2007, 12:14:57
you are welcome, what is your hosting panel ? because i checked ELXIS on very panel's (cpanel , virtualmin , ...) and also on both platforms (linux and windows) , it works correctly , but please attention that may be some servers hasn't correct settings , so you should install it properly

i think you should check the sessions on that server ...
Title: Re: Missing db tables
Post by: lifemaker on October 12, 2007, 13:28:31
I ve tried everithing from very beginning, unfortunately the same mistake. (I'm sure I'm doing something wrong :()
Hosting panel is cpanel.

Is there any way to import ready tables and after installation to modify them?

Now I'll try to istall it locally with XAMPP and to upload DB and rest later, what would be your advise?
if no success, I'll try once again and you'll be well informed about each of my steps...

I have a lot of CMS, but dont want them..., this is the reason to insist on ELXIS CMS.

Thank you for your support Farhad Sakhaei
Title: Re: Missing db tables
Post by: Farhad Sakhaei on October 12, 2007, 14:00:34
you can install Elxis on localhost , and then move it to the server , so you need to transfer file to the server and take a .sql backup from your local database and then import that to PHPMyAdmin , and alsi you need to rename all localhost words to your domain name in .sql file ... finally you should edit your configuration.php file and reset the values of your new database name and user & pass and domain name ,etc ...

but i think you have some problems on your server of host , so you may have another problems, when you transfer from local to server ...
Title: Re: Missing db tables
Post by: lifemaker on October 12, 2007, 14:32:26
Tree times I receive:

"For your security please completely remove the installation directory including all files and sub-folders - then refresh this page"   when after all preparations i type http://mydomain.com  to start the instllation process.

I didn't start installation yet, but receive such a notice...?


THNX...
Title: Re: Missing db tables
Post by: Farhad Sakhaei on October 12, 2007, 14:42:26
remove your configuration.php file
Title: Re: Missing db tables
Post by: Ivan Trebješanin on October 12, 2007, 15:04:40
"For your security please completely remove the installation directory including all files and sub-folders - then refresh this page"   when after all preparations i type http://mydomain.com  to start the instllation process.

DON'T remove configuration.php, just do what it says: remove installation directory, and you're done! Successful instalation!
Title: Re: Missing db tables
Post by: lifemaker on October 12, 2007, 15:31:11
Guys here is flow of process:

1. I creade database and database use (later copied to sonfiguration.php).
2. Upload ELXIS files to my /home/myname/public_html directory.
3. Writing values for configuration.php file (only values changed are listed):

$mosConfig_user = 'database_username;      
$mosConfig_password = 'database_password';   
$mosConfig_db = 'database_name';      
$mosConfig_dbprefix = 'elx_';      
$mosConfig_dbtype = 'mysql';
- - - - - - - - - - - - - - - - - - - - -
$mosConfig_absolute_path = '';      //I dobt about it
$mosConfig_live_site = 'http://www.mysite.com';
- - - - - - - - - - - - - - - - - - - - -
$mosConfig_cachepath = '/cache';
- - - - - - - - - - - - - - - - - - - - -

Additional info, I never passed first stage:
------ at first I had an error #1146-missing tables in db.
Cleared everything, uploaded again (I thought some files are modified during previous try, that's why I HAD to upload everithing :()
------second time I faced this warning message, to delete installation folder
Title: Re: Missing db tables
Post by: Ivan Trebješanin on October 12, 2007, 15:38:04
I just want to make it short: some hosts are not configured to support utf-8, and no matter what you do, you can't run elxis on them.
Example: netfirms.com

ADVICE: change host

NOTICE:
I don't want to put down any hosting provider, it's just my experience
Title: Re: Missing db tables
Post by: Farhad Sakhaei on October 12, 2007, 17:37:09
yes , change your host, how much space do u need , i can offer it for you , it is compatible 100% with elxis