English (United Kingdom)
Jms Multi Site, formerly joomla multisite.
Create, share multiple joomla sites in few clicks !
Message
  • EU e-Privacy Directive

    This website uses cookies to manage authentication, navigation, and other functions. By using our website, you agree that we can place these types of cookies on your device.

    View e-Privacy Directive Documents

Welcome, Guest
Please Login or Register.    Lost Password?
Go to bottomPage: 1
TOPIC: Create table error [1066]
*
#4155
Create table error [1066] 14 Years, 8 Months ago Karma: 0
I got this error when I try to make slave site.

Create table error [1066] on query [CREATE TABLE IF NOT EXISTS it_acesef_extensions LIKE `skillsfo_skills`.`it_acesef_extensions`]. DB Error: Not unique table/alias: 'it_acesef_extensions' SQL=CREATE TABLE IF NOT EXISTS it_acesef_extensions LIKE `skillsfo_skills`.`it_acesef_extensions`
Create table error [1066] on query [CREATE TABLE IF NOT EXISTS it_acesef_urls LIKE `skillsfo_skills`.`it_acesef_urls`]. DB Error: Not unique table/alias: 'it_acesef_urls' SQL=CREATE TABLE IF NOT EXISTS it_acesef_urls LIKE `skillsfo_skills`.`it_acesef_urls`
Create table error [1066] on query [CREATE TABLE IF NOT EXISTS it_acesef_urls_moved LIKE `skillsfo_skills`.`it_acesef_urls_moved`]. DB Error: Not unique table/alias: 'it_acesef_urls_moved' SQL=CREATE TABLE IF NOT EXISTS it_acesef_urls_moved LIKE `skillsfo_skills`.`it_acesef_urls_moved`
Create table error [1066] on query [CREATE TABLE IF NOT EXISTS it_alpha_rating LIKE `skillsfo_skills`.`it_alpha_rating`]. DB Error: Not unique table/alias: 'it_alpha_rating' SQL=CREATE TABLE IF NOT EXISTS it_alpha_rating LIKE `skillsfo_skills`.`it_alpha_rating`

...... and so on for every table.

first I got this error says "MakeDB - DB Connection fail.WARNNOTCONNECTDB" then when I create a slave site and put new DB and USER.

Please help what this error mean..
jsohler
Junior Boarder
Posts: 33
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#4157
Re: Create table error [1066] 14 Years, 8 Months ago Karma: 54
Where is your new table prefix ?

It seems that you try replicate a website where existing table prefix is "it" into the same DB with the same table prefix "it".

When you replicate a website into the same DB, you have to provide different table prefix for each websites
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#4210
Re: Create table error [1066] 14 Years, 7 Months ago Karma: 0
Hi edwin2win;

I found this new error "Create User error [1044]: Query = [GRANT ALL PRIVILEGES ON `wounded_test`.* TO `wounded_test`@`localhost` IDENTIFIED BY 'PW_HERE' WITH GRANT OPTION;], DB Message = [Access denied for user 'woundeds_rbmstr'@'localhost' to database 'wounded_test' SQL=GRANT ALL PRIVILEGES ON `wounded_test`.* TO `wounded_test`@`localhost` IDENTIFIED BY 'PW_HERE' WITH GRANT OPTION;]"

do you have any idea why I came up with this error and possible solution in regards this problem please help..
jsohler
Junior Boarder
Posts: 33
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#4216
Re: Create table error [1066] 14 Years, 7 Months ago Karma: 54
That mean that the user you provided were not present and that JMS has tried to create the user for you and it fails.
When the MySQL user that you provide is correct, Jms does not try to create it.
So provide a correct MySQL user.
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1
get the latest posts directly to your desktop
2Win, Multisite(s) are trademarks of Edwin2Win.
Joomla