[Obm] [CRASH] : Migration de la version 2.1.15 à 2.2.0

Salaun Pascal pascal.salaun at laposte.net
Fri Mar 20 14:26:36 CET 2009


Bonjour,

je viens de migrer OBM 2.1.15 en 2.2.0
et ça s'est mal passé ( quand on bricole la structure des tables mysql 
;-) ).

voici les erreurs en question :
 

2009-03-20 13:24:01 [Info] [Cron] : Executing OBM crontab at 2009-03-20 13:24:01 
2009-03-20 13:24:01 [Debug] [Cron] : UserExpiration registred 
2009-03-20 13:24:01 [Debug] [Cron] : CronJob registred 
2009-03-20 13:24:01 [Debug] [Cron] : EventAlertCronJob registred 
2009-03-20 13:24:01 [Debug] [Cron] : ContactExpiration registred 
2009-03-20 13:24:01 [Debug] [Cron] : VacationCronJob registred 
2009-03-20 13:24:01 [Debug] [Cron] : Trying to get lock 
2009-03-20 13:24:01 [Debug] [Cron] : Cron locked 
2009-03-20 13:24:01 [Info] [Cron] : UserExpiration will not be executed 
2009-03-20 13:24:01 [Info] [Cron] : CronJob will not be executed 
2009-03-20 13:24:01 [Info] [Cron] : EventAlertCronJob will be executed 
2009-03-20 13:24:01 [Debug] [EventAlertCronJob] : Getting alerts between 2009-03-20 13:24:01 and 2009-03-20 13:26:00 
2009-03-20 13:24:01 [Debug] [/usr/share/obm/www/cron/jobs/EventAlertCronJob.class.php] : Only variables should be assigned by reference in /usr/share/obm/www/cron/jobs/EventAlertCronJob.class.php at 161 
2009-03-20 13:24:01 [Debug] [/usr/share/obm/www/cron/jobs/EventAlertCronJob.class.php] : Only variables should be assigned by reference in /usr/share/obm/www/cron/jobs/EventAlertCronJob.class.php at 177 
2009-03-20 13:24:01 [Debug] [EventAlertCronJob] : Getting alerts on non-reccurent events between 2009-03-20 13:24:01 and 2009-03-20 13:26:00 
2009-03-20 13:24:01 [Warning] [/usr/share/obm/www/obminclude/phplib/db_mysql.inc] : mysql_free_result(): supplied argument is not a valid MySQL result resource in /usr/share/obm/www/obminclude/phplib/db_mysql.inc at 98 
2009-03-20 13:24:01 [Warning] [/usr/share/obm/www/obminclude/phplib/db_mysql.inc] : mysql_free_result(): supplied argument is not a valid MySQL result resource in /usr/share/obm/www/obminclude/phplib/db_mysql.inc at 98 
</td></tr></table><b>Database error:</b> Invalid SQL: SELECT
      event_id,
      event_title,
      event_privacy,
      event_description,
      event_location,
      event_repeatfrequence,
      event_owner,
      userentity_entity_id as eventlink_entity_id,
      'user' as eventlink_entity,
      eventlink_state,
      UNIX_TIMESTAMP(event_date) - eventalert_duration as event_date,
      eventalert_duration,
      event_duration,
      event_allday,
      userobm_lastname,
      userobm_firstname
    FROM EventAlert
      INNER JOIN Event ON event_id = eventalert_event_id  
      INNER JOIN UserEntity ON userentity_user_id = eventalert_user_id
      INNER JOIN EventLink ON event_id = eventlink_event_id AND eventlink_entity_id = userentity_entity_id 
      INNER JOIN UserObm ON userobm_id = eventlink_entity_id
    WHERE eventlink_state = 'ACCEPTED'
      AND event_repeatkind = 'none'
      AND (UNIX_TIMESTAMP(event_date) - eventalert_duration) >= 1237555441
      AND (UNIX_TIMESTAMP(event_date) - eventalert_duration) <=  1237555560
      AND  eventalert_duration > 0
      ORDER BY event_date
<br>
<b>MySQL Error</b>: 1146 (Table 'obm.EventAlert' doesn't exist)<br>
Session halted.



Pour info :
OS    : Debian etch
PHP   : 5.2
MySQL : 5.0 




More information about the Obm mailing list