Hello,
I am getting following error while using it with Postgres, when I add any record I am getting
Message: pg_fetch_result(): Argument #1 ($result) must be of type PgSql\Result, bool given
It was working fine few days back but now its showing error, we also have unique id for table as well so not sure what is wrong, we tested but unable to resolve,
Any help really appreciated.
Thanks
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
Hello @ondigit ,
I guess there is an issue with the database itself? Maybe you have changed something? The error means that you are getting a Postgres error in the database and hence returning “false”. Maybe there is more info within the error itself? Maybe sending the full error is showing extra information?
Regards
Johnny
Sure
— Full Error —
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
<p>Backtrace:</p>
<p style="margin-left:10px">
File: /var/www/html/application/libraries/GroceryCrudEnterprise/laminas/laminas-db/src/Adapter/Driver/Pgsql/Connection.php<br />
Line: 291<br />
Function: pg_fetch_result </p>
<p style="margin-left:10px">
File: /var/www/html/application/libraries/GroceryCrudEnterprise/laminas/laminas-db/src/Adapter/Driver/Pgsql/Pgsql.php<br />
Line: 223<br />
Function: getLastGeneratedValue </p>
<p style="margin-left:10px">
File: /var/www/html/application/libraries/GroceryCrudEnterprise/grocery-crud/enterprise/src/GroceryCrud/Core/Model.php<br />
Line: 515<br />
Function: getLastGeneratedValue </p>
<p style="margin-left:10px">
File: /var/www/html/application/libraries/GroceryCrudEnterprise/grocery-crud/enterprise/src/GroceryCrud/Core/State/InsertState.php<br />
Line: 94<br />
Function: insert </p>
<p style="margin-left:10px">
File: /var/www/html/application/libraries/GroceryCrudEnterprise/grocery-crud/enterprise/src/GroceryCrud/Core/State/StateAbstract.php<br />
Line: 1177<br />
Function: GroceryCrud\Core\State\{closure} </p>
<p style="margin-left:10px">
File: /var/www/html/application/libraries/GroceryCrudEnterprise/grocery-crud/enterprise/src/GroceryCrud/Core/State/StateAbstract.php<br />
Line: 331<br />
Function: stateOperation </p>
<p style="margin-left:10px">
File: /var/www/html/application/libraries/GroceryCrudEnterprise/grocery-crud/enterprise/src/GroceryCrud/Core/State/InsertState.php<br />
Line: 104<br />
Function: stateOperationWithCallbacks </p>
<p style="margin-left:10px">
File: /var/www/html/application/libraries/GroceryCrudEnterprise/grocery-crud/enterprise/src/GroceryCrud/Core/GroceryCrud.php<br />
Line: 2867<br />
Function: render </p>
<p style="margin-left:10px">
File: /var/www/html/application/controllers/Admin.php<br />
Line: 7130<br />
Function: render </p>
<p style="margin-left:10px">
File: /var/www/html/index.php<br />
Line: 315<br />
Function: require_once </p>
Hello @ondigit ,
From a quick google search it seems that the table is not creating automatically and id for the table. My blind guess would be:
The solutions for the above:
ALTER TABLE your_table_name
ADD COLUMN id SERIAL PRIMARY KEY;
-- Find the maximum value of the id column
SELECT MAX(id) FROM your_table_name;
-- If the maximum value is close to the maximum limit of the data type,
-- you might want to reset the sequence
-- Suppose the sequence name is something like "your_table_name_id_seq"
-- Resetting the sequence would reset the auto-increment counter
-- Replace "your_table_name_id_seq" with the actual sequence name
SELECT setval('your_table_name_id_seq', (SELECT MAX(id) FROM your_table_name) + 1);
Regards
Johnny
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
Hello @ondigit ,
Not sure that the update will wok but what version do you currently have? Latest one is 3.1.1. Maybe it is worth update anyway 
Also can you give us more information about the PHP version, Postgres version that you use?
Regards
Johnny
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
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Use callbackColumn() but keep inline edit functionality |
|
3 | 648 | Apr 12 |
| Setting quick search values via JavaScript not working properly for booleans |
|
0 | 563 | Nov 2025 |
| callbackColumn() has not effect in v3.2.6 Enterprise |
|
2 | 696 | Dec 2025 |
| displayAs() doesn’t support new line in headings |
|
4 | 871 | Jan 5 |
| PRINT date format not consistent |
|
6 | 354 | Sep 7 |