Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Joomla version 1.5 is end-of-life and are no longer supported. Please use Joomla 3.x instead.

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.
FnF
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 160
Joined: Thu Jul 19, 2007 4:27 am
Location: Wisconsin

Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by FnF » Sat Jul 11, 2009 3:56 am

As promised.

Couple of things I'd like to mention here up front;
  • A- Do not delete your current 1.0.x installation of Joomla....yet.
  • B- You MUST have Virtuemart 1.1.3 running correctly on your existing Joomla 1.0 site for the migration to be successful. So if need be, upgrade VM first.
    It's as simple as uploading a file, and extracting to over write. When you log into your VM admin it notices the updates and runs the DB query bringing your install up to date.
  • C- You'll also need an SQL file to upload during the migration.
    So you'll need to download the latest version of the Joomla Migrator found here and upload it to your current 1.0x site by using the component installer.
  • D- Your going to need some Virtuemart plugins for your new migrator in order for Virtuemart to accompany you on this journey. Virtuemart ETL Plugins can downloaded here.
    They can be added to the Migrator by clicking Components > Migrator, and then clicking "add 3rd party plugins" from the bottom of the Migrator screen. This never did work for me.
    So I uploaded the zipped plugin package to administrator/components/com_migrator/plugins, and unzipped it there.
  • E- Now you can go back to your Joomla admin panel and click on components > Migrator, and then "list plugins" at the bottom to verify they are there.
  • If all is well, click back to get to the front page of the Migrator and click "Create Migration SQL File" from the bottom right.
    It'll list the plugins again it's going to create the sql dump for, and at the bottom of the page now you'll see a "start migration" link. You can click that.
    The migrator will create the file and go through a couple sequences, and when it's finished you'll be presented with a "MIGRATION COMPLETE" at the top of the page.
    Dont be fooled, your migration is far from complete, but your sql file for the migration is complete. LOL. Click the "Download" button in the lower left, and you'll see your sql file listed. You may download it from there.
    I suggest saving it to place you can readily find it later. You'll need it soon.
  • F- Now you may log out of your old Joomla1.0.x, were done there.
----------------------------------------------------

And here we go. Migrating Joomla1.0 to 1.5X and bringing Virtuemart With.
The hype about migrating to J1.5 first and then upgrading to the latest from there seems to be nothing more then that, hype. I've done it from 1.0 to 1.5.12 with no problems.
  • 1- The first thing you want to do is download the latest version of Joomla here. You'll want the full package and not the upgrade.
  • 2- Create a new directory in your sites control panel and upload the zipped Joomla version you've just downloaded. Do not try to over write your existing 1.0 files with it by placing it in the same home directory.
    And yes you'll need to set up a new database for your new J1.5 site.
  • 3- As with any new Joomla install, extract the zipped file, and then visit the url of the directory you uploaded to, to run the installer.
    • 4- When you get to the installation step that asks for your site name, instead of adding that info, scroll down to the bottom, add the table prefix for your old joomla install which is most likely "jos_" without the quotes.
      Your old site encoding is most likely iso-8859-1, if not adjust that accordingly.
      Then click the browse button to upload the sql dump file you created earlier and downloaded from the Migrator component in your old joomla install.
      Finally put a check in the box stating this is a 1.0 migration script, and click "Upload and Execute"
If everything went as planned you'll be presented with a "Migration Successful, please press next to continue and it will ask you for your site name, email and password info again. Fill this out and click next.

Your Done...with the initial install anyway. :D
From here you can either visit your new site or go straight to the admin panel.
Don't be alarmed if you go straight to the site's front page and things seem a little off. Remember your just migrated to a whole new version and things are much different, plus you'll automatically be set up on a different template. You can adjust things, and add templates later. Right now lets get your Virtuemart content, products etc, working.

The sql dump file you uploaded added all your content from the old Joomla install, and with the Virtuemart plugins, your Virtuemart tables were added to the database.
Now we need to install Virtuemart so you and your viewers can access that content.
This Virtuemart installation process is going to be much different then your old one. So dont just hop over to Virtuemart downloads and think you can download it and install it with the handy component installer within Joomla, and be done.
This gets tricky, so take your time, and be thorough.

