11
FDSG
Re: Wflinks - Mysql/Template Error
  • 2008/12/8 13:08

  • FDSG

  • Just popping in

  • Posts: 16

  • Since: 2008/11/30


then remains for me nothing else than to uninstall module

12
ghia
Re: Wflinks - Mysql/Template Error
  • 2008/12/8 14:37

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


As I understand it correct, the problem is the 7 empty blocs at the end of each page?
Can you put debug mode on and make a list of the queries for generating a page eg Sonstiges?

13
FDSG
Re: Wflinks - Mysql/Template Error
  • 2008/12/8 16:15

  • FDSG

  • Just popping in

  • Posts: 16

  • Since: 2008/11/30


Hello
Yes exactly is the problem. In the Admin area will do everything properly displayed. So the query must have an error.
I now have on the category "Sonstiges" clicked. 2 "right" links are registered and 7 are wrong.

Errors:
Warning: Class 'XoopsTree' is deprecated, check 'XoopsObjectTree' in tree.php in file /class/xoopstree.php line 45
Warning: Class 'XoopsTree' is deprecated, check 'XoopsObjectTree' in tree.php in file /class/xoopstree.php line 45
Warning: Class 'XoopsTree' is deprecated, check 'XoopsObjectTree' in tree.php in file /class/xoopstree.php line 45
Notice: Undefined index: extensions in file /class/module.textsanitizer.php line 531
Warning: array_filter() [function.array-filter]: The first argument should be an array in file /class/module.textsanitizer.php line 531
Notice: Undefined index: extensions in file /class/module.textsanitizer.php line 531
Warning: array_filter() [function.array-filter]: The first argument should be an array in file /class/module.textsanitizer.php line 531
Notice: Function xoops_getLinkedUnameFromId() is deprecated, use XoopsUserUtility::getUnameFromId() instead in file /include/functions.legacy.php line 44
Notice: Undefined index: extensions in file /class/module.textsanitizer.php line 531
Warning: array_filter() [function.array-filter]: The first argument should be an array in file /class/module.textsanitizer.php line 531
Notice: Function xoops_getLinkedUnameFromId() is deprecated, use XoopsUserUtility::getUnameFromId() instead in file /include/functions.legacy.php line 44

Queries:
SET NAMES 'utf8'
SELECT * FROM ffstg_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM ffstg_session WHERE sess_id = 'ef05d38cc76059d2b39ea272016ff34d'
SELECT * FROM ffstg_users WHERE uid = '1'
SELECT * FROM ffstg_modules WHERE dirname = 'wflinks'
SELECT * FROM ffstg_config WHERE (conf_modid = '43') ORDER BY conf_order ASC
SELECT * FROM ffstg_wflinks_cat WHERE pid=7 ORDER BY title
SELECT * FROM ffstg_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT DISTINCT gperm_itemid FROM ffstg_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2,26,27)
SELECT b.* FROM ffstg_newblocks b, ffstg_block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,43) AND b.bid IN (35,11,12,10,9,8,7,6,5,34,4,3,2,1,25,24,23,36,22,32,31,30,92,91,89,87,86,90,88,101,100,99,98,97,96,95,56,94,93,29,64,28,26,27,21,20,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51) ORDER BY b.weight,b.bid
SELECT * FROM ffstg_modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC, mid ASC
SELECT * FROM ffstg_group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2' OR gperm_groupid = '26' OR gperm_groupid = '27'))
SELECT * FROM ffstg_modules WHERE dirname = 'news'
SELECT * FROM ffstg_config WHERE (conf_modid = '5') ORDER BY conf_order ASC
SELECT * FROM ffstg_modules WHERE dirname = 'info'
SELECT * FROM ffstg_config WHERE (conf_modid = '28') ORDER BY conf_order ASC
SELECT * FROM ffstg_info WHERE parent_id=0 ORDER BY blockid
SELECT catid,title FROM ffstg_info_cat
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_mainmenu.html') ORDER BY tpl_refid
SELECT * FROM ffstg_modules WHERE dirname = 'pm'
SELECT COUNT(*) FROM `ffstg_priv_msgs` WHERE (read_msg = '0' AND to_userid = '1')
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid
SELECT storyid,homepage FROM ffstg_info WHERE address ='/modules/wflinks/viewcat.php?cid=7'
SELECT * FROM ffstg_info WHERE parent_id=0 ORDER BY blockid
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'info_nav_block.html') ORDER BY tpl_refid
SELECT storyid,homepage FROM ffstg_info WHERE address ='/modules/wflinks/viewcat.php?cid=7'
SELECT * FROM ffstg_info WHERE parent_id=0 ORDER BY blockid
SELECT COUNT(*) FROM ffstg_online WHERE online_uid=1
UPDATE ffstg_online SET online_updated=1228752760, online_module = 43 WHERE online_uid = 1
SELECT * FROM ffstg_online
SELECT COUNT(*) FROM ffstg_online WHERE online_module = '43'
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_online.html') ORDER BY tpl_refid
SELECT pid, title FROM ffstg_wflinks_cat WHERE cid=7
SELECT title, description, nohtml, nosmiley, noxcodes, noimages, nobreak, imgurl, client_id, banner_id FROM ffstg_wflinks_cat WHERE cid =7
SELECT * FROM ffstg_smiles
SELECT indeximage, indexheading FROM ffstg_wflinks_indexpage
SELECT DISTINCT a.* FROM ffstg_wflinks_links a LEFT JOIN ffstg_wflinks_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1228752760 AND (a.expired = 0 OR a.expired > 1228752760) AND a.offline = 0 AND (b.cid=a.cid OR (a.cid=7 OR b.cid=7)) ORDER BY title ASC LIMIT 0, 10
SELECT COUNT(*) FROM ffstg_wflinks_links a LEFT JOIN ffstg_wflinks_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1228752760 AND (a.expired = 0 OR a.expired > 1228752760) AND a.offline = 0 AND (b.cid=a.cid OR (a.cid=7 OR b.cid=7))
SELECT pid, title FROM ffstg_wflinks_cat WHERE cid=7
SELECT * FROM ffstg_modules WHERE dirname = 'pbboard'
SELECT pid, title FROM ffstg_wflinks_cat WHERE cid=7
SELECT * FROM ffstg_modules WHERE dirname = 'pbboard'
SELECT * FROM ffstg_xoopsnotifications WHERE (not_modid = '43' AND not_category = 'global' AND not_uid = '1') ORDER BY not_id ASC
SELECT * FROM ffstg_modules WHERE mid = 43
SELECT * FROM ffstg_xoopsnotifications WHERE (not_modid = '43' AND not_category = 'category' AND not_itemid = '7' AND not_uid = '1') ORDER BY not_id ASC
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'wflinks_viewcat.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'wflinks_linkload.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM ffstg_tplfile f LEFT JOIN ffstg_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_notification_select.html') ORDER BY tpl_refid

