Support Forums

Support Online : Mon - Fri / 10am - 6pm (GMT +6)

Your Time: Our Time:

SP Kindergarten not working after upgrade

Featured Lock Resolved
Hi,

SP Kindergarten not working after upgrade to v. 2.1

An error has occurred when I click "Components / SP Kindergarten" on the Admin.
0 Invalid controller: name='', format=''


Joomla! v. 3.8.12
PHP v. 7.2.8

8 Answers

Rifat Wahid Alif - Staff

More than a month ago #Permalink
Hi,
Thanks for your reply. We need to check first from where the problem coming, You can do a thing, could you please try to update SQL:


--Changes of table #__spkgarten_classes
ALTER TABLE `#__spkgarten_classes` CHANGE COLUMN `spkgarten_class_id` `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
ALTER TABLE `#__spkgarten_classes` CHANGE COLUMN `slug` `alias` VARCHAR(255) NOT NULL DEFAULT '';
ALTER TABLE `#__spkgarten_classes` CHANGE COLUMN `enabled` `published` TINYINT(3) NOT NULL DEFAULT '1';
ALTER TABLE `#__spkgarten_classes` CHANGE COLUMN `created_on` `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `#__spkgarten_classes` CHANGE COLUMN `modified_on` `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `#__spkgarten_classes` CHANGE COLUMN `locked_by` `checked_out` bigint(20) NOT NULL DEFAULT '0';
ALTER TABLE `#__spkgarten_classes` CHANGE COLUMN `locked_on` `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';

--Changes of table #__spkgarten_courses
ALTER TABLE `#__spkgarten_courses` CHANGE COLUMN `spkgarten_course_id` `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
ALTER TABLE `#__spkgarten_courses` CHANGE COLUMN `spkgarten_class_id` `class_id` bigint(20) unsigned NOT NULL;
ALTER TABLE `#__spkgarten_courses` CHANGE COLUMN `slug` `alias` VARCHAR(255) NOT NULL DEFAULT '';
ALTER TABLE `#__spkgarten_courses` CHANGE COLUMN `enabled` `published` TINYINT(3) NOT NULL DEFAULT '1';
ALTER TABLE `#__spkgarten_courses` CHANGE COLUMN `created_on` `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `#__spkgarten_courses` CHANGE COLUMN `modified_on` `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `#__spkgarten_courses` CHANGE COLUMN `locked_by` `checked_out` bigint(20) NOT NULL DEFAULT '0';
ALTER TABLE `#__spkgarten_courses` CHANGE COLUMN `locked_on` `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';

--Changes of table #__spkgarten_events
ALTER TABLE `#__spkgarten_events` CHANGE COLUMN `spkgarten_event_id` `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
ALTER TABLE `#__spkgarten_events` CHANGE COLUMN `kgarten_eventcategory_id` `category_id` bigint(20) unsigned NOT NULL;
ALTER TABLE `#__spkgarten_events` CHANGE COLUMN `slug` `alias` VARCHAR(255) NOT NULL DEFAULT '';
ALTER TABLE `#__spkgarten_events` CHANGE COLUMN `enabled` `published` TINYINT(3) NOT NULL DEFAULT '1';
ALTER TABLE `#__spkgarten_events` CHANGE COLUMN `created_on` `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `#__spkgarten_events` CHANGE COLUMN `modified_on` `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `#__spkgarten_events` CHANGE COLUMN `locked_by` `checked_out` bigint(20) NOT NULL DEFAULT '0';
ALTER TABLE `#__spkgarten_events` CHANGE COLUMN `locked_on` `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';

--Changes of table #__spkgarten_speakers
ALTER TABLE `#__spkgarten_speakers` CHANGE COLUMN `spkgarten_speaker_id` `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
ALTER TABLE `#__spkgarten_speakers` CHANGE COLUMN `slug` `alias` VARCHAR(255) NOT NULL DEFAULT '';
ALTER TABLE `#__spkgarten_speakers` CHANGE COLUMN `enabled` `published` TINYINT(3) NOT NULL DEFAULT '1';
ALTER TABLE `#__spkgarten_speakers` CHANGE COLUMN `created_on` `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `#__spkgarten_speakers` CHANGE COLUMN `modified_on` `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `#__spkgarten_speakers` CHANGE COLUMN `locked_by` `checked_out` bigint(20) NOT NULL DEFAULT '0';
ALTER TABLE `#__spkgarten_speakers` CHANGE COLUMN `locked_on` `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `#__spkgarten_speakers` ADD COLUMN `language` VARCHAR(25) NOT NULL DEFAULT '*' AFTER `published`;

