problème suite transfert de mon site
Aucun lien ne fonctionne ! Cette erreur s'affiche : 1064: You have an error in your SQL syntax ... etc.. concernant toutes les tables de la base de données
Pourtant, j'ai bien suivi les instructions pour migrer mon site.
Petit détail :
Avant mon site était dans un répertoire /yacs et maintenant il est à la racine de mon nouvel hébergeur...
Merci de votre aide !!
Exemple de message d'erreur : SELECT * FROM `yacs_files` AS files WHERE (files.anchor LIKE 'article:52') AND (files.active='Y' OR files.active='X' OR files.active='R' OR files.active='N') ORDER BY files.edit_date DESC, files.title LIMIT 0,FILES_PER_PAGE 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FILES_PER_PAGE' at line 1
SELECT * FROM `yacs_links` AS links WHERE links.anchor LIKE 'article:52' ORDER BY links.edit_date DESC, links.title LIMIT 0,LINKS_PER_PAGE 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LINKS_PER_PAGE' at line 1
SELECT categories.* FROM `yacs_members` AS members, `yacs_categories` AS categories WHERE (members.member LIKE 'article:52') AND (categories.id = SUBSTRING_INDEX(members.anchor, ':', -1)) AND ((categories.active='Y' OR categories.active='R' OR categories.active='N') AND ((categories.expiry_date is NULL) OR (categories.expiry_date '2007-01-03 12:33:35'))) ORDER BY categories.rank, categories.title, categories.edit_date DESC LIMIT 0,CATEGORIES_PER_PAGE 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CATEGORIES_PER_PAGE' at line 1
Merci de votre aide !!
Exemple de message d'erreur : SELECT * FROM `yacs_files` AS files WHERE (files.anchor LIKE 'article:52') AND (files.active='Y' OR files.active='X' OR files.active='R' OR files.active='N') ORDER BY files.edit_date DESC, files.title LIMIT 0,FILES_PER_PAGE 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FILES_PER_PAGE' at line 1
SELECT * FROM `yacs_links` AS links WHERE links.anchor LIKE 'article:52' ORDER BY links.edit_date DESC, links.title LIMIT 0,LINKS_PER_PAGE 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LINKS_PER_PAGE' at line 1
SELECT categories.* FROM `yacs_members` AS members, `yacs_categories` AS categories WHERE (members.member LIKE 'article:52') AND (categories.id = SUBSTRING_INDEX(members.anchor, ':', -1)) AND ((categories.active='Y' OR categories.active='R' OR categories.active='N') AND ((categories.expiry_date is NULL) OR (categories.expiry_date '2007-01-03 12:33:35'))) ORDER BY categories.rank, categories.title, categories.edit_date DESC LIMIT 0,CATEGORIES_PER_PAGE 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CATEGORIES_PER_PAGE' at line 1
| Bernard from nearby-an-airport Associate, 6728 posts | Les constantes mentionnées dans les messages d'erreur ( FILES_PER_PAGE, etc) ont été déplacées dans le fichier skins/skin_skeleton.php et le symptôme que vous indiquez pourrais signifier une incohérence de versions des scripts sur votre serveur.
|
Rate this page
Posted by Sebadaf on Jan. 3 2007, commented by Bernard on Jan. 3 2007, (popular)