Later Update Crashed my site need help

Update
I just updated my site, and now it is not working.

Check out my site
leddownlights.co.nz

Could I be advised on the best way to fix this? or am I best to do a complete reinstall. If so could I be pointed in the direction to do this ?

I am about to install a new them and do not want this issue to be present when I do so.

Installation notes

I downloaded update and removed 2 files from the

Upload>config-dist.php
Upload>Admin>config-dist.php

I then Zipped the Upload file

I then uploaded the Zipped “upload file” to my site file public_html

I then unzipped file

At this point, my website stopped working with a fatal error.

Following the installation instructions I
http://leddownlights.co.nz/install
Confirmed it was to Upgrade
I then Upgraded

and completed the rest of the instructions on the Upgrade page.

I then went to file manager and
deleted (zipped) install folder

On Opencart backend my Dashboard was empty and only displayed version installed

Upload from backup
/home1/leddown1/public_html

Same for /home1/leddown1/public_html/admin
and replaced config.php with back up

Admin panel
Resorted

Still not working, so I deleted all the files in my public folder and uploaded my back up to the public> folder

I then when onto opencast backend system>tools>backup restore I then uploaded my backup.

I get a list of *errors I have attached a few lines below








*errors there are more that this

Notice: Error: Table 'leddown1_opencart679.fxi_banner_image_description' doesn't exist
Error No: 1146
TRUNCATE TABLE `fxi_banner_image_description` in /home1/leddown1/public_html/system/library/db/mysqli.php on line 41Notice: Error: Table 'leddown1_opencart679.fxi_banner_image_description' doesn't exist
Error No: 1146
INSERT INTO `fxi_banner_image_description` (`banner_image_id`, `language_id`, `banner_id`, `title`) VALUES ('217', '1', '1', 'Warm vs Natural white') in /home1/leddown1/public_html/system/library/db/mysqli.php on line 41Notice: Error: Table 'leddown1_opencart679.fxi_banner_image_description' doesn't exist

Most of your errors should be covered by This topic

I tried to check, if my new Gun really works. It did, but I accidentally killed my Dog.
Ernie

IP_CAM wrote:I tried to check, if my new Gun really works. It did, but I accidentally killed my Dog.
Ernie

Update

I re-installed the update file.

and then did the *language bug fix

I still have attached errors. I need this sorted ASAP; any hep would be great.

In the back end, my banners pics have no names. When I try to save new names, I get an error message

*Language bug fix
BUG: Deleting a language causes Error: Table banner_image_description doesn't exist

FIX (4722):
- EDIT: admin/model/localisation/language.php
- CHANGE (line 222):
from:
CODE: SELECT ALL
$this->db->query("DELETE FROM " . DB_PREFIX . "banner_image_description WHERE language_id = '" . (int)$language_id . "'");

to:
CODE: SELECT ALL
$this->db->query("DELETE FROM " . DB_PREFIX . "banner_image WHERE language_id = '" . (int)$language_id . "'");

Table 'leddown1_opencart679.fxi_banner_image_description' doesn't exist
it tells you clearly, what's missing, in your DB, it's the Banner Table !
So, first, disable the Banner Module, and try again.
Ernie

Thanks, I removed the slide show modules and I don't have the errors

When I create a new Banner, I hit save and get the attached message.

Any help with this would be much appreciated.

you are seemengly trying to use different DB Prefixes, in one case, this DB Table is called:
banner_image_description
and in the other one, it's called:
fxi_banner_image_description
but I guess, that your UPDATE Attempt did not work in the first place,
because you probably also still try to use Extensions, not longer usable in your latest OC Version.
So, you better talk FACTS, and let us know, exactly, what kinds and Versions of extensions you have installed,
otherways, it makes no sense.
Ernie

Thanks for the replies.

The original version was 2.1.0.2, and I have installed the latest version.

I have only installed several Vq mods,

once this issue is fixed I am going to install journal.

If my image labeling is an issue, please explain what changes I need to make?