Update problem

24.09.2010 10:32
#1
mrbernd
Joomshopping forum user no avatar
Name: Bernd
18.02.2010
Posts: 309
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: 309
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: 19162
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: 309
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: 309
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: 19162
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: 309
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: 19162
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: 309
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: 19162
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: 309
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: 19162
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
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.