Can't Install, get "Call to undefined function mysql_connect()"

HobbyTech · 2006-07-25 05:14:05

<pre>Windows XP Pro SP 2
Apache 2.0.58
PHP 5.1.2
MySQL 5.0.21</pre>

<pre>“Fatal error: Call to undefined function mysql_connect() in I:\htdocs\TxpSite\textpattern\setup\index.php on line 189”</pre>

I don’t know why.

<ul><li>I left the MySQL Server at “localhost”</li>
<li>Database is created, using correct DB name “TxpDB”</li>
<li>Using correct DB password</li>
<li>Using correct login name</li>
<li>Gave permissions on “TxpDb” to a user I’ll call “theUser”, with pw I’ll call “thePassword”: 
grant select,insert,update,delete,index,alter,create,drop on TxpDB.* to theUser identified by ‘thePassword’;</li>
<li>Site URL: “http://localhost/TxpSite”</li></ul>

I also tried the Windows service name, “MySQL”, as the MySQL server, but I understand now from reading it is really supposed to be “localhost”, which I tried first.

I know there are no problems between PHP, MySQL, and Apache because I have several Apache test scripts that use MySQL with no problem. Apache runs under the “SYSTEM” account by default on Windows, and that’s the way it is on my machine.

I tried installing another blog software to see if maybe Textpattern is just difficult or something, but that one freezes while trying to connect to MySQL (on its own DB with its own user and password). I verified for both blog software packages that no tables have been created in their respective databases, so I think I’m totally missing something.

The “htdocs” folder is on a partition for all web stuff, while the servers are on my system partition. I created its own folder for each install, as you can see by the path “I:\htdocs\TxpSite\textpattern\setup\index.php” (which is the correct txp path). The actual database files are stored on a partition seperate from the MySQL server, and as I said, Apache/PHP/MySQL work fine with some test scripts…I’m just learning, but they do work.

What am I missing?

Last edited by HobbyTech (2006-07-25 05:17:25)

Mary · 2006-07-25 07:09:16

Are you certain you have MySQL installed, not just MySQLi?

zem · 2006-07-25 08:44:45

Looks like you don’t have the PHP mysql extension installed. phpinfo() or php.exe -i should tell you.

HobbyTech · 2006-07-26 01:57:44

Mary wrote:

Are you certain you have MySQL installed, not just MySQLi?

Yes, I have MySQL installed…I created a database and password, as I said. I’m learning web development using Apache, PHP, and MySQL, done some basic stuff (like designing a database…with tables that are populated…and making a PHP script that queries and returns the result in an HTML page, some of it’s my own stuff not following the book).

So, yes, MySQL is installed and working! I just think I am missing some small detail in my setup because with both blog softwares, neither one can connect to MySQL at all. They each have their own database, username, and password.

I installed the 2nd one just to see if I have the same problem as the first one, and I do.

And, by the way, the blog software users are set to use localhost…“localhost” (without quotes) is in the Host column in the User database of the mysql table.

HobbyTech · 2006-07-26 02:05:38

zem wrote:

Looks like you don’t have the PHP mysql extension installed. phpinfo() or php.exe -i should tell you.

I don’t see it…I assume you’re not talking about “mysql.sock”, since that is listed in the section “Mysqli”. I don’t know where I’d expect to see it (is it a module?), but it should be easy since each section’s details are listed alphabetically.

OK, so I’ll go to the PHP site and see how to fix this…I used the Windows installer, which is recommended, so I hope it’s not to hard to fix b/c I don’t have any experience with PHP or MySQL on Apache before buying these books.

———- EDIT ————-
Ok, so I read the PHP docs, and MySQL is compiled into Windows already (THANK GOD!)…all I needed to do to enable it is uncomment “extension=php_mysql.dll” in “php.ini”. I restarted both MySQL and Apache (probably only needed to restart Apache), and there is now a whole section for “Mysql”.

Now, I just need to see if the install of either/both work(s).
——————————-

Last edited by HobbyTech (2006-07-26 02:41:27)

hcgtv · 2006-07-26 02:13:30

In your php.ini are you sure this line is uncommented?

extension=php_mysql.dll

HobbyTech · 2006-07-26 03:07:49

Thanks, Burt…(and PHP manual-writers)…that was it. Maybe that info should be in the manual of the texpattern install, for people who used the Windows installer for PHP.

The PHP docs actually recommend a manual install. But I read somewhere else (maybe in the MySQL docs, or in someone’s comments to some docs…I don’t remember), that it is best to use the installer if you’re doing all 3, because it sets things up “right”, and there’s very little you need to change.

I can vouch for that, no problems on my first Apache/PHP/MySQL install ever (did install Apache before by itself, but didn’t do much with it).

Uncommenting “extension=php_mysql.dll” certainly qualifies as a very minor change…and I would have known it without asking if I was not a newbie at PHP. So I think using the installer is a good bet, assuming you’re not going to go “live” without changing security settings first. Don’t know if you agree, and maybe this is a little OT, except I think it’s really not OT b/c that note could be added to the “TextBook”

<ul><li>If you compile PHP from source, must compile with mysql extension</li>
<li>If you use installer, which is binary, don’t use PHP 4.x b/c mysq extension is NOT compiled in</li>
<li>if you use installer:
<ul><li>use PHP 5.x b/c mysql extension IS compiled in</li>
<li>make sure your extension_dir is set in “php.ini”</li>
<li>make sure you uncomment “extension=php_mysql.dll” by removing the “;” at the beginning of the line (be real specific, in case newbies don’t know what “uncomment” means)</li></ul></li></ul>

[CONSIDER THIS SOLVED] 
(Is this what we’re supposed to do if it’s solved? Some forums have you put [SOLVED] in the subject, but we can’t edit the subject here.)

Last edited by HobbyTech (2006-07-26 03:09:08)

Mary · 2006-07-30 04:42:03

PHP has excellent documentation provided for it by the developers, why duplicate it? Particularly when, if you don’t know what you’re doing, there are several all-in one solutions available.

Textpattern CMS

Textpattern CMS support forum

#1 2006-07-25 05:14:05

Can't Install, get "Call to undefined function mysql_connect()"

#2 2006-07-25 07:09:16

Re: Can't Install, get "Call to undefined function mysql_connect()"

#3 2006-07-25 08:44:45

Re: Can't Install, get "Call to undefined function mysql_connect()"

#4 2006-07-26 01:57:44

Re: Can't Install, get "Call to undefined function mysql_connect()"

#5 2006-07-26 02:05:38

Re: Can't Install, get "Call to undefined function mysql_connect()"

#6 2006-07-26 02:13:30

Re: Can't Install, get "Call to undefined function mysql_connect()"

#7 2006-07-26 03:07:49

Re: Can't Install, get "Call to undefined function mysql_connect()"

#8 2006-07-30 04:42:03

Re: Can't Install, get "Call to undefined function mysql_connect()"

Board footer