[ABD] PhpBB3 Knowledge Base

Any abandoned MODs will be moved to this forum.

WARNING: MODs in this forum are not currently being supported or maintained by the original MOD author. Proceed at your own risk.
Forum rules
IMPORTANT: MOD Development Forum rules

WARNING: MODs in this forum are not currently being supported nor updated by the original MOD author. Proceed at your own risk.
Locked
User avatar
Stickygreen
Registered User
Posts: 179
Joined: Mon Oct 13, 2008 9:15 pm

Re: [RC] PhpBB3 Knowledge Base

Post by Stickygreen »

That's on your end having to do with the url.
IronDogg
Registered User
Posts: 130
Joined: Thu Sep 26, 2002 11:47 pm

Re: [RC] PhpBB3 Knowledge Base

Post by IronDogg »

Stickygreen wrote: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
Registered User
Posts: 383
Joined: Wed Jun 06, 2007 7:44 am
Location: Bucks, UK
Name: Tom Martin

Re: [RC] PhpBB3 Knowledge Base

Post by poppertom69 »

IronDogg wrote: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
Do one thing everyday, that scares you!
IronDogg
Registered User
Posts: 130
Joined: Thu Sep 26, 2002 11:47 pm

Re: [RC] PhpBB3 Knowledge Base

Post by IronDogg »

poppertom69 wrote: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
Registered User
Posts: 383
Joined: Wed Jun 06, 2007 7:44 am
Location: Bucks, UK
Name: Tom Martin

Re: [RC] PhpBB3 Knowledge Base

Post by 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.
Do one thing everyday, that scares you!
IronDogg
Registered User
Posts: 130
Joined: Thu Sep 26, 2002 11:47 pm

Re: [RC] PhpBB3 Knowledge Base

Post by IronDogg »

Hi Poppertom,

I sent you a bunch of links in a pm. Hopefully they help?
poppertom69
Registered User
Posts: 383
Joined: Wed Jun 06, 2007 7:44 am
Location: Bucks, UK
Name: Tom Martin

Re: [RC] PhpBB3 Knowledge Base

Post by 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
Do one thing everyday, that scares you!
IronDogg
Registered User
Posts: 130
Joined: Thu Sep 26, 2002 11:47 pm

Re: [RC] PhpBB3 Knowledge Base

Post by IronDogg »

poppertom69 wrote: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
Registered User
Posts: 352
Joined: Fri Jul 01, 2005 1:23 pm

Re: [RC] PhpBB3 Knowledge Base

Post by 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
Registered User
Posts: 190
Joined: Sat Oct 22, 2005 2:53 pm
Location: Copenhagen, Denmark
Name: Andreas Nexmann
Contact:

Re: [RC] PhpBB3 Knowledge Base

Post by Imladris »

Are you sure you have installed it on a phpBB version 3.0.6?
Best regards,
Andreas Nexmann aka. Imladris, Danish Phpbb Forum admin.
Geisthund
Registered User
Posts: 352
Joined: Fri Jul 01, 2005 1:23 pm

Re: [RC] PhpBB3 Knowledge Base

Post by Geisthund »

upgrade to 3.06 last night before KB install
HTH
Imladris
Registered User
Posts: 190
Joined: Sat Oct 22, 2005 2:53 pm
Location: Copenhagen, Denmark
Name: Andreas Nexmann
Contact:

Re: [RC] PhpBB3 Knowledge Base

Post by Imladris »

Geisthund wrote: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...
Best regards,
Andreas Nexmann aka. Imladris, Danish Phpbb Forum admin.
Geisthund
Registered User
Posts: 352
Joined: Fri Jul 01, 2005 1:23 pm

Re: [RC] PhpBB3 Knowledge Base

Post by Geisthund »

Opps forgot to run the database update.
Cheers
Imladris
Registered User
Posts: 190
Joined: Sat Oct 22, 2005 2:53 pm
Location: Copenhagen, Denmark
Name: Andreas Nexmann
Contact:

Re: [RC] PhpBB3 Knowledge Base

Post by Imladris »

Imladris wrote:
Imladris wrote:
zake black wrote: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?
zake black wrote: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.
Best regards,
Andreas Nexmann aka. Imladris, Danish Phpbb Forum admin.
Artack
Registered User
Posts: 312
Joined: Thu Feb 07, 2008 11:26 pm

Re: [RC] PhpBB3 Knowledge Base

Post by Artack »

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

Return to “[3.0.x] Abandoned MODs”