Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unknown column 'catalog_categ' in 'on clause' #47

Open
lrkwz opened this issue Jan 28, 2015 · 2 comments
Open

Unknown column 'catalog_categ' in 'on clause' #47

lrkwz opened this issue Jan 28, 2015 · 2 comments

Comments

@lrkwz
Copy link

lrkwz commented Jan 28, 2015

I've just done a fresh install, after removing Specinstall from config/application.config.php I reload page and a Zend\Db\Adapter\Exception\InvalidQueryException shows up.
Tracing query in mysql revealed:

SELECT `catalog_category`.*, `catalog_category_website`.* FROM `catalog_category` INNER JOIN `catalog_category_website` ON `catalog_categ`or`y_website`.`categ`or`y_id` = `catalog_categ`or`y`.`categ`or`y_id` WHERE `website_id` = 1 AND `parent_category_id` IS NULL;
ERROR 1054 (42S22): Unknown column 'catalog_categ' in 'on clause'

here you can notice backticks ` around any or in any occurence of categORy.

How can I fix this?

I've unsuccessully tried to reach somebody on irc

@ALTAMASH80
Copy link

Hi Irkwz,
I don't exactly know what causes the query to get destroyed. But a fix which i tried and got successful is by changing the composer.json.
in composer.json change the line
"zendframework/zendframework": "2." to "zendframework/zendframework": "2.3." and give it a try. If even than it doesn't solve your problem i'm sure some one will give a reply.

@lrkwz
Copy link
Author

lrkwz commented Jan 29, 2015

Much better now 👍

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants