Hello,
I've installed SMF before a few times with really no big hassles. I've set it up personally on my own Windows 2003 server running IIS 6.0 and it was a little more complicated, but got it running fine.
What I have is a Windows Server 2003 running IIS6.0 at a school district I service.
I've installed the latest version of MySql as of 4/11/2006 and also the latest PHP. Got the latest SMF 7.0 as well...
I've setup all the extensions and am using the "phpisapi.dll". I've double checked the extension folder for PHP which is D:\php\ext
Everything seems to be running fine but when I try to run the install.php I just get:
"The installer was unable to detect MySQL support in PHP. Please ask your host to ensure that PHP was compiled with MySQL, or that the proper extension is being loaded."
If I take out the part of the installer that checks for MySQL it comes up to the Step 1 page where I can name my forum and such, but when I fill in the information and click OK it never adds the tables or information to the MySQL database. It's like there is no connectivity between the installer and the database.
I've pretty much spent a solid 8 hours on this now, so any help would be greatly appreciated.
Matt
This is a silly question, but you do have MySQL support enabled in php.ini, correct? Remember that MySQL is not enabled by default.
Ummm... I think I do.
Do you mean as far as removing the semicolon from the extension?
Here is my ini file: http://www.nnhood.com/php.zip
My SQL Install is located on the D: drive. It's D:\SQL Server 5
My PHP Install is located on the D: as well. It's under D:\php
The extension folder is D:\php\ext
What's strange is I'm using "phpmyadmin" to help manage the MySQL and it runs just fine... and it's a .php based application...
But I can't get SMF to work for the life of me.
Thanks a lot for any help,
Matt
Make a php script with this code:
<?php
$server = '';
$username = '';
$password = '';
$link = mysql_connect($server, $username, $password);
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully.';
mysql_close($link);
?>
Put it in your SMF directory and execute it.
Thanks a lot for your time kegobeer... I named the script kegobeer.php and ran it and got this:
Could not connect: Access denied for user 'ODBC'@'localhost' (using password: NO)
I didn't event think I had a user called ODBC? I only had root and I made a tech as well... but I never made an ODBC user? I wonder where that is coming from?
I can manually log in from DOS using mysql -u -p and I can attach fine, it just seems that when an application tries to automatically log in it uses that goofy ODBC user...
Thanks again for your help... any ideas about that error?
Matt
Kegobeer...
I edited your file and put in the correct username and password and now it connects fine.
I can even get to the first page of the SMF install now which is really weird... it wouldn't connect at all yesterday.
But now I get this message:
Some of the queries were not executed properly. This could be caused by an unsupported (development or old) version of MySQL.
Technical information about the queries:
Line #1070: Out of range value adjusted for column 'ID_POLL' at row 1
Click here to try this step again.
Any Ideas?
Matt
Are you running MySQL in strict mode? If so, turn it off.
Hey thanks for all your help... I forgot when I initially tried installing the forum and failed, I had used an older version of SMF just to try it.
It was like 1.0 or a very old version, but it actually installed after I ran your script... maybe just coincidence... I upgraded to 7.0 now and everything is working fine.
Thanks for your time and help.
Matt