405 error afther update

[florren]

Using EspoCrm for few months, working verry wel

Now afther update from 504 to 505 got a error:

logged in as admin
creating a new contact (or anything else) going fine

Editing a contact (or anything else) gives a 405 error
On both cases: using "update" in quick edit or using "save" in form

This was working on our server (ht acces file workaround ok)

Got some errors in my log file (see below)

Can any one point me in the good direction?




log:

like this:
[2018-03-05 10:11:32] Espo.ERROR: Display Error: {"reason":"Duplicate","data":..................... ........................

[2018-03-05 11:48:23] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'portugal_espo800.portal' doesn't exist" at ***********/application/Espo/ORM/DB/Mapper.php line 114 {"exception":"[object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'portugal_espo800.portal' doesn't exist at /*************************/application/Espo/ORM/DB/Mapper.php:114)"} []

[tanya]

The text of topic tells that Patch method is disabled. https://forum.espocrm.com/forum/general/2359-error-405 https://stackoverflow.com/questions/...-403-forbidden
Log file
1) duplicate of some record.
2) no table. Tables don't lose. Could you Rebuild EspoCRM in Administration?

[florren]

Thanks for the reply

Think I already checked that. It was working before for months (dide also the htacces patch to work then)

Tried a clean instal, dide the Patch and no luck, running php 5.6

Dide a rebuild in admin, no luck also.....(see log file below)

Any more tips?

htaccess file in my espocrm directory looks like this:


<ifModule mod_headers.c>
Header always set Access-Control-Allow-Methods "POST, GET, PUT, PATCH, DELETE"
</ifModule>

DirectoryIndex index.php index.html

<IfModule mod_rewrite.c>
RewriteEngine On

# PROTECTED DIRECTORIES
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^/?(data|api)/ - [F]

RewriteRule ^/?data/config\.php$ - [F]
RewriteRule ^/?data/logs/ - [F]
RewriteRule ^/?data/cache/ - [F]
RewriteRule ^/?data/upload/ - [F]
RewriteRule ^/?data/\.backup/ - [F]
RewriteRule ^/?application/ - [F]
RewriteRule ^/?custom/ - [F]
RewriteRule ^/?vendor/ - [F]
#END PROTECTED DIRECTORIES

RewriteRule .* - [E=HTTP_ESPO_CGI_AUTH:%{HTTP:Authorization}]

RewriteRule reset/?$ reset.html [QSA,L]
</IfModule>

<Limit GET POST PUT DELETE HEAD OPTIONS PATCH>
Order allow,deny
Allow from all
</Limit>


log file:

[2018-03-06 08:04:14] Espo.DEBUG: Schema\Converter - Start: building schema [] []
[2018-03-06 08:04:14] Espo.DEBUG: DBAL: Table [entity_team] exists. [] []
[2018-03-06 08:04:14] Espo.DEBUG: Schema\Converter - End: building schema [] []
[2018-03-06 08:23:01] Espo.INFO: CronManager: Stop cron running, too frequent execution. [] []

[tanya]

In the log you have no error...
Clean install also doesn't allow you to edit records?

[florren]

just checked it again... dide a clean install on domain, dide the Patch

no luck

can create but not edit

no new data in espo logs......
only: Espo.INFO: CronManager: Stop cron running, too frequent execution. [] []

dide clear chache and rebuild but no luck.

running espo in www.mydomain.com/espodir

dide a instal of WPress in www.mydomain.com

But can not think of any problem giving that?

[tanya]

check apache error log, if you have no logs in espocrm log

[florren]

ok... some problem I think there:
[Tue Mar 06 09:56:14.241075 2018] [allowmethods:error] [pid 8357:tid 139951509337856] [client 78.137.205.175:64979] AH01623: client method denied by server configuration: 'PATCH' to /home/*******/domains/***************/public_html/*************/api/v1/Contact, referer: http://**********.com/******/index.php Should I allow Patch some where else then in my htaccess file in my espo directory?

[tanya]

Did you restart apache after modification?