I am getting this error in the log:
Code:
[29-Oct-2017 16:07:38 America/New_York] Request URI: /test4store/xxxxxx/addon_review_reminder.php, IP address: 142.167.45.240
#1 trigger_error() called at [/home/creat419/public_html/creationcassel.com/test4store/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/home/creat419/public_html/creationcassel.com/test4store/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/home/creat419/public_html/creationcassel.com/test4store/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/home/creat419/public_html/creationcassel.com/test4store/xxxxxx/addon_review_reminder.php:344]
[29-Oct-2017 16:07:38 America/New_York] PHP Fatal error: 1146:Table 'creat419_test4.addon_review_reminder_optout' doesn't exist :: SELECT DISTINCT o.`orders_id` AS oid,
o.`customers_id`,
DATE_FORMAT(o.`date_purchased`,'%m/%d/%y') AS date,
os.`orders_status_name` AS status,
o.`customers_name` AS customer,
o.`customers_company` AS company,
osh.`date_added`
FROM `zen_orders` AS o
LEFT JOIN `zen_orders_status` AS os
ON o.`orders_status` = os.`orders_status_id`
LEFT JOIN `zen_customers` AS c
ON o.`customers_id` = c.`customers_id`
LEFT JOIN `zen_orders_status_history` AS osh
ON (o.`orders_id` = osh.`orders_id`
AND osh.`orders_status_id` = '')
WHERE osh.`date_added` > '1969-12-31'
AND osh.`date_added` < '1969-12-31 23:59:59'
AND o.`orders_status` = ''
AND o.`customers_id` NOT IN (
SELECT `customers_id`
FROM `addon_review_reminder_optout`
)
AND o.`orders_id` NOT IN (
SELECT `orders_id`
FROM `addon_review_reminder_log`
)
GROUP BY o.`orders_id`
ORDER BY o.`orders_id` DESC ==> (as called by) /home/creat419/public_html/creationcassel.com/test4store/xxxx/addon_review_reminder.php on line 344 <== in /home/creat419/public_html/creationcassel.com/test4store/includes/classes/db/mysql/query_factory.php on line 167
I x'ed out the admin folder.
Bookmarks