• eCommerce
  • Social and Community Suite
  • Content Management
  • RSS Extensions
  • VirtueMart Extensions
Follow us on Twitter   Join The Factory on the New Digg  
(0) | Login | Register | Lost Password?
Username: Password:  
Home
Our Products
Joomla 1.7.x  (23) & J!1.6.x
Joomla 1.5.x (28)
Joomla 1.0.x (17)
Factory Club Extensions (7)
Drupal, Elxis, MODx (6)
Windows Gadgets for J! (11)
Free Templates (4)
All Products (92)
Documentation
Tweets
Forum
Contact Us
Terms & Conditions
How to Buy Guide
Customers FAQ's
Updates & Upgrades
About Us
The Factory Demo Server for Joomla Extensions
Money Back Guarantee
Payment Methods for Joomla Extensions
Follow us on Facebook

Latest Tweets

  • Join us at the Joomladay UK!
  • The Factory Extensions Joomla Compatibility Chart
  • Love Factory 2.4 for Joomla 1.7
  • Love Factory - Memberships [VIDEO]
  • Love Factory - Custom Fields Integration [VIDEO]
  • Love Factory - Google Maps Integration [VIDEO]
  • Love Factory - Administrator Guide [VIDEO]
  • Love Factory - Memberships
  • Collection Factory for Joomla 1.6 with CB support
  • Reverse Auction Factory 1.5.9
 
   Home   Help Search Login Register  
The Factory > Forum > Content Management Suite for Joomla CMS. > eBook Factory > Upgrading from version 1.6.0 to 1.6.3 and transferring my settings
Pages: [1]
« previous next »
  Print  
Author Topic: Upgrading from version 1.6.0 to 1.6.3 and transferring my settings  (Read 1147 times)
philscanlan
Newbie
*
Posts: 2


View Profile
Upgrading from version 1.6.0 to 1.6.3 and transferring my settings
« on: July 23, 2010, 07:19:30 pm »

Hi,

I would like to upgrade from my current version 1.6.0 to 1.6.3 but I would like to transfer my settings and documents across to the new version.

I was advised to try an environment back and then transfer the files back over but this has not worked.

Can you suggest a process that I can try to make this work?

Thank you in advance for your assistance.
Logged
alex.d
The Factory Staff
Hero Member
*
Posts: 1469


Senior Developer


View Profile WWW
Re: Upgrading from version 1.6.0 to 1.6.3 and transferring my settings
« Reply #1 on: July 26, 2010, 09:57:26 am »

Hello!

First of all, make sure you BACKUP in case something goes wrong!

1. Using an application like phpmyadmin, export the tables (only the data and not the table creation part) from 1.6.0.: #__ebooks and #__ebooks_items (replace #__ with your Joomla database prefix).

You should have something like this (in my case the database prefix is jos_):

Quote
INSERT INTO `jos_ebooks` (`id`, `name`, `storage_place`, `description`, `cover_jpg`, `cover_html`, `copyright_page`, `credits_page`, `ack_page`, `introduction_page`, `introduction_section`, `index_page`, `version`, `opt_cover`, `opt_toc`, `opt_chapternumbering`, `opt_subchapternumbering`, `opt_usesection`, `opt_usecategory`, `opt_useitem`, `last_render`, `font_main`, `font_main_size`, `font_chapter`, `font_chapter_size`, `font_subchapter`, `font_subchapter_size`, `font_header`, `font_header_size`, `font_pageno`, `font_pageno_size`, `img_align`, `text_align`, `pageno_align`, `opt_ch_page`, `opt_subch_page`, `opt_heading`, `columns`, `opt_page_format`, `opt_left_margin`, `opt_right_margin`, `opt_top_margin`, `opt_bottom_margin`, `opt_unit`, `opt_chapter_font_color`, `opt_chapter_headline_bg_color`, `opt_main_font_color`, `opt_subchapter_font_color`, `opt_header_font_color`, `opt_pageno_font_color`, `opt_orientation`, `opt_custom_width`, `opt_custom_height`, `opt_mambot`, `opt_user_password`, `opt_admin_password`, `opt_lockpdf`, `opt_link_color`, `user_id`) VALUES
(1,   'Ebook 160',   'RjpcZWJvb2tzXzE2MFxhZG1pbmlzdHJhdG9yXGNvbXBvbmVudHNcY29tX2Vib29rc1xzdG9yYWdlXA==',   'Cras et metus non lectus venenatis dictum sed at magna. Quisque sodales, libero suscipit dictum sed.',   NULL,   '',   '',   '',   '',   '',   NULL,   '',   '',   1,   1,   1,   1,   1,   1,   1,   '2010-07-26 10:40:42',   'courier',   12,   'courier',   14,   'courier',   13,   'courier',   '11',   'courier',   '10',   'left',   'left',   'right',   1,   1,   'no',   1,   'a4',   11,   12,   13,   14,   'mm',   '',   '',   '',   '',   '',   '',   'P',   '',   '',   0,   '',   '',   0,   '',   62);

INSERT INTO `jos_ebooks_items` (`id`, `bookid`, `sectionid`, `catid`, `itemid`, `itemorder`, `type`) VALUES
(1,   1,   1,   1,   1,   1,   'content'),
(2,   1,   1,   1,   6,   2,   'content'),
(3,   1,   1,   1,   9,   3,   'content'),
(4,   1,   1,   1,   44,   4,   'content'),
(5,   1,   1,   1,   45,   5,   'content');

2. Uninstall version 1.6.0.

3. Install version 1.6.3.

4. Using phpmyadmin again, import the content from step 1.

This way all your ebooks (only the settings and items and not the PDF's files; you'll have to render the ebooks again) will be transfered to 1.6.3.
Logged

The Factory's Development Team member.
Pages: [1]
  Print  
« previous next »
 
Jump to:  

Loading...
Joomla Extension - RSS Factory Manager  Joomla Extension - EBook Factory  Joomla Extension - Briefcase Factory  Joomla Extension - Auctions Factory  Joomla Module - RSS Contextual  Joomla Module - Exchange Factory (Europe / EURO)  Joomla Module - Exchange Factory (Romania/ RON)  Joomla Custom Extensions Development   Free Joomla Extensions  Joomla Extension - RSS Factory Pro (Enhanced Version)  Joomla Virtuemart Payment Plugin - Gecad (EPayment.ro)  Joomla Module - Mosimage / Image Module  Joomla Extension - Reverse Auction Factory (Lowest Bidder Auctions)  Joomla Extension - Article Factory Manager  Joomla Module - Lavalamp Menu  Joomla Module - RSS Image Extractor  Joomla Module - Exchange Factory (Europe / EURO) for Joomla 1.0.15  Joomla Module - Exchange Factory (Romania / RON) for Joomla 1.0.15  Joomla Module - Top Movies (IMDB)   Joomla Module - EBay Latest Auctions  Auction Factory Standalone PHP script