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: mysql error
#11162
mysql error 11 Years, 9 Months ago Karma: 0
Hello!

There was one more problem, at duplication of the second site, gives out here such error of mysql


Error(1) [1142] query [CREATE OR REPLACE VIEW headrush_users AS SELECT * FROM 'fightwear4'.'u1weg_users']. DB Error: ANY command denied to user 'h_root' @ for table '%' 'u1weg_users' SQL=CREATE OR REPLACE VIEW headrush_users AS SELECT * FROM 'fightwear4'.'u1weg_users'

and just the same mistake according to all tables + copies only the following folders in the necessary directory: cache, logs, tmp, configuration.php
and everything, has to after all copy still templates, but copying doesn't happen. All settings of a template look as follows:


$templates['site.com'] = array(
'fromSiteID' => ':master_db:',
'validity_unit' => 'days',
'toDomains' => array( 'site.com', 'www.site.com'),
'toSiteID' => 'site.com',
'adminUserID' => '42',
'toDBHost' => 'localhost',
'toDBName' => 'name',
'toDBUser' => 'user',
'toDBPsw' => 'pass',
'toPrefix' => 'pref_',
'toSiteName' => 'site',
'setDefaultJLang' => 'en-GB',
'setDefaultTemplate' => 'beez5',
'deploy_dir' => '/var/www/vhosts/site1.com/www/site.com/',
'toFTP_enable' => '1',
'toFTP_host' => 'myhost',
'toFTP_user' => 'user',
'toFTP_psw' => 'pass',
'toFTP_rootpath' => '/var/www/vhosts/site1.com/www/site.com/',
'symboliclinks' => array( 'administrator' => array( 'action' => 'SL'),
'cache' => array( 'action' => 'mkdir', 'readOnly' => '1'),
'cli' => array( 'action' => 'SL'),
'components' => array( 'action' => 'SL'),
'fancyapps-fancyBox-3a66a9b' => array( 'action' => 'SL'),
'images' => array( 'action' => 'special'),
'includes' => array( 'action' => 'SL'),
'installation' => array( 'action' => 'dirlinks'),
'language' => array( 'action' => 'SL'),
'libraries' => array( 'action' => 'SL'),
'logs' => array( 'action' => 'mkdir', 'readOnly' => '1'),
'market' => array( 'action' => 'SL'),
'media' => array( 'action' => 'SL'),
'modules' => array( 'action' => 'copy'),
'multisites' => array( 'action' => 'SL'),
'picture_library' => array( 'action' => 'SL'),
'plesk-stat' => array( 'action' => 'SL'),
'plugins' => array( 'action' => 'SL'),
'templates' => array( 'action' => 'copy'),
'tmp' => array( 'action' => 'mkdir', 'readOnly' => '1'),
'zipimport' => array( 'action' => 'SL'),
'.htaccess' => array( 'action' => 'SL'),
'1.php' => array( 'action' => 'SL'),
'LICENSE.txt' => array( 'action' => 'SL'),
'README.txt' => array( 'action' => 'SL'),
'analyticstracking.php' => array( 'action' => 'SL'),
'beckap_12_01_2013.zip' => array( 'action' => 'SL'),
'blago.html' => array( 'action' => 'SL'),
'brends.php' => array( 'action' => 'SL'),
'brends_adminka.php' => array( 'action' => 'SL'),
'defines.php' => array( 'action' => 'SL'),
'fancybox_setings.js' => array( 'action' => 'SL'),
'favicon.ico' => array( 'action' => 'SL'),
'fightmap.png' => array( 'action' => 'SL'),
'fw_backap.zip' => array( 'action' => 'SL'),
'htaccess.txt' => array( 'action' => 'SL'),
'jsys.php' => array( 'action' => 'SL'),
'robots.txt' => array( 'action' => 'SL'),
'sea.html' => array( 'action' => 'SL'),
'test.php' => array( 'action' => 'SL'),
'titles_and_desc.php' => array( 'action' => 'SL'),
'web.config.txt' => array( 'action' => 'SL'),
'yandex_66e030b87f64a020.html' => array( 'action' => 'SL'),
'index.php' => array( 'action' => 'redirect', 'readOnly' => '1'),
'index2.php' => array( 'action' => 'redirect', 'readOnly' => '1')),
'dbsharing' => array( 'dbsh_UserSharing' => 'Joomla', 'dbsh_VirtueMart' => 'on'));


Help please..
benshee
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#11163
Re:mysql error 11 Years, 9 Months ago Karma: 0
sorry, this problem solved, simply do not have enough rights to the database

Topic delete will not, who can come in handy
benshee
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#11167
Re:mysql error 11 Years, 9 Months ago Karma: 54
Happy to see that you found the solution yourself
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