Hi all,
please let me know, if you need any other information, like the schema of the tables?
The error-messages are absolutly reproducable and I cant see any error in the queries - thought I can not test them with the query tool, as it does not allow prepared statements.
Thanks for any help or thoughts
Ralf
Ralf Becker schrieb:
Hi,
The following to statements run well, before I started using prepared statements. Now I get some error-messages:
1) UPDATE phpgw_addressbook SET bday=?,url=?,org_name=?,org_unit=?,n_given=?,n_family=?,n_middle=?,n_prefix=?,n_suffix=?,fn=?,email=?,email_type=?,email_home=?,email_home_type=?,title=?,tel_work=?,tel_home=?,tel_fax=?,tel_pager=?,tel_cell=?,tel_msg=?,tel_car=?,tel_video=?,tel_isdn=?,adr_one_street=?,adr_one_locality=?,adr_one_region=?,adr_one_postalcode=?,adr_one_countryname=?,adr_one_type=?,adr_two_street=?,adr_two_locality=?,adr_two_region=?,adr_two_postalcode=?,adr_two_countryname=?,adr_two_type=?,tz=?,pubkey=?,note=?,label=?,access=?,cat_id=?,tid=?,last_mod=? WHERE id=3
Parameters: '9/67/23','','OUT GmbH','','Birgit','Becker','','','','Birgit Becker','','INTERNET','','INTERNET','','','0631 26647','','','','','','','','','','','','','','','','','','','','0','keiner','keine','wie Ralf','public','0','n','1097764302'
sapdb Error: S1000 ([MySQL MaxDB][LIBSQLOD SO][MaxDB] General error;-9404 POS(1) System error: AK System error: VAK505 2)
2) INSERT INTO phpgw_async (async_id,async_next,async_times,async_method,async_data,async_account_id) VALUES (?,?,?,?,?,?) UPDATE DUPLICATES
Parameters: '##last-check-run##','0','a:0:{}','none','a:3:{s:6:"run_by";s:8:"fallback";s:5:"start";i:1097771503;s:3:"end";i:0;}',''
sapdb Error: 23000 ([MySQL MaxDB][LIBSQLOD SO] Integrity constraint violation)
I need to use prepared statements, as some of the inserts into long columns are too big, to run as regular statements. I also hoped for some performance improvements.
Any help greatly appreciated :-)
Ralf
-- eGroupWare Training ==> http://www.outdoor-training.de/egroupware
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
