[phpws-comm-auto] [ phpwebsite-comm-Support Requests-865706 ] error in list of related articles: viewCategory&fatcat_id

[SourceForge.net <no...@so...>]

Support Requests item #865706, was opened at 2003-12-25 12:02
Message generated for change (Comment added) made by adarkling
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=563509&aid=865706&group_id=81360

Category: Module: article
Group: First Level Support
Status: Open
Resolution: None
Priority: 5
Submitted By: cpteos (cpteos)
Assigned to: Nobody/Anonymous (nobody)
Summary: error in list of related articles: viewCategory&fatcat_id

Initial Comment:
article-module 2.0: 

> A very nice feature is to list an overview of all
articles of a category on a single page (link with
abstract ...). It's the headline-link of "what's
related box".

> But the problem is:

In WindowsXP standard-security settings for Internet
Explorer are on a high-level ("Mittel"). Now calling
this link to list an articles-overview:

./index.php?module=fatcat&fatcat[user]=viewCategory&fatcat_id=1&module_title=article

>results in an error-message:

DB Error: syntax error
SELECT * FROM WHERE id = 8 [nativecode=1064 ** You have
an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right
syntax to use near 'WHERE id = 8' at line 1]

>The "normal" user thinks it's a fault of the
websitemaker and willnot try any change of
security-settings or choose another browser.

I did't get this symptom anywhereelse in an
all-modules-installation but there.

>Maybe you have quick&dirty hack or can make a update
to solve this problem.

----------------------------------------------------------------------

Comment By: Eloi George (adarkling)
Date: 2003-12-29 02:39

Message:
Logged In: YES 
user_id=619893

Seasons' Greetings!

Found the bug.

In /mod/article/conf/fatcat.php after:
require_once(PHPWS_SOURCE_DIR.'mod/article/class/ArticleManager.php');

add this line:
$_SESSION['SES_ART_master'] = new PHPWS_ArticleManager;

That should clear up the problem.


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=563509&aid=865706&group_id=81360