[ic] No key 'code' found for function='update' table='????'

Matthew Crosswell matthew at compedge.co.nz
Sat Oct 4 12:55:25 EDT 2003


Using mysql on IC4.9
Error:
No key 'code' found for function='update' table='user_data_answers'

I'm getting the above error when posting data back to a custom database. The
insert or update works and the data is updated so there are no errors that
effect the function of the site, just this error in my error.log for the
catalog + a slight delay while the error is logged.

The table structure is :
Database user_data_answers user_data_answers.txt  SQL
Database user_data_answers DSN          __SQLDSN__
ifdef SQLUSER
Database user_data_answers USER         __SQLUSER__
endif
ifdef SQLPASS
Database user_data_answers PASS         __SQLPASS__
endif
Database user_data_answers DEFAULT_TYPE text
Database user_data_answers NO_SEARCH    1

Database user_data_answers KEY        code
Database user_data_answers COLUMN_DEF "code=varchar(64) NOT NULL PRIMARY
KEY"
Database user_data_answers COLUMN_DEF "module=int"
Database user_data_answers COLUMN_DEF "session=int"
Database user_data_answers COLUMN_DEF "user_name=varchar(64)"
Database user_data_answers INDEX        user_name
Database user_data_answers COLUMN_DEF "license=varchar(64)"
Database user_data_answers COLUMN_DEF "field_name=varchar(64)"
Database user_data_answers COLUMN_DEF "field_data=text"
Database user_data_answers COLUMN_DEF "read_only=int"

The insert statement is:
[query sql="REPLACE INTO `user_data_answers` (`code`, `module`, `session`,
`username`, `license`, `field_name`, `field_data`) VALUES ('[scratch
row_name]', '[scratch ss_mn]', '[scratch ss_sn]', '[data session username]',
'[scratch sm_lic]', '[time locale=en_US]%Y%m%d%H%M%S[/time]', '[scratch
row_value]');" type=html][/query]


Any help would be greatly appreciated
Cheers
Matthew :)



More information about the interchange-users mailing list