Database error: Invalid SQL: SELECT myop_photo.*, myop_serie.*, myop_photographe.*,
MATCH (myop_photo.fichier) AGAINST ('"france"') AS score_fichier,
MATCH (myop_photo.fichier_origine) AGAINST ('"france"') AS score_fichier_origine,
MATCH (myop_photo.titre_photo_fr) AGAINST ('"france"') AS score_titre_photo,
MATCH (myop_photo.ville_90) AGAINST ('"france"') AS score_ville_90,
MATCH (myop_photo.region_95) AGAINST ('"france"') AS score_region_95,
MATCH (myop_photo.pays_101) AGAINST ('"france"') AS score_pays_101,
MATCH (myop_photo.motscles_25_fr) AGAINST ('"france"') AS score_motscles_25,MATCH (myop_serie.titre_serie_fr) AGAINST ('"france"') AS score_titre_serie,
MATCH (myop_serie.motscles_fr) AGAINST ('"france"') AS score_motscles,
MATCH (myop_photographe.nom) AGAINST ('"france"') AS score_nom
FROM myop_photo, myop_serie, myop_photographe
WHERE (myop_photo.fk_id_serie=myop_serie.id_serie)
AND (myop_serie.fk_id_photographe=myop_photographe.id_photographe)
AND MATCH (
myop_photo.fichier,
myop_photo.fichier_origine,
myop_photo.titre_photo_fr,
myop_photo.ville_90,
myop_photo.region_95,
myop_photo.pays_101,
myop_photo.motscles_25_fr,myop_serie.motscles_fr,
myop_photographe.nom
) AGAINST ('+"france"' IN BOOLEAN MODE) ORDER BY (
(score_fichier * 10)
+ (score_fichier_origine * 10)
+ (score_titre_photo)
+ (score_ville_90 * 3)
+ (score_region_95 * 2)
+ (score_pays_101 * 3)
+ (score_motscles_25 * 5)+ (score_titre_serie)
+ (score_motscles * 2)
+ (score_nom * 20)
)
DESC
MySQL Error: 126 (Incorrect key file for table '/tmp/#sql_15d6_0.MYI'; try to repair it)
Session halted.