Home » RADICORE development » Bug Reports » Error update column to popup with Postgresql
Error update column to popup with Postgresql [message #4258] |
Sat, 14 June 2014 09:05 ![Go to next message Go to next message](/theme/default/images/down.png) |
kong
Messages: 90 Registered: December 2011
|
Member |
|
|
Column->Update and set as popup field with task id results in an update SQL statement that produces fatal error:
Fatal Error: PostgreSQL: ERROR: 42703: column "list1" does not exist LINE 1: ...ntrol='popup', optionlist=NULL,task_id=h_supplier(list1), fo... ^ LOCATION: errorMissingColumn, src\backend\parser\parse_relation.c:2655 (# 42703)
SQL query: UPDATE dict_column SET control='popup', optionlist=NULL,task_id=h_supplier(list1), foreign_field='supplier_id', revised_date='2014-06-14 07:52:10', revised_user='EKL' WHERE database_id='hotel' AND table_id='expense' AND column_id='supplier_id'
It appears that ...task_id=h_supplier(list1)... is missing the single quotes. For full error details, please see attached pdf file.
|
|
|
|
|
|
Re: Error update column to popup with Postgresql [message #4263 is a reply to message #4262] |
Mon, 16 June 2014 14:05 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to next message](/theme/default/images/down.png) |
kong
Messages: 90 Registered: December 2011
|
Member |
|
|
That modification allowed us to move further one step but hit next problem instead upon 'import columns':Fatal Error: PostgreSQL: ERROR: 23502: null value in column "is_password" violates not-null constraint DETAIL: Failing row contains (hotel, expense, expense_id, 1, Expense Id, null, integer, null, null, 10, 10, N, Y, PRI, nextval('expense_expense_id_seq'::regclass), 1, N, null, null, null, -2147483648, 2147483647, 0, 2147483647, null, null, null, null, null, null, null, null, null, null, null, N, null, null, null, null, null, null, null, null, null, null, null, null, 2014-06-14 04:27:40, EKL, 2014-06-16 17:36:29, EKL, integer). LOCATION: ExecConstraints, src\backend\executor\execMain.c:1611 (# 23502)
SQL query: UPDATE dict_column SET col_default='nextval(''expense_expense_id_seq''::regclass)', col_auto_increment='1', is_password=NULL,auto_insert=NULL,auto_update=NULL,infinityisnull=NULL,revised_date='2014-06-16 17:36:29', revised_user='EKL' WHERE database_id='hotel' AND table_id='expense' AND column_id='expense_id'
Error in line 1446 of file 'D:\Pet\PHP Full Env\UwAmp\www\radpg184\includes\dml.pgsql.class.inc'. and this error when trying to do import columns for some other tables:Fatal Error: PostgreSQL: ERROR: 23502: null value in column "col_auto_increment" violates not-null constraint DETAIL: Failing row contains (hotel, department, department_id, 1, Department Id, null, varchar, null, null, 16, 16, N, Y, PRI, null, null, null, null, null, null, null, null, null, null, null, null, null, UPPER, N, null, null, null, null, null, null, N, null, null, null, null, null, null, null, null, null, null, null, null, 2014-06-09 01:53:40, MGR, 2014-06-16 17:59:12, EKL, varchar). LOCATION: ExecConstraints, src\backend\executor\execMain.c:1611 (# 23502)
SQL query: UPDATE dict_column SET col_auto_increment=NULL,col_unsigned=NULL,auto_insert=NULL,auto_update=NULL,infinityisnull=NULL,revised_date='2014-06-16 17:59:12', revised_user='EKL' WHERE database_id='hotel' AND table_id='department' AND column_id='department_id'
Error in line 1446 of file 'D:\Pet\PHP Full Env\UwAmp\www\radpg184\includes\dml.pgsql.class.inc'. Perhaps need to make more modifications to the table column definitions for dict_column?
|
|
|
|
|
|
|
Goto Forum:
Current Time: Mon Sep 09 10:01:42 EDT 2024
Total time taken to generate the page: 0.03329 seconds
|