[Solved: Tag Tree] Installation failed, no more access to Site Admin -> Pugins page
oceco
Joined: 2007-10-22
Posts: 666 |
Posted: Sun, 2009-03-08 19:17 |
The installation of the Tag Tree module failed and since then I can't access anymore the Plugins page in Site Admin. Error An error has occurred. Back to the Gallery Error Detail - Error (ERROR_PLUGIN_VERSION_MISMATCH) : [tags] db: (v: 1.3.6 core api: 7/10, module api: 3/5) code: (v: 1.4 core api: 7/54, module api: 3/9) * in modules/core/classes/helpers/GalleryPluginHelper_simple.class at line 178 (GalleryCoreApi::error) * in modules/core/classes/GalleryCoreApi.class at line 273 (GalleryPluginHelper_simple::loadPlugin) * in modules/tagtree/classes/TagTreeCompatibilityHelper.class at line 39 (GalleryCoreApi::loadPlugin) * in modules/tagtree/module.inc at line 95 (TagTreeCompatibilityHelper::isCompatibleTagsModuleActive) * in modules/core/PluginCallback.inc at line 424 (TagTreeModule::needsConfiguration) * in modules/core/AdminPlugins.inc at line 104 (PluginCallbackView::getPluginState) * in modules/core/SiteAdmin.inc at line 209 (AdminPluginsView::loadTemplate) * in modules/core/classes/GalleryView.class at line 293 (SiteAdminView::loadTemplate) * in main.php at line 465 (GalleryView::doLoadTemplate) * in main.php at line 104 * in main.php at line 88 System Information Gallery version 2.3 PHP version 5.2.6 apache2handler Webserver Apache/2.0.52 (CentOS) Database mysqli 4.1.20 Toolkits SquareThumb, ImageMagick, Thumbnail, Gd Operating system Linux naiad.kreativmedia.ch 2.6.9-42.ELsmp #1 SMP Sat Aug 12 09:39:11 CDT 2006 i686 Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9.0.7) Gecko/2009021910 Firefox/3.0.7 (.NET CLR 3.5.30729) Update: I run the Integrity Check and got the following messages: Checked 18136 entities Orphaned data in table AccessMap with no row in AccessSubscriberMap table; ids: 24298, 24299, 24300, 24301, 24302, 24303, 24304, 24305, 24306, 24307, 24308, 24309, 24310, 24311, 24312, 24313, 24314, 24315, 24316, 24317, 24318, 24319, 24320, 24321, 24322, 24323, 24324, 24325, 24326, 24327, 24328, 24329, 24330, 24331, 24332, 24333, 24334, 24335, 24349, 24358, 24359, 24494, 24495, 24496, 24996, 24998, 25003, 25005, 25007, 25009, 25011, 25013, 25015, 25017, 25019, 25021, 25023, 25025, 25027, 25029, 25031, 25033, 25035, 25037, 25039, 25041, 25043, 25045, 25047, 25049, 25051, 25053, 25055, 25057, 25059, 25061, 25063, 25065, 25067, 25069, 25071, 25073, 25075, 25077, 25079, 25081, 25083, 25085, 25087, 25089, 25091, 25093, 25095, 25097, 25099, 25101, 25103, 25105, 25107, 25109, 25111, 25113, 25115, 25117, 25119, 25121, 25123, 25125, 25127, 25129, 25131, 25133, 25135, 25137, 25139, 25141, 25143, 25145, 25147, 25149, 25151, 25153, 25155, 25157, 25159, 25161, 25163, 25165, 25167, 25169, 25171, 25173, 25175, 25177, 25179, 25181, 25183, 25185, 25187, 25189, 25191, 25193, 25195, 25197, 25199, 25201, 25203, 25205, 25207, 25209, 25211, 25213, 25215, 25217, 25219, 25221, 25223, 25225, 25227, 25229, 25231, 25233, 25235, 25237, 25239, 25241, 25243, 25245, 25247, 25249, 25251, 25253, 25255, 25257, 25259, 25261, 25263, 25265, 25267, 25269, 25271, 25273, 25275, 25277, 25279, 25281, 25283, 25285, 25287, 25289, 25291, 25293, 25295, 25297, 25299, 25301, 25303, 25305, 25307, 25309, 25311, 25313, 25315, 25317, 25319, 25321, 25323, 25325, 25327, 25329, 25331, 25333, 25335, 25337, 25339, 25341, 25343, 25345, 25347, 25349, 25351, 25353, 25355, 25357, 25359, 25361, 25363, 25365, 25367, 25369, 25371, 25373, 25375, 25377, 25379, 25381, 25383, 25385, 25387, 25389, 25391, 25393, 25395, 25397, 25399, 25401, 25403, 25405, 25407, 25409, 25411, 25413, 25415, 25417, 25419, 25421, 25423, 25425, 25427, 25429, 25431, 25433, 25435, 25437, 25439, 25441, 25443, 25445, 25447, 25449, 25451, 25453, 25455, 25457, 25459, 25461, 25463, 25465, 25467, 25469, 25471, 25473, 25475, 25477, 25479, 25481, 25483, 25485, 25487, 25489, 25491, 25493, 25495, 25497, 25499, 25501, 25503, 25505, 25507, 25509, 25511, 25513, 25515, 25517, 25681, 25682, 25683, 25684, 25704, 25705 ___________________________________________________ |
|
Posts: 27300
What is the tagtree module? I have only seen the tags module.
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
Posts: 666
The Tag Tree was listed on the repository plugins list in Site Admin and there the description said it shall display tags in a hierarchy. Yes, I was wondering, too.
From this repository plugins list I've installed it. Beside the error message during its installation and now when I want to access the plugins page in Site Admin I've also not seen it! So far I've also only seen the tags module ;-((
Also the error message above uses this term (name in bold).
___________________________________________________
Top Secret: Tipps, Tricks und mehr
The Most Secret Gallery2 Treasure: Quick Start Guide
Posts: 27300
Seems it might need some development.
It does seem to work on the authors site:
http://chadandelisa.parry.org/album/main.php See the sidebar.
I would ping him and see if he can help. I have never seen the module or tried.
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
Posts: 666
Hi floridave
Thanks for your feedback, now I'm not wondering anymore how this shall work as I understood the idea meanwhile. And yes, I send a PM to chad.
But until I get an answer I'd like to ask you the following: Is there a possibility to deactivate a plugin by means of phpmyadmin? I'm not an expert in it, but I might be able to deactivate it with a good hint ;-) , e.g where can I learn more about the G2 DB structure?
krgds/oceco
___________________________________________________
Top Secret: Tipps, Tricks und mehr
The Most Secret Gallery2 Treasure: Quick Start Guide
Posts: 27300
FAQ: How can I deactivate a module when I am unable to login?
I tried to install this module but did not realize that it required 1.4 of the Tags module ( my test install had a older version of the tags module) thus it failed. I belive it should have had some compatibility check durring install/activation preventing this error.
I was not able to get to de-activate the module as I got a error on the plugins page. So I deleted it from the file system.
I then upgraded tags module. I was then able to install the tagtree module.
I have to look a bit closer at it to see if it does some checks during activation/install.
Dave
___________ __________________________________
Blog & G2 || floridave - Gallery Team
Posts: 666
Hi floridave
Thanks a lot for your tests and feedback!!!!
I have identified two tables that are candidates for deletion: TagItemMap and TagMap. Both have a creation date of March 8., 21:20, but many other tables have the same creation date. So the creation date didn't help me either.
If I look at the content of these two tables it looks like TagMap is a list of my tags (g_tagId, g_tagName) and TagItemMap maps my tags to elements (g_itemId, g_tagId). That brings me to the conclusion they are not the right candidates for deletion.
Then I read your posting one more time, found "...I deleted it from the file system." Thus I renamed the directory tagtree to tagtreex and the error message showed a message in regard to tagtreex!
Then I deleted it from the file system resulting in this when I'm accessing the plugins page:
This message told me that there must be a list of plugins. Found "g2_PluginMap", deleted "tagtree" (BTW g_active was set to 0 as well for the tag module!??).
For me remains the question: Why does it still try to access and load the module?
Then I deleted caches et all and run the integrity check yielding in
Checked 18137 entities Orphaned data in table AccessMap with no row in AccessSubscriberMap table; ids: 24298, 24299, 24300, 24301, 24302, 24303, 24304, 24305, 24306, 24307, 24308, 24309, 24310, 24311, 24312, 24313, 24314, 24315, 24316, 24317, 24318, 24319, 24320, 24321, 24322, 24323, 24324, 24325, 24326, 24327, 24328, 24329, 24330, 24331, 24332, 24333, 24334, 24335, 24349, 24358, 24359, 24494, 24495, 24496, 24996, 24998, 25003, 25005, 25007, 25009, 25011, 25013, 25015, 25017, 25019, 25021, 25023, 25025, 25027, 25029, 25031, 25033, 25035, 25037, 25039, 25041, 25043, 25045, 25047, 25049, 25051, 25053, 25055, 25057, 25059, 25061, 25063, 25065, 25067, 25069, 25071, 25073, 25075, 25077, 25079, 25081, 25083, 25085, 25087, 25089, 25091, 25093, 25095, 25097, 25099, 25101, 25103, 25105, 25107, 25109, 25111, 25113, 25115, 25117, 25119, 25121, 25123, 25125, 25127, 25129, 25131, 25133, 25135, 25137, 25139, 25141, 25143, 25145, 25147, 25149, 25151, 25153, 25155, 25157, 25159, 25161, 25163, 25165, 25167, 25169, 25171, 25173, 25175, 25177, 25179, 25181, 25183, 25185, 25187, 25189, 25191, 25193, 25195, 25197, 25199, 25201, 25203, 25205, 25207, 25209, 25211, 25213, 25215, 25217, 25219, 25221, 25223, 25225, 25227, 25229, 25231, 25233, 25235, 25237, 25239, 25241, 25243, 25245, 25247, 25249, 25251, 25253, 25255, 25257, 25259, 25261, 25263, 25265, 25267, 25269, 25271, 25273, 25275, 25277, 25279, 25281, 25283, 25285, 25287, 25289, 25291, 25293, 25295, 25297, 25299, 25301, 25303, 25305, 25307, 25309, 25311, 25313, 25315, 25317, 25319, 25321, 25323, 25325, 25327, 25329, 25331, 25333, 25335, 25337, 25339, 25341, 25343, 25345, 25347, 25349, 25351, 25353, 25355, 25357, 25359, 25361, 25363, 25365, 25367, 25369, 25371, 25373, 25375, 25377, 25379, 25381, 25383, 25385, 25387, 25389, 25391, 25393, 25395, 25397, 25399, 25401, 25403, 25405, 25407, 25409, 25411, 25413, 25415, 25417, 25419, 25421, 25423, 25425, 25427, 25429, 25431, 25433, 25435, 25437, 25439, 25441, 25443, 25445, 25447, 25449, 25451, 25453, 25455, 25457, 25459, 25461, 25463, 25465, 25467, 25469, 25471, 25473, 25475, 25477, 25479, 25481, 25483, 25485, 25487, 25489, 25491, 25493, 25495, 25497, 25499, 25501, 25503, 25505, 25507, 25509, 25511, 25513, 25515, 25517, 25681, 25682, 25683, 25684, 25704, 25705, 25851, 25852, 25853, 25854, 25855, 25856 Orphaned data in table PluginParameterMap with no row in PluginMap table; ids: module/tagtree
OK, I deleted the row in PluginMap.
Accessing the plugins page gives still the following error messages:
# in modules/tagtree/classes/TagTreeCompatibilityHelper.class at line 39 (GalleryCoreApi::loadPlugin)
# in modules/tagtree/module.inc at line 95 (TagTreeCompatibilityHelper::isCompatibleTagsModuleActive)
# in modules/core/PluginCallback.inc at line 424 (TagTreeModule::needsConfiguration)
Why is Gallery2 loading/activating this damed module, when:
- its g_active status is set to 0 ?
- it is deleted from the g2_PluginMap table????
At least, please remove this module from the repository list!!! It destroyed _ALL_ the positive impressions I had from Gallery2.
___________________________________________________
Top Secret: Tipps, Tricks und mehr
The Most Secret Gallery2 Treasure: Quick Start Guide
Posts: 4342
If you do manual writes to the db you have to clear the database cache before Gallery will pick up the new values.
Presumably it's in the community repository - you'll notice the "(use at your own risk!)" caveat.
Posts: 666
Hi Alec
even clearing the DB cache didn't help. I know I installed it at my own risk. This plugin just kills your G2 installation and my intention is to tell others don't use the tag tree module!
___________________________________________________
Top Secret: Tipps, Tricks und mehr
The Most Secret Gallery2 Treasure: Quick Start Guide
Posts: 666
A week ago I sent a PM to the developer Chad of tag tree and so far I didn't even get a message: "I'll take a look at it".
And yeahh, my last manual DB backup is one month old. Restoring it will distroy all the changes I've made meanwhile! But I made too many and heavy changes meanwhile!!! Conclusion for me: Make a manual G2 Backup before every plugin installation!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Now I have to choose between living with a broken DB or forget G2 at all and all my dependend websites (15 months of work!). Yes, sometimes shit happens!
___________________________________________________
Top Secret: Tipps, Tricks und mehr
The Most Secret Gallery2 Treasure: Quick Start Guide
Posts: 4342
Hi Oceco,
What exactly is/are the remaining problem(s) with your database?
Posts: 666
Hi Alec
Thank you for your continued interested in my problem.
The problem is that I can't deactivate the tag tree module and therefore I can't access anymore my site admin -> pligins page.
I'll send you a PM with further details.
rgds/oceco
___________________________________________________
Top Secret: Tipps, Tricks und mehr
The Most Secret Gallery2 Treasure: Quick Start Guide
Posts: 4342
So... looking at your installation, the problem at the moment (might not be the only problem) is this:
1. the TagTree module isn't installed
2. the Tags module is deactivated
3. when you access the plugins page, even uninstalled plugins are initialised
4. the TagTree module has a needsConfiguration() function which attempts to load the Tags module to check whether a compatible Tags module is installed
5. This loading of the tags module is failing with a terminal error because the db reports that you have v1.3.6 installed but the tags module code is v1.4 (I'm guessing you just upgraded the tags module code)
6. therefore you can't access the plugins page
I can think of about three different fixes that will get you out of the mud.
If it were my database this is how I'd proceed:
1. Move the TagTree module code folder out of the modules/ directory (I'd say delete it, but I would keep a copy in case it hasn't been uninstalled properly. Then if you get extra/different errors you can put it back)
2. Complete the upgrade of the tags module (I think this process is stalled: the version 1.3.6 (database) vs. 1.4 (code) is a normal part of the module upgrade procedure which is done through the plugins page, only you can't complete it because the TagTree module is throwing a fit.
3. reinstall the TagTree module.
Caveat: I may have missed something significant, and I'm not responsible if it goes pear shaped. But you should know after step 1 if things are looking up.
Overall it looks like the author of the TagTree module has made brave efforts to code a module dependency procedure, but hasn't spotted the potential for his loading of the tags module to fail if the tags module itself is in the middle of an upgrade.
Posts: 666
Now I do understand the first error message line in my original posting. (I never upgraded the TagsTree module, I just installed it from the repository list and the got the error message as shown in the OP).
I did this already in the past, but did it now again.
How to upgrade when I still can't access the plugins page?
I have a backup of the DB and the files ;-)
In the table g2_PluginMap there was originally the module "tagtree" with the value 0 for g_active. I deleted this entry but still got an error message.
Today I also deleted the module "tags" with g_active=0 in table g2_PluginMap , cleard DB cache, browser cache (to make sure) and since then I can access the plugins-page again!!!!
But there I could still see the block:
Tag Tree 1.0.0 1.0.0 Jump directly to any album using a hierarchical tag view
So I went in the DB to the table:%20g2_PluginPackageMap and there I just found
module tags base 1.4 1728
and deleted it. Additionally in Tabelle: g2_PluginParameterMap I deleted all entries with g_pluginId=tag*
(don't know if this last step is neccessary, but I have a backup ;-)
Then I saw on the plugins-page both modules aren't installed anymore!
After that I could successfully install tags 1.4 and Tag Tree 1.0.0!!!
Thanks a lot go to floridave and alecmyers for their support!!!!
___________________________________________________
Top Secret: Tipps, Tricks und mehr
The Most Secret Gallery2 Treasure: Quick Start Guide
Posts: 4342
I was fairly sure that removing the code would give you access to the plugins page.
Still, good that you've got it sorted!
Posts: 666
Removing the code (files) alone didn't help . I had to delete with phpmyadmin the module "tags" in g2_PluginMap. After that I could access the plugins page again.
But a new installation of the tags module failed. Unless I modified the g2_PluginPackageMap table.
Meanwhile I also checked the entries I deleted in table g2_PluginParameterMap. The new installation has 4 new entries:
Seems to me that the new 1.0.0 version has a better version checking.
___________________________________________________
Top Secret: Tipps, Tricks und mehr
The Most Secret Gallery2 Treasure: Quick Start Guide
Posts: 27300
alecmyers did most of the leg work.
Glad you got it all sorted.
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
Posts: 39
Hi
I tried to use Tag Tree module in embedded G2.3 with Joomla 1.5.9 but it does not work :
It shows an empty block with [object Object] and I have 2 errors:
Works fine in non embedded mode. Any idea?
Thanks
David
Posts: 27300
I bet it was never tested.
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
Posts: 39
I confirm it. If I can help...
David
Posts: 38
I am the author of TagTree. I just saw that people had tried to contact me on this thread. Sorry, I didn't receive a message.
The TagTree module does indeed include a compatibility check, as you guessed. The check should prevent users from installing the module, rather than causing errors after installation. If this problem crops up again for anyone, feel free to email me at
.