Solved Templates

SP Live Sports Database Error

Asked by Robert 3 years ago Last activity 3 years ago

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.

Accepted answer

Marked as the solution
Robert Asked this
3 years ago · edited

Hi,

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.

1 more reply

Rashida Rahman Staff
3 years ago

Hello Robert,

Thanks for sharing your experience with us.

Hopefully, it will help others.

Best Regards

Log in to reply.