Undefined index: bottom in footer.php

[JohnAsOne]

Hi. I've searched the forum, the single fix mentioned for this doesn't seem to apply to me, it's a different file. I've done a fresh install of Opencart 1.5.3.1 and restored my database. Only after restoring the database does this problem show up.

Undefined index: bottom in /var/www/vhosts/rugoutlet.co.uk/httpdocs/catalog/controller/common/footer.php on line 26Notice: Undefined index: bottom in /var/www/vhosts/rugoutlet.co.uk/httpdocs/catalog/controller/common/footer.php on line 26

Here's the code surrounding line 26 of footer.php:

Code: Select all

      $this->load->model('catalog/information');
      
      $this->data['informations'] = array();

      foreach ($this->model_catalog_information->getInformations() as $result) {
         if ($result['bottom']) {
            $this->data['informations'][] = array(
               'title' => $result['title'],
               'href'  => $this->url->link('information/information', 'information_id=' . $result['information_id'])
            );
         }
       }

I can't find any more information on here or Google about how to fix this. I know it's been fixed in 1.5.3.1 OC but I think it may be something else? PHP is not my strong point.

Appreciate any help or advice.

Cheers,
John.

[opcrat]

That's weird. Can you please verify your database table information has bottom column or not?

[JohnAsOne]

Hi Opcrat,

I'm looking at the database through MySQL Administrator, under "Table Name", where there's items such as category, product, etc. there's no "bottom" column. Am I looking in the right place? I barely understand DB's I'm afraid :/

You're probably right though, from a fresh install I don't get the error, but after restoring my DB it comes back. If I selectively restore only certain fields from the DB it doesn't come back either.

Cheers for the reply,
John.

[jrotem]

Did you solve this problem? I'd like to know too.

[JohnAsOne]

Fraid not mate, I just had to do a fresh install and then only restore essential things from the DB, like products, etc.

Cheers,
John.

[aduakasoft]

have you run update process ? it will adjust your db to use with newest opencart version

[jrotem]

aduakasoft
The problem started after I updated from 1.5.1 to 1.5.3.1. It was fine before. I'd rather not do a clean install as I've spent hours upon hours designing the site and I don't know how to keep the changes I made.

[flipsexchange]

I have this same problem on line 26 and have not found a solution. I have also made many changes to source code and do not want to do a fresh install. This error is happening on two different websites that I have. Any other suggestions would be very helpful.

[cooktech]

same issue here - i left it on my dev site so you can take a look. I have lost so many upgrade paths and abandoned countess open cart sites due to not being able to resolve these types of issues. This is the only reason I use Magento more often for my clients.

[aduakasoft]

check if your database up to date, find bottom field on information table.

[jrotem]

Thank you but where/how? I looked in mySQL and it was there, assuming I looked in the right place.

[aduakasoft]

have you check this : http://www.opencart.com/index.php?route ... on&path=98 ?

have you run your update script ?

[jrotem]

The problem started after updating. Unfortunately I wasn't thinking and used a one-click upgrade via my host.