Re: Mysql Error on importing View

[Michael Russotti]

Hi Peter

Thanks for your reply.

The error is:

******

Error at the line 3276: `C`.`mainCategoryID`) */;

Query: --
--
--
--
`name`,`C`.`visible` AS `visible`,`M`.`priority` AS `main_priority`,`C`.`Priority` AS `priority` from (`categories` `C` join `categories_main` `M`) where (`M`.`id` =
`C`.`mainCategoryID`) */

MySQL: 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 '`name`,`C`.`visible` AS `visible`,`M`.`priority` AS `main_priority`,`C`.`Priorit' at line 5

*******

The target server MySQL Version is 5.5.54-cll