Error Creating Reports 2.2.4.1

[sosamv]

Hello, I've just installed feng office locally, the version is 2.2.4.1, everything works perfect but the reports, I cant save 'em i'm getting the same error everytime.

Query failed with message '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 ''object_id','59')
ON DUPLICATE KEY UPDATE content = '59'' at line 2'

The problem is located at line 186 of the ApplicationDataObject.clas.php, the function $searchable_object->getRelObjectId() is returning 'null'.

[goldmanp]

Hi sosamv.
Could you solve this issue?
Same problem
Thanks

[Slartibardfast]

Having just upgraded from 2.2.2 to 2.2.4.1 (which went very smoothly as far as I can tell), I have exactly the same problem.

The previous Reports open and print fine, and will even Edit and Save.  It is adding a (new) Custom Report where it falls over.

Haven't found any other problems yet, but I haven't used it much (only just upgraded).

[likaku]

We have the same problem, as my feng has been new installed with mysql 5 without any plugin and customized field. please help on this!

[Slartibardfast]

Until such time as this is fixed, I will have to revert to 2.2.2.  No point in upgrading if Reports are broken.  I am sure it will be sorted out in time.

[giorgosk]

appropriate place to report bugs is the bugtracker
fengoffice.com/web/bugs/
(but you have to register and login)

TEMPORARY SOLUTION
I realized dropping new 2.3beta version on top of the 2.2.4.1
(found here sourceforge.net/projects/opengoo/)
and running /public/upgrade from the browser lets me save custom reports !!!!

read upgrade instructions here
fengoffice.com/web/wiki/doku.php/installation:migration

[Slartibardfast]

Already done, but thanks for the suggestion.

I'll probably run with 2.2.2 for the time being.  What does 2.2.4.1 give which makes it more compelling?  Apart from the general principle and efficacy of using the latest stable releases of any supported software.

[franponce87]

Already done, but thanks for the suggestion.

I'll probably run with 2.2.2 for the time being.  What does 2.2.4.1 give which makes it more compelling?  Apart from the general principle and efficacy of using the latest stable releases of any supported software.

You may find further info here:
http://www.fengoffice.com/web/blogen/?p=1076

Best regards,
Francisco

[sosamv]

Dont panic people... I've got This! hahaha, just download the beta version, and replace the ApplicationDataObject.class.php with the new one, and fixed

[franponce87]

Thanks for the feedback!
You may try with the 2.3RC version as well

Best regards,
Francisco