[ABD] PhpBB3 Knowledge Base

7emper5i · Post by **7emper5i** » Sat Apr 24, 2010 2:03 pm

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 · Post by **Imladris** » Mon Apr 26, 2010 1:35 pm

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

Maertske · Post by **Maertske** » Wed May 05, 2010 8:31 am

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)

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 · Post by **Imladris** » Wed May 05, 2010 10:45 am

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)

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.

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.

Maertske · Post by **Maertske** » Wed May 05, 2010 11:34 am

Thanks, problem is fixed now....

Turbid · Post by **Turbid** » Thu May 06, 2010 1:49 am

How close is this to a release version?

poppertom69 · Post by **poppertom69** » Thu May 06, 2010 10:12 am

It has been submitted to the MODDB just waiting to hear from the mod team about validation!

Maertske · Post by **Maertske** » Fri May 07, 2010 7:40 am

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!

therat · Post by **therat** » Sat May 08, 2010 10:33 pm

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 · Post by **Imladris** » Sat May 08, 2010 10:36 pm

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.

Imladris · Post by **Imladris** » Mon May 10, 2010 12:16 pm

I have released a BETA converter from Mini-KB to this mod, see here for more information.

nutnut · Post by **nutnut** » Mon May 10, 2010 8:36 pm

Is there a add on for susilver2 ?

irakly · Post by **irakly** » Thu May 20, 2010 11:15 am

subsilver2 needed....

Imladris · Post by **Imladris** » Thu May 20, 2010 11:20 am

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

mfrankena · Post by **mfrankena** » Tue May 25, 2010 4:56 pm

oh my god Imladris, i love you love you love you love you .... when you finish subsilver 2

advertisements