Fatal Error with SugarCrm 4.51e Subpanels!!

[drs]

HI All

We are having the same issue as the one below, our versions are :-

Fedora Core 6
Apache 2.2.2
Mysql 5.0.27
SugarCRM Version 4.5.1e (Build 1049)
Php 5.1.6

All has been working fine, have tried repairing everything through Sugar admin, to no avail. The top levels all work fine, its just the subpanels keep producing the following error, and this occurs for all the modules!!!!! THis is a major show stopper, and Im struggling.... have noticed a few other people having this issue? any help very gratefully accepted!!!

Error retrieving Account list: Query Failed SELECT meetings.id , meetings.name , meetings.status , CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')) contact_name, ' ' contact_name_owner , ' ' contact_name_mod , meetings.date_modified , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' filename , meetings.assigned_user_id , 'meetings' panel_name FROM meetings AND contacts.deleted=0 LEFT JOIN users jt1 ON jt1.id= meetings.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( meetings.parent_id= '8d71bed0-59b7-2131-6be9-4601091724bd' AND meetings.parent_type='Accounts' AND meetings.deleted=0 AND (meetings.status='Held' OR meetings.status='Not Held')) AND meetings.deleted=0 ) UNION ALL ( SELECT tasks.id , tasks.name , tasks.status , CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')) contact_name , tasks.contact_id , contacts.assigned_user_id contact_name_owner , 'Contacts' contact_name_mod, tasks.date_modified , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' filename , tasks.assigned_user_id , 'tasks' panel_name FROM tasks LEFT JOIN contacts contacts ON contacts.id= tasks.contact_id AND contacts.deleted=0 AND contacts.deleted=0 LEFT JOIN users jt1 ON jt1.id= tasks.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( tasks.parent_id= '8d71bed0-59b7-2131-6be9-4601091724bd' AND tasks.parent_type='Accounts' AND tasks.deleted=0 AND (tasks.status='Completed' OR tasks.status='Deferred')) AND tasks.deleted=0 ) UNION ALL ( SELECT calls.id , calls.name , calls.status , CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')) contact_name, ' ' contact_name_owner , ' ' contact_name_mod , calls.date_modified , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' filename , calls.assigned_user_id , 'calls' panel_name FROM calls AND contacts.deleted=0 LEFT JOIN users jt1 ON jt1.id= calls.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( calls.parent_id= '8d71bed0-59b7-2131-6be9-4601091724bd' AND calls.parent_type='Accounts' AND calls.deleted=0 AND (calls.status='Held' OR calls.status='Not Held')) AND calls.deleted=0 ) UNION ALL ( SELECT notes.id , notes.name , ' ' status , CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')) contact_name , notes.contact_id , contacts.assigned_user_id contact_name_owner , 'Contacts' contact_name_mod, notes.date_modified , ' ' assigned_user_name , ' ' assigned_user_owner , ' ' assigned_user_mod , notes.filename , notes.created_by , 'notes' panel_name FROM notes LEFT JOIN contacts contacts ON contacts.id= notes.contact_id AND contacts.deleted=0 AND contacts.deleted=0 where ( notes.parent_id= '8d71bed0-59b7-2131-6be9-4601091724bd' AND notes.parent_type='Accounts' AND notes.deleted=0) AND notes.deleted=0 ) UNION ALL ( SELECT emails.id , emails.name , emails.status , CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')) contact_name, ' ' contact_name_owner , ' ' contact_name_mod , emails.date_modified , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' filename , emails.assigned_user_id , 'emails' panel_name FROM emails AND jt0.deleted=0 LEFT JOIN users jt1 ON jt1.id= emails.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where emails.deleted=0 ) ORDER BY date_modified desc 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 'AND contacts.deleted=0 LEFT JOIN users jt1 ON jt1.id= meetings.assigned_user_i' at line 1





Quote:
Originally Posted by soreilly
Hi,

I have been developing custom modules using Olavo's Module Builder v4.5.1c, (with the Time/Invoice module installed) and had no problem interacting them with my running version of Sugar 4.5.1d. However, recently I have not been able to see the subpanels for the base Sugar modules ie. Projects, Opportunities etc.

The error on screen is:

