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: Virtuemart sharing
#3698
Virtuemart sharing 14 Years, 1 Month ago Karma: 0
Hi,

When I try to share virtuemart I get the following error:

Error [1064] query [CREATE OR REPLACE VIEW ns_vm_auth_group AS SELECT * FROM `equip2009_63937`.`jos_vm_auth_group`]. DB Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR REPLACE VIEW ns_vm_auth_group AS SELECT * FROM `equip2009_63 SQL=CREATE OR REPLACE VIEW ns_vm_auth_group AS SELECT * FROM `equip2009_63937`.`jos_vm_auth_group`

Could anyone help me to solve this?

Thanks
godo
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3858
Re: Virtuemart sharing 14 Years, 1 Month ago Karma: 1
If Linux, set all your permissions to 777 just to install. Reset back when finished.
Don't know about windows.
Bendo
Fresh Boarder
Posts: 11
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3865
Re: Virtuemart sharing 14 Years, 1 Month ago Karma: 54
Are you sure that your are using a MySQL 5.0 for the DB where the table prefix is "ns_"

Also check that you have a DB called "equip2009_63937" with table "os_vm_auth_group"
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