WP2Joomla (Wordpress to Joomla Converter) has been updated
16 Jan, 2009 | Written by
Dan) | under Uncategorized
Dan) | under Uncategorized I have made a change to the Wordpress to Joomla converter that allows you tochoose not to import comments. This is a small change to the config.php and content.php file. I also need to remove the debugging from the content.php page which has been rolled into this version.
The download link on the downloads page links to the new wp2joomla.zip file
| 2.1 |






Currently working as a Technical Support Manager, I have some 5+ years experience as a PHP coder, and am here to share my experiences and ideas with you all. Whilst I no longer code full time, I often write snippets to help with day to day work, that I am sure you will find useful.


Megos (Who am I?)
1 year ago
Hello! Thx for your script, but I have some problems…
Initialised WP DB
Initialised JOS DB
Created Category Map table
Categories Selected from WP
Warning: Invalid argument supplied for foreach() in /home/***/wp2Joomla/categories.php on line 52
Your Categories have now been imported, Please check these in Joomla before proceeding to the next step.
After that all categories imported in Joomla, but writen in “???”. My sites in russian language. WP base in UTF-8, Joomla base in UTF-8 too.
—————-
And then must imported content, I recive:
Warning: Table ‘777news_jbase.wp_posts’ doesn’t exist in /home/***/wp2Joomla/db/ez_sql_mysql.php on line 204
Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘and post_status=’publish’ or post_status=’draft’ order by ID ASC LIMIT 20′ at line 1 in /home/***/wp2Joomla/db/ez_sql_mysql.php on line 204
ezSQL (v2.03) Debug..
Last Error — [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and post_status='publish' or post_status='draft' order by ID ASC LIMIT 20' at line 1]
Query [1] — [Select ID, post_author, post_date, post_content, post_title, post_parent, post_excerpt, post_status, post_name, post_modified from wp_posts where ID> and post_status='publish' or post_status='draft' order by ID ASC LIMIT 20]
Query Result..
No Results
Warning: Invalid argument supplied for foreach() in /home/***/wp2Joomla/content.php on line 130
Import of Content and Comments complete. Now for the cleanup
Content doesn`t imported.
How I can fix it?
Megos (Who am I?)
1 year ago
WP version 2.7.1 , Joomla version 1.5.9
Dan (Who am I?)
1 year ago
Looks like there were database changes in 2.7. I will be working on this week to try to get it working for you guys.
Dan
Dan (Who am I?)
1 year ago
I jsut retested this with the exact same versions and did no get the error, can you please confirm the following.
It looks like you have configured the converter incorrectly.
“777news_jbase.wp_posts” looks like you have put the Joomla prefix in as the Wordpress prefix. What is the prefix for your Wordpress database, because as the error says it looks like the table 777news_jbase.wp_posts does not exist
All of your other errors will stem from this original error