Quickbooks Import QBI

[adam5532]

I don't actually have to install any databases do I? All i did was copy all the files within each folder to the same folder and path on the server. I have done this many times with other templates and addons to zen cart so i was sure i did that correctly. However the sql files and such i did nothing with because it didn't say to add them or anything like that. From what i understood it was supposed to do all that when i went into the admin portion of zen cart and clicked on the qbi tool under customers. How should i delete qbi from my server then readd it?

You need to copy all files, regardless of the extension. Since you didn't copy the SQL files, QBI had no way to install its database. The instructions do say to copy all files, not just .php files.

Thanks,
Adam

[welchyboy]

I am sorry but i must be missing something. Please any more info you could give me. I am using zen cart 1.38 my server has all the up to date php and other requirements. I transferred the files with filezilla going going to each directory and transferring to the same directory on the server...including sql files. Every file in each folder. I have deleted every file and then readded them again but still the same issue. I followed the manual step by step. Changed the two folders to 777 (chmod). Please if anyone can help me with this issue.


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: 1
No.: 1


This copy of QBI is not registered!
Please go to www.libermansound.com/qbi to register this copy, and then click the support tab on the QBI menu above to enter your registration into QBI.
Registration will facilitate technical support, and will allow you to receive notification of updates.

QBI 3 for Zen-Cart Copyright ©2004, 2005, 2006 by Adam Liberman
Distributed under the terms of version 2 or later of the GNU General Public License

[adam5532]

I am sorry but i must be missing something. Please any more info you could give me.

Run the following 6 SQL statements in phpMyAdmin to add the missing rows:

ALTER TABLE `orders` ADD `qbi_imported` TINYINT(2) UNSIGNED DEFAULT '2' NOT NULL

ALTER TABLE `orders` CHANGE `qbi_imported` `qbi_imported` TINYINT(2) UNSIGNED DEFAULT '0' NOT NULL

ALTER TABLE `orders` ADD INDEX (`qbi_imported`)

ALTER TABLE `products` ADD `qbi_imported` TINYINT(2) UNSIGNED DEFAULT '2' NOT NULL

ALTER TABLE `products` CHANGE `qbi_imported` `qbi_imported` TINYINT(2) UNSIGNED DEFAULT '0' NOT NULL

ALTER TABLE `products` ADD INDEX (`qbi_imported`)

- Adam

[welchyboy]

OK I am not really familiar with myphpadmin but what i did was went to the website server went to myphpadmin and went to sql. I copied the code you sent to me and tried to run it and got this error. Not really sure how to do this so there is a huge chance i am doing something wrong. However if you can get me through this problem I will be so grateful. I have been working on this one portion of the site for way too long. Thanks in advance.


Error

SQL query:

ALTER TABLE `orders` ADD `qbi_imported` TINYINT( 2 ) UNSIGNED DEFAULT '2' NOT NULL ALTER TABLE `orders` CHANGE `qbi_imported` `qbi_imported` TINYINT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ALTER TABLE `orders` ADD INDEX ( `qbi_imported` ) ALTER TABLE `products` ADD `qbi_imported` TINYINT( 2 ) UNSIGNED DEFAULT '2' NOT NULL ALTER TABLE `products` CHANGE `qbi_imported` `qbi_imported` TINYINT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ALTER TABLE `products` ADD INDEX ( `qbi_imported` )

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `orders` CHANGE `qbi_imported` `qbi_imported` TINYINT(2) UNSIGNED DE' at line 3

[adam5532]

OK I am not really familiar with myphpadmin but what i did was went to the website server went to myphpadmin and went to sql. I copied the code you sent to me and tried to run it and got this error.

Note in my message above there are 6 SQL statements. You need to run each one separately, not all of them at the same time. That is why it isn't working.

Thanks,
Adam

[welchyboy]

