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?

Error(1) [1142] query [CREATE OR REPLACE VIEW
(1 viewing) (1) Guest
Go to bottomPage: 123
TOPIC: Error(1) [1142] query [CREATE OR REPLACE VIEW
#1527
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?
liliam
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#1529
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).
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3494
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
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3502
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.
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3516
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
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 123
get the latest posts directly to your desktop
2Win, Multisite(s) are trademarks of Edwin2Win.
Joomla