[CDBI] Odd behaviour under RedHat vs Debian

Mike Whitaker mike at mindcandydesign.com
Fri Nov 17 10:48:33 GMT 2006


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 - mike at mindcandydesign.com
Tel: +44 (0) 20 7501 1920 - Mob: +44 (0) 7971 977375
Skype: FleetfootMike; AIM: FleetfootMike





More information about the ClassDBI mailing list