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 →
Latest Posts Under: SQL Server
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 →
Below you will find a select that will help you check the state of all your publication on SQL server in order to know if all the subscribers are in synch or the syncronization agent has stopped running. SELECT (CASE WHEN mdh.runstatus = ‘1’ THEN ‘Start – ‘+cast(mdh.runstatus as varchar) WHEN mdh.runstatus = ‘2’ THEN… Read Article →
Recently I changed the name of my SQL Server computer from the generic one given by the Windows installation to ‘SERVER’. In the beggining there was no apparent problem in the connections since I used IP addresses. After a while I wanted to use Replication and tried to create an SQL Server Publication only to… 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 →
Here is a quick and easy way to alter the schema of any of the objects in your sql server that has been created with any other user than the dbo. This has been giving me troubles when using TSQL and has been difficult to change it using the sql managment studio. SELECT ‘ALTER SCHEMA… Read Article →
Many times in many projects I had to filter some records in a list by selecting not one but multiple categories. This has been a nightmare to be done in a stored procedure since you had to have a limited numbers of parameters and it would be inefficient to have @category1, @category2, etc. What you… Read Article →
Ever had a table in SQL Server with hundreds of locations with their longitude, latitude and wanted to retrieve only top 10 which are nearest to you or those that are within couple of Kilometers away? To do so in SQL Server 2005 you needed to convert long,lat into Radians and then make a large… Read Article →
Ever wanted to get the current time and date from the SQL Server to avoid different times between yous server and the clients (for example having a centralized application running on many countries) ? Using LINQ to SQL there is no way to get the time from the database build in the class. What you… Read Article →