Support Forums

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

Your Time: Our Time:

Error after update sp_kindergarten

Featured Lock Resolved Bug
After updating joomla to 3.8.12 and updating sp_kindergarten i get this error when opening sp_kindergarten via the backend: 0 Invalid controller: name='', format=''
I tried to instal sp_kindergarten again but this didn't help
Can canybody help me to solve this?

9 Answers

Sajeeb Ahamed

More than a month ago #Permalink
Hey Jonathan,
What is the version of com_spkgarten have you used before upgrading to version 2.1?

- Thanks.

jonathan

More than a month ago #Permalink
dont know exact, i installed the complete template inclusive component one month ago.

jonathan

More than a month ago #Permalink
When trying to install a fresh download of sp_kgarten i get this error, this might be the reason i get the error message 0 Invalid controller: name='', format=''
I just found out that my previous version was 1.0

So when installing the fresh version i get the mysql error given in the attachement. I think this is because a previous installation got an error and some of the tables are already changed so when installing the fresh version the query is unable to find the table to change.

any idea how to solve this?
uninstal the compontent and then a fresh installation? But in this case i wil lose my sample data. or can i reinstall the sample data with a fresh installation?

Attachments (1)

  • Capture.PNG
    Capture.PNG 19.5 KB

Sajeeb Ahamed

More than a month ago #Permalink
Hey jonathan,
Could you please try this solution?

Replace the #_ and jos prefix with your database prefix.

-Thanks.

jonathan

More than a month ago #Permalink
Thanks reply, i just tried this.
But i get this error:
SQL-query:


ALTER TABLE `kidz_spkgarten_classes` CHANGE COLUMN `spkgarten_class_id` `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT
MySQL

#1054 - unknown collumn 'spkgarten_class_id' in kidz_spkgarten_classes

I think this is because some of the collumn names have already changed and some not?

Sajeeb Ahamed

More than a month ago #Permalink
Thanks reply, i just tried this.
But i get this error:
SQL-query:


ALTER TABLE `kidz_spkgarten_classes` CHANGE COLUMN `spkgarten_class_id` `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT
MySQL

#1054 - unknown collumn 'spkgarten_class_id' in kidz_spkgarten_classes

I think this is because some of the collumn names have already changed and some not?


I think so. Could you please confirm me that if you change any column name before manually?

jonathan

More than a month ago #Permalink
Thanks reply, i just tried this.
But i get this error:
SQL-query:


ALTER TABLE `kidz_spkgarten_classes` CHANGE COLUMN `spkgarten_class_id` `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT
MySQL

#1054 - unknown collumn 'spkgarten_class_id' in kidz_spkgarten_classes

I think this is because some of the collumn names have already changed and some not?


I think so. Could you please confirm me that if you change any column name before manually?


I did not change any collumn name manually, but attached a screenshot of the current situation.

Attachments (1)

  • tables.png
    tables.png 68.5 KB

Sajeeb Ahamed

More than a month ago #Permalink
Thanks reply, i just tried this.
But i get this error:
SQL-query:


ALTER TABLE `kidz_spkgarten_classes` CHANGE COLUMN `spkgarten_class_id` `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT
MySQL

#1054 - unknown collumn 'spkgarten_class_id' in kidz_spkgarten_classes

I think this is because some of the collumn names have already changed and some not?


I think so. Could you please confirm me that if you change any column name before manually?


I did not change any collumn name manually, but attached a screenshot of the current situation.


I see your table structure. please run this sql in your database and check if not works then install the component again.


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


Please change the #_ with your database prefix. In your case I think it's kidz_spkgarten_teachers.

jonathan

More than a month ago #Permalink
Just ran the query with good result.
When trying to open the component via the backend i still got the same error message as first posted.
Tried a new installation of com_kgarten_fullpackage_v2.1
got this error message
Unknown column 'spkgarten_class_id' in '#__spkgarten_classes'
SQL =
ALTER TABLE `#__spkgarten_classes` CHANGE COLUMN `spkgarten_class_id` `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;

still the problem that some columns are changed and some not, right?


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: 133
Sifat

Sifat

Total Accepted Answers: 88
Toufiq

Toufiq

Total Accepted Answers: 41
Pavel

Pavel

Total Accepted Answers: 7
Al Mamun

Al Mamun

Total Accepted Answers: 3

114

Templates

292518

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