Mysqlm error; query failed

**dekleinemedia** · 2009-06-16, 08:33 AM

Hello,
I have the following problem, and i hope someone can help me with;

after an update from sugar v5.2.0e to v.5.2.0f i now get an error when i want to create an new project;

Error Message:
Query Failed:INSERT into project set ::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 '' at line 1

Does someone knows how to fix this problem?

Much appreciate, thanksss

**crmbalah** · 2009-06-16, 11:41 AM

Hi
try to execute the "Repair Database","Clear Vardefs Data Cache" repairs

**andopes** · 2009-06-16, 11:43 AM

Hi Jordy

How did you perform the upgrade process?
Go to Admin -> Repair -> Quick Repair and Rebuild.

Cheers

**dekleinemedia** · 2009-06-16, 01:40 PM

Originally Posted by andopes

Hi Jordy

How did you perform the upgrade process?
Go to Admin -> Repair -> Quick Repair and Rebuild.

Cheers

Hi, i did the upgrade process as written in the Sugar Upgrade Manual. Admin -> Upgrade Wizard and followed the instructions. Now i get the same message everytime i want to create a new project. I have add some new labels and fields within this module, maybe that is the problem?

When i want to create a new contact (which is not customized) everthing works fine. Its just only the projects of which the system says that there is a Mysql error.
I repaired this several time, still without any luck.

Hope someone knows whats going on.