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: 12
TOPIC: How to change jos_ prefix?
#11
How to change jos_ prefix? 16 Years ago Karma: 0
When I go to the server area of global configuration- which is where I assume the jos_ prefix would need to be changed, I see:
WARNING! Do not change unless you have a database built using tables with the prefix you are setting.

I don't have a database built with different values, and have no idea how to change this without breaking the entire install.

I have actually read most of the documentation, and understand that this needs to be changed, yet not a word on how to change it.

What do I do?
crashmodem
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2008/12/09 20:27 By crashmodem.
The administrator has disabled public write access.
 
#14
Re:How to change jos_ prefix? 16 Years ago Karma: 54
When you use the Joomla Installation and you arrive the the database page where you can specify the server, db name, user and password you have to open the advanced setting pannel to have access to the table prefix.
See the "demo installation" document that show you that.

When you create a new slave site with JMS with it replication, you just have to give the new table prefix and JMS will do the job for you like you had to do with the "advanced setting" panel of Joomla.
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#72
Re:How to change jos_ prefix? 15 Years, 11 Months ago Karma: 0
I have a similar probem. At the time of installation I did not change the jos_ prefix to master_ as I was supposed to.

Is it possible to go back now and make the replacement without incident?
traz
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#73
Re:How to change jos_ prefix? 15 Years, 11 Months ago Karma: 54
NO, in Joomla, there is no method to rename the jos_ into master_.
You can either use a PHPMyAdmin tool or similar to perform the MySQL rename table;
OR you can use JMS replication mechanism to duplicate the jos_ tables into master_. When the replication is performed, you could delete the jos_.
It this is freesh installation (as I suppose), this is faster to re-do it.
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#83
Re:How to change jos_ prefix? 15 Years, 11 Months ago Karma: 0
The PHP Admin Tool did the trick - allowed me to go back and rename all of the files with jos_ to master_ I then went into the configuration file and replaced jos_ with master_ and everything works!!
traz
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#538
Re:How to change jos_ prefix? 15 Years, 9 Months ago Karma: 0
I had the same problem, and fixed it using the following sql statement inside the php admin:
Code:

ALTER TABLE jos_tablename RENAME TO master_tablename


You have to do this for every table name in the database. Then open the configuration.php file, and change the prefix from jos_ to master_.
djooky
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 12
get the latest posts directly to your desktop
2Win, Multisite(s) are trademarks of Edwin2Win.
Joomla