Several oscommerce issues to fix: -------------------------- ONE: catalog/shopping [url removed, login to view] When using QTPro contribution 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 ') and language_id= '1' order by products_options_id' at line...
I hired you 7 months ago to fix some errors in an existing installation of oscommerce and was very pleased with the work that you did. The website was www.realmessiah.name. Everything has been working since then until out of the blue I tried changing the prices on products today in myadmin and the gross price which is supposed to update automatically
...a "1064 - You have an error in your SQL syntax..." error when attempting to access the discount add-on from admin back end. The error started when my webhost upgraded from MySQL 4 to 5. The discount add-on has a global discount and a product discount. This should be an easy fix if you are proficient in MySQL and osCommerce. Upon accepta...
I have an existing, heavily modified oscommerce shop and am looking for the following: 1) Fix a small problem with Google Checkout. When an order is updated, I get the following error message: 1146 - Table 'retropolitan.google_orders' doesn't exist select google_order_number from google_orders where orders_id= 119 [TEP STOP] This should
I am having compatibility issues with oscommerce site and the database server SQL 5 vs. the site being set up for SQL4. I am looking for a developer who has experience with this issue and quickly add the fixes needed. I moved my older OScommerce website with a lot of modifications and updates to a new dedicated server at siteground.com. Support at
...Having trouble passing my PCI compliance with my OSCommerce website. I have an SQL injection issue and haven't a clue how to fix it. Probably a very simple problem for someone who has done it or is familiar. See below for error from Security Metrics (PCI compliance company): > Description: Script allows SQL injection (gCards) Severity: Critical &...
I have an osCommerce site that has been running for almost 3 years. About 6 months ago I had an SQL injection and found a guy who repaired the problem but since then there has been an error message every time a customer uses a discount code in conjunction with Paypal. The guy that created this problem can't fix it. The error message is: 0 -
I have a webstore with oscommerce installed. I tried to install [url removed, login to view],1339/category,5/search,members which is a contribution to delay the process of becoming a site member until approved in the back end. I installed the sql no problem but now when i go back to test it and create a new user to test it with
...following mod; [url removed, login to view] Installed onto our oScommerce site. Normally we would do this ourselves, but one of the first steps in the install instructions call for inputting some .SQL code, which gives us an error. IF YOU DO NOT KNOW ENOUGH ABOUT .SQL TO FIX THIS PROBLEM, PLEASE DO NOT BID. This is an urgent project that we
getting this error on my creloaded / oscommerce website first 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 'and g.admin_groups_id=' at line 1 select a.admin_id, a.admin_firstname, a.admin_lastname, a.admin_email_address, a.admin_created,
Fix error in Openfreeway Oscommerce Ecommerce Shop When Using easy populate in the adin section the following error occurs: Regardless if the products_image field exsists in the csv file Regardless if the products_image is changed to products_image_1 or even removed completely. No Products Will Import, But Categories will 1054 - Unknown column
...need an urgent fix doing to our heavily modified oscommerce cart. We have installed this contribution 'Get 1 Free' [url removed, login to view] It all works fine apart from a bug on the shopping cart page. If we try to either: a) remove a product from the cart or b) change the qty in the cart this error occurs Warning:
Hello. I have an adult sex toy website which is a cre loaded/oscommerce shopping cart. Daily i am getting 1000's of hits from targetted PPC programmes but none of them seam to be converting! I have had a few that have converted but somewhere on my site is a huge problem. What i require someone to do is identify why the users are not converting to sales
I have a heavily modified osCommerce shopping cart which has a new bug after transporting to mySQL5 database. In the osCommerce admin, when trying to backup the database, then to restore, I will get the following error. The .sql being generated by the script is causing the error, but if I knew for sure, I wouldn't be here now would I? 1067 - Invalid
I have a new Oscommerce installation. The site is up and running but I have three problems, probably all related. I think they are tiny small but for me to find a solution is likely uneconomic. Issue (1) I have the following error message on my main admin panel: Error: Catalog images directory does not exist: /home/*******/public_html/images/ Issue
I am a beginner trying to set up an online store using oscommerce. My site is up and online, but it gets errors. The error is:1054 . This seems to be a compatibility issue with php4 and php5. The site that I bought the template from is no help at all. I am asking for a bid to solve the 1054 errors. You may see the complete errors by going to <http://www
...(simlar to oscommerce) only to find that it is not compatable with the current version of mySQL running on the server. Problem: MySQL 5.0 introduces Server SQL modes as part of its SQL 2003 standards support, and uses a more stricter approach to executing SQL queries. This is performed by default with setting STRICT_TRANS_TABLES as a Server SQL mode
Immediate need to fix this 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 'ORDER BY p.products_price' at line 1 SELECT DISTINCT (p.products_id), pd.products_name, products_image, p.products_bimage, p.products_price, p.products_date_available, p.products_free_sh...
i have a oscommerce site, right now there are an error coming up on a few pages. admin- orders - pending, processing, shipped, cancel, - these all have a error of "1064 error in SQL syntax" admin- catalog - manufacture, review, special, and product expected - all have a error of "1064 error in SQL syntax" ...
...strange error when my site loads up in the featured products section and and new products box in the column_right field. I am experienced in oscommerce and i just cant seem to figure it out. Also after some editing my pictures dont show up for the products i added. I dont mind paying upto $20 for someone to spend 5-10 min to tell me the error and the