Code: Select all
Fatal error: Uncaught Exception: Error: Unknown column 'query' in 'where clause'<br />Error No: 1054<br />SELECT * FROM oc_seo_url WHERE query = 'product_id=42' in system/library/db/mysqli.php:40
Code: Select all
Fatal error: Uncaught Exception: Error: Unknown column 'query' in 'where clause'<br />Error No: 1054<br />SELECT * FROM oc_seo_url WHERE query = 'product_id=42' in system/library/db/mysqli.php:40
Not being part of your database is another story, you need to find a way to import those fields and values as the same situation encountered between the OC v2.x and OC v3.x releases with the oc_url_alias and the oc_seo_url fields since it is unlikely possible to create a migration extension specifically for the stores and languages where a store would have more than one store associated with more than one language in this case.derzet wrote: ↑Sun Jun 14, 2020 8:59 pmstill having trouble with SEO and latest 3.0.3.4-core-pre, opening a product givesIn fact there's no such column in my database and - having a brief look - no code in the installer to create itCode: Select all
Fatal error: Uncaught Exception: Error: Unknown column 'query' in 'where clause'<br />Error No: 1054<br />SELECT * FROM oc_seo_url WHERE query = 'product_id=42' in system/library/db/mysqli.php:40
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Please read my previous post about this issue. Again, you are the one who needs to find a way to integrate your old table with the new seo_url table. Then, to configure your SEO profiles from the OC admin.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Then, to configure your SEO profiles from the OC admin.
Clean. I'm removing my former code and db completely with every new update.
Which location do you encounter the query error? More information is needed.derzet wrote: ↑Mon Jun 15, 2020 11:39 pmClean. I'm removing my former code and db completely with every new update.
Perhaps it makes sense to add an extra trailing part to the zip file like 3.0.3.4-core-pre-XX or some kind of version file inside to make sure we know which version we're talking about? All I can tell is the last one i downloaded had 17Mb instead of the former 14Mb
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Code: Select all
$this->db->query("DELETE FROM " . DB_PREFIX . "seo_url WHERE query = 'product_id=" . (int)$product_id . "'");
Code: Select all
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "seo_url WHERE query = 'product_id=" . (int)$product_id . "'");
Screenshot_2020-06-15_19-13-43.png (37.02 KiB) Viewed 15292 times
Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer
Issue spotted. One line was missing but we do not remove it, we need to replace it with the new query line from the master branch. Will update the package shortly.xxvirusxx wrote: ↑Mon Jun 15, 2020 11:59 pmThis fix should be added.
Expired session not deleted from database
https://github.com/opencart/opencart/is ... -480609923
LE. Confirm the bug.
After clean install when you try to edit a product you get query error..
From product model this line should be removedWrong code at getSeoUrls functionCode: Select all
$this->db->query("DELETE FROM " . DB_PREFIX . "seo_url WHERE query = 'product_id=" . (int)$product_id . "'");
No more query in tableCode: Select all
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "seo_url WHERE query = 'product_id=" . (int)$product_id . "'");
LE2. Same issue on Categories, Manufacturer
Crash when you try to add Download...
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Code: Select all
mysqli::real_escape_string() expects parameter 1 to be string, array given in system/library/db/mysqli.php on line 45
Code: Select all
public function getPaths($category_id) {
Code: Select all
public function getPath($category_id) {
return implode('_', array_column($this->getPaths($category_id), 'path_id'));
}
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
still cannot edit these information pages in admincyclops12 wrote: ↑Tue Jun 09, 2020 1:41 am
Plus you cannot edit any of the four information pages in Catalog/information (About Us, Delivery etc) as it comes up with this errorCode: Select all
Notice: Undefined property: Proxy::getInformationDescriptions in C:\xampp\htdocs\oc3.0.3.4\admin\controller\catalog\information.php on line 76
Users browsing this forum: No registered users and 247 guests