Running 2 php-nuke sites on 1 mySQL database

Corporal Joined: Jun 17, 2005 Posts: 63

I have 3 domain names.... on my main one i have a phpnuke website... unfortunately with my host I only have 1 mySQL database.... the default sql settings for phphnuke is... nuke_ which goes to database. if i were to mod the nuke_sgl file and point it to something else... would the php nuke site on the new domain still be able to work?

main question... can i have two php-nuke sites running on one SQL database?
and if so.. what is required to do so.. thanks

Posted: Sat Jun 18, 2005 11:56 pm

With one DB, multiple phpnukes work very well ONLY IF YOU ARE USING DIFFERENT PREFIX. This means that your DB field will have different names. Good Luck.

Corporal Joined: Jun 17, 2005 Posts: 63

how do i use diff prefix? i am sure u gotta go in the nuke.sql file and change every location of nuke_ to whatever.... say... solo_ but what else do i need to change other than the nuke.sql file?

Site Admin Joined: Aug 17, 2003 Posts: 12397

$prefix values in your config.php

Corporal Joined: Jun 17, 2005 Posts: 63

okay so if i change the prefix value in the config.php.... i must also manually change all the stuff in the nuke.sql file before i upload it to mySQL correct? so they will be installed as solo_ instead of nuke_ in my database..

Site Admin Joined: Aug 17, 2003 Posts: 12397

Exactly

Corporal Joined: Jun 17, 2005 Posts: 63

okay got all the done with the renaming... uploaded nuke to new site... but comin across a prob right now.... i went to admin.php... made GOD username and copied it as reg user... went to preferences.. and all the fields were blank.... tried to add stuff to it... and hit save but doesnt save... what is causing this? thanks

Corporal Joined: Jun 17, 2005 Posts: 63

okay here is what i put on the .sql file...

Code:

$dbhost = "db205.perfora.net";
$dbuname = "MYUSERNAME";
$dbpass = "MYPASSWORD";
$dbname = "MYDATABASENAME";
$prefix = "tater";
$user_prefix = "tater";
$dbtype = "MySQL";
$sitekey = "MYSITEKEY";
$gfx_chk = 0;
$subscription_url = "";
$admin_file = "admin";

ALL THE CRUCIAL stuff I put in caps to protect my sensitive info..

did i just need to change $prefix and leave$user_prefix ="nuke"?? Or did i do it correctly? everything else on the site is saving... besides the preferences in admin.....

my host is linux.. so what files do i need to CHMod to allow admin pref to write.. everything works well on my other site... didnt have this prob before... thanks..

Site Admin Joined: Aug 17, 2003 Posts: 12397

It should be correct. I'm not sure why you cannot get to preferences. Try and make sure you have the table tater_config and it has data in it

Corporal Joined: Jun 17, 2005 Posts: 63

yes.. tater_config is in my database... i can get into admin preferences... its just blank... and doesnt save data when i click submit..

Corporal Joined: Jun 17, 2005 Posts: 63

Any other suggestions?? kinda really bugging me that its not saving stuff... cant very well go on with the site if i cant save the basic settings =/

Corporal Joined: Jun 17, 2005 Posts: 63

?

Private Joined: Apr 22, 2005 Posts: 42

i had a similar problem once because I had the wrond DB type entered:
$dbtype = "MySQL"; vs $dbtype = "MySQL4"; etc.
may not be your problem, but maybe...

Corporal Joined: Jun 17, 2005 Posts: 63

ugh... cmon anyone have a clue?? everything else on this site saves.... (forums, news, journals, users, etc) only thing that WILL not save is Preferences in the ADMIN section..... what can i do to fix this??? thanks..

Corporal Joined: Jun 17, 2005 Posts: 63

okay.. since phpnuke 7.7 just got released for free... i downloaded that.. and replaced this whole site... with this update... and it still isnt having anything in the preferences section in admin... and still not saving... so its telling me that its gotta be something with the database...or a broken link in the php thats not having the info in it... but i think its a database problem.. so how can i fix this database for preferences in MYSQL.... can i manually add stuff in database for preferences? if so how? thanks..