How to remove SQL patches from admin
Hello I need help this has to do with QBI however I have posted many times in the QBI thread however I am still having trouble. I have installed QBI 3.21b from the zen cart downloads area but I get ALL kinds of errors.
Code:
Warning: Some products are missing the model name! Correct this issue before creating iif files!
Notice: Query failed: Unknown column 'qbi_imported' in 'where clause' SQL: SELECT COUNT(*), MIN(orders_id), MAX(orders_id), MIN(UNIX_TIMESTAMP(date_purchased)) as date_min, MAX(UNIX_TIMESTAMP(date_purchased)) as date_max FROM orders WHERE qbi_imported='0' AND orders_status='1' in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 119
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 160
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
New Orders
Notice: Query failed: Unknown column 'qbi_imported' in 'where clause' SQL: SELECT COUNT(*), MIN(orders_id), MAX(orders_id), MIN(UNIX_TIMESTAMP(date_purchased)) as date_min, MAX(UNIX_TIMESTAMP(date_purchased)) as date_max FROM orders WHERE qbi_imported='1' in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 119
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 160
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
Previous Batch of Orders
Notice: Query failed: Unknown column 'qbi_imported' in 'where clause' SQL: SELECT COUNT(*), MIN(orders_id), MAX(orders_id), MIN(UNIX_TIMESTAMP(date_purchased)) as date_min, MAX(UNIX_TIMESTAMP(date_purchased)) as date_max FROM orders WHERE (qbi_imported='1' OR qbi_imported='2') in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 119
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 160
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
All Previous Orders
Notice: Query failed: Unknown column 'qbi_imported' in 'where clause' SQL: SELECT COUNT(*), MIN(products_id), MAX(products_id), MIN(UNIX_TIMESTAMP(products_date_added)) as date_min, MAX(UNIX_TIMESTAMP(products_date_added)) as date_max FROM products WHERE qbi_imported='0' in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 119
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 160
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
New Products
Notice: Query failed: Unknown column 'qbi_imported' in 'where clause' SQL: SELECT COUNT(*), MIN(products_id), MAX(products_id), MIN(UNIX_TIMESTAMP(products_date_added)) as date_min, MAX(UNIX_TIMESTAMP(products_date_added)) as date_max FROM products WHERE qbi_imported='1' in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 119
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 160
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
Previous Batch of Products
Notice: Query failed: Unknown column 'qbi_imported' in 'where clause' SQL: SELECT COUNT(*), MIN(products_id), MAX(products_id), MIN(UNIX_TIMESTAMP(products_date_added)) as date_min, MAX(UNIX_TIMESTAMP(products_date_added)) as date_max FROM products WHERE (qbi_imported='1' OR qbi_imported='2') in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 119
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 160
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/stxmill/public_html/admin/includes/classes/qbi_mysql.php on line 176
All Previous Products
All Customers
Quan: 2
No.: 1 to 2
I have gotten previous versions to work but after installing the new version for some reason I am getting these issues. I believe it could be the old and new sql patches in the admin of zen cart maybe or something. I just need to figure out how to start over on the installation of this. I have followed the instructions of installing QBI step by step and followed the folder structure and everything but still getting errors. PLEASE I NEED YOUR HELP. The QBI thread has tried to help me as much as he can for the free version. I will have to purchase QBI in order to get more help. If anyone has any suggestions that could possible lead to a solution I will gladly take any. Thanks
