24.09.2010 10:32
|
|
mrbernd
Name: Bernd
18.02.2010
Posts: 337
|
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
|
|
mrbernd
Name: Bernd
18.02.2010
Posts: 337
|
neue kategorie erstellen
hallo,
wenn ich eine neue kategorie erstellen möchte bekomme ich folgenden fehler:
JoomShopping: 2.2.5
|
|
24.09.2010 10:55
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25938
|
Aw: Update problem
You did update via next url: (administrator/index.php?option=com_jshopping&controller=update)?
|
|
24.09.2010 10:58
|
|
mrbernd
Name: Bernd
18.02.2010
Posts: 337
|
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
|
|
mrbernd
Name: Bernd
18.02.2010
Posts: 337
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25938
|
Aw: Update problem
You have not updated database via file update.sql
|
|
24.09.2010 11:04
|
|
mrbernd
Name: Bernd
18.02.2010
Posts: 337
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25938
|
Aw: Update problem
Please execute following SQL instruction
delete from `#__jshopping_languages`;
#__ - prefix (example: jos_jshopping_languages)
|
|
24.09.2010 11:10
|
|
mrbernd
Name: Bernd
18.02.2010
Posts: 337
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25938
|
Aw: Update problem
Please execute following SQL instruction
delete from `jos_jshopping_languages`;
|
|
24.09.2010 11:39
|
|
mrbernd
Name: Bernd
18.02.2010
Posts: 337
|
Aw: Update problem
now it works, but i don´t know why.
thanks for your professional support - 5 *****
|
|
24.09.2011 16:46
|
|
sidekick
Name: Edwin
04.04.2009
Posts: 4
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25938
|
Aw: Update problem
It is impossible.
|
|
27.09.2011 14:46
|
|
me
Name: chase
29.11.2010
Posts: 16
|
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
|
|