Object reference not set to an instance of an object. in Des

Posted by Community Admin on 26-Apr-2011 00:00

Hi
As we have encountred a serious problem with our pages ( pages showing old widgets that ahev been deleted before)
I had to redo ALL PAGES with no template !! waiting the bug fix.

I 've worked all the weekend to complete them, and now I wanted to add new template to be able to test my pages : Big surprise : I can't and I get the message : Object reference not set to an instance of an object.

I have checked in the table sf_Page_Template and all my templates are there.

I am suspecting this is because of the culture since all my new pages are in FR-CA, but I tried to change the both languages (frontend end and backend to ENG-US, FR , FR-CA) with no luck.

1- Any idea How this could be fixed,
2- Is there a way to create new clean project and copy all my pages and content to the new project, I can afford redo the template but not the pages (180 pages).

Posted by Community Admin on 27-Apr-2011 00:00

HI JP, are you using custom master page? i had this issue too before. here's my fix

add runat="server" in head tag

<head runat="server">

secondly add form and script manager inside the body

<body>

<form id="form1" runat="server">

<asp:ScriptManager ID="ScriptManager1" runat="server">

</asp:ScriptManager>

.....

</form>

</body>

hopefully this can can help and maybe someone from telerik can explain more?

Posted by Community Admin on 27-Apr-2011 00:00

Hello JP,

My colleague Sonya Panayotova answered you in the support ticket you have opened. If there are further questions we can keep the discussion in the support thread.

Regards,
Victor Velev
the Telerik team

Posted by Community Admin on 27-Apr-2011 00:00

Any chance of finding out what the solution provided in the support ticket was/is or if it worked. i just upgraded from 4.0 to 4.1 and running into what I think is the same thing.

I cant even get a return of the templates that have been created or an option to create a new template. I just get "Object reference not set to an instance of an object." when i click on Page Templates.

Thanks.

Anthony

Posted by Community Admin on 27-Apr-2011 00:00

We experienced the exact same issue. This morning, we started getting the same error, (object reference not set to instance of an object), we were able to identify and correct what was causing it.

Login to the database and run this query:

SELECT *
FROM    dbo.sf_page_templates a
INNER JOIN dbo.sf_draft_pages b
ON      a.id = b.template_id
        AND b.is_temp_draft = 0
INNER JOIN dbo.sf_page_data c
ON      b.page_id = c.content_id
WHERE   NOT EXISTS ( SELECT 1
                     FROM   dbo.sf_page_node x
                     WHERE  x.content_id = c.content_id )

If you get any results, then you have the same issue we did.

Tom

Posted by Community Admin on 27-Apr-2011 00:00

I get one row returned using your Query.
Does this row need to be deleted or any other action taken? After running I am still getting the error.

Posted by Community Admin on 27-Apr-2011 00:00

OK,

Yes, you will need to delete it. The pages you delete will need to be recreated, so take note of what you delete.

You run this at you own risk. This is what we did to fix it, but make SURE you back up the database before you do this.

Run this SQL:

DELETE  a
FROM    dbo.sf_draft_pages a
WHERE   a.page_id IS NULL
        OR NOT EXISTS ( SELECT  1
                        FROM    dbo.sf_page_data x
                        WHERE   x.content_id = a.page_id )

then run this SQL:

SELECT  'DELETE FROM sf_draft_pages WHERE id = ''' + CAST(b.id AS VARCHAR(50)) + '',
        'DELETE FROM sf_page_data WHERE id = ''' + CAST(b.page_id AS VARCHAR(50)) + ''
FROM    dbo.sf_page_templates a
INNER JOIN dbo.sf_draft_pages b
ON      a.id = b.template_id
        AND b.is_temp_draft = 0
INNER JOIN dbo.sf_page_data c
ON      b.page_id = c.content_id
WHERE   NOT EXISTS ( SELECT 1
                     FROM   dbo.sf_page_node x
                     WHERE  x.content_id = c.content_id )

Copy the Delete statements generated from the second SQL and past it in another query window and run it.

That took care of it for us.

Posted by Community Admin on 27-Apr-2011 00:00

You sir, are an evil genius! Thank you very much for the help. Seems to have fixed my prob.

Anthony