It works!!
Ah, thanks a lot....
I guess Account is the default but does not work if we do not use account? Although the code looks like "organisation" is the problematic parameter.
Announcement
Collapse
No announcement yet.
"Leads" list page does not show list: bad server response
Collapse
X
-
Originally posted by tanya View PostYes, thanks.
Administration > Entity Manager > Lead > Edit - what is in Default Order (field)?
(by the way we do not use Account)
Leave a comment:
-
Yes, thanks.
Administration > Entity Manager > Lead > Edit - what is in Default Order (field)?
also you can check custom/Espo/Custom/Resources/metadata/entityDefs/Lead.json > collection > sortBy
Leave a comment:
-
OK our IT guy could collect the following information:
(just as a reminder: although Leads exist in the database, the Leads page returns empty and shows "bad server response")
The requested url from the leads page looks like:
Code:_/api/v1/Lead?[COLOR=#f79232]maxSize=50&offset=0[/COLOR]&[COLOR=#d04437]sortBy[/COLOR]=organisation&[COLOR=#14892c]asc=false[/COLOR]_
Code:_WHERE lead.deleted = '0' [COLOR=#FF0000][B]ORDER BY[/B][/COLOR] [COLOR=#14892c][B]DESC[/B][/COLOR] [COLOR=#f79232]LIMIT[/COLOR] [COLOR=#f79232]0, 50[/COLOR];_
Code:[I]WHERE lead.deleted = '0' ORDER BY [B]organisation[/B] DESC LIMIT 0, 50;[/I]
Does that help? It seems a word is not transferred properly from the URL to the SQL How could we fix this?
Leave a comment:
-
Thanks, will check our IT guys.
Will that increase the logging also in the browser console or only on the server side logs?
Leave a comment:
-
add here (in your files) https://github.com/espocrm/espocrm/b.../Base.php#L255 the code
if ($entityType == "Lead") $GLOBALS['log']->error($sql);
Leave a comment:
-
As far as I know, from the beginning. Leads were not used so far; I started to test them and added them to the UI. Accessing one specific Lead works (for example from my activity stream, where it tells me I created a Lead).
Leave a comment:
-
Thanks,
Yes, list view other entities work.
Reset gives the same error / javascript console message.
Leave a comment:
-
If list view of other entities works, press Reset button on the Leads Search panel
Leave a comment:
-
Thanks, we will (I need our IT guys to do it).
It seems my image above was not posted. The browser console says:
Server side error 200: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DESC LIMIT 0, 50' at line 3
Leave a comment:
-
"Leads" list page does not show list: bad server response
Hi,
New user to EspoCRM, and new to forum,
I have created at least one Lead, but the Leads overview page does not work. "Bad Server Response":
Thank you for any hint or suggestion in trying to resolve this,
Kind regards,
Olivier.
Tags: None
Leave a comment: