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
_______________________________________________
Obm mailing list
[email protected]
http://www.list.aliasource.fr/mailman/listinfo/obm
