[ABD] PhpBB3 Knowledge Base

[Stickygreen]

That's on your end having to do with the url.

[IronDogg]

That's on your end having to do with the url.

Ah thanks... Do you know what the potential issue is for me to check? It worked good before the update and the update didn't have any changes to overall header so I was a bit perplexed...

[poppertom69]

I have an old bug that came up again Imladris. The link in my overall header to my mp3 player (for example) works fine when clicked on from the index, but when I go into a category or article within the knowledge base, then click on the mp3 player link from there, I get an error message as thus:

Not Found
The requested URL /Category/Environment_In_General/mp3player.swf was not found on this server.

or

Not Found
The requested URL /Article/The_Dangers_of_Plastic_Bags/mp3player.swf was not found on this server.

Can you fix this issue again, or is it a coding error on my end?

That is to do with the coding in your overall_header.html file can you send the coding you have for that link so I can sort it for you

[IronDogg]

That is to do with the coding in your overall_header.html file can you send the coding you have for that link so I can sort it for you

Thanks poppertom, all the links in the overall header work except for the radio, mp3 player, and chat links. They give me that error I mentioned before. Here is the rightside linklist code for that area in overall header:

<ul class="linklist rightside">
<!-- IF not S_IS_BOT and S_USER_LOGGED_IN -->
<li class="icon-logout"><a href="radio.php" onclick="window.open('radio.php','','toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=yes, resizable=yes, width=440, height=380, left=20, top=20'); return false;">{L_RADIO}</a></li>
<li class="icon-bump"><a href="javascript:musics_pop();" title="{L_MP3_PLAYER_EXPLAIN}">{L_MP3_PLAYER}</a></li>
<!-- ENDIF -->
<!-- IF S_USER_LOGGED_IN -->
<li class="icon-members">
<a href="./chat/flashchat.php" target="_blank" img src="" title="FlashChat Login" accesskey="1">Chat</a>
</li>
<!-- ENDIF -->
<li class="icon-ucp"><a href="{U_ARCADE}" title="{L_ARCADE_EXPLAIN}">{L_ARCADE}</a></li>
<li><img src="{T_THEME_PATH}/images/cart.png" alt="Classified Ads" />&nbsp;<a href="{U_CLASSIFIEDS}" title="{L_CLASSIFIEDS}">{L_CLASSIFIEDS} {L_TOTAL_ADS_COUNT}</a></li>
<!-- IF ENABLE_TWITTER -->
<li><img src="{T_THEME_PATH}/images/twitter.png" alt="Twitter" />&nbsp;<a href="{TWITTER_LINK}">{L_TWITTER}</a></li>
<!-- ENDIF -->
<!-- IF S_HIDE_LINKSMOD -->
<li class="icon-links"><a href="{U_LINKS}" title="{L_LINKS_PAGE}">{L_LINKS}</a></li>
<!-- ENDIF -->
<li class="icon-kb"><a href="{U_KB}" title="{L_KB_EXPLAIN}">{L_KB}</a></li>
<li class="icon-rules"><a href="{U_BOARD_RULES}" title="{L_BOARD_RULES}">{L_BOARD_RULES}</a></li>
<li class="icon-faq"><a href="{U_FAQ}" title="{L_FAQ_EXPLAIN}">{L_FAQ}</a></li>
<!-- IF not S_IS_BOT -->
<!-- IF S_DISPLAY_MEMBERLIST --><li class="icon-members"><a href="{U_MEMBERLIST}" title="{L_MEMBERLIST_EXPLAIN}">{L_MEMBERLIST}</a></li><!-- ENDIF -->
<!-- IF not S_USER_LOGGED_IN and S_REGISTER_ENABLED and not (S_SHOW_COPPA or S_REGISTRATION) --><li class="icon-register"><a href="{U_REGISTER}">{L_REGISTER}</a></li><!-- ENDIF -->
<li class="icon-logout"><a href="{U_LOGIN_LOGOUT}" title="{L_LOGIN_LOGOUT}" accesskey="x">{L_LOGIN_LOGOUT}</a></li>
<!-- ENDIF -->
</ul>

