Phoca Forum

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?

Not sure how to proceed here.

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.

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

Hi, did you follow all the steps in migration manual exactly? ... This seems like the table is not the newest