Unknown column 'user_permissions' in 'field list' [1054]

Deadliner

this error has come up on my forum. maybe something to do with the database in myphpadmin.

please help!

bretticus

google search yields

...Probably something you changed (added a new column or removed an existing one.)

Deadliner

yes. but how do i fix it?

woodeye

I recently had the same problem. My problem was that my query was looking for a column that didn't exist in the table that I was seaching. Are you sure the table has a column called "user_permissions"?

Deadliner

yes im sure thats what it is called

but i think its been deleted or dropped therefore its no longer there.

how do i get it to shop looking for the column and to open the forum again?

many thanks.

bretticus

Deadliner;10878476 wrote:
yes. but how do i fix it?

Sure, I'll just magically gaze into my crystal ball, find exactly where your code goes awry :evilgrin:

Perhaps now would be a good time to post your code?

Deadliner

im sorry im new to the database.

what code would you like to see and how would i get it ?

sorry again.

woodeye

Do a search in your code for "user_permissions" and look for it in a query, then remove it. Although that sounds like something that you want in your database. If it's been dropped or deleted, then it's no longer there, which is what I was saying in the first place, there is no column called "user_permissions", MySQL doesn't care what USED to be there. So you either have to remove it from the query or add it back into the database. Hopefully you have a backup of your database from before it was dropped or deleted.

Good luck!

bretticus

I'm sorry likewise, I don't mean to be a curmudgeon, but please be more specific when asking questions in here. Again, forgive my crankiness...

Do you get any other information besides "Unknown column 'user_permissions' in 'field list' [1054]". A page reference? I guess I'd do one of two things:

Do a search of your code for "user_permissions" and pull it out of SQL queries.
Create a new "user_permissions" column for each table you suspect may need it until error goes away. (last resort and not recommended.)

Obviously, you will get better responses in the forum for this software. For example, if this is phpbb, the guys over there will be more familiar with the forum code and how to debug it.

It seems this sort of thing happens when a newly implemented release of the source code does not match the old database schema.

Good luck!

bradgrafelman

Note what you're asking is similar to having the fuel pump in your car break down, and you ask the mechanic to simply remove the fuel pump so that your car doesn't have anything broken in it and therefore works again.

If it's a forum, I doubt it's going to be as simply as just plucking out any reference to a column. So you can either a) spend lots and lots of time essentially rewriting the program to not use that column/functionality, b) restore the DB from a backup (everyone takes backups of important things...right?), or c) re-download the product and try to restore the original table schema (attempting to preserve current data, though this might require some manual tweaking, e.g. giving yourself admin access again).

Deadliner

sorry for the novice question again:

i've been backing up from the forum each day, can i use this backup to restore the database? also, how do i go about doing this ,because i cannot access the forum at all due to the error. im guessing id have to restore it from myphpadmin, but could you tell me how?

sorry again for the novice question + reply.

bretticus

Backup and Restore MySQL using phpMyAdmin and using shell