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  [ 109 posts ]  Go to page Previous  1, 2, 3, 4  Next
Author Message
PostPosted: Wed Apr 04, 2012 7:33 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Wed Apr 04, 2012 7:26 pm
Posts: 1
Wow Lieven Borms that is probably the greatest fix I have ever used. Thanks!


Top
 Profile  
 
PostPosted: Fri Apr 06, 2012 8:21 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Tue Sep 20, 2011 11:07 am
Posts: 26
thank you very much, Lieven Borms
that's really good, specially the php file,nice done.


Top
 Profile  
 
PostPosted: Sat Apr 07, 2012 4:06 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sat Apr 07, 2012 4:03 pm
Posts: 2
how do we get past this part

#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′, â€


Top
 Profile  
 
PostPosted: Sat Apr 07, 2012 4:31 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sat Apr 07, 2012 4:03 pm
Posts: 2
Hats Off Lieven Borms used the slbs file in the end - worked a treat


Top
 Profile  
 
PostPosted: Thu Apr 12, 2012 2:26 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Sep 07, 2010 7:50 pm
Posts: 2
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.)



Sir, I take my hat of for you.

Thank you for sharing this with us


Top
 Profile  
 
PostPosted: Sun Apr 15, 2012 4:07 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sun Nov 15, 2009 11:36 pm
Posts: 39
hooray! so rarely does a forum question i need answered get answered so well. thank you so much!


Top
 Profile  
 
PostPosted: Tue Apr 17, 2012 2:11 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Apr 17, 2012 2:03 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.)


THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
I tought i need to reinstall all system and start from zero .... You save me one week of hard work...
Beer on me ;)


Top
 Profile  
 
PostPosted: Mon Apr 23, 2012 11:01 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Mon Apr 23, 2012 10:54 am
Posts: 1
Lieven Borms thanks very very much mate =)


Top
 Profile  
 
PostPosted: Mon Apr 23, 2012 2:02 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Thu Jan 13, 2011 11:13 pm
Posts: 6
You are awesome. Thank you.


Top
 Profile  
 
PostPosted: Fri Apr 27, 2012 5:01 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Wed Jul 20, 2011 9:43 am
Posts: 4
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.)


YOU SAVED MY LIFE. Solution worked well on joomla 2.5

You are a joomla lifesaver


Top
 Profile  
 
PostPosted: Tue May 01, 2012 8:12 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue May 01, 2012 7:32 am
Posts: 1
rw1 wrote:
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!



Thanksssssss!!!!!!!!!!!!!!!!!!! muchas gracias man! usted es un genio!!!! gracias!!!! funciona perfectamente en joomla 2.5


Top
 Profile  
 
PostPosted: Tue May 01, 2012 1:27 pm 
User avatar
Joomla! Guru
Joomla! Guru

Joined: Tue Aug 23, 2005 6:41 am
Posts: 860
I haven't tried this solution yet but I think I discovered where the problem might come from in the first place.

There is the possibility of different database collations between some of the tables and their structures. One of the SQL queries failed for me during menu migrations due to difference in collations. This could be the same problem that is happening here.

For me simply exporting the old 1.5 database and changing all collations to utf8_general_ci (my database collation) and then importing it into a temp installation on my computer and performing the upgrade with jUpgrade at that point worked perfectly fine. I don't get the SQL error during menu migration anymore.

I actually didn't get any errors until enabling migration debug and then I noticed the problem when enabling migration debug in the jUpgrade params. I thought I may as well post it here in case it helps anyone or gives any insight into what could be happening.

_________________
TY2U.com Designs http://ty2u.com - Professional Joomla! Extensions


Top
 Profile  
 
PostPosted: Sun May 06, 2012 4:35 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon Dec 03, 2007 7:14 pm
Posts: 33
This was P-E-R-F-E-C-T !!!

What a timesaver!

Thank you!

Lobo


Top
 Profile  
 
PostPosted: Wed May 09, 2012 10:27 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sun Feb 06, 2011 3:38 am
Posts: 4
Lieven,

Thank you so much for the quick fix. I have no idea what you did, but it worked perfectly!


Top
 Profile  
 
PostPosted: Fri May 11, 2012 11:41 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri May 11, 2012 10:57 pm
Posts: 11
Hi
It doesn't work for me .. i get this error: #1142 - INSERT command denied to user 'xxxxxx'@'localhost' for table 'uf405_menu'
what am i missing?

I have joomla 2.5.4


Top
 Profile  
 
PostPosted: Sat May 12, 2012 12:33 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri May 11, 2012 10:57 pm
Posts: 11
WOW!!! solved, thank you



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.)


Top
 Profile  
 
PostPosted: Mon May 14, 2012 9:33 am 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Sat Jun 10, 2006 7:15 am
Posts: 149
Location: London
I recently had the same problem and should have searched the Joomla forums first to see if there was a solution.

Anyway, I managed to solve the problem and my solution is sort of similar to that mentioned here.
For those interested it's on one of the RT forums because I wasn't sure if the problem was RT related initially.

http://www.rockettheme.com/forum/index.php?f=15&t=163426&rb_v=viewtopic


Top
 Profile  
 
PostPosted: Wed May 30, 2012 2:16 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat Feb 19, 2011 12:44 pm
Posts: 31
Fixed it for me :)

