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
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.