1
hughs
Template Set Manager
  • 2005/8/19 8:29

  • hughs

  • Not too shy to talk

  • Posts: 117

  • Since: 2003/10/7


Hello.

I've cloned my modules, now after de-installing mydownlods, my Template Set Manager has got a white background and i'm not able to edit-change anything, i can only view my modules,i'm using XooPs 2.2.2.

Thank you for your help.

hughs

2
WarDick
Re: Template Set Manager [CURE]
  • 2005/8/19 9:54

  • WarDick

  • Just can't stay away

  • Posts: 890

  • Since: 2003/9/13


Hi hughs,

I do not know why this is happening but I do know what is happening!

Look at the default template set you will find that one of the modules was not completely uninstalled. You will notice that there are still some templates listed.

To get your template manager working correctly again. You must remove the left over templates from the default set.

I manually edit the default template set with myPhpAdmin. To do this find the name of the left over module or modules that have an incorrect number of templates still lingering in the default set. Locate them the table xxx_tplfile. Scan thought the table using the column tpl_module as your key. Delete each entry form the name of the module in question.

Your template manager will be automagically working again.

Don't forget to remove all of the leftover files!! You will know you have succeeded when the template manager returns to normal.
Urging XOOPS to be the Best It Can Be.
Richard......

3
Mithrandir
Re: Template Set Manager

I think the safer road would be to check the tplfile table and locate and remove all the records that have a tpl_module value that is not present in the modules table's mid values

The main nuisance is that there is also a tplsource table with only a reference through the tpl_id - the tplsource records with the same template reference id as the records removed in the tplfile table... not at all simple.

We are trying to figure out what to do about this, but first we are trying to find out why the heck this happens to some of you (it doesn't at my end)
"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

4
WarDick
Re: Template Set Manager
  • 2005/8/19 10:16

  • WarDick

  • Just can't stay away

  • Posts: 890

  • Since: 2003/9/13


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.
Urging XOOPS to be the Best It Can Be.
Richard......

5
hughs
Re: Template Set Manager
  • 2005/8/19 10:22

  • hughs

  • Not too shy to talk

  • Posts: 117

  • Since: 2003/10/7


Hi again.

I did follow your advise and i got my Template Set Manager working perfectly again, thanks your wisdom !!.
I like to send you both a BIG THANKS for your help and expertise advise.
Have a nice weekend..

hughs

PS) May i ask you why it happens..??

6
Mithrandir
Re: Template Set Manager

Quote:
PS) May i ask you why it happens..??

Are you reading the replies? or just skimming through them?

Quote:

WarDick wrote:
I do not know why this is happening


Quote:

Mithrandir wrote:
We are trying to figure out what to do about this, but first we are trying to find out why the heck this happens to some of you
"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

7
hughs
Re: Template Set Manager
  • 2005/8/19 10:39

  • hughs

  • Not too shy to talk

  • Posts: 117

  • Since: 2003/10/7


You are quite right!.
I'm sorry about it.

hughs

8
Mithrandir
Re: Template Set Manager

WarDick, can you try to reproduce it, this time with PHP & MySQL debug on?

Note any errors and let me know?
"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

9
WarDick
Re: Template Set Manager
  • 2005/8/19 10:43

  • WarDick

  • Just can't stay away

  • Posts: 890

  • Since: 2003/9/13


Yes I will send you the data. It will take a while to recreate the scenario. Standby!
Urging XOOPS to be the Best It Can Be.
Richard......

10
WarDick
Re: Template Set Manager
  • 2005/8/19 11:26

  • WarDick

  • Just can't stay away

  • Posts: 890

  • Since: 2003/9/13


This debug data was capture at the removal of xoopstron.

Quote:
Queries core
SELECT * FROM xxx_config WHERE (conf_modid = '1' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data FROM xxx_session WHERE sess_id = '36c3d8ab6af1ac125f44c6049cf9a2a1'
( 0.000303)
SELECT * FROM xxx_users u, KCX_user_profile p WHERE u.uid = p.profileid AND uid = '1' LIMIT 0, 1
( 0.000554)
SELECT * FROM xxx_modules WHERE dirname = 'system'
( 0.000365)
SELECT * FROM xxx_config WHERE (conf_modid = '1') ORDER BY conf_order ASC
( 0.001232)
SELECT * FROM xxx_config WHERE (conf_modid = '1' AND conf_catid = '3') ORDER BY conf_order ASC
( 0.00043)
SELECT * FROM xxx_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'module_admin' AND gperm_groupid IN (1,2))
( 0.000753)
SELECT * FROM xxx_modules WHERE (hasadmin = '1' AND isactive = '1' AND mid IN (1,28,27,26,24,22,33,21,30,32,9,15,6,36,38)) ORDER BY name ASC
( 0.00091)
SELECT * FROM xxx_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'system_admin' AND gperm_groupid IN (1,2))
( 0.00068)
SELECT * FROM xxx_configcategory WHERE confcat_modid IN (6,24,38,27,21,33,9,32,15,36,26,22,28,1,30)
( 0.000794)
SELECT groupid, name FROM xxx_groups ORDER BY name ASC
( 0.000531)
SELECT * FROM xxx_modules WHERE dirname = 'news'
( 0.00059)
SELECT * FROM xxx_modules WHERE dirname = 'bmsurvey'
( 0.000412)
Total Number of Queries: 13 | Total SQL Generation Time: 0.007554

