Update problem

24.09.2010 10:32
#1
mrbernd
Joomshopping forum user no avatar
Name: Bernd
18.02.2010
Posts: 293
Quote
Update problem

hallo

ich habe meine version von 2.2.4 auf 2.2.5 upgedatet und bekomme folgende fehlermeldung, wenn ich die kategorien aufrufe:

administrator/components/com_jshopping/views/category_list/tmpl/default.php on line 49

meine produktkategorien sind nicht mehr vorhanden?!


JoomShopping: 2.2.5
 
24.09.2010 10:36
#2
mrbernd
Joomshopping forum user no avatar
Name: Bernd
18.02.2010
Posts: 293
Quote
neue kategorie erstellen

hallo,

wenn ich eine neue kategorie erstellen möchte bekomme ich folgenden fehler:
neue kategorie erstellen


JoomShopping: 2.2.5
 
24.09.2010 10:55
#3
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16480
Quote
Aw: Update problem

You did update via next url: (administrator/index.php?option=com_jshopping&controller=update)?
Aw: Update problem

 
24.09.2010 10:58
#4
mrbernd
Joomshopping forum user no avatar
Name: Bernd
18.02.2010
Posts: 293
Quote
Aw: Update problem

no, i did my update by ftp upload. should i do the update by the shop-update-function again?

 
24.09.2010 11:00
#5
mrbernd
Joomshopping forum user no avatar
Name: Bernd
18.02.2010
Posts: 293
Quote
Aw: Update problem

when i do the update by update-function, i get the following message:

DB function failed with error number 1060
Duplicate column name 'show_tax_product_in_cart' SQL=ALTER TABLE `jos_jshopping_config` ADD `show_tax_product_in_cart` TINYINT( 1 ) NOT NULL, ADD `show_sort_product` TINYINT( 1 ) NOT NULL, ADD `show_count_select_products` TINYINT( 1 ) NOT NULL, ADD `order_send_pdf_client` TINYINT( 1 ) NOT NULL, ADD `order_send_pdf_admin` TINYINT( 1 ) NOT NULL

 
24.09.2010 11:01
#6
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16480
Quote
Aw: Update problem

You have not updated database via file update.sql

 
24.09.2010 11:04
#7
mrbernd
Joomshopping forum user no avatar
Name: Bernd
18.02.2010
Posts: 293
Quote
Aw: Update problem

when i update the databas, i get the same message:

#1060 - Duplicate column name 'show_tax_product_in_cart'

 
24.09.2010 11:08
#8
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16480
Quote
Aw: Update problem

Please execute following SQL instruction

delete from `#__jshopping_languages`;


#__ - prefix (example: jos_jshopping_languages)

 
24.09.2010 11:10
#9
mrbernd
Joomshopping forum user no avatar
Name: Bernd
18.02.2010
Posts: 293
Quote
Aw: Update problem

this is my sql-update-file:

ALTER TABLE `jos_jshopping_config` ADD `show_tax_product_in_cart` TINYINT( 1 ) NOT NULL, ADD `show_sort_product` TINYINT( 1 ) NOT NULL, ADD `show_count_select_products` TINYINT( 1 ) NOT NULL, ADD `order_send_pdf_client` TINYINT( 1 ) NOT NULL, ADD `order_send_pdf_admin` TINYINT( 1 ) NOT NULL;
ALTER TABLE `jos_jshopping_config_main_page` ADD `order_finish_descr` text NOT NULL default '';
ALTER TABLE `jos_jshopping_manufacturers` ADD `products_page` int(11) NOT NULL, ADD `products_row` int(11) NOT NULL;
delete from `jos_jshopping_languages`;

 
24.09.2010 11:11
#10
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16480
Quote
Aw: Update problem

Please execute following SQL instruction
delete from `jos_jshopping_languages`;

 
24.09.2010 11:39
#11
mrbernd
Joomshopping forum user no avatar
Name: Bernd
18.02.2010
Posts: 293
Quote
Aw: Update problem

now it works, but i don´t know why.

thanks for your professional support - 5 *****

 
24.09.2011 16:46
#12
sidekick
Joomshopping forum user no avatar
Name: Edwin
04.04.2009
Posts: 4
Quote
Aw: Update problem

Hi, I'm having same problem upgrading from 3.2.6 to 3.2.7.

Executed delete from `jos_jshopping_languages`; successfully.

This is my upgrade file:
ALTER TABLE `#__jshopping_products` CHANGE `product_weight` `product_weight` DECIMAL( 14, 4 ) NOT NULL;
ALTER TABLE `#__jshopping_products` CHANGE `weight_volume_units` `weight_volume_units` DECIMAL( 12, 4 ) NOT NULL;
ALTER TABLE `#__jshopping_shipping_method_price_weight` CHANGE `shipping_weight_from` `shipping_weight_from` DECIMAL( 14, 4 ) NOT NULL ,
CHANGE `shipping_weight_to` `shipping_weight_to` DECIMAL( 14, 4 ) NOT NULL;

This is error:

Error
SQL query:
ALTER TABLE `jos__jshopping_products` CHANGE `product_weight` `product_weight` DECIMAL( 14, 4 ) NOT NULL ;

MySQL said: Documentation
#1146 - Table 'coloured_main.jos__jshopping_products' doesn't exist


Joomla: 1.7
JoomShopping: 3.2.7
PHP: 5.3.1
MySQL: 5.1.53
Website Url: localhost
 
24.09.2011 23:36
#13
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16480
Quote
Aw: Update problem

It is impossible.

 
27.09.2011 14:46
#14
me
Joomshopping forum user no avatar
Name: chase
29.11.2010
Posts: 16
Quote
Aw: Updated to latest and lots of errors

ORDERS
administrator/components/com_jshopping/controllers/orders.php on line 90

administrator/components/com_jshopping/views/orders_list/tmpl/default.php on line 71
PRODUCTS
administrator/components/com_jshopping/views/product_list/tmpl/default.php on line 101

CAT..
administrator/components/com_jshopping/views/category_list/tmpl/default.php on line 59
-----------------------------------

done a complete new install
add all compents etc again

fixed


Joomla: 1.5.23
JoomShopping: 2.97
PHP: 5.2.17
Website Url: PM

Letzte Änderung: 27.09.2011 16:13
 
Copyrights MAXXmarketing GmbH. All Rights Reserved