My SQL 5 problem

[puggsley1980]

Hi, i hope you can help me out.

I have installed MYSQL 5 and PHP 5.1.1 as best as i can figure, but when i try and run install.php i get the following error.

"The installer was unable to detect MySQL support in PHP. Please ask your host to ensure that PHP was compiled with MySQL, or that the proper extension is being loaded."

I followed these destructions to set up PHP, hxxp:psdresource.com/forum/showthread.php?s=baf33df1b8ae8425ee3369%20db62c146c5&t=1366 [nonactive] and it seems to run okay, just not the SQL bit.

Someone suggested that i need to edit the php.ini file to point to the php_mysql.dll file, but in truth i'm not sure what i'm supposed to be editing.  I'm a total newbie at this so please use simple terms.

the sections i edited are thus:

; Directory in which the loadable extensions (modules) reside.
extension_dir = "c:\php\ext\"

and

; Windows Extensions
; Note that ODBC support is built in, so no dll is needed for it.
; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)
; extension folders as well as the separate PECL DLL download (PHP 5).
; Be sure to appropriately set the extension_dir directive.

;extension=php_mbstring.dll
;extension=php_bz2.dll
;extension=php_curl.dll
;extension=php_dba.dll
;extension=php_dbase.dll
;extension=php_exif.dll
;extension=php_fdf.dll
;extension=php_filepro.dll
;extension=php_gd2.dll
;extension=php_gettext.dll
;extension=php_ifx.dll
;extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_ldap.dll
;extension=php_mcrypt.dll
;extension=php_mhash.dll
;extension=php_mime_magic.dll
;extension=php_ming.dll
;extension=php_mssql.dll
;extension=php_msql.dll
extension=php_mysql.dll
;extension=php_oci8.dll
;extension=php_openssl.dll
;extension=php_oracle.dll
;extension=php_pgsql.dll
;extension=php_shmop.dll
;extension=php_snmp.dll
;extension=php_sockets.dll
;extension=php_sqlite.dll
;extension=php_sybase_ct.dll
;extension=php_tidy.dll
;extension=php_xmlrpc.dll
;extension=php_xsl.dll

Any help you can offer would be great.

Cheers,
Puggs

[Oldiesmann]

Make sure that the extensions directory is correct and that php_mysql.dll exists in that directory. You will also need to copy libMySQL.dll from the "bin" folder of your MySQL installation to C:\WINDOWS\System32

[puggsley1980]

Hi,

Managed to get it to run after rebooting the server, I guess the changes I made to the INI file did not show up until then?

Anyway, I now have two problems that may or may not be related.

Firstly, when accessing the site over the LAN, no images show up and the format seems garbled.  Is there a setting I need to change on my IIS server? Or would it be an IE thing?

Also, the forum loads fine when accessed locally on the server. But when I click on any of the boards I receive the following error:

Unknown column 'ml.ID_MEMBER' in 'on clause'
File: c:\Inetpub\wwwroot\Sources\MessageIndex.php
Line: 471

Does anyone know what this means?  I'm a total database newbie so any help would be much appreciated.

Cheers,
Puggs.

[puggsley1980]

Hi,

I found the repair_settings.php file which resolved my image problem, i had to change a few settings so that they pointed to my servers name and not to 'localhost'. I presume because i'm on a lan?

I am now not getting the second error anymore, i am now getting a standard Data base error:

"Please try again. If you come back to this error screen, report the error to an administrator. "

Any ideas? Thanks for everything so far.

[Oldiesmann]

MySQL 5.0.12 Compatibility patch

[puggsley1980]

Top Draw!

Solved my problems nicely.  Thanks.