Elxis CMS Forum

Support => Installation => Topic started by: vago on April 05, 2011, 11:05:52

Title: Two Installations Same Issue - database errors [SOLVED]
Post by: vago on April 05, 2011, 11:05:52

Hi guys,

I'm new to Elxis and keen to get started with it. I am trying to get it setup on two different server/hosts/domain
Thank you for your help in solving these problems.

~vago


#1 http://www.searchcountry.net

I went through the entire setup process, deleted the setup files, thought I had been successful, but now I get these messages when I visit the domain:

mysql Error [1146] : EXECUTE
DB function failed with error number 1146
Table 'tangierb_hotel.1234_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 'tangierb_hotel.1234_session' doesn't exist
SQL =

SELECT session_id FROM 1234_session WHERE session_id='f4dcbbb838f339ac0bcc8f0892cd8cd5'




#2 http://www.istanbulhotelplanner.com

I think this is the same problem, but I am not completing the setup on this one until I find the problem
When I reach the database step, I get the following errors when I put _xls as the database table prefix.

mysql error [1142] : EXECUTE
URI: index.php
Message: CREATE command denied to user 'C259477_vago'@'98.130.2.110' for table 'elx_banner'
CREATE TABLE `elx_banner` ( `bid` INTEGER NOT NULL AUTO_INCREMENT, `cid` INTEGER NOT NULL DEFAULT 0, `type` VARCHAR(10) NOT NULL DEFAULT 'banner', `name` VARCHAR(50), `imptotal` INTEGER NOT NULL DEFAULT 0, `impmade` INTEGER NOT NULL DEFAULT 0, `clicks` INTEGER NOT NULL DEFAULT 0, `imageurl` VARCHAR(100), `clickurl` VARCHAR(200) NOT NULL, `dateadded` TIMESTAMP NOT NULL, `showbanner` TINYINT NOT NULL DEFAULT 0, `checked_out` TINYINT NOT NULL DEFAULT 0, `checked_out_time` DATETIME NOT NULL DEFAULT '1979-12-19 00:00:00', `editor` VARCHAR(50), `custombannercode` TEXT, `targetbanner` TINYINT NOT NULL DEFAULT 1, PRIMARY KEY (`bid`) ) TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci
mysql error [1142] : EXECUTE
URI: index.php
Message: ALTER command denied to user 'C259477_vago'@'98.130.2.110' for table 'elx_banner'
ALTER TABLE `elx_banner` ADD INDEX `elx_viewbanner` (`showbanner`)
mysql error [1142] : EXECUTE
URI: index.php
Message: CREATE command denied to user 'C259477_vago'@'98.130.2.110' for table 'elx_bannerclient'
CREATE TABLE `elx_bannerclient` ( `cid` INTEGER NOT NULL AUTO_INCREMENT, `name` VARCHAR(60), `contact` VARCHAR(60), `email` VARCHAR(60), `extrainfo` TEXT, `checked_out` TINYINT NOT NULL DEFAULT 0, `checked_out_time` DATETIME, `editor` VARCHAR(50), PRIMARY KEY (`cid`) ) TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci
mysql error [1142] : EXECUTE
URI: index.php
Message: CREATE command denied to user 'C259477_vago'@'98.130.2.110' for table 'elx_bannerfinish'
CREATE TABLE `elx_bannerfinish` ( `bid` INTEGER NOT NULL AUTO_INCREMENT, `cid` INTEGER NOT NULL DEFAULT 0, `type` VARCHAR(10), `name` VARCHAR(50), `impressions` INTEGER NOT NULL DEFAULT 0, `clicks` INTEGER NOT NULL DEFAULT 0, `imageurl` VARCHAR(50), `datestart` DATETIME, `dateend` DATETIME, PRIMARY KEY (`bid`) ) TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci
mysql error [1142] : EXECUTE
URI: index.php
Message: CREATE command denied to user 'C259477_vago'@'98.130.2.110' for table 'elx_categories'
CREATE TABLE `elx_categories` ( `id` INTEGER NOT NULL AUTO_INCREMENT, `parent_id` INTEGER NOT NULL DEFAULT 0, `title` VARCHAR(120), `name` VARCHAR(255), `image` VARCHAR(100), `section` VARCHAR(120), `image_position` VARCHAR(10), `description` TEXT, `published` TINYINT NOT NULL DEFAULT 0, `checked_out` INTEGER NOT NULL DEFAULT 0, `checked_out_time` DATETIME NOT NULL DEFAULT '1979-12-19 00:00:00', `editor` VARCHAR(50), `ordering` INTEGER NOT NULL DEFAULT 0, `access` INTEGER NOT NULL DEFAULT 29, `count` INTEGER NOT NULL DEFAULT 0, `params` TEXT, `language` VARCHAR(255), `seotitle` VARCHAR(255), PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci
mysql error [1142] : EXECUTE
URI: index.php
Message: ALTER command denied to user 'C259477_vago'@'98.130.2.110' for table 'elx_categories'
ALTER TABLE `elx_categories` ADD INDEX `elx_cat_idx` (`section`, `published`, `access`)
mysql error [1142] : EXECUTE
URI: index.php
Message: ALTER command denied to user 'C259477_vago'@'98.130.2.110' for table 'elx_categories'
ALTER TABLE `elx_categories` ADD INDEX `elx_idx_section` (`section`)
mysql error [1142] : EXECUTE
URI: index.php
Message: ALTER command denied to user 'C259477_vago'@'98.130.2.110' for table 'elx_categories'
ALTER TABLE `elx_categories` ADD INDEX `elx_idx_access` (`access`)
mysql error [1142] : EXECUTE
URI: index.php

and more...

Title: Re: Two Installations Same Issue - database errors
Post by: vago on April 05, 2011, 11:15:36

Okay, I think I figured out the problem with IstanbulHotelPlanner.com, it was a permissions issue...

Is there any way to fix searchcountry though?

thank you.

~vago

Title: Re: Two Installations Same Issue - database errors
Post by: rentasite on April 05, 2011, 12:04:01

Quote

Table 'tangierb_hotel.1234_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 'tangierb_hotel.1234_session' doesn't exist
SQL =

As you can see: Those 2 tables do not exist in the database.

Start the installation from scratch.. and do not rename the table's prefix.

Title: Re: Two Installations Same Issue - database errors
Post by: vago on April 05, 2011, 15:02:21

Thank you. Problem solved. You rule.

Title: Re: Two Installations Same Issue - database errors
Post by: rentasite on April 05, 2011, 21:04:58

mark the 1st topic/subject as SOLVED  ;)