node.js issue with mysql error - quick fix

£10-20 GBP

En curso

Publicado

hace más de 8 años

£10-20 GBP

Pagado a la entrega

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

ID del proyecto: 9476534

Información sobre el proyecto

6 propuestas

Proyecto remoto

Activo hace 8 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@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 en 1 día

4,9

(4 comentarios)

2,6

6 freelancers están ofertando un promedio de £19 GBP por este trabajo

@anthonioez

A proposal has not yet been provided

£22 GBP en 1 día

4,8

(110 comentarios)

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 en 1 día

5,0

(23 comentarios)

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 en 1 día

5,0

(7 comentarios)

3,7

@rahulkumartest

A proposal has not yet been provided

£18 GBP en 3 días

5,0

(1 comentario)

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 en 1 día