All i did now was add this one piece of code that you sent and still an error. The last line Table 'stxmill_phplocator.orders' doesnt exist. The phplocator is an sql i have in my phpadmin. Is there something i need to add. Do i need to add a database for the quickbook? It doesnt look like it added anything. Sorry to be so much trouble.

Error

SQL query:

ALTER TABLE `orders` ADD `qbi_imported` TINYINT( 2 ) UNSIGNED DEFAULT '2' NOT NULL

MySQL said: Documentation
#1146 - Table 'stxmill_phplocator.orders' doesn't exist

[adam5532]

All i did now was add this one piece of code that you sent and still an error. The last line Table 'stxmill_phplocator.orders' doesnt exist. The phplocator is an sql i have in my phpadmin. Is there something i need to add. Do i need to add a database for the quickbook? It doesnt look like it added anything. Sorry to be so much trouble.

Error

SQL query:

ALTER TABLE `orders` ADD `qbi_imported` TINYINT( 2 ) UNSIGNED DEFAULT '2' NOT NULL

MySQL said: Documentation
#1146 - Table 'stxmill_phplocator.orders' doesn't exist

If you don't have an orders table, then you must have added a prefix. In this case, change 'orders' to the name of your orders table. Or, maybe you are looking at the wrong database. You need to be in your Zen Cart database.

Thanks,
Adam

[welchyboy]

OK I wasn't in the zen cart database when you said phpadmin i thought you were thinking with my site and not within zen cart. However I tried it individually on my sites server and in the zen cart database under install sql patch with this...

ALTER TABLE `orders` ADD `qbi_imported` TINYINT(2) UNSIGNED DEFAULT '2' NOT NULL

and both times got errors. In zen cart the only error i get when trying to apply the patch is failed. I have no idea what my orders table is set too. I normally leave everything standard then start modifying once it works. But this hasn't worked yet. I have the stock plain jane qbi 3.21b or whatever. What do i need to do to check this out?

[adam5532]

OK I wasn't in the zen cart database when you said phpadmin i thought you were thinking with my site and not within zen cart. However I tried it individually on my sites server and in the zen cart database under install sql patch with this...

ALTER TABLE `orders` ADD `qbi_imported` TINYINT(2) UNSIGNED DEFAULT '2' NOT NULL

and both times got errors. In zen cart the only error i get when trying to apply the patch is failed. I have no idea what my orders table is set too. I normally leave everything standard then start modifying once it works. But this hasn't worked yet. I have the stock plain jane qbi 3.21b or whatever. What do i need to do to check this out?

You need to be in phpMyAdmin, with the Zen Cart database selected before you try to run the SQL statements. If the QBI tables are installed properly, you'll see them in the database (prefixed by qbi_). I'm not sure why you are having trouble installing, as it is normally trouble-free - those SQL statements normally run automatically. I can't offer to look at your tables, as that's the level of support I give for the paid version of QBI, not the free one, nor can I spend time trying to instruct you how to use phpMyAdmin. In other words, I'd like to help you, but I'm not sure if I can do more through the forum.

- Adam

[welchyboy]

I am sorry I followed the instructions to the "T"...The only thing i can think of is a bad install or an older qbi which was there before. I am not sure how to delete sql patches to start completely over. However I just downloaded the qbi 3.21b again from zen cart and followed the instructions step by step following the folder structure and chmod the two folders and everything. Still getting the same errors. So can it be something from a another installation. My problem is I have already done this a few months ago with another version but the client decided not to go through with it. Well they have changed their minds and I tried reinstalling it and I am not having issues. Before it worked just as you say...Perfectly and easily with no problems. So what could be the issue. Anyone. I don't mind deleting the sql keys and reinstalling qbi i just need to know if there are certain steps or how to even find if my prefixes have changed or my "orders". I am not sure about all of that. Like i said i normally do the default. Please can you help...Can anyone help who has had this issue. I can't be the only one with this problem or who has had this problem before. Please let me know if anyone has any suggestions and how to go about these suggestions. Thanks again for all your help Adam