Phoca Cart beta87 and RC1. Need to update DB?

[sulpher]

Hi,
There was PC beta87 installed. I have been installed RC1 over beta87. Is everything clear with DB?
I see .sql file and the last comment was related to -- 5.0.0 Beta83

Af far as I understand, nothing need to be updated with the DB. But I just want to make things clear and asking here.

Thanks.

[Benno]

Hi,

I see .sql file and the last comment was related to -- 5.0.0 Beta83

There have been some changes in database since Phoca Cart 5.0.0 Beta83:

See: pkg_phocacart_v5.0.0RC\packages\com_phocacart_v5.0.0RC\admin\update\sql\mysql\5.0.0.sql

Kind regards,
Benno

[sulpher]

Hi Benno,
Thanks for your reply.
Ah, OMG, how I could miss these lines...
Yes, I see it. thank you.

Code: Select all

-- 5.0.0 Beta103
INSERT IGNORE INTO `#__mail_templates` (`template_id`, `extension`, `language`, `subject`, `body`, `htmlbody`, `attachments`, `params`) VALUES
    ('com_phocacart.question', 'com_phocacart', '', 'COM_PHOCACART_EMAIL_QUESTION_SUBJECT', 'COM_PHOCACART_EMAIL_QUESTION_BODY', 'COM_PHOCACART_EMAIL_QUESTION_HTMLBODY', '', '{"tags":["name","email","phone","product_title","product_long_title","product_sku","product_link","product_url","category_title","category_long_title","category_link","category_url","site_name","site_link","site_url"]}');
INSERT IGNORE INTO `#__mail_templates` (`template_id`, `extension`, `language`, `subject`, `body`, `htmlbody`, `attachments`, `params`) VALUES
    ('com_phocacart.question.admin', 'com_phocacart', '', 'COM_PHOCACART_EMAIL_QUESTION_ADMIN_SUBJECT', 'COM_PHOCACART_EMAIL_QUESTION_ADMIN_BODY', 'COM_PHOCACART_EMAIL_QUESTION_ADMIN_HTMLBODY', '', '{"tags":["name","email","phone","product_title","product_long_title","product_sku","product_link","product_url","category_title","category_long_title","category_link","category_url","site_name","site_link","site_url"]}');
INSERT INTO `#__mail_templates` (`template_id`, `extension`, `language`, `subject`, `body`, `htmlbody`, `attachments`, `params`) VALUES
    ('com_phocacart.submit_item', 'com_phocacart', '', 'COM_PHOCACART_EMAIL_SUBMIT_ITEM_SUBJECT', 'COM_PHOCACART_EMAIL_SUBMITE_ITEM_BODY', 'COM_PHOCACART_EMAIL_SUBMIT_ITEM_HTMLBODY', '', '{"tags":["user_name","user_username","user_email","products","product_title","product_sku","product_url","site_name","site_url"]}');
INSERT INTO `#__mail_templates` (`template_id`, `extension`, `language`, `subject`, `body`, `htmlbody`, `attachments`, `params`) VALUES
    ('com_phocacart.submit_item.admin', 'com_phocacart', '', 'COM_PHOCACART_EMAIL_SUBMIT_ITEM_ADMIN_SUBJECT', 'COM_PHOCACART_EMAIL_SUBMITE_ITEM_ADMIN_BODY', 'COM_PHOCACART_EMAIL_SUBMIT_ITEM_ADMIN_HTMLBODY', '', '{"tags":["user_name","user_username","user_email","products","product_title","product_sku","product_url","site_name","site_url"]}');

ALTER TABLE `#__phocacart_orders` ADD COLUMN `payment_date` datetime;

Well, should I run these queries since beta103 in phpmyadmin or need to verify each column manually?

[sulpher]

I've ran these queries and got correct update.
The question has been resolved.

Thank you, Benno.

[Benno]

Hi,
see: https://forum.joomla.de/thread/2712-pho ... post167253

1) Entweder Update, aber man muss manuell einige SQL Queries in Datenbank durchführen - Wenn du nicht weißt, welche, dann gehst du von der letzten zur ersten und führst so lange SQL-Abfragen aus, bis dir die Datenbank beispielsweise sagt, dass die Spalte schon existiert – dann weißt du, dass du weder diese Abfrage noch die vorherige ausführen musst: administrator/components/com_phocacart/update/sql/mysql/5.0.0.sql

Translated:

1) Either update, but you have to manually run some SQL queries in database - If you don't know which one, then go from the last one to the first one and run SQL queries until the database tells you for example that the column already exists - then you know that you don't have to run this query or the previous one: administrator/components/com_phocacart/update/sql/mysql/5.0.0.sql

Kind regards,
Benno
Edit: too late...

[Benno]

You're welcome!

Kind regards,
Benno