Cannot install SermonSpeaker 2.5.4 to new J 2.5

I am finally migrating our site from Joomla 1.4 to 2.5, and cannot execute the first step in the SermonSpeaker migration. Here's what install tells me:

JInstaller: :Install: Error SQL DB function failed with error number 1064
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 '' at line 18 SQL=CREATE TABLE `xyz_sermon_speakers` ( `id` INT(10) NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL, `alias` VARCHAR(255) NOT NULL, `website` TEXT, `intro` MEDIUMTEXT, `bio` MEDIUMTEXT, `pic` TEXT, `state` TINYINT(3) NOT NULL DEFAULT '0', `home` TINYINT(3) NOT NULL DEFAULT '0', `ordering` INT(11) NOT NULL DEFAULT '0', `hits` INT(10) NOT NULL DEFAULT '0', `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by` INT(10) NOT NULL DEFAULT '0', `catid` INT(10) NOT NULL DEFAULT '0', `metakey` TEXT NOT NULL, `metadesc` TEXT NOT NULL, `checked_out` INT(11) NOT NULL DEFAULT '0';
SQL =

CREATE TABLE `#__sermon_speakers` (
`id` INT(10) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`alias` VARCHAR(255) NOT NULL,
`website` TEXT,
`intro` MEDIUMTEXT,
`bio` MEDIUMTEXT,
`pic` TEXT,
`state` TINYINT(3) NOT NULL DEFAULT '0',
`home` TINYINT(3) NOT NULL DEFAULT '0',
`ordering` INT(11) NOT NULL DEFAULT '0',
`hits` INT(10) NOT NULL DEFAULT '0',
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_by` INT(10) NOT NULL DEFAULT '0',
`catid` INT(10) NOT NULL DEFAULT '0',
`metakey` TEXT NOT NULL,
`metadesc` TEXT NOT NULL,
`checked_out` INT(11) NOT NULL DEFAULT '0';

Component Install: SQL error file DB function failed with error number 1064
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 '' at line 18 SQL=CREATE TABLE `xyz_sermon_speakers` ( `id` INT(10) NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL, `alias` VARCHAR(255) NOT NULL, `website` TEXT, `intro` MEDIUMTEXT, `bio` MEDIUMTEXT, `pic` TEXT, `state` TINYINT(3) NOT NULL DEFAULT '0', `home` TINYINT(3) NOT NULL DEFAULT '0', `ordering` INT(11) NOT NULL DEFAULT '0', `hits` INT(10) NOT NULL DEFAULT '0', `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by` INT(10) NOT NULL DEFAULT '0', `catid` INT(10) NOT NULL DEFAULT '0', `metakey` TEXT NOT NULL, `metadesc` TEXT NOT NULL, `checked_out` INT(11) NOT NULL DEFAULT '0';
SQL =

CREATE TABLE `#__sermon_speakers` (
`id` INT(10) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`alias` VARCHAR(255) NOT NULL,
`website` TEXT,
`intro` MEDIUMTEXT,
`bio` MEDIUMTEXT,
`pic` TEXT,
`state` TINYINT(3) NOT NULL DEFAULT '0',
`home` TINYINT(3) NOT NULL DEFAULT '0',
`ordering` INT(11) NOT NULL DEFAULT '0',
`hits` INT(10) NOT NULL DEFAULT '0',
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_by` INT(10) NOT NULL DEFAULT '0',
`catid` INT(10) NOT NULL DEFAULT '0',
`metakey` TEXT NOT NULL,
`metadesc` TEXT NOT NULL,
`checked_out` INT(11) NOT NULL DEFAULT '0';

Package Install: There was an error installing an extension: com_sermonspeaker.zip

My environment:

...

Is the problem on my end or SermonSpeakers?

I'll have to try it out first myself which I will do later today. But from a first look it seems that you installed SermonSpeaker 4.4.2. But the migration steps states you need to install SermonSpeaker 4.0 for the migration. Every other package may or may not work since it's not tested.

So please try to do it with SermonSpeaker 4.0 and then upgrade it later if the migration is done. Tell me if that worked.

I'll see if I can figure out what happend with SermonSpeaker 4.4.2

There was indeed a bug in the SQL statement in SermonSpeaker 4.4.2. It's fixed in the package and component zip now. You can download it again and it should work now.
The bug only appeared if you installed SermonSpeaker the first time. Upgrading from a previous version worked fine.

Still, for a migration please use SermonSpeaker 4.0 as this is the tested way.

Thanks - your correction did allow me to install.

Here's a brief progress report on the migration - I'm not quite there yet:
I migrated from SS 3.4.3 on Joomla 1.5 to SS 4.4.2 on Joomla 2.5.4. I first installed SS v4.0 on the Joomla 2.5.4 site, imported database records from the 1.5 site, then re-installed SS v4.0. All seemed to go well - except that categories were not retained (where are they stored, anyway?). I then installed SS 4.4.2, and everything looked good from the back-end (except categories). However, from the front-end, no sermons show up in the sermon list. Sermons do show up latest-sermons module, but display "No resource found".

Any idea where to look for the no-sermons-in-the-list problem? (You can see at fumcquitman.org/j25 / Worship / Sermons, Latest-Sermons module temporarily in the upper right of the page.)

Unfortunately categories can't be migrated easily because Joomla changed fundamentally how they work. You need to recreate them and relink.

They are stored in the database in the #__categories table. The managing is done by the core component com_categories, the category manager you see inside SermonSpeaker is in fact this com_categories which is loaded there.

About why the sermons do not show
Can you maybe check if there are error messages in your error logfile. Or maybe enable error reporting in the Joomla Global Configuration -> Server. Set it to "Maximum" and see if there is an error thrown. My suspect is that for some reason something goes wrong with the database query.

Turned error reporting to maximum, and no errors appear. Nothing shows in error.log related to Sermon Speaker.