Forums / Setting Up Specials and SaleMaker / Salemaker Start and Finsh Date

Salemaker Start and Finsh Date

Views: 4,416

Results 1 to 4 of 4
2 Nov 2023, 12:05 AM
#1
bruce1952 avatar

bruce1952

Totally Zenned

Join Date:
Aug 2008
Location:
Sydney Australia
Posts:
828
Plugin Contributions:
0

Salemaker Start and Finsh Date

Server Information:
Server Host: outdoorking.com (172.105.167.154)
Database: outdoorking_xxxx
Home: /home/xxx/public_html/xxx/Server OS: Linux 3.10.0-1062.12.1.el7.x86_64
Server Date: 31/10/2023 09:16:50
Server Up Time: Disabled/UnavailableHTTP
Server: ApachePHP Version: 7.3.33 (Zend: 3.3.33)PHP File
Uploads: OnUpload Max Size: 1024M
PHP Memory Limit: 1024M
POST Max Size: 1024M
Database Engine: MySQL 5.7.44
Database Host: localhost (127.0.0.1)
Database Date: 31/10/2023 09:16:50
Database Data Size: 244,309 kBDatabase
Index Size: 41,430 kBMySQL Slow Query Log
Status: OffMySQL Slow Query
Log File: /var/lib/mysql/au-slow.logMySQL Mode: NO_ENGINE_SUBSTITUTION

Hi All,

I am running zencart 1.5.8a on a test server using the bootstrap template which is stated as the preferred template but I am having an issue with the Salemaker section.

  1. If I load a start date and end date the module does not activate
  2. If I remove the start date it activates and works
  3. We changed the date format to Australian (could this cause the issue)

I did not have this issue in version 1.5.5e

Is this an issue with the latest version of zencart?

Outdoorking
Live Site https://www.outdoorking.com.au

2 Nov 2023, 11:14 AM
#2
mprough avatar

mprough

Totally Zenned

Join Date:
Nov 2007
Location:
Woodbine, Georgia, United States
Posts:
4,305
Plugin Contributions:
39

Re: Salemaker Start and Finsh Date

Bruce1952:

Server Information:
Server Host: outdoorking.com (172.105.167.154)
Database: outdoorking_xxxx
Home: /home/xxx/public_html/xxx/Server OS: Linux 3.10.0-1062.12.1.el7.x86_64
Server Date: 31/10/2023 09:16:50
Server Up Time: Disabled/UnavailableHTTP
Server: ApachePHP Version: 7.3.33 (Zend: 3.3.33)PHP File
Uploads: OnUpload Max Size: 1024M
PHP Memory Limit: 1024M
POST Max Size: 1024M
Database Engine: MySQL 5.7.44
Database Host: localhost (127.0.0.1)
Database Date: 31/10/2023 09:16:50
Database Data Size: 244,309 kBDatabase
Index Size: 41,430 kBMySQL Slow Query Log
Status: OffMySQL Slow Query
Log File: /var/lib/mysql/au-slow.logMySQL Mode: NO_ENGINE_SUBSTITUTION

Hi All,

I am running zencart 1.5.8a on a test server using the bootstrap template which is stated as the preferred template but I am having an issue with the Salemaker section.

  1. If I load a start date and end date the module does not activate
  2. If I remove the start date it activates and works
  3. We changed the date format to Australian (could this cause the issue)

I did not have this issue in version 1.5.5e

Is this an issue with the latest version of zencart?

Is the start date the same day as today? If starting immediately can leave start blank. Is it also occurring with future dates?

2 Nov 2023, 1:47 PM
#3
bruce1952 avatar

bruce1952

Totally Zenned

Join Date:
Aug 2008
Location:
Sydney Australia
Posts:
828
Plugin Contributions:
0

Re: Salemaker Start and Finsh Date

It does not work on future dates.

I did try to set the start date for two days earlier but when I updated it did not work either.

I just got this error message:
UPDATE salemaker_sales SET sale_name = 'CLEARANCE', sale_deduction_value = '20', sale_deduction_type = '1', sale_pricerange_from = '1', sale_pricerange_to = '700', sale_specials_condition = '0', sale_categories_selected = '2039', sale_categories_all = ',2039,', sale_date_start = '0001-01-01', sale_date_end = '20231109', sale_date_last_modified = now() WHERE sale_id = 24

Outdoorking
Live Site https://www.outdoorking.com.au

2 Nov 2023, 2:05 PM
#4
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,119
Plugin Contributions:
56

Re: Salemaker Start and Finsh Date

Bruce1952:

It does not work on future dates.

I did try to set the start date for two days earlier but when I updated it did not work either.

I just got this error message:
UPDATE salemaker_sales SET sale_name = 'CLEARANCE', sale_deduction_value = '20', sale_deduction_type = '1', sale_pricerange_from = '1', sale_pricerange_to = '700', sale_specials_condition = '0', sale_categories_selected = '2039', sale_categories_all = ',2039,', sale_date_start = '0001-01-01', sale_date_end = '20231109', sale_date_last_modified = now() WHERE sale_id = 24
Surely, there was more to that error message that indicates what the underlying issue is.:huh:

Just be sure to obfuscate the name of your admin directory when you post the full error-log, since that log will contain the admin-directory name.