Hello Johnny, We able to fix issue by passing the last inserted ID to the function, so all is working as expected. Appreciate for your time and support. Thanks

Hello Johnny, We have already added SERIAL PRIMARY KEY, and few days back it was working fine, suddenly its showing this error. Do we need to update the GC to latest version or something like that ? Kindly advise. Thanks

Sure — Full Error — An uncaught Exception was encountered Type: TypeError Message: pg_fetch_result(): Argument #1 ($result) must be of type PgSql\Result, bool given Filename: /var/www/html/application/libraries/GroceryCrudEnterprise/laminas/laminas-db/src/Adapter/Driver/Pgsql/Connection.php Li…

An uncaught Exception was encountered Type: TypeError Message: pg_fetch_result(): Argument #1 ($result) must be of type PgSql\Result, bool given Filename: /var/www/html/application/libraries/GroceryCrudEnterprise/laminas/laminas-db/src/Adapter/Driver/Pgsql/Connection.php Line Number: 291

Even if we remove the status from array and use this $crud->setRelation(‘groupid’,‘tbluser_group’,‘name’); Then also it does not work can you please let us know

We are using the simple setrelation function $crud->setRelation(‘groupid’,‘tbluser_group’,‘name’,array(‘status’ => ‘1’)); we also tried with this $crud->setRelation(‘groupid’,‘tbluser_group’,‘name’, [‘status’ => ‘1’]) but still having the same issue

hello, Can you please reply for this below question also now the grocery crud is working but when i add setRelation to function there is error nothing is displayed Error: Internal Server Error. Server Response: The server returned an empty response (e.g. a blank page). And when i remove the se…

Hello, Can you please tell how to enable debug mode in grocery crud enterprise v3 so that i can get to know errors?

hello, now the grocery crud is working but when i add setRelation to function there is error nothing is displayed Error: Internal Server Error. Server Response: The server returned an empty response (e.g. a blank page). And when i remove the setRelation line from function the page displayes the…

Hello, This $crud->setSequenceName(‘demo_id_seq’); will be used for “demo” table and this $crud->setSequenceName(‘demo1_id_seq’); will be used for “demo1” table we i have used correct only for both the functions this is not the solution

Hello, Just to make sure, the name that you have is demo_id_seq and not demo1_id_seq that you are referring to. So maybe it was just a typo? If not then maybe something like this may work? == the table name, schema name is correct only my table is demo1 and schema is da_client_master there is no…

Hello, I tried using your setsequencename prperty but nothing seems to be changed. getting the following same error A PHP Error was encountered Severity: Warning Message: pg_query(): Query failed: ERROR: relation “demo1_id_seq” does not exist LINE 1: SELECT CURRVAL(‘demo1_id_seq’) as “currval” ^ …

Hello, i tried the example which you provided but while adding serial as datatype to to “id” column after executing query its shows integer as datatype don’t know why there is no serial datatype. Is this due to PostgreSQL 15.3 or anything else not able to get

It has to do something with the nextval to be honest. == not able to get what is the issue because fir update from system everything works ok Maybe this is an issue with the database schema? == but how to check that because other database also having the same schema and it works fine there. Can yo…

Yes sure i will provide ou the code: public function index() { $schema_name=“da_client_master”; $crud = $this->_getGroceryCrudEnterprise(); $crud->setDatabaseSchema($schema_name); $crud->setTable(‘demo’); $crud->setSubject(‘demo’, ‘demo’); $crud->columns([‘firstname’,‘username’,‘email’]); $…

Please see below screen after adding var_dump($config); [dev.rialtorepairs.com_ci3_ - Google Chrome 2023-07-17 10.30.59] Also can you give us more info? Are you using CodeIgniter version 4? ==no we not using codeigniter 4 we are using codeigniter 3 now i getting my columns listing but now one …