schema report-
zeitgeist-
primary key: missing in database

Comments

fgm’s picture

fgm
Primary language French
Location Paris, France
commented
Status: Active » Postponed (maintainer needs more info)

Hi.

Could you give more detail on how you obtain this error ?

fgm’s picture

fgm
Primary language French
Location Paris, France
commented

I could not reproduce the problem.

Unless you give more details, I'll have to close this issue.

designanddraft’s picture

designanddraft commented

i have installed my first site and am using many modules, when i do a schema report this is the error that is presented. i could send a copy of a db table, if you could be more specific as to what might help?

when i go to the admin/logs/zeitgeist page is blank and producess error

warning: call_user_func_array() [function.call-user-func-array]: First argument is expected to be a valid callback, 'zeitgeist_page' was given in /home/content/d/e/s/designanddraft/html/govbyus/includes/menu.inc on line 346.

fgm’s picture

fgm
Primary language French
Location Paris, France
commented
Assigned: Unassigned » fgm

This is indeed strange: the module should send you to admin/reports/zeitgeist, not admin/logs/zeitgeist.

Can you confirm the $Id .... $ string at the top of the zeitgeist.module and zeitgeist.install files ?

designanddraft’s picture

designanddraft commented

$Id: zeitgeist.module,v 1.9.6.2 2007/10/14 16:52:53 fgm Exp $

$Id: zeitgeist.install,v 1.1.6.3 2007/10/14 16:52:53 fgm Exp $

fgm’s picture

fgm
Primary language French
Location Paris, France
commented

Please upgrade to the latest 6.x.dev version dated today. Since it is not yet packaged on d.o., pick it up from CVS.

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Title: schema-primary key missing » The primary key is missing
Status: Postponed (maintainer needs more info) » Fixed

As the report has not gotten any feedback, it would be better to set it to fixed. Feel free to re-open it if you think it's not correct.

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented

In another report is reported a patch that contains the following comment:

    /**
     * ZG does not use a PK, because the timer granularity can actually cause duplicates,
     * and there is no actual need to differentiate them. The alternatives would be heavier:
     * adding an occurrence count on all rows, and update it instead of adding a row in the
     * rare case when a duplicate occurs. This would be heavy on every request, with no obvious gain
     * An additional solution would be to add an autoincrement column to differentiate otherwise
     * identical rows, again to no actual benefit.
     */

I think the comment explains well why the module is not using a primary key.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.