node.js issue with mysql error - quick fix

£10-20 GBP

Käynnissä

Julkaistu

noin 8 vuotta sitten

£10-20 GBP

Maksettu toimituksen yhteydessä

Quick fix i'm positive. I'm attaching the file that has the problem for you to see. Written in Node.js and reference a MYSQL DB. Quick cheap fix - looking to find someone to help with future problems. Error: get_betting_list/accepted/details { game_id: '81', user_id: '14' } get_betting_info error { [Error: ER_BAD_FIELD_ERROR: Unknown column 'user_id' in 'where clause'] code: 'ER_BAD_FIELD_ERROR', errno: 1054, sqlState: '42S22', index: 0 } 

iPhone

Mobile App Development

MySQL

Node.js

Objective C

Projektin tunnus (ID): 9476534

Tietoa projektista

6 ehdotukset

Etäprojekti

Aktiivinen 8 vuotta sitten

Haluatko ansaita rahaa?

Sähköpostiosoite

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu

Saa maksu työstäsi

Kuvaile ehdotustasi

Rekisteröinti ja töihin tarjoaminen on ilmaista

Myönnetty käyttäjälle:

@clancer1125

Try to change [login to view URL]('select * from tbl_game where game_id = ? AND (user_id = ? or opponent_id = ?) AND game_status="accept" order by created_at desc limit 1', To [login to view URL]('select * from tbl_game where game_id = ? HAVING (user_id = ? or opponent_id = ?) AND game_status="accept" order by created_at desc limit 1',

£17 GBP 1 päivässä

4,9

(4 arvostelua)

2,6

6 freelancerit tarjoavat keskimäärin £19 GBP tätä projektia

@anthonioez

A proposal has not yet been provided

£22 GBP 1 päivässä

4,8

(110 arvostelua)

7,1

@yusuf2004

Hello sir! I'm expert on NodeJS/MySQL and i can fix you problem in minutes! Please award me then let's start! Thank you ...

£23 GBP 1 päivässä

5,0

(23 arvostelua)

6,2

@mcfarhat

hey there, i am an experienced developer, with over 12 years of experience. Would gladly assist you in resolving this issue

£23 GBP 1 päivässä

5,0

(7 arvostelua)

3,7

@rahulkumartest

A proposal has not yet been provided

£18 GBP 3 päivässä

5,0

(1 arvostelu)

1,8

@MartinBories

Your MySQL-Table (called "tbl_users") does not have a column called "user_id". If you send the MySQL database to me, or send me an installation script for the MySQL database, I could tell you which is the correct name for the column and fix your script. But as far as it currently looks, your fault is on line 215, where you try to filter the SELECT-clause by the "user_id"-property, which does not seem to exist on the "tbl_users"-table.

£13 GBP 1 päivässä