Diferencia entre revisiones de «Drupal»

De gacq wiki
Saltar a: navegación, buscar
(Errores)
Línea 4: Línea 4:
  
 
= Errores =
 
= Errores =
 +
== Database error creating nodes ==
 +
 +
Drupal 6.4 - Database migrated from drupal 5
 +
 +
Error produced during node add:
 +
<pre>
 +
# user warning: Duplicate entry '0' for key 2 query: INSERT INTO node (vid, type, language, title, uid, status, created, changed, comment, promote, moderate, sticky, tnid, translate) VALUES (0, 'page', 'es', 'eee', 1, 1, 1222437644, 1222437644, 2, 1, 0, 0, 0, 0) in /var/www/webapps/drupal6/includes/common.inc on line 3318.
 +
# user warning: Duplicate entry '0' for key 1 query: INSERT INTO node_comment_statistics (nid, last_comment_timestamp, last_comment_name, last_comment_uid, comment_count) VALUES (0, 1222437644, NULL, 1, 0) in /var/www/webapps/drupal6/modules/comment/comment.module on line 607.
 +
</pre>
 +
 +
Apparently this is produced by a problem during database upgrade, because auto_increment is not set for node_revisions table.
 +
 +
===To fix===
 +
 +
Obtain last node ID
 +
<pre>
 +
SELECT max( nid ) FROM `node`
 +
</pre>
 +
 +
And sum 1 to the number obtained from previous query and replace YOUR_NUMBER with it.
 +
 +
and run:
 +
<pre>
 +
ALTER TABLE `node_revisions` ADD PRIMARY KEY ( `vid` )
 +
ALTER TABLE `node_revisions` CHANGE `vid` `vid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT
 +
ALTER TABLE `node` AUTO_INCREMENT=YOUR_NUMBER
 +
ALTER TABLE `node_revisions` AUTO_INCREMENT=YOUR_NUMBER
 +
</pre>
 +
 +
 
== Error en ejecucion de cron ==
 
== Error en ejecucion de cron ==
 
<pre><nowiki>
 
<pre><nowiki>

Revisión del 12:48 26 sep 2008

Documentation


Errores

Database error creating nodes

Drupal 6.4 - Database migrated from drupal 5

Error produced during node add:

# user warning: Duplicate entry '0' for key 2 query: INSERT INTO node (vid, type, language, title, uid, status, created, changed, comment, promote, moderate, sticky, tnid, translate) VALUES (0, 'page', 'es', 'eee', 1, 1, 1222437644, 1222437644, 2, 1, 0, 0, 0, 0) in /var/www/webapps/drupal6/includes/common.inc on line 3318.
# user warning: Duplicate entry '0' for key 1 query: INSERT INTO node_comment_statistics (nid, last_comment_timestamp, last_comment_name, last_comment_uid, comment_count) VALUES (0, 1222437644, NULL, 1, 0) in /var/www/webapps/drupal6/modules/comment/comment.module on line 607.

Apparently this is produced by a problem during database upgrade, because auto_increment is not set for node_revisions table.

To fix

Obtain last node ID

SELECT max( nid ) FROM `node` 

And sum 1 to the number obtained from previous query and replace YOUR_NUMBER with it.

and run:

ALTER TABLE `node_revisions` ADD PRIMARY KEY ( `vid` )
ALTER TABLE `node_revisions` CHANGE `vid` `vid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT
ALTER TABLE `node` AUTO_INCREMENT=YOUR_NUMBER
ALTER TABLE `node_revisions` AUTO_INCREMENT=YOUR_NUMBER


Error en ejecucion de cron

From: root@otrasyerbas.com.ar (Cron Daemon)
To: www-data@otrasyerbas.com.ar
Subject: Cron <www-data@geacequ>          [ -x /usr/share/drupal/scripts/cron.sh ] && /usr/share/drupal/scripts/cron.sh

Fatal error: Call to undefined function:  mysql_connect() in /usr/share/drupal/includes/database.mysql.inc on line 31

El script del cron usa las extensiones de mysql de php4-cli que hay que habilitar editando /etc/php4/cli/php.ini y descomentando "extension=mysql.so"

Ejemplos Bloques

<?php
$uptime = shell_exec("cut -d. -f1 /proc/uptime");
$loadavg_array = explode(" ", exec("cat /proc/loadavg"));
$loadavg = $loadavg_array[2];
$days = floor($uptime/60/60/24);
$hours = $uptime/60/60%24;
$mins = $uptime/60%60;
$secs = $uptime%60;
echo "This server has been up $days day(s) $hours hour(s) $mins minute(s) and $secs second(s)";
echo "<p><br>";
print("[ Current server load: " . $loadavg . " ]");
?>