Ulisses Ramos Posted August 2, 2011 Share Posted August 2, 2011 I have a store using 1.2.4. I installed 1.4.4 on my pc to compare and the database has several fields that are different on the tables. If i do a simple upgrade will the upgrade add the fields that are not present in 1.2.4 and preserve the data i have? or do i have to make csv´s of all to update the dabatase after? Link to comment Share on other sites More sharing options...
Paul C Posted August 2, 2011 Share Posted August 2, 2011 You just need to run the installer provided in 1.4.4 and it will upgrade the database appropriately (ensure that it's running in upgrade mode and not a new install). I usually then export the structure (only - no data) of the resulting store and compare it to a structure export from a fresh 1.4.4 install - there are usually minor differences that I like to fix (minor things like fields lacking "unsigned" and slight differences in default values). Basically you need to preserve your theme, product and category images, any additional modules, translations, email templates and finally the /config/settings.inc.php file (<-- IMPORTANT)-- everything else can be deleted (but it's a good idea obviously to keep a backup). You can then copy the new distribution to your server, copy your original settings.inc.php file into the config directory and then visit the url http://www.example.com/install and this should start the upgrade process. Usually you actually need to copy the above customised files somewhere safe, ftp the new version and then overwrite with the files you previously saved, otherwise you'll lose your versions when you copy the default files in new distribution. Be aware that there are major differences in the themes (smarty 3 being the "killer"), so it might be best to revert to the default "prestashop" theme prior to upgrade and disable any non-core modules so you can confirm that the upgrade was ok, and then tackle your custom theme and modules. Paul 1 Link to comment Share on other sites More sharing options...
jeckyl Posted August 2, 2011 Share Posted August 2, 2011 Hi, if you want simply update your site with a backup (data & files) you can use our module : http://www.prestatoolbox.com/administrative-tools/70-automatic-update-of-prestashop.html You just use a spacific template for the new prestashop you install. Link to comment Share on other sites More sharing options...
Ulisses Ramos Posted August 2, 2011 Author Share Posted August 2, 2011 Just made a comparison of tables existing in 1.2.4 and 1.4.4 I still didn´t compare the content of each table 1.2.4_________________________________1.4.4 ps_access_____________________________ps_access ps_accessory__________________________ps_accessory ps_address____________________________ps_address ______________________________________ps_address_format ps_alias______________________________ps_alias ps_attachment_________________________ps_attachment ps_attachment_lang____________________ps_attachment_lang ps_attribute__________________________ps_attribute ps_attribute_group____________________ps_attribute_group ps_attribute_group_lang_______________ps_attribute_group_lang ps_attribute_impact___________________ps_attribute_impact ps_attribute_lang_____________________ps_attribute_lang ps_block_cms ps_carrier____________________________ps_carrier ______________________________________ps_carrier_group ps_carrier_lang_______________________ps_carrier_lang ps_carrier_zone_______________________ps_carrier_zone ps_cart ps_cart ps_cart_discount______________________ps_cart_discount ps_cart_product_______________________ps_cart_product ps_category___________________________ps_category ps_category_group_____________________ps_category_group ps_category_lang______________________ps_category_lang ps_category_product___________________ps_category_product ps_cms________________________________ps_cms ______________________________________ps_cms_block ______________________________________ps_cms_block_lang ______________________________________ps_cms_block_page ______________________________________ps_cms_category ______________________________________ps_cms_category_lang ps_cms_lang___________________________ps_cms_lang ______________________________________ps_compare_product ps_configuration______________________ps_configuration ps_configuration_lang_________________ps_configuration_lang ps_connections________________________ps_connections ps_connections_page___________________ps_connections_page ps_connections_source_________________ps_connections_source ps_contact____________________________ps_contact ps_contact_lang_______________________ps_contact_lang ps_country____________________________ps_country ps_country_lang_______________________ps_country_lang ______________________________________ps_county ______________________________________ps_county_zip_code ps_currency___________________________ps_currency ps_customer___________________________ps_customer ps_customer_group_____________________ps_customer_group ______________________________________ps_customer_message ______________________________________ps_customer_thread ps_customization______________________ps_customization ps_customization_field________________ps_customization_field ps_customization_field_lang___________ps_customization_field_lang ps_customized_data____________________ps_customized_data ps_date_range_________________________ps_date_range ps_delivery___________________________ps_delivery ps_discount___________________________ps_discount ps_discount_category__________________ps_discount_category ps_discount_lang______________________ps_discount_lang ps_discount_quantity ps_discount_type______________________ps_discount_type ps_discount_type_lang_________________ps_discount_type_lang ______________________________________ps_editorial ______________________________________ps_editorial_lang ps_employee___________________________ps_employee ps_feature____________________________ps_feature ps_feature_lang_______________________ps_feature_lang ps_feature_product____________________ps_feature_product ps_feature_value______________________ps_feature_value ps_feature_value_lang_________________ps_feature_value_lang ps_group______________________________ps_group ps_group_lang_________________________ps_group_lang ______________________________________ps_group_reduction ps_guest______________________________ps_guest ______________________________________ps_help_access ps_hook ps_hook ps_hook_module________________________ps_hook_module ps_hook_module_exceptions_____________ps_hook_module_exceptions ps_image______________________________ps_image ps_image_lang_________________________ps_image_lang ps_image_type_________________________ps_image_type ______________________________________ps_import_match ps_lang ps_lang ps_location_coords ps_log_email ps_loyalty ps_loyalty_history ps_loyalty_state ps_loyalty_state_lang ps_mailalert_customer_oos ______________________________________ps_log ps_manufacturer_______________________ps_manufacturer ps_manufacturer_lang__________________ps_manufacturer_lang ______________________________________ps_memcached_servers ps_message____________________________ps_message ps_message_readed_____________________ps_message_readed ps_meta ps_meta ps_meta_lang__________________________ps_meta_lang ps_module_____________________________ps_module ps_module_country_____________________ps_module_country ps_module_currency____________________ps_module_currency ps_module_group_______________________ps_module_group ps_newsletter ps_operating_system___________________ps_operating_system ps_orders_____________________________ps_orders ps_order_detail_______________________ps_order_detail ps_order_discount_____________________ps_order_discount ps_order_history______________________ps_order_history ps_order_message______________________ps_order_message ps_order_message_lang_________________ps_order_message_lang ps_order_return_______________________ps_order_return ps_order_return_detail________________ps_order_return_detail ps_order_return_state_________________ps_order_return_state ps_order_return_state_lang____________ps_order_return_state_lang ps_order_slip_________________________ps_order_slip ps_order_slip_detail__________________ps_order_slip_detail ps_order_state________________________ps_order_state ps_order_state_lang___________________ps_order_state_lang ps_pack ps_pack ps_page ps_page ps_pagenotfound_______________________ps_pagenotfound ps_page_type__________________________ps_page_type ps_page_viewed________________________ps_page_viewed ______________________________________ps_payment_cc ps_product____________________________ps_product ps_product_attachment_________________ps_product_attachment ps_product_attribute__________________ps_product_attribute ps_product_attribute_combination______ps_product_attribute_combination ps_product_attribute_image____________ps_product_attribute_image ______________________________________ps_product_country_tax ps_product_comment ps_product_comment_criterion ps_product_comment_criterion_product ps_product_comment_grade ps_product_download___________________ps_product_download ______________________________________ps_product_group_reduction_cache ps_product_lang_______________________ps_product_lang ps_product_sale_______________________ps_product_sale ps_product_tag________________________ps_product_tag ps_profile____________________________ps_profile ps_profile_lang_______________________ps_profile_lang ps_psf_fbconnect ps_quick_access_______________________ps_quick_access ps_quick_access_lang__________________ps_quick_access_lang ps_range_price________________________ps_range_price ps_range_weight_______________________ps_range_weight ps_ratings ps_referralprogram ps_referrer___________________________ps_referrer ps_referrer_cache_____________________ps_referrer_cache ______________________________________ps_required_field ps_scene______________________________ps_scene ps_scene_category_____________________ps_scene_category ps_scene_lang_________________________ps_scene_lang ps_scene_products_____________________ps_scene_products ps_search_engine______________________ps_search_engine ps_search_index_______________________ps_search_index ps_search_word________________________ps_search_word ps_sekeyword__________________________ps_sekeyword ps_shiptopay ______________________________________ps_specific_price ______________________________________ps_specific_price_priority ps_state______________________________ps_state ps_statssearch________________________ps_statssearch ______________________________________ps_stock_mvt ______________________________________ps_stock_mvt_reason ______________________________________ps_stock_mvt_reason_lang ______________________________________ps_store ps_subdomain__________________________ps_subdomain ps_supplier___________________________ps_supplier ps_supplier_lang______________________ps_supplier_lang ps_tab________________________________ps_tab ps_tab_lang___________________________ps_tab_lang ps_tag________________________________ps_tag ps_tax________________________________ps_tax ps_tax_lang___________________________ps_tax_lang ps_tax_state ps_tax_zone ______________________________________ps_tax_rule ______________________________________ps_tax_rules_group ps_timezone___________________________ps_timezone ______________________________________ps_webservice_account ______________________________________ps_webservice_permission ps_web_browser________________________ps_web_browser ps_wishlist ps_wishlist_email ps_wishlist_product ps_wishlist_product_cart ps_zone_______________________________ps_zone Link to comment Share on other sites More sharing options...
jeckyl Posted August 2, 2011 Share Posted August 2, 2011 And now you can compare all data format, index, and other .... Good luke to loose your time. You have only 1 methode to upgarde your shop. Make a manual upgarde or an automatic with our module. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now