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- Error message: Ferreteria/mysqli error: database query failed with error .
- Thrown in /var/www/env/live/lib/ferreteria/db/v2/db-conn-mysqli.php line 122
- Stack trace:#0 /var/www/env/live/lib/ferreteria/db/v2/db-conn-mysqli.php(102): fcDataConn_MySQL->ProcessResultset(NULL, Object(vcqtStockTitlesInfo), 'SELECT \n ID_...')
#1 /var/www/env/live/lib/ferreteria/db/v2/tables/db-table.php(81): fcDataConn_MySQL->FetchRecordset('SELECT \n ID_...', Object(vcqtStockTitlesInfo))
#2 /var/www/env/live/lib/VbzCart/page/home.php(297): fcTable_wSource_wRecords->FetchRecords('SELECT \n ID_...')
#3 /var/www/env/live/lib/VbzCart/page/home.php(164): vcqtStockTitlesInfo->SelectRecords_forTitleStockStatus()
#4 /var/www/env/live/lib/VbzCart/page/home.php(141): vcPageContent_home->GetRandomItems()
#5 /var/www/env/live/lib/VbzCart/page/home.php(72): vcPageContent_home->FigureExhibitPage_fromInput()
#6 /var/www/env/live/lib/ferreteria/page/page.php(42): vcPageContent_home->OnRunCalculations()
#7 /var/www/env/live/lib/ferreteria/page/page.php(70): fcPageContent->OnEventDispatch(2)
#8 /var/www/env/live/lib/ferreteria/page/page.php(56): fcPageContent->OnEventBefore(2)
#9 /var/www/env/live/lib/ferreteria/page/page.php(60): fcPageContent->DoEvent(2)
#10 /var/www/env/live/lib/ferreteria/page/page.php(60): fcContainerTag->DoEvent(2)
#11 /var/www/env/live/lib/ferreteria/page/page.php(60): fcContainerTag->DoEvent(2)
#12 /var/www/env/live/lib/ferreteria/page/page.php(570): fcPage->DoEvent(2)
#13 /var/www/env/live/lib/ferreteria/app.php(243): fcPage->DoFiguring()
#14 /var/www/env/live/lib/ferreteria/app.php(210): fcAppStandard->Main()
#15 /var/www/env/live/lib/VbzCart/app.php(23): fcAppStandard->Go()
#16 /home/vbz/public_html/index.php(73): vcAppShop->Go()
#17 {main}