Recent articles block (Solved)

Support for IntegraMOD 141

Moderator: Integra Moderator

Recent articles block (Solved)

PostAuthor: krillmeed » Sun Jan 21, 2007 2:46 am

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 Message

Since 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 :D <img>
Last edited by krillmeed on Fri Jan 26, 2007 5:44 am, edited 1 time in total.

krillmeed
Sr Integra Member
Sr Integra Member
 
Posts: 301
Likes: 0 post
Liked in: 0 post
Joined: Sat May 27, 2006 1:34 am
Cash on hand: 0.00

Re: Recent articles block

PostAuthor: Dr. Bantham » Sun Jan 21, 2007 5:12 am

I have this identical problem and had to turn off the block in order for IM Portal to display.
Last edited by Dr. Bantham on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
User avatar
Dr. Bantham
Integra Member
Integra Member
 
Posts: 152
Likes: 0 post
Liked in: 0 post
Joined: Sat Apr 08, 2006 6:25 pm
Cash on hand: 0.00

Re: Recent articles block

PostAuthor: krillmeed » Sun Jan 21, 2007 5:40 am

"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>
Last edited by krillmeed on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.

krillmeed
Sr Integra Member
Sr Integra Member
 
Posts: 301
Likes: 0 post
Liked in: 0 post
Joined: Sat May 27, 2006 1:34 am
Cash on hand: 0.00

PostAuthor: IntegraMOD » Sun Jan 21, 2007 9:02 am

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
Last edited by IntegraMOD on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
Image
Please do not PM for support
User avatar
IntegraMOD
Administrator
Administrator
 
Posts: 459
Likes: 0 post
Liked in: 0 post
Joined: Sat Mar 11, 2006 4:46 pm
Cash on hand: 0.00
Bank: 100.00
Location: Seattle Wa

PostAuthor: krillmeed » Mon Jan 22, 2007 9:19 am

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
Last edited by krillmeed on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.

krillmeed
Sr Integra Member
Sr Integra Member
 
Posts: 301
Likes: 0 post
Liked in: 0 post
Joined: Sat May 27, 2006 1:34 am
Cash on hand: 0.00

Re: Recent articles block

PostAuthor: Teelk » Mon Jan 22, 2007 1:57 pm

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.
Last edited by Teelk on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
User avatar
Teelk
Dev Team
Dev Team
 
Posts: 1309
Likes: 0 post
Liked in: 0 post
Joined: Tue Mar 14, 2006 6:25 pm
Cash on hand: 0.00
Location: Canada

PostAuthor: krillmeed » Mon Jan 22, 2007 11:13 pm

Thanks, no hurry, my members can still read them in the forum <img>
Last edited by krillmeed on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.

krillmeed
Sr Integra Member
Sr Integra Member
 
Posts: 301
Likes: 0 post
Liked in: 0 post
Joined: Sat May 27, 2006 1:34 am
Cash on hand: 0.00

Re: Recent articles block

PostAuthor: Teelk » Tue Jan 23, 2007 12:03 am

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.
Last edited by Teelk on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
User avatar
Teelk
Dev Team
Dev Team
 
Posts: 1309
Likes: 0 post
Liked in: 0 post
Joined: Tue Mar 14, 2006 6:25 pm
Cash on hand: 0.00
Location: Canada

PostAuthor: krillmeed » Tue Jan 23, 2007 12:39 pm

Check you pm <img>
Last edited by krillmeed on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.

krillmeed
Sr Integra Member
Sr Integra Member
 
Posts: 301
Likes: 0 post
Liked in: 0 post
Joined: Sat May 27, 2006 1:34 am
Cash on hand: 0.00

Re: Recent articles block

PostAuthor: Dr. Bantham » Wed Jan 24, 2007 5:53 pm

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!
Last edited by Dr. Bantham on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
User avatar
Dr. Bantham
Integra Member
Integra Member
 
Posts: 152
Likes: 0 post
Liked in: 0 post
Joined: Sat Apr 08, 2006 6:25 pm
Cash on hand: 0.00

PostAuthor: krillmeed » Wed Jan 24, 2007 10:48 pm

I think that is exactly the fault with mine as well
Last edited by krillmeed on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.

krillmeed
Sr Integra Member
Sr Integra Member
 
Posts: 301
Likes: 0 post
Liked in: 0 post
Joined: Sat May 27, 2006 1:34 am
Cash on hand: 0.00

Re: Recent articles block

PostAuthor: Teelk » Thu Jan 25, 2007 11:50 pm

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.
Last edited by Teelk on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
User avatar
Teelk
Dev Team
Dev Team
 
Posts: 1309
Likes: 0 post
Liked in: 0 post
Joined: Tue Mar 14, 2006 6:25 pm
Cash on hand: 0.00
Location: Canada

PostAuthor: krillmeed » Fri Jan 26, 2007 5:44 am

Thanks works perfectly now <img>
Last edited by krillmeed on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.

krillmeed
Sr Integra Member
Sr Integra Member
 
Posts: 301
Likes: 0 post
Liked in: 0 post
Joined: Sat May 27, 2006 1:34 am
Cash on hand: 0.00

Re: Recent articles block (Solved)

PostAuthor: Dr. Bantham » Fri Jan 26, 2007 10:57 am

Yep - works like a charm. Thanks, Teelk!
Last edited by Dr. Bantham on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
User avatar
Dr. Bantham
Integra Member
Integra Member
 
Posts: 152
Likes: 0 post
Liked in: 0 post
Joined: Sat Apr 08, 2006 6:25 pm
Cash on hand: 0.00


Return to IntegraMOD 141

Who is online

Registered users: App360MonitorBot, Bing [Bot], Google [Bot]