Not listing contacts, accounts, etc.

[jsanto]

Greetings,

We've just installed 4.5.1 of Sugar CRM.
Operating System: Windows 2000 Server
Webserver: IIS 6
PHP: 5.2.4
MySQL 5.0

Everything at first glance appears to be working, but when you add a new account or contact, though they populate the DB, they do not appear in any lists (ie: Accounts list, Contacts list) and they do not appear in the search. This is also true for meetings, although you can see a meeting in calendar view, just not in a list. I imagine it's true for activities and the like. No read from DB.

Essentially it appears data isn't coming back from the DB in these instances, although the Calendar function works ad does the Portal function (where you can add a web site, etc.)

We're really excited about Sugar, and when one of us installed 4.5.1 on a local machine running Apache (I believe), it was no issue. We tried installing Sugar 5.0 as well, and that's when we noticed the DB problem, thus we attempted 4.5.1 and are experiencing the same problem.

You help is greatly appreciated!

Regards,

Jason

[jsanto]

Just an update:

We are now running Sugar on Apache, and have managed to get items to show up when input through Sugar. So if we create a contact or an account, they will show up on a list of all accounts, etc. Search now too, also works.

Alas, we are still having issues with the import functionality. We are attempting to import a client list CSV into Accounts. I'll attempt to tweak our CSV and will report on any success/failures we encounter.

If anyone has any helpful insights, please share!

Thank you,

Jason

[userz]

jsanto,

did you ever get your lists to show your contacts from import or earlier version of Sugar?

I'm having the same problem.....

Z

[andopes]

Hi, jsanto.

Have you installed the phpmyadmin?
Can you make sure the new contact or account has been inserted into database?

This question is to guide you.

Cheers

--
André Lopes
Lâmpada Global Services
Rua Bela Cintra, 299 conjunto. 51
São Paulo, SP 01415-000
tel1. 55 11 3237-3110
cel. 55 11 7636-5859
e-mail: info@lampadacrm.com.br

[shamaho]

I had the same import problem with the 5.0 GA and and I think I know what happened

I went to check directly into the database and all the imported accounts had been registered as deleted (i.e. column DELETE = 1 in teh table.

As soon as I updated table data directly (DELETED = 0) the accounts appeared in the web front-end.

What I guess ehat happened is:

1. I imported the accoutns -> They showed up
2. I did a mass update to assign the imported records to another user - I did it's thing
3. I selected two records to delete them (duplicates)
4. All records disappeared

So I suspect that between a mass update where I selected all records and the next operation the system somehow did not update or reset the selection status, so Kept all records still selected. So when I deleted the two isolated records, the system ended up deleting everyhting...