database error?

Kastancia

Hi, I wonder if anyone can help me?
I try to create banners in Opencart but get a very big error message as follows : Fatal error: Uncaught exception 'ErrorException' with message 'Error: Unknown column 'description' in 'field list'<br />Error No: 1054<br />INSERT INTO oc_banner_image_description SET banner_image_id = '129', language_id = '1', banner_id = '15', title = 'Banner test', description = ''' in /home/myhost/public_html/mysite.com/shop4/system/database/mysqli.php:41 Stack trace: #0 /home/myhost/public_html/mysite.com/shop4/vqmod/vqcache/vq2-system_library_db.php(20): DBMySQLi->query('INSERT INTO oc...') #1 /home/myhost/public_html/mysite.com/shop4/vqmod/vqcache/vq2-admin_model_design_banner.php(37): DB->query('INSERT INTO oc...') #2 /home/myhost/public_html/mysite.com/shop4/vqmod/vqcache/vq2-admin_controller_design_banner.php(55): ModelDesignBanner->editBanner('15', Array) #3 [internal function]: ControllerDesignBanner->update() #4 /home/myhost/public_html/mysite.com/shop4/vqmod/vqcache/vq2-system_engine_front.php(42): call_user_func_array(Array, Array) #5 /home/ypnaitji/public_html in /home/myhost/public_html/mysite.com/shop4/system/database/mysqli.php on line 41

Also, I have cloned the site to try and work around the problem but get this message now appearing on the front end: Notice: unserialize(): Error at offset 408 of 520 bytes in /home/myhost/public_html/mysite.com/the_shop/index.php on line 67

Any ideas anyone?
Thanks in advance.....

Weedpacket

Most of the error message is telling you where the error occurred.
The error itself is "'Error: Unknown column 'description'". Apparently the table "oc_banner_image_description" doesn't have a column named 'description'.

Kastancia

Hi, thanks for the quick reply. I don't know why this has happened as the database and all other scripts have not been altered, the Opencart software has not been updated in anyway (I have auto update turned off). A test site I did is fine. How would I change this back to what it is supposed to be?
Thanks.

Weedpacket;11053621 wrote:
Most of the error message is telling you where the error occurred.
The error itself is "'Error: Unknown column 'description'". Apparently the table "oc_banner_image_description" doesn't have a column named 'description'.

sneakyimp

This sort of thing typically happens when your code is changed to make reference to some new column that is supposed to be added to a database but that column never gets added. Alternatively, it can happen when a column is deleted from your database but your code is still referring to it. I don't think there's any way we can explain to you how this happened. We don't know what code is running, we don't know if it changed or what might have changed it. We don't know your database structure and if it's changed or what might have changed it. Sounds like you'll need to do some sleuthing.

To fix the problem, sounds like either your code or your database is going to have to change so that the two match. Which should be changed? I've no idea.

SerenityPantone

I also experience a database error most of the time. I think, it is a signal that there are really errors while connecting to the site? By the way, I also try to find out how to fix it and found this site: How to Fix the Error. It might help.

Kastancia

Thanks Sneakimp, have checked the SQL database and it doesn't reference a Description column, damned if I know how one has been added into the OpenCart admin section!

sneakyimp;11053653 wrote:
This sort of thing typically happens when your code is changed to make reference to some new column that is supposed to be added to a database but that column never gets added. Alternatively, it can happen when a column is deleted from your database but your code is still referring to it. I don't think there's any way we can explain to you how this happened. We don't know what code is running, we don't know if it changed or what might have changed it. We don't know your database structure and if it's changed or what might have changed it. Sounds like you'll need to do some sleuthing.

To fix the problem, sounds like either your code or your database is going to have to change so that the two match. Which should be changed? I've no idea.

Kastancia

Thanks SerenityPantone, I will have a look. I have a feeling that it's the OpenCart software that is the cause, it's just tracking it down that's giving me a headache! 🙁

I'll have a look at the video, many thanks.

SerenityPantone;11053727 wrote:
I also experience a database error most of the time. I think, it is a signal that there are really errors while connecting to the site? By the way, I also try to find out how to fix it and found this site: How to Fix the Error. It might help.

Kastancia

It appears that the New-Carousel module (a VQmod add on) has added a description field to the Banner design area without changing the SQL database that still only has 3 fields allocated. This may be a VQmod problem or my template, the template supplier is looking into it. I disable the New-Carousel module and I now have no problem adding banner designs.

Kastancia;11053829 wrote:
Thanks SerenityPantone, I will have a look. I have a feeling that it's the OpenCart software that is the cause, it's just tracking it down that's giving me a headache! 🙁

I'll have a look at the video, many thanks.

Kastancia

sneakyimp;11053653 wrote:
This sort of thing typically happens when your code is changed to make reference to some new column that is supposed to be added to a database but that column never gets added. Alternatively, it can happen when a column is deleted from your database but your code is still referring to it. I don't think there's any way we can explain to you how this happened. We don't know what code is running, we don't know if it changed or what might have changed it. We don't know your database structure and if it's changed or what might have changed it. Sounds like you'll need to do some sleuthing.

To fix the problem, sounds like either your code or your database is going to have to change so that the two match. Which should be changed? I've no idea.

sneakyimp

Plugin devs for some of these open source projects can be super flaky. If the plugin requires a change to one of your base db tables, they should have supplied some SQL you can run to make the changes. Sounds to me like you should grief the plugin devs a bit -- or read their documentation more carefully.