[poppertom69]

Right what is happening is when you enable the seo setting it creates a work around for the links to be able to be set out the way they are. The only way for me to change this for you is to change some of your code, but i need the links to all those mods so i can tell you what to change. In the mean time I would suggest disabling the seo setting. Until you give me those links and i can fix it.

[IronDogg]

Hi Poppertom,

I sent you a bunch of links in a pm. Hopefully they help?

[poppertom69]

Code: Select all

<ul class="linklist rightside">
<!-- IF not S_IS_BOT and S_USER_LOGGED_IN -->
<li class="icon-logout"><a href="{ROOT_PATH}radio.php" onclick="window.open('{ROOT_PATH}radio.php','','toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=yes, resizable=yes, width=440, height=380, left=20, top=20'); return false;">{L_RADIO}</a></li>
<li class="icon-bump"><a href="#" onlick="window.open('{ROOT_PATH}mp3player.swf?xml=mp3config.xml','musics','width=380,height=305,resizable=yes,scrollbars=no');" title="{L_MP3_PLAYER_EXPLAIN}">{L_MP3_PLAYER}</a></li>
<!-- ENDIF -->
<!-- IF S_USER_LOGGED_IN -->
<li class="icon-members">
<a href="{ROOT_PATH}chat/flashchat.php" target="_blank" img src="" title="FlashChat Login" accesskey="1">Chat</a>
</li>
<!-- ENDIF -->
<li class="icon-ucp"><a href="{U_ARCADE}" title="{L_ARCADE_EXPLAIN}">{L_ARCADE}</a></li>
<li><img src="{T_THEME_PATH}/images/cart.png" alt="Classified Ads" />&nbsp;<a href="{U_CLASSIFIEDS}" title="{L_CLASSIFIEDS}">{L_CLASSIFIEDS} {L_TOTAL_ADS_COUNT}</a></li>
<!-- IF ENABLE_TWITTER -->
<li><img src="{T_THEME_PATH}/images/twitter.png" alt="Twitter" />&nbsp;<a href="{TWITTER_LINK}">{L_TWITTER}</a></li>
<!-- ENDIF -->
<!-- IF S_HIDE_LINKSMOD -->
<li class="icon-links"><a href="{U_LINKS}" title="{L_LINKS_PAGE}">{L_LINKS}</a></li>
<!-- ENDIF -->
<li class="icon-kb"><a href="{U_KB}" title="{L_KB_EXPLAIN}">{L_KB}</a></li>
<li class="icon-rules"><a href="{U_BOARD_RULES}" title="{L_BOARD_RULES}">{L_BOARD_RULES}</a></li>
<li class="icon-faq"><a href="{U_FAQ}" title="{L_FAQ_EXPLAIN}">{L_FAQ}</a></li>
<!-- IF not S_IS_BOT -->
<!-- IF S_DISPLAY_MEMBERLIST --><li class="icon-members"><a href="{U_MEMBERLIST}" title="{L_MEMBERLIST_EXPLAIN}">{L_MEMBERLIST}</a></li><!-- ENDIF -->
<!-- IF not S_USER_LOGGED_IN and S_REGISTER_ENABLED and not (S_SHOW_COPPA or S_REGISTRATION) --><li class="icon-register"><a href="{U_REGISTER}">{L_REGISTER}</a></li><!-- ENDIF -->
<li class="icon-logout"><a href="{U_LOGIN_LOGOUT}" title="{L_LOGIN_LOGOUT}" accesskey="x">{L_LOGIN_LOGOUT}</a></li>
<!-- ENDIF -->
</ul>

try replacing your code with that and that should do it let me know

[IronDogg]

try replacing your code with that and that should do it let me know

