Unknown column 'default_left_column' in 'field list'

[dformica]

Please, How do I fix this error?

This is a fresh install of PS 1.6.0.6 then imported a backup from my current PS 1.5.6.0

[PrestaShopDatabaseException]

Unknown column 'default_left_column' in 'field list'

		SELECT IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
		FROM ps_theme t
		LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
		LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
		WHERE t.id_theme =1 AND m.page = "index" LIMIT 1


at line 635 in file classes/db/Db.php

629. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
630. 		}
631. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
632. 		{
633. 			if ($sql)
634. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
635. 			throw new PrestaShopDatabaseException($this->getMsgError());
636. 		}
637. 	}
638. 
639. 	/**

[vekia]

 

 

 then imported a backup from my current PS 1.5.6.0

how you imported this backup? 

database structure in 1.5.6.0 is totally (not so much but it is) different than 1.6.x

[NemoPS]

If you imported a 1.5 dump on a 1.6 installation you should better do it from scratch, it's never going to work this way, as vekia said db structures are different

[dformica]

how you imported this backup? 

database structure in 1.5.6.0 is totally (not so much but it is) different than 1.6.x

 

I did an export via PHPAdmin on my current site database 1.5.6.0 then I imported that .sql file into my fresh 1.6 install.  It completed sucessfully but obviously something went wrong.

 

So what do you recommend to setup my new 1.6 site and load data from my current site?

Edited April 23, 2014 by dformica (see edit history)

[vekia]

upgrade your 1.5 shop to 1.6

then export database and import it to your fresh 1.6 installation.

[dformica]

OK.  I made a copy of my current 1.5.6.0 and did the automated upgrade to 1.5.6.2 and then to 1.6.0.6

Everything completed successfully.  Right now my development site 1.6.0.6 is looking way off but I'm working on making the small updates fix it.  I leave those for other threads. 
 

Thanks!! @vekia and  @Nemo1