Elxis CMS Forum
Support => Installation => Topic started by: uyghurmen on March 06, 2011, 00:28:06
-
After Installation shown belove message:
mysql Error [1146] : EXECUTE
URI: index.php
Message: Table 'eynekbiz_sinaq.elx_sinaqcore_acl_access_lists' doesn't exist
SELECT * FROM elx_sinaqcore_acl_access_lists
DB function failed with error number 1146
Table 'eynekbiz_sinaq.elx_sinaqcore_acl_access_lists' doesn't exist
mysql Error [1146] : EXECUTE
URI: index.php
Message: Table 'eynekbiz_sinaq.elx_sinaqmenu' doesn't exist
SELECT id, link FROM elx_sinaqmenu 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 'eynekbiz_sinaq.elx_sinaqtemplates_menu' doesn't exist
SELECT template, params FROM elx_sinaqtemplates_menu WHERE client_id='0' AND menuid='0' LIMIT 0,1
mysql Error [1146] : EXECUTE
URI: index.php
Message: Table 'eynekbiz_sinaq.elx_sinaqsession' doesn't exist
DELETE FROM elx_sinaqsession WHERE (time < 1299362830)
mysql Error [1146] : EXECUTE
URI: index.php
Message: Table 'eynekbiz_sinaq.elx_sinaqsession' doesn't exist
SELECT * FROM elx_sinaqsession WHERE session_id='a2b825aa57a8b657ef667c0f1cdd6968'
mysql Error [1146] : EXECUTE
URI: index.php
Message: Table 'eynekbiz_sinaq.elx_sinaqsession' doesn't exist
SELECT session_id FROM elx_sinaqsession WHERE session_id='2a18a86970fba814496e19baa0a2a3ed'
DB function failed with error number 1146
Table 'eynekbiz_sinaq.elx_sinaqsession' doesn't exist
SQL =
SELECT session_id FROM elx_sinaqsession WHERE session_id='2a18a86970fba814496e19baa0a2a3ed'
-
I guess the database tables didn't created during install. You have to re-install Elxis. If you have mysql 5.2 there is a mysql bug with the usage of "TYPE" instead of "ENGINE" term.
To solve/type/engine bug on mysql 5.2 do this.
Open includes/adodb/adodb-datadict.inc.php
go to line 590
change this:
$sql[0] .= ' TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci';
to this:
$sql[0] .= ' ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci';
Re-install Elxis after that.
-
My MYSQL information is:
Server: Localhost via UNIX socket
Server version: 5.0.91-community
Protocol version: 10
User: eynekbiz@localhost
MySQL charset: UTF-8 Unicode (utf8)
Web server
cpsrvd 11.28.83
MySQL client version: 4.1.22
PHP extension: mysql
Right now another problem is: not running installation wzard, message said: delete the installation files
delete and upload again, also same, not running, same mesasage.
-
I guess the database tables didn't created during install. You have to re-install Elxis. If you have mysql 5.2 there is a mysql bug with the usage of "TYPE" instead of "ENGINE" term.
To solve/type/engine bug on mysql 5.2 do this.
Open includes/adodb/adodb-datadict.inc.php
go to line 590
change this:
$sql[0] .= ' TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci';
to this:
$sql[0] .= ' ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci';
Re-install Elxis after that.
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'sinaq1'@'localhost' (using password: YES) in /home/eynekbiz/public_html/sinaq/includes/adodb/drivers/adodb-mysql.inc.php on line 364
and Time zone problem . I don't know where is the php.ini?
and I don't know about "Database Table Prefix:" How to fill?
-
It seems that the problem is with your database user. To prepare a database for elxis to install do the following:
- Go to your web hosting control panel and create a new database.
- Create a new database user and assign him to the newly created database. This user will have all the required privileges for this database.
Now go to elxis installer and install elxis by using the database name, username and password you just created.
For your php.ini contact your web hosting provider.
The timezone information must always be set in php.in as of php 5.x/6.x, and should never be left empty.
-
It seems that the problem is with your database user. To prepare a database for elxis to install do the following:
- Go to your web hosting control panel and create a new database.
- Create a new database user and assign him to the newly created database. This user will have all the required privileges for this database.
Now go to elxis installer and install elxis by using the database name, username and password you just created.
For your php.ini contact your web hosting provider.
The timezone information must always be set in php.in as of php 5.x/6.x, and should never be left empty.
I did all in my control panel. Data Base, Username , password. but you have another thing : database table. What is this? How to fill? If time zone very nessary, maybe I can't use elxis.
Because I not found php.ini.
Why such as difficult install? I used alot of open source CMS not like that. very easy. one click to install.
Thanks your reply.
-
timezone is not an elxis stuff, it is pure php stuff, so it is required for any php application that uses date functions.
Timezone information it is required by php 5.1+ to be set in your server's php.ini
Related wiki documentation: http://wiki.elxis.org/wiki/Set_timezone (http://wiki.elxis.org/wiki/Set_timezone)
and also here: http://wiki.elxis.org/wiki/PHP_settings (http://wiki.elxis.org/wiki/PHP_settings)
Contact your web hosting provider, he is responsible on setting up this information in php.
You will not find php.ini in your site files, it is a server file.
BTW Elxis can work even without this as it fixes this problem automatically but you should set the proper timezone in php.ini if you want to be correct.
More info
When you install PHP timezone info it is not set by default. So php 5.1+ uses the server's timezone to fix this issue but throws a warning on every request that it is not safe to rely on server's timezone. To get rid of this warning you should set the timezone information on server's php.ini
Related information on php.net web site: http://www.php.net/manual/en/function.date-default-timezone-set.php (http://www.php.net/manual/en/function.date-default-timezone-set.php) (read the note at the top)