GetAFreelancer.com
 
Find projectsSearch
Sign Up | Log in | Top Rated Users | Browse projects | Post Project | RSS feeds | Articles
 

1064 Error in CRE Loaded

   Click here to post similar project

1064 Error in CRE Loaded is project number 81902 posted at GetAFreelancer.com. Click here to post your own project.

Status: Closed (Selected Service Provider)
Selected Providers: selected service provider VladKuznetsov
Budget: $30-100
Created: 08/17/2006 at 21:09 EDT
Bidding Ends: 08/22/2006 at 21:09 EDT
Project Creator: zachthomas View PM Post PM
Buyer Rating: 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(2 reviews)
Description: I was changing some stuff in the admin section today, and in the “Configuration” panel I clicked on “Category/Display Products Order”. It then gave me 4 options to choose from in the right hand column, but when I tried to choose an option and update it, the “Category/Display Products Order” value was set to 0 and now I can’t change it. Now in the catalog side when a customer tries to click on anything in categories up comes this message:

"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 'limit 0, 15' at line 11

select p.products_image, p.products_model, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (products p left join specials_retail_prices s using(products_id) ) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '1' order by limit 0, 15"


I haven’t changed this value since getting the new CRE Loaded cart, so I assume it is problem that arose when the database was converted, but I don't know. I want someone who knows exactly what the problem is so I can get this resolved quickly.
Report violation
Job Type:
  • PHP
Database: MySQL
Operating system: Linux
Bid count: 1
Average bid: $ 30

 

Related project
 
Nonpublic project #366019 Featured Nonpublic
login to view
 

FREE Trial project for new buyers!

 

View Project Message Board     Post Message on Project Message Board
Messages Posted: 0

If you are the project creator or one of the bidders Log in as project creator or bidder for more options

Bid on This Project

Service Providers PMB Bid Delivery Within Time of Bid Provider Rating
VladKuznetsov
View PM Post PM
$ 30 0 days 08-17-2006 21:38 EDT 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(67 reviews)
Hello Sir. I can help you with your sql problem within right now. I'm available via GMail CHat, MSN or ICQ. Regards Zend Certified PHP Developer Vladimir Kuznetsov.
Bid on This Project

 

[ Join GAF Free ] [ Secure Forms ] [ Outsourcing Web Design ] [ EU Freelance ] [ View All Projects ]

What is GetAFreelancer.com? ( Read about the company )

Find freelance programmers, web designers, copywriters and translators. Deposit money and don't purchase until your project is completed. GetAFreelancer.com helps webmasters, web designers, programmers, software developers and business owners to develop their projects. We have thousands of satisfied clients around the world. Outsource projects and save a lot of money. Getting affordable freelance work, freelance programming and custom web design done for your website has never been easier. Our escrow feature is developed to protect both buyers and sellers.

Would you like to outsource your next project? Would you like to make money as a freelancer? Click Sign Up to start! Our site is global and we have freelancers from India, Romania, Russia, Ukraine, United States, UK and many other parts of the world. A freelancer is an independent worker, not on salary, hired instead on a project basis. It's easy, fun and very affordable to outsource your project with our site.

Find Webmaster Resources and Webmaster Forum. Take a look at Search Engine Submission.