Error retrieving Meeting list: Query Failed

[Jirka]

» Operating system type and version (Debian Linux)
» Sugar Suite version (4.5.1)
» Webserver type and version (Apache 2.0.55)
» PHP version (5.1.4-0.1)
» MySQL server version (5.022)


Hi,

we have a new install of SugarCRM Open Source and when we set up a meeting and then open it, it displays the meeting and under is this message:

Error retrieving Meeting list: Query Failed: SELECT users.id , ' ' m_accept_status_fields , ' ' meeting_id , users.first_name , users.last_name , as name, users.user_name , users.email1 , users.phone_work , users.created_by , 'users' panel_name FROM users INNER JOIN meetings_users ON (users.id=meetings_users.user_id AND meetings_users.meeting_id='2a6daff0-a6b3-5bd7-601b-45ec9b04a374') where ( meetings_users.deleted=0 AND users.deleted=0) AND users.deleted=0 ORDER BY name asc LIMIT 0,10::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 'as name, users.user_name , users.email1 , users.phone_work , users.created_by ,' at line 1

what to do about it? Any hints?
thanks,
j.

[pblag]

Hi!

This query generates users and contacts SubPanels.

the problem is in the following code
' ' m_accept_status_fields , ' '
This string should show a list of fields because m_accept_status_fields is Array name
So we have a problem with sql string generating.

you have to start the fixing from folder /include/SubPanel/

If you want we can help you.

you can leave us a message here:
http://www.blagodir.com/index.php?mo...s&action=index

Regards,
Petro Blagodir
pblag@blagodir.com
http://www.blagodir.com

[Jirka]

SOLVED: Lazy Unix administrator

We are playing with multiple instances on our hosting server.
Our system administator installed the first instance and it worked fine.

Then he just copied the files from this first instance into other instances and only modified config.php.
It all seemed to work, but then the ghosts as described above started to pop up.

thanks pblag for you offer and hitns.

Jirka