ERROR : (1213) Deadlock found when trying to get lock; try restarting transaction
==> SQL : create temporary table stock0 select item,sum(case when left(docu,1)="I" then cant else cant*(-1) end) as stock from inve1 left join inve2 on idnum1=idnum2 left join item0 on item=item_codigo left join lsub0 on item_lsub=lsub_codigo left join mrca0 on item_mrca=mrca_codigo left join bode0 on bode=bode_codigo left join clor0 on item_clor=clor_codigo left join tlla0 on item_tlla=tlla_codigo left join kldd0 on item_kldd=kldd_codigo where status not in ("O","X") and bode_tipo not like "N%" and item_mrca = "THO" group by item
DEBUG :
==> Array || file=/home/vcrxol/public_html/_lib/ctlg_item3.php || line=288 || function=msql_query || args=Array
==> Array || file=/home/vcrxol/public_html/_lib/menu_load0.php || line=691 || args=Array || function=include
==> Array || file=/home/vcrxol/public_html/_lib/vrstart.php || line=275 || args=Array || function=include
==> Array || file=/home/vcrxol/public_html/orel/index.php || line=1 || args=Array || function=include


ERROR : (1146) Table 'vcrxol_orel.stock0' doesn't exist
==> SQL : select *,count(item_tlla) as item_ctalla from item0 left join lsub0 on item_lsub=lsub_codigo left join mrca0 on item_mrca=mrca_codigo left join clor0 on item_clor=clor_codigo left join tlla0 on item_tlla=tlla_codigo left join kldd0 on item_kldd=kldd_codigo where item_status not in ("I","X") and item_descri!="" and item_codigo not like "99%" and item_puni1>0 and item_codigo like "20%" and item_mrca = "THO" and left(item_codigo,10) in(select left(item,10) from stock0 where stock>0) group by item_codigo order by item_descri,item_codigov
DEBUG :
==> Array || file=/home/vcrxol/public_html/_lib/ctlg_item3.php || line=394 || function=msql_query || args=Array
==> Array || file=/home/vcrxol/public_html/_lib/menu_load0.php || line=691 || args=Array || function=include
==> Array || file=/home/vcrxol/public_html/_lib/vrstart.php || line=275 || args=Array || function=include
==> Array || file=/home/vcrxol/public_html/orel/index.php || line=1 || args=Array || function=include

==> Array || file=/home/vcrxol/public_html/_lib/ctlg_item3.php || line=398 || function=msql_num_rows || args=Array
==> Array || file=/home/vcrxol/public_html/_lib/menu_load0.php || line=691 || args=Array || function=include
==> Array || file=/home/vcrxol/public_html/_lib/vrstart.php || line=275 || args=Array || function=include
==> Array || file=/home/vcrxol/public_html/orel/index.php || line=1 || args=Array || function=include

---

05:17:40