Main Menu has gone down in backend

General questions relating to Joomla! There are other boards for more specific help on Joomla! features and extensions.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
noodlehead
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Sun Feb 26, 2006 12:34 am

Main Menu has gone down in backend

Post by noodlehead » Wed Jun 06, 2007 4:38 am

While the menu still works when published I am unable to access or edit. Joomla gives me the following:

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/apache/sites/gannettministries/htdocs/joomla/includes/database.php on line 289

Warning: Invalid argument supplied for foreach() in /home/apache/sites/gannettministries/htdocs/joomla/administrator/components/com_menus/admin.menus.php on line 167


None of the menu items show up on the screen.

Any thoughts?

 
noodlehead
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Sun Feb 26, 2006 12:34 am

Re: Main Menu has gone down in backend

Post by noodlehead » Wed Jun 06, 2007 3:29 pm

I did want to mention the menu appears in the front end still...
It is just when I go to edit the mainmenu to add links that I get the error

User avatar
nomsaumi
Joomla! Explorer
Joomla! Explorer
Posts: 289
Joined: Sat Apr 15, 2006 3:07 am
Location: Syracuse, NY

Re: Main Menu has gone down in backend

Post by nomsaumi » Wed Jun 06, 2007 6:58 pm

This may indicate database corruption - are you using phpMyAdmin? Perhaps you can run the database repair utility...

stilero
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Sat Jun 07, 2008 11:42 am
Location: Floda. Sweden
Contact:

Re: Main Menu has gone down in backend

Post by stilero » Sat Jun 07, 2008 11:53 am

I'm having the same problem on 2 different websites located on different servers.

The error occurs randomly on the frontend when you klick a menulink. Both websites are 1.5.3 installations, and one of them has no third party extensions installed yet. When the problem first started, one of the sites were 1.5.2, so i upgraded to 1.5.3 and still got the error.

The following error shows up when you've clicked the frontend mainmenu-links about 10-20 times:

Warning: mysql_query() [function.mysql-query]: Unable to save result set in ***/public_html/libraries/joomla/database/database/mysql.php on line 221

Warning: Invalid argument supplied for foreach() in ***/public_html/components/com_content/models/section.php on line 352

I've tried the repair function in phpmyadmin, but still get the error.
Note that I have caching disabled for both sites.

djb
Joomla! Apprentice
Joomla! Apprentice
Posts: 16
Joined: Thu Nov 23, 2006 1:00 pm
Location: Farnham, Surrey, England

Re: Main Menu has gone down in backend

Post by djb » Mon Sep 08, 2008 2:14 pm

Did you have any luck fixing this? I'm getting the same error code and am all out of ideas trying to fix it.

http://forum.joomla.org/viewtopic.php?f=471&t=322465

500fans
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Fri Dec 14, 2007 3:01 pm

Re: Main Menu has gone down in backend

Post by 500fans » Sat Nov 29, 2008 7:47 pm

Hi,

I had the same problem, the main menu items wasn't accessible via backend but fully working in frontend.

I fixed it by accessing the menu via the Joomla Back-end Control panel -> Menu Stats. From there I copied all items into a newly created menu.

Hope that helps. I don't now how to solve the underlying bug though...

Cheers,
Fredrik

dilipray
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Sun Sep 19, 2010 11:51 am

Re: Main Menu has gone down in backend

Post by dilipray » Mon Jun 06, 2011 11:05 am

Repair All your Tables from PhpMyAdmin

 

Locked

Return to “General Questions - 1.0.x”