Knowledge Base Error

[DjPorkchop]

I posted an article in the KB on my test board and on submission, I got a headers already sent error in functions.php. I checked the file for a white space before and after the phptags and I found none. I figured that might be the cause since that is normally the cause of the headers error.

Then after I got that error, it immediately kicks me over to another page that shows a sql error.

[img]http://www.thunderva.com/images/kberror.jpg[/img]


I then went back and posted another one. This time I did not receive a headers error, but it did forward me to the posted pic page again.

[Helter]

did you setup the kb in the acp before adding the article?

[DjPorkchop]

Yes I sure did. It was a WAMP install. I'm gonna delete it and install it again just to be sure. But I am pretty positive I set up the KB first.

[Helter]

I ask because the only time I ever received a similar error was when I tried to add an article before I created a category in an earlier version of the KB mod.

[DjPorkchop]

Well, I created a category first, then thats when I logged in over here to check up on what exactly the types were. After I figured that out, that is when I created an article.

Like I said, it is on a local host server WAMP, So here in about an hour after I get back from getting my bangs trimmed up, I am going to do a fresh install and try one more time just to make sure that I can confirm what I am saying. I don't want you searching for something you already had the answer to. I'll post back in an hour or so and let you know.

[DjPorkchop]

Brand new virgin install on WAMP mySQl 5.1.36 php 5.3.0


Created a KB Category and sub category

Went and created types.

here is the result trying to post an article.

[img]http://www.thunderva.com/images/kberror3.jpg[/img]

and this is what that page goes to immediately after

[img]http://www.thunderva.com/images/error4.jpg[/img]


No mods installed no template changes no nothing. Plain jane virgin IM3

is it possible that it is a server config problem? I have tried IM 1.4.1 installs on it and the KB works just fine though.

[Blue-Blood]

I have same problem
Fresh install
Installed on XAMPP 1.7.3 PHP: 5.3.1

[Helter]

i dont know about xamp and wamp but im running php 5.3.1 on the server and I cannot duplicate this error.

[DjPorkchop]

My WAMP server is running 5.3.0 php and 5.1.36 mysql. I actually forgot about this thread. I have not tried to figure this problem out in quite some time. I'll give it a go again after I update WAMP and see what happens.

[Blue-Blood]

So i installed im3 on my host IXwebHost
Here you can see it first hand
http://stargateworldportal.com/im3/know ... w.php?id=1

Login info
Blue Blood
TYUgq0VxccF8

[Blue-Blood]

I made this post at about 1pm and now its 9pm and the google bot is indexing the site
Followed from here i guess..
I have never submitted this site or had any site on this domain before...

LOL... now I know were to post my links to get them indexed in less then a day <img>

[Helter]

ive got some time on friday so ill go through the mod to see what is up with it.

[Blue-Blood]

Hey, Helter

did you ever get time to check out this SQL errror.
Thanks

[Helter]

I cannot recreate this problem so the error logs are useless.
I did however update the current mod to the latest version and still no problems.
Try this. Unzip and upload these files, over-writing your current files.
There are no file edits, or sql changes in this update

You will have to manually add the modCP section
[*]go to acp/system/Moderator Control Panel
[*]in the "Create new module box, add "KB_NAME" -without the quotes
Module type]Click on the new "Knowledge Base" catagory
[*]In the right side dropdown menu marked "add module" select and add and enable the following modules
Acrtivate article
Reported articles
Overview

Delete all your caches and try the KB mod again

[Blue-Blood]

Now I get this error when I submit a KB article and it wont make the post.
before I get error after the post when it redirects to view the post.

[code]General ErrorSQL ERROR [ mysqli ]  Field 'page_uri' doesn't have a default value [1364]  SQL  INSERT INTO phpbb_kb_article (titel, article, description, cat_id, type_id, enable_bbcode, enable_smilies, enable_magic_url, post_id, last_edit_user, last_change, bbcode_bitfield, bbcode_uid, bbcode_options, has_attachment, post_time, user_id) VALUES ('bnmb', 'sdflkjsldjflksdf', 'nokhdofs', 1, 1, 1, 1, 1, 0, '2', 1283916234, '', '', 7, '0', 1283916234, '2')  BACKTRACE  FILE]

again you can see it first hand
http://stargateworldportal.com/im3/

Login info
Blue Blood
TYUgq0VxccF8