[BUG] unsignedNOT NULL

[cheesegrits]

There's a typo in _addKey(), around line 1808 in fabrik_table.class.php that breaks the ALTER TABLE statement for primary keys:

        if ( $autoIncrement ){
            # $$$ hugh
            #$sql = "ALTER TABLE $this->db_table_name CHANGE $fieldName $fieldName " . $type . "NOT NULL AUTO_INCREMENT"; //add the autoinc
            $sql = "ALTER TABLE $this->db_table_name CHANGE $fieldName $fieldName " . $type . " NOT NULL AUTO_INCREMENT"; //add the autoinc

Note the space before the NOT.

-- hugh

 

[quaysupport]

Aha..... A solution - BRAVO

 

[rob]

Hi Hugh

thanks for posting, I checked the svn and I believe this had already been fixed

keep it up

Rob