PDA

View Full Version : Cannot edit user


carbide
06-22-2008, 03:10 PM
Hi all
In my admin panel,I cannot edit a users password,It comes up with this error.

Invalid SQL:
UPDATE user SET nmaps_isreporter = 0 WHERE userid =0;

MySQL Error : Unknown column 'nmaps_isreporter' in 'field list'
Error Number : 1054

this happened after a upgrade to 3.7

Opserty
06-22-2008, 08:11 PM
Its due to some kind of modification, this isn't a default vBulletin field AFAIK, disable your modifications (and if it is still not resolved, undo any file edits you may have made to the admincp files)

carbide
06-22-2008, 11:42 PM
Thanks I will give that a try

carbide
07-06-2008, 11:54 PM
Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE user SET nmaps_isreporter = 0 WHERE userid =25;

MySQL Error : Unknown column 'nmaps_isreporter' in 'field list'
Error Number : 1054
damn I cannot figure this out,All I did was rename my admin cp?

JesusLiv3s
07-07-2008, 03:11 AM
I don't know too much about this, but I can assure you it has nothing to do with renaming your admincp directory.

This specific issue is related to your database, and could be anything from a modification to a database corruption.

Someone more skilled in this field should help you.

Dismounted
07-07-2008, 06:31 AM
Have you done what Opserty has said?

carbide
07-07-2008, 11:46 PM
Have you done what Opserty has said?
Thanks guys for all your help.
I disabled nmaps and its all good:)
thanks again