Thank you for beta2
-
- Phoca Member
- Posts: 19
- Joined: 15 Jan 2015, 14:09
Thank you for beta2
Thanks for beta2, love so much and i will test on next month.
- Jan
- Phoca Hero
- Posts: 47794
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Thank you for beta2
Hi, great to hear it.
Jan
Jan
If you find Phoca extensions useful, please support the project
-
- Phoca Member
- Posts: 19
- Joined: 15 Jan 2015, 14:09
Re: Thank you for beta2
please, i can't find my topic then i will show again
my brother upgrade beta 1 to beta 2 and he found message
thanks for cart
my brother upgrade beta 1 to beta 2 and he found message
Code: Select all
1054 - Unknown column 'a.sales' in 'field list' SQL=SELECT a.id, a.title, a.image, a.alias, a.description, a.catid, c.id AS categoryid, c.title AS categorytitle, c.alias AS categoryalias, a.price, a.price_original, t.tax_rate as taxrate, t.calculation_type as taxcalculationtype, t.title as taxtitle, a.date, a.sales, a.featured, a.external_id, AVG(r.rating) AS rating, at.required AS attribute_required FROM crotc_phocacart_products AS a LEFT JOIN crotc_phocacart_categories AS c ON c.id = a.catid LEFT JOIN crotc_phocacart_taxes AS t ON t.id = a.tax_id LEFT JOIN crotc_phocacart_reviews AS r ON a.id = r.product_id AND r.id > 0 LEFT JOIN crotc_phocacart_attributes AS at ON a.id = at.product_id AND at.id > 0 AND at.required = 1 WHERE c.id = 5 AND a.published = 1 AND c.published = 1 AND c.access IN (1,1,5) AND a.access IN (1,1,5) GROUP BY a.id ORDER BY a.date DESC LIMIT 0, 6
- Jan
- Phoca Hero
- Posts: 47794
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Thank you for beta2
Hi, it is a development version and the upgrading of database does not work, so it needs to be newly installed.
Jan
Jan
If you find Phoca extensions useful, please support the project
-
- Phoca Member
- Posts: 10
- Joined: 10 Aug 2015, 15:14
Re: Thank you for beta2
Hi, if I uninstall beta1, and install a new beta2, will remain my data? Thanks. Im sorry for my english...
Czech: Pokud odinstaluji Phoca Cart ve verzi beta 1 a nainstaluji novou verzi Phoca Cart beta2, zůstanou mi předchozí data? Děkuji
Czech: Pokud odinstaluji Phoca Cart ve verzi beta 1 a nainstaluji novou verzi Phoca Cart beta2, zůstanou mi předchozí data? Děkuji
- Jan
- Phoca Hero
- Posts: 47794
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Thank you for beta2
Hi, no, when uninstalling component in Joomla!, then the data will be lost.
Updating is done per installing only (this means you don't uninstall but install the component over the other). The problem is, Phoca Cart in development version so there the update script is not working with database items. This means, to not lose the data:
- install the component (not uninstall the previous version)
- manually add new columns (tables) in your database (e.g. per phpMyAdmin)
The changes in database are stored here:
administrator/components/com_phocacart/install/sql/mysql/install.utf8.sql
at the bottom
Jan
Updating is done per installing only (this means you don't uninstall but install the component over the other). The problem is, Phoca Cart in development version so there the update script is not working with database items. This means, to not lose the data:
- install the component (not uninstall the previous version)
- manually add new columns (tables) in your database (e.g. per phpMyAdmin)
The changes in database are stored here:
administrator/components/com_phocacart/install/sql/mysql/install.utf8.sql
at the bottom
Jan
If you find Phoca extensions useful, please support the project
-
- Phoca Member
- Posts: 10
- Joined: 10 Aug 2015, 15:14
Re: Thank you for beta2
Hi, thx for help.
Here is SQL code to fix it:
"x" is prefix DB on SQL server.
I have a question. When I perform batch processing. For example, copy the products into other languages. For new products copied in other languages missing images. Can not you fix it? Or do I need for each copied item reassign pictures? It would take a lot of time. Thx.
Example:
It is OK -> http://www.arboldeseda.com/cs/produkty/ ... ocka-modry
It isn't OK (missing pictures) -> http://www.arboldeseda.com/en/products- ... erfly-blue
Thank you.
Here is SQL code to fix it:
Code: Select all
ALTER TABLE `#_phocacart_specifications` ADD `alias_value` VARCHAR(255) NOT NULL DEFAULT '' AFTER `language`;
ALTER TABLE `#_phocacart_products` ADD `sales` INT(11) NOT NULL DEFAULT '0' AFTER `language`;
ALTER TABLE `#_phocacart_products` ADD `serial_number` VARCHAR(255) NOT NULL DEFAULT '' AFTER `sales`;
ALTER TABLE `#_phocacart_products` ADD `registration_key` VARCHAR(255) NOT NULL DEFAULT '' AFTER `serial_number`;
ALTER TABLE `#_phocacart_products` ADD `external_id` VARCHAR(255) NOT NULL DEFAULT '' AFTER `registration_key`;
ALTER TABLE `#_phocacart_products` ADD `external_key` VARCHAR(255) NOT NULL DEFAULT '' AFTER `external_id`;
I have a question. When I perform batch processing. For example, copy the products into other languages. For new products copied in other languages missing images. Can not you fix it? Or do I need for each copied item reassign pictures? It would take a lot of time. Thx.
Example:
It is OK -> http://www.arboldeseda.com/cs/produkty/ ... ocka-modry
It isn't OK (missing pictures) -> http://www.arboldeseda.com/en/products- ... erfly-blue
Thank you.
- Jan
- Phoca Hero
- Posts: 47794
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Thank you for beta2
Hi, thank you for the info, I will take a look at it.
Jan
Jan
If you find Phoca extensions useful, please support the project
- Jan
- Phoca Hero
- Posts: 47794
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Thank you for beta2
Hi, batch completed in version 3.0.0 RC:
https://www.phoca.cz/news/866-phoca-cart ... c-released
Jan
https://www.phoca.cz/news/866-phoca-cart ... c-released
Jan
If you find Phoca extensions useful, please support the project