SQL Error on ranks "doupdate"

[Duckface]

Hiya,

When editing a rank on admincp I'm getting this sql error:

Database error in vBulletin 4.2.2:

Invalid SQL:
 
        UPDATE ranks 
        SET ranklevel = 1, 
            minposts = 0, 
            rankimg = 'images/ranksets/1.png', 
            usergroupid = -1, 
            type = 0, 
            stack = 0, 
            display = 0, 
        WHERE rankid = 11;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE rankid = 11' at line 9
Error Number  : 1064
Request Date  : Saturday, April 25th 2015 @ 10:48:53 PM
Error Date    : Saturday, April 25th 2015 @ 10:48:53 PM
Script        : http://spawnscape614.co.uk/forums/admincp/ranks.php?do=doupdate
Referrer      : http://spawnscape614.co.uk/forums/admincp/ranks.php?do=edit&rankid=11
IP Address    : 141.101.99.22
Username      : Shekii
Classname     : vB_Database
MySQL Version : 5.5.42-cll

*The ip is cloudflare so.

I looked into the ranks.php within the admincp and checked the doupdate and its currently this:

if ($_POST['do'] == 'doupdate')
{
	$vbulletin->input->clean_array_gpc('p', array(
        'ranklevel'   => TYPE_UINT, 
        'minposts'    => TYPE_UINT, 
        'rankimg'     => TYPE_STR, 
        'usergroupid' => TYPE_INT, 
        'doinsert'    => TYPE_STR, 
        'rankhtml'    => TYPE_NOTRIM, 
        'stack'       => TYPE_UINT, 
        'display'     => TYPE_UINT, 
	));

Is anything wrong with this?

Checking phpmyadmin to see what columns that I have:

Could anyone help me?

--------------- Added [DATE]1430002527[/DATE] at [TIME]1430002527[/TIME] ---------------

Never mind, fixed. Resolved by myself.

[ForceHSS]

It will not allow you to have usergroupid = -1 it needs to be whatever group id you have set in ranks if you have set it at -1 then you need to change that