The Joomla! Forum ™

Download

Demo


Board index » Joomla! 2.5 - Ask Support Questions Here » Migrating and Upgrading to Joomla! 2.5

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  Page 2 of 4
  [ 110 posts ]  Go to page Previous  1, 2, 3, 4  Next
  Print view Previous topic | Next topic 
Author Message
L3B3R
PostPosted: Fri Nov 04, 2011 5:59 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Fri Dec 03, 2010 11:49 pm
Posts: 3
After copying the info in the database and changing to the correct name and prefix I get this error:

#1062 - Duplicate entry '1' for key 1

I also tried the slbs.php but it says that "the problem was already solved." I rebuilt the menus but the error still occurs.
Top
 Profile  
 
Lieven Borms
PostPosted: Fri Nov 04, 2011 7:06 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Jul 01, 2011 11:08 am
Posts: 19
Location: Dendermonde
The “JTableMenu: _getNode” error occurs when there is a line missing. By executing the sql-query or the slbs.php file these line can’t be added to the database because it’s stil inside.
What you can do is delete the line with ‘id’ = 1 in the menu table and redo all the steps.

Kind regards
Top
 Profile  
 
rjscott2005
PostPosted: Fri Nov 11, 2011 3:03 pm 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Mon Aug 22, 2005 6:41 pm
Posts: 93
Location: Dallas, Georgia U.S.
Worked perfectly for me when I used your php file in the root.
Thanks!

_________________
RJ
Atlanta, Georgia, US
Top
 Profile  
 
solosan
PostPosted: Sun Dec 11, 2011 6:51 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Wed Nov 02, 2011 12:28 am
Posts: 3
Thanks so much for this. It was perfect.posting.php?mode=reply&f=625&t=632543&sid=817e90fbceb5de77849004928bb433e7#
Top
 Profile  
 
mojito
PostPosted: Thu Dec 15, 2011 4:57 pm 
User avatar
Joomla! Guru
Joomla! Guru

