Post by 007davidjames » Thu Oct 06, 2016 1:07 pm

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

Attachments

Screen Shot 2016-10-05 at 3.50.56 PM.png

Screen Shot 2016-10-05 at 3.50.56 PM.png (69.91 KiB) Viewed 654 times

Screen Shot 2016-10-05 at 2.01.16 PM.png

Screen Shot 2016-10-05 at 2.01.16 PM.png (141.33 KiB) Viewed 654 times

Screen Shot 2016-10-05 at 2.09.51 PM.png

Screen Shot 2016-10-05 at 2.09.51 PM.png (129.52 KiB) Viewed 654 times


New member

Posts

Joined
Thu Oct 06, 2016 12:55 pm

Post by cyclops12 » Fri Oct 07, 2016 3:38 am

Most of your errors should be covered by This topic

Expert Member

Posts

Joined
Sun Sep 27, 2015 1:10 am

Post by IP_CAM » Fri Oct 07, 2016 4:18 am

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

I am no longer active at the Forum. Please do NOT send me Personal Mails,
they will no longer be replied to.
My Github OC Site: https://github.com/IP-CAM
4'100 + FREE OC Extensions, on the World's largest Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by cyclops12 » Fri Oct 07, 2016 8:07 pm

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

Expert Member

Posts

Joined
Sun Sep 27, 2015 1:10 am

Post by 007davidjames » Fri Oct 14, 2016 7:31 am

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 . "'");

Attachments

Screen Shot 2016-10-14 at 12.25.35 PM.png

Screen Shot 2016-10-14 at 12.25.35 PM.png (165.54 KiB) Viewed 557 times

Last edited by 007davidjames on Fri Oct 14, 2016 7:40 am, edited 1 time in total.

New member

Posts

Joined
Thu Oct 06, 2016 12:55 pm

Post by IP_CAM » Fri Oct 14, 2016 7:40 am

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

I am no longer active at the Forum. Please do NOT send me Personal Mails,
they will no longer be replied to.
My Github OC Site: https://github.com/IP-CAM
4'100 + FREE OC Extensions, on the World's largest Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by 007davidjames » Sat Oct 15, 2016 11:10 am

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

New member

Posts

Joined
Thu Oct 06, 2016 12:55 pm

Post by 007davidjames » Sat Oct 15, 2016 11:29 am

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

Any help with this would be much appreciated.

Attachments

Screen Shot 2016-10-15 at 4.24.00 PM.png

Screen Shot 2016-10-15 at 4.24.00 PM.png (25.96 KiB) Viewed 527 times

Screen Shot 2016-10-15 at 4.21.16 PM.png

Screen Shot 2016-10-15 at 4.21.16 PM.png (56.36 KiB) Viewed 527 times


New member

Posts

Joined
Thu Oct 06, 2016 12:55 pm

Post by IP_CAM » Sat Oct 15, 2016 4:39 pm

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

I am no longer active at the Forum. Please do NOT send me Personal Mails,
they will no longer be replied to.
My Github OC Site: https://github.com/IP-CAM
4'100 + FREE OC Extensions, on the World's largest Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by 007davidjames » Tue Oct 18, 2016 11:50 am

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?

Attachments

Screen Shot 2016-10-18 at 5.02.41 PM.png

Screen Shot 2016-10-18 at 5.02.41 PM.png (30.86 KiB) Viewed 483 times


New member

Posts

Joined
Thu Oct 06, 2016 12:55 pm
Who is online

Users browsing this forum: No registered users and 6 guests