--------------------------------------------------

The Virtuemart Part (hey that rhymed!) 8)
Now visit Virtuemarts download page and download the "Complete Package for Joomla! 1.5".
This is not the typical VM package some of you may used to, so remember you cant upload it as it is. It's actually made up of several more zip files, and again this is where I think most of you are getting confused. Take your time.

1- Unzip the VM zip file to a new directory on your desktop so you can work with the many files within it. You'll notice a lot of goodies in there. Non of it is edible though.

2- Now the first file you'll need to deal with is the "com_virtuemart_1.1.3.j15.zip". You are SUPPOSE to be able to install this as a component through the installer of your new Joomla site, but not as you'd expect.
Inside the admin panel of your new Joomla install, under Extensions is where you install it from but uploading it as a package by using the first option there has been completely ignored by Firefox, and gives fits to Microsoft Internet Explorer.
So your best bet is to jump down to the "Install from directory" option.
Upload the zipped com_virtuemart_1.1.3.j15.zip file to the "tmp" directory of your new Joomla install with Cpanel or what ever you use to access your site files.
Now you can go back to the Admin panel > Extensions > Install/Uninstall, and list the path in the second option (install from directory) and click install.

When it's done it'll take you to a Welcome to Virtuemart panel.
Settle down, were just getting started.
From there be sure to click "Go Directly to Shop". Do not install sample data if you want your prior items to be migrated over.
Go to the the shop, click Admin > Configuration, and then Save. Some tutorials say you need to do this. I do not no if it's necessarily a requirement, but I did do it.

3- This next step is going to be the tough part for some of you. For some reason in all my failed attempts I was never able to actually get the content of my old Virtuemart, products, prices, users etc, to migrate over with the sql dump file.
I know the migrator sql dump creates the tables, so I wanted to make sure the right data was in the tables by exporting my own dump file.
To do that you can go through PHPMyAdmin.

Inside PHPMyAdmin, click the database on the right for your old Joomla install and then choose export from the tabs at the top.
Your presented with a list of tables within that database.
Highlight each of the tables within that list that begin with jos_vm_ by clicking them and holdin your Ctr or CTRL key.
It will be nearly half of them and it'll be the lower half.
Once they are highlighted scroll down and make sure SQL is ticked below the list of tables. Also place a tick under Structure where it reads, Add DROP TABLE / VIEW / PROCEDURE / FUNCTION and then click "GO" in the lower right hand corner.

The next page is your SQL query. Place your mouse inside the window with the text, holding the ctrl key and click A. This highlights all the text.

Now right click the highlighted text and choose copy from the menu that appears.

Now scroll back up and click the home button in the upper left corner.

From there click the database name for your NEW Joomla install.

Once that opens click SQL from the tabs near the top, and you'll be presented with an SQL window.

Click once in the window to get your flashing cursor, then right click and choose paste this time from the drop down menu that appears.

Then click "GO" from the lower right.

4- You can now log out of PHPMyAdmin. The content of your old Virtuemart tables has been copied to your new Joomla database.
Want to take a break? ...or should we keep going going? LOL Were almost done.

5- Now we go back to the admin section of your new Joomla site. Were going to install some more pieces of that so called Complete Virtuemart package you downloaded and unzipped to your desktop earlier.
Go to Admin > Extensions > Install/Uninstall
The rest of the uploads done through your admin panel will play nice with Firefox and M.I.E., so were going to use the first option in there which is "Upload Package File", from now on.

Click browse and find the file inside your unzipped VM Complete directory titled mod_virtuemart_1.1.3.j15.zip. It's going to be inside the modules directory of that unzipped VM package and along with about 12 other zip files, so take your time.
Then click upload and install.

6- Now you should go to Admin > Modules, and enable the Virtuemart Mod you just installed, by clicking the red X to the right of it in your module list.

7- Now you can go back to Admin > Extensions > Install/Uninstall, and in the same fashion as you just did, finish uploading and installing all the remaining files within the module directory of that VM complete package.
Be sure to go back and enable them when your finished with them all. As described in step 6

8- Once your done with that, done the same way, you can upload and install the two files found within the "Plugin" directory of the VM Complete package.

Your Done!

If everything went right, and it certainly should, your cart should now be fully functional as it was before, but with tons of new features and a whole lot easier to use.

You can now start to rearrange the modules and content on your sites front page to suit your needs, since it most likely will not be a replica of your old site, due to the fact that the templates will be different.

The only thing that may not have migrated over for you regarding your Virtuemart install would be the images. Meaning product images, category images etc. And those can easily be copied over with your Cpanel by copying the entire directory components/com_virtuemart/shop_image/product directory to your new install and over writing the existing one with your old one.
Just be sure to place it where it goes by following the same path.

Once you've finished tweaking your site and making all the adjustments needed to make it presentable, you can remove your old version by moving all the files to a different directory incase you find you need something later, and then moving the new install to it's directory.
You'll have to edit a couple paths in your config file to match, but it's easily done.

If this tutorial helps 1 person, I'll consider it time well spent to set down and type it out.
I fought with this migration for weeks before finally figuring it out, and personally I think the tutorials out there, what few of them there are, leave out too much information, that a lot of them are taking for granted folks know.

Comments welcome :pop

User avatar
dpacadmin
Joomla! Champion
Joomla! Champion
Posts: 6029
Joined: Sat Aug 16, 2008 1:46 pm
Location: the Bat Cave
Contact:

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by dpacadmin » Sat Jul 11, 2009 3:17 pm

Thanks for a great post, I'm sure this will help many. :)

FnF
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 160
Joined: Thu Jul 19, 2007 4:27 am
Location: Wisconsin

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by FnF » Tue Jul 14, 2009 10:48 am

I expected questions by now.
I must have explained things too well. :)

FnF
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 160
Joined: Thu Jul 19, 2007 4:27 am
Location: Wisconsin

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by FnF » Thu Jul 16, 2009 2:00 am

Just a quick addition.
Virtuemart applications using PayPal payment methods

The PayPal information, (your PayPal address) doesn't seem to be following along with the migration. Most likely for security reasons. ???

Never the less, you will need to re edit your PayPal configuration once migrated. Which also includes removing the PayPal payment method from 'test mode'.

User avatar
dpacadmin
Joomla! Champion
Joomla! Champion
Posts: 6029
Joined: Sat Aug 16, 2008 1:46 pm
Location: the Bat Cave
Contact:

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by dpacadmin » Thu Jul 16, 2009 2:22 am

131 views to date, your tutorial seems to be pretty popular.

FnF
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 160
Joined: Thu Jul 19, 2007 4:27 am
Location: Wisconsin

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by FnF » Sat Jul 25, 2009 2:21 am

Another quick addition.

Some servers and some zip files may have a tendency to NOT retain their appropriate permissions when extracting.
Which means that if you upload a zip a file to overwrite while either doing your migration or when putting the finishing touches on your new 1.5.x site, you may find that all of a sudden your faced with server errors, or page denied etc.

Before you panic, and uninstall, or delete everything, there's a 98% chance that this is simply a permissions issue caused by the zip file you just extracted to overwrite, not retaining the proper permissions.

If you are running either Suphp or Suexec, or both, on your server or your host is, this is especially true.
Go in through an FTP program WinSCP or something similar to check or re-edit permissions. Dont rely on Cpanel or Plesk to show you the right permissions due to caching issues especially if you've just overwrote the files.

User avatar
dpacadmin
Joomla! Champion
Joomla! Champion
Posts: 6029
Joined: Sat Aug 16, 2008 1:46 pm
Location: the Bat Cave
Contact:

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by dpacadmin » Wed Aug 12, 2009 9:08 pm

Just thought I'd let you know there is now a link to your tutorial on the official migration guide page;
http://docs.joomla.org/Migrating_from_1 ... 1.5_Stable

FnF
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 160
Joined: Thu Jul 19, 2007 4:27 am
Location: Wisconsin

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by FnF » Thu Aug 13, 2009 1:45 am

Oh NNnnnnnice. :D
That is way cool! Thanks for pointing that out to me, unless your the one that did it, then thank you very much.

I wish I was able to edit the original post and keep it updated, but for some reason it's not allowing me an edit option. They must have it disabled after x amount of days.

I wanted to edit the link to the VirtueMart ETL plugins because VM has taken them behind closed doors now.

I've done 15 Joomla/VirtueMart migrations for my clients since the tutorial post, and done every one of them as described above. Never had an ounce of trouble with a single one of them.

You and several others helped me get to the point I could actually pull these migrations off successfully, and got me to the point that I could write that tutorial. So a lot of the Kudos goes to you and the other helpful members as well. ;)

User avatar
dpacadmin
Joomla! Champion
Joomla! Champion
Posts: 6029
Joined: Sat Aug 16, 2008 1:46 pm
Location: the Bat Cave
Contact:

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by dpacadmin » Thu Aug 13, 2009 1:52 am

Thanks for your appreciation, just glad to have been of some help. I am just one of many and as you say there are many people here willing to help others and I enjoy being a part of that. ;D

thockley
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Fri Aug 28, 2009 1:43 am

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by thockley » Fri Aug 28, 2009 1:54 am

thankyou FnF for the excellent tutorial. I am in the process of migration from 1.0 to 1.5.
So re your instruction as follows--
"So you'll need to download the latest version of the Joomla Migrator found here and upload it to your current 1.0x site by using the component installer"
Component installer requests a package file to upload. The migrator folder contains many files and folders. What do i select for upload ? sorry FnF but i am a newby, your help appreciated

User avatar
dpacadmin
Joomla! Champion
Joomla! Champion
Posts: 6029
Joined: Sat Aug 16, 2008 1:46 pm
Location: the Bat Cave
Contact:

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by dpacadmin » Fri Aug 28, 2009 2:05 am

Just select the zip file to install, migrator.zip.

thockley
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Fri Aug 28, 2009 1:43 am

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by thockley » Fri Aug 28, 2009 3:19 am

thank you dpacadmin it was successful. However after completing step E - "Create Migration SQL File" all my thumbnail images in the database are gone on my site -just a blank square where they should be, but they load into a small window for larger view as normal but no thumbnails - do you have any idea why this happened ?

FnF
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 160
Joined: Thu Jul 19, 2007 4:27 am
Location: Wisconsin

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by FnF » Fri Aug 28, 2009 3:43 am

Hi thockley,
What do you mean all the thumbnail images in the database?

thockley
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Fri Aug 28, 2009 1:43 am

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by thockley » Fri Aug 28, 2009 4:16 am

on my site www.opalmine.com.au -under the jewelry and rough opal links there are no thumbnail images. I think they are in the SQL database ( not sure dpacadmin )

FnF
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 160
Joined: Thu Jul 19, 2007 4:27 am
Location: Wisconsin

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by FnF » Fri Aug 28, 2009 11:59 am

I'm seeing thumbnails when I visit, unless I'm on the wrong page.
I wanted to ask you is this your old site or your new 1.5.x site?

User avatar
dpacadmin
Joomla! Champion
Joomla! Champion
Posts: 6029
Joined: Sat Aug 16, 2008 1:46 pm
Location: the Bat Cave
Contact:

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by dpacadmin » Fri Aug 28, 2009 10:28 pm

I see them too, probably just needs to clear their browser cache.

johnpeterson82
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Sat Aug 29, 2009 7:14 am

Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by johnpeterson82 » Sat Aug 29, 2009 7:44 am

Excellent! Just excellent.

Worked like a charm, even though my website's sql is huge (over 500mb).

I migrated both of my sites using this.

regards..

john

thockley
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Fri Aug 28, 2009 1:43 am

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by thockley » Mon Aug 31, 2009 5:50 am

FnF this is old site Joomla v 1.0.15. Thumbnails can still be viewed on home page but are missing on pages Rough Opal and Jewelry - this happened after i upgraded Vituemart. Clear cache was done and did not make thumbnails return. So should i proceed with the migration to Joomla 1.5.14 or fix the missing thumbnail issue first ?

kharri1073
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Tue Oct 30, 2007 8:06 pm

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by kharri1073 » Tue Sep 01, 2009 8:26 pm

The migration seems to go well until I get to this step...
4- When you get to the installation step that asks for your site name, instead of adding that info, scroll down to the bottom, add the table prefix for your old joomla install which is most likely "jos_" without the quotes.
Your old site encoding is most likely iso-8859-1, if not adjust that accordingly.
Then click the browse button to upload the sql dump file you created earlier and downloaded from the Migrator component in your old joomla install.
Finally put a check in the box stating this is a 1.0 migration script, and click "Upload and Execute"
I was successful with every other step until then.

When I get there, I run into the following problem.

Code: Select all

Error at the line 32: INSERT INTO jos_banner (`bid`,`cid`,`type`,`name`,`imptotal`,`impmade`,`clicks`,`imageurl`,`clickurl`,`date`,`showBanner`,`checked_out`,`checked_out_time`,`editor`,`custombannercode`,`position`,`alias`) VALUES ( '1','1','','Home Top Left','0','537542','4748','abaweb_homeban_getaway.gif','http://www.airbrushaction.com/workshops/view-all-products.html','2009-07-31 06:54:57','1','0','0000-00-00 00:00:00','','','left','home-top-left');

Query:INSERT INTO jos_banner (`bid`,`cid`,`type`,`name`,`imptotal`,`impmade`,`clicks`,`imageurl`,`clickurl`,`date`,`showBanner`,`checked_out`,`checked_out_time`,`editor`,`custombannercode`,`position`,`alias`) VALUES ( '1','1','','Home Top Left','0','537542','4748','abaweb_homeban_getaway.gif','http://www.airbrushaction.com/workshops/view-all-products.html','2009-07-31 06:54:57','1','0','0000-00-00 00:00:00','','','left','home-top-left');

MySQL: Unknown column 'position' in 'field list'

Stopped on error
Any ideas how to get past this?

User avatar
dpacadmin
Joomla! Champion
Joomla! Champion
Posts: 6029
Joined: Sat Aug 16, 2008 1:46 pm
Location: the Bat Cave
Contact:

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by dpacadmin » Tue Sep 01, 2009 8:33 pm

Sounds like an extension or someone added a "position" field to the jos_banners table. You could try editing a copy of the dump file and remove the position field from the sql statement, en try running the install again with the edited file. Remember you can not reuse a dump file so if the install goes bad you need to upload a new copy of the dump file.
Here is a create table statement from a Joomla 1.5 install

Code: Select all

