Sql error "Syntax error or access violation: 1064" [closed]

Question

Closed. This question needs debugging details. It is not currently accepting answers.

---

Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question.

Closed 5 years ago.

Improve this question

getting (syntax error or access violation 1064) dont know what is the problem. why i am getting this error? I think problen in my syntax with DATE

here is the screen with error: enter image description here

My code:

$sql = "SELECT ds.id
FROM documents ds
INNER JOIN institutions_if ib on ds.to_inst_id = ib.id
INNER JOIN documents_log dl on ds.id = dl.doc_id
WHERE
 ds.to_inst_id in :insts
 AND DATE(FROM_UNIXTIME(dl.timestamp)) = '2014-12-31' // <======== ERROR HERE!!!!!
 AND ds.status in ('sent','received','accepted','archived')
 AND ds.template_id = :template1
 AND NOT EXISTS (
 SELECT id FROM documents dr
 WHERE
 dr.reply_to = ds.id
 and dr.template_id = :template2
 and dr.status in ('sent','received','accepted','archived')
 and dr.to_inst_id in :insts
 );";
 $result = db_query($sql, array(
 ':insts' => institution_children_plan('[237, 279, 373]'),
 ':template1' => DocumentTemplate::get_template_by_handler('disp_suspend_operat_cont'),
 ':template2' => DocumentTemplate::get_template_by_handler('comun_anul_disp_susp_oper')
 ));

• jarlh: What happens if you remove that row?
• norman.lol: What is this about Drush?
• Nick: Hmm, error now in line "AND ds.status in ('sent','received','accepted','archived')" So I think problem in line "ds.to_inst_id in :insts", you see something wrong?
• jarlh: If you run into a problem like this, simply remove things until the problem is found.

Answer 1

You missed the () around the first IN content

WHERE ds.to_inst_id in (:insts)

so you have an error on the next AND

• Nigel Ren: as :insts will be bound as a string, have you tried this?
• Nick: thk for you answer. But now I have new error :D
• ScaisEdge: You can't use a param for a string and use as an array .. for this you need dinamic sql ..( string with sql concatenaed .. but check for content for avoid sql injection)
• ScaisEdge: Or you could use several OR condition instead of an IN clause ..