[CDBI] Odd behaviour under RedHat vs Debian
Mike Whitaker <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.class-dbi |
|---|---|
| Message-ID | <[email protected]> |
I have a chunk of code which works fine under Debian etch (CDBI
3.0.14, DBI 1.52, CDBI::Loader 0.33, CDBI::L::mysql 0.30,
DBIx::ContextualFetch 1.03), and fails under Redhat (CDBI 3.0.16, DBI
1.40 OR 1.53, CDBI::Loader 0.32 being the only differences)...
Basically, it's screwing up an add_to_xxx on a has_many, viz:
Can't insert new MCD::SQL::PointAward: DBD::mysql::st execute failed:
You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near '1210220 (table_id, reason, points, player_id, table_name)
VALUES ('1210220', 'So' at line 1 [for Statement "INSERT INTO 1210220
(table_id, reason, points, player_id, table_name)
VALUES (?, ?, ?, ?, ?)
" with ParamValues: 4='uid_solve', 1='Solved card 40', 3='46151',
0='1210220', 2=10
Note that the first param value (1210220) seems to have got somehow
inserted as the TABLE name in the generated SQL.
Anyone seen this before, or any clue what's going on?
--
Mike Whitaker - [email protected]
Tel: +44 (0) 20 7501 1920 - Mob: +44 (0) 7971 977375
Skype: FleetfootMike; AIM: FleetfootMike