Author Topic: Error Creating Reports 2.2.4.1  (Read 4386 times)

sosamv

  • Newbie
  • *
  • Posts: 7
    • View Profile
    • Email
Error Creating Reports 2.2.4.1
« on: April 11, 2013, 02:04:31 PM »
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'.
« Last Edit: April 11, 2013, 02:06:40 PM by sosamv »

goldmanp

  • Newbie
  • *
  • Posts: 1
    • View Profile
    • Email
Re: Error Creating Reports 2.2.4.1
« Reply #1 on: April 15, 2013, 09:20:58 AM »
Hi sosamv.
Could you solve this issue?
Same problem :(
Thanks

Slartibardfast

  • Freshman
  • *
  • Posts: 12
    • View Profile
    • Email
Re: Error Creating Reports 2.2.4.1
« Reply #2 on: April 22, 2013, 07:09:44 PM »
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

  • Newbie
  • *
  • Posts: 1
    • View Profile
    • Email
Re: Error Creating Reports 2.2.4.1
« Reply #3 on: April 22, 2013, 11:33:26 PM »
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

  • Freshman
  • *
  • Posts: 12
    • View Profile
    • Email
Re: Error Creating Reports 2.2.4.1
« Reply #4 on: April 27, 2013, 10:25:09 AM »
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

  • Newbie
  • *
  • Posts: 2
    • View Profile
Re: Error Creating Reports 2.2.4.1
« Reply #5 on: April 27, 2013, 03:17:23 PM »
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

  • Freshman
  • *
  • Posts: 12
    • View Profile
    • Email
Re: Error Creating Reports 2.2.4.1
« Reply #6 on: April 28, 2013, 10:26:49 AM »
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

  • Administrator
  • Hero Member
  • *****
  • Posts: 1819
    • View Profile
    • Email
Re: Error Creating Reports 2.2.4.1
« Reply #7 on: April 29, 2013, 04:05:37 PM »
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
Would you like to install Feng Office Professional or Enterprise Edition in your servers? No problem! Read this article!

sosamv

  • Newbie
  • *
  • Posts: 7
    • View Profile
    • Email
Re: Error Creating Reports 2.2.4.1
« Reply #8 on: May 03, 2013, 02:23:06 PM »
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

  • Administrator
  • Hero Member
  • *****
  • Posts: 1819
    • View Profile
    • Email
Re: Error Creating Reports 2.2.4.1
« Reply #9 on: May 06, 2013, 11:12:39 AM »
Thanks for the feedback!
You may try with the 2.3RC version as well :)

Best regards,
Francisco
Would you like to install Feng Office Professional or Enterprise Edition in your servers? No problem! Read this article!

 

anything