Warning: mysqli::__construct(): The server requested authentication method unknown to the client [caching_sha2_password] in /var/www/env/live/lib/ferreteria/db/v2/db-conn-mysqli.php on line 81

Warning: mysqli::__construct(): (HY000/2054): The server requested authentication method unknown to the client in /var/www/env/live/lib/ferreteria/db/v2/db-conn-mysqli.php on line 81

Warning: fcDataConn_MySQL::ErrorNumber(): Couldn't fetch mysqli in /var/www/env/live/lib/ferreteria/db/v2/db-conn-mysqli.php on line 37

Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/env/live/lib/ferreteria/db/v2/db-conn-mysqli.php on line 100

Warning: fcDataConn_MySQL::ErrorString(): Couldn't fetch mysqli in /var/www/env/live/lib/ferreteria/db/v2/db-conn-mysqli.php on line 40

Warning: fcDataConn_MySQL::ErrorNumber(): Couldn't fetch mysqli in /var/www/env/live/lib/ferreteria/db/v2/db-conn-mysqli.php on line 37
SQL: SELECT ID_Title, SUM(sl.QtyForSale) AS QtyForSale, SUM(sl.QtyForShip) AS QtyForShip, SUM(sl.QtyExisting) AS QtyExisting FROM (SELECT st.ID, st.ID_Bin, i.ID_Title, IF(sb.isForSale, st.Qty, 0) AS QtyForSale, IF(sb.isForShip, st.Qty, 0) AS QtyForShip, st.Qty AS QtyExisting, st.CatNum, st.WhenAdded, st.WhenChanged, st.WhenCounted, st.Notes, sb.Code AS BinCode, sb.ID_Place, sp.Name AS WhName FROM ((stk_lines AS st LEFT JOIN stk_bins AS sb ON sb.ID = st.ID_Bin) LEFT JOIN stk_places AS sp ON sb.ID_Place = sp.ID) LEFT JOIN cat_items AS i ON st.ID_Item=i.ID WHERE (sb.WhenVoided IS NULL) AND (st.Qty <> 0) AND (sp.isActivated)) AS sl WHERE QtyForSale > 0 GROUP BY sl.ID_Title
DB Error:
VBZ error