I have a website that I recently migrated over. I have access to both the source (original place where the website was) and the destination (new website). When I migrated the website, I changed the domain name and web hosting, so servers are different.
Something broke along the way. The website is a listing website. All is ok, until I click on one of the listings, then I see the error below. I have my friend look into it and he said it was because the original site the geo distance database is not ported over and the right controller needs to be found.
I need this problem resolved ASAP. Please only bid if you can start work NOW. You will be paid US$10-US$20 if you can resolve the error, but if you can resolve it within the next hour, you will get a very good bonus
Here is the error message:
A Database Error Occurred
Error Number: 1318
Incorrect number of arguments for FUNCTION startupf_cows.geo_distance; expected 1, got 4
SELECT [url removed, login to view],title,price,per,size,sq,defaultPic,geo_distance(1.27998190, 103.84151700, latitude, longitude) as distance,location_name,price_type FROM listings LEFT JOIN locations ON [url removed, login to view] = locations.loc_id LEFT JOIN prices ON prices.price_id = [url removed, login to view] WHERE [url removed, login to view] != '130' AND approved = 1 AND [url removed, login to view] = '24' HAVING `distance` <= 1.242 OR price <= '770' OR price >= '630' ORDER BY distance ASC, price ASC LIMIT 10
Filename: /home/startupf/public_html/[url removed, login to view]
Line Number: 377
5 freelancers are bidding on average $20 for this job
I think this is the issue with number of arguments passing to that [url removed, login to view] give me the server access, i can check that Regards jacob