Exporting database when migrating from Joomla 1.5 to 2.5

Phoca Download - download manager
dbranmn
Phoca Newbie
Phoca Newbie
Posts: 6
Joined: 18 Feb 2013, 08:47

Exporting database when migrating from Joomla 1.5 to 2.5

Post by dbranmn »

I have tried following your instructions on "How to Migrate Extensions from Joomla! 1.5 to Joomla! 2.5 (1.7)", but ended up getting errors when importing the .sql file into Joomla 2.5. I'm not sure I exported the files from Joomla 1.5 correctly. My phpMyAdmin application is in a different format than what you explain and the options are as follows. I'm not that familiar with databases to understand which options to select. Could someone help me to know which of the following to select?
Structure
___Add DROP TABLE / VIEW / PROCEDURE / FUNCTION
___Add IF NOT EXISTS
___Add AUTO_INCREMENT value
___Enclose table and field names with backquotes
___Add CREATE PROCEDURE / FUNCTION
Add into comments
___Creation/Update/Check dates
Data
___Complete inserts
___Extended inserts
Maximal length of created query 50000
___Use delayed inserts
___Use ignore inserts
___Use hexadecimal for BLOB
Export type - INSERT, UPDATE OR REPLACE?
dbranmn
Phoca Newbie
Phoca Newbie
Posts: 6
Joined: 18 Feb 2013, 08:47

Re: Exporting database when migrating from Joomla 1.5 to 2.5

Post by dbranmn »

Not sure how to proceed here. :(
gray
Phoca Member
Phoca Member
Posts: 39
Joined: 03 Jul 2008, 13:30

Re: Exporting database when migrating from Joomla 1.5 to 2.5

Post by gray »

These inscructions https://www.phoca.cz/documents/50-phoca/ ... -joomla-25 are rather detailed.
Please show what kind of errors did you get when trying to import to J2.5.
dbranmn
Phoca Newbie
Phoca Newbie
Posts: 6
Joined: 18 Feb 2013, 08:47

Re: Exporting database when migrating from Joomla 1.5 to 2.5

Post by dbranmn »

SQL query:

--
-- Database: 'tom1029409033069'
--
--
-- Dumping data for table 'cmeg1_phocadownload'
--
INSERT INTO cmeg1_phocadownload
VALUES ( 1, 1, 1, 62, 0, '01 Snow Bird', '01-snow-bird', 'userupload/83f021a78f/01 Snow Bird.mp3', 4615969, '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '2010-10-21 21:43:20', '2010-10-21 21:43:20', '0000-00-00 00:00:00', 1, 0, 1, 1, 0, '0000-00-00 00:00:00', 1, 1, -1, 1, NULL , '', '' ) ;

MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48587
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Exporting database when migrating from Joomla 1.5 to 2.5

Post by Jan »

Hi, did you follow all the steps in migration manual exactly? ... This seems like the table is not the newest :idea:
If you find Phoca extensions useful, please support the project
Post Reply