Support Forums - XOOPS Web Application System

Subject:* <
Name/Email:* <
Message Icon:* <
Select* <
Message:* <	xx-Small x-Small Small Medium Large x-Large xx-Large Arial Courier Georgia Helvetica Impact Verdana Haettenschweiler Black Blue Brown Green Grey Orange Paper Purple Red White Yellow [quote] WarDick wrote: I have done this numberous times on several different installations. It works evertime. It is caused by removeing a modules that was installed under version 2.0.x. I can duplicate it every time! The lingering files in xxx_tplsource do not seem to interfer because there is nothing to access them with. They are clutter though. A script to do this automatically would be awesome. It is happening to everyone with this scenario.[/quote] Click the Preview to see the content in action.
Options:* <	Enable Smiley Enable Xoops Code
Confirmation Code* <	8 + 8 = ? Input the result from the expression Maximum attempts you can try: 10
* <

Re: Template Set Manager

by freakingid on 2006/2/24 21:00:02

Here's an SQL statement that will clean it up for you.
I think there's an easier way to write this (without the USING?) but who cares.

le="color: #000000"><?php DELETE FROM xoops_tplfile, xoops_tplsource USING xoops_tplfile, xoops_tplsource WHERE xoops_tplfile.tpl_module = "article" AND xoops_tplsource.tpl_id = xoops_tplfile.tpl_id

In my example, "article" is the name of the module as seen in the _tplfile table.

Re: Template Set Manager

by daddystu on 2005/9/22 7:26:54

THANK YOU. Deleting the entries in the tplfile table certainly did the trick.

Don't know if you have managed to get to the bottom of this one yet but I had this happen to me with a clean install on a new server.

I noticed here that upgrading was a possible culprit so I thought just to be sure, I can verify that it is not exclusively upgrading ...

So just in case it helps.

Xoops 2.2.2
Clean install (did NOT check each module for 2.2 compatability - it is a testing server / playground hehe)

Initially...
system
popnUpBlog
wordpress
Extended Profiles
..made a clone of the templates to play around

then uninstalled
wordpress this left records in the tplfile table

then installed
myAlbum-p
xcGallery

then uninstalled
myAlbum this left records in the tplfile table

then installed
xoopsGallery

then uninstalled
xcGallery this left records in the tplfile table

Hope you get this one, seems fun though (ahem...)

HTH

Re: Template Set Manager

by monique on 2005/9/1 21:14:23

Uninstalling WIWI leaves extraneous records, too.

Re: Template Set Manager

by monique on 2005/8/30 19:51:40

It happened to me and I think it has to do with when you uninstall a module, the module doesn't always clean up after itself (if you get what I mean) and leaves some records in the template table. XOOPS CHAT is one that did it.

Re: Template Set Manager [CURE]

by Jellocat on 2005/8/30 19:21:36

Oh!!!!! Hallelujah! I'm NO programmer, nor do I know anything about SQL but was able to figure out the steps and fixed the template problem outlined in this thread. THANKS!! HUG!!!!!!!!!!!!