I have a MySQL error 1064 in syntax ?!

[dekleinemedia]

Hi, I get the following error when i want to repair my database;

I create a new field in my a package called "Complaints". This new field is called "invoice_amount". When i deploy my package and i try to quick rebuild repair i get this message;

Executing repair query: Query Failed:ALTER TABLE comp_complaints_projecten add column invoice_amount float(18,2,2) NULL::MySQL error 1064: 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 '2) NULL' at line 1

Does anybody knows how i can fix this error? Thankss

Much Appreciate

[andopes]

Hi Jordy

It is related to a sugar bug.
Sometimes sugar adds a second precision number on query which generate a sql error.
So go to Admin -> Repair -> Quick Repair and Rebuild and when the sql query text area is displayed remove the second precision number.

Cheers

[dekleinemedia]

Hi Andopes,

Great, it worked! Thanks a lot, this will spare me much time

I appreciate all your help

[zaska]

Hi Jordy

It is related to a sugar bug.
Sometimes sugar adds a second precision number on query which generate a sql error.
So go to Admin -> Repair -> Quick Repair and Rebuild and when the sql query text area is displayed remove the second precision number.

Cheers

Is there a fix for that bug?

[zaska]

Fixed Bugs in 5.2.0g
Bug 28463
When using the MySQL database, setting the precision for a decimal field for a custom module results in a SQL error.

[KACP]

It is related to a sugar bug.
Sometimes sugar adds a second precision number on query which generate a sql error.
So go to Admin -> Repair -> Quick Repair and Rebuild and when the sql query text area is displayed remove the second precision number.

Cheers

Andopes -- I'm not clear where you can remove second precision number within Quick Repair. What am I missing? I have the same issue.

<<Error filling in additional detail fields: Query Failed:SELECT name , assigned_user_id parent_name_owner from accounts where id = '#BO6 4U6&\'::MySQL error 1064: 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 ''#BO6 4U6&\'' at line 1>>