1 MotoKW25$(923) WorkShop-On_Display $25 ' ' OS: D:-1 MT #0 RyanMysqlQuery(SELECT transactions.Product_ID, transactions.Product_Name, transactions.Comments ,CustomTransactions.ID, transactions.Price, transactions.Number, Inventory.Link FROM CustomTransactions JOIN transactions ON TransactionID = transactions.ID Join Inventory on transactions.Product_ID = Inventory.ID WHERE CustomTransactions.Done IS NULL AND transactions.Voided != 1, Array ()) called at [/homepages/29/d238888950/htdocs/W22/Functions/Function_CreateArray_MakeThese.php:16] #1 OutputPrintableListOfCustomOrders(Array ([ValueOfNeededSculptures] => 0,[MakeTimeForNeededSculptures] => 0,[1] => ), , 0) called at [/homepages/29/d238888950/htdocs/W22/Functions/Function_CreateArray_MakeThese.php:145] #2 CreateArray_MakeThese(Array ([ValueOfNeededSculptures] => 0,[MakeTimeForNeededSculptures] => 0,[1] => )) called at [/homepages/29/d238888950/htdocs/W22/Summery.php:192]
the querry was: SELECT transactions.Product_ID, transactions.Product_Name, transactions.Comments ,CustomTransactions.ID, transactions.Price, transactions.Number, Inventory.Link FROM CustomTransactions JOIN transactions ON TransactionID = transactions.ID Join Inventory on transactions.Product_ID = Inventory.ID WHERE CustomTransactions.Done IS NULL AND transactions.Voided != 1
error in Ryan My sql Querry, this is an sql error not a php error: debug back trace is :
the my sql error is: Unknown column 'Inventory.Link' in 'SELECT'
$GLOBALS[QueryLog] is:
Part1ScanPostKeysTriggerMySqlUpdates, Here we begin scanning the post variable for setting top of the summery page and entering data into my sql as needed
Here we begin scanning the post variable for numbers that were submitted in numbers forms and entering data into my sql as needed
** no transaction calculations since the post variable is empty ***

**after transaction calculations
querry all items on display that have an other-sales number > 0. check the live other-sales number for each on display

**after (1) retire these

*********************Begin CreateArray_StockThese***********************
Group Inventory = 1
Group Display Inventory = 0 Group Inventory = 1
Group Display Inventory = 0 Group Inventory = 96
Group Display Inventory = 0 Group Inventory = 1
Group Display Inventory = 0 Group Inventory = 95
Group Display Inventory = 0 Group Inventory = 1
Group Display Inventory = 0 Group Inventory = 100
Group Display Inventory = 0 Group Inventory = 2
Group Display Inventory = 0 Group Inventory = 98
Group Display Inventory = 0
SELECT Sum(On_Display) FROM Inventory Where On_Display >= 1

**after (2) stock these


**************begin Make these create array function ************************
UPDATE CustomTransactions SET DateOnly = DATE(Done) WHERE DateOnly = NULL
***End Query log ***