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?
Exporting database when migrating from Joomla 1.5 to 2.5
-
- Phoca Newbie
- Posts: 6
- Joined: 18 Feb 2013, 08:47
-
- Phoca Newbie
- Posts: 6
- Joined: 18 Feb 2013, 08:47
Re: Exporting database when migrating from Joomla 1.5 to 2.5
Not sure how to proceed here. 

-
- Phoca Member
- Posts: 39
- Joined: 03 Jul 2008, 13:30
Re: Exporting database when migrating from Joomla 1.5 to 2.5
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.
Please show what kind of errors did you get when trying to import to J2.5.
-
- Phoca Newbie
- Posts: 6
- Joined: 18 Feb 2013, 08:47
Re: Exporting database when migrating from Joomla 1.5 to 2.5
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
--
-- 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
- Jan
- 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
Hi, did you follow all the steps in migration manual exactly? ... This seems like the table is not the newest 

If you find Phoca extensions useful, please support the project