Thanks! The other links work now, however the mp3 player link does not open at all. Something to do with the ahref="#" thing?

[Geisthund]

Hi

I've just installed your latest release over a previous version of KB which I uninstalled before installing the new version.
The install appeared to go ok but I'm now getting the error below when I access KB via the KB tab in UCP

General Error
SQL ERROR [ mysql4 ]

Unknown column 'g.group_skip_auth' in 'where clause' [1054]

SQL

SELECT a.forum_id, a.auth_option_id, a.auth_role_id, a.auth_setting FROM phpbb3_article_acl_groups a, phpbb3_user_group ug, phpbb3_groups g WHERE a.group_id = ug.group_id AND g.group_id = ug.group_id AND ug.user_pending = 0 AND NOT (ug.group_leader = 1 AND g.group_skip_auth = 1) AND ug.user_id = 2

BACKTRACE


FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/kb_auth.php
LINE: 238
CALL: dbal_mysql->sql_query()

FILE: includes/kb_auth.php
LINE: 158
CALL: kb_auth->acl_raw_data_single_user()

FILE: includes/kb_auth.php
LINE: 59
CALL: kb_auth->acl_cache()

FILE: includes/ucp/ucp_kb.php
LINE: 45
CALL: kb_auth->acl()

FILE: includes/functions_module.php
LINE: 507
CALL: ucp_kb->main()

FILE: ucp.php
LINE: 334
CALL: p_master->load_active()

plus a similar error via the links in .MOD: Category permissions & Knowledge Base Roles

General Error
SQL ERROR [ mysql4 ]

Unknown column 'g.group_skip_auth' in 'where clause' [1054]

SQL

SELECT a.forum_id, a.auth_option_id, a.auth_role_id, a.auth_setting FROM phpbb3_article_acl_groups a, phpbb3_user_group ug, phpbb3_groups g WHERE a.group_id = ug.group_id AND g.group_id = ug.group_id AND ug.user_pending = 0 AND NOT (ug.group_leader = 1 AND g.group_skip_auth = 1) AND ug.user_id = 2

BACKTRACE


FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/kb_auth.php
LINE: 238
CALL: dbal_mysql->sql_query()

FILE: includes/kb_auth.php
LINE: 158
CALL: kb_auth->acl_raw_data_single_user()

FILE: includes/kb_auth.php
LINE: 59
CALL: kb_auth->acl_cache()

FILE: includes/acp/acp_kb_permissions.php
LINE: 41
CALL: kb_auth->acl()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_kb_permissions->main()

FILE: adm/index.php
LINE: 78
CALL: p_master->load_active()

Also found when accessing www.mysite.com/kb.php

SQL ERROR [ mysql4 ]

Unknown column 'g.group_skip_auth' in 'where clause' [1054]

[Imladris]

Are you sure you have installed it on a phpBB version 3.0.6?

[Geisthund]

upgrade to 3.06 last night before KB install
HTH

[Imladris]

upgrade to 3.06 last night before KB install
HTH

Sure you have updated the DB then, because the DB field it reports missing has nothing to do with the KB what so ever...

[Geisthund]

Opps forgot to run the database update.
Cheers

[Imladris]

Just thought id give some feedback, installed on a test board (exact copy of my live board)

Main knowledge base view. Classic view tested only. although i deleted all articles the latest article list was still populated?

I will look into this... it is quite possible, the latest articles are still rather dodgy. Just one question, did you delete them one by one?

Clicking on breadcrumb (article title only results in 404 page not found) all other parts of breadcrumb are fine

Will look into it.

I cannot recreate these 2 errors locally, could you please describe them more in detail, perhaps provide a screenshot for me.

Any news on these 2 errors? I will be gone for a week now, and if no new bugs have appeared when I come back, we might be ready for 1.0.2.

[Artack]

I have problem with non english characters in name of articles, if seo turn on
Any solutions?