OSCommerce Order Problem

An order was recently placed on a website I work on. On the admin control panel the order says "Pending", but when you click on the pending orders it does not show up. If I type in the oID order number directly I get a syntax error:

**1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''CustomersName''' at line 1

select * from zones where zone_country_id = '176' and zone_name = '**CustomersName**''**

*******where customers name is the actual name of the customer.**

I need you to restore the data from the order, as well as fix this issue so it does not happen again. I would also like a detailed explanation as to what happened. I would like to get this done today, and I will be available for contact.

## Deliverables

The order must be restored (not including maxmind data if its not possible.)

You must stop this from happening again.

Provide an explanation as to what happened.

Any files you change backup the old ones by renaming them [url removed, login to view]

Any questions please ask.

Habilidades: Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website

Veja mais: line in problem, fix website restore error, php maxmind, php sql syntax error, backup sql mysql, 1064 php, customer name error, order number mysql, sql backup mysql, sql syntax error, work order management project php, php mysql 1064, mysql restore backup, sql select order, mysql sql syntax, sql problem, restored files, fix server error oscommerce orders, orders control oscommerce, sql syntax

Acerca do Empregador:
( 4 comentários ) United States

ID do Projeto: #3662123

Concedido a:


See private message.

$33.15 USD em 2 dias
(237 Comentários)

2 freelancers estão ofertando em média $38 para esse trabalho


See private message.

$42.5 USD in 2 dias
(13 Comentários)