Will a new theme install solve unexpected error?

Permalink
Greetings C5 community, I need your advice please.

My websitehttp://www.lovingallpets.com/ is currently using the dotAwesome cool theme from Vivid. After trying to update the theme from version 2.05 to 2.06 I encountered the error below. Now, the only pages that work are the home page and gallery. All the other pages will produce this error when clicking on their tabs.

mysqlt error: [1146: Table 'lovingal_concrete.btSimpleHrDotawesome' doesn't exist] in EXECUTE("SHOW COLUMNS FROM `btSimpleHrDotawesome`")

This also happened previously when I updated the theme from version 2.04 to 2.05 and Michael from Vivid was able to fix it. He wrote, “Don't really know what happened - but I was able to fix it. Let me know if you continue to see problems. There may be a chance that the HR blocks disappeared; you may be able to just re-add them. Really strange...”

I have tried emailing Michael directly and c5 support @ Vivid twice each with no response. I do hope he is okay. My experience is limited to CMS (front end) and I do not code. I now have decided to give up on this theme and try a fresh start with a completely different theme from another developer.

My question is, will activating a new theme and re-building all of my pages re-write over this code problem or will this re-appear with a new theme down the road. I am not sure what HR blocks are regarding this problem.

Any input on this issue would be great! Thank you!

Erik

View Replies: View Best Answer
hostco replied on at Permalink Reply
hostco
Hello,

You may be able to solve this issue by uninstalling then reinstalling the theme.

Dashboard > Install > dotAwesome > Edit > Uninstall Package

After uninstall, revisit the install page and install the theme.
erikras replied on at Permalink Reply
Thank you Hostco, I will give that a try.
erikras replied on at Permalink Reply
Hostco, I am uninstalling the theme now. Should I answer yes or no to this?

Move package to trash directory on server?
hostco replied on at Permalink Reply
hostco
No, do not move it to the trash.
erikras replied on at Permalink Reply
Thanks for trying to help Hostco, after clicking uninstall I get a page that gives the same error...

An unexpected error occurred.
mysqlt error: [1146: Table 'lovingal_concrete.btSimpleHrDotawesome' doesn't exist] in EXECUTE("SHOW COLUMNS FROM `btSimpleHrDotawesome`")

I will wait a few days and see if anyone else out there has been through this and then I might try a new theme. I'm just worried that my environment has become too unstable.

Thank you. :)
enlil replied on at Permalink Best Answer Reply
enlil
Sounds to me like there is an issue in the uninstall function in the theme package controller.php file. I ran into this issue last night with another add-on.

C5 recently started automatically removing tables through parent::uninstall. If the tables are removed via database queries before this, the tables no longer exist and therefore throws the error.

In my case i need to manually create the tables needed to remove the add-on and then the controller.php file will need to be updated by the developer, which they already acknowledge!! Hope this helps...
erikras replied on at Permalink Reply
This is good information! I will look into it further.

I am still wondering if a new theme will clean this mess up with the missing table error. I realize that will be a very time consuming work around, but I am feeling like it's time for a fresh start.

Thanks enlil
hostco replied on at Permalink Reply
hostco
As enlil stated, you can manually add the table to the database or yes a new theme would work as well.
hostco replied on at Permalink Reply
hostco
To make sure, test with one of the default themes first.
enlil replied on at Permalink Reply
enlil
Sure, you could always install another theme or start using one of the core themes. The problem is, you will have remnants everywhere from the theme that is still stuck uninstallable, such as "global areas" in the stacks dialogue, etc!

So, yes, you could get your site working so people could view it, but be sure to complete the removal of the old theme as well!!
erikras replied on at Permalink Reply
I understand now, thank you Hostco and enlil for your time and expertise. I really do appreciate your help. Now I know what needs to be done.

Cheers,
Erik