5.5.2 - Can not see leads imported or added via Sugar.

**Pravo** · 2010-05-20, 05:53 PM

I installed 5.5.2.

2 Problems:

1. Couldn't import custom fields data into table leads_cstm using Sugar Import

- Requires field "Last Name" even though that field is not a field included in the custom data

- Field id_c was not available in the Sugar Import to map. How does the data in table leads_cstm get associated with data in table leads?

I went ahead and imported the custom data via phpMyAdmin to bypass the required Last Name field and to get the IDs (id_c) imported as well. Is there a way to import and update data without the required field Last Name?

2. Now that the data has been imported I am not able to see the data using ANY User accounts. I've even added data through the New Lead quick add section on the left of the Leads page to make sure it was seeing the database table. It adds the data correctly to the table with the Assigned to User as well. However, I still can't bring the lead up for that User.

I have set the permissions as suggested in the documentation for all folders and files recursively. While this fixed themes and modules issues I haven't figured out why I can't see the leads data.

Apache version 2.2.15
PHP version 5.2.9
MySQL version 5.0.90-community

Please advise!

Mike

**Pravo** · 2010-05-21, 06:17 AM

I've set all of the permissions recursively.

It sees the database just fine - I can add leads using the Quick add on the Leads page.

All leads are assigned to the Admin.

However, I can't see the leads from Sugar. Not even the leads created from the Leads page.

Please provide some suggestions. I've searched this forum but don't see any 5.5.2 posts that have similar problem and haven't found a previous version post similar either.

All fields are clear in the basic and advanced search as well so it isn't a seach field issue.

Please give me some ideas.

Thanks!

**Pravo** · 2010-05-21, 02:52 PM

1. 777 on all files and folders so it can't be a permissions issue.
2. Created a new user
3. Logged in as the new user
4. Created a new lead
5. Lead added to database table "leads" confirmed

Problem: User can not see lead once created. There are no search filters in place. Search is totally clear.

I've worked with Sugar for about a year now and have never had this problem until 5.5.2. Does anyone who doesn't think it is the layout, css and permissions issues have ANY suggestions?

I've run all the rebuilds, set permissions to 775/664 then all to 777, I've checked config.php and everything is running great with the exception of being able to see my lead data.

System settings mentioned above.

**Pravo** · 2010-05-21, 06:44 PM

Here is the error I was receiving prior to changing the permissions to 777 all directories and all files. These errors were happening with 775/664 permissions:

Code:

[Fri May 21 09:37:09 2010] [error] [client 00.000.00.000] File does not exist: /home/xxxxxx/public_html/403.shtml, referer: http://www.website.com/SugarDirector...s&action=index
[Fri May 21 09:37:09 2010] [error] [client 00.000.00.000] (13)Permission denied: file permissions deny server access: /home/xxxxxx/public_html/SugarDirectory/cache/jsLanguage/en_us.js, referer: http://www.website.com/SugarDirector...s&action=index
[Fri May 21 09:37:00 2010] [error] [client 00.000.00.000] File does not exist: /home/xxxxxx/public_html/403.shtml, referer: http://www.website.com/SugarDirector...ion=DetailView
[Fri May 21 09:37:00 2010] [error] [client 00.000.00.000] (13)Permission denied: file permissions deny server access: /home/xxxxxx/public_html/SugarDirectory/cache/jsLanguage/en_us.js, referer: http://www.website.com/SugarDirector...ion=DetailView
[Fri May 21 09:36:56 2010] [error] [client 00.000.00.000] File does not exist: /home/xxxxxx/public_html/403.shtml, referer: http://www.website.com/SugarDirector...ion=DetailView
[Fri May 21 09:36:56 2010] [error] [client 00.000.00.000] (13)Permission denied: file permissions deny server access: /home/xxxxxx/public_html/SugarDirectory/cache/jsLanguage/en_us.js, referer: http://www.website.com/SugarDirector...ion=DetailView
[Fri May 21 09:36:26 2010] [error] [client 00.000.00.000] File does not exist: /home/xxxxxx/public_html/403.shtml, referer: http://www.website.com/SugarDirector...s&action=index
[Fri May 21 09:36:26 2010] [error] [client 00.000.00.000] (13)Permission denied: file permissions deny server access: /home/xxxxxx/public_html/SugarDirectory/cache/jsLanguage/en_us.js, referer: http://www.website.com/SugarDirector...s&action=index
[Fri May 21 09:36:25 2010] [error] [client 00.000.00.000] File does not exist: /home/xxxxxx/public_html/403.shtml, referer: http://www.website.com/SugarDirector...s&action=index
[Fri May 21 09:36:25 2010] [error] [client 00.000.00.000] (13)Permission denied: file permissions deny server access: /home/xxxxxx/public_html/SugarDirectory/cache/jsLanguage/en_us.js, referer: http://www.website.com/SugarDirector...s&action=index

Have not received this error since. I don't want to leave everything 777. Even though I dont get this error anymore I still can not see any leads that have been imported via phpMyAdmin or added through Sugar.

**cs3gallery** · 2010-05-21, 08:33 PM

So just to be clear. You did go to the admin panel and do a database repair?

Did you also set the owner to your sugar directory to the correct owner?

for debian its www-data for apache

**Pravo** · 2010-05-21, 09:02 PM

Yes, I have done the database repair several times. I went down the list in the admin panel.

Unclear on your last question. Do you mean when setting the permissions?

I've tried the 775/664, 775/666, 777 to no avail.

OK - I understand what you are asking about setting the owner. The thing is that the old version of Sugar 4.something worked (using same server). Using the old version I could see everything and it worked great. I tried to step upgrade but decided it was too much trouble so I just clean installed 5.5.2 and imported the data. So, the only thing now is that I can't see the data.

**Pravo** · 2010-05-21, 09:21 PM

Just checked and the Apache settings are correct. .htaccess rebuild works. ???

**Pravo** · 2010-05-22, 07:12 PM

It is looking for an .htaccess file in the following directories:

/cache/jsLanguage/Leads/.htaccess pcfg_openfile: unable to check htaccess file
/cache/jsLanguage/Administration/.htaccess pcfg_openfile: unable to check htaccess file
/cache/jsLanguage/Contacts/.htaccess pcfg_openfile: unable to check htaccess file

I don't have any .htaccess files in those directories. I've run the rebuild but it still doesn't create them.

Can someone provide me with the .htaccess file that is supposed to be in those directories?

**Pravo** · 2010-05-24, 04:41 PM

Problem Fixed:

I completely deleted the 5.5.2 install.

Installed 5.5.0a and re-installed 5.5.2 duplicating each step between the two versions.

5.5.0a works fine once you set the permissions and added the.htaccess files to the proper directories.

5.5.2 still does not work so there must be a bug in this version.

I wanted to post this resolution to my problem in case others have experienced or are experiencing issues with 5.5.2.

Since the forum contributors who only respond with generic permissions or theme based answers for the simple reason to build their Post numbers didn't want to help address this issue...

well...