⚠ In case you've missed it we are migrating to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This forum is read-only and soon will be archived. ⚠


majd94

Member Since 04 Jul 2019
Offline Last Active Apr 29 2021 08:54 PM
-----

Posts I've Made

In Topic: Try to "CRUD" from a view

13 April 2021 - 12:14 PM

Any idea?


In Topic: Try to "CRUD" from a view

10 April 2021 - 09:57 AM

Hello John, thanks for your reply. I really have checked every thing, seemed to be a connection database error only when click on read, edit (by using view as a table). Do you have a solution?
This is the response that I get when calling a specific row:

An uncaught Exception was encountered

Type: Zend\Db\Adapter\Exception\InvalidQueryException

Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= '1'' at line 1

Filename: C:\xampp\htdocs\plesung\application\libraries\GroceryCrudEnterprise\zendframework\zend-db\src\Adapter\Driver\Mysqli\Connection.php

Line Number: 240

 

 

 


In Topic: Try to "CRUD" from a view

09 April 2021 - 06:22 PM

You have to add the primary_key if you want to add a view. For example:
 

$crud->set_table('dist_cli');
$crud->set_primary_key('id');

 

I am using GC Enterprise und want to crud from a view. I did put the primary key and the table has correctly loaded. But when I click on read a row, it appears this error We can't process the response of the server. This is all we know about it:

Summary: 500 - Internal Server Error

Error: error

Response: