Does nayone know of an easy way to migrate from version 2.5.5 to 2.7. It seems that there are differences in the database (e.g. the items database is not the same) and the style sheet is completely different (it took me hours to get the original such that the site looked good, no i need to figure out again what doe what)
 
Is it possible to somehow migratethe entire "old" database to the new ?
 
Thanks
Erwin

Hello,
 
to update to the new version please do the following:
- make a backup of all files in your current version
- make a backup of your current database
- rewrite all files from new version (except ones you've changed, e.g. templates,styles)
- you should leave 'old' file /includes/var_definition.php
- run 'Administration > System > System Upgrade' - this should upgrade your database structure
 
Thanks,
ViArt Support Team

Hi,
 
Followed this exactly, in the admin >upgrade i do not see any upgrade message, it ays i am already running 2.7. Still the shop is gone now, gives a database error.
 
The error i get is :
Page URL: http://localhost/mysite/
Referrer URL:
Database error: Invalid SQL: SELECT item_type_id, tax_percent FROM va_tax_rates_items WHERE tax_id=28
MySQL Error: Table 'collectors.va_tax_rates_items' doesn't exist
 
The admin pages do work, i copied everything from version 2.5.5. except for the templates and style forms.
 
How do i get the database updated now without loosing the content ?
 
Regards
ErwinS

Hello,
 
It seems your database wasn't updated.
 
After updating files when you go to System Upgrade usually you can see something like following:
Currently installed version: 2.5.5
Version available to install: 2.7
 
More information can be found here http://www.viart.com/doc.php?code=ecommerce_system_upgrading.html
 
Thanks,
ViArt Support Team

From the page you linked to i first see picture nr 4 (new version 2.7 is available). After downloading and installing i copy the new files to the old directory and overwrite all except for style and templates and var_definition files.
 
After that i get the database error om the site , i can however log into the admin pages, when looking at the upgrade section i see pic nr 1, "you have the latest version" and no database update or anything
 
Regards
Erwin

Hello,
 
Did you updated 'includes/common.php' file as well?
 
If you want you can also send FTP details to your site so our support team try to help you.
 
Thanks,
ViArt Support Team

Hi,
 
Even if i install the 2.7 version clean and only change the var_definition file to point at the old database i do not get the database upgrade message, just the screen that i have the latest installed.
I also tried it through version 2.6 first, same thing, no update database.
 
Maybe i should just rework the 2.7 database and files and migrate everything to that. The .css of 2.7 looks much easier to change anyway.
 
Thanks
Erwin

Just curious... where is the current version of the database ? That should be somewhere in the database correct ? Could you tell me where i can find it so i can trace from there why it does not seem to find an update needed ?
(the new version number is in common.php VA_RELEASE correct ?!)

Hello,
  
It's storing in the va_global_settings table where
setting_type='version' and setting_name='number' and the setting_value should be in your case '2.5.5'.
  
Yes, that's right.
 
Thanks,
ViArt Support Team

Think i got the issue there, va_global_settings does not have a version field in my database.
 
I just searched, it is also not in the mysql_viart_shop.sql file for initially setting up the shop (version 2.5.5)
 
I have added the variables to the table, and now it does offer a database update.
I'll give the update a try tomorrow, but i think this might have been the isseu.
 
Thanks
Erwin