[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
7emper5i
Registered User
Posts: 118
Joined: Mon May 04, 2009 5:31 pm
Location: Germany Cologne
Name: Philipp R.
Contact:

Re: [RC] PhpBB3 Knowledge Base

Post by 7emper5i »

Code: Select all

SQL ERROR [ mysql4 ]

Column 'cat_name' cannot be null [1048]

SQL

INSERT INTO phpbb_article_cats (parent_id, left_id, right_id, cat_name, cat_desc, cat_desc_bitfield, cat_desc_options, cat_desc_uid, cat_image, cat_articles, latest_ids) VALUES (0, 1, 2, NULL, NULL, '', 7, '', '', 0, 'a:0:{}')

BACKTRACE

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

FILE: includes/functions_install_kb.php
LINE: 629
CALL: dbal_mysql->sql_query()

FILE: kb.php
LINE: 43
CALL: kb_install()
Do you guys maybe know, where my mistake in editing the code might be?


by the way:

editing the htacces with

Code: Select all

RewriteEngine on

Rewriterule ^(.+)/(.+)/a([0-9]*).html					./includes/kb_plugins/seo.php?a=$3&%{QUERY_STRING} [L]
Rewriterule ^(.+)/(.+)/c([0-9]*).html					./includes/kb_plugins/seo.php?c=$3&%{QUERY_STRING} [L]
Rewriterule ^tag/(.+)/					
does not work either for me. When I am adding this code, I am not able to enter my board at all.

In the ACP all the editing stuff is added, but when I try to go to the KnowledgeBase it says:

Code: Select all

You have closed the browser or have been cut off from the internet in the middle of a page load. Unfortunately this has caused the installation to fail and is, most likely, broken. We recommend you to uninstall the remnants manually and restart the installation from scratch.
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 »

7emper5i wrote:

Code: Select all

SQL ERROR [ mysql4 ]

Column 'cat_name' cannot be null [1048]

SQL

INSERT INTO phpbb_article_cats (parent_id, left_id, right_id, cat_name, cat_desc, cat_desc_bitfield, cat_desc_options, cat_desc_uid, cat_image, cat_articles, latest_ids) VALUES (0, 1, 2, NULL, NULL, '', 7, '', '', 0, 'a:0:{}')

BACKTRACE

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

FILE: includes/functions_install_kb.php
LINE: 629
CALL: dbal_mysql->sql_query()

FILE: kb.php
LINE: 43
CALL: kb_install()
Do you guys maybe know, where my mistake in editing the code might be?


by the way:

editing the htacces with

Code: Select all

RewriteEngine on

Rewriterule ^(.+)/(.+)/a([0-9]*).html					./includes/kb_plugins/seo.php?a=$3&%{QUERY_STRING} [L]
Rewriterule ^(.+)/(.+)/c([0-9]*).html					./includes/kb_plugins/seo.php?c=$3&%{QUERY_STRING} [L]
Rewriterule ^tag/(.+)/					
does not work either for me. When I am adding this code, I am not able to enter my board at all.

In the ACP all the editing stuff is added, but when I try to go to the KnowledgeBase it says:

Code: Select all

You have closed the browser or have been cut off from the internet in the middle of a page load. Unfortunately this has caused the installation to fail and is, most likely, broken. We recommend you to uninstall the remnants manually and restart the installation from scratch.
See http://kb.softphp.dk/viewtopic.php?f=9&t=159&p=744#p744
Best regards,
Andreas Nexmann aka. Imladris, Danish Phpbb Forum admin.
User avatar
Maertske
Registered User
Posts: 13
Joined: Sun Apr 04, 2010 9:14 pm
Contact:

Re: [RC] PhpBB3 Knowledge Base

Post by Maertske »

Imladris wrote:
7emper5i wrote:Change the description in the separate language packs

html/language/yourlanguage/common.php

Code: Select all

	'KB'					=> 'KB',
	'KIB'					=> 'KiB',
	'KNOWLEDGE_BASE'		=> 'Knowledge Base',
	'KB_EXPLAIN'			=> 'Knowledge Base',
to whatever you like.
As well as leaving the field in the ACP for KB title empty, that should do the trick.
Hi Imladris,

For some reason this isn't working on my forum. I checked my language files in common.php and everything is okay there. But if I leave the field in the ACP for KB title empty, then there is nothing showing the name in the overall header? And the icon of the KB is smashed to the top of the header??? (See screenshot)

Image

If I fill in a name in the KB title name, then it is showing this name in all languages..

I also have another question. I can't find how to delete, move or edit articles? I think my permissions are okay, but can't find a way to do this?

Thx for your help!

Hans
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 »

Maertske wrote:
Imladris wrote:
7emper5i wrote:Change the description in the separate language packs

html/language/yourlanguage/common.php

Code: Select all

	'KB'					=> 'KB',
	'KIB'					=> 'KiB',
	'KNOWLEDGE_BASE'		=> 'Knowledge Base',
	'KB_EXPLAIN'			=> 'Knowledge Base',
to whatever you like.
As well as leaving the field in the ACP for KB title empty, that should do the trick.
Hi Imladris,

For some reason this isn't working on my forum. I checked my language files in common.php and everything is okay there. But if I leave the field in the ACP for KB title empty, then there is nothing showing the name in the overall header? And the icon of the KB is smashed to the top of the header??? (See screenshot)

Image

If I fill in a name in the KB title name, then it is showing this name in all languages..
There is a slight bug in the code the mod changes for includes/functions.php I'm afraid. :oops: Follow this quick guide and it should fix your problems:
Open: includes/functions.php
Find:

Code: Select all

'L_KB' => (isset($config['kb_link_name'])) ? $config['kb_link_name'] : $user->lang['KB'],
Replace with:

Code: Select all

'L_KB' => (isset($config['kb_link_name']) && $config['kb_link_name'] != '') ? $config['kb_link_name'] : $user->lang['KB'],
Save and reupload the file.
Maertske wrote:I also have another question. I can't find how to delete, move or edit articles? I think my permissions are okay, but can't find a way to do this?

Thx for your help!

Hans
Please check this tutorial for information on how to setup permissions.
Best regards,
Andreas Nexmann aka. Imladris, Danish Phpbb Forum admin.
User avatar
Maertske
Registered User
Posts: 13
Joined: Sun Apr 04, 2010 9:14 pm
Contact:

Re: [RC] PhpBB3 Knowledge Base

Post by Maertske »

Thanks, problem is fixed now....
Turbid
Registered User
Posts: 40
Joined: Thu Jun 04, 2009 5:36 am
Contact:

Re: [RC] PhpBB3 Knowledge Base

Post by Turbid »

How close is this to a release version?
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 »

It has been submitted to the MODDB just waiting to hear from the mod team about validation!
Do one thing everyday, that scares you!
User avatar
Maertske
Registered User
Posts: 13
Joined: Sun Apr 04, 2010 9:14 pm
Contact:

Re: [RC] PhpBB3 Knowledge Base

Post by Maertske »

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?
Hi Imladris,

I have the same problem as zake black did, but I haven't seen a solution for this yet. Problem is like this: Deleted 1 article, but it is still showing in the latest article plugin list. How can i get rid of this?

Thx!
User avatar
therat
Registered User
Posts: 285
Joined: Sun Apr 07, 2002 6:06 pm
Contact:

Re: [RC] PhpBB3 Knowledge Base

Post by therat »

At the moment each category in the KB has it's own RSS feed, is there any way of merging them in to one feed or intergrating them in to the main forum feed?
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 »

therat wrote:At the moment each category in the KB has it's own RSS feed, is there any way of merging them in to one feed or intergrating them in to the main forum feed?
Not yet I'm afraid, but duly noted as feature request.
Best regards,
Andreas Nexmann aka. Imladris, Danish Phpbb Forum admin.
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 »

I have released a BETA converter from Mini-KB to this mod, see here for more information.
:D
Best regards,
Andreas Nexmann aka. Imladris, Danish Phpbb Forum admin.
nutnut
Registered User
Posts: 20
Joined: Mon Apr 12, 2010 6:20 pm
Contact:

Re: [RC] PhpBB3 Knowledge Base

Post by nutnut »

Is there a add on for susilver2 ?
User avatar
irakly
Registered User
Posts: 16
Joined: Sat Jan 16, 2010 3:17 pm

Re: [RC] PhpBB3 Knowledge Base

Post by irakly »

subsilver2 needed.... :cry:
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 »

There is still no subsilver2 available, I will release it as soon as possible.

UPDATE: While I am awaiting the mod to be validated (just had a deny and resubmitted changes) I am putting the finishing touches on the converter and I have started working on subsilver2... at the moment I am 30% into the templates, and it looks okay. I am no stylist :P
Best regards,
Andreas Nexmann aka. Imladris, Danish Phpbb Forum admin.
User avatar
mfrankena
Registered User
Posts: 128
Joined: Sun Apr 17, 2005 3:11 pm

Re: [RC] PhpBB3 Knowledge Base

Post by mfrankena »

oh my god Imladris, i love you love you love you love you .... when you finish subsilver 2 :mrgreen: :mrgreen: :mrgreen: :mrgreen: :mrgreen: :twisted:
Regards,
Martin

Sites: BF2CC Admin // 2142CC Admin // M.B.T. Admin // Homepage
Locked

Return to “[3.0.x] Abandoned MODs”