Fixing TYPOlight-error #145 – Table ‘./tl_search’ is marked as crashed and should be repaired

Posted by Eric Bartels

Today a website of a customer running with TYPOlight stopped working. The friendly “there is an error”-message appeared. Even the administration-backend was not working anymore. Enabling the “display-error” setting revealed that there was a database-problem (perhaps due to a crash of mysql). #145 – Table ‘./tl_search’ is marked as crashed and should be repaired The [...]

Value too long error in PostgreSQL inside a plpgsql-function

Posted by Eric Bartels

In an application I am working on I recently found errors in the applications log file. Value too long for type character varying(64) Within a function (written with plpgsql) a dynamic query is built and executed via sql-EXECUTE. The error PostgreSQL gives me stated out that the error was in the line containing the EXECUTE-statement. [...]