Hello All,
I am working on a site where I installed a few third party modules. I am using the solspace user module and the fielder module from [removed]. I also am trying to use LG’s better meta module. When I tried to publish to a weblog and add some better meta, I get a mySQL error 1054. I attached a screen shot. So I started to trouble shoot by disabling my extensions one at a time. After each extension was disabled with no improvement and the same error still showing, I moved to the modules and started disabling them as well.
That’s when I noticed that if I disabled a module, it went through the confirmation screen like it is supposed to, but if exited the modules tab and went back to it, the module I just uninstalled is showing that it is installed. So I can’t turn my modules off. I can enable unused modules, but after that, I can’t turn them back off.
Does anyone have any Ideas. Also, I tried removing the modules from the server, then I get the errors that the system can’t find the associated language file.
Well there’s a quick and dirty way to do it:
If you use something like phpMyAdmin to go to your database, look for the exp_modules table. Inside that is a row for each module installed. If you delete the row of the module you want to disable, to EE it will look like you haven’t installed the module. That doesn’t clean anything else up though - so if the module installs other tables or changes any info then this will mean all that hasn’t been reverted back like it would be if you de-installed the module properly. So use it at your own risk. And it really doesn’t address your underlying problem.
EDIT: You should probably start a thread about the better meta problem (or post in that thread). Leevi is good about helping out 😊
Thanks for that. I have thought about doing that, but I am more likely to get myself in more trouble there. I don’t think it is a better meta problem as I have used that extension on another site and it ran perfect. I think it is a conflict somewhere. If I were to bet, I think it has to do with the fielder module. I didn’t notice any problems until I installed that module. But like I said, I can’t uninstall any module now. So troubleshooting this is not fun.
Looking at that error message it definitely looks like a problem with the better meta module:
INSERT INTO exp_lg_better_meta
I just looked at a site I”ve done that uses that module and there is no ‘change_frequency’ column in my copy either (I haven’t updated to the newest version). Did you by any chance update to a newer version of lg_better_meta at some point? Looking at the screenshots for better meta, it looks like the new sitemap addition with the 1.7 version has a ‘change frequency’ option for making sitemaps - the error you show would make sense if you didn’t uninstall the module before upgrading to the newest version.
I don’t want to point you down the wrong path but there’s definitely something wrong with better meta as shown from your error message.
If anyone is having this issue. I read and followed this thread and it fixed my problem. http://ellislab.com/forums/viewreply/490820/
Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.