NOTE:: Before reporting an issue, make sure you are running the latest version, currently 3.3.1

View Issue Details Jump to Notes ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0016850phplist applicationMessage Send Processpublic27-08-13 16:3208-04-14 03:54
PlatformOSOS Version
Product Version3.0.2 
Target Version3.0.XFixed in Version3.0.6 
Summary0016850: Query updating msg/hr in messagedata will fail on geman locale
DescriptionWhen processing the queue from the command line I get a lot of messages like this:

Nachrichtenbrief - Sql error replace into messagedata set id= 1, name="msg/hr", data= 13819,3548387
Nachrichtenbrief - Database error 1064 while doing query 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 '0645161' at line 1

The messages are send out fine.

The problem is the "," in the query, MySQL needs a "." there. This is on a (old) GERMAN server, I'm pretty sure that's the problem. In german you write fractional numbers with a ",", but MySQL expects the english format with the ".".

Pretty common problem :)
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to 0016956resolvedmichiel MySQL Error while processing queue 

-  Notes
michiel (manager)
27-08-13 16:50

I've seen it in different (english) contexts as well. It should get " around the value.
niklas.rother (reporter)
08-01-14 15:34

Still having the problem on 3.0.5, seems not to be fixes.
To fix change the line setMessageData($messageid,'msg/hr',$msgperhour); in processqueue.php to setMessageData($messageid,'msg/hr',"$msgperhour");
actxc (reporter)
08-04-14 03:09
edited on: 08-04-14 03:10

for 3.0.5:

edit file admin/action/processqueue.php worked for me
line no. 1146:
change setMessageData($messageid,'msg/hr',$msgperhour);
to setMessageData($messageid,'msg/hr',"$msgperhour");

this will change the localised number format into the system format, that fits SQL syntax.

michiel (manager)
08-04-14 03:54


Copyright © 2000 - 2017 MantisBT Team
Powered by Mantis Bugtracker