DataGrid v7.9.9 Extension: PDO Database: mysql

All ApPHP DataGrid script bugs discussion. Questions and requests here.
Please, use a $debug_mode = true; before you say "Why Nothing Works ?!" (solves 90% of all issues)

Moderator: alexandrleonenko

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

DataGrid v7.9.9 Extension: PDO Database: mysql

Postby al.mariani@teletu.it » Dec 11th, '17, 20:00

Hi,
I changed my server CeontOS 7 + mysql + php 7 in Windows 10 +mysql + php 7 with XAMPP 7.1.11 (last version).
In my home page in debug mode I can see:
Attention: 1) Wrong parameter in [id]: Check this field carefully, it may be not a Primary Key!
If I try to add a value another message appears in my filed:
Warning: A non-numeric value encountered in C:\xampp\htdocs\cartelli\datagrid.class.php on line 4207
In CentOS instead it works well.

And so on... when I modify a form:
Warning: Illegal string offset 'select' in C:\xampp\htdocs\app\classes\sqlparser.class.php on line 207
Warning: Cannot assign an empty string to a string offset in C:\xampp\htdocs\app\classes\sqlparser.class.php on line 207
Warning: Illegal string offset 'select' in C:\xampp\htdocs\app\classes\sqlparser.class.php on line 208
Fatal error: Uncaught Error: Cannot use assign-op operators with string offsets in C:\xampp\htdocs\app\classes\sqlparser.class.php:208 Stack trace: #0 C:\xampp\htdocs\app\datagrid.class.php(5199): SqlParser::ParseString('SELECT id, data...') #1 C:\xampp\htdocs\app\datagrid.class.php(2287): DataGrid->SetTotalNumberRows(' ORDER BY id a...', '', '', true) #2 C:\xampp\htdocs\app\datagrid.class.php(1005): DataGrid->GetDataSet(' ORDER BY id a...', '', '', '', false, true) #3 C:\xampp\htdocs\app\datagrid.class.php(867): DataGrid->DataSourceOld(Object(PDO), 'SELECT id, data...', Array) #4 C:\xampp\htdocs\app\datagrid.class.php(751): DataGrid->DataSourceNew(Array) #5 C:\xampp\htdocs\app\index.php(82): DataGrid->__call('DataSource', Array) #6 {main} thrown in C:\xampp\htdocs\app\classes\sqlparser.class.php on line 208

I attach jpg files with XAMPP versions tested (7.1.11 and 5.6.32) with DataGrid v7.9.9 - Extension: PEAR - Database: mysql
Version 5.6.32 (PHP 5) work fine, 7.1.11 (PHP 7) doesn't work well.
Best regards.
Attachments
XAMPP_PHP_5_VS_PHP_7 - Win10.jpg
XAMPP_PHP_5_VS_PHP_7 - Win10.jpg (147.64 KiB) Viewed 551 times

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

Re: DataGrid v7.9.9 Extension: PDO Database: mysql

Postby administrator » Dec 12th, '17, 14:24

Don't run PEAR extension, use PDO instead.


Return to “ApPHP DataGrid {bugs}”