Errori "Duplicate entri"

8 contenuti / 0 new
Ultimo contenuto
Errori "Duplicate entri"

Qualcuno mi può dare una mano a risolvere questo problema? Ricevo sempre gli errori riportati di seguito. Sono andato nel db ma non ho trovato nessuna voce duplicata (certamente sbaglio io) relativamente ai temi (che poi sono quelli di base) . La cosa paradossale è che tutti i temi elencati non sono usati ne attivati.

    * user warning: Duplicate entry 'themes/chameleon/marvin/marvin.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('marvin', '', 'a:13:{s:4:"name";s:6:"Marvin";s:11:"description";s:31:"Boxy tabled theme in all grays.";s:7:"regions";a:2:{s:4:"left";s:12:"Left sidebar";s:5:"right";s:13:"Right sidebar";}s:7:"version";s:4:"6.15";s:4:"core";s:3:"6.x";s:10:"base theme";s:9:"chameleon";s:7:"project";s:6:"drupal";s:9:"datestamp";s:10:"1260996916";s:8:"features";a:10:{i:0;s:20:"comment_user_picture";i:1;s:7:"favicon";i:2;s:7:"mission";i:3;s:4:"logo";i:4;s:4:"name";i:5;s:17:"node_user_picture";i:6;s:6:"search";i:7;s:6:"slogan";i:8;s:13:"primary_links";i:9;s:15:"secondary_links";}s:11:"stylesheets";a:1:{s:3:"all";a:1:{s:9:"style.css";s:33:"themes/chameleon/marvin/style.css";}}s:7:"scripts";a:1:{s:9:"script.js";s:33:"themes/chameleon/marvin/script.js";}s:10:"screenshot";s:38:"themes/chameleon/marvin/screenshot.png";s:3:"php";s:5:"4.3.5";}', 'theme', 'themes/chameleon/marvin/marvin.info', 0, 0, 0) in /home/hopfrog/public_html/modules/system/system.module on line 822.
    * user warning: Duplicate entry 'themes/chameleon/chameleon.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('chameleon', 'themes/chameleon/chameleon.theme', 'a:12:{s:4:"name";s:9:"Chameleon";s:11:"description";s:42:"Minimalist tabled theme with light colors.";s:7:"regions";a:2:{s:4:"left";s:12:"Left sidebar";s:5:"right";s:13:"Right sidebar";}s:8:"features";a:4:{i:0;s:4:"logo";i:1;s:7:"favicon";i:2;s:4:"name";i:3;s:6:"slogan";}s:11:"stylesheets";a:1:{s:3:"all";a:2:{s:9:"style.css";s:26:"themes/chameleon/style.css";s:10:"common.css";s:27:"themes/chameleon/common.css";}}s:7:"version";s:4:"6.15";s:4:"core";s:3:"6.x";s:7:"project";s:6:"drupal";s:9:"datestamp";s:10:"1260996916";s:7:"scripts";a:1:{s:9:"script.js";s:26:"themes/chameleon/script.js";}s:10:"screenshot";s:31:"themes/chameleon/screenshot.png";s:3:"php";s:5:"4.3.5";}', 'theme', 'themes/chameleon/chameleon.info', 0, 0, 0) in /home/hopfrog/public_html/modules/system/system.module on line 822.
    * user warning: Duplicate entry 'themes/pushbutton/pushbutton.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('pushbutton', 'themes/engines/phptemplate/phptemplate.engine', 'a:13:{s:4:"name";s:10:"Pushbutton";s:11:"description";s:52:"Tabled, multi-column theme in blue and orange tones.";s:7:"version";s:4:"6.15";s:4:"core";s:3:"6.x";s:6:"engine";s:11:"phptemplate";s:7:"project";s:6:"drupal";s:9:"datestamp";s:10:"1260996916";s:7:"regions";a:5:{s:4:"left";s:12:"Left sidebar";s:5:"right";s:13:"Right sidebar";s:7:"content";s:7:"Content";s:6:"header";s:6:"Header";s:6:"footer";s:6:"Footer";}s:8:"features";a:10:{i:0;s:20:"comment_user_picture";i:1;s:7:"favicon";i:2;s:7:"mission";i:3;s:4:"logo";i:4;s:4:"name";i:5;s:17:"node_user_picture";i:6;s:6:"search";i:7;s:6:"slogan";i:8;s:13:"primary_links";i:9;s:15:"secondary_links";}s:11:"stylesheets";a:1:{s:3:"all";a:1:{s:9:"style.css";s:27:"themes/pushbutton/style.css";}}s:7:"scripts";a:1:{s:9:"script.js";s:27:"themes/pushbutton/script.js";}s:10:"screenshot";s:32:"themes/pushbutton/screenshot.png";s:3:"php";s:5:"4.3.5";}', 'theme', 'themes/pushbutton/pushbutton.info', 0, 0, 0) in /home/hopfrog/public_html/modules/system/system.module on line 822.
    * user warning: Duplicate entry 'themes/bluemarine/bluemarine.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('bluemarine', 'themes/engines/phptemplate/phptemplate.engine', 'a:13:{s:4:"name";s:10:"Bluemarine";s:11:"description";s:66:"Table-based multi-column theme with a marine and ash color scheme.";s:7:"version";s:4:"6.15";s:4:"core";s:3:"6.x";s:6:"engine";s:11:"phptemplate";s:7:"project";s:6:"drupal";s:9:"datestamp";s:10:"1260996916";s:7:"regions";a:5:{s:4:"left";s:12:"Left sidebar";s:5:"right";s:13:"Right sidebar";s:7:"content";s:7:"Content";s:6:"header";s:6:"Header";s:6:"footer";s:6:"Footer";}s:8:"features";a:10:{i:0;s:20:"comment_user_picture";i:1;s:7:"favicon";i:2;s:7:"mission";i:3;s:4:"logo";i:4;s:4:"name";i:5;s:17:"node_user_picture";i:6;s:6:"search";i:7;s:6:"slogan";i:8;s:13:"primary_links";i:9;s:15:"secondary_links";}s:11:"stylesheets";a:1:{s:3:"all";a:1:{s:9:"style.css";s:27:"themes/bluemarine/style.css";}}s:7:"scripts";a:1:{s:9:"script.js";s:27:"themes/bluemarine/script.js";}s:10:"screenshot";s:32:"themes/bluemarine/screenshot.png";s:3:"php";s:5:"4.3.5";}', 'theme', 'themes/bluemarine/bluemarine.info', 0, 0, 0) in /home/hopfrog/public_html/modules/system/system.module on line 822.
    * user warning: Duplicate entry 'sites/all/themes/litejazz/litejazz.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('litejazz', 'themes/engines/phptemplate/phptemplate.engine', 'a:13:{s:4:"name";s:8:"LiteJazz";s:11:"description";s:31:"A Drupal 6 Theme by RoopleTheme";s:7:"version";s:7:"6.x-1.7";s:4:"core";s:3:"6.x";s:6:"engine";s:11:"phptemplate";s:7:"regions";a:20:{s:8:"toplogin";s:9:"Top Login";s:12:"sidebar_left";s:12:"Left Sidebar";s:13:"sidebar_right";s:13:"Right Sidebar";s:12:"colonna_left";s:12:"Colonna Left";s:13:"colonna_right";s:13:"Colonna Right";s:8:"top_left";s:8:"Top Left";s:9:"top_right";s:9:"Top Right";s:11:"content_top";s:11:"Content Top";s:14:"content_bottom";s:14:"Content Bottom";s:6:"header";s:6:"Header";s:10:"suckerfish";s:15:"Suckerfish Menu";s:5:"user1";s:6:"User 1";s:5:"user2";s:6:"User 2";s:5:"user3";s:6:"User 3";s:5:"user4";s:6:"User 4";s:5:"user5";s:6:"User 5";s:5:"user6";s:6:"User 6";s:5:"user7";s:6:"User 7";s:5:"user8";s:6:"User 8";s:13:"footer_region";s:6:"Footer";}s:7:"project";s:8:"litejazz";s:9:"datestamp";s:10:"1220959821";s:8:"features";a:10:{i:0;s:20:"comment_user_picture";i:1;s:7:"favicon";i:2;s:7:"mission";i:3;s:4:"logo";i:4;s:4:"name";i:5;s:17:"node_user_picture";i:6;s:6:"search";i:7;s:6:"slogan";i:8;s:13:"primary_links";i:9;s:15:"secondary_links";}s:11:"stylesheets";a:1:{s:3:"all";a:1:{s:9:"style.css";s:35:"sites/all/themes/litejazz/style.css";}}s:7:"scripts";a:1:{s:9:"script.js";s:35:"sites/all/themes/litejazz/script.js";}s:10:"screenshot";s:40:"sites/all/themes/litejazz/screenshot.png";s:3:"php";s:5:"4.3.5";}', 'theme', 'sites/all/themes/litejazz/litejazz.info', 0, 0, 0) in /home/hopfrog/public_html/modules/system/system.module on line 822.
    * user warning: Duplicate entry 'sites/all/themes/osmobi-mobile/osmobi_mobile.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('osmobi_mobile', 'themes/engines/phptemplate/phptemplate.engine', 'a:13:{s:4:"name";s:13:"Osmobi Mobile";s:11:"description";s:207:"Osmobi base theme. Enable to mobilize your site with osmobi! This theme generates raw content and meta-data, without any style or layout. It is only suitable for the Osmobi service and should not be changed.";s:4:"core";s:3:"6.x";s:6:"engine";s:11:"phptemplate";s:7:"version";s:7:"6.x-1.1";s:7:"regions";a:5:{s:3:"def";s:7:"Default";s:7:"content";s:7:"Content";s:4:"left";s:3:"Top";s:5:"right";s:6:"Bottom";s:6:"footer";s:6:"Footer";}s:7:"project";s:13:"osmobi-mobile";s:9:"datestamp";s:10:"1263395707";s:8:"features";a:10:{i:0;s:20:"comment_user_picture";i:1;s:7:"favicon";i:2;s:7:"mission";i:3;s:4:"logo";i:4;s:4:"name";i:5;s:17:"node_user_picture";i:6;s:6:"search";i:7;s:6:"slogan";i:8;s:13:"primary_links";i:9;s:15:"secondary_links";}s:11:"stylesheets";a:1:{s:3:"all";a:1:{s:9:"style.css";s:40:"sites/all/themes/osmobi-mobile/style.css";}}s:7:"scripts";a:1:{s:9:"script.js";s:40:"sites/all/themes/osmobi-mobile/script.js";}s:10:"screenshot";s:45:"sites/all/themes/osmobi-mobile/screenshot.png";s:3:"php";s:5:"4.3.5";}', 'theme', 'sites/all/themes/osmobi-mobile/osmobi_mobile.info', 0, 0, 0) in /home/hopfrog/public_html/modules/system/system.module on line 822.
    * user warning: Duplicate entry 'themes/garland/minnelli/minnelli.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('minnelli', 'themes/engines/phptemplate/phptemplate.engine', 'a:14:{s:4:"name";s:8:"Minnelli";s:11:"description";s:56:"Tableless, recolorable, multi-column, fixed width theme.";s:7:"version";s:4:"6.15";s:4:"core";s:3:"6.x";s:10:"base theme";s:7:"garland";s:11:"stylesheets";a:1:{s:3:"all";a:1:{s:12:"minnelli.css";s:36:"themes/garland/minnelli/minnelli.css";}}s:7:"project";s:6:"drupal";s:9:"datestamp";s:10:"1260996916";s:7:"regions";a:5:{s:4:"left";s:12:"Left sidebar";s:5:"right";s:13:"Right sidebar";s:7:"content";s:7:"Content";s:6:"header";s:6:"Header";s:6:"footer";s:6:"Footer";}s:8:"features";a:10:{i:0;s:20:"comment_user_picture";i:1;s:7:"favicon";i:2;s:7:"mission";i:3;s:4:"logo";i:4;s:4:"name";i:5;s:17:"node_user_picture";i:6;s:6:"search";i:7;s:6:"slogan";i:8;s:13:"primary_links";i:9;s:15:"secondary_links";}s:7:"scripts";a:1:{s:9:"script.js";s:33:"themes/garland/minnelli/script.js";}s:10:"screenshot";s:38:"themes/garland/minnelli/screenshot.png";s:3:"php";s:5:"4.3.5";s:6:"engine";s:11:"phptemplate";}', 'theme', 'themes/garland/minnelli/minnelli.info', 0, 0, 0) in /home/hopfrog/public_html/modules/system/system.module on line 822.
    * user warning: Duplicate entry 'themes/garland/garland.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('garland', 'themes/engines/phptemplate/phptemplate.engine', 'a:13:{s:4:"name";s:7:"Garland";s:11:"description";s:66:"Tableless, recolorable, multi-column, fluid width theme (default).";s:7:"version";s:4:"6.15";s:4:"core";s:3:"6.x";s:6:"engine";s:11:"phptemplate";s:11:"stylesheets";a:2:{s:3:"all";a:1:{s:9:"style.css";s:24:"themes/garland/style.css";}s:5:"print";a:1:{s:9:"print.css";s:24:"themes/garland/print.css";}}s:7:"project";s:6:"drupal";s:9:"datestamp";s:10:"1260996916";s:7:"regions";a:5:{s:4:"left";s:12:"Left sidebar";s:5:"right";s:13:"Right sidebar";s:7:"content";s:7:"Content";s:6:"header";s:6:"Header";s:6:"footer";s:6:"Footer";}s:8:"features";a:10:{i:0;s:20:"comment_user_picture";i:1;s:7:"favicon";i:2;s:7:"mission";i:3;s:4:"logo";i:4;s:4:"name";i:5;s:17:"node_user_picture";i:6;s:6:"search";i:7;s:6:"slogan";i:8;s:13:"primary_links";i:9;s:15:"secondary_links";}s:7:"scripts";a:1:{s:9:"script.js";s:24:"themes/garland/script.js";}s:10:"screenshot";s:29:"themes/garland/screenshot.png";s:3:"php";s:5:"4.3.5";}', 'theme', 'themes/garland/garland.info', 0, 0, 0) in /home/hopfrog/public_html/modules/system/system.module on line 822.
    * user warning: Duplicate entry 'themes/chameleon/marvin/marvin.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('marvin', '', 'a:13:{s:4:"name";s:6:"Marvin";s:11:"description";s:31:"Boxy tabled theme in all grays.";s:7:"regions";a:2:{s:4:"left";s:12:"Left sidebar";s:5:"right";s:13:"Right sidebar";}s:7:"version";s:4:"6.15";s:4:"core";s:3:"6.x";s:10:"base theme";s:9:"chameleon";s:7:"project";s:6:"drupal";s:9:"datestamp";s:10:"1260996916";s:8:"features";a:10:{i:0;s:20:"comment_user_picture";i:1;s:7:"favicon";i:2;s:7:"mission";i:3;s:4:"logo";i:4;s:4:"name";i:5;s:17:"node_user_picture";i:6;s:6:"search";i:7;s:6:"slogan";i:8;s:13:"primary_links";i:9;s:15:"secondary_links";}s:11:"stylesheets";a:1:{s:3:"all";a:1:{s:9:"style.css";s:33:"themes/chameleon/marvin/style.css";}}s:7:"scripts";a:1:{s:9:"script.js";s:33:"themes/chameleon/marvin/script.js";}s:10:"screenshot";s:38:"themes/chameleon/marvin/screenshot.png";s:3:"php";s:5:"4.3.5";}', 'theme', 'themes/chameleon/marvin/marvin.info', 0, 0, 0) in /home/hopfrog/public_html/modules/system/system.module on line 822.
    * user warning: Duplicate entry 'themes/chameleon/chameleon.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('chameleon', 'themes/chameleon/chameleon.theme', 'a:12:{s:4:"name";s:9:"Chameleon";s:11:"description";s:42:"Minimalist tabled theme with light colors.";s:7:"regions";a:2:{s:4:"left";s:12:"Left sidebar";s:5:"right";s:13:"Right sidebar";}s:8:"features";a:4:{i:0;s:4:"logo";i:1;s:7:"favicon";i:2;s:4:"name";i:3;s:6:"slogan";}s:11:"stylesheets";a:1:{s:3:"all";a:2:{s:9:"style.css";s:26:"themes/chameleon/style.css";s:10:"common.css";s:27:"themes/chameleon/common.css";}}s:7:"version";s:4:"6.15";s:4:"core";s:3:"6.x";s:7:"project";s:6:"drupal";s:9:"datestamp";s:10:"1260996916";s:7:"scripts";a:1:{s:9:"script.js";s:26:"themes/chameleon/script.js";}s:10:"screenshot";s:31:"themes/chameleon/screenshot.png";s:3:"php";s:5:"4.3.5";}', 'theme', 'themes/chameleon/chameleon.info', 0, 0, 0) in /home/hopfrog/public_html/modules/system/system.module on line 822.
    * user warning: Duplicate entry 'themes/pushbutton/pushbutton.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('pushbutton', 'themes/engines/phptemplate/phptemplate.engine', 'a:13:{s:4:"name";s:10:"Pushbutton";s:11:"description";s:52:"Tabled, multi-column theme in blue and orange tones.";s:7:"version";s:4:"6.15";s:4:"core";s:3:"6.x";s:6:"engine";s:11:"phptemplate";s:7:"project";s:6:"drupal";s:9:"datestamp";s:10:"1260996916";s:7:"regions";a:5:{s:4:"left";s:12:"Left sidebar";s:5:"right";s:13:"Right sidebar";s:7:"content";s:7:"Content";s:6:"header";s:6:"Header";s:6:"footer";s:6:"Footer";}s:8:"features";a:10:{i:0;s:20:"comment_user_picture";i:1;s:7:"favicon";i:2;s:7:"mission";i:3;s:4:"logo";i:4;s:4:"name";i:5;s:17:"node_user_picture";i:6;s:6:"search";i:7;s:6:"slogan";i:8;s:13:"primary_links";i:9;s:15:"secondary_links";}s:11:"stylesheets";a:1:{s:3:"all";a:1:{s:9:"style.css";s:27:"themes/pushbutton/style.css";}}s:7:"scripts";a:1:{s:9:"script.js";s:27:"themes/pushbutton/script.js";}s:10:"screenshot";s:32:"themes/pushbutton/screenshot.png";s:3:"php";s:5:"4.3.5";}', 'theme', 'themes/pushbutton/pushbutton.info', 0, 0, 0) in /home/hopfrog/public_html/modules/system/system.module on line 822.