Error retrieving Opportunity list: Query Failed SELECT meetings.id , meetings.name , meetings.status , CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')) contact_name, ' ' contact_name_owner , ' ' contact_name_mod , meetings.date_start , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, meetings.time_start , meetings.assigned_user_id , 'meetings' panel_name FROM meetings AND contacts.deleted=0 LEFT JOIN users jt1 ON jt1.id= meetings.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( meetings.parent_id= 'ae3f05db-19c3-fdac-d7b3-467bdd191ec5' AND meetings.parent_type='Opportunities' AND meetings.deleted=0 AND (meetings.status='Planned')) AND meetings.deleted=0 ) UNION ALL ( SELECT tasks.id , tasks.name , tasks.status , CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')) contact_name , tasks.contact_id , contacts.assigned_user_id contact_name_owner , 'Contacts' contact_name_mod, tasks.date_due as date_start , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, tasks.time_due as time_start , tasks.assigned_user_id , 'tasks' panel_name FROM tasks LEFT JOIN contacts contacts ON contacts.id= tasks.contact_id AND contacts.deleted=0 AND contacts.deleted=0 LEFT JOIN users jt1 ON jt1.id= tasks.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( tasks.parent_id= 'ae3f05db-19c3-fdac-d7b3-467bdd191ec5' AND tasks.parent_type='Opportunities' AND tasks.deleted=0 AND (tasks.status='Not Started' OR tasks.status='In Progress' OR tasks.status='Pending Input')) AND tasks.deleted=0 ) UNION ALL ( SELECT calls.id , calls.name , calls.status , CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')) contact_name, ' ' contact_name_owner , ' ' contact_name_mod , calls.date_start , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, calls.time_start , calls.assigned_user_id , 'calls' panel_name FROM calls AND contacts.deleted=0 LEFT JOIN users jt1 ON jt1.id= calls.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( calls.parent_id= 'ae3f05db-19c3-fdac-d7b3-467bdd191ec5' AND calls.parent_type='Opportunities' AND calls.deleted=0 AND (calls.status='Planned')) AND calls.deleted=0 ) ORDER BY date_start desc 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 'AND contacts.deleted=0 LEFT JOIN users jt1 ON jt1.id= meetings.assigned_user_i' at line 1


And the log file looks like this:

07/03/07 15:42:07,066 [2684] FATAL SugarCRM - 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 'AND users.id = '1'' at line 1
07/03/07 17:22:21,115 [2684] FATAL SugarCRM - Error fetching relationship from cache bugs_configurations
07/03/07 17:22:21,170 [2684] FATAL SugarCRM - Error fetching relationship from cache configurations_test_suites
07/03/07 17:22:44,428 [2684] FATAL SugarCRM - Error fetching relationship from cache testplans_test_suites
07/04/07 17:41:35,450 [1692] FATAL SugarCRM - Error fetching relationship from cache bugs_configurations
07/04/07 17:41:35,632 [1692] FATAL SugarCRM - Error fetching relationship from cache configurations_test_suites
07/04/07 17:42:24,382 [1692] FATAL SugarCRM - Error fetching relationship from cache testplans_test_suites
07/04/07 17:53:02,563 [1692] FATAL SugarCRM - Error fetching relationship from cache testplans_test_suites
07/04/07 17:53:53,955 [1692] FATAL SugarCRM - Error fetching relationship from cache bugs_test_suites
07/04/07 17:53:54,010 [1692] FATAL SugarCRM - Error fetching relationship from cache configurations_test_suites
07/04/07 17:53:54,037 [1692] FATAL SugarCRM - Error fetching relationship from cache testplans_test_suites
07/04/07 18:01:06,071 [1692] FATAL SugarCRM - 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 'AND jcrmtime.assigned_user_id = GROUP BY 1,2 ORDER BY 1' at line 1

The sub-panels for the created modules work fine though, any ideas anybody?

I'm running PHP 5.1.2, Apache 2.2.0 and MySQL 5.0.18.

I posted this in the Developer's forum a while ago, but there was no reply from anyone over there, so this seemed to be the next port of call.

P.S. Olavo, the beta version of the Wizard is looking superb, well done so far

[drs]

Further information on this problem, for others out there who experience it. It seems the database is ok, by exporting the data base to a fresh code base, the data relationships seem to be ok (phew!!) and the errors stop, but I think that when updating via studio, some how relationships are damaged. I have yet to work out exactly what is happening, and any thoughts others out there might have on this problem would be helpful. thanks

[aleksserbia]

Hi drs;
are you tried "repair relationships " from studio?
try , i think it would help
all best
aleksandar.markovic@softserbia.com

[tclevela]

Everyone,

I am having the same problem. I have downloaded a fresh copy of 4.5.1e, installed it successfully, login with no issues, can create contacts or leads...etc with no issues but I NEVER see the subpanels at the bottom of the screens. It doesn't matter how many screens I look at there are still no subpanels.

I have also installed a full copy of the tool on my windows machine and I can see all subpanels with no issues so you can imagine this is driving me nuts. I have tried many different adjustments to my php.ini file and httpd.conf file with no success.

Sugar Version 4.5.1e
Sugar Edition (Opensource)
Category (All items)
Operating System (Fedora Core 5)
PHP Version (5.1.6)
Database (mysql Ver 14.12 Distrib 5.0.27)
Web Server (Apache 2.2.2)

You can login to my server and see this for yourself at http://www.fourcleves.com/CRM login as guest/guest

[al3]

Everyone,

Sugar Version 4.5.1e
Sugar Edition (Opensource)
Category (All items)
Operating System (Fedora Core 5)
PHP Version (5.1.6)
Database (mysql Ver 14.12 Distrib 5.0.27)
Web Server (Apache 2.2.2)

You can login to my server and see this for yourself at http://www.fourcleves.com/CRM login as guest/guest

You are not seeing sub-panels nor are you seeing theme choices on Accounts, Leads, etc. You say you installed a fresh set of modules. OK. Then what I want to know is what version of PHP are you running on your desktop. The only thing I come up with is that Sugar does not run well with 5.1.6 and maybe you should try to upgrade to the latest 5.2.x and see if that helps.

I looked at all you settings in admin and they looks good. I tried some repairs and they did not work.

I run Sugar on a FreeBSD server with PHP 5.2.3 with Apache 2.2.4 and at home on a Mac (yes, it runs fine on a Mac!) using 5.2.4. but the old Apache 1.3 (too lazy to upgrade... no need.)

What do you run on your Win machine?

Al

[tclevela]

Hi Al,

Thanks for the feedback!! I really appreciate it. I am running the sugarCRM package install for windows that installs apache, mysql and php all in one. I'm also running Windows Vista but have successfully set it up on XP as well. The install of php that comes with this package is 4.4.3 (win version) and the apache is 2.0.59 (windows version).

I'm going to try and upgrade PHP and mysql per your suggestion because that very well might solve the issue.

Any links you might have on upgrading and existing copy of PHP and APACHE would be appreciated. I've never upgraded an existing Linux PHP or APACHE for fear of screwing it up :-)

Thanks

[al3]

I'm going to try and upgrade PHP and mysql per your suggestion because that very well might solve the issue.

Any links you might have on upgrading and existing copy of PHP and APACHE would be appreciated. I've never upgraded an existing Linux PHP or APACHE for fear of screwing it up :-)

Thanks

Before you mess with PHP I would do a complete re-install of Sugar as well as generate a new database. Maybe you've done that, but if not my guess is that somehow something went wrong in the install. I don't understand why you don't get the sub-panels but my guess is that you are either missing some PHP code or version 5.1.6 does not run Sugar too well (even though it is a supported version according to the docs.)

As for upgrading PHP, just use whatever package manager Fedora is using these days... Yum, RPM or whatever. I assume you have not messed with php.ini at all, although I don't know what you could do in there that would cause the problem you have. You might want to turn on error warning as you might be taking errors but they are being suppressed by your setting in php.ini.

I'm wondering if you are missing an 'include' file somewhere.

The other possibility is that you have a corrupted database in that the links are not showing up. But if that were the case I would think the code would still execute. However if you are throwing an error, maybe PHP is just halting and that's why you are not seeing the sub-panels.

I would NOT bother upgrading Apache. I don't see that as being your problem. Maybe SQL and maybe PHP, but not Apache in this case.

Clear everything out and start over again and see what happens.

Al

[drs]

Just to update where I am with this issue. First I have run the repair relationships from in Sugar, no errors were reported, and the problem continues. After setting up another instance, and moving the entire db on to the new install, the system works perfectly once more. The difference on the new install and the old, is essentially the first is running php 5.1.6, the new working system is running 5.2.2. The strange thing about this problem was the fact it had been working well for some 6 months. I loaded a new module to the system, MarkGrins travel calendar, and uninstalled it, I had also changed some of the default columns displayed in views. Its difficult to pin it down to a particular event, because the problem occurred in the cache. At least its reassuring the data is intact.

[al3]

Just to update where I am with this issue. First I have run the repair relationships from in Sugar, no errors were reported, and the problem continues. After setting up another instance, and moving the entire db on to the new install, the system works perfectly once more. The difference on the new install and the old, is essentially the first is running php 5.1.6, the new working system is running 5.2.2. The strange thing about this problem was the fact it had been working well for some 6 months. I loaded a new module to the system, MarkGrins travel calendar, and uninstalled it, I had also changed some of the default columns displayed in views. Its difficult to pin it down to a particular event, because the problem occurred in the cache. At least its reassuring the data is intact.

Hmmm. "tclevela" is running 5.1.6 and having problems. Maybe we've uncovered a PHP bug and not a Sugar bug?

Al

[tclevela]

Ok guys, PROGRESS

I reinstalled Sugar completely with no luck. I tried upgrading my version of Fedora (5) to version 7 but even after this no luck. So I had a seperate harddrive that I decided to re-image with a completely new install of Fedora 7 and pulled all of my data over from the previous version of Fedora. I pulled the databbase and files for sugar without changing a thing. I made sure my php.ini memory setting was set to 32M (which I found was already set to this by default) and I made sure my upload file size was at least 16M. This time, the memory errors weren't being generated in the httpd error_log and the sub-panels were all showing.

Biggie: The main item I found different in my newest php.ini file compared to my old was I had the "zend.zel_compatibility_mode" variable set to "ON". This was causing my other issues with not being able to actually view or edit the contacts and some other select items. This variable is set to OFF by default and with the new load of FC7. However, this did not seem to impact my subpanel issue.

In summary, with a fresh install of FC7 and with the above changes, SCRM is working like advertised. Here's my new software versions for your reference. Unfortunately, I don't know exactly what fixed the subpanel issue:

- PHP v2.2.0
- MySQL v5.0.37
- Apache 2.2.4

Feel free to incquire about any other settings I may have if you'd like to compare systems..

Regards,