Page 1 of 1

KB SQL Error After Upgrading [Solved]

PostPosted: Tue May 15, 2007 3:29 am
Author: Master Dwarf
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>

PostPosted: Tue May 15, 2007 8:36 pm
Author: Master Dwarf
please don't bury me... <img>

Re: KB SQL Error After Upgrading

PostPosted: Tue May 15, 2007 9:16 pm
Author: Frost
Show me the upgrade .script's sql portion here, I think your upgrade didn't get completed properly

Re: KB SQL Error After Upgrading

PostPosted: Wed May 16, 2007 3:04 am
Author: Master Dwarf
Thanks Frost. I ran it again. Here are the results...

Re: KB SQL Error After Upgrading

PostPosted: Wed May 16, 2007 11:33 pm
Author: Frost
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

Re: KB SQL Error After Upgrading

PostPosted: Thu May 17, 2007 3:17 am
Author: Master Dwarf
"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>

PostPosted: Thu May 17, 2007 3:27 am
Author: Master Dwarf
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.

PostPosted: Thu May 17, 2007 3:45 am
Author: Master Dwarf
I, sir, am an idiot. I ran the CORRECT .script and all is fine. Sorry to have wasted your time Frost.