11
Mithrandir
Re: Template Set Manager

DELETE FROM xxx_block_instance WHERE instanceid 39
0.000161)
DELETE FROM xxx_block_module_link WHERE block_id 40
0.000112)
DELETE FROM xxx_group_permission WHERE (gperm_modid '1' AND gperm_name 'block_read' AND gperm_itemid '40')
0.000345)
DELETE FROM xxx_block_instance WHERE instanceid 40
0.000132)
SELECT FROM xxx_tplfile WHERE (tpl_tplset 'myLatest' AND tpl_refid '40' AND tpl_type 'block'ORDER BY tpl_refid
0.000523)
DELETE FROM xxx_tplfile WHERE tpl_id 1109
0.000215)
DELETE FROM xxx_tplsource WHERE tpl_id 1109
0.007534)
DELETE FROM xxx_newblocks WHERE bid 40

It does seem that it deletes the block instance, deletes the visible-on-pages, deletes group permissions and deletes the block instance.

Then it looks for the template, finds it (tpl_id=1109) and deletes tplfile and tplsource before deleting the block...

Why is there still a template left? It does seem to delete the template from the current selected template set and not the default template set, so maybe that's it...

Sometimes I hate the templating system.
"When you can flatten entire cities at a whim, a tendency towards quiet reflection and seeing-things-from-the-other-fellow's-point-of-view is seldom necessary."

Cusix Software

12
WarDick
Re: Template Set Manager
  • 2005/8/19 13:04

  • WarDick

  • Just can't stay away

  • Posts: 890

  • Since: 2003/9/13


This module was install when the site was an 2.0.x version. It has been updated to 2.2.2.

A modules that is installed after the update will not exibit this problem.

This module can be installed and uninstalled now without any side effects. After manually removeing the left over template.
Urging XOOPS to be the Best It Can Be.
Richard......

13
Calipsy
Re: Template Set Manager [CURE]
  • 2005/8/22 17:46

  • Calipsy

  • Just popping in

  • Posts: 87

  • Since: 2003/4/30


I also had my Template Set Manager messed up after uninstalling some modules... So I just followed these steps and the Template Set Manager is back to normal.

thanks Wardick!
Enjoy your day!
Cyber-Minds.Network......

14
Jellocat
Re: Template Set Manager [CURE]
  • 2005/8/30 19:21

  • Jellocat

  • Just popping in

  • Posts: 7

  • Since: 2005/8/28


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!!!!!!!!!!!!


15
monique
Re: Template Set Manager
  • 2005/8/30 19:51

  • monique

  • Just popping in

  • Posts: 62

  • Since: 2005/5/23


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.

16
monique
Re: Template Set Manager
  • 2005/9/1 21:14

  • monique

  • Just popping in

  • Posts: 62

  • Since: 2005/5/23


Uninstalling WIWI leaves extraneous records, too.

17
daddystu
Re: Template Set Manager
  • 2005/9/22 7:26

  • daddystu

  • Just popping in

  • Posts: 100

  • Since: 2004/5/25


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
??????- isogebamaware

18
freakingid
Re: Template Set Manager
  • 2006/2/24 21:00

  • freakingid

  • Just popping in

  • Posts: 10

  • Since: 2005/8/18


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.

DELETE FROM xoops_tplfilexoops_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.

Login

Who's Online

413 user(s) are online (292 user(s) are browsing Support Forums)


Members: 0


Guests: 413


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits