OpenCart Community

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

BUG: Error: Could not load model total!

Two-part bug. Part one: Event Compatibility cuts off too many parts of the route when trying to load the older extension format. ex. "extension/total/sub_total/getTotal" route gets turned into "total/sub_total" instead of "total/sub_total/getTotal". This causes it to try and load a model with no name throwing the exception. Part Two, this compatibility is being loaded fine when the route is "extension/total/subtotal" but is also loading when the route is "extension/total/sub_total/getTotal". I think this event should not be triggered for compatibility because it is a getTotal is a function call, not a model load. This causes the verification to fail and try to load the 2.2.x version which has other bits missing and throws different errors. Haven't figured out why the function call is going down the event path. But basically the attempt to support backwards compatibility with 2.2 mods is causing problems.

2 Solutions

FIX 1: Give up on 2.2.x compatibility and delete the following left-over folders:

Code: Select all

    catalog/model/total
    catalog/model/payment
    catalog/controller/payment
    catalog/model/shipping
    catalog/controller/module
    admin/controller/total
    admin/controller/payment
    admin/controller/shipping
    admin/controller/module

FIX 2: Add a hack to bypass the event when the function call for "getTotal", "getMethod", or "getQuote" are passed in. This is experimental but should at least restore support for 2.2.x mods for now. This is NOT a permanent fix. Just a work around.
EDIT: catalog/controller/event/compatibility.php
FIND:

Code: Select all

'model/' . $route. '.php'

REPLACE WITH:

Code: Select all

'model/' . ((strpos($route,'get') !== false) ? dirname($route) : $route) . '.php'

This should let routes like "extension/total/sub_total" work but block "extension/total/sub_total/getTotal" calls which fail on the directory check.

BUG: When enabled, fraud modules cause an error to be thrown during order completion, which can prevent the order from being fully completed. The error message thrown is: "Call to a member function check() on a non-object in /catalog/model/checkout/order.php"

FIX: http://forum.opencart.com/viewtopic.php ... 93#p638230

mbeerli wrote:FTP of files worked great,
Upgrade of DB seemed to work
Admin pages seem fine, all pages show up, dashboard, products and so on.
But main page homepage is blank.

Any suggestions?
Something strange:
If I delete config.php and replace with an empty file
the site trys to load for a while and the URL shows
<domain>/install/install/install/install/install/install/install/install/install/install/install/install/install/install/install/install/install/install/install/install/index.php

visual wrote:Hi all.

I am migrating over to Opencart from Zencart and I have downloaded version 2.3.0.1 .. I have uploaded it to my server and there is a PHP version issue

I am running PHP Version 5.3.27 on the server and the message I am getting when I browse to the install is it requires version 5.4 ?

So ... can someone please advise a Opencart build that is compatible with my PHP version ? .. I have looked at the download requirements and on there it is stating 5.3+

I await your response.

Kind regards

visual wrote:Many thanks for your response straightlight

I am taking your advice and downloading the latest version to try it again. If it works .. I will update you here.

Basically .. I uploaded to my server and targetted the domain, going to the "install" directory. The webpage just gave me a text response saying "PHP version 5.4 required" .. I hope this explains it, if it happens again this time .. I will post a screenshot of the response.

rikn78 wrote:Hi,
I have just upgraded from opencart 2.2 to 2.2.0.3 and when I open the storefront I get a blank page with http error 500 on it. I have logged the error below but have no idea what it all means or where to start. Any suggestions please?

rikn78 wrote:Hi,
I have just upgraded from opencart 2.2 to 2.2.0.3 and when I open the storefront I get a blank page with http error 500 on it. I have logged the error below but have no idea what it all means or where to start. Any suggestions please?

catalog/model/feed
catalog/model/fraud
catalog/model/module
catalog/model/openbay
catalog/model/payment
catalog/model/shipping
catalog/model/total

opencartArab wrote:

rikn78 wrote:Hi,
I have just upgraded from opencart 2.2 to 2.2.0.3 and when I open the storefront I get a blank page with http error 500 on it. I have logged the error below but have no idea what it all means or where to start. Any suggestions please?

