Running 2 php-nuke sites on 1 mySQL database

Nuke Cadet Joined: Jun 29, 2005 Posts: 2

I have the same problem. I paid for version phpnuke 7.8 and its not working in there. My phpnuke 7.7 version worked on my local box (Windows IIS) so I uploaded 7.8 to my service provider and now prefrences won't save.

Nuke Cadet Joined: Jun 29, 2005 Posts: 2

Found the problem.

When I installed PHPNuke i took the nuke.sql file and replace all occurences of nuke with my new prefix. I set the prefix in the config.php file and thought all is fine, but it was not. I now created a database with the standard nuke prefix and my site is fine.

Either some nuke got replaced with my prefix that should not have been or that must be a bug in PHPNuke.

Corporal Joined: Jun 17, 2005 Posts: 63

ya well my first site is already using the default prefix of nuke_ in the mySQL database..so cant make another one cause it will say its already there.

Site Admin Joined: Aug 17, 2003 Posts: 12397

This simple script will give you the SQL commands to rename your tables. Run in the root where your config.php is. Just take the output of this script and run in phpMyAdmin

rename.php

Code:

<?php

require_once("config.php");

mysql_connect($dbhost, $dbuname, $dbpass, $dbname);
$result = mysql_list_tables($dbname);
while ($row = @mysql_fetch_row($result) or die(mysql_error())) {
$table = $row[0];
if (eregi($prefix, $table)) {
echo "ALTER TABLE $row[0] RENAME ".eregi_replace("nuke_","","NEWPREFIX_".$table."").";<br>";
}

}

?>

Replace NEWPREFIX as appropriate