Joined: Wed Sep 07, 2005 10:18 pm
Posts: 600
Location: London
I am unable to rebuild the menu I get an error ! An so my site is down :( so any help appreciated.
The error is 'Failed rebuilding Menu Items list' I should just click on the rebuild menu button right ?
This is from a SP Upgrade site from J1.5 to 1.7 I have a lot of menus and not sure if I want at this stage to delete all of them and start again. I did step one ok and the id=1 record exists in table_menu the lft=0 and so does the rft=0, how can I work out what they should be manually as rebuild wont work...

This upgrade has been a long 2 weeks and still it seems I'm not there. :(

Thanks for any help out there.

_________________
Check out the 'bad toilet' online !
Top
 Profile  
 
mojito
PostPosted: Thu Dec 15, 2011 5:43 pm 
User avatar
Joomla! Guru
Joomla! Guru

Joined: Wed Sep 07, 2005 10:18 pm
Posts: 600
Location: London
I was making changes to the wrong database ! It does work well, thanks Lieven Borms..a great kudos for you.

_________________
Check out the 'bad toilet' online !
Top
 Profile  
 
nate-ivy
PostPosted: Fri Dec 16, 2011 11:30 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Fri Dec 16, 2011 10:51 pm
Posts: 1
Long live Lieven Borms! slbs.php saved the day!
Top
 Profile  
 
joomloo-000
PostPosted: Tue Dec 20, 2011 7:07 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Dec 20, 2011 4:38 am
Posts: 3
Can someone talk me through the 'root' folder?

I have downloaded the slbs.php but am not sure where to find the root folder for my site. This is the first time I have built a site (Joomla 1.7) and everything was going so well (a weeks work) until I tidied up the menu list and now I have the same problem. Have tried to find the root folder but can't locate it. I have C-Panel & PHPMy Admin, would someone mind taking me through the location of this in simple terms?
Top
 Profile  
 
mojito
PostPosted: Tue Dec 20, 2011 7:22 am 
User avatar
Joomla! Guru
Joomla! Guru

Joined: Wed Sep 07, 2005 10:18 pm
Posts: 600
Location: London
the root folder 'should' be evident from the following structure, you will see the following folders and more (just do a quick check that you haven't got some nested folders the same if so then you will need some cleaning time.)
administrator
cache
components...

Normally hosts lock your ftp access down into the root but you might find that the root is found by looking in a folder like 'public_html' so don't assumer that when you log into ftp using your ftp client that you will see the root.
Can we ask why you are visiting this thread - did you get the error listed in the posts above ?

_________________
Check out the 'bad toilet' online !
Top
 Profile  
 
joomloo-000
PostPosted: Tue Dec 20, 2011 7:27 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Dec 20, 2011 4:38 am
Posts: 3
Thank you was I was having a brain block, it has been a frustrating day - with a good end! Appreciate your file it worked perfectly! Here's to the Guru!!!! I'd buy you a beer if you were here CHEERS
Top
 Profile  
 
joomloo-000
PostPosted: Tue Dec 20, 2011 12:23 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Dec 20, 2011 4:38 am
Posts: 3
Yes I got the exact same error, but have now fixed it by downloading the slb.php file provided and uploaded that tp my public HTML folder.

Very useful. Menu is working again,
Cheers
Top
 Profile  
 
rw1
PostPosted: Tue Jan 03, 2012 5:35 am 
User avatar
Joomla! Guru
Joomla! Guru

Joined: Sun Aug 28, 2005 11:23 am
Posts: 958
Location: New York
Lieven Borms wrote:
Because some people are struggling with the phpMyAdmin part. I simplified the first part of the solution.
Below you can find the renewed solution.

To solve this problem please enter the following two steps.
1. Add the missing record to the database
Unzip the file ‘slbs.zip’ (attached to this post)
Copy the file ‘slbs.php’ to the root of your domain
Go to http://www.yourdomain.com/slbs.php (replace ‘yourdomain.com’ with your real domain)
Now you can remove the ‘slbs.php’ file from the root

2. Rebuilding menus
Go to the administrator panel of joomla.
Menus --> MenuManager
Select all menus
Click on the button ‘Rebuild’
(By doing step two, the field ‘rgt’ in the just added record (step one) will get the appropriate value.)

This worked! Incredible! Thank You Very Much!!!!!!!

Edit: On 1.7.0 too!
Top
 Profile  
 
c a g a t a y
PostPosted: Tue Jan 10, 2012 9:16 am 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Sat Jan 07, 2006 7:58 pm
Posts: 91
Location: Ankara / Turkiye
It says:

#1146 - Table 'ctlyst.ctlyst_menu' doesn't exist

There is 'ctlyst_menu' table in my "ctlyst" DB

any idea?

After step 2 (rebuild) I got this error from Wamp

Code:
( ! ) Fatal error: Call to undefined method MenusModelItem::getMessage() in D:\wamp\www\catalyst\administrator\components\com_menus\controllers\menus.php on line 95
Call Stack
#   Time   Memory   Function   Location
1   0.0015   705096   {main}( )   ..\index.php:0
2   0.1741   7480832   JAdministrator->dispatch( )   ..\index.php:47
3   0.1839   7990304   JComponentHelper::renderComponent( )   ..\application.php:153
4   0.1970   8081848   require_once( 'D:\wamp\www\catalyst\administrator\components\com_menus\menus.php' )   ..\helper.php:156
5   0.2065   8555656   JController->execute( )   ..\menus.php:23
6   0.2065   8555736   MenusControllerMenus->rebuild( )   ..\controller.php:684
Top
 Profile  
 
c a g a t a y
PostPosted: Tue Jan 10, 2012 9:24 am 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Sat Jan 07, 2006 7:58 pm
Posts: 91
Location: Ankara / Turkiye
Lieven Borms wrote:
Because some people are struggling with the phpMyAdmin part. I simplified the first part of the solution.
Below you can find the renewed solution.

To solve this problem please enter the following two steps.
1. Add the missing record to the database
Unzip the file ‘slbs.zip’ (attached to this post)
Copy the file ‘slbs.php’ to the root of your domain
Go to http://www.yourdomain.com/slbs.php (replace ‘yourdomain.com’ with your real domain)
Now you can remove the ‘slbs.php’ file from the root

2. Rebuilding menus
Go to the administrator panel of joomla.
Menus --> MenuManager
Select all menus
Click on the button ‘Rebuild’
(By doing step two, the field ‘rgt’ in the just added record (step one) will get the appropriate value.)



Heyyoooo
It worked now...Thanks a lot Lieven Borms for your great job (it is great for me :))
Top
 Profile  
 
tasteofkush
PostPosted: Mon Jan 23, 2012 3:56 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Jan 04, 2012 7:25 am
Posts: 12
I have a clean install of Joomla 1.7.3 with JomSocial 2.2.2 and jReviews 2.3.15.209. Nothing in this project has worked correctly. If it's not a Joomla issue, it's jQuery issue or jReviews problem. I have yet to setup a single module, create a menu item or category without running into glitchy issues.

So....I find a new problem. I go into "Menu Manager" and create a new menu called "Hidden". The purpose for this is to add menu items and attach them to categories to make the URL string a bit more nice looking. Instead of random strings like, "......./blah/blah/los-angeles-county_c84/" it would, instead, show as, "/California/Los Angeles/"

I've attached an example of the error the shows. I've read a bunch of solutions, but they don't seem to apply to this exactly. Let me know if you have any ideas. Thanks.


You do not have the required permissions to view the files attached to this post.

Top
 Profile  
 
tokenring
PostPosted: Sun Jan 29, 2012 3:45 pm 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Sun Mar 22, 2009 11:42 pm
Posts: 203
I had same problem with more symptoms. You can see my thread HERE / 692049. Anyway, I did the following trick and I am now able to add items, move menus, rebuild and so on. I really appreciate it! Great thread. This is why Joomla ROCKS!

TokenRing
Top
 Profile  
 
grixis
PostPosted: Tue Jan 31, 2012 8:04 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Jan 31, 2012 8:00 pm
Posts: 1
Lieven Borms wrote:
Because some people are struggling with the phpMyAdmin part. I simplified the first part of the solution.
Below you can find the renewed solution.

To solve this problem please enter the following two steps.
1. Add the missing record to the database
Unzip the file ‘slbs.zip’ (attached to this post)
Copy the file ‘slbs.php’ to the root of your domain
Go to www.yourdomain.com/slbs.php (replace ‘yourdomain.com’ with your real domain)
Now you can remove the ‘slbs.php’ file from the root

2. Rebuilding menus
Go to the administrator panel of joomla.
Menus --> MenuManager
Select all menus
Click on the button ‘Rebuild’
(By doing step two, the field ‘rgt’ in the just added record (step one) will get the appropriate value.)

Thx!!!! I <3 u))))
Top
 Profile  
 
