Error while upgrading

-- url of the page with the problem -- : aer-conditionat-inverter-constanta.ro/Split-de-perete/categorie
-- HikaShop version -- : 2.3.0.
-- Joomla version -- : 3.1
-- PHP version -- : 5.3.18
-- Browser(s) name and version -- : Firefox 28.0
-- Error-message(debug-mod must be tuned on) -- : Error_message

So i was trying to update from 2.1.1. to hikashop 2.3.0 ,because i can't implement some payment plugin and was hoping a upgrade will fixit
But this seems to happen

Hello,
1. Can you give me more information about what's happening when you're upgrading your Hikashop version through your extension manager page ?
2. Also, note that you can try to install it via FTP .

So i installed via FTP
this is the error code that i get while installing it

"1091 Can't DROP 'payment_type'; check that column/key exists SQL=ALTER TABLE `suwxv_hikashop_payment` DROP INDEX payment_type"

and after that multiple pages break down, the error is
1054 - Unknown column 'b.taxation_date_start' in 'where clause' SQL=SELECT b.*,c.* FROM suwxv_hikashop_category AS a LEFT JOIN suwxv_hikashop_taxation AS b ON a.category_namekey=b.category_namekey LEFT JOIN suwxv_hikashop_tax AS c ON b.tax_namekey=c.tax_namekey WHERE a.category_id = 11 AND b.taxation_published=1 AND ( taxation_type = '' OR taxation_type = 'company_with_vat_number' ) AND b.taxation_date_start <= 1396125973 AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1396125973) AND (b.taxation_access = 'all' OR b.taxation_access LIKE '%,8,%')


the only way it doesnt break is if i uninstall it,then install it again,but then i loose my moenus,layouts,settings of my products etc
and after that if i try to edit one of the products i get this error:1054 Unknown column 'b.taxation_date_start' in 'where clause' SQL=SELECT b.*,c.* FROM suwxv_hikashop_category AS a LEFT JOIN suwxv_hikashop_taxation AS b ON a.category_namekey=b.category_namekey LEFT JOIN suwxv_hikashop_tax AS c ON b.tax_namekey=c.tax_namekey WHERE a.category_id = 11 AND b.taxation_published=1 AND ( taxation_type = '' OR taxation_type = 'company_with_vat_number' ) AND b.taxation_date_start <= 1396132077 AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1396132077) AND (b.taxation_access = 'all' OR b.taxation_access LIKE '%,8,%')

Hi,

That's because of this:
www.hikashop.com/support/support/documen...lity-issues.html#SQL
Run the alter query for the taxation_date_start as explained in the documentation and it will work.

It worked eventually , there were several tables not updated i thought i was doing something wrong.
thank you

This error persists tho ...it is where categories listing should be,i created a image for every category,and now it wont display any of them. Please help
Thisare the errors.

Warning: imagecreatetruecolor() [function.imagecreatetruecolor]: Invalid image dimensions in /home/andocomr/public_html/aer-conditionat-constanta/administrator/components/com_hikashop/helpers/image.php on line 451

Warning: imagecolorallocatealpha() expects parameter 1 to be resource, boolean given in /home/andocomr/public_html/aer-conditionat-constanta/administrator/components/com_hikashop/helpers/image.php on line 565

Warning: imagefill() expects parameter 1 to be resource, boolean given in /home/andocomr/public_html/aer-conditionat-constanta/administrator/components/com_hikashop/helpers/image.php on line 467

Warning: imageantialias() expects parameter 1 to be resource, boolean given in /home/andocomr/public_html/aer-conditionat-constanta/administrator/components/com_hikashop/helpers/image.php on line 471

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in /home/andocomr/public_html/aer-conditionat-constanta/administrator/components/com_hikashop/helpers/image.php on line 487

Hi,

Please follow these instructions:
www.hikashop.com/forum/product-category-...-showing.html#148669

Regards,

It did not work.
The code was already there
P.S. my problem is at the front end when trying to display the category images(as shown in the first post image)

Hi,

Please go in the menu Display->Content menus and do a screenshot of the options there.
Also, please do a screenshot of the Images section of the configuration.
Because we're not able to reproduce the error on our end.

Hey nicolas i fixed it , after the update ,the image sizes and pane height were showing different numbers than i previously had set.
Thank you

I had this problem also. I tried all of the solutions to no avail. My user definately did have access to alter the database. I checked in the database and the tables were there.
However, ultimately I noticed that the taxation table was empty. So I added a tax category in the hikashop settings and it fixed it.

I am having this same issue, just after upgrading to 2.3.1. I checked for the code mentioned in this thread in image.php and it's fixed there. I looked at the Files tab in configuration and it looks fine to me. Help please?

Site at: bellwetherwool.com/index.php/roving

I am having this same issue, just after upgrading to 2.3.1. I checked for the code mentioned in this thread in image.php and it's fixed there. I looked at the Files tab in configuration and it looks fine to me. Help please??

[url=http://http://bellwetherwool.com/index.php/roving][/url]

I just found it. Went to Display>Content menus, and I saw that the width for my thumbnails had disappeared. Changed it back and the problem was fixed. Please update this in the next patch, thanks!

Hi,

Which was your previous HikaShop version number ?

Regards,