Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Fix: mySQL Error: Column count doesn't match value  (Read 3423 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.023 seconds with 20 queries.