Site maintenance fix

[razz2]

Well the site maintenance is showing:

The Admin / Webmaster has enabled maintenance at : TEXT_DATE_TIME

I found the post that it could be a missing file or record in MySQL. It did not mention what to add though. The TEXT_DATE_TIME record did not exist. Here's the thing. It is a fresh install of oscmax 1.7 and aside from a few things it is working great in development except for this and a voucher issue mentioned in another post. The question is what settings should use if I add the record to MySQL?

I set the configuration_id to: 391
The title to: when webmaster enabled maintenance
The key to: TEXT_DATE_TIME
The value to: NOW
The description to: Display when webmaster has enabled maintenance
The configuration_group_id to: 16
The sort_order to: 14

I added it, and it will pull the configuration_value, but the value is static. Where is the code that is supposed to update the record when I turn the feature on?

As always, I thank you all ahead of time for any help,

razz

[razz2]

Well, I looked everywhere for the code that is supposed to set the TEXT_DATE_TIME value and could not find it. I have seen other posts about this and someone mentioned missing a MySQL record. I looked for the record and the code that would update the date/time in that record when you enable the site maintenance feature. I found no code to do that so I wrote some.

If you are getting this display when you enable the feature:

The Admin / Webmaster has enabled maintenance at : TEXT_DATE_TIME

Then here is the fix.

Find the file:

/catalog/admin/configuration.php

Find this code (lines 26 and 27):

tep_db_query("update " . TABLE_CONFIGURATION . " set configuration_value = 'false', last_modified = '" . NOW . "' where configuration_key = 'WARN_BEFORE_DOWN_FOR_MAINTENANCE'"); }

tep_redirect(tep_href_link(FILENAME_CONFIGURATION, 'gID=' . $HTTP_GET_VARS['gID'] . '&cID=' . $cID));


Insert this code between them (I am on my Mac at the moment so if the line breaks fail just let me know and I will re-post from the PC):

// Insert these two lines to fix setting start time
// Requires adding a record to the MySQL Configuration Table
// I used
// configuration_id = 391
// configuration_title = when webmaster enabled maintenance
// configuration_key = TEXT_DATE_TIME
// configuration_value = (set by this code)
// configuration_desription = Display when webmaster has enabled maintenance
// configuration_group_id = 16
// sort_order = 14

// Set time of maintenance start

if ( $cID == 378 ) {
tep_db_query("update " . TABLE_CONFIGURATION . " set configuration_value = now(), last_modified = now() where configuration_key = 'TEXT_DATE_TIME'"); }

//End of Set time of maintenance start

razz