How Do I Install A Second PHP-Nuke?

Corporal Joined: Apr 28, 2003 Posts: 70

I have PHP-Nuke 6.5 (with sec fixes/mods) in my root directory on the site. I'd like to install 6.8 into another directory (example: www.fttguild.com/newphp/). Is there a proper procedure to do this? How do I modify the install so it won't goof up my original database? Any expertise help would be greatly appreciated!

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

That's how I have www.nukecops.com and beta.nukecops.com configured. Beta is a directory in the www.nukecops.com folder. Beta simply uses a different database is all. Plus, apache knows the beta.nukecops.com is a subdomain.

Corporal Joined: Apr 28, 2003 Posts: 70

Below is from the INSTALL file. The config.php is on problem, but the nuke.sql might be trouble for me. Do I need to manually change anything if I want a new database prefix? The 6.5 I installed was under the default "nuke_" but I think for a second install I need a different prefix like "nuke2_" right? If so, do I need to edit the nuke.sql?

Quote:

Now go to the directory where you uncompressed all files and edit the
file "config.php". Change all the fields until you are happy with the
changes and they fits the need of your web site. Give special attention
to the database configuration section. When you have finished to edit
config.php file change to the /sql/ directory and there is a file called
"nuke.sql" this file contains the commands to build the database structure,
tables and the default data.

1) Create a database called, for example, nuke:

mysqladmin create nuke

2) Now fill the databases with the tables in nuke.sql file:

mysql nuke < nuke.sql

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Right, you need to simply use a different database name.

Corporal Joined: Apr 28, 2003 Posts: 70

I feel like an idiot, it's been awhile since I first installed PHP-Nuke. I go into phpMyAdmin and create new table on my database right? Once I create a new table, do I need to do anything in nuke.sql? Gonna go read through Install forum section and see if I can "refresh" my memory...been too long...heh. Thanks so far Smile

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Actually no, not a new table, but a new database. So you would have two different databases. The mysql command:

create database newname

Corporal Joined: Apr 28, 2003 Posts: 70

Along with your post's I read: http://www.the-sci-factor.net/modules.php?name=Idiots_Guide&op=sqlsetup

I have the original database my web-host set up as MySQL 4.0.13 running on localhost as mydatabase@localhost. I've never tried to create another database. I may have to contact my host to see if I have the access level to create another database. Is that something normally granted to a subscriber?

Corporal Joined: Apr 28, 2003 Posts: 70

I'm waiting on an answer back from my web-host about another database under my name.

Could someone confirm I need a whole new database to put up another php-nuke? The default nuke.sql installs the database with the table prefix "nuke_". Isn't it possible to edit the config.php and the nuke.sql so that it installs a different table prefix like "nuke2_"? Bear with me on this while I learn as I go please. Thanks!

Posted: Fri Jul 18, 2003 8:34 am

You do not need a second database at all, you can run 100 sites or as many as you wish (if your webspace allows for that many files) on one database, here's a basic how-to:

Create a subfolder in your root (where your other site is) example NewNuke and upload Nuke's files to it.

Edit the new site's config.php, use the first site's config.php as a template, copy everything from the first config to the second one but change $prefix and $user_prefix to something different (i.e. newnuke)

Download nukesql.php for the version of Nuke you are installing, upload it to the second site's directory.

Point your browser to http://yoursiteurl/NewNuke/nukesql.php and after running the test select Default Fresh Install from the options, you will now have a second set of tables on the same database.

Corporal Joined: Apr 28, 2003 Posts: 70

Thanks for the reply chatserv. I'm gonna give it a try. I had already uploaded the new version of php-nuke into the sub-directory and edited the config.php with the new table information (so it didn't read by the default "nuke_"). I just needed to hear that what I was thinking might actually work. I was just afraid the nuke.sql would create the table entries based on it's own script. I'm very much a newb at all this...heh. Thanks again!

Corporal Joined: Apr 28, 2003 Posts: 70

OMG, I didn't notice you were the author for the sql 6.8 webinstaller! Smile

I did everything like you posted and got the following error after the last step:

Quote:

Fatal error: Call to a member function on a non-object in /home/users/public_html/mysubdirectory/nukesql.php on line 3235

This is the line it referred to:

Line 3235 $db->sql_query("CREATE TABLE ".$prefix."_authors (

Code:

mysql_connect($dbhost, $dbuname, $dbpass);
@mysql_select_db($dbname);
$db->sql_query("CREATE TABLE ".$prefix."_authors (
aid varchar(25) NOT NULL default '',
name varchar(50) default NULL,
url varchar(255) NOT NULL default '',
email varchar(255) NOT NULL default '',
pwd varchar(40) default NULL,
counter int(11) NOT NULL default '0',
radminarticle tinyint(2) NOT NULL default '0',
radmintopic tinyint(2) NOT NULL default '0',
radminuser tinyint(2) NOT NULL default '0',
radminsurvey tinyint(2) NOT NULL default '0',
radminsection tinyint(2) NOT NULL default '0',
radminlink tinyint(2) NOT NULL default '0',
radminephem tinyint(2) NOT NULL default '0',
radminfaq tinyint(2) NOT NULL default '0',
radmindownload tinyint(2) NOT NULL default '0',
radminreviews tinyint(2) NOT NULL default '0',
radminnewsletter tinyint(2) NOT NULL default '0',
radminforum tinyint(2) NOT NULL default '0',
radmincontent tinyint(2) NOT NULL default '0',
radminency tinyint(2) NOT NULL default '0',
radminsuper tinyint(2) NOT NULL default '1',
admlanguage varchar(30) NOT NULL default '',
PRIMARY KEY (aid),
KEY aid (aid)
) TYPE=MyISAM");

Posted: Fri Jul 18, 2003 10:38 am

Did you upload nuke 6.8's files before trying to run nukesql.php? If you did and still get that error try using this modified nukesql.php instead, let me know how it goes.

Corporal Joined: Apr 28, 2003 Posts: 70

I did upload nuke 6.8's files into the sub-directory before I ran the nukesql.php. I just downloaded the file from the link you provided (several times), but it says it is an unrecognizable format or damaged. I have WinRar installed of course, so it's not that I shouldn'd be able to open the file. Maybe it is damaged?

Posted: Fri Jul 18, 2003 10:59 am

Odd, ok i uploaded it as a zip now:

http://www.nukecops.com/uploads/chatserv/nukesql.zip

Corporal Joined: Apr 28, 2003 Posts: 70

chatserv wrote:

Odd, ok i uploaded it as a zip now:

That's strange, it just gave me the same error. I assumed it must be on my end since it continued to be a problem. The only thing I could think might have anything to do with messing up the download was my download manager (GetRight) and sure enough it was. I turned it off, downloaded it and it opened right up. Strange. I'm trying the file out right now. Thanks Smile