problème de migration

Edit ·  Delete

on Jan. 12 2007

" SELECT * FROM `yacs_files` AS files WHERE (files.anchor LIKE 'article:1') 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:1' 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:1') 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-12 23:57:01'))) 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 "

Edit ·  Delete

inspired from Bernard on Jan. 15 2007