Fatal error: Call to undefined function: mysql_pconnect()

[brookelyn]

Does anyone know waht this means and how to fix it? I had my hosting place upgrade to PHP4 and all hell broke loose. this happened, so they migrated all my stuff to a new server and it was working and now this is happening! what's wrong. the hosting company is clueless.


http://www.hole.com/soapbox/index.php

[Mike Sullivan]

That error happens if MySQL support wasn't compiled into PHP or the module to access it wasn't loaded.

You'll have to talk to your host to fix it, or recompile PHP yourself.

[brookelyn]

so this HAD to have happened when they switched over my server to one with php 4 right? because i thought that it was working after they switched it over and then it did this within the last hour. what should i tell my hosting company? they are working on it right now and said they would call me back, but if they haven't fixed it, what should i tell them?

[Chris Schreiber]

Basically they need to make sure they use a 'configure' command for PHP similar to the one below:

./configure --prefix=/usr/local/php --with-config-file-path=/usr/local/php --with-mysql --with-apache=../apache_1.3.19 --enable-track-vars --enable-debugger --enable-magic-quotes --with-zlib=/usr/local/zlib


Of course some of that may vary (like the --with-apache and --with-zlib).

[brookelyn]

ok, now they reinstalled PHP and i am getting the problem with the database screen and emails that say:

Database error in vBulletin: Invalid SQL: SELECT template FROM template WHERE title='options'
mysql error: Table 'soapbox.template' doesn't exist
mysql error number: 1146
Date: Friday 13th of April 2001 06:12:49 PM
Script: /soapbox/
Referer:



what does this mean?
i am sorry i am such a retard, but i just am.

[Chris Schreiber]

It looks like your database isn't there. Verify that your database name is "soapbox" and it contains all the vB tables (including template).

[brookelyn]

Originally posted by Chris Schreiber
It looks like your database isn't there. Verify that your database name is "soapbox" and it contains all the vB tables (including template).


that was the problem.
thanks,.
somehow it didn't get all backedup off the other server.,