PHPBB error on IIS

[abcat]

Hi,

I was trying to setup a PHPBB forum on my machine which is windows xp pro sp2 with IIS 5.1 and everything is seems to be ok but when install I got an error.

Everything I use should be the latest of now. When I @ the installation page install.php , I try to use mysql 5 and old version then click Start Install and it show me this error

The PHP configuration on your server doesn't support the database type that you chose

I try ms access it show me

An error occurred trying to update the database

Could not insert board_startdate :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_startdate', 1154624335) :: 888 :: c:\Inetpub\wwwroot\phpBB2\install\install.php

Could not insert default_lang :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_lang', 'english') :: 895 :: c:\Inetpub\wwwroot\phpBB2\install\install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = 'test@mail.com' WHERE config_name = 'board_email' :: 912 :: c:\Inetpub\wwwroot\phpBB2\install\install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = '/phpBB2/' WHERE config_name = 'script_path' :: 912 :: c:\Inetpub\wwwroot\phpBB2\install\install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = '80' WHERE config_name = 'server_port' :: 912 :: c:\Inetpub\wwwroot\phpBB2\install\install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = 'localhost' WHERE config_name = 'server_name' :: 912 :: c:\Inetpub\wwwroot\phpBB2\install\install.php

Could not update admin info :: UPDATE phpbb_users SET username = 'Administrator', user_password='098f6bcd4621d373cade4e832627b4f6', user_lang = 'english', user_email='test@mail.com' WHERE username = 'Admin' :: 923 :: c:\Inetpub\wwwroot\phpBB2\install\install.php

Could not update user_regdate :: UPDATE phpbb_users SET user_regdate = 1154624335 :: 930 :: c:\Inetpub\wwwroot\phpBB2\install\install.php

I just wanna try to make my phpbb work with either one of the database, but I heard that the latest php does not support mysql is it true?

Hope someone can teach me how to make it works with the latest mysql and ms access too. I have try to read the documentation on the web but it show me the old version tutorial, so I think my problem is that I'm stuck on the database, I install mysql with default settings and it does not work, ms access I create a new blank databse and store in wwwroot/phpb22/db/phpbb.mdb and I go to the Data Sources (ODBC) under System DSN and add the file. Am I wrong or whats more I need to do?

Thanks in advanced :)

[CornedBee]

No, it's not true. The latest PHP does support MySQL, it just doesn't come with the old mysql extension built-in.

Can you connect a normal script to the database? Are your connection settings correct?
Also, create a PHP page containing only this:
<?php phpinfo(); ?>
Does it mention mysql anywhere?

[abcat]

Hi, Thanks for your reply :) u mean old version come with the mysql extension built in? If I now use all the setup of latest version, is mysql-5.0.22-win32.exe the correct setup to use? I install mysql-5.0.22-win32.exe and I can't find the mysql thingy in the php page that you call me create.

How to know whether I can connect a normal script to the database & are my connection settings correct?

Sorry I'm quite new to all this stuff, I just want to make the phpbb stuff works easily, I thought installing is easy but turn out so hard for me. Can I say that I install iis, php, mysql then if I go localhost and I can see the install.php working, I am half done or I need to install something more like php extension or go edit some php.ini files etc.? Cos everything now I do is use installer with default settings.

Maybe someone can teach me how to create the sample database and link correctly, preferbaly MS Access & MySQL so that I think I won't receive the error anymore or someone can direct me a website for tutorial as I visit the phpbb forum and it teaches us with old version.

Thanks in advanced :)

[eguru]

yes the latest comes with older version of mysql

[visualAd]

What version of PHP are you using? For PHP 5 make sure you download the ZIP archive from the site as this includes the extension DLL php_mysql.dll. You must also make sure you copy the file libmysql.dll from the Mysql installation directory to a PATH directory such as the windows directory.

Once you have done this try the phpinfo() function agina and you should see a secion for mysql. :)

[abcat]

Hi, finally saw the mysql thingy. Thanks all for the help :)

I just do a re-install for some software then I do the step install php the exe version, 2nd install php the zip version to c:\php and overwrite some files, 3rd, install mysql the latest exe version and untick strict mode and tick include windows bin directory thing, 4th install phpbb zip version to C:\Inetpub\wwwroot\ and 5th step is my friend teach me one, go to php.ini and change

; Directory in which the loadable extensions (modules) reside.
extension_dir = "c:\php\ext"

and delete away 2 ;
extension=php_msql.dll
extension=php_mysql.dll

6th, create the php file u guys told me to do that and I finally can found the mysql thingy, 7th, my friend recommended me a phpmyadmin to mysql mangement of database so I install it, 8th, I create a database phpbb for my phpbb, 9th I go to install phpbb and it finally works, so happy about it.

Now I wanna know which step have I miss or need to do, especially on the editing on php.ini part, did I miss out anything & what is pecl-5.1.4-Win32.zip for, must I install it? Btw, IIS need to do anythings more, I just add a index.php on documents tab there on the first line?

I got this error Failed sending email :: PHP ::

DEBUG MODE

Line : 234
File : emailer.php

is it because of I never input any SMTP server and put default, is there a way if I do not have the SMTP server, can I use others one?

Btw, I'm curious to know that how can I make it work with MS Access database, I know mysql is much more better than MS Access but I just wanna know how 2 set it up.

Last question to go along, any online free web host that can support phpbb with mysql and which is good like bandwidth and storage is like average and easy to setup? Please recommended some free web host you know.

Sorry for so many question at 1 goal but thanks in advanced :)

[abcat]

anyone can answer some of my question, lol, thanks :)

[abcat]

bumpz

[visualAd]

PECL contains all the extensions for PHP. Most of these are included with the ZIP distribution so you do not need to download it.


You are getting the SMTP error because you have most probably not set the SMTP server in your php.ini. Open your php.ini configuration fail and search for SMTP. Set this directive to the SMTP server of your ISP.


Access can be configured to work with PHP. You must access it via the ODBC driver by setting your datadbase up as a data source in the System DSN tab of the ODBC sources control panel.

Here is a good guide on setting up DSN's : http://www.zend.com/zend/tut/odbc.php?article=odbc&kind=t&id=8231&open=1&anc=0&view=1

This articke on PHP builder explains how to connection to an Access 97 Database: http://www.phpbuilder.com/columns/siddarth20000228.php3?page=1


Free hosts with plenty of storage, PHP, mysql and PHP BB? I don't think so. :p

[abcat]

Thanks visualAd for your reply :)