I gang

URGENT Help Needed to Resolve Database Error

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

Færdigheder: Database Administration, Programmering af database, MySQL, PHP, Web Design

Se mere: web design price per hour, web design price hour, distance from home to work, database design prices, asc it, 24 hour web design, Hosting Controller, database models, urgent line, models asap, error database problem, access controller, php select order asc price, order controller, select order price asc, urgent work home, urgent models needed, help needed web design, urgent work needed, php line distance, order asc price, order price asc, urgent website needed, models database, urgent help

Om arbejdsgiveren:
( 52 bedømmelser ) Singapore, Singapore

Projekt-ID: #6038968

Tildelt til:

Aloknano

can we discuss the project in more details . .. . . . .. . . . .. . . . .. . . . .. . . . .. . . . .. . . . .. . . . .. . . . .. . . . .. . . . .. . . . .. . . . .. . . . .. . . . .. . . . .. . . . .. . . . .. . . . . Mere

$20 USD in 0 dage
(131 bedømmelser)
6.4
Azaddien

Hello Sir I read your project and I am ready to fix your error right now I promise you. my experienceis very good in this situations

$20 USD in 0 dage
(28 bedømmelser)
4.7

5 freelancers are bidding on average $20 for this job

acronymsolutions

Hi, I have gone through your requirements .I am a DBA at CMM5 Level company since August 2010.I am working on MySql,SQL Server,Oracle database, I can do your job confidently with in few hours. I am very much Interested Mere

$24 USD in 0 dage
(13 bedømmelser)
4.1
workforyou17

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

$10 USD på 1 dag
(2 bedømmelser)
0.8
fawzi2000

Hi dear I'm ready to start working now if you let me, this may be my first project on freelancer but trust in me I now what you need.. Thanks

$25 USD på 1 dag
(0 bedømmelser)
0.0