nononcents
PostPosted: Fri Feb 03, 2012 2:53 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Dec 12, 2007 10:13 am
Posts: 9
Worked for me as well! THANK YOU, THANK YOU, THANK YOU, Lieven. I think you deserve a promotion from apprentice.

My Situation. Joomla 2.5.0 Yoo Enterprise theme. Used jupgrade and it worked OK but menus weren't quite right. I think what had happened was it had created a "Main" menu which was ID1. I already had a Main menu so I had duplicate menu names. I deleted it as MY "Main" menu had my menu structure. And problems began. Lieven's solution fixed it. :laugh: :laugh: :laugh:
Top
 Profile  
 
didier L
PostPosted: Wed Feb 15, 2012 11:15 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sun Dec 30, 2007 2:49 pm
Posts: 12
Location: Near Paris in France
Thanks a lot

I met this problem using Jupgrade ... And your solutions works !

A webmaster from France, near Paris

_________________
Didier L
Top
 Profile  
 
Hille
PostPosted: Mon Feb 27, 2012 1:33 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Jan 25, 2012 7:32 am
Posts: 5
Sweet man. Thanks for the script!
Top
 Profile  
 
Tophe
PostPosted: Sat Mar 03, 2012 11:35 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Tue Aug 23, 2005 6:00 am
Posts: 10
Thank you Lieven,
Your solution fixed the issue for me in a J-2.5.1 migration using "SP Upgrade". :)

I hope you win a lottery.
ChrisTopher
Top
 Profile  
 
pepecortez
PostPosted: Mon Mar 05, 2012 11:13 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Wed Sep 23, 2009 7:39 pm
Posts: 1
Thanks, worked great on J2.5.1 as well.
Top
 Profile  
 
timchap2
PostPosted: Thu Mar 08, 2012 12:23 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Wed Sep 12, 2007 7:00 pm
Posts: 4
Thank you! Worked on Joomla 2.5.2 update from Installatron.
Top
 Profile  
 
dimi2011
PostPosted: Tue Mar 13, 2012 12:52 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Thu Nov 10, 2011 7:50 am
Posts: 9
Lieven Borms wrote:
Because some people are struggling with the phpMyAdmin part. I simplified the first part of the solution.
Below you can find the renewed solution.

To solve this problem please enter the following two steps.
1. Add the missing record to the database
Unzip the file ‘slbs.zip’ (attached to this post)
Copy the file ‘slbs.php’ to the root of your domain
Go to http://www.yourdomain.com/slbs.php (replace ‘yourdomain.com’ with your real domain)
Now you can remove the ‘slbs.php’ file from the root

2. Rebuilding menus
Go to the administrator panel of joomla.
Menus --> MenuManager
Select all menus
Click on the button ‘Rebuild’
(By doing step two, the field ‘rgt’ in the just added record (step one) will get the appropriate value.)


Lieven Borms I love you, brother. Your solution saved me so much frustration. By the way, your solution also works on a clean install of 2.5.2. It also solved another problem I had where I wasn't getting admin menu items of newly installed components like Akeeba backup. Thanks again!!! PS if I ever meet you in one of those Joomla days festivals, I'll buy you a beer. :)
Top
 Profile  
 
bobankrstic
PostPosted: Tue Mar 13, 2012 7:12 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Mar 13, 2012 7:01 pm
Posts: 1
To Lieven Borms

