index.php

[LeoSixtySix]

My hosting company performed some server restores over the weekend and now launching www.<domain>.com/index.php brings up the following.

*****
Not Found

The requested URL /zc_install/index.php was not found on this server.


Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

*****

I also noticed that www.<domain>.com/index.php now gets directed to www.<domain>.com/zc_install/index.php which apparently prompts the above error message. The MySQL database appears to be intact though.

I trust that I am missing a file somewhere but could use some assistance on where to look and what to look for. There is an index.php file in my public_html\ directory along with an index.html file which I'm using as a temporary "splash" page.

While I was building the site, I used to be able to explicitly go to www.<domain>.com/index.php just to review my progress.

Thanks in advance.

Arnold

[afo]

That's odd. Have you looked at the contents of the current index.php? Do you have a copy of your site on your local drive?

[Merlinpa1969]

looks like they trashed your configure.php files

[afo]

looks like they trashed your configure.php files

OUCH! If you have them backed up locally, you can just FTP them up to the site.

[LeoSixtySix]

Thanks to all who have responded. The configure.php file does appear to be corrupted but the MySQL database is still intact. I was still using 1.3.5 but do have a genuine interest to try 1.3.7 so perhaps this was meant to be.

I can obviously do a new install of 1.3.7 instead of overwriting 1.3.5 but was wondering about MySQL. (not sure if this is the right place to ask this question or if anyone can help me)

After I reinstall 1.3.7, can I just run the configuration to point to the existing database or do I need to create a new one and then just go through the exercise of exporting and importing from my previous database to the new one?

If the latter, I believe that SQL would be the preferred format for importing (though there are other formats for exporting) and if so, should I go after each of the 93 tables one at a time or can I just grab the entire store?

Any recommendations?

Thanks,
Arnold

[afo]

Installing 1.3.7 on your live site will destroy your db. You don't want that.

If you can restore the config files to get your site up and running for now, do that. You can then install 1.3.7 in a different directory (with its own db) and test it.

If not, use your webmaster panel to export your data and save it to your local drive. This should do the entire db in one step. Install 1.3.7 on the site (this will rebuild the db and destroy the existing data). Import the backup into the new db. That should do it.

Any other suggestions, Merlin?

[LeoSixtySix]

On the subject of exporting and importing...

1. Is this done through phpMyAdmin?
2. Any specific switches that I need to be aware of when exporting?
3. Importing only seems to accept SQL format. Is this correct or am I missing something?

The reason for these questions is that when I try to perform a SQL import, it returns the following...

*****

-- Table structure for table `address_book`
--
CREATE TABLE `address_book` ( `address_book_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`customers_id` int( 11 ) NOT NULL default '0',
`entry_gender` char( 1 ) NOT NULL default '',
`entry_company` varchar( 32 ) default NULL ,
`entry_firstname` varchar( 32 ) NOT NULL default '',
`entry_lastname` varchar( 32 ) NOT NULL default '',
`entry_street_address` varchar( 64 ) NOT NULL default '',
`entry_suburb` varchar( 32 ) default NULL ,
`entry_postcode` varchar( 10 ) NOT NULL default '',
`entry_city` varchar( 32 ) NOT NULL default '',
`entry_state` varchar( 32 ) default NULL ,
`entry_country_id` int( 11 ) NOT NULL default '0',
`entry_zone_id` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `address_book_id` ) ,
KEY `idx_address_book_customers_id_zen` ( `customers_id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =11;

MySQL said:
#1050 - Table 'address_book' already exists

*****


I was just wondering if I even exported the data correctly.

Thanks,
Arnold

[LeoSixtySix]

Please disregard my previous posting.

I found my answers at the following thread.

http://www.zen-cart.com/forum/faq.ph...yadmin_backups

Thanks again for everyone's help.

Arnold

[afo]

Good luck! Keep us posted! :)