forum.coppermine-gallery.net

Support => Older/other versions => cpg1.2 PHPnuke/Postnuke Support => Topic started by: Charlie Shin on December 01, 2003, 04:24:12 pm

Title: Fix: mySQL Error: Column count doesn't match value
Post by: Charlie Shin on December 01, 2003, 04:24:12 pm

The install.php line 377-382:

Quote

       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.

Title: Fix: mySQL Error: Column count doesn't match value
Post by: DJMaze on December 01, 2003, 09:01:21 pm

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 8)

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: