logo
Welcome Guest! To enable all features please Login. New Registrations are disabled.

Notification

Icon
Error

Options
Go to last post Go to first unread
bart  
#1 Posted : Monday, September 10, 2012 10:22:25 AM(UTC)
bart

Rank: Administration

Reputation:

Groups: Administration
Joined: 10/8/2008(UTC)
Posts: 188
Man

Was thanked: 1 time(s) in 1 post(s)
Sometimes when you click "Content/menu" and then "Website:<sitenam>"
You will get an error, This is cause of a problem which exists a couple of years ago(2008), This problem is solved but it can still leave some wrong value in the menu table which causes an error.

You can solve this by running the following Query
Code:
Update c
set c.TaalId = p.TAALID
from <!!CID!!>_MENU c
Join <!!CID!!>_MENU p on c.Ouder=p.Id
where (c.TAALID = 0 or c.TAALID IS NULL)
And p.TAALID <>0 and p.TAALID IS NOT NULL

where "<!!CID!!>" should be replace as usual;)

It can happen you have to run this query 2 or 3 times until all is fixed(depending on how deep submenu's are going.), I could create a while in the query for this but I didn't you can do this if you like so.

The problem is the language Id for some items isn't set correctly.

But with this query it will be set the correct way.
bart attached the following image(s):
error.png

Wanna join the discussion?! Login to your Sienn Forum forum account. New Registrations are disabled.

Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.