Fix: mySQL Error: Column count doesn't match value

[Charlie Shin]

The install.php line 377-382:

if (defined('IN_POSTNUKE'))
            $query .= "\nINSERT INTO ".$prefix."_modules VALUES (NULL, '$dirname', 1, '$dirname', 'Coppermine photo gallery', 0, '$dirname', '1.2', 1, 1, 3);";
        else if (defined('IN_OLDNUKE'))
            $query .= "\nINSERT INTO ".$prefix."_modules VALUES (NULL, '$dirname', '$dirname', 0, 0);";
        else
            $query .= "\nINSERT INTO ".$prefix."_modules VALUES (NULL, '$dirname', '$dirname', 0, 0, 1);";

.

If you have nuke 6.9, nuke_modules have these 7 fields: (mid, title, custom_title, active, view, inmenu, mcid). The last $query .= is supposed to insert coppermine module into module table, which only have 6 field. So just go to your admin.php -> modules, activate coppermine module.

If you haven't installed it or deleted from your db, just change above code to represent your nuke module table structure.

This post should reply to other postings related to mysql error.

[DJMaze]

That's strange my version of phpNuke 6.9 didn't have that much fields in the nuke_modules table so i downloaded nuke 6.9 again.

This solved your problem but it is FALSE your using phpNuke 6.9

phpNuke uses only 6 fields,  (package: oktober 22, files: oktober

Some module addition you use added the "mcid" field, and you all read the topic about that you have to mention added modules or modifications, but you all didn't do that.  :roll: