A general problem that I recently encountered for the second time is an Umbraco site not being able to generate any page without displaying an error or timeout. After examining the log (umbracoLog table on SQL server) you will see the error below: Error Republishing: System.Xml.XmlException: ‘ ’, hexadecimal value 0x1F, is an invalid character. Line 1,… Read Article →
Posts Tagged: umbraco
Recently I had a problem with an Umbraco 4.7.1 installation that had became 10GB in SQL Server and had about 20000 published pages. Since there is no way to do something like this from the umbraco administration panel I had to create a T-SQL to clear the database. DECLARE @createdDate Datetime = ‘2012-03-01’ DELETE FROM… Read Article →
Updated thanks to jeffreypriebe — Uncomment below to verify the number of nodes returned is the same as the number of nodes that is in the Recycle Bin — SELECT * FROM umbracoNode WHERE path LIKE ‘%-20%’ AND id != -20 –Setup the temporary table CREATE TABLE #temp ([id] int); INSERT #temp select id from… Read Article →
Recently one of my sites that was created using umbraco has started to behave somewhat strange. There was nothing that seem to be wrong and all the errors produced were: No Document exists with Version ‘00000000-0000-0000-0000-000000000000’ As it turned out the problem was due to extreme delay in the SQL Server. What made me look… Read Article →
Recently I had problems with a site I have created using umbraco. The problem was that for some reason in the version control of the application there were many orphan versions that where visible on the cmsContentVersion table but not on the cmsDocument. You can find those using the query below: SELECT * FROM cmsContentVersion… Read Article →
If you have problems when using XSLTsearch extension for umbraco on version 4.6 installation the easiest way to resolve it is to simply complile the .cs file to a .dll using Visual Studio and then declare it as an xslt extension using the line below: <ext assembly=”XSLTsearch” type=”PS.XSLTsearch” alias=”PS.XSLTsearch” /> To make this even easier… Read Article →