SP Live Sports Database Error
Robert
Hi,
After initially installing SP Live Sports quickstart v1.0.1, I received an update notification callout for SP Soccer template. After I applied the template update; com_spsoccer_fullpackage_v2.1.0.zip, I received the following error.
* Table 'pmmt01_spsoccer_polloptions' has the wrong type or attributes for column
'published' with type tinyint. (From file 2.0.0-2022-07-05.sql.)
* 109 database changes were checked.
* 0 database changes did not alter table structure and were skipped. I reinstalled SP Live Sports quickstart and checked this DB entry for any variation from the SP Soccer template updated DB entry and found them to be identicle entries. No idea what the issue is at this point.
Regards.
Robert
Accepted AnswerHi,
After some digging around in the 2.0.0-2022-07-05.sql file, I found that these two lines shared similar DB entry notations but were notably different. The original Line 121 entry was creating the error that I noted above. The former DB error was removed upon making the change noted below.
Line 110 (Comparative SQL entry):
ALTER TABLE `#__spsoccer_polls` CHANGE `enabled` `published` tinyint(1) NOT NULL DEFAULT '1';Line 121 (Original SQL entry creating error callout):
ALTER TABLE `#__spsoccer_polloptions` CHANGE `enabled` `published` tinyint(1) NULL DEFAULT '1';Line 121 (My updated SQL entry; Error removed):
ALTER TABLE `#__spsoccer_polloptions` CHANGE `enabled` `published` tinyint(1) NOT NULL DEFAULT '1';Regards.
