Magento 503 Error Fix

Budget $30 - $250 USD
Bids 13
Average Bid $192

My magento store is showing in google webmaster tools many links with this error, this error is showed as well in the subcategories that has sub sub categories, but it is basically the same error:
There has been an error processing your request
SQLSTATE[42000]: Syntax error or access violation: 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 ')' at line 1

Trace:
#0 /chroot/home/colombou/[url removed, login to view](300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /chroot/home/colombou/[url removed, login to view](468): Zend_Db_Statement->execute(Array)
#2 /chroot/home/colombou/[url removed, login to view](238): Zend_Db_Adapter_Abstract->query('SELECT `catalog...', Array)
#3 /chroot/home/colombou/[url removed, login to view](333): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `catalog...', Array)
#4 /chroot/home/colombou/[url removed, login to view](725): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 /chroot/home/colombou/[url removed, login to view](352): Zend_Db_Adapter_Abstract->fetchRow(Object(Varien_Db_Select))
#6 /chroot/home/colombou/[url removed, login to view](225): Mage_Core_Model_Mysql4_Abstract->load(Object(Mage_Catalog_Model_Category), Object(Mage_Catalog_Model_Category), NULL)
#7 /chroot/home/colombou/[url removed, login to view](49): Mage_Core_Model_Abstract->load(Object(Mage_Catalog_Model_Category))
#8 /chroot/home/colombou/[url removed, login to view](212): include('/chroot/home/co...')
#9 /chroot/home/colombou/[url removed, login to view](239): Mage_Core_Block_Template->fetchView('frontend/blank/...')
#10 /chroot/home/colombou/[url removed, login to view](253): Mage_Core_Block_Template->renderView()
#11 /chroot/home/colombou/[url removed, login to view](753): Mage_Core_Block_Template->_toHtml()
#12 /chroot/home/colombou/[url removed, login to view](43): Mage_Core_Block_Abstract->toHtml()
#13 /chroot/home/colombou/[url removed, login to view](753): Mage_Core_Block_Text_List->_toHtml()
#14 /chroot/home/colombou/[url removed, login to view](520): Mage_Core_Block_Abstract->toHtml()
#15 /chroot/home/colombou/[url removed, login to view](471): Mage_Core_Block_Abstract->_getChildHtml('left', true)
#16 /chroot/home/colombou/[url removed, login to view](40): Mage_Core_Block_Abstract->getChildHtml('left')
#17 /chroot/home/colombou/[url removed, login to view](212): include('/chroot/home/co...')
#18 /chroot/home/colombou/[url removed, login to view](239): Mage_Core_Block_Template->fetchView('frontend/blank/...')
#19 /chroot/home/colombou/[url removed, login to view](253): Mage_Core_Block_Template->renderView()
#20 /chroot/home/colombou/[url removed, login to view](753): Mage_Core_Block_Template->_toHtml()
#21 /chroot/home/colombou/[url removed, login to view](529): Mage_Core_Block_Abstract->toHtml()
#22 /chroot/home/colombou/[url removed, login to view](389): Mage_Core_Model_Layout->getOutput()
#23 /chroot/home/colombou/[url removed, login to view](115): Mage_Core_Controller_Varien_Action->renderL

Post a Project Like This

This project was awarded to

elchinillo

This job was completed in 1 day instead of 2. This developer has great communication skills, understands English and only contacted me by email 1 time to verify exactly how I wanted something done. I would recommend his services to anyone. He is a great asset to Freelancer.com. I just wish I could give 6 stars for this feedback. Exceptional job!!
About the Freelancer
elchinillo Profile Picture

