PORTAIL DOCUMENTAIRE

ALTER TABLE tri_tempo_1 ADD tbdate_parution varchar(255)

The table 'tri_tempo_1' is full

CREATE TEMPORARY TABLE tri_tempo_1_update(notice_id INT NOT NULL, tbdate_parution varchar(255) not null default '') ENGINE=memory (SELECT notices.notice_id, SUBSTRING(date_parution, 1, 255) AS tbdate_parution FROM tri_tempo_1 LEFT JOIN notices ON (notices.notice_id = tri_tempo_1.notice_id))

The table 'tri_tempo_1_update' is full

ALTER TABLE tri_tempo_1_update ADD INDEX (notice_id)

Table 'sigb.tri_tempo_1_update' doesn't exist

UPDATE notices, tri_tempo_1, tri_tempo_1_update SET tri_tempo_1.tbdate_parution = tri_tempo_1_update.tbdate_parution WHERE tri_tempo_1.notice_id=tri_tempo_1_update.notice_id AND notices.notice_id=tri_tempo_1.notice_id AND tri_tempo_1_update.tbdate_parution IS NOT NULL AND tri_tempo_1_update.tbdate_parution != ''

Table 'sigb.tri_tempo_1_update' doesn't exist

ALTER TABLE tri_tempo_1 ADD tbtitle varchar(255)

The table 'tri_tempo_1' is full

CREATE TEMPORARY TABLE tri_tempo_1_update(notice_id INT NOT NULL, tbtitle varchar(255) not null default '') ENGINE=memory (SELECT notices.notice_id, SUBSTRING(index_sew, 1, 255) AS tbtitle FROM tri_tempo_1 LEFT JOIN notices ON (notices.notice_id = tri_tempo_1.notice_id) WHERE notices.niveau_biblio!='b')

The table 'tri_tempo_1_update' is full

ALTER TABLE tri_tempo_1_update ADD INDEX (notice_id)

Table 'sigb.tri_tempo_1_update' doesn't exist

UPDATE notices, tri_tempo_1, tri_tempo_1_update SET tri_tempo_1.tbtitle = tri_tempo_1_update.tbtitle WHERE tri_tempo_1.notice_id=tri_tempo_1_update.notice_id AND notices.notice_id=tri_tempo_1.notice_id AND tri_tempo_1_update.tbtitle IS NOT NULL AND tri_tempo_1_update.tbtitle != ''

Table 'sigb.tri_tempo_1_update' doesn't exist

UPDATE notices, tri_tempo_1, tri_tempo_1_update SET tri_tempo_1.tbtitle = tri_tempo_1_update.tbtitle WHERE tri_tempo_1.notice_id=tri_tempo_1_update.notice_id AND notices.notice_id=tri_tempo_1.notice_id AND tri_tempo_1_update.tbtitle IS NOT NULL AND tri_tempo_1_update.tbtitle != ''

Unknown column 'tri_tempo_1.tbtitle' in 'field list'

ALTER TABLE tri_tempo_1 ORDER BY tbdate_parution DESC,tbtitle ASC

Unknown column 'tbdate_parution' in 'order clause'

SELECT * FROM tri_tempo_1 ORDER BY tbdate_parution DESC,tbtitle ASC LIMIT 180,15

Unknown column 'tbdate_parution' in 'order clause'