MySQL error 1054: Unknown column 'user' HELP!

[tj@estreet.com]

Hey All,

I am SO STUMPED!
After Some updates today (principly to enable Assigned To: field and Only My Items filter in ProspectLists/ListView)
I began getting MySQL error 1054: Unknown column 'user' having CLICKED the Select Button for the Target List Subpanel in
Campaigns/DetailView AND THEN CLICKING on the Column Sort Heading for Newly Functional PROSPECT_LIST.ASSIGNED_USER_NAME
(was {PROSPECT_LIST.ASSIGNED_TO_NAME}) in ProspectLists/Popup_picker.html
( also assigned_user_name was added to vardefs)

Logged Out/In as Different User, Different campaign, Select Target Lists, Sort By Assigned To: column
AND UP JUMPS THE EROR

Error retrieving ProspectList list: Query Failed:SELECT users.user_name as assigned_user_name, prospect_lists.* FROM prospect_lists LEFT JOIN users ON prospect_lists.assigned_user_id=users.id AND users.deleted = 0 where prospect_lists.deleted=0 ORDER BY user asc LIMIT 0,50::MySQL error 1054: Unknown column 'user' in 'order clause'

I have rolled back all updates, but the error persists.
I have rolled back the entire moduels folder AND STILLL the error persists in the ProsepctLists Popup,
which no longer loads the list at all -- only the error -- for a USER who has attempted to sort by User in Popup.
It is User Specifiec (Only affects Users who have tried to sort)
AND whatever caused it, I haven't been able to trace but can rule out with some certainty that whaterver caused it is
no longer in the code ... so why does this error persist.

Something lodged in some CACHE, Cookie.... or User Settiongs? How Do I Make this go away????

[ruchida]

Hi

What about executing "Reset To Default Preferences" in My Account?
Please note that all of preferences are reset.

[tj@estreet.com]

Thanks Ruchida,

I should have mentioned I am working OS 4.01f and as of this build there doesn't seem to be any
"Reset To Default Preferences" in My Account, though if there WERE, well... just the thought of
such a function makes me break out in a cold sweat!

Anyway, it finally dawned on me that I have been down a path similar to this in months past.
There is an Order By clause stuck in the users cache (don't think that's right but you get the idea)
and the only remedy I have been able to find for it (now that I remember) is to select a different
sort Order By -- which is kinda hard to do when the page won't load.

The solution? Find the QUERY/CODE with the Order By (in this case ProspectLists.php)
and switch if($order_by == "") for if($order_by != "") ,
Then reload the broken page -- for each user sadly --- and change the Sort Order to another field that
you know works. Then switch back to if($order_by != "") ,

The problem here, was that the ASSIGNED_USER_NAME column in Popup_picker.html WAS SET INSTEAD
to ASSIGNED_TO, and the Popup_picker order by link was set to <a href="{ORDER_BY}user"
when it should have been <a href="{ORDER_BY}assigned_user_id"

That said, I'd still like to know where and how that user data is stored (thought it was in tracker but not)

Now if I could just get the Only My Items fiilter to work in the popup_query_form !
Anyone???