Account Records Not Displaying

[JustinGould]

On Sugar 6.0.3, SQL 2005, Windows 2003/IIS, I am having an issue where all of my Account records are not displaying. When I look at them, I see the first couple I entered into the system before making any customizations to the Accounts module. However, if I look in the Accounts table in the database, the information is indeed there.

Additionally, Sugar is acting as though it is stuck in an upgrade loop. When I go to the Upgrade Wizard, it is on the Commit Upgrade step. When I try to finish committing it, I get:

SQL Error : [Microsoft][SQL Server Native Client 10.0][SQL Server]
The index 'idx_category_name' is dependent on column 'name'.. 
[Microsoft][SQL Server Native Client 10.0][SQL Server]ALTER TABLE ALTER COLUMN name failed because one or more objects access this column..

We moved Sugar from one server to another and had some PHP/MSSQL issues (needed SQL 2008 native client), which we resolved.

A Quick Repair/Rebuild generates a SQL script to sync the database to VARDEFS, but the script won't run - same error as above. It seems the database schema and code are out of sync, like the code is at 6.0.3 but the DB is at 6.0GA or something.

I've attached the VARDEFS script that repair generated, along with a full diagnostics report. Any help would be greatly, greatly appreciated! I'm totally dead in the water here...

Justin

[JustinGould]

A couple other things:

• When I first logged in, the Account records I could see were ones I originally created myself when I built the system.
• I went into Admin and did a Reset User Preferences, and couldn't see ANY Account records any longer.
• I created a test Account record, and immediately was told that I did not have access to view the record I just created. I verified that I have ALL access on all modules. I had a second user test, same results.

[JustinGould]

Bump. I'm sorry to bump this, but I'm absolutely stumped and need help. At this point, I'd even do pay per incident support if it was an option...

We've looked at what Sugar is doing using SQL Profiler. It's requesting (and receiving) the top 21 account records, but not displaying them.

[davidboris]

Hello,

Try echoing your list view query, include/ListView/ListViewData.php, search for $main_query in function getListViewData and try executing that query in database.