I've inherited a swamp of an osCommerce installation...

[seansloan777]

Sorry for the repost, I had it in the wrong area:

 

I have inherited a site using osCommerce, www.vitalhemp.com that has some serious problems.

 

1. At first I didn't even recognize the site as even being osCommerce, it looked so different from any of the installations that I had done or ever seen. Has anyone seen an osC site like this and can you refer me to anyone/place that might have more info about such and installation?

 

2. The damn cart works, up to a point: it sends the order to osC and I can see it in the admin area but the order NEVER goes to PayPal even though I have the module installed and all the info right. I'm wondering if it ever worked. Where to even start looking? I did get the following error "Fatal error: Call to undefined function: tep_session_is_registered() in /home/vitalhem/public_html/checkout_success.php on line 16". And now it seems there is a MySQL problem, judging by the non appearance of pages when I go to the site and click on the links.

 

3. What would you all recommend? If I do a clean install it seem like I'll lose the "look and feel" that this unusual installation has succeeded in giving this guy. I don't feel like I know enough PHP to duplicate what has been done before me.

 

Thanks in advance, Sean

[Brown Knight]

dont reinstall, there is lots of custom work with the template. you need to learn how to read through the code and errors, the mysql error is you are missing siomething in the db.

for paypal, it all eepends upon how y ou have it setup, would need troubleshooting also.

[Iggy]

1054 - Unknown column 'p.products_id' in 'on clause'

 

This one is well known. Let me take a guess. This shop was running on mysql 4 but is now running on 5?

 

Google

 

Get thee to the updates and start your diff engine.

 

HTH,

Iggy

[jasonabc]

dont reinstall, there is lots of custom work with the template.

Tricky one. I have to say most of the time it's usually far easier/quicker to start again with a fresh install than trying to debug lots of crappy code. This is a fairly advanced template though so if you aren't that familiar with PHP, HTML, CSS etc it may take you as much time starting from scratch as trying to debug what has already been done.

[Iggy]

Tricky one. I have to say most of the time it's usually far easier/quicker to start again with a fresh install than trying to debug lots of crappy code. This is a fairly advanced template though so if you aren't that familiar with PHP, HTML, CSS etc it may take you as much time starting from scratch as trying to debug what has already been done.

 

These are sage words of advice.^^^^^^^

 

Iggy

[crash3903]

Your error resolved

[seansloan777]

Your error resolved

 

I appreciate all of the feedback/input/links and everything, it really means a lot to me in my hour of need. I feel like I have a handle on all to the topics, PHP, HTML and CSS but how those elements are working with osCommerce in my case is what's baffling me. www.vitalhemp.com

 

The index.html page links, where it calls the osC, calls the index.php page with a variable appended to the string (eg. ?cPath=1&osCsid=6f5409501faa0cbf661409a94ea92b1c ) . The session ID is obvious enough, it repeats, but the cPath value, I have no idea how they were determined or what I can do with in the limits, what the limits even are. This is where my understanding of how its integrated into osC is lacking. I have had zero luck in finding any references to this type of installation/use of osCommerce.

 

So, the story goes like this: IF I can fix the errors I'm getting and IF I can get it to send an order to PayPal I would then be faced with the limitations of this unorthodox use of osC. Thanks for the help and lending an ear, Sean

[♥Vger]

cPaths are Category numbers, created and stored in the database when products are added using the osCommerce admin panel.

 

If this website is hosted on an Apache server, not Windows, and Mod Rewrite is enabled then you may be able to install a small contribution called Ultimate SEO URL's, which will improve SEO and clean up the URL's for you.

 

I'd work with the exisitng store. It has a nice look to it.

 

Vger

[seansloan777]

Vger, thanks for the insight into the cPath/Categories, that goes a long way towards helping me understand and use them. I guess I will just need to look in the Categories section of the Admin area in order to determine the new cPath number or perhaps I can assume it will be the next number numerically.

 

Once I have things working, with help from a developer who works in osC all the time, I may look into the Ultimate SEO URL's, that seems like a logical way to go, thanks.

 

While I did not design the store I agree that it does have a nice look to it and i will do what I can to preserve that. The site owner will appreciate that as well.

 

Thanks again for taking the time to respond and for sharing your experience. Bye, Sean

 

cPaths are Category numbers, created and stored in the database when products are added using the osCommerce admin panel.

 

If this website is hosted on an Apache server, not Windows, and Mod Rewrite is enabled then you may be able to install a small contribution called Ultimate SEO URL's, which will improve SEO and clean up the URL's for you.

 

I'd work with the exisitng store. It has a nice look to it.

 

Vger