Post by JohnAsOne » Tue Jun 26, 2012 7:49 pm

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.

Newbie

Posts

Joined
Tue Jun 19, 2012 9:06 pm

Post by opcrat » Wed Jun 27, 2012 4:20 am

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

Most Useful Extensions || Most Selling Extensions
Opencart Development || Opencart Designing || eCommerce Project

✔ Join more than 5000 Happy Opencart Store Owners enjoying the extensions designed and developed by Opcrat, Opencart Partner.


User avatar
Active Member

Posts

Joined
Wed Dec 21, 2011 6:54 am

Post by JohnAsOne » Wed Jun 27, 2012 5:46 pm

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.

Newbie

Posts

Joined
Tue Jun 19, 2012 9:06 pm

Post by jrotem » Thu Jun 28, 2012 5:35 am

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

User avatar
New member

Posts

Joined
Sun Jun 24, 2012 3:38 pm

Post by JohnAsOne » Thu Jun 28, 2012 5:00 pm

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.

Newbie

Posts

Joined
Tue Jun 19, 2012 9:06 pm

Post by aduakasoft » Thu Jun 28, 2012 8:42 pm

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

MODULE PRODUCT SORT, CUSTOM ORDER FILTER, SEO CACHE, BULK DISCOUNT


User avatar
Active Member

Posts

Joined
Thu Mar 29, 2012 8:04 am

Post by jrotem » Mon Jul 02, 2012 11:17 am

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.

User avatar
New member

Posts

Joined
Sun Jun 24, 2012 3:38 pm

Post by flipsexchange » Mon Jul 09, 2012 9:39 am

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.

Newbie

Posts

Joined
Mon Jul 09, 2012 9:35 am

Post by cooktech » Wed Jul 18, 2012 7:57 pm

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.

Newbie

Posts

Joined
Wed Jul 18, 2012 7:53 pm

Post by aduakasoft » Wed Jul 18, 2012 11:00 pm

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

MODULE PRODUCT SORT, CUSTOM ORDER FILTER, SEO CACHE, BULK DISCOUNT


User avatar
Active Member

Posts

Joined
Thu Mar 29, 2012 8:04 am

Post by jrotem » Thu Jul 19, 2012 10:49 am

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

User avatar
New member

Posts

Joined
Sun Jun 24, 2012 3:38 pm

User avatar
Active Member

Posts

Joined
Thu Mar 29, 2012 8:04 am

Post by jrotem » Fri Jul 20, 2012 6:41 am

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

User avatar
New member

Posts

Joined
Sun Jun 24, 2012 3:38 pm
Who is online

Users browsing this forum: No registered users and 142 guests