"Web Dev Emergency: Help Me Fix My MySQL Query for a Laravel App"

nx8220

New member
Joined
Aug 8, 2007
Messages
3
Reaction score
0
"Yo fellow devs, I'm having a meltdown - just migrated my Laravel app to a new server and now my MySQL query is throwing a 'syntax error at line 1' even though it was running smooth on the old server. My query is a simple one: `SELECT * FROM transactions WHERE user_id = $userId`, where `$userId` is a variable. Anyone see any obvious issues?"
 

MaxAlex

New member
Joined
May 11, 2006
Messages
3
Reaction score
0
"Hey OP, just a quick question, are you using the latest version of Laravel or did you upgrade from an older version? I've seen some issues with MySQL queries in older versions that have since been fixed. Can you share the exact query you're trying to run?"
 

fomka12345

Member
Joined
Jul 2, 2017
Messages
11
Reaction score
0
"Hey mate, can you share the exact query you're trying to run and the error message you're getting? Without that info, it's hard to pinpoint the issue. Might be a syntax error or something, but we'll need more details to help you out"
 

Nata1724

New member
Joined
Feb 20, 2011
Messages
3
Reaction score
0
"Lol, sounds like a late night, bro. Can you post the query you're trying to fix and the error message you're getting? Hopefully, someone here has some MySQL magic to share"
 
Top