Moving from 2.5 to 3.4

I've read posts about this, but my question isn't answered.

Old site is on: Joomla 2.5.8
New site is on: Joomla 3.4.1

On the new site I upload Sermon Speaker version that was on the old site: com_sermonspeaker458

I go into the myPHPAdmin for the old site and locate all the files starting with #_sermon_


I go to the NEW site's myPHPAdmin and locate the files there:


I Notice that the prefix on both is different (jos on the old site and......r0uxc on the new)

Anyway, I drop the r0uxc_sermon files from the new site
And I import the jos_sermon files from the old site

When I import the jos_sermon files from the old site....I get an error

An error has occurred.
1146 Table 'pamdemo_data.r0uxc_sermon_speakers' doesn't exist SQL=SELECT speakers.id As value,CASE WHEN CHAR_LENGTH(c_speakers.title) THEN CONCAT(speakers.name, " (", c_speakers.title, ")") ELSE speakers.name END AS text FROM r0uxc_sermon_speakers AS speakers LEFT JOIN r0uxc_categories AS c_speakers ON c_speakers.id = speakers.catid WHERE speakers.state = 1 ORDER BY speakers.name

Yeah, the different prefix is what is causing the issue.
You need to adjust the tablenames so they contain the new prefix. You can do that in phpMyAdmin. Click on the table and then select "Operations", there you can rename the table without losing any data.

Hi Thomas

1. I uploaded SermonSpeaker 4.5 onto my Joomla 3 site.
2. I renamed the tables in my Joomla 3 site to the old table name...... jos_sermon_etc
3. I exported the old tables from my Joomla 2.5 to the Joomla 3 site
4. I renamed the imported tables back to the extension of my new site ......g9w_sermon_etc.

I can see the data in the tables...but when I go to my site and click on SermonSpeaker and look at the Sermon manager, I get this error:
Unknown column 'speakers.title' in 'field list' SQL=SELECT speakers.id As value,CASE WHEN CHAR_LENGTH(c_speakers.title) THEN CONCAT(speakers.title, " (", c_speakers.title, ")") ELSE speakers.title END AS text FROM g9w_sermon_speakers AS speakers LEFT JOIN g9w_categories AS c_speakers ON c_speakers.id = speakers.catid WHERE speakers.state = 1 ORDER BY speakers.title

When I click on the Speaker Manager, I get:
Unknown column 'speakers.title' in 'field list' SQL=SELECT speakers.id, speakers.title, speakers.catid, speakers.created_by, speakers.language, speakers.hits, speakers.home, speakers.pic, speakers.website, speakers.alias, speakers.state, speakers.ordering, speakers.checked_out, speakers.checked_out_time, speakers.publish_up, speakers.publish_down,l.title AS language_title,uc.name AS editor,ua.name AS author_name,c.title AS category_title FROM `g9w_sermon_speakers` AS speakers LEFT JOIN `g9w_languages` AS l ON l.lang_code = speakers.language LEFT JOIN g9w_users AS uc ON uc.id = speakers.checked_out LEFT JOIN g9w_users AS ua ON ua.id = speakers.created_by LEFT JOIN g9w_categories AS c ON c.id = speakers.catid WHERE (speakers.state IN (0, 1)) ORDER BY speakers.title asc LIMIT 0, 20

When I click on Series Manager, I get:
Unknown column 'series.title' in 'field list' SQL=SELECT series.id, series.title, series.catid, series.language, series.hits, series.home, series.alias, series.avatar, series.state, series.ordering, created_by, series.checked_out, series.checked_out_time, series.publish_up, series.publish_down,l.title AS language_title,uc.name AS editor,ua.name AS author_name,c.title AS category_title FROM `g9w_sermon_series` AS series LEFT JOIN `g9w_languages` AS l ON l.lang_code = series.language LEFT JOIN g9w_users AS uc ON uc.id = series.checked_out LEFT JOIN g9w_users AS ua ON ua.id = series.created_by LEFT JOIN g9w_categories AS c ON c.id = series.catid WHERE (series.state IN (0, 1)) ORDER BY series.title asc LIMIT 0, 20

What did I do wrong?
Pam

After you copied the tables, you need to install SermonSpeaker 4.5 again over the existing installation. Then it will detect the tables and adjust them as needed.
There will be a message stating so.

OK. I did that....just reinstalled 4.5 and the same errors are coming up.

Ah sorry, I missed that you were updating from a Joomla 2.5 site. I assumed you are updating from Joomla 1.5.

The latest version available for Joomla 2.5 is SermonSpeaker 4.5.8. This version works both in Joomla 2.5 and Joomla 3. Which means you update your SermonSpeaker in Joomla 2.5 to SermonSpeaker 4.5.8 and install the same version in Joomla 3. Then copy the tables over and adjust the prefix and all is fine.
After that, update to the latest SermonSpeaker version in Joomla 3 using the Joomla Extension Manager.

Even more simple would be to make a backup of the existing Joomla 2.5 site (eg using Akeeba Backup) and restore it in a new location. Then update that new installation and its extension to Joomla 3 using the Joomla Updater and the Extension Manager.