--Changes of table #__spkgarten_teachers
ALTER TABLE `jos_spkgarten_teachers` CHANGE COLUMN `spkgarten_teacher_id` `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
ALTER TABLE `jos_spkgarten_teachers` CHANGE COLUMN `slug` `alias` VARCHAR(255) NOT NULL DEFAULT '';
ALTER TABLE `jos_spkgarten_teachers` CHANGE COLUMN `enabled` `published` TINYINT(3) NOT NULL DEFAULT '1';
ALTER TABLE `jos_spkgarten_teachers` CHANGE COLUMN `created_on` `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `jos_spkgarten_teachers` CHANGE COLUMN `modified_on` `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `jos_spkgarten_teachers` CHANGE COLUMN `locked_by` `checked_out` bigint(20) NOT NULL DEFAULT '0';
ALTER TABLE `jos_spkgarten_teachers` CHANGE COLUMN `locked_on` `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';

--Changes of table #__spkgarten_media
ALTER TABLE `#__spmedia` CHANGE COLUMN `created_on` `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `#__spmedia` CHANGE COLUMN `modified_on` `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';


NB: replace #_ to your database prefix and please take a database backup before the update.

- Thanks

Rifat Wahid Alif - Staff

More than a month ago #Permalink
Hi,
Sorry for your inconvenience. We have checked by update SP Kindergarten component from the previous version, Everything is working perfectly there. Could you please mention your previous SP Kindergarten component version? if possible then pm me your administrative panel (cPanel) access for the faster fix.

- Thanks

Grzegorz

More than a month ago #Permalink
Hi,
my previous SP Kindergarten component version is 1.3 (l had to downgrade this component on my site, because error occured on the public Site as well).

I'm sorry, but it isn't possible to sent you access to my cPanel...
I know MySQL and PHP, so I can also make a quick fix - just write me how :)

Grzegorz

More than a month ago #Permalink
Hi,
Thanks for answer, but it strange...
I've reached the goal without using your SQL ;)

In your SQL is:

--Changes of table #__spkgarten_teachers
ALTER TABLE `jos_spkgarten_teachers`


Which prefix is correct: '#__' (my prefix) or 'jos_'?


I update SP Kindergarten from 1.3 to 2.1 and I get an error:
".... Table '...jos_spkgarten_teachers' doesn't exist."
It's true - I have 'myprefix_spkgarten_teachers' table, not 'jos_spkgarten_teachers'.

If I change table name to 'jos_spkgarten_teachers' and run the update again - update to v.2.1 finished with no errors. :)

But if I try on the Site display details of kindergarten group - I get an error:
'Error 1146: Table '... .#__spkgarten_teachers' doesn't exist'

If I change table name to '(myprefix)_spkgarten_teachers' - all works fine :D
I think it's some mistake around table '... spkgarten_teachers' due update.

Thank you for your help :)

Rifat Wahid Alif - Staff

More than a month ago #Permalink
Now everything working fine?

Grzegorz

More than a month ago #Permalink
Yes, now it's OK.
Thanks.

Rifat Wahid Alif - Staff

More than a month ago #Permalink
Thanks for being with us.


There are no replies made for this post yet.
Be one of the first to reply to this post!

Leaderboard (30 days)

Paul Frankowski

Paul Frankowski

Total Accepted Answers: 128
Sifat

Sifat

Total Accepted Answers: 89
Toufiq

Toufiq

Total Accepted Answers: 45
Pavel

Pavel

Total Accepted Answers: 6
Sohan

Sohan

Total Accepted Answers: 5

114

Templates

292794

Community Users

Newsletter

Don’t miss any updates of our new templates and extensions and all the astonishing offers we bring for you.
We never spam

Joomla! ® name is used under a limited license from Open Source Matters in the United States and other countries. JoomShaper.com is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.

Connect Us