Optimize Oscommerce Checkout

Closed

I have a heavily modified oscommerce MS2+ website where the host just moved it to a new server.

It worked fine for about 2 years on the old server but on the new server I keep getting a 2006 - MySQL server has gone away error on the following page: [url removed, login to view]

It usually only seems to happen when someone checks out using a credit card. I will receive a payment but also receive the database error(s) so the order is not written to the website. Then I have to hassle with figuring out what they ordered and send an email telling them about the problem and asking them to verify what they ordered and where they want it shipped. Then I have to manually enter their order choosing money order so I have a record of the order. As you can see, this is getting to be a headache after only about a week so I need it fixed ASAP.

The credit card module I am using is PayPal Website Payments Pro (US) Direct Payments

[url removed, login to view],22

There is also the following database error at the same time:

select count(*) as total from sessions where sesskey = 'b1f840e0351ee36012174c80' (session number changed for obvious reasons)

I did get the error once when someone checked out using Paypal. Here is the error that came from the following file:

[url removed, login to view]

2006 - MySQL server has gone away

select txn_id from paypal where txn_id = '0J9588732C553645K' limit 1

[TEP STOP]

I have code on the website that redirects my customer to the home page instead of displaying the error and the code sends me emails with the error message and the URL info. This is how I see the error messages.

Since the site is on shared hosting and the host does not want to increase the time allowed for the [url removed, login to view] file to process and I understand it is doing a lot of stuff...I am wondering if the file could be optimized to make it process faster?

I have another website hosted somewhere else that runs slower but I was comparing some server settings and noticed that the slower website has mysql.connect_timeout set at 30 and the website I am having problems with on the [url removed, login to view] has the mysql.connect_timeout set at 20.

I do have a [url removed, login to view] file but am not sure if their system lets you override their standard server settings. In other words I am not sure if my [url removed, login to view] file is doing anything or if something needs to be added to the .htaccess file to make it work?

-------------

I know the [url removed, login to view] file is doing a lot of things and am wondering if the database queries can be optimized or the file optimized to run faster and not time out?

I have thought about the one page checkout contribution but don't know if that would help or not.

This website has had auctionblox added and I know it is mixed up in the checkout too but don't know how to remove it since I no longer use auctionblox.

-------------------

Ultimately, I need the checkout page(s) optimized so the website does not get the MySQL timeout.

I will need this done on 2 similar websites hosted at the same place. One of the sites is fairly busy so I would prefer to have a test site made before moving the changed files to the live site.

Skills: MySQL, OSCommerce, PHP, Web Hosting

See more: work from home reasons, where is my money in paypal, reasons to work from home, need gone asap, how does work at home work, what is paypal and how does it work, verify credit card number, using paypal to receive money, paypal how to receive money, paypal how does it work, ipn number, how to use paypal to receive money, how to set up paypal to receive money, how to remove a card from paypal, how to receive money using paypal, how do credit card payments work, getting written up at work, getting money out of paypal, can you use paypal credit to send money, test a website asap 3, optimize mysql, one page checkout, new years card, checkout page, payment code oscommerce

Project ID: #5504095

Awarded to:

kagg

Hi, I have 12+ yrs. experience of osCommerce. I have already worked on hundreds of oscommerce websites including template integration, module installation and custom module development. I have contributed 3 payment More

$105 USD in 1 day
(294 Reviews)
8.0

8 freelancers are bidding on average $106 for this job

SunrisePHP

Hi, We have throughly read your requirements and believe that we can deliver exceptional results. We hope you will consider using our services. Kind Regards,

$126 USD in 4 days
(589 Reviews)
7.4
techwelfare

hi we could do it perfectly with accuracy, please let us know if you want any clarification. if you want us to share our skill and previous work please initiate the chat..

$81 USD in 1 day
(62 Reviews)
6.3
techmartsol

Hello, We have gone through the scope of work and would be happy to provide complete solution on this and future support also if required. Scope of work includes - - Optimizing OSC checkout page performance to b More

$98 USD in 3 days
(43 Reviews)
6.0
rsen75

hi, i'm 14+ experienced with strong knowledge of API integration for many CMS and e-Com see my few portfolio **WooCommerce Payment Plugins ccavenue wolrd / paypal pro /SEYLAN bank/libertyreserve/perfectmo More

$150 USD in 6 days
(43 Reviews)
5.5
yanotcook

I have completed these osc projects with excellent reviews: http://www.e-trade360.com.hk/download/Reviews_osc_131227.html ============================================ Have strong confidence, to solve your request wi More

$88 USD in 4 days
(49 Reviews)
5.3
jenzeerbasheer

cPanel certified expert here i can provide you one month support for 89 with unlimited admin hours, unlimited tickets 24x7 monitor etc Please have a look here http://iserversupport.com/on-demand/ I am Linux(red More

$88 USD in 1 day
(11 Reviews)
3.9
munjalmayank

Hi, Greetings! I am one of the best Freelancer in Wordpress / eCommerce (opencart) / HTML / CSS / Javascript. Do let us know your thoughts on the same.

$88 USD in 5 days
(17 Reviews)
3.5
otpisani1

Dear client, I can do a job for you 100 % sure. Possess many years experiance working with CMS apps like Wordpress, Drupal and OScommerce. I can made whole site including web developing/design, so if you nedd p More

$111 USD in 5 days
(0 Reviews)
0.0