Re:Error(1) [1142] query [CREATE OR REPLACE VIEW 15 Years, 4 Months ago
|
Karma: 0
|
Hi again, I want to install multi-site in other domain that is on the server I`m think to tranfer the website, I want to install mult-sites in other domain for test and then if it works I`ll then tranfer the website I`m developing by changing the DNS, is that posible?
|
|
|
|
|
Re:Error(1) [1142] query [CREATE OR REPLACE VIEW 15 Years, 4 Months ago
|
Karma: 54
|
Theorically YES.
If you are developing a website in another hosting provider and that later you decide to transfert the domain or just redefine the DNS setting then this will be in your new hosting company that you will have to define the new domain name (like the slave site).
|
|
|
|
|
Re:Error(1) [1142] query [CREATE OR REPLACE VIEW 14 Years, 9 Months ago
|
Karma: 0
|
Hi
I have had this issue too. I use Cpanel, so I asked my host to check MySQL user permissions. The host support tell me that the MySQL user permissions are fine. SO I'm stuck again.
I was able to create a new site 'slavemaster' using multisites without a template (copy from master) - then the installer process ran and created all the tables.
I have then used 'slavemaster' site to create a template for the slave sites, per your tutorial video on "User Sharing".
But when I try to create the new slave site from the template, it spits the error as above and does not create tables for the new slave site. I'm using one database for the master, then a second database for the slavemaster (table prefix slavemaster_) and all the resulting slave sites (prefix sslave1_) .
Can you please give me any more tips? Or do you need more info to diagnose?
Hosting: rochenhost.com Linux
Joomla version 1.5.15,
Multisite version 1.2.19 . All patches installed OK.
Thank you very much for any help
Dex
|
|
dex
Fresh Boarder
Posts: 6
|
|
|
Re:Error(1) [1142] query [CREATE OR REPLACE VIEW 14 Years, 9 Months ago
|
Karma: 54
|
MySQL User are NOT fine.
Give them the query that you have to execute with your MySQL user login.
They have to add the create and show view privileges.
Tell them to go in PHPMyAdmin.
Select the privileges menu.
Click on your MySQL user.
Enable the Create and Show view that are NOT set by cPanel.
Know bug (or limitation) in cPanel.
|
|
|
|
|
Re:Error(1) [1142] query [CREATE OR REPLACE VIEW 14 Years, 9 Months ago
|
Karma: 0
|
thank you very much, I will do that.
Dex
|
|
dex
Fresh Boarder
Posts: 6
|
|
|
|