Migration from 3.4.3

It feels like I'm getting closer.

I see the data in phpmyadmin now but get errors when I browse to the component (I replaced my true prefix with xxxxx_.



1054 Unknown column 'speakers.state' in 'where clause' 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 xxxxx_sermon_speakers AS speakers LEFT JOIN xxxxx_categories AS c_speakers ON c_speakers.id = speakers.catid WHERE speakers.state = 1 ORDER BY speakers.name


AND


Error
Unknown column 'speakers.language' in 'field list' SQL=SELECT speakers.id, speakers.name, 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,l.title AS language_title,uc.name AS editor,c.title AS category_title FROM `xxxxx_sermon_speakers` AS speakers LEFT JOIN `xxxxx_languages` AS l ON l.lang_code = speakers.language LEFT JOIN xxxxx_users AS uc ON uc.id = speakers.checked_out LEFT JOIN xxxxx_categories AS c ON c.id = speakers.catid WHERE (speakers.state IN (0, 1)) ORDER BY speakers.name asc Unknown column 'speakers.language' in 'field list' SQL=SELECT speakers.id, speakers.name, 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,l.title AS language_title,uc.name AS editor,c.title AS category_title FROM `xxxxx_sermon_speakers` AS speakers LEFT JOIN `xxxxx_languages` AS l ON l.lang_code = speakers.language LEFT JOIN xxxxx_users AS uc ON uc.id = speakers.checked_out LEFT JOIN xxxxx_categories AS c ON c.id = speakers.catid WHERE (speakers.state IN (0, 1)) ORDER BY speakers.name asc LIMIT 0, 20 Unknown column 'speakers.language' in 'field list' SQL=SELECT speakers.id, speakers.name, 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,l.title AS language_title,uc.name AS editor,c.title AS category_title FROM `xxxxx_sermon_speakers` AS speakers LEFT JOIN `xxxxx_languages` AS l ON l.lang_code = speakers.language LEFT JOIN xxxxx_users AS uc ON uc.id = speakers.checked_out LEFT JOIN xxxxx_categories AS c ON c.id = speakers.catid WHERE (speakers.state IN (0, 1)) ORDER BY speakers.name asc



AND





Error

Unknown column 'series.language' in 'field list' SQL=SELECT series.id, series.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,l.title AS language_title,uc.name AS editor,c.title AS category_title FROM `xxxxx_sermon_series` AS series LEFT JOIN `xxxxx_languages` AS l ON l.lang_code = series.language LEFT JOIN xxxxx_users AS uc ON uc.id = series.checked_out LEFT JOIN xxxxx_categories AS c ON c.id = series.catid WHERE (series.state IN (0, 1)) ORDER BY series.series_title asc Unknown column 'series.language' in 'field list' SQL=SELECT series.id, series.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,l.title AS language_title,uc.name AS editor,c.title AS category_title FROM `xxxxx_sermon_series` AS series LEFT JOIN `xxxxx_languages` AS l ON l.lang_code = series.language LEFT JOIN xxxxx_users AS uc ON uc.id = series.checked_out LEFT JOIN xxxxx_categories AS c ON c.id = series.catid WHERE (series.state IN (0, 1)) ORDER BY series.series_title asc LIMIT 0, 20 Unknown column 'series.language' in 'field list' SQL=SELECT series.id, series.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,l.title AS language_title,uc.name AS editor,c.title AS category_title FROM `xxxxx_sermon_series` AS series LEFT JOIN `xxxxx_languages` AS l ON l.lang_code = series.language LEFT JOIN xxxxx_users AS uc ON uc.id = series.checked_out LEFT JOIN xxxxx_categories AS c ON c.id = series.catid WHERE (series.state IN (0, 1)) ORDER BY series.series_title asc

Try to install SermonSpeaker over the existing installation, without uninstalling first. The installer should detect those missing files and apply the needed changes.

I've never done an uninstalled before an install. That would have deleted the tables in the database.

I tried it again and get the same results.

The error means that the database tables are not up to date.

The install script should check the tables and apply the migration script if needed.
You can do this manually if for some reason the check fails. In the install package, there is a migrate.sql file. If you open this, you see a lot of SQL commands. You need to manually replace the prefix "#__" with the one used in your database and then you can use these commands within phpMyAdmin.

I'm still getting conflicting database errors, for example:

SQL query:

ALTER TABLE fkgdx_sermon_sermons CHANGE `published` `state` TINYINT( 3 ) NOT NULL DEFAULT '0';

MySQL said: Documentation
#1054 - Unknown column 'published' in 'fkgdx_sermon_sermons'

It seems I'm chasing my tail here. My guess is that it's the move from GoDaddy (which uses old versions php and mysql) to a real host. GoDaddy has been notorious for causing so many headaches for Joomla and other php based frameworks. Not that I have clue about any of this, it's just been my experience.

Then it looks like some of the changes are already done in your installation. You can try to leave out the lines causing the problem and try to apply the other ones.
Or you can start over completely fresh by uninstalling SermonSpeaker, manually deleting all SermonSpeaker tables if there are some left and then try again following the step-by-step guide from the FAQ. Or you can email me access to your backend and phpMyAdmin and I can do it for you (for free).