Mea culpa
6 May 2006 – 19:03Sí, señores; es mi culpa por decidir usar el pMachine este de los cogorcios… El calendario no funcaba (telefunken) y todavía dudo que todo funcione correctamente…
Resulta que el instalador no creaba bien la tabla pm_events pq “repeat” está reservado en mysql 5 y… Total, que la he creado y he retocado los ficheros que modifican la bd :)
En el fichero… pm/cp/events.cp.php$query = new DB_query($DB, “select repeat_event from $db_events where link_id = ‘$linkid’ and t_stamp > ‘$t_stamp’”);
$repeat = $query->row['repeat_event'];
$query = new DB_query($DB, “insert into $db_events (id,link_id,repeat_event,t_stamp,year,month,day,show_time,title,description)
$query = new DB_query($DB, “update $db_events set t_stamp = ‘$t_stamp’,repeat_event = ‘$repeat’,year = ‘$evyear’,month = ‘$evmonth’,day = ‘$evday’,show_time = ‘$show_time’,title = ‘$title’,description = ‘$description’ where id = ‘$id’”);
$query = new DB_query($DB, “insert into $db_events (id,link_id,repeat_event,t_stamp, year,month,day,show_time,title, description) values (”, ‘$link_id’,'$repeat’,'$t_stamp’,'$evyear’,'$evmonth’,'$evday’,'$show_time’,'$title’,'$description’)”);
$repeat = $query->row['repeat_event'];
$query = new DB_query($DB, “insert into $db_events (id,link_id,repeat_event,t_stamp,year,month,day,show_time,title,description)
$query = new DB_query($DB, “update $db_events set t_stamp = ‘$t_stamp’,repeat_event = ‘$repeat’,year = ‘$evyear’,month = ‘$evmonth’,day = ‘$evday’,show_time = ‘$show_time’,title = ‘$title’,description = ‘$description’ where id = ‘$id’”);
$query = new DB_query($DB, “insert into $db_events (id,link_id,repeat_event,t_stamp, year,month,day,show_time,title, description) values (”, ‘$link_id’,'$repeat’,'$t_stamp’,'$evyear’,'$evmonth’,'$evday’,'$show_time’,'$title’,'$description’)”);
Como veis, he cambiado repeat por repeat events, he buscado la sentencia de creación mysql (google te ama) y también lo he sustituido ahi
create table pm_events ( id int unsigned not null auto_increment primary key, link_id varchar(50) not null, repeat_event char(2) not null, t_stamp int unsigned not null, year char(4) not null, month char(2) not null, day char(2) not null, show_time char(1) not null, title tinytext not null, description text not null ) ;