Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Fix: mySQL Error: Column count doesn't match value  (Read 3666 times)

0 Members and 1 Guest are viewing this topic.

Charlie Shin

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
Fix: mySQL Error: Column count doesn't match value
« 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.
Logged

DJMaze

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Posts: 831
    • Dragonfly CMS
Fix: mySQL Error: Column count doesn't match value
« Reply #1 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:
Logged
There are 2 kinds of users in this world: satisfied and complainers.
Why do we never hear something from the satisfied users?
http://coppermine-gallery.net/forum/index.php?topic=24315.0
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 18 queries.