The Joomla! Forum ™



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.



Post new topic Reply to topic  [ 3 posts ] 
Author Message
PostPosted: Sun Mar 25, 2012 7:33 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sun Mar 25, 2012 7:20 pm
Posts: 2
Good Day, on an old site that I have, Joomla 1.0.... My admin menu on the backend has disappeared and I am trying to get it back and working.

I have came accross this thread viewtopic.php?f=472&t=517284&p=2145097#p2145097 which I believe is the closest thing I could find in regards to getting it back. My Admin Menus where not there so I tried the suggested sql code and ran it. However when I follow these steps I receive the following error:

Error

SQL query:

INSERTINTO`jos_modules`
VALUES (

'','Admin Menu','', 1,'menu', 0,'0000-00-00 00:00:00', 1, 'mod_menu', 0, 2, 1,'', 0, 1,''
)

MySQL said:
#1136 - Column count doesn't match value count at row 1


Is there anything I can do to get my admin Menu back?


Top
 Profile  
 
PostPosted: Sun Mar 25, 2012 8:53 pm 
User avatar
Joomla! Master
Joomla! Master

Joined: Thu Aug 18, 2005 8:55 pm
Posts: 19645
Location: Nijmegen, The Netherlands
You referred to a Joomla 1.5 solution. However, the table structure (amount of fields) of Joomla 1.5 is different from Joomla 1.0.

The easiest to do:
with phpMyAdmin, goto your jos_modules table,
select "insert" and use the fields from your SQL statement as values.

Better: create a local webenvironment (eg with XAMPP), install Joomla 1.0,
use phpMyAdmin to export the jos_modules table,
and copy the line for the "Admin Menu" record,
and run that SQL statement in the database of your 1.0 website.

Note: back-up your website's database before doing so...

_________________
Kind Regards,
Peter Martin, Global Moderator - Community Leadership Team
http://www.db8.nl - Joomla specialist, Nijmegen, Nederland
Joomla 2.5 multilanguage in 10 steps: http://www.db8.nl/en/joomla-presentatio ... ge-website


Top
 Profile  
 
PostPosted: Mon Mar 26, 2012 12:27 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sun Mar 25, 2012 7:20 pm
Posts: 2
Thanks so much. I'll give it a whirl.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 



Who is online

Users browsing this forum: No registered users and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group