The following below appears on every page of mine. Not sure how to fix. Please help. It is from my seo extension im sure. And or it could be because my hosting company decided for a fix, that they would take it upon themselves to create a new database, backup the old and import it into the new database to use? And or because I just imported 50k in new products ... please help.
Error No: 1054
SELECT keyword FROM url_alias WHERE `query` = 'route = product/ product' AND (`language_id` = '1' OR `language_id` = 0) in / var/ww w/vhost s/v italvintagecoalition. om/ httpdocs/system/library/db/mysqli.php on line 40Notice: Trying to get property of non-object in / var/ www/ vhosts/ vitalvintage. com/ httpdocs / vqmod/ vqcache/ vq2- catalog_control ler_common_seo_ url. php on line 273Notice: Error: Unknown column 'language_id' in 'where clause'
There is no language_id in the url_alias table, this is probably a remnant of the seo extension.
Try and replace the catalog/controller/common/seo_url.php with an original
Try and replace the catalog/controller/common/seo_url.php with an original
Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+ 
Thanks!
Thanks for the help, but no, i just tried replacing that file with the original, and the problem remains.
Did you refresh the modification and vqmod cache?
Or is there something else in the error log that gives away where this query is coming from?
Or is there something else in the error log that gives away where this query is coming from?
Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+
Thanks!
Not sure how to re-fresh the vqmod cache unless i do that when hitting clear & refresh from the admin>extensions>modifications tab
same errors from the error log:
2016-01-26 18:36:38 - PHP Notice: Trying to get property of non-object in /var /www /vh sts/vitalvin tagecoalition. com /httpdocs /v qmod/ vqcache/vq2-catalog_controller_common_seo_url.php on line 273
2016-01-26 18:36:43 - PHP Notice: Error: Unknown column 'language_id' in 'where clause'<br />Error No: 1054<br />SELECT * FROM url_alias WHERE `query` = 'category_id=6816' AND (`language_id` = '1' OR `language_id` = 0) in /var /www /vho sts/vita lvintagecoalition.com/ht tpdocs/sys tem/libr ary/db/ mysqli. php on line 40
2016-01-26 18:36:43 - PHP Notice: Trying to get property of non-object in /v ar/www / vhosts/vitalvi ntagecoalition. com/httpdo cs/vqm od/v qcache/vq2-catalog_controller_common_seo_url. php on line 259
same errors from the error log:
2016-01-26 18:36:38 - PHP Notice: Trying to get property of non-object in /var /www /vh sts/vitalvin tagecoalition. com /httpdocs /v qmod/ vqcache/vq2-catalog_controller_common_seo_url.php on line 273
2016-01-26 18:36:43 - PHP Notice: Error: Unknown column 'language_id' in 'where clause'<br />Error No: 1054<br />SELECT * FROM url_alias WHERE `query` = 'category_id=6816' AND (`language_id` = '1' OR `language_id` = 0) in /var /www /vho sts/vita lvintagecoalition.com/ht tpdocs/sys tem/libr ary/db/ mysqli. php on line 40
2016-01-26 18:36:43 - PHP Notice: Trying to get property of non-object in /v ar/www / vhosts/vitalvi ntagecoalition. com/httpdo cs/vqm od/v qcache/vq2-catalog_controller_common_seo_url. php on line 259
You can just empty the cache folder inside the vqmod folder.
If it persists I can take a look for you, should be easy to find!
If it persists I can take a look for you, should be easy to find!
Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+
Thanks!
Emptyied the vqcache folder ... problem remains... Ive just given the developer of my SEO extension,,, as I know that is the problem from when it is disabled the errors accross every page disapeer. Though because of the settings in the seo, my entire catalog is screwed up, many products don't show, and majority of categories vanish. So, in summary i gave the developer login credentials to fix, and if i give you another then you both might conflict. ?
It's his job! I thought you had no support, that's why I offered after our conversation.
Let us know how it goes
Let us know how it goes
Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+
Thanks!
Who is online
Users browsing this forum: No registered users and 3 guests