Strong knowledge of: + PHP --- CakePHP + Python --- Django + Java --- Struts 2 + JavaScript --- jQuery --- Dojo --- ExtJS + eCommerce --- osCommerce + Ajax + Comet + HTML + XML + XSL + MySQL + SQLite

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • CoVaLiDiTy Profile Picture

    CoVaLiDiTy

    Ternopil,  Ukraine

    Interests and Knowledges (in order of my interest from High to Low). OS: Unix, FreeBSD/OpenBSD/NetBSD, Solaris, OpenSolaris, Plan9, Linux, W!nd@ws DB: PostgreSQL, Oracle, BerkleyDB, JavaDB, Mysql Lang: Java, Perl/Python/Ruby/Tcl/Tk, C/C++ Java TEch: Mobile/Enterprise/other SysTech: security, broadcast, base services (dns:bind,poverdns, mail:qmail,sendmail,postfix, www: apache, lighthttp, tomcat, globule, firewall:pf, ipfw, pfw, etc, control panel: webmin/virtualmin, plesk, ispadmin, cpanel, vtonf, postfixadmin, geo: geobackend for dns, load balancers, etc) Parallel and Virtualization: Xen, OpenVZ, other VoIP: asterisk, vicidial, codecs, other Scripts: Any RubyOnRails, PhP based Carts: Magento, ZenCArt, Creloaded, X-cart, Oscommerce Additional. Like to dig the code and find weak/buggy things and fix them;-)

    Graphic Design, Linux, AJAX, and CSS

  • elchinillo Profile Picture

    elchinillo

    Morelia,  Mexico

    Strong knowledge of: + PHP --- CakePHP + Python --- Django + Java --- Struts 2 + JavaScript --- jQuery --- Dojo --- ExtJS + eCommerce --- osCommerce + Ajax + Comet + HTML + XML + XSL + MySQL + SQLite

    PHP, Java, Javascript, and Python

  • brycep Profile Picture

    brycep

    Uttarpara,  India

    Greetings! The best place on Earth where you come looking for Web Development and Design is FREELANCER.com. And at Freelancer.com, we create websites and graphics, skill games and a full range of casino- and mini games with the strongest confidence! Check out our 5-star client feedback for yourself. I need not say much, but our work shall speak for itself. OUR SERVICES ---------------------------------------------- * WebBand * Web Services ---------------------------------------------- 1. Simple Websites (Static or Informational) 2. Ecommerce Website / OSCommerce / Portal Development 3. Responsive Website 4. 2D and 3D Game for Android and Iphone 5. Mobile Apps 6. Web Programming, Web Updations and Web Integration (eg. Paypal Integration) 7. API/XML/SOAP Integration 8. HTML Email Design / Emailer & Sales Page Creation 9. Search Engine Optimization 10. Online Forms & Database Integration 11. Usability & Interface Design 12. Web Design & Development 13. Hi-Fi Low Cost Web Hosting 12. Domain Name Registration ----------------------------------------------------------- * WebBand * Graphics & Art ----------------------------------------------------------- 1. Logo Designing & Development(Textual, Symbolic, Graphical) 2. C.I.P (Corporate Identity Package) 3. Business Cards & Letterheads 4. Web Site Template Design 5. Illustration (Sketches & Coloration - Baby, Cartoons, Realistic, Futuristic) 7. Banner Ads (Static & Animated) 8. Print Ads 9. Photo Retouching 10. Package & Product Design 11. Page & Book Layout 12. Brochures 13. Billboards & Signage 14. Catalogs / Menus 15. Direct Mailer Design 16. 3D Modelling ------------------------------------------------------ * WebBand * Multimedia Services ------------------------------------------------------ 1.Flash/ CD Presentations 2. Animated Web/ CD Intros 3. Animated Website Headers & Banners 4. Flash Cartoon Animation ( eg. ECards )

    PHP, .NET, Mobile Phone, and Shopping Carts

  • vniteam Profile Picture

    vniteam

    Thai Nguyen,  Vietnam

    Programming is my passion, Magento is my favorite platform and quality and customer happiness is my success.

    Javascript, XML, Website Design, and Graphic Design

  • utsavsab Profile Picture

    utsavsab

    India,  India

    I have written worlds fastest web crawler.. . I am a professional working for worlds biggest companies in the field of web crawling / scrapping etc. I am the administrator of pycurl, worlds best python web crawling framework

    PHP, Python, System Admin, and Linux

  • designcreative1 Profile Picture

    designcreative1

    Lucknow,  India

    We have been delivering quality tech solutions since last 12 years and have more than 2000 satisfied clients in almost every part of the world. We are expert in developing customized / bespoke application for mobile, web and cloud platforms. We have developed tech solutions for industries like Hospitality, Consulting, Finance, Education, Automotive, Social, Entertainment, Health, Ecommerce, Gaming, Medical etc SERVICE HIGHLIGHTS ====== - Custom building large scale, complex, high traffic applications for mobile, cloud and web - Expert team in PHP5, cakePHP, HTML 5, CSS3, Bootstrap, jQuery, XML, API, Magento, Drupal, Joomla, Wordpress, Objective C, iOS, Android, PhoneGap, Ionic, Node.js, Odoo, OrangeHRM, MySQL, MongoDB, Python, Hadoop, Apache Spark - Consulting & customization of popular CRM, ERP, HRM solutions - Available to provide technical support & maintenance after project gets completed - Experienced System Admins to setup, migrate, install, secure, troubleshoot Servers

    PHP, ASP, C Programming, and Java

  • souravdev Profile Picture

    souravdev

    Kolkata,  India

    We are a group of freelancers are capable enough to deliver you the best.We all are having exposure of 3-4 years in various domains of web technology.

    PHP, Javascript, AJAX, and Wordpress

  • JansenCorp Profile Picture

    JansenCorp

    Gloucester,  United Kingdom

    I am a Web Designer and Developer with over 16 years' experience in my profession, 10 years of which I have been involved predominantly with Joomla!, Drupal and Word Press for Brochure Sites and Magento, PrestaShop and CRE loaded for Shopping Sites as well as Bespoke Builds.

    PHP, Graphic Design, Magento, and Branding

  • iclicknetwork Profile Picture

    iclicknetwork

    HCMC,  Vietnam

    Hi, Magento guru is here, i work and bid only in magento task, so please have a fair compare on reviews number, looking for long term work with magento, i can start work immediately, daily report working progress by email, skype.. No modified core files even in espacial case, 100% compatible with magento convention. Free conflict on next magento updates list of latest magento project i've done: http://elit.no/ http://www.soundgarden.no/ http://interiorkupp.no/ http://www.bixbyandball.com http://www.blueskyfun.com/ (Magento Enterprise) http://www.ewell.com.au/ http://mywineaffair.com/ (Multiple store based on Magento Pro ) http://www.asiawinesociety.com/ http://dirtbag.biz/ http://coolest-gadgets-shop.com/ http://listpornhd.com/ (Porn site) http://taw9eel.com http://phimsac.net/ http://tattoo-bodysuits.com/ http://www.sneakertraffic.com/ So i think this job will be solved soon and smooth. If you feel interest, please PM for full list of magento jobs i've done, OR simply we can go straight to talk how to start your project list detail of lastest magento projects: - http://elit.no + Create quote/order feature on checkout step + Multiple store view, product have different price on different store view + - http://www.soundgarden.no/ + Create CRESCO payment gateway and integrate it into Magento + Customize shipping method + Update product price and stock via a remote webservice + Customize product gallery and product detail view - http://interiorkupp.no/ + Develope shipping method based on product shipping setting: package / roll / unit per package/roll etc... + Update product price and stock via a remote webservice + Customize product gallery and product detail view -http://www.blueskyfun.com/ (Magento Enterprise) + Build extension amazon fulfillment service for magento + Build extension allow and calculate shipping methods from amazon full fillment service + Customize product themes, install gallery extension + Customize new cart promotion rule to work with specific coupon codes - http://mywineaffair.com/ (Multiple stores based on Magento Pro): - http://www.asiawinesociety.com.sg (sub website) + Private sales with special price for customer + Invited customer only + Integrate calendar event for special events/campaign + New system price based on customer group (Membership / Normal customer) http://listpornhd.com/ - Auto import product script - over 3000 products video - Improve magento speed http://coolest-gadgets-shop.com/ - Multiple product currency - Over 2000 products in phone accessory and hightech stuff - Extension installed: Ajax add to cart - http://deb.iclicknetwork.com/home.html + Design the site + Integrate new design to magento + Customize product properties (3 properties can be filtered in left navigator block ) + Customize price list (Must login to see price) + Multi tier prices for product + Setup promotions: Add new catalog price rules + Huge import product (1014 products in 6 categories) + Customize left shoping navigator + Setup Payment gateway (Google Checkout, Paypal Bussiness pro, Purchase order) + Setup Shipping rule (shipping cost based on weight of cart items), and Shipping methods (DHL, USPS) + Customize order email templates - http://dirtbag.biz/ + Intergrated new theme design to magento + Customized the one page checkout (Add alternative shipping address in some specific cases, ) + Developed new Payment gateway for magento (TCLLink) + Developed product export feature in backend with speacial requires. + Setuped product tax + Setuped promotions: Add new catalog price rules + Customize shipping rules (shipping cost based on weight of cart items and free in some specific cases) + Setup Shipping methods + Customize order email templates

    PHP, Java, Javascript, and XML

  • zhaojc Profile Picture

    zhaojc

    peking,  China

    i am a magento developer and from china.hope you can enjoy my service.

    Website Design, and Magento