Hi

I've installed J 3.7.0 on www.swanseainbloom.co.uk and now, when I change the access level on a menu item it is immediately trashed. Sometimes I'm able to re-publish them, sometimes not.

I was fiddling with it yesterday and suddenly all the menu items except the home page were trashed and I couldn't get them back, so I restored the site from a backup.

Has anyone any ideas on this?

Thanks

Ian

Hmm. If I try to empty more than one item at a time from the trash I get this error code:

1690 BIGINT UNSIGNED value is out of range in '(`swanseai_db`.`#__menu`.`level` - 1)'

Hi Ian,

Are you able to test your site locally?

Have you done the usual check for any database issues e.g. using the fix button

Hi Paul - thanks for getting back to me.

I'm afraid I still can't get this site to work locally.

And yes, I have fixed the database and checked for problems in ACL.

I was deleting old trashed menu items just now, when I lost all the items except home. I did a rebuild and some of them came back, while others have vanished completely. When I replace the missing menu items with new ones they seem to work OK.

When the site was in J 3.6.5 this problem was not apparent.

It feels like a database problem to me, but I'm totally out of my depth here...

Have you tried the rebuild button in the menu prior to changing the menu?

I'd suggest not touching the live site till you have it working locally

With the links are you logged in as a superuser?

No - I've not tried the rebuild button before changing the access level.

I clicked it after losing all items except home, and it brought some of them back. The others have disappeared entirely - not trashed or anywhere. I've been able to recreate them.

And yes - logged in as super user.

At the moment the menu items seem to be working OK, but there's probably something horrible lurking under the bonnet for later

I have got duplicate links in the footer - I never took your advice and created a proper menu.

Those links have all stopped working...

hmm

have you checked the database in the admin and that doesn't show any problems?

When you say the links don't work - produce an error, do nothing at all?

Have you checked the source code to see what is listed there?

They're giving me category not found.

I've not checked the source code.

How do I check database in admin?

Yes changing access level from guest > public > registered etc

Are you able to change the footer links and change the menu type?

You could use the alias link type to point to the main menu links

with the link access level can you give me a specific example?

If I test public to registered? - is that what you trying?

You advised me to use menu item aliases before, to avoid duplicate links. I do most of what you tell me

The links which no longer work are to menu items which have disappeared - that's why they're not working.

Not sure what you mean by change menu type...

Could the duplicate links have caused the problem?

Sorry Paul - it started when I tried to change guest to public and registered to public on the registration and entry forms.

After that I tried all sorts of things.

It seems to me it is specific menu items which gave me the problem.

The ones that were left and the replacements I have created seem to work fine.

I still get the error if I try to delete multiple trashed items.

Are you trying to make this happen locally?

yes and on live dev sites

It takes someone as stupid as me