Set future Product Availability Date For All Products?

[mc12345678]

Is there an update to this? Doesn’t work since the PHP update this Summer. Thanks again; in advance.

admin->tools->Install SQL Patch

Code:

UPDATE products SET products_date_available = 'yyyy-mm-dd 00:00:00';

When posting about an issue, please provide as much information as possible, even if posting because aggravated or "tried everything". Not doing so only slows down getting a solution.

What doesn't work?

Does the available date not display to the customer?
Is the date not in the database?
Does the product not become active at the date/time in question?
Does executing the query cause an error?
From what php to what php version?

Take a moment and think of other things about the information provided and what types of questions may be asked. Giving more information than thought necessary isn't a bad thing as long as it isn't say privacy like information. We don't need to know the specific house number of someone's address, but understanding the country involved may be of help, etc...

[Webskipper]

v157C

PHP Version: 7.4.27 (Zend: 3.4.0)


Date is in 2022: UPDATE products SET products_date_available = ‘2022-01-01 01:01:01';


Results: WARNING: An Error occurred ….


This patch did work last year. I have the shop closed for Winter. Shop stays is Showcase no price. Fails in normal Store mode, too.

[swguy]

Bear in mind that things can fail silently in Install SQL Patches. You might need to use phpMyAdmin and run the command there to report back on the error. Just be sure to specify the prefix (if one is used) when you provide a table name (e.g. UPDATE zc_products ... if the prefix is 'zc_').

[mc12345678]

v157C

PHP Version: 7.4.27 (Zend: 3.4.0)


Date is in 2022: UPDATE products SET products_date_available = ‘2022-01-01 01:01:01';


Results: WARNING: An Error occurred ….


This patch did work last year. I have the shop closed for Winter. Shop stays is Showcase no price. Fails in normal Store mode, too.

What does the resulting myDebug-adm- log have to say about the operation? (Obscure the admin directory if posting the log. Also just before pasting it, look in the messagebox toolbar for the # symbol so that post between CODE tags.

If haven't yet, can install display logs in the modules->plugin manager section...

This appears will likely be a mysql related issue rather than a ZC issue.

[carlwhat]

v157C

PHP Version: 7.4.27 (Zend: 3.4.0)


Date is in 2022: UPDATE products SET products_date_available = ‘2022-01-01 01:01:01';


Results: WARNING: An Error occurred ….


This patch did work last year. I have the shop closed for Winter. Shop stays is Showcase no price. Fails in normal Store mode, too.

you quotes look off...

//from
UPDATE products SET products_date_available = ‘2022-01-01 01:01:01';
//to
UPDATE products SET products_date_available = ‘2022-01-01 01:01:01‘;
//or
UPDATE products SET products_date_available = '2022-01-01 01:01:01';

[swguy]

Nice! Eagle-eyed @carlwhat to the rescue!

[carlwhat]

Nice! Eagle-eyed @carlwhat to the rescue!

[Webskipper]

Thanks Carl for the Catch!

Admin debug sez:
#1 trigger_error() called at [/includes/classes/db/mysql/query_factory.php:170]
#2 queryFactory->show_error() called at [/includes/classes/db/mysql/query_factory.php:142]
#3 queryFactory->set_error() called at [/includes/classes/db/mysql/query_factory.php:269]
#4 queryFactory->Execute() called at [/sniFf-mbN-Truck/sqlpatch.php:294]
#5 executeSql() called at [/sniFf-mbN-Truck/sqlpatch.php:735]
#6 require(/sniFf-mbN-Truck/sqlpatch.php) called at [/sniFf-mbN-Truck/index.php:11]
--> PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '01:01:01‘' at line 1 :: UPDATE products SET products_date_available = ‘2022-01-01 01:01:01‘; ==> (as called by) /sniFf-mbN-Truck/sqlpatch.php on line 294 <== in /includes/classes/db/mysql/query_factory.php on line 170.

v157C
PHP Version: 7.4.27 (Zend: 3.4.0)
Store mode is Showcase only

[carlwhat]

this works for me.

UPDATE products SET products_date_available = '2022-01-01'

[swguy]

I think he may have the same issue as before.

Be sure you use the forward quote ' not the back quote `.