DB Error: extension not found.

Talk about installation process and problems

Moderator: alexandrleonenko

al.mariani@teletu.it
Senior
Senior
Posts: 26
Joined: Nov 26th, '14, 20:57

DB Error: extension not found.

Postby al.mariani@teletu.it » May 25th, '17, 06:29

I installed datagrid 7.0 in a new virtual machine: Ubuntu 16.04 server version.
The same version of datagrid, with the same caratteristics, works on VM with CentOS 6.0 O.S. without any problem.
When I input in my browser the link to index.php page the system warning me with this message:
DB Error: extension not found.
Best Regards.
Alberto

administrator
Site Admin
Site Admin
Posts: 6001
Joined: Jan 7th, '09, 23:18
Contact:

Re: DB Error: extension not found.

Postby administrator » May 25th, '17, 10:36

Turn on showing errors on page.
Check you have PDO is installed and what drivers are installed.

al.mariani@teletu.it
Senior
Senior
Posts: 26
Joined: Nov 26th, '14, 20:57

Re: DB Error: extension not found.

Postby al.mariani@teletu.it » May 25th, '17, 14:09

Thank You for your answer.

I turned on debug mode, but with (database: mysql), my system returned "DB Error: extension not found".

While with (database: mysqli):
DataGrid v7.9.9 | Extension: PEAR | Database: mysqli
debug mode warning message
Attention:
1) Field operator, used in the list of fields in View Mode was not found in SELECT SQL! Please, check carefully your code syntax and field name, it may be case sensitive!

I always used (database: mysql) not mysqli on CentOS 6 and it works fine (PHP5) .

The new virtual machine, Ubuntu 16.04, mount PHP7 version.

alberto@ubuntu:~$ php -i|grep PDO
PDO
PDO support => enabled
PDO drivers => mysql
PDO Driver for MySQL => enabled

administrator
Site Admin
Site Admin
Posts: 6001
Joined: Jan 7th, '09, 23:18
Contact:

Re: DB Error: extension not found.

Postby administrator » May 26th, '17, 15:48

You don't need to use PEAR - use PDO instead:

Code: Select all

$dgrid = new DataGrid();
$dgrid->DataSource('PDO', 'mysql', $DB_HOST, $DB_NAME, $DB_USER, $DB_PASS,      'SELECT * FROM demo_countries', array('name'=>'ASC'));


Return to “Installation”