Blocks:
Hauptmenü: No Cache
Count-Up: No Cache
Mitgliedsmenü: No Cache
DH-INFO Menüblock: No Cache
DH-INFO Menüblock: No Cache
Wer ist online: No Cache
Einloggen: No Cache

Extra:
XOOPS took 0.391 seconds to load.
XOOPS Boot took 0.028 seconds to load.
Module init took 0.010 seconds to load.
XOOPS output init took 0.063 seconds to load.
Module display took 0.266 seconds to load.
Page rendering took 0.012 seconds to load

Greets

14
ghia
Re: Wflinks - Mysql/Template Error
  • 2008/12/8 16:39

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Can you execute this query in phpMyAdmin?
SELECT DISTINCT a.* FROM ffstg_wflinks_links a
 LEFT JOIN ffstg_wflinks_altcat b ON b
.lid a.lid
 WHERE a
.published AND
  
a.published <= 1228752760 AND
  (
a.expired OR a.expired 1228752760) AND
  
a.offline AND
  (
b.cid=a.cid OR (a.cid=OR b.cid=7))
 
ORDER BY title ASC
 LIMIT 0
10
It should have only two results.

Can you repeat it without the 'distinct'?

The 'b.cid=a.cid OR' clause seems me very odd. I would think it should be left out.

15
FDSG
Re: Wflinks - Mysql/Template Error
  • 2008/12/8 17:01

  • FDSG

  • Just popping in

  • Posts: 16

  • Since: 2008/11/30


Can you repeat it without the 'distinct'? -> What do you mean?

The 'b.cid = a.cid OR' clause me seems very odd. I would think it should be left out. -> This should be in the viewcat.php the line "." AND (b.cid = a.cid OR (a.cid = ". Intval ($ cid)." B.cid OR = ". Intval ($ cid) . "))"" Or? If I remove this then loaded several categories. The problem continues.

I thank you that you are helping me. my English is not exactly the best and can be a little tiring.
thank you anyway

16
McDonald
Re: Wflinks - Mysql/Template Error
  • 2008/12/8 18:07

  • McDonald

  • Home away from home

  • Posts: 1072

  • Since: 2005/8/15


Quote:
The 'b.cid=a.cid OR' clause seems me very odd. I would think it should be left out.

No, you need this because a link (lid) can have alternative categories (altcat).

17
FDSG
Re: Wflinks - Mysql/Template Error
  • 2008/12/8 21:54

  • FDSG

  • Just popping in

  • Posts: 16

  • Since: 2008/11/30


Hi folks!
I've been slowly definitively by the error may be.
Background: I have reinstalled the CMS and the current module installed.
It all works. Then I have in the path by Mainfile can.
Then the modules. Once I module DH-Info "disable everything works.
So the fault lies in this module. Now the question -> There are two modules at these problems or is it a wrong attitude?
Regards

18
McDonald
Re: Wflinks - Mysql/Template Error
  • 2008/12/8 22:38

  • McDonald

  • Home away from home

  • Posts: 1072

  • Since: 2005/8/15


Can you give me a link where I can download the same version of the DH-Info module as you have in use, so I can do some testing?

19
FDSG
Re: Wflinks - Mysql/Template Error
  • 2008/12/8 23:05

  • FDSG

  • Just popping in

  • Posts: 16

  • Since: 2008/11/30



20
ghia
Re: Wflinks - Mysql/Template Error
  • 2008/12/8 23:36

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Quote:
No, you need this because a link (lid) can have alternative categories (altcat).
Yes, but you are looking for the links in a given category (7 in the example).
So you have the full links with category (cid) 7 and then the alternate links, where an existing link from another category is also filed under a second category. So we want also all the alternate links with cid 7. This is the clause ((a.cid = 7) OR (B.cid = 7)).
When you make an OR with b.cid=a.cid you allow also the records where in both tables the link id (join) and the category id (clause) is the same. This could lead to links from another category (eg 3) to be listed, than the one which was searched for (7).
Normally there should be no such records, because that would mean that a link has also the same category in the alternate table has its original. The add alternate category routine should prevent such illogical operations.
Thats the reason why I find the 'b.cid=a.cid OR' clause very odd, but I'm looking forward to the why explained.

Login

Who's Online

138 user(s) are online (105 user(s) are browsing Support Forums)


Members: 0


Guests: 138


more...

Donat-O-Meter

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

Latest GitHub Commits