Contact Errors with 4.5 Beta

[cdavidson]

Just installed Version 4.5.0RC (Build 1050) and imported about 720 records from an export from Salesforce.com.

I only got about 492, which is strange since there are only about a dozen dups ( I scrubbed the data in the CSV file before importing). I was expecting to see a list of what failed on the import, since I read that was a feature in 4.5, but only see what was imported, not what wasn't and why.

That aside, I was happy to see my 492 contacts, until I clicked on one to look at the details. What I got was:

Error running count query for Contact List: Query Failed:SELECT count(*) c FROM contacts LEFT JOIN users ON contacts.assigned_user_id=users.id LEFT JOIN accounts_contacts ON contacts.id=accounts_contacts.contact_id LEFT JOIN accounts ON accounts_contacts.account_id=accounts.id where (users_last_import.assigned_user_id='1' AND users_last_import.bean_type='Contacts' and users_last_import.bean_id=contacts.id AND users_last_import.deleted=0) AND contacts.deleted=0 AND (accounts.deleted is NULL or accounts.deleted=0) ::MySQL error 1109: Unknown table 'users_last_import' in where clause

I've re-run the install and recreated the tables and re-imported with the same results. I didn't have this issue with version 4.2 and realize 4.5 is just Beta, but was wondering if somebody else has seen this.

Thanks!

[cdavidson]

Since I have a real-world deadline on this project and haven't seen any replies to my post, I de-installed 4.5 and fell back to 4.2.1

I went to 4.5 because I have numerous issues with imports, including the fact that it totally ignores the Assigned To, Last Modified by ID, and Created By values during my import, instead assigned "admin" (that's me) to both the modified by and created by fields.

The import process only shows what has been imported, not what hasn't. If you're importing 500 records and 495 get imported, you'd want to see the five that DIDN'T so you can address that problem, NOT the 495 that worked. Leaving you to figure out which few didn't import is just silly - the process should show the failures, not the successes!

[chrisky]

This identical problem described is my latest issue at hand.
I can shed a little more light on it at the moment though I've just begun working on this.

If you pay attention to the link that is being opened, i.e.
https://xxxx.xxx/crm45/index.php?act...24841664858100

Well, I've noticed that IF I remove EITHER the &offset or &stamp variables from the link that sugar will load the detailview without a problem. I do not know exactly what those represent or do and will figure that out soon enough, but that said my first 'quick fix' thought is locating the code responsible for creating that link and remove one or both of those variables, the stamp or offset portion of that link code.

I'm working on this myself and in my forum search for a solution I saw your post and thought I'd share some more info and a pre-mature solution.

P.S. What led me to discover this was the fact that the 'view' icons DID work and opened the detailview. There are two view icons from the list view, with one being in the additional details popup box and the other at the very right of that list view item. I mention this to make the point that apparently the stamp or offset variables are not neccessary as these view icons do not use them, but I'm definately curious as to what they do or represent.

[chrisky]

I've spent some time on this and am quitting with more important problems to focus on.
What I ended up finally doing is just removing the stamp variable from the link. The stamp variable represents what number down in the listview that record is. I.e. if you have a listview that has 20 records displayed and you click on the 5th record, the stamp would be &stamp=5.

This isn't too important or necessary and thus my decission to stop wasting time on this and just remove the &stamp portion of the link code which can be found in the ListViewGeneric.tpl file and the ListView.html files.

Before editing any files, be sure to make a backup copy first!

This problem also presents itself on non-imported records, though from other modules the &stamp doesn't present this problem. In my case I was working from the leads module, and had previously imported records into that modem. Somehow this problem IS related to the import routines. Intestingly enough the SQL error returned is that the database table is unknown/doesn't exist; however, it most definately does. I also examined with detail the log files and all field names and table name have no misspellings or formatting errors that I can find.

Chris,

[khvitaliy]

This isn't too important or necessary and thus my decission to stop wasting time on this and just remove the &stamp portion of the link code which can be found in the ListViewGeneric.tpl file Liand the ListView.html files.

Chris,

Thanks for advise, I'm new to sugar, where can I find ListViewGeneric.tpl file, Thanks for help, Vitaliy