Previous Thread
Next Thread
Print Thread
Hop To
#1447 07/19/2006 4:36 PM
Joined: Jun 2006
Posts: 225
M
enthusiast
enthusiast
M Offline
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


Join Europes biggest BMW M Car owners site
M-Torque - www.mtorque.co.uk
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
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
M
enthusiast
enthusiast
M Offline
Joined: Jun 2006
Posts: 225
This is my server


Join Europes biggest BMW M Car owners site
M-Torque - www.mtorque.co.uk
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
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:

PHP Code
phpinfo(); 

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
M
enthusiast
enthusiast
M Offline
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


Join Europes biggest BMW M Car owners site
M-Torque - www.mtorque.co.uk
Joined: Jun 2006
Posts: 225
M
enthusiast
enthusiast
M Offline
Joined: Jun 2006
Posts: 225
Seems PHP 5 doesnt come with mysql libraries.. great


Join Europes biggest BMW M Car owners site
M-Torque - www.mtorque.co.uk
Joined: Jun 2006
Posts: 225
M
enthusiast
enthusiast
M Offline
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..


Join Europes biggest BMW M Car owners site
M-Torque - www.mtorque.co.uk
Joined: Jun 2006
Posts: 225
M
enthusiast
enthusiast
M Offline
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..



Join Europes biggest BMW M Car owners site
M-Torque - www.mtorque.co.uk
Joined: Jun 2006
Posts: 225
M
enthusiast
enthusiast
M Offline
Joined: Jun 2006
Posts: 225
<insert loudly shouted swear words here>


Join Europes biggest BMW M Car owners site
M-Torque - www.mtorque.co.uk
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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)


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 225
M
enthusiast
enthusiast
M Offline
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


Join Europes biggest BMW M Car owners site
M-Torque - www.mtorque.co.uk
Joined: Jun 2006
Posts: 225
M
enthusiast
enthusiast
M Offline
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.


Join Europes biggest BMW M Car owners site
M-Torque - www.mtorque.co.uk
Joined: Jun 2006
Posts: 464
Likes: 1
M
Addict
Addict
M Offline
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
M
enthusiast
enthusiast
M Offline
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 ?


Join Europes biggest BMW M Car owners site
M-Torque - www.mtorque.co.uk
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 225
M
enthusiast
enthusiast
M Offline
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.


Join Europes biggest BMW M Car owners site
M-Torque - www.mtorque.co.uk
Joined: Jun 2006
Posts: 626
Addict
Addict
Joined: Jun 2006
Posts: 626
Originally Posted by Rick
Ok, first thing would be to take a look at your phpinfo. Try creating a .php file with the following inside of it:

PHP Code
phpinfo(); 

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.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Havenofsobriety), 522 guests, and 99 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)