Suljettu

Sql Syntax Error OSC

Hello,

I'm using Oscommerce 2.2 and our server provider updated the MySQL version and now I'm getting SQL syntax error from these these lines:

I really don't idea what is the problem, if anyone can help that would great :)

$inventory_query = "SELECT products_stock_id, products_id, products_stock_quantity , products_stock_reorder , products_stock_code FROM products_inventory WHERE products_id = ".$products_id." AND products_stock_code = ".$products_options['inventory_code']." group by products_stock_code order by products_stock_id asc";

Taidot: OSCommerce, PHP, SQL

Näytä lisää:

About the Employer:
( 8 reviews ) Budapest, Hungary

Projektin tunnus: #13168899

29 freelanceria on tarjonnut keskimäärin 7 $/tunti tähän työhön

coolguyinus2004

I know the solution for this fix as i am an oscommerce expert here. Hire me so i can fix this in minutes for you asap. 11+ years of experience in programming PHP/MYSQL/API/WEB SCRAPING/DEBUG EXPERT/ANY KIND OF FIX I Lisää

$8 USD / tunti
(337 arvostelua)
7.6
saiSoftIndia

I have read your requirements and think that I would be a great fit for this project, Ready to start

$8 USD / tunti
(473 arvostelua)
7.7
SunrisePHP

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

$5 USD / tunti
(657 arvostelua)
7.4
$5 USD / tunti
(108 arvostelua)
7.2
pytho

Hi, I am interested to work with you on this project, I reviewed the requests you listed and I would like to discuss further details with you. Since 2006 I am managing a Web Design Agency located in Romania, which cur Lisää

$15 USD / tunti
(39 arvostelua)
6.9
phpwebsoft

I have 8 years of experience in open source technologies PHP/MySQL. Below are some of the projects which I have done in oscommerce. http://www.eventdecordirect.com/catalog/ http://diviningmind.com/store/ http:// Lisää

$7 USD / tunti
(256 arvostelua)
6.9
webexpert0102

"HI, THIS IS webexpert0102. I WOULD LIKE TO WORK ON YOUR PROJECT" I am ready to start and I would like to discuss with you on this project. Please check my portfolio here: http://viwiz.com/webexpert0102-portfolio Lisää

$5 USD / tunti
(313 arvostelua)
7.1
rinkul123

Hi, I have more than 5 years of experience in working on professional websites and blog designs as well as on developments which consist of relevant skills like Wordpress, Joomla, Php, Html, Css, Js, SEO .I also hav Lisää

$5 USD / tunti
(47 arvostelua)
6.3
shreeyait

Hello Sir, Hope you are fine there. We are having good experience with CorePHP projects and the reason we came across here to give the best output to your project with supreme quality. We have develope Lisää

$13 USD / tunti
(55 arvostelua)
6.8
sat12

Hi, there seems problem in that query.i will fix it easily. I am osCommerce,wordpress,PHP programmer having 5 years of experience. I am very good in wordpress,php,mysql,joomla. Recently done these projects http:// Lisää

$6 USD / tunti
(289 arvostelua)
6.5
Danharrison

Hello, Thanks for the details -->We are one of best IT solution provider based in USA from last 5 years. We have some Query:- >Please share details of FTP,cPanel and Database,As well as API in details. >Plea Lisää

$5 USD / tunti
(2 arvostelua)
5.7
webmaestro2013

Dear Sir/Mam I will resolve mysql error very soon PLEASE HAVE A LOOK ABOUT MY RATING AND REVIEWS I will complete your job successfully. I have 10+ years experience in oscommerce I have done more jobs in os Lisää

$6 USD / tunti
(42 arvostelua)
5.6
openeratech

Hi, I Read Your Task requirement and understand you want to correct mysql error in osc site. Just share error detail Then I will do it more quickly as required. Invite me to discuss and done this work .

$6 USD / tunti
(45 arvostelua)
5.2
SourceBest

I am experienced in oscommerce for over 8 years. confident that i would fix it quickly. Thanks Balaji

$8 USD / tunti
(42 arvostelua)
5.3
engmalaa

A proposal has not yet been provided

$7 USD / tunti
(23 arvostelua)
4.7
$5 USD / tunti
(24 arvostelua)
4.8
jerry40

Hi! It seems that you need to rename "products_id" to "products_stock_id" in SELECT products_stock_id, products_id..... Good luck!

$22 USD / tunti
(18 arvostelua)
4.6
jagdishbhatt38

your syntax is incorrect ...where you are applying condition...

$7 USD / tunti
(15 arvostelua)
4.4
$4 USD / tunti
(21 arvostelua)
3.7
meganachunchu

Hi sir, Please review my profile and lets discuss about task and price, My price is negotiable I have eight experience in cms and frame works CMS(joomla,drupal,wordpress and concrete 7 ) Frame Works(CakePHP, Lisää

$5 USD / tunti
(4 arvostelua)
2.5