Thank you very much for sharing your knowledge!!!
Top
 Profile  
 
metatech
PostPosted: Thu Mar 15, 2012 2:13 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Apr 05, 2006 11:42 am
Posts: 8
You just saved my bacon. :)
Worked well on Joomla 2.5 (after an upgrade process from 1.5-1.7-2.5).

A million thanks. :D
Top
 Profile  
 
tronath
PostPosted: Sat Mar 17, 2012 7:37 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sat Mar 17, 2012 7:33 pm
Posts: 1
Thanks very much!
Top
 Profile  
 
RenewGuru
PostPosted: Fri Mar 23, 2012 7:19 pm 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Thu Mar 11, 2010 1:34 am
Posts: 76
Lieven Borms wrote:
In a normal Joomla 1.5 installation the table names are starting with the prefix ‘jos_’.
When you migrate from 1.5 to 1.6, the ‘jos_’ tables are copied for Joomla 1.6. The prefix of the new tables, for the Joomla 1.6 installation, is normally ‘j16_’ (in later versions of jupgrade you can adjust it). So when you do this step these tables already exist.

If you database name is “druensve” and the prefix is “j16_” then you need to have ‘druensve’.’j16_menu’ instead of ‘druensve.j16_menu'. (‘database_name’.’table_name’)

Below your customized query. Normally it should work with this. (If the prefix is ‘j16_’)
INSERT INTO `druensve`.`j16_menu` (`id` ,`menutype` ,`title` ,`alias` ,`note` ,`path` ,`link` ,`type` ,`published` ,`parent_id` ,`level` ,`component_id` ,`ordering` ,`checked_out` ,`checked_out_time` ,`browserNav` ,`access` ,`img` ,`template_style_id` ,`params` ,`lft` ,`rgt` ,`home` ,`language` ,`client_id` ) VALUES ( '1', '', 'Menu_Item_Root', 'root', '', '', '', '', '1', '0', '0', '0', '0', '0', '0000-00-00 00:00:00', '0', '0', '', '0', '', '0', '0', '0', '*', '0')


I edited my Joomla! 2.5.3 SQL to the following:
INSERT INTO `joomrei`.`jos_menu` (`id` ,`menutype` ,`title` ,`alias` ,`note` ,`path` ,`link` ,`type` ,`published` ,`parent_id` ,`level` ,`component_id` ,`ordering` ,`checked_out` ,`checked_out_time` ,`browserNav` ,`access` ,`img` ,`template_style_id` ,`params` ,`lft` ,`rgt` ,`home` ,`language` ,`client_id` ) VALUES ( ’1′, ”, ‘Menu_Item_Root’, ‘root’, ”, ”, ”, ”, ’1′, ’0′, ’0′, ’0′, ’0′, ’0′, ’0000-00-00 00:00:00′, ’0′, ’0′, ”, ’0′, ”, ’0′, ’0′, ’0′, ‘*’, ’0′)

However now I am receiving a Syntax error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '00:00:00′, ’0′, ’0′, ”, ’0′, ”, ’0′, ’0′, ’0′, ‘' at line 1

This is using WAMP Server 2.2D on a Windows 7 64bit machine with the latest PHP version 5.3.10

Seriously do not understand why this issue would be present in a 3rd Stable release of Joomla! 2.5 :geek:
Top
 Profile  
 
kc318
PostPosted: Tue Apr 03, 2012 3:45 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Apr 03, 2012 3:40 pm
Posts: 1
#1142 - INSERT command denied to user 'cordiert'@'localhost' for table 'jml1_menu'

what did i do wrong? i believe this is the only database i have... cordiert_jml1
Top
 Profile  
 
RenewGuru
PostPosted: Wed Apr 04, 2012 12:48 pm 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Thu Mar 11, 2010 1:34 am
Posts: 76
kc318 wrote:
#1142 - INSERT command denied to user 'cordiert'@'localhost' for table 'jml1_menu'

what did i do wrong? i believe this is the only database i have... cordiert_jml1


Typical WAMP (or variant) installations do not have any other username other than "root" and no password. The username/password are set in the final installation process of Joomla for the Admin username/password only. phpMySQL will show you what your database name is or you may create a new database before attempting to install Joomla then use that db name. Also within that db if you scroll down to the "Menu" table you will find the name extension (jos_menu) or something similar. Use the actual db name and menu table name info from phpMySQL in your edit of the script you will run in the SQL tab.
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 2 of 4
  [ 110 posts ]  Go to page Previous  1, 2, 3, 4  Next


Board index » Joomla! 2.5 - Ask Support Questions Here » Migrating and Upgrading to Joomla! 2.5

Who is online

Users browsing this forum: Taynguyenem_21 and 16 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