In classico stile Windows - prova spegnere e riaccendere; cioè andare in admin/build/themes/select e cliicare 'Salva configurazione' - non si sa mai!

Più imparo, più dubito.

Non ho capito cosa significa in classico stile Windows e una spiegazione sarebbe davvero gradita. Per il resto l'operazione indicata è stata una delle prime che ho fatto. Come si può immaginare senza nessun risultato

hopfrog wrote:
Non ho capito cosa significa in classico stile Windows e una spiegazione sarebbe davvero gradita.

Era una battuta... "Se non va, fai Ctrl-Alt-Canc!"

hopfrog wrote:
Per il resto l'operazione indicata è stata una delle prime che ho fatto. Come si può immaginare senza nessun risultato

Infatti dovevo immaginarlo - non l'avevi scritto.
Un breve sbirciatina a modules/system/system.install indica che è filename che è univoco, quindi non ci possono essere mai due uguale (lo bloccerà il RDBMS) esattamente come sta succedendo.
La funzione che sta faccendo il lavoro (modules/system.module:808) dice:
<?php
function system_theme_data() {
 
// Scan the installation theme .info files and their engines.
 
$themes = _system_theme_data();
 
// Extract current files from database.
 
system_get_files_database($themes, 'theme');
 
db_query("DELETE FROM {system} WHERE type = 'theme'");
  foreach (
$themes as $theme) {
    if (!isset(
$theme->owner)) {
     
$theme->owner = '';
    }
   
db_query("INSERT INTO {system} (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('%s', '%s', '%s', '%s', '%s', %d, %d, %d)", $theme->name, $theme->owner, serialize($theme->info), 'theme', $theme->filename, isset($theme->status) ? $theme->status : 0, 0, 0);
  }
  return
$themes;
}
?>

Quindi avrebbe dovuto cancellare tutti i 'theme's prima di inserirli di nuovo. Ma evidentemente questo non è successo. Molto curioso.

Prova fare un update...

Più imparo, più dubito.

Grazie per la tua disponibilità ma ho già provate le 2 soluzioni che erano le più ovvie. Il rimedio è andare direttamente in mysql ed eliminare manualmente tutto ciò che si riferisce ai temi e poi fare l'update. Quello che invece non riesco a capire è il motivo (infatti è curioso come dici anche tu).

non è che il tema che usavi ti dava dei problemi?
è uno del core?

L'utente per il db (settings.php) ha il diritto (grant) di cancellare record, vero? http://drupal.org/getting-started/6/install/create-database

Più imparo, più dubito.

generalmente ignoro questo problema. è causato da una race condition.
questo commento e link è la spiegazione più semplice ed esaustiva che ho trovato: http://drupal.org/node/477550#comment-1690820