From: Filipus K. <ch...@gm...> - 2011-10-22 17:02:14
|
Le 2011-10-22 07:21, Jean-François BILGER a écrit : > That's the one. Thanks. Good to know the first 2 are gone. > > 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 '-37' at line 1 - > > SELECT tti.*, ttif.`value`, ttf.`type`, sttif.`value` as `sortvalue` > FROM > ( `tiki_tracker_items` tti > INNER JOIN `tiki_tracker_item_fields` ttif ON tti.`itemId` = > ttif.`itemId` > INNER JOIN `tiki_tracker_fields` ttf ON ttf.`fieldId` = ttif.`fieldId`) > LEFT JOIN (`tiki_tracker_item_fields` sttif) ON (tti.`itemId` = > sttif.`itemId` AND sttif.`fieldId` = 41) > WHERE tti.`trackerId` = '5' and (`status`='o' or `status`='c') AND > `ttif`.`fieldId` IN( '41' ) > GROUP BY tti.`itemId` > ORDER BY `sortvalue` asc -37? Enlarging the message field will surely help. Another thing which would help a lot would be to log which request URL caused a database error. > > 2011/10/22 Jean-François BILGER <cha...@gm... > <mailto:cha...@gm...>> > > Ok for the 2 first. Was a migration problem, old dev.to > <http://dev.to> was still trying to store data. > > For the last, i will make some changes in DB structure of Action > log to have more than 200 character. > > I'll let you know when it's done. > > > 2011/10/21 Louis-Philippe Huberdeau <lph...@lp... > <mailto:lph...@lp...>> > > I would need more details. > > The first one, I greped through the code and could not find > anything. The table lost most of its columns. > > The second one, the column was also removed. I couldn't find > traces in the code either. > > The third one, the fragment is too short to find the origin. > > -- > LP > > On Fri, Oct 21, 2011 at 2:58 AM, Jean-François BILGER > <cha...@gm... <mailto:cha...@gm...>> wrote: > > We have a lot of failed SQL query in actionlog. > > Could someone have a look at that ? (LPH or someone else) > > Unknown column 'type' in 'where clause' - select * from > `users_permissions` where `type`= 'wiki' and `permName` > > '' order by `permName` desc > > Unknown column 'lang' in 'field list' - SELECT `fieldId`, > `lang`, `value` FROM `tiki_tracker_item_fields` WHERE 1=1 > AND `itemId` = '1085' > > 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 '-12' at line 1 - SELECT tti.*, > ttif.`value`, ttf.`type`, tti.`created` as `sortvalue` > FROM ( `tiki_tracker_items` tti > > -- > Changi > -- > Tiki Wiki CMS Groupware Project - Infrastructure Team - > http://tiki.org > > > |