Page 1 of 1

upgrade messup

Posted: Sat Jun 23, 2012 8:07 pm
by DnAWebCreations
I just did the update though simple scripts with Blue Host. First I got the error

Code: Select all

Notice: Undefined index: bottom in /home2/klassyk1/public_html/catalog/controller/common/footer.php on line 26Notice: Undefined index: bottom in /home2/klassyk1/public_html/catalog/controller/common/footer.php on line 26Notice: Undefined index: bottom in /home2/klassyk1/public_html/catalog/controller/common/footer.php on line 26Notice: Undefined index: bottom in /home2/klassyk1/public_html/catalog/controller/common/footer.php on line 26Notice: Undefined index: bottom in /home2/klassyk1/public_html/catalog/controller/common/footer.php on line 26Notice: Undefined index: bottom in /home2/klassyk1/public_html/catalog/controller/common/footer.php on line 26
So I removed

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'])
				);
			}
    	}
That error went away now I am getting

Code: Select all

Notice: Error: Table 'klassyk1_pnc1.oc_customer_group_description' doesn't exist
Error No: 1146
SELECT * FROM oc_customer_group cg LEFT JOIN oc_customer_group_description cgd ON (cg.customer_group_id = cgd.customer_group_id) WHERE cgd.language_id = '1' ORDER BY cgd.name ASC in /home2/klassyk1/public_html/system/database/mysql.php on line 49
When I try to go to the system-settings.
This seems to be the code are from the php file it is referring to

Code: Select all

  	public function query($sql) {
		$resource = mysql_query($sql, $this->link);

		if ($resource) {
			if (is_resource($resource)) {
				$i = 0;
    	
				$data = array();
		
				while ($result = mysql_fetch_assoc($resource)) {
					$data[$i] = $result;
    	
					$i++;
				}
				
				mysql_free_result($resource);
				
				$query = new stdClass();
				$query->row = isset($data[0]) ? $data[0] : array();
				$query->rows = $data;
				$query->num_rows = $i;
				
				unset($data);

				return $query;	
    		} else {
				return true;
			}
		} else {
			trigger_error('Error: ' . mysql_error($this->link) . '<br />Error No: ' . mysql_errno($this->link) . '<br />' . $sql);
			exit();
    	}
  	}
Please help I still have to redo all the css changes that the update undone and the customer is going to be PO if she sees it like this.

Re: upgrade messup

Posted: Sat Jun 23, 2012 8:19 pm
by MarketInSG
Do the upgrade manually again. That should fix it. Upgrade with the latest version

Re: upgrade messup

Posted: Sat Jun 23, 2012 8:28 pm
by DnAWebCreations
Well I went to do that and blue host gave me the option to revert back so I did that and the site is back just like it was. How can I do the update and not have it mess up all my setting? Can I save my css file and then just over wright the new one?

Re: upgrade messup

Posted: Sat Jun 23, 2012 9:04 pm
by MarketInSG
What is your current version? If you are using v1.5.1.x and wish to upgrade to v1.5.3.x, then you will need to re do your template.

Re: upgrade messup

Posted: Sat Jun 23, 2012 9:33 pm
by DnAWebCreations
i have version 1.5.2.1

Re: upgrade messup

Posted: Sun Jun 24, 2012 9:29 am
by MarketInSG
Then you can upgrade if you want. Do a manual upgrade yourself. Those scripts dont do the job well

Re: upgrade messup

Posted: Sun Jun 24, 2012 8:33 pm
by DnAWebCreations
Ok I will try that

Re: upgrade messup

Posted: Mon Jun 25, 2012 5:47 pm
by syednayab
i upgraded it to version 1.5.3.1

these are the errors i am finding. please help.

Notice: Undefined index: bottom in /home/a6909368/public_html/catalog/controller/common/footer.php on line 26Notice: Undefined index: bottom in /home/a6909368/public_html/catalog/controller/common/footer.php on line 26Notice: Undefined index: bottom in /home/a6909368/public_html/catalog/controller/common/footer.php on line 26Notice: Undefined index: bottom in /home/a6909368/public_html/catalog/controller/common/footer.php on line 26

Re: upgrade messup

Posted: Sun Sep 16, 2012 5:51 pm
by phonepartsusa
Everyone that is getting this error.. do not be worried.

This is an easy fix.

go to mysql database.

find table 'information'

you need to add a new row in this table called 'bottom'

Code: Select all

`bottom` int(1) NOT NULL default '0',
it needs to be under the 1st row 'information id'