Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2005-11-29 07:25:38
- paulbarris
- New Member
- Registered: 2005-11-29
- Posts: 5
"Fatal error: Call to undefined function mysql_connect()"
Hellow everyone :)
any help greatly aprriciated!!
trying to install txp on my laptop.
installed php and mysql and iis as server.
using win xp professional.
i defined a database from the command prompt naming it ‘txpDB’ (“msql> CREATE DATABASE txpDB;”) succecfuly.
after entering the data in the ‘textpattern/setup/index.php’ file like so:
MySQL login: root
MySQL password: myPassword
MySQL server: localhost
MySQL database: txpDB
i get a page saying:
“Checking database connection…
Fatal error: Call to undefined function mysql_connect() in c:\Inetpub\wwwroot\dynamicTesting\textpattern\setup\index.php on line 187”
(‘dynamicTesting’ is the name of my “site” on my laptop)
what do i do wrong?
i have a feeling txp is having trouble finding my txpDB database..
is it ok that I installed mysql in the program files folder (and not directly on my harddrive C:)?
any comments are welcomed
thaks very much for your tyme :)
Paul.
Offline
Re: "Fatal error: Call to undefined function mysql_connect()"
PHP does not have the mysql extension loaded. Take a peek in the php manual, installation secction.
Offline
#3 2005-11-29 11:33:09
- paulbarris
- New Member
- Registered: 2005-11-29
- Posts: 5
Re: "Fatal error: Call to undefined function mysql_connect()"
Thank you very much Sencer for solving my afformentioned problem!
for the benefit of others:
installing php and mysql for running txp on a local machine via iis:
platform i used: win xp professional sp2, webserver-iis
the following link is Very helpful:
http://www.bitzenbytes.com/Content-Arcanum-18-1-22.html
steps to add to the instructions in the above link:
1. allow the mysql extension too by removing the ‘;’ from the begining of the line “extension=php_mysql.dll”
found in the c:\WINDOWS\php.ini file after installing php as instructed above.
THANK YOU VERY MUCH SENCER for helping me out with this!
2.
copy the file “libmysql.dll” from the unziped files of php into the C:\WINDOWS\system32 folder.
Note: i do not know if this is the best way to do it but it solves the
“Unable to load dynamic library ‘c:\PHP\ext\php_mysql.dll’”
problem which is basicaly due to missing the libmysql.dll file.
read the following thread about it:
http://www.codecomments.com/PHP_Language/message274647.html
all the best,
Paul
Offline