KrishnaSaysInBG: Difference between revisions

Revision as of 09:37, 18 February 2023

The query SELECT yadatest(tran.tran_id),tran.tran_id,vers_ref,replace(vers_ref," ","_"),tran_text FROM `tran`,`trpr`,`vers` WHERE tran.tran_id=trpr.tran_id and tran.vers_id=vers.vers_id and prop_id = {{{1}}} is invalid (Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Template:1}' at line 1 Function: EDConnectorRdbms::fetch Query: SELECT yadatest(tran.tran_id),tran.tran_id,vers_ref,replace(vers_ref," ","_"),tran_text FROM `tran`,`trpr`,`vers` WHERE tran.tran_id=trpr.tran_id and tran.vers_id=vers.vers_id and prop_id = {{{1}}} ).

from	until	Tuplets	Verse	Translation

@@ Line 3: / Line 3: @@
   |from= tran,trpr,vers
   |where= tran.tran_id=trpr.tran_id and tran.vers_id=vers.vers_id and prop_id = {{{1}}}
-  |data= tuplets=yadatest(tran_id),id=tran.tran_id,vref_s=vers_ref,vref_u=replace(vers_ref," ","_"),text=tran_text
+  |data= tuplets=yadatest(tran.tran_id),id=tran.tran_id,vref_s=vers_ref,vref_u=replace(vers_ref," ","_"),text=tran_text
 }}
 {| class="wikitable" style="width:70%; font-size:initial; border-radius:8px"