X-Cart forums

[campi54]

Hi,
We recently changed host and got everything running perfect. Last night I was cleaning up in the image location and when I checked the site all of my images for the site dissappeared. But all of the product images are in tact. (I know, I should have left it alone, but I didn't)
Basically it looks like we lost the skin.

When I changed back to the original path I got this error:

"INVALID SQL: 1064 : You have an error in your SQL syntax;Check the manuaal that corresponds to yourMySQL server version for the right syntax to use"at line 1

SQL QUERY FAILURE:SELECT COUNT(*)FROM"

All images were originally in the database not FS.

here is what it looks like at www.caltape.com

Any help appreciated.

[balinor]

What do you mean by 'cleaning up in the image location'?

It looks like either your database is specified incorrectly in config.php, or the site path itself.

[campi54]

I knew you were going to ask me that. I'm one of those kind of people that can't leave things alone. OK? There I admitted it. lol

I changed the path to the images because it didn't look right. errrr. The the script prior to the mishap, was correct. I can't see that the config.php got tweaked in the process.

If I change that I am afraid I will really muck up the works. This just happend when i changed the "Path to images on the local server"

[balinor]

But you changed the path in General settings/Images Location or in config.php? If config.php, what did you use to edit the file with?

[campi54]

Well here's where it gets weird. I changed it in the "General settings/Images Location" but that should only affect the images in the FS. Correct?
I had everthing in the Database.

Could it be a concidental thing that was probably going to happen anyway and changing the path had nothing to do with it? And, if the files for the tumbnails etc were in the db, how come they are still present but the skin images are gone?

[balinor]

It shouldn't have anything to do wtih the images location. Are there any other files you 'cleaned up'?

[campi54]

Ahhh balinor,

Stupid me stupid me. It was a considence. Can you say .htaccess.

Here is what I had in my public_html (a short list)

Options -Indexes
DirectoryIndex index.php

# block access to /skin1_original
Redirect gone /skin1_original

This is what I have now in the pertaining files as long as there are no php files.

<Limit GET POST>
# "None","All","Indexes","Includes","FollowSymLinks" ,"ExecCGI","MultiViews"

Options none

</Limit>

Talk about your everyday considence.

Thanks for taking the time.