Page 1 of 1
Recent articles block (Solved)

Posted:
Sun Jan 21, 2007 2:46 am
Author: krillmeed
Your phpBB Version: 2.0.22
phpBB Type: phpBB / IMPortal
MODs: Yes
Your knowledge: Basic Knowledge
Board URL: http://www.krillmeed.com/forum/index.php PHP Version: MySQL Version: What was done before the problem appeared?Upgraded from Integramod 1.40 What was done to try to solve the problem?Block deactivated De.scription and MessageSince upgrading to the 1.41 version, my recent aricles block does not work anymore. When i activate it, this is what is say
[code]General Error Could not query users DEBUG MODE SQL Error ]
strange thing is, its only 3 files, and the KB articles are still were they always were

<img>
Re: Recent articles block

Posted:
Sun Jan 21, 2007 5:12 am
Author: Dr. Bantham
I have this identical problem and had to turn off the block in order for IM Portal to display.
Re: Recent articles block

Posted:
Sun Jan 21, 2007 5:40 am
Author: krillmeed
"Dr. Bantham";p="19995" wrote:I have this identical problem and had to turn off the block in order for IM Portal to display.
Thats what i have done, with the mod it is only 3 small files and nothing done to the database, so the problem must be in one of those files which needs to be changed <img>

Posted:
Sun Jan 21, 2007 9:02 am
Author: IntegraMOD
From the error your are showing there is a table missing in you MySql look and see if table kb_articles exists and look in your old 1.40 database to see if it is there also, if you find it in 1.40 export it and add it to your 1.41 database

Posted:
Mon Jan 22, 2007 9:19 am
Author: krillmeed
The table is still there as it ever was before i upgraded, and the forum it stores them in still shows them, as also in the ACP
Re: Recent articles block

Posted:
Mon Jan 22, 2007 1:57 pm
Author: Teelk
Is the KB MOD itself working without any problems? If so, it's probably that the table differences between KB MOD .97 and 2.0.2 are different and so the Recent Articles Block is looking in the wrong place. I'll take a look.

Posted:
Mon Jan 22, 2007 11:13 pm
Author: krillmeed
Thanks, no hurry, my members can still read them in the forum <img>
Re: Recent articles block

Posted:
Tue Jan 23, 2007 12:03 am
Author: Teelk
If anyone can provide me a copy of this block that would be great. The one in downloads isn't working and I can't find my copy.

Posted:
Tue Jan 23, 2007 12:39 pm
Author: krillmeed
Check you pm <img>
Re: Recent articles block

Posted:
Wed Jan 24, 2007 5:53 pm
Author: Dr. Bantham
In my case, the phpbb prefix seems to be missing from the table call, or at least that is what is implied by the error message:
SQL Error : 1146 Table 'xxxxx_xxxxx.kb_articles' doesn't exist
The actual table is xxxxx_xxxxx.phpbb_kb_articles
I hope this helps!

Posted:
Wed Jan 24, 2007 10:48 pm
Author: krillmeed
I think that is exactly the fault with mine as well
Re: Recent articles block

Posted:
Thu Jan 25, 2007 11:50 pm
Author: Teelk
That was infact the problem. The KB MOD was written for both phpBB and mxBB and so I had to add a line that would tell the block that it was installed in phpBB and not mxBB so it would process the correct code.
[url=http]The download has been updated.[/url] - Just overwrite the files.

Posted:
Fri Jan 26, 2007 5:44 am
Author: krillmeed
Thanks works perfectly now <img>
Re: Recent articles block (Solved)

Posted:
Fri Jan 26, 2007 10:57 am
Author: Dr. Bantham
Yep - works like a charm. Thanks, Teelk!