vtiger

[academyofsocialarts]

Hi guys,

I have a BIG problem with the leads. The are added within the database but are NOT shown within the Leadslist.

So I have in the database x + 5 leads and in the list are just shown x leads.

I checked the leadids. the 5 additional leads have are something like 20 numbers higher then the leadids before.

Please need you help!

Thx

[pinaki]

Hi,


First try creating a new lead. It might happen that the five leads you are talking about are marked as deleted (deleted=0 in vtiger_crmentity table).

Otherwise the best guess that I can make from the information you have provided regarding this, is that the query to fetch the records in listview is failing. This might happen if some of the tables which are joined in the list query are not getting poplulated during save.

The best way to test will be this:

Go to mysql prompt and type this query:

select * from leaddetails;

This will fetch you all the leads in the database. Now try and get one lead which is not getting displayed is listview and note it's ID (say leadid=150). Now login to vtiger and type the following path in your browser:

<vtiger>/index.php?action=DetailView&module=Leads&record=????

where
<vtiger> is the path of your vtiger installation (like http://localhost/vtiger), and

???? is the leadid (like 150)

Check if the record is being displayed properly in the DetailView. If yes then the query is failing in listview and you will need to debug more.

Feel free to contact me with the information you have after debugging for any assistance. If possible also track down any changes you made in the code of late.

Thanks
Pinaki
vTiger Team

[tracker]

Weel, as I can see there are two of us with the same problem. I tried with the solution "pinaki" showed us and the screen result was:

Record you are trying to access is not found. Go Back.

Which by the way is the same message I said in my recent post.

In the other hand, How do I start debuging?

Regards,

Gabriel

[alioop]

I have the same problem: the same error message when I try to add a lead through the UI, and displays 9 count in dashboard for leads.

When I select leaddetails, there are no records. I just installed vtiger today. I made no changes to the code.

I did try to import lead data, and it said it was sucessful, but no leads. How do I clean up the dashboard display, and how do I get lead data into vtiger?

Thanks!