CREATE TABLE `jos_banner` (
  `bid` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL default '0',
  `type` varchar(30) NOT NULL default 'banner',
  `name` varchar(255) NOT NULL default '',
  `alias` varchar(255) NOT NULL default '',
  `imptotal` int(11) NOT NULL default '0',
  `impmade` int(11) NOT NULL default '0',
  `clicks` int(11) NOT NULL default '0',
  `imageurl` varchar(100) NOT NULL default '',
  `clickurl` varchar(200) NOT NULL default '',
  `date` datetime default NULL,
  `showBanner` tinyint(1) NOT NULL default '0',
  `checked_out` tinyint(1) NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `editor` varchar(50) default NULL,
  `custombannercode` text,
  `catid` int(10) unsigned NOT NULL default '0',
  `description` text NOT NULL,
  `sticky` tinyint(1) unsigned NOT NULL default '0',
  `ordering` int(11) NOT NULL default '0',
  `publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
  `publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
  `tags` text NOT NULL,
  `params` text NOT NULL,
  PRIMARY KEY  (`bid`),
  KEY `viewbanner` (`showBanner`),
  KEY `idx_banner_catid` (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

kharri1073
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Tue Oct 30, 2007 8:06 pm

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by kharri1073 » Wed Sep 02, 2009 7:00 pm

Thanks for the suggestion, I removed the 'custom' columns and I was able to get much further through the migration, although it's still has yet to complete.

The latest problem is as follows.
Error at the line 41648: INSERT INTO jos_menu_migration_migration (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '2','mainmenu','Home','index.php?option=com_frontpage','components','1','0','10','0','2','0','0000-00-00 00:00:00','0','0','0','3','num_leading_articles=1\r\nnum_intro_articles=2\r\nnum_links=1\r\nimage=1\r\nshow_page_title=0\r\npage_title=Welcome to the Frontpage\r\norderby_sec=front\r\nshow_print_icon=0\r\nshow_pdf_icon=0\r\nshow_email_icon=0\r\nback_button=0\nshow_title=1\n','home-mainmenu-1');

Query:INSERT INTO jos_menu_migration_migration (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '2','mainmenu','Home','index.php?option=com_frontpage','components','1','0','10','0','2','0','0000-00-00 00:00:00','0','0','0','3','num_leading_articles=1\r\nnum_intro_articles=2\r\nnum_links=1\r\nimage=1\r\nshow_page_title=0\r\npage_title=Welcome to the Frontpage\r\norderby_sec=front\r\nshow_print_icon=0\r\nshow_pdf_icon=0\r\nshow_email_icon=0\r\nback_button=0\nshow_title=1\n','home-mainmenu-1');

MySQL: Table 'j15_airbrush.jos_menu_migration_migration' doesn't exist

Stopped on error
This has been reported before at http://forum.joomla.org/viewtopic.php?p ... 8#p1688221

I have replaced the script and i'm removing any tables in the database every time that it fails. I have also double checked the migration.sql file to make sure there is no string in the file that consists of 'migration_migration'.

jos_ is the prefix and both of the following are checked...
I have already uploaded the migration script to the server (e.g. via FTP/SCP)
This script is a Joomla! 1.0 migration script.

I'm migrating from 1.0.15 to 1.5.14

User avatar
dpacadmin
Joomla! Champion
Joomla! Champion
Posts: 6029
Joined: Sat Aug 16, 2008 1:46 pm
Location: the Bat Cave
Contact:

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by dpacadmin » Wed Sep 02, 2009 10:11 pm

The migration_migration error seems to be caused by trying to reuse the migration file, according to the post you linked to. This
j15_airbrush.jos_menu
doesn't sound like a correct table name even without the migration_migration on the end. Could be a problem with a large migration file, how large is your dump file? This is something I think Sam will need to help with, he would know what the query is trying to do. You could try PMing him
pasamio

kharri1073
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Tue Oct 30, 2007 8:06 pm

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by kharri1073 » Thu Sep 03, 2009 7:41 pm

Ok, thanks I'll pm him.

FnF
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 160
Joined: Thu Jul 19, 2007 4:27 am
Location: Wisconsin

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by FnF » Sat Sep 05, 2009 4:00 am

thockley wrote:FnF this is old site Joomla v 1.0.15. Thumbnails can still be viewed on home page but are missing on pages Rough Opal and Jewelry - this happened after i upgraded Vituemart. Clear cache was done and did not make thumbnails return. So should i proceed with the migration to Joomla 1.5.14 or fix the missing thumbnail issue first ?
Sorry about the delay in getting back to you thockley.
I would proceed with the migration.
As mentioned in my first post, I did have some images from VirtueMart not following along to the new sites through migration, so I simply copied the directory "components/com_virtuemart/shop_image/product" over to the new site and overwrote the existing one.

kharri1073
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Tue Oct 30, 2007 8:06 pm

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by kharri1073 » Tue Sep 08, 2009 3:51 pm

Sorry, it's saying I can't pm anyone without having at least 5 posts first.

kharri1073
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Tue Oct 30, 2007 8:06 pm

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by kharri1073 » Tue Sep 08, 2009 3:52 pm

Just need one more post, sorry to do this, I just need to pm someone.

User avatar
Lockerbie
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 170
Joined: Wed Dec 06, 2006 4:25 pm

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by Lockerbie » Thu Sep 10, 2009 9:46 pm

Thanks very much FnF, you really helped me out here! 8)

I tried to figure it out how to upgrade/migrate to Joomla 1.5 with VirtueMart for days. Just like you said: most tutorials tell you to go the other way around, so to upgrade to J-1.5x first. But that won't work, so I'm glad I found this post!

One small thing:
At point 2 of "The VirtueMart Part", I would like to add:
If none of the described ways to upload and/or install "com_virtuemart_1.1.3.j15.zip" works, you can unpack the contents of "com_virtuemart_1.1.x.zip" and upload those files to a directory in your Joomla! site (e.g /media or /tmp) using an FTP client. After you've done that, specify the directory on the server from where you want to install the files and click "Install". (Found here.)

sparkydog
Joomla! Apprentice
Joomla! Apprentice
Posts: 46
Joined: Tue Oct 17, 2006 9:42 pm

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by sparkydog » Thu Sep 17, 2009 4:34 pm

This was a lot of work, FnF, and it is highly appreciated by all.

However, I find one discrepancy that's confusing. In the first part, you say to get the ETL plugins, then in the last part, to import the VM tables yourself cause you could never get the VM tables to come over with the MySQL migration.

If you're going to export the tables from your old installation, then there's no point in using the ETL plugins, even if they worked.

If the ETL plugins did work, then there's be no point in doing your own export/import -- or in the case of how you explain it, in doing a copy f the tables from one database to another in same server/account.

If all the ETL plugins do is create the tables, but do not take the actual data in them, there's no point in having them do that, either.

I mention this last one because you say:
I know the migrator sql dump creates the tables, so I wanted to make sure the right data was in the tables by exporting my own dump file.
Whether you copy data on the same server or create a dump file and export/ import from one to the other, you don't need to have the tables already created by the ETL plugins (with no data in them?), but can have hem created for you in the process.

Not to be a nit-picker. I'm just trying to save you all an extra step if it's not necessary.

I'm about to do a full upgrade and migration myself, and I'm going to check out those ETL plugins, so I'll let you all know how it goes and if what I said was right, and if there's anything else to add that would be helpful.

:)