Queries module
SELECT * FROM KCX_modules WHERE dirname = 'xoopsotron'
( 0.000356)
SELECT * FROM xxx_newblocks WHERE mid = '23'
( 0.000357)
SELECT * FROM xxx_block_instance WHERE bid IN (0)
( 0.000339)
DELETE FROM xxx_modules WHERE mid = 23
( 0.000247)
DELETE FROM xxx_group_permission WHERE gperm_name = 'module_admin' AND gperm_itemid = 23
( 0.000381)
DELETE FROM xxx_group_permission WHERE gperm_name = 'module_read' AND gperm_itemid = 23
( 0.000342)
SELECT block_id FROM xxx_block_module_link WHERE module_id = 23
( 0.000232)
SELECT block_id FROM xxx_block_module_link WHERE module_id != 23 AND block_id = 40
( 0.000132)
UPDATE KCX_newblocks SET visible = 0 WHERE bid = 40
Error number: 1054
Error message: Unknown column 'visible' in 'field list'
( 0.000165)
UPDATE KCX_block_module_link SET module_id = -1 WHERE module_id = 23
( 0.000166)
SELECT * FROM xxx_tplfile WHERE (tpl_refid = '23' AND tpl_type = 'module') ORDER BY tpl_refid
( 0.00052)
DELETE FROM xxx_tplfile WHERE tpl_id = 225
( 0.000225)
DELETE FROM xxx_tplsource WHERE tpl_id = 225
( 0.042386)
DELETE FROM xxx_tplfile WHERE tpl_id = 1059
( 0.000248)
DELETE FROM xxx_tplsource WHERE tpl_id = 1059
( 0.030411)
SELECT * FROM xxx_newblocks WHERE mid = '23'
( 0.000248)
SELECT * FROM xxx_block_instance WHERE bid = '40'
( 0.000343)
DELETE FROM xxx_block_module_link WHERE block_id = 39
( 0.000193)
DELETE FROM xxx_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'block_read' AND gperm_itemid = '39')
( 0.000522)
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
( 0.00042)
DROP TABLE xxx_xoopsotron
( 0.000338)
DELETE FROM xxx_group_permission WHERE (gperm_modid = '23')
( 0.000501)
SELECT * FROM xxx_config WHERE conf_modid = '23' ORDER BY conf_order ASC
( 0.000641)
DELETE FROM xxx_config WHERE conf_id = 339
( 0.012866)
SELECT * FROM xxx_configoption WHERE conf_id = '339'
( 0.000417)
DELETE FROM xxx_config WHERE conf_id = 340
( 0.000217)
SELECT * FROM xxx_configoption WHERE conf_id = '340'
( 0.000195)
DELETE FROM xxx_config WHERE conf_id = 341
( 0.000197)
SELECT * FROM xxx_configoption WHERE conf_id = '341'
( 0.000184)
DELETE FROM xxx_config WHERE conf_id = 342
( 0.000191)
SELECT * FROM xxx_configoption WHERE conf_id = '342'
( 0.000182)
DELETE FROM xxx_config WHERE conf_id = 343
( 0.000196)
SELECT * FROM xxx_configoption WHERE conf_id = '343'
( 0.000181)
DELETE FROM xxx_config WHERE conf_id = 344
( 0.000192)
SELECT * FROM xxx_configoption WHERE conf_id = '344'
( 0.00018)
DELETE FROM xxx_config WHERE conf_id = 345
( 0.000192)
SELECT * FROM xxx_configoption WHERE conf_id = '345'
( 0.000182)
DELETE FROM xxx_config WHERE conf_id = 346
( 0.000191)
SELECT * FROM xxx_configoption WHERE conf_id = '346'
( 0.000182)
DELETE FROM xxx_config WHERE conf_id = 347
( 0.000194)
SELECT * FROM xxx_configoption WHERE conf_id = '347'
( 0.000179)
DELETE FROM xxx_config WHERE conf_id = 348
( 0.000192)
SELECT * FROM xxx_configoption WHERE conf_id = '348'
( 0.000184)
Total Number of Queries: 50 | Total SQL Generation Time: 0.105429

Queries block
Total Number of Queries: 0 | Total SQL Generation Time: 0

Blocks
Total: 0 blocks

Execution Time
XOOPS took 0.45772695541382 seconds to load.

Extra
Token Validation: Valid Token Found


This is the lingering entry in the database.Quote:
226 40 xoopsotron default xoopsotron_block.html


This is the error message on the template page.

Quote:
Fatal error: Call to a member function on a non-object in /home/kinneyco/public_html/kcgcd/modules/system/admin/tplsets/main.php on line 103


Let me know if you need more data!
Urging XOOPS to be the Best It Can Be.
Richard......

Login

Who's Online

228 user(s) are online (187 user(s) are browsing Support Forums)


Members: 0


Guests: 228


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