Query Error in Lead List

[wesmon]

I've searched the forums and several other people are having the same problem. None of those threads have been helped.

If go to the lead list screen, sort the list by NAME, click on a name, we get the following error:

Error retrieving Lead list: Query Failed:SELECT leads.*, users.user_name assigned_user_name FROM leads LEFT JOIN users ON leads.assigned_user_id=users.id where leads.deleted=0 ORDER BY name ASC LIMIT 0,1::MySQL error 1054: Unknown column 'name' in 'order clause'

If I sort the list by something other than Name, I can click on a name without a problem.

This happened with 4.5.1 and with 4.5.1b

I just upgraded to 4.5.1b in hopes that it would cure the problem. It did not.

Sugar Open Source 4.5.1b
MySql 4.1.21-standard-log
PHP 5.0.5

HELP!

thanks
Wes

[jnassi]

I've searched the forums and several other people are having the same problem. None of those threads have been helped.

If go to the lead list screen, sort the list by NAME, click on a name, we get the following error:

Error retrieving Lead list: Query Failed:SELECT leads.*, users.user_name assigned_user_name FROM leads LEFT JOIN users ON leads.assigned_user_id=users.id where leads.deleted=0 ORDER BY name ASC LIMIT 0,1::MySQL error 1054: Unknown column 'name' in 'order clause'

If I sort the list by something other than Name, I can click on a name without a problem.

This happened with 4.5.1 and with 4.5.1b

I just upgraded to 4.5.1b in hopes that it would cure the problem. It did not.

Sugar Open Source 4.5.1b
MySql 4.1.21-standard-log
PHP 5.0.5

HELP!

thanks
Wes

Wes,

Try doing a "Reset to Default Preferences" within the My Account screen, see if that clears up the problem. With a fresh install of Sugar 4.5.1b, the query is built correctly.

[wesmon]

Jason,

I just tried that and it did not work. Logged in as admin, My Account, clicked Reset to Default Preferences. Got logged out, logged back in, set time zone.

Still didn't work. Strange thing is that this is happening on two of my installs for ALL users. Both are 4.5.1b. This was happening to both even with 4.5.1

They are both hosted at the same place. The other commonality is that to get the lead list, I performed an "import" from a tab delimtted file.

Here's another thing I noticed: once I click on the name and receive the error, the lead name shows up on the left as Last Viewed. Of course, if I click the lead name there, it comes up just fine.

With that clue, which module do you think is creating the problem? (I'm a programmer, but not too familiar with PHP and the structure of the system, so if you point me in the right module, I can try and debug it).

thanks
Wes

[wesmon]

Does anyone have any other ideas? Can I try coding around this?

thanks
Wes

[martin.huber@canoo.com]

Just to increase the weight on this issue: we have it too.

We are using Version 4.5.1d (Build 1273) .

Cheers,
Martin

[pblag]

Hi Wes!

Please post your vardefs.php file from modules/Leads/ folder so we may better help you.

[mrships]

I have the same problem in 4.1.5d.

I also did an import of leads.

In the chance it may help I'm posting vardefs.php file from modules/Leads/ folder as Petro Blagodir suggested...

Regards,
Chip

[pblag]

Hi All!

Unfortunately i can say that vardefs.php is good.

Probably you installed some patches or modules.

Please let us know if so.

[kbrill]

Post your

modules/Leads/metadata/listviewdefs.php
and
custom/modules/Leads/metadata/listviewdefs.php if it exists.

[tdmalone]

We have exactly the same problem too. But leads were not imported, they have all been entered by hand, so we may be able to rule that out as the cause.

To give a bit more information, after doing another re-ordering of the list, the link from the previous re-order starts working.

Example:
- I sort leads by name, and click on a name. It takes me to this link: /index.php?action=DetailView&module=Leads&record=f1 2c225d-bcc0-1774-10c4-466e1abeb109&offset=1&stamp=1181882296061427800
- That page shows the error
- I sort leads by name again, and click on the same name, it takes me to this link: /index.php?action=DetailView&module=Leads&record=f1 2c225d-bcc0-1774-10c4-466e1abeb109&offset=1&stamp=1181882356013053500
- That page also shows me the error
- I manually visit the link it took me to last time, and it now works

The only difference between those two links is the 'stamp' variable. It seems that each new sort generates a new stamp value, and the newest one doesn't work - yet all the older ones do.

I have attached /modules/Leads/metadata/listviewdefs.php. /custom/modules/Leads/metadata doesn't exist.