I’ve written a dynamic query which is finally executed via EXECUTE my_dynamic_query; The query contained a select list in which two columns should always be NULL. — … stuff before dynamic_select_cols := ‘tbl1.foo, tbl1.bar, null AS theAlias1, null AS theAlias2, tbl2.foo2′; — … stuff after combining the dynamic queries EXECUTE my_dynamic_query; In my case the [...]
One of my development systems is running on Debian Lenny (no this one does not host SharePoint). After update the system via apt-get update something went wrong and “core services” (samba, ssh) were out of order. It seems this is a bug in the packages provided by Debian. After struggling for a while a simple [...]
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 [...]
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. [...]
Today the crawler of the search service of my MOSS-Development system stopped working from “one second to another”. The crawl-log showed me this error. The crawler could not communicate with the server. Check that the server is available and that the firewall access is configured correctly.. The start is essential I reconfigured everything, I checked [...]