Category Content Missing
Moderator: Thorsten
Category Content Missing
Hi Folks,
I'm new to PHPMyFAQ and this forum. I tried searching but couldn't find a solution (possibly just don't know the right keywords yet).
When I click on a category, it tells me how may FAQs there are, but doesn't actually display links to them. The 2 FAQs I've created show up in search and in the Sticky area, but they don't show up as links under the category. The best I can tell is that this is the categoryContent section in the show.tpl template file.
I turned on debug in the /inc/bootstrap.php file, but I saw no debug output - even after restarting the website and recycling the app pool - no difference whether logged in or not.
I'm running MyPHPFAQ 2.8.8 on IIS 8.5, PHP 5.3 and Microsoft SQL Express 2012.
Any help or direction to an existing FAQ would be great.
Thanks!
I'm new to PHPMyFAQ and this forum. I tried searching but couldn't find a solution (possibly just don't know the right keywords yet).
When I click on a category, it tells me how may FAQs there are, but doesn't actually display links to them. The 2 FAQs I've created show up in search and in the Sticky area, but they don't show up as links under the category. The best I can tell is that this is the categoryContent section in the show.tpl template file.
I turned on debug in the /inc/bootstrap.php file, but I saw no debug output - even after restarting the website and recycling the app pool - no difference whether logged in or not.
I'm running MyPHPFAQ 2.8.8 on IIS 8.5, PHP 5.3 and Microsoft SQL Express 2012.
Any help or direction to an existing FAQ would be great.
Thanks!
Aaron
Re: Category Content Missing
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Category Content Missing
Thanks for the response Thorsten. Unfortunately it's still not showing the individual KBs. Tried IE and Chrome after making change, recycling app pool and restarting website.
Aaron
Re: Category Content Missing
Hi,
is it possible to get access to your FAQ?
bye
Thorsten
is it possible to get access to your FAQ?
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Category Content Missing
For security reasons it is not publicly accessible. I know that makes it harder to troubleshoot, but can't be avoided unfortunately. Is there something I can run as a test?
Aaron
Re: Category Content Missing
Hi,
so you don't get any errors if you enable the debug mode. Do you see the category content in the admin section?
so you don't get any errors if you enable the debug mode. Do you see the category content in the admin section?
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Category Content Missing
Without logging in I see no category content in the main panel, but the FAQs populate properly in the Sticky, Latest, and Most popular FAQs panels. Same when I log in.
If I log in and go to Administration -> Edit existing FAQs, I see the categories listed with the correct number of FAQs, and the FAQs show up when I click on a category.
If I log in and go to Administration -> Edit existing FAQs, I see the categories listed with the correct number of FAQs, and the FAQs show up when I click on a category.
Aaron
Re: Category Content Missing
Hi,
I think I have to rebuild your infrastructure.
bye
Thorsten
I think I have to rebuild your infrastructure.
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Category Content Missing
PHP log shows - "[10-Apr-2014 16:45:25 Europe/Berlin] phpMyFAQ warning: sqlsrv_num_rows() expects parameter 1 to be resource, boolean given in C:\phpmyfaq\inc\PMF\DB\Sqlsrv.php on line 206"
Aaron
Re: Category Content Missing
Hi,
ah, that's the reason! I'll check the code!
bye
Thorsten
ah, that's the reason! I'll check the code!
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Category Content Missing
I output the query as faq.php is generating it:
And this is the error I get when I run it directly in SQL Server 2012 Mangement Studio:SELECT
fd.id AS id,
fd.lang AS lang,
fd.sticky AS sticky,
fd.thema AS thema,
fcr.category_id AS category_id,
fv.visits AS visits
FROM
slcfaqdata AS fd
LEFT JOIN
slcfaqcategoryrelations AS fcr
ON
fd.id = fcr.record_id
AND
fd.lang = fcr.record_lang
LEFT JOIN
slcfaqvisits AS fv
ON
fd.id = fv.id
AND
fv.lang = fd.lang
LEFT JOIN
slcfaqdata_group AS fdg
ON
fd.id = fdg.record_id
LEFT JOIN
slcfaqdata_user AS fdu
ON
fd.id = fdu.record_id
WHERE
fd.date_start <= '20140410172626'
AND
fd.date_end >= '20140410172626'
AND
fd.active = 'yes'
AND
fcr.category_id = 3
AND
fd.lang = 'en'
AND ( fdg.group_id IN (-1, 1) OR (fdu.user_id IN (-1, 2) OR fdg.group_id IN (-1, 1)) )
GROUP BY fd.id, fd.lang, fcr.category_id, fv.visits
ORDER BY fd.sticky DESC, fd.id DESC
If I add fd.sticky to the GROUP BY clause, then it complains about the slcfaqdata.thema being invalid. If I add that, then I get:Msg 8120, Level 16, State 1, Line 5
Column 'slcfaqdata.sticky' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Not sure where to go from here.Msg 306, Level 16, State 2, Line 41
The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
Aaron
Re: Category Content Missing
Hi,
looks like MS SQL Server has problems with this query, I think I can remove the ORDER BY part and do that in PHP.
bye
Thorsten
looks like MS SQL Server has problems with this query, I think I can remove the ORDER BY part and do that in PHP.
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Category Content Missing
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist