1
FDSG
Re: Wflinks - Mysql/Template Error
  • 2008/12/10 10:33

  • FDSG

  • Just popping in

  • Posts: 16

  • Since: 2008/11/30


It works! Thank you. Finally, it worked!
Thank you



2
FDSG
Re: Wflinks - Mysql/Template Error
  • 2008/12/9 13:57

  • FDSG

  • Just popping in

  • Posts: 16

  • Since: 2008/11/30


I will make very grateful.



3
FDSG
Re: Wflinks - Mysql/Template Error
  • 2008/12/9 12:55

  • FDSG

  • Just popping in

  • Posts: 16

  • Since: 2008/11/30


Thank you
And what should I do now best?



4
FDSG
Re: Wflinks - Mysql/Template Error
  • 2008/12/9 0:44

  • FDSG

  • Just popping in

  • Posts: 16

  • Since: 2008/11/30


True but I prefer währe if these flaws at the end of the query are displayed somewhere in the middle instead.



5
FDSG
Re: Wflinks - Mysql/Template Error
  • 2008/12/8 23:46

  • FDSG

  • Just popping in

  • Posts: 16

  • Since: 2008/11/30


Well this is too complicated for me.
Until now we have found the error, I am reassured.
I hope this can somehow be resolved.
With Love



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

  • FDSG

  • Just popping in

  • Posts: 16

  • Since: 2008/11/30





7
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



8
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



9
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



10
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




TopTop
(1) 2 »



Login

Who's Online

152 user(s) are online (118 user(s) are browsing Support Forums)


Members: 0


Guests: 152


more...

Donat-O-Meter

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

Latest GitHub Commits