Thank you for beta2

Phoca Cart - complex e-commerce extension
toonytoony2004
Phoca Member
Phoca Member
Posts: 19
Joined: 15 Jan 2015, 14:09

Thank you for beta2

Post by toonytoony2004 »

Thanks for beta2, love so much and i will test on next month. :| :| :|
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47794
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Thank you for beta2

Post by Jan »

Hi, great to hear it.

Jan
If you find Phoca extensions useful, please support the project
toonytoony2004
Phoca Member
Phoca Member
Posts: 19
Joined: 15 Jan 2015, 14:09

Re: Thank you for beta2

Post by toonytoony2004 »

please, i can't find my topic then i will show again

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
thanks for cart :| :|
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47794
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Thank you for beta2

Post by Jan »

Hi, it is a development version and the upgrading of database does not work, so it needs to be newly installed.

Jan
If you find Phoca extensions useful, please support the project
k.ats
Phoca Member
Phoca Member
Posts: 10
Joined: 10 Aug 2015, 15:14

Re: Thank you for beta2

Post by k.ats »

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
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47794
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Thank you for beta2

Post by Jan »

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
If you find Phoca extensions useful, please support the project
k.ats
Phoca Member
Phoca Member
Posts: 10
Joined: 10 Aug 2015, 15:14

Re: Thank you for beta2

Post by k.ats »

Hi, thx for help.

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`;
"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.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47794
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Thank you for beta2

Post by Jan »

Hi, thank you for the info, I will take a look at it.

Jan
If you find Phoca extensions useful, please support the project
k.ats
Phoca Member
Phoca Member
Posts: 10
Joined: 10 Aug 2015, 15:14

Re: Thank you for beta2

Post by k.ats »

Thank you Jan.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47794
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Thank you for beta2

Post by Jan »

Hi, batch completed in version 3.0.0 RC:
https://www.phoca.cz/news/866-phoca-cart ... c-released

Jan
If you find Phoca extensions useful, please support the project
Post Reply