Dreamweaver unable to make database connection

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Dreamweaver unable to make database connection

Postby RiscPC700 » 07. March 2019 22:07

Up until yesterday both my PC (Windows 7 Professional) and laptop (Windows 10 Professional) were able to run Dreamweaver and connect to my databases, nothing has been touched, the mysql_error log shows entries from today, nothing prior to that.
Today I find neither of the computers can make a connection to any database with the error "Your PHP server doesn't have the MySQL module loaded or you can't use the mysql_(p) connect functions.
I updated from version 5.? when parts were deprecated, the update went well with everything working as it should, below is the mysql error log I now get:

2019-03-07 20:51:29 1494 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2019-03-07 20:51:29 5268 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-03-07 20:51:29 5268 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-03-07 20:51:29 5268 [Note] InnoDB: The InnoDB memory heap is disabled
2019-03-07 20:51:29 5268 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-03-07 20:51:29 5268 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-03-07 20:51:29 5268 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-03-07 20:51:29 5268 [Note] InnoDB: Using generic crc32 instructions
2019-03-07 20:51:29 5268 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-03-07 20:51:29 5268 [Note] InnoDB: Completed initialization of buffer pool
2019-03-07 20:51:30 5268 [Note] InnoDB: Highest supported file format is Barracuda.
2019-03-07 20:51:30 5268 [Note] InnoDB: The log sequence number 6280575 in ibdata file do not match the log sequence number 6280585 in the ib_logfiles!
2019-03-07 20:51:31 5268 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2019-03-07 20:51:33 5268 [Note] InnoDB: 128 rollback segment(s) are active.
2019-03-07 20:51:33 5268 [Note] InnoDB: Waiting for purge to start
2019-03-07 20:51:33 5268 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.42-84.2 started; log sequence number 6280585
2019-03-07 20:51:34 4564 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-03-07 20:51:34 5268 [Note] Plugin 'FEEDBACK' is disabled.
2019-03-07 20:51:34 5268 [Note] Server socket created on IP: '::'.
2019-03-07 20:51:34 5268 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.38-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
RiscPC700
 
Posts: 3
Joined: 07. March 2019 21:52
XAMPP version: 3.22
Operating System: Windows 10 Professional

Re: Dreamweaver unable to make database connection

Postby Nobbie » 08. March 2019 11:33

RiscPC700 wrote:I updated from version 5.?


Not a good idea, in PHP7 all mysql_XXXX functions are removed, they cant be used anymore. You have to use mysqlI_XXXX instead (or PDO), or go back to PHP 5.x

See also http://php.net/manual/en/function.mysql-connect.php

Warning This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information.
Nobbie
 
Posts: 10780
Joined: 09. March 2008 13:04

Re: Dreamweaver unable to make database connection

Postby RiscPC700 » 08. March 2019 15:03

I've changed all my code to use mysqli, everything I've developed works OK, the problem is trying to add new php files that require data access, Dreamweaver can't show a list of tables in a database and therefore no recordsets can be created - I think this is a Dreamweaver problem and on reflection this would have happened from day 1 of me upgrading to PHP 7, I just hadn't done any further development to my site from the day I upgraded to PHP 7 until yesterday...

How do I go about installing the PDO_MySQL extension?
RiscPC700
 
Posts: 3
Joined: 07. March 2019 21:52
XAMPP version: 3.22
Operating System: Windows 10 Professional

Re: Dreamweaver unable to make database connection

Postby Nobbie » 08. March 2019 17:45

Isnt it installed already?
Nobbie
 
Posts: 10780
Joined: 09. March 2008 13:04

Re: Dreamweaver unable to make database connection

Postby RiscPC700 » 08. March 2019 22:01

Yes, I think you're right (never used it before!).
I've managed to make a database connection using PDO, so that's good, I just need to learn the rest of the stuff.
Thanks for the pointers.
RiscPC700
 
Posts: 3
Joined: 07. March 2019 21:52
XAMPP version: 3.22
Operating System: Windows 10 Professional


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 52 guests