|
Joined: Jun 2006
Posts: 225
enthusiast
|
enthusiast
Joined: Jun 2006
Posts: 225 |
Hi all..
Not getting too far with this install.. the database server is running, the permissions are set, and regardless of the username and setting I give it for the DB, i get the following error when it tries to connect to the DB.. I've played around for hours and now i'm just getting annoyed, so I thought I'd post up...
Connecting to server Fatal error: Call to undefined function mysql_connect() in G:\webs\www.bm3w.co.uk\public_html\ubbthreads\install\install.php on line 436
Any ideas or pointers before I set it on fire
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
This error "Call to undefined function mysql_connect()" means that PHP isn't compiled with mysql support or at least it's not set in the php.ini file. Is this your own server or a hosted server?
|
|
|
|
Joined: Jun 2006
Posts: 225
enthusiast
|
enthusiast
Joined: Jun 2006
Posts: 225 |
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Ok, first thing would be to take a look at your phpinfo. Try creating a .php file with the following inside of it: Bring the file up in your web browser and see if there is anything related to mysql in the configuration. If php has been compiled with mysql support you should at least see a --with-mysql.
|
|
|
|
Joined: Jun 2006
Posts: 225
enthusiast
|
enthusiast
Joined: Jun 2006
Posts: 225 |
Is that all I need to stick, as that is all that is being displayed when I load it up..
I've had a look in php.ini and there is a load of mysql stuff in there .. I guess I need to read up on it
|
|
|
|
Joined: Jun 2006
Posts: 225
enthusiast
|
enthusiast
Joined: Jun 2006
Posts: 225 |
Seems PHP 5 doesnt come with mysql libraries.. great
|
|
|
|
Joined: Jun 2006
Posts: 225
enthusiast
|
enthusiast
Joined: Jun 2006
Posts: 225 |
PHP Version 5.1.4
System Windows NT BM3W 5.2 build 3790 Build Date May 4 2006 10:30:29 Configure Command cscript /nologo configure.js "--enable-snapshot-build" "--with-gd=shared" Server API CGI/FastCGI Virtual Directory Support enabled Configuration File (php.ini) Path C:\WINDOWS\php.ini PHP API 20041225 PHP Extension 20050922 Zend Extension 220051025 Debug Build no Thread Safety enabled Zend Memory Manager enabled IPv6 Support enabled Registered PHP Streams php, file, http, ftp, compress.zlib Registered Stream Socket Transports tcp, udp Registered Stream Filters convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, zlib.*
Is the report on my query.. im just searching for the right DLL to enable it..
|
|
|
|
Joined: Jun 2006
Posts: 225
enthusiast
|
enthusiast
Joined: Jun 2006
Posts: 225 |
You know what, it really bugs me when these people decide to change what they ship with their products and take out something people use.. ARGGGHGHHGHGG
I'm giving up for now, its too hot and im frustrated, I've copied the files to various places and its just stupid..
|
|
|
|
Joined: Jun 2006
Posts: 225
enthusiast
|
enthusiast
Joined: Jun 2006
Posts: 225 |
<insert loudly shouted swear words here>
|
|
|
|
Joined: Jun 2006
Posts: 16,347 Likes: 122
|
Joined: Jun 2006
Posts: 16,347 Likes: 122 |
I believe that PHP5 uses MySQLi vs MySQL; I'm not sure on too much more as I'm utiliing PHP4 on all of my machines...
Your best bet is google though "php5 mysql" (or something similar)
|
|
|
|
Joined: Jun 2006
Posts: 225
enthusiast
|
enthusiast
Joined: Jun 2006
Posts: 225 |
Yeah ive been doing that, and im fed up trying the 1001 peoples different ways of fixing the damn issue when they dont work. Ill downgrade before i rip my hair out or throw my laptop out the window.
I HATE UPGRADES
|
|
|
|
Joined: Jun 2006
Posts: 225
enthusiast
|
enthusiast
Joined: Jun 2006
Posts: 225 |
As a side note Rick, would it be hard to build into the installer a system that checks for this instead of displaying a meaningless error ? It's ok if your a PHP expert and understand the errors, but im not.. and im sure i wont be the first.
|
|
|
|
Joined: Jun 2006
Posts: 464 Likes: 1
Addict
|
Addict
Joined: Jun 2006
Posts: 464 Likes: 1 |
I ran into a similar situation. PHP 4.4.2 is working great for me. PHP 5.0 give me connect errors to MYSql.
There is still a little bit of a learning curve for me. I am getting there.
Last edited by Mors; 07/19/2006 7:09 PM.
Happy Customer !!!
|
|
|
|
Joined: Jun 2006
Posts: 225
enthusiast
|
enthusiast
Joined: Jun 2006
Posts: 225 |
Consider Rick said he is running with all the latest versions then surely he must be able to either provide the correct DLL's or at least point us in the right direction ?
|
|
|
|
Joined: Jun 2006
Posts: 16,347 Likes: 122
|
Joined: Jun 2006
Posts: 16,347 Likes: 122 |
One thing you have to keep in mind is that while infopop (groupee) creates products to be run on webservers, they do not develop the technologies which run them, they are in no way tied to Apache/PHP/MySQL/IIS, they merely develop software to run utilizing them...
|
|
|
|
Joined: Jun 2006
Posts: 225
enthusiast
|
enthusiast
Joined: Jun 2006
Posts: 225 |
Yeah your right, easy to forget.
Well if anyone can point me at the correct DLL's to enable me to use the latest PHP and MYSQL please drop me a PM as i'd much rather start out with the latest versions from day 1.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
Ok, first thing would be to take a look at your phpinfo. Try creating a .php file with the following inside of it: Bring the file up in your web browser and see if there is anything related to mysql in the configuration. If php has been compiled with mysql support you should at least see a --with-mysql. I created this file, however, when I use it, I only see phpinfo(); on my browser. Am I doing something wrong when I create this file?
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
Never mind. It worked when I clicked on the refresh icon.
|
|
|
4 members (Baldeagle, toner, Mender, 1 invisible),
315
guests, and
116
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|