Espo.ERROR

[x3t9fi]

Hi

I did not use my system some weeks - and after i would try to login today - the login windows was showing - typed in my creds and endet with a white screen - after deleting browser and espo cache i get the following message in my log:

[2018-09-13 14:33:36] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM `auth_token` LIMIT 0, 1' at line 1" at ...application/Espo/ORM/DB/Mapper.php line 115 {"exception":"[object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM `auth_token` LIMIT 0, 1' at line 1 at .../application/Espo/ORM/DB/Mapper.php:115)"} []

I dont have any idea what the problem is - because i did not change anything at the whole system in the past 4 weeks. Any ideas?

[tanya]

Hello,
at first try to execute in CLI
php rebuild.php under web server user (sudo -u www-data php rebuild.php).

[x3t9fi]

Hi Tanya

Thank you for your answer - tried it but without any results. I just get a white page with a short AUTH ERROR message which after 1-2 seconds disappear.

[tanya]

Do you have auth_token table in database? Check also server log

[x3t9fi]

Hi tanya

Thank you for your help - i will check this - Server log you can see in my first post. or do you need more?

EDIT: Yes the table is there - see the attachment

[x3t9fi]

Browser says:
Failed to load resource: the server responded with a status of 401 (Unauthorized) /api/v1/Settings:1
Failed to load resource: the server responded with a status of 401 (Unauthorized) /api/v1/I18n:1

[x3t9fi]

as additional information: the version is 4.7.2 - same errors on php5.6 and 7.1.

[tanya]

https://github.com/espocrm/espocrm/blob/master/application/Espo/ORM/DB/Query/Base.php#L263

on this place add $GLOBALS['log']->error($sql);
run EspoCRM again
check {espo_dir}/data/logs/espo-{today}.log
attach this file, please.