KB SQL Error After Upgrading [Solved]

Support for IntegraMOD 141

Moderator: Integra Moderator

KB SQL Error After Upgrading [Solved]

PostAuthor: Master Dwarf » Tue May 15, 2007 3:29 am

Your phpBB Version: 2.0.
phpBB Type: Integramod 141
MODs: No
Your knowledge: Basic Knowledge
Board URL: http://www.GrumblingDwarf.com

PHP Version:not sure, 4 or 4
MySQL Version:not sure


What was done before the problem appeared?
Upgraded from 1.40 to 1.41


What was done to try to solve the problem?




De.scription and Message

I just upgraded from 1.40 to 1.41 and have some problems noted above. I get the following error when trying to access 'Knowledge Base'...
Failed obtaining forum access control lists

DEBUG MODE

SQL Error : 1054 Unknown column 'a.auth_view' in 'field list'

SELECT a.category_id, a.auth_view, a.auth_post, a.auth_rate, a.auth_comment, a.auth_edit, a.auth_delete, a.auth_approval, a.auth_approval_edit FROM phpbb_kb_categories a

Line : 114
File : functions_kb_auth.php


I had similar problem with my 'Album' section but got a fix [url=http]from this thread.[/url]

You can check my site...www.grumblingdwarf.com

I have checked all my file permissions and ran the update .script a few times.

Help? Thanks in advance. <img>
Last edited by Master Dwarf on Thu May 17, 2007 3:45 am, edited 1 time in total.
Sean Kelley
http://www.GrumblingDwarf.com
Wisconsin Region Game Site
User avatar
Master Dwarf
Integra Supporter
Integra Supporter
 
Posts: 102
Likes: 0 post
Liked in: 0 post
Joined: Sun Apr 09, 2006 9:26 am
Cash on hand: 0.00
Location: Madison, WI

PostAuthor: Master Dwarf » Tue May 15, 2007 8:36 pm

please don't bury me... <img>
Last edited by Master Dwarf on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
Sean Kelley
http://www.GrumblingDwarf.com
Wisconsin Region Game Site
User avatar
Master Dwarf
Integra Supporter
Integra Supporter
 
Posts: 102
Likes: 0 post
Liked in: 0 post
Joined: Sun Apr 09, 2006 9:26 am
Cash on hand: 0.00
Location: Madison, WI

Re: KB SQL Error After Upgrading

PostAuthor: Frost » Tue May 15, 2007 9:16 pm

Show me the upgrade .script's sql portion here, I think your upgrade didn't get completed properly
Last edited by Frost on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
[size=99px]PhpBB3 Themes[/url] ]PhpBB3 Development Center[/url] [/size]

Frost
Sr Integra Member
Sr Integra Member
 
Posts: 776
Likes: 0 post
Liked in: 0 post
Joined: Wed Sep 13, 2006 2:04 am
Cash on hand: 0.00
Location: Photoshop CS3

Re: KB SQL Error After Upgrading

PostAuthor: Master Dwarf » Wed May 16, 2007 3:04 am

Thanks Frost. I ran it again. Here are the results...
You do not have the required permissions to view the files attached to this post.
Last edited by Master Dwarf on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
Sean Kelley
http://www.GrumblingDwarf.com
Wisconsin Region Game Site
User avatar
Master Dwarf
Integra Supporter
Integra Supporter
 
Posts: 102
Likes: 0 post
Liked in: 0 post
Joined: Sun Apr 09, 2006 9:26 am
Cash on hand: 0.00
Location: Madison, WI

Re: KB SQL Error After Upgrading

PostAuthor: Frost » Wed May 16, 2007 11:33 pm

Is that the install instructions portion?

I want the original text that tells you what sql queries to run, or the installer.php either way
Last edited by Frost on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
[size=99px]PhpBB3 Themes[/url] ]PhpBB3 Development Center[/url] [/size]

Frost
Sr Integra Member
Sr Integra Member
 
Posts: 776
Likes: 0 post
Liked in: 0 post
Joined: Wed Sep 13, 2006 2:04 am
Cash on hand: 0.00
Location: Photoshop CS3

Re: KB SQL Error After Upgrading

PostAuthor: Master Dwarf » Thu May 17, 2007 3:17 am

"Frost";p="25469" wrote:Is that the install instructions portion?

I want the original text that tells you what sql queries to run, or the installer.php either way
Sorry, here that is...
Keep in mind, I was upgrading and not doing a fresh install. It's quite possible I overlooked something. <img>
You do not have the required permissions to view the files attached to this post.
Last edited by Master Dwarf on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
Sean Kelley
http://www.GrumblingDwarf.com
Wisconsin Region Game Site
User avatar
Master Dwarf
Integra Supporter
Integra Supporter
 
Posts: 102
Likes: 0 post
Liked in: 0 post
Joined: Sun Apr 09, 2006 9:26 am
Cash on hand: 0.00
Location: Madison, WI

PostAuthor: Master Dwarf » Thu May 17, 2007 3:27 am

You know, now that I'm thinking about it. I wonder if I ran the wrong damn update. I was going from 1.40-1.41 and I think I did the phpbb to 1.41. *sigh* I hope I can fix this and not hose my site.
Last edited by Master Dwarf on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
Sean Kelley
http://www.GrumblingDwarf.com
Wisconsin Region Game Site
User avatar
Master Dwarf
Integra Supporter
Integra Supporter
 
Posts: 102
Likes: 0 post
Liked in: 0 post
Joined: Sun Apr 09, 2006 9:26 am
Cash on hand: 0.00
Location: Madison, WI

PostAuthor: Master Dwarf » Thu May 17, 2007 3:45 am

I, sir, am an idiot. I ran the CORRECT .script and all is fine. Sorry to have wasted your time Frost.
Last edited by Master Dwarf on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
Sean Kelley
http://www.GrumblingDwarf.com
Wisconsin Region Game Site
User avatar
Master Dwarf
Integra Supporter
Integra Supporter
 
Posts: 102
Likes: 0 post
Liked in: 0 post
Joined: Sun Apr 09, 2006 9:26 am
Cash on hand: 0.00
Location: Madison, WI


Return to IntegraMOD 141

Who is online

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