WebServers
Topic: How can I make PHPNuke work with IIS and MySQL???

Hey everyone, I need some help getting PHPNuke to work with IIS and MySql. I just know exactly what i need to do to get it working.

THANKS!!!

RTFM Here

Quote:

RTFM

With a smile

DR,

Go to the link below to get some tips on how to set up IIS for PHP apps on a Windows 2K machine.

php_win2k.zip

This will help you with the first part. With respect to MySQL, if you haven't already installed it, use the windows binary install with the Windows Installer. It works well. Use version 3.23.5x. It's well-tested, stable, and is still the primary version used by most ISP's. You will also need to install the MyODBC driver prior to installing MySQL, because it will be looking for the driver.

Next, download phpMyAdmin at this location:

PhpMyAdmin

phpMyAdmin is a browser-based database management tool written in PHP and was specifically designed to facilitate administration of MySQL over the Web. It permits you to create and drop databases, create/alter/drop tables, search databases, import and export data, execute any SQL statement, and much more. Great tool!! And, one of the easiest PHP apps to install out-of-the-box on Windows.

Now, with respect to myPhpNuke, each Windows environment appears to respond differently. I'm using Advanced Server. With Win2K, you'll probably need to place virtual include slashes "./" before every include in the subdirectories beneath the html root directory; namely, html/admin, html/gallery, and html/themes. For example, change include("header.php") to include("./header.php").

You can do a global search and replace from your html or text editor to speed up the process. Make these changes before you execute the install file, which is install.php, located in the html root when the program is unzipped.

This is an example of an include file error (you don't want these):

--------
Warning: Failed opening 'admin/gallery/config.php' for inclusion (include_path='c:\php4\pear') in
c:\inetpub\wwwroot\myportal\html\gallery\mainGallery.php on line 127

Correct by placing "./" before "config.php" in the file at the line indicated, as in
include("./config.php").
-----------------

Some other specific errors to watch out for are these:
------------------------
SAMPLE VARIABLE ERRORS
------------------------
The following is an example of the script not finding the "mainfile.php".

----------------------
html/myyp.php
----------------------

Warning: Undefined variable: mainfile in c:\inetpub\wwwroot\myportal\html\myyp.php
on line 21

CHANGE TO:

Code:

if (!isset($mainfile)) { include("mainfile.php"); }

----------------------
html/newtopic.php
----------------------
line 27-29 change to:

Code:

if (!isset($cancel)) { $cancel = ""; } if($cancel) { header("Location: viewforum.$phpEx?forum=$forum"); }

----------------------
html/replypmsg.php
----------------------
line 26-28 change to:

Code:

if (!isset($cancel)) { $cancel = ""; } if($cancel) { header("Location: viewpmsg.$phpEx"); }

Finally, before you run the phpMyNuke install file, you must make certain that the permissions on the virtual directory which is linked to YOURWEBROOT/mpn/html. The "Security" properties on this directory must contain the Internet Guest Account (IUSR_YOUR_MACHINE_NAME), which must have read and execute, read, list folder contents, and write permissions. If you fail to give "write" permissions properly, then the install will have numerous errors or not create the config.php file at all. You'll know if the install is good, if their are no errors, and you can successfully open your Admin page from the install dialogue.

HTH,

SwingDancer


-----------------
Looking for a talented, good-looking, honest, hardworking IT employee -- hire me!