Can I close the store for maintenance... from the database?

[jenpen]

Hello,
Interesting one, this.
Our admin has disappeared - all I'm getting in the installation screen - although the store is still up and appears to be working fine. I can see that admin/includes/configure.php has lost all its connection details, but when I correct them, the file reverts to "localhost" etc upon saving.
So I want to back up the files and database so I can reinstall, but first I need to close the store for maintenance. Can I do this from the database in phpMyadmin?

[Design75]

When you save your confiure.php to the server. did you remember to make it writeable (664 or 666) first? Otherwise your changes will not be saved on the server.

[RodG]

but first I need to close the store for maintenance. Can I do this from the database in phpMyadmin?

Yes. Run the following SQL command

UPDATE configuration set configuration_value = 'true' where configuration_key = 'DOWN_FOR_MAINTENANCE';

Cheers
Rod

[jenpen]

Thanks Design75 but yes, it was writeable. My changes disappear upon Save. But thanks RodG, that exactly what I need.

[jenpen]

Guys, I exported the DB, reinstalled ZC and have just tried to import the DB. But I'm getting:
Error

SQL query:

--
-- Dumping data for table `address_format`
--
INSERT INTO `address_format` ( `address_format_id` , `address_format` , `address_summary` )
VALUES ( 1, '$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country', '$city / $country' ) , ( 2, '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country', '$city, $state / $country' ) , ( 3, '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country', '$state / $country' ) , ( 4, '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country' ) , ( 5, '$firstname $lastname$cr$streets$cr$postcode $city$cr$country', '$city / $country' ) , ( 6, '$firstname $lastname$cr$streets$cr$city$cr$state$cr$postcode$cr$country', '$postcode / $country' ) ;

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 1

What to do?

[jenpen]

I just tried the same import again. This time it's giving the same error message but there are real names and addresses in the data.

[jenpen]

I'm stuck here, so if anyone can cast some light, please don't hold back

[RodG]

I'm stuck here, so if anyone can cast some light, please don't hold back

Option1: Delete the data from the table before trying to import new data.
Option2: Assuming the data that already exists in the table is valid, then simply ignore this error.

Oh, there should *not* be real names in the import data. The data contains variable names only.

Cheers
Rod

[jenpen]

RodG, excuse this phpMyadmin amateur, but I am having trouble deleting the whole database. I know the SQL for deleting from a table, so I'm trying to use that, ie delete from 'prefix_databasename'. But I get a syntax error. I guess I could delete each table one by one, but trying to avoid that.

[DrByte]

You're supposed to "Include DROP/CREATE TABLE IF EXISTS" support when you're doing your backup. See: http://www.zen-cart.com/content.php?...atabase-backup

If you didn't do that, then you'll need to "drop" all your normal Zen Cart tables before you can import data back into them. Hopefully your backup at least includes "CREATE TABLE" statements. If not, then you'll be an even bigger pickle.