remove this folders:

Code: Select all

catalog/model/feed
catalog/model/fraud
catalog/model/module
catalog/model/openbay
catalog/model/payment
catalog/model/shipping
catalog/model/total

mbeerli wrote:FTP of files worked great,
Upgrade of DB seemed to work
Admin pages seem fine, all pages show up, dashboard, products and so on.
But main page homepage is blank.

Any suggestions?
Something strange:
If I delete config.php and replace with an empty file
the site trys to load for a while and the URL shows
<domain>/install/install/install/install/install/install/install/install/install/install/install/install/install/install/install/install/install/install/install/install/index.php

Warning: require(/homepages/13/d561807322/htdocs/arcadeshop/catalog/language/en-gb/common/footer.php): failed to open stream: Permission denied in /homepages/13/d561807322/htdocs/arcadeshop/system/library/language.php on line 49
Fatal error: require(): Failed opening required '/homepages/13/d561807322/htdocs/arcadeshop/catalog/language/en-gb/common/footer.php' (include_path='.:/usr/lib/php5.5') in /homepages/13/d561807322/htdocs/arcadeshop/system/library/language.php on line 49

kermit627 wrote:Upgraded from 2.0.3.1 to 2.3.0.2 - any assistance is greatly appreciated.

After upgrading this is the error code i'm receiving:

Warning: require(/homepages/13/d561807322/htdocs/arcadeshop/catalog/language/en-gb/common/footer.php): failed to open stream: Permission denied in /homepages/13/d561807322/htdocs/arcadeshop/system/library/language.php on line 49
Fatal error: require(): Failed opening required '/homepages/13/d561807322/htdocs/arcadeshop/catalog/language/en-gb/common/footer.php' (include_path='.:/usr/lib/php5.5') in /homepages/13/d561807322/htdocs/arcadeshop/system/library/language.php on line 49

Fatal error: Uncaught exception 'Exception' with message 'Error: Could not load model total!' in /homepages/13/d561807322/htdocs/arcadeshop/system/engine/loader.php:169 Stack trace: #0 [internal function]: Loader->{closure}(Array, Array) #1 /homepages/13/d561807322/htdocs/arcadeshop/system/engine/proxy.php(25): call_user_func_array(Object(Closure), Array) #2 /homepages/13/d561807322/htdocs/arcadeshop/catalog/controller/common/cart.php(37): Proxy->__call('getTotal', Array) #3 /homepages/13/d561807322/htdocs/arcadeshop/catalog/controller/common/cart.php(37): Proxy->getTotal(Array) #4 [internal function]: ControllerCommonCart->index(Array) #5 /homepages/13/d561807322/htdocs/arcadeshop/system/engine/action.php(51): call_user_func_array(Array, Array) #6 /homepages/13/d561807322/htdocs/arcadeshop/system/engine/loader.php(24): Action->execute(Object(Registry), Array) #7 /homepages/13/d561807322/htdocs/arcadeshop/catalog/controller/common/header.php(129): Loader->controller('common/cart') #8 [internal function]: ControllerCommonH in /homepages/13/d561807322/htdocs/arcadeshop/system/engine/loader.php on line 169

Qphoria wrote:

kermit627 wrote:Upgraded from 2.0.3.1 to 2.3.0.2 - any assistance is greatly appreciated.

After upgrading this is the error code i'm receiving:

Warning: require(/homepages/13/d561807322/htdocs/arcadeshop/catalog/language/en-gb/common/footer.php): failed to open stream: Permission denied in /homepages/13/d561807322/htdocs/arcadeshop/system/library/language.php on line 49
Fatal error: require(): Failed opening required '/homepages/13/d561807322/htdocs/arcadeshop/catalog/language/en-gb/common/footer.php' (include_path='.:/usr/lib/php5.5') in /homepages/13/d561807322/htdocs/arcadeshop/system/library/language.php on line 49

Not sure. Seems like some sort of permissions thing. Does the file catalog/language/en-gb/common/footer.php exist and can you edit it in ftp normally?