Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
1 registered (Ruben), 35 Guests and 16 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 04/14/13
Posts: 4
Top Posters (30 Days)
Ruben 33
Gizmo 17
Rob Provencher 12
SD 9
Rimex 9
Bert 8
sw55 7
Eugene 5
TCS1 4
Matthias1976 4
Latest Photos
Uhm...
Mayan End of World
Gas Station Disco Video Shoot
Test Pictures
Audrey Kate
Topic Options
#179176 - 02/22/07 05:05 PM Problem with Step 3 of install "database check"
WhiteRabbit Offline
stranger
Registered: 02/22/07
Posts: 5
Hello:

I'm going through install.php and when I proceed to database check, the page doesn't seem to load all the way. All that comes up is "step 3" "connecting to database". It doesn't say "pass" or "fail", just stops at connecting to database.

Why?
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#179240 - 02/23/07 10:45 AM Re: Problem with Step 3 of install "database check" [Re: WhiteRabbit]
WhiteRabbit Offline
stranger
Registered: 02/22/07
Posts: 5
Ok, I did some playing around, and got the page to display an error. Next to "connecting to database" (in the right column of that table) I get the following error:

PHP Fatal error: Call to undefined function mysql_connect() in...on line 438
Top
#179242 - 02/23/07 10:48 AM Re: Problem with Step 3 of install "database check" [Re: WhiteRabbit]
WhiteRabbit Offline
stranger
Registered: 02/22/07
Posts: 5
Ok I figured it out. My PHP install was not correct. When installing PHP 5 you must make sure to install the mySQL extension, which I didn't do.
Top
#179243 - 02/23/07 10:48 AM Re: Problem with Step 3 of install "database check" [Re: WhiteRabbit]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10177
Loc: Aberdeen, WA
Ok, so that means that your PHP install either wasn't compiled "with-mysql" or the mysql portion is commented out in the php.ini file. If this is a hosted webserver you'll need to put in a request with your host, giving them that error, to update PHP.
Top
#179288 - 02/23/07 05:05 PM Re: Problem with Step 3 of install "database check" [Re: Rick]
Gizmo Offline

Registered: 06/05/06
Posts: 15451
Loc: Portland, OR; USA
If you installed via yum, you would just need to do (only do this if you installed via yum):
yum install php-mysql
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime Supporter, Beta Tester & Resident Post-A-Holic.
Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Top
#180616 - 03/13/07 09:52 PM Re: Problem with Step 3 of install "database check" [Re: WhiteRabbit]
Ken DuCharme Offline
stranger
Registered: 03/13/07
Posts: 3
 Originally Posted By: WhiteRabbit
Hello:

I'm going through install.php and when I proceed to database check, the page doesn't seem to load all the way. All that comes up is "step 3" "connecting to database". It doesn't say "pass" or "fail", just stops at connecting to database.

Why?

NOTE: This requires an IIS restart which may be an issue if it is a production server that needs this update.

You already answered yourself, but I figured that I'd elaborate a little bit more.

This is because you have an install of PHP5 and PHP5 no longer comes with the MySQL extension by default anymore (per the PHP manual's section on extensions in Windows).

You must download the extension from MySQL themselves via the link: http://dev.mysql.com/downloads/connector/php/

Follow the directions under the heading How do I install the mysql/mysqli extensions for PHP? or just follow mine which are specific to a default Win32 install (note that my PHP install directory is C:\Program Files\PHP):

1) Since no extensions directory is created by default you need to create your own. I chose C:\Program Files\PHP\extensions for mine. NOTE: I didn't have to change any security settings for the IUSR_ account on mine since it was in Program Files.

2) There are only 2 files in the downloaded zip file: php_mysql.dll and libmysql.dll
  • php_mysql.dll - Copy to C:\Program Files\PHP\extensions
  • libmysql.dll - Copy to C:\Program Files\PHP


3) Edit your php.ini file (located at C:\Program Files\PHP\php.ini for me) making the following changes:
  • Set or create the line: extension_dir = "c:\Program Files\PHP\extensions"
  • Uncomment or add the line: extension=php_mysql.dll


4) Now you must restart IIS to get PHP to load the changes to the php.ini file. This can be done through the IIS Manager or by using the command IISRESET on the Command Prompt window on the server.

Now your ubb.Threads install will rock right through Step 3!

Cheers,
-ken
Ken DuCharme
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Express hosting.
by Ruben
05/16/13 03:54 PM
Level of detail in new user registration emails
by Mitch P.
05/15/13 10:20 PM
Approving users
by Bert
05/15/13 09:22 PM
Users randomly added to other group
by Bert
05/15/13 09:15 PM
Posting and other problems with 7.5.7
by Matthias1976
05/15/13 02:58 PM
Forum Stats
10964 Members
36 Forums
33956 Topics
183368 Posts

Max Online: 978 @ 06/24/07 10:19 PM
Random Image