Thanks...


Top
 Profile  
 
PostPosted: Thu Jul 05, 2012 4:47 pm 
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Mon May 10, 2010 4:14 am
Posts: 109
Quote:
For me simply exporting the old 1.5 database and changing all collations to utf8_general_ci (my database collation) and then importing it into a temp installation on my computer and performing the upgrade with jUpgrade at that point worked perfectly fine. I don't get the SQL error during menu migration anymore.


How to you change the collation on a database for those of us with less of a skill set. :)

Many thanks,
Houston


Top
 Profile  
 
PostPosted: Sun Jul 08, 2012 9:20 pm 
User avatar
Joomla! Master
Joomla! Master

Joined: Wed Aug 17, 2005 10:27 pm
Posts: 14709
Location: Kent, England
HoustonBrown wrote:
How to you change the collation on a database for those of us with less of a skill set


BACKUP YOUR SITE AND DATABASE

Use phpMyAdmin to run the following command:
  1. To update the database itself :
    Code:
    ALTER DATABASE database_name CHARACTER SET = utf8  COLLATE = utf8_general_ci;
    .
  2. You must also change any of the tables that are not configured with utf-8 collation character set and the columns in the tables.
    Code:
    ALTER TABLE table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;


Top
 Profile  
 
PostPosted: Sat Jul 28, 2012 2:33 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sat Jul 28, 2012 12:17 pm
Posts: 1
Accept kisses from my GF! You made my day. :)


Top
 Profile  
 
PostPosted: Sat Aug 04, 2012 12:47 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sat Aug 04, 2012 12:39 pm
Posts: 1
Location: Poland
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.)



Thanks. Your script saved me a few hours of work. One more time Thank You very much :)

Regards
Iwona


Top
 Profile  
 
PostPosted: Thu Aug 30, 2012 5:56 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Thu Aug 30, 2012 5:11 pm
Posts: 30
Lieven Borms,

you are awesome : ). Thanks!


Top
 Profile  
 
PostPosted: Mon Sep 03, 2012 2:41 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Mon Sep 03, 2012 2:06 pm
Posts: 1
Hi where is the link to download this file?

thanks a lot ! :pop


Last edited by pkpss on Mon Sep 03, 2012 3:19 pm, edited 1 time in total.

Top
 Profile  
 
PostPosted: Mon Sep 03, 2012 2:58 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Jul 01, 2011 11:08 am
Posts: 19
Location: Dendermonde
You can download the file on the first page of this post. (posted by Lieven Borms on 08 oktober 2011, 19:24)


Top
 Profile  
 
PostPosted: Tue Sep 11, 2012 11:00 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Wed Mar 24, 2010 8:38 pm
Posts: 3
For those having problems with the fix there is an additional step that isn't apparent in instructions for step 1....

You have to change your 'DATABASE_NAME' as well as the prefix for ???_menu (right next to the DATABASE_NAME. Find your ???_menu prefix by using the search query to find ???_menu. From there you will find j16_menu or jos_menu or whatever (mine was jos_menu in 2.5). Now edit the DATABASENAME and the prefix of your _MENU and press go.


Top
 Profile  
 
PostPosted: Sun Sep 16, 2012 7:24 pm 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Sun Dec 28, 2008 3:25 pm
Posts: 56
Location: Sweden
@Lieven,

Thank you ever so much. You have no idea how much I feel I O U for this solution :)

Greetings
Anna

_________________
Jomlare in Sweden :-)
http://www.formfranska.com


Top
 Profile  
 
PostPosted: Wed Sep 19, 2012 2:10 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Jun 02, 2010 3:55 pm
Posts: 7
I don't normally post on this forum, but had to here. This post has worked for me and literally saved my life! I have a client website that is due to go live any day now, and I suddenly ran into this problem.

In joomla 2.5 just make sure you substitute the 'j16_menu' for the random generated table prefix that you will find when you look in phpMyAdmin.

Thanks again!!!


Top
 Profile  
 
PostPosted: Mon Oct 01, 2012 1:58 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Mon Oct 01, 2012 1:29 am
Posts: 1
thank you very much...finally problem solved...


Top
 Profile  
 
PostPosted: Fri Oct 12, 2012 1:22 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Fri Oct 12, 2012 11:42 am
Posts: 2
Can you please help me?

Actually i`m also getting the same error on my website but before everything was fine. I`m using joomla version 2.5.7 but when i checked my jos_menu table in phpmyadmin then it appears to be 1.5 version where the table structure is completely different than the joomla 2.5.7 version structure. Actually my office-mate had imported the joomla 1.5 version jos_menu in this joomla v 2.5.7.So, can u please suggest me some tips on how to solve this problem. Even i also have checked in the jos_menu table that there is an id having value 1 is there.
Thanks,


Last edited by imanickam on Thu Nov 08, 2012 6:19 am, edited 1 time in total.
Duplicate post http://forum.joomla.org/viewtopic.php?f=625&t=763037 in the forum Migrating and Upgrading to Joomla! 2.5 has been removed. In the future, please do not post the same topic multiple times as it is against the forum rules to cross post.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 109 posts ]  Go to page Previous  1, 2, 3, 4  Next



Who is online

Users browsing this forum: No registered users and 10 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