ADDENDUM: The link for the VirtueMart ETL plugins in the first post in this thread does not work. it is now: http://extensions.joomla.org/extensions ... sions/7415.

User avatar
Alextampa
Joomla! Guru
Joomla! Guru
Posts: 557
Joined: Fri Jan 09, 2009 3:16 pm
Location: Tampa

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by Alextampa » Thu Sep 17, 2009 5:12 pm

thockley wrote:thank you dpacadmin it was successful. However after completing step E - "Create Migration SQL File" all my thumbnail images in the database are gone on my site -just a blank square where they should be, but they load into a small window for larger view as normal but no thumbnails - do you have any idea why this happened ?

You have to more than likely "re-create" the thumbnails by disabling the dynamic resizing, and save. And then re-enable, and save.

User avatar
Lockerbie
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 170
Joined: Wed Dec 06, 2006 4:25 pm

Re: Migrate to Joomla 1.5 bringing Virtuemart too / TUTORIAL

Post by Lockerbie » Thu Sep 17, 2009 6:47 pm

Alextampa wrote:
thockley wrote:thank you dpacadmin it was successful. However after completing step E - "Create Migration SQL File" all my thumbnail images in the database are gone on my site -just a blank square where they should be, but they load into a small window for larger view as normal but no thumbnails - do you have any idea why this happened ?

You have to more than likely "re-create" the thumbnails by disabling the dynamic resizing, and save. And then re-enable, and save.
If that doesn't work, try this solution. It even "magically" recovers the lightbox- and shopimages, which are probably missing also. ;)


Locked

Return to “Migrating and Upgrading to Joomla! 1.5”