Strange problem with zen cart - Admin preview problems after Access db load

[ExceedIT]

I am having a very strange probem with Zen cart.

The problem is that with some products, when I edit them and then click Preview (to save) the site takes me to the homepage of my shoppping site (rather then the preview confirmation page as it should).

Ths only happens with some products - particularly older ones - and we believe it was due to someone trying to connect to the database using an access database (No idea why but no other potential trigger is known).

This problem is puzzeling in itself - but the real puzzel is if I tell the PHP page to exit on load (while i try to debug) the system still redirects to the home page where this problem is happening. I.e. a different page is served in response to the POST request then the one that is supposed t be with no in page redirect.

Do you Have you got any suggestions for either problem?

Thanks,

Shlom Solomon

[DrByte]

A few questions ...
- do you have any FORMs in your product descriptions?
- do you have any HTML code other than markup related to appearances?
- are there any images embedded in your prod-description HTML?
- what version of Zen Cart?
- what addons have you installed?
- what kinds of customizations have you made to your site?
- what is the URL saying when you get redirected? Does it flicker to something else briefly? if so, what?

[ExceedIT]

A few questions ...
- do you have any FORMs in your product descriptions?
- do you have any HTML code other than markup related to appearances?
- are there any images embedded in your prod-description HTML?
- what version of Zen Cart?
- what addons have you installed?
- what kinds of customizations have you made to your site?
- what is the URL saying when you get redirected? Does it flicker to something else briefly? if so, what?

Hi,

Thanks for helping with this. Taking your points in turn

1) No other content in the forms other then plain text and standard appearance markup - everything was ok to start with until the Access incident

2) No images embedded - its all very simple

3) Zen cart 1.3.7

4) No addons (as far as I know)

5) No customisations at all - problems started when I tried to access DB via Access database but other then that all code has not been touched (other then to try and debug this issue as mentioned)

6) It starts to load the correct URL (i.e. admin/products.php etc) then suddenly changes to the homepage as if a redirect has been triggered - as mentioned I have tried to terminate on teh first line of products.php but this still happens

[stage]

I am having a very strange probem with Zen cart.

The problem is that with some products, when I edit them and then click Preview (to save) the site takes me to the homepage of my shoppping site (rather then the preview confirmation page as it should).

Ths only happens with some products - particularly older ones - and we believe it was due to someone trying to connect to the database using an access database (No idea why but no other potential trigger is known).

This problem is puzzeling in itself - but the real puzzel is if I tell the PHP page to exit on load (while i try to debug) the system still redirects to the home page where this problem is happening. I.e. a different page is served in response to the POST request then the one that is supposed t be with no in page redirect.

Do you Have you got any suggestions for either problem?

Thanks,

Shlom Solomon

It sure sounds as if you have some database corruption going on. I would start there, poke around a little and see if something looks out of place. Do you have any type of URL rewriting going on? LIke the Ultimate SEO's, I haven't myself used that particular mod, but with other systems I've used code rewriting types of tools and when there was a glitch, it caused the same sort of problem you are describing.

What happens when you click on the products in question from the front end?

stage

[ExceedIT]

It sure sounds as if you have some database corruption going on. I would start there, poke around a little and see if something looks out of place. Do you have any type of URL rewriting going on? LIke the Ultimate SEO's, I haven't myself used that particular mod, but with other systems I've used code rewriting types of tools and when there was a glitch, it caused the same sort of problem you are describing.

What happens when you click on the products in question from the front end?

stage

What do you mean by URL rewriting and ultimate SEO's

I am also inclined to think its something to do with the DB but I cannot imagine what given the strange redirection even out of the script - the whole redirection symptoms is very strange for a database probelm.

I have tried repairing some tables in phpmyadmin to see if it helps but no joy.

[ExceedIT]

PS: with regard to the databse - I have tried recreating the database by creating a new one and copying all the data using SQL and the problem remains - i.e. adding new products fine, old products redirect to homepage.

[DrByte]

In your product descriptions, are there any embedded URLs or images or other HTML that might be confusing things?
Is there any embedded PHP code?

Admin->Configuration->My Store->Missing Page Check ... what is this set to? If you turn it Off, what happens differently?

[ExceedIT]

In your product descriptions, are there any embedded URLs or images or other HTML that might be confusing things?
Is there any embedded PHP code?

Admin->Configuration->My Store->Missing Page Check ... what is this set to? If you turn it Off, what happens differently?

I tried what you said - the option is set to "Page cannot be found" and when I change it to Off then it makes no difference at all - still redirects to homepage

[DrByte]

This is a lengthy process, but it's where I'd recommend checking things out ... it may or may not reveal anything. It'd be good if you are able to include your .htaccess files in your download.
http://www.zen-cart.com/wiki/index.p...Obscure_Issues

[ExceedIT]

This is a lengthy process, but it's where I'd recommend checking things out ... it may or may not reveal anything. It'd be good if you are able to include your .htaccess files in your download.
http://www.zen-cart.com/wiki/index.p...Obscure_Issues

Ok I am not exactly sure what the problem is but I have tried copying everything to another server and it works fine.

I dont know if this is because .htaccess files did not copy or what but now I am going to try deleting everything and reuploading and if there is still a problem then just use the other server.

Thanks you very much for your help Dr Byte - I suggest anyone who has this problem try the above.