Find Jobs
Hire Freelancers

SQL Error in X-Cart & Can't login to backend of X-Cart

$30-250 USD

In Progress
Posted almost 14 years ago

$30-250 USD

Paid on delivery
I have been getting emails from my X-Cart site like this "Date : 08-Jun-2010 10:43:51 Site : http://www..[login to view URL] Request URI : /[login to view URL] Remote IP : [login to view URL] Logged as : SQL query : SELECT * FROM xcart_products_lng WHERE code='US' AND productid=16361 union select count(*),1,2,concat((select login from xcart_customers where usertype=0x50 limit 1),floor(rand(0)*2)) x from xcart_customers group by x Error code : 1222 Description : The used SELECT statements have a different number of columns Backtrace : /home/physical/public_html/include/[login to view URL] /home/physical/public_html/include/[login to view URL] /home/physical/public_html/include/[login to view URL] /home/physical/public_html/include/[login to view URL] /home/physical/public_html/include/[login to view URL] /home/physical/public_html/[login to view URL] " "Date : 23-May-2010 07:34:40 Site : http://www..[login to view URL] Request URI : /[login to view URL] Remote IP : [login to view URL] Logged as : SQL query : SELECT * FROM xcart_products_lng WHERE code='US' AND productid=16361 union select count(*),1,2,3,concat((select login from xcart_customers where usertype=0x50 limit 1),floor(rand(0)*2)) x from xcart_customers group by x Error code : 1062 Description : Duplicate entry 'master1' for key 1 Backtrace : /home/physical/public_html/include/[login to view URL] /home/physical/public_html/include/[login to view URL] /home/physical/public_html/include/[login to view URL] /home/physical/public_html/include/[login to view URL] /home/physical/public_html/include/[login to view URL] /home/physical/public_html/[login to view URL] " Also when I try and login to the /admin part of the site the screen is just blank and no login screen. Orders are still coming through the website as normal. I need this fixed ASAP. I have replaced my domain with above.
Project ID: 718224

About the project

4 proposals
Remote project
Active 14 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
quick fix, ready to start.
$50 USD in 0 day
5.0 (3 reviews)
3.2
3.2
4 freelancers are bidding on average $80 USD for this job
User Avatar
We have good hands at xcart.
$101 USD in 1 day
4.8 (53 reviews)
8.0
8.0
User Avatar
Mysql/Xcart professional, ready to start
$100 USD in 1 day
4.9 (3 reviews)
4.1
4.1
User Avatar
Hi I'm Gregory. I'm a L/WAMP Hosting specialist. I would like to further discouse this error with you to best understand how to resolve this .
$70 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Miranda, Australia
5.0
6
Member since Nov 28, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.