Hi there,
I am developing a new OC site and I am getting some weird errors whenever I try to add a new article. The article does add, but when I try to edit, I get the error below. I think there is some corruption in my MySQL DB. Can anyone help please? Thanks
Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /var/www/vhosts/test.com/httpdocs/dev/system/library/db/mysqli.php on line 18
Fatal error: Uncaught exception 'Exception' with message 'Error: Subquery returns more than 1 row<br />Error No: 1242<br />SELECT DISTINCT *, (SELECT keyword FROM oc_url_alias WHERE query = 'information_id=8') AS keyword FROM oc_information WHERE information_id = '8'' in /var/www/vhosts/test.com/httpdocs/dev/system/library/db/mysqli.php:40 Stack trace: #0 /var/www/vhosts/test.com/httpdocs/dev/system/library/db.php(16): DB\MySQLi->query('SELECT DISTINCT...', Array) #1 /var/www/vhosts/test.com/httpdocs/dev/admin/model/catalog/information.php(78): DB->query('SELECT DISTINCT...') #2 [internal function]: ModelCatalogInformation->getInformation('8') #3 /var/www/vhosts/test.com/httpdocs/dev/system/storage/modification/system/engine/loader.php(178): call_user_func_array(Array, Array) #4 [internal function]: Loader->{closure}(Array, Array) #5 /var/www/vhosts/test.com/httpdocs/dev/system/engine/proxy.php(25): call_user_func_array(Object(Closure), Array) #6 /var/www/vhosts/test.com/httpdocs/ in /var/www/vhosts/test.com/httpdocs/dev/system/library/db/mysqli.php on line 40
Code: Select all
SELECT keyword FROM oc_url_alias WHERE query = 'information_id=8'
It should be a good idea to LIMIT 1 on the resultset, to avoid future problems, but if there is in fact more duplicated content on that table, you might run into problems later on anyway.
Opencart Developer - My Extension Showcase
Contact me at aeon.yoda@gmail.com
Who is online
Users browsing this forum: No registered users and 75 guests