Quickbooks Import QBI

Please help-- error messages!

I put in all the new files and made all the changes and went to check out this faboo mod from Admin, and here's what I get:

at the top of the page:
Notice: Query failed: Table 'workman_ship.qbi_config' doesn't exist SQL: SHOW COLUMNS FROM qbi_config in /home/workman/public_html/new_shop/admin/includes/classes/qbi_mysql.php on line 119

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/workman/public_html/new_shop/admin/includes/classes/qbi_mysql.php on line 160

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/workman/public_html/new_shop/admin/includes/classes/qbi_mysql.php on line 176

Warning: Cannot modify header information - headers already sent by (output started at /home/workman/public_html/new_shop/admin/includes/classes/qbi_mysql.php:119) in /home/workman/public_html/new_shop/admin/includes/classes/qbi_classes.php on line 891

Then I get the following after what is usually the top part of the Admin section:

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' in /home/workman/public_html/new_shop/admin/includes/classes/qbi_mysql.php on line 119

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/workman/public_html/new_shop/admin/includes/classes/qbi_mysql.php on line 160

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/workman/public_html/new_shop/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/workman/public_html/new_shop/admin/includes/classes/qbi_mysql.php on line 119

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/workman/public_html/new_shop/admin/includes/classes/qbi_mysql.php on line 160

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/workman/public_html/new_shop/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/workman/public_html/new_shop/admin/includes/classes/qbi_mysql.php on line 119

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/workman/public_html/new_shop/admin/includes/classes/qbi_mysql.php on line 160

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/workman/public_html/new_shop/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/workman/public_html/new_shop/admin/includes/classes/qbi_mysql.php on line 119

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/workman/public_html/new_shop/admin/includes/classes/qbi_mysql.php on line 160

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/workman/public_html/new_shop/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/workman/public_html/new_shop/admin/includes/classes/qbi_mysql.php on line 119

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/workman/public_html/new_shop/admin/includes/classes/qbi_mysql.php on line 160

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/workman/public_html/new_shop/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/workman/public_html/new_shop/admin/includes/classes/qbi_mysql.php on line 119

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/workman/public_html/new_shop/admin/includes/classes/qbi_mysql.php on line 160

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/workman/public_html/new_shop/admin/includes/classes/qbi_mysql.php on line 176

Help! I'm drowning in errors I don't understand! What did I do wrong? If I made a typo in typing in all that code, where should I go look for it? Any help is appreciated.

Thanks,
Sarah

sarahbn:

Please help-- error messages!

I put in all the new files and made all the changes and went to check out this faboo mod from Admin, and here's what I get:

...

Help! I'm drowning in errors I don't understand! What did I do wrong? If I made a typo in typing in all that code, where should I go look for it? Any help is appreciated.

Thanks,
Sarah
Did you get a button to install the database tables when you first started QBI, and did you push it? What version of PHP are you running? Some very old versions (before 4.2 I think) will have trouble because they use an old syntax on the environment variables that is deprecated and not used in QBI.

Thanks,
Adam

I did not get any button about the database. From the instructions, I was expecting to see one, but those error messages were what I got instead. There were a few buttons interspersed between the error messages but they all said "Download file".

The PHP is version 4.4.2.

I should probably also mention that I have ZC v.1.2.7, not 1.3.0.1. I can't upgrade because I rely on a mod that isn't compatible with 1.3.x.

I appreciate your help!

Thanks,
Sarah

sarahbn:

I did not get any button about the database. From the instructions, I was expecting to see one, but those error messages were what I got instead. There were a few buttons interspersed between the error messages but they all said "Download file".

The PHP is version 4.4.2.

I should probably also mention that I have ZC v.1.2.7, not 1.3.0.1. I can't upgrade because I rely on a mod that isn't compatible with 1.3.x.

I appreciate your help!

Thanks,
Sarah
Sarah,

You are trying to install QBI v3.00. Please download and install version 3.01, which was released on June 6. The installation routine was rewritten and should be more reliable. Copy all the new files over the old ones, and replace the changes to the database_tables.php file with the new version of the changes. The installation instructions are now included as a Word document so that you can copy and paste the changes. Let me know if your installation is successful after that.

Thanks,
Adam

IT'S ALIIIIIIIIIVE!!!!

Thanks Adam! I don't know how I missed that there were two versions and downloaded the other. I suppose that's what I get for lack of sleep, eh?

Thanks,
Sarah

Worked fine last night but now gives this error

Fatal error: Call to undefined function: create_line_item() in /home/cell/public_html/admin/includes/classes/qbi_classes.php on line 203

and this
when saving configuration
Warning: array_walk(): Unable to call strip_quotes_array() - function does not exist in /home/cell/public_html/admin/includes/classes/qbi_classes.php on line 2446

whats causing it.

knuckle-101:

Worked fine last night but now gives this error

Fatal error: Call to undefined function: create_line_item() in /home/cell/public_html/admin/includes/classes/qbi_classes.php on line 203
Check that you have Quickbooks Country set to United States and Output Format set to iif in the Configuration. The other choices have not been added yet.
and this
when saving configuration
Warning: array_walk(): Unable to call strip_quotes_array() - function does not exist in /home/cell/public_html/admin/includes/classes/qbi_classes.php on line 2446

whats causing it.
This is a bug that I will fix shortly in the next release. To fix it yourself for now, please see post #67.

Thanks,
Adam

I have just released QBI version 3.02, which includes the fix described in post #67. As there are no other code changes since 3.01, if you have made this fix yourself, you do not need to upgrade from v3.01 to v3.02. I have also made some minor changes in the manuals, which clarify the support policy and the directory structure.

Thanks,
Adam

Hi Adam,

Been waiting for this for a long time. Thanks!

What versions of Zen do you think it will work with?

Tim

northfork:

Hi Adam,

Been waiting for this for a long time. Thanks!

What versions of Zen do you think it will work with?

Tim
It works with 1.3.0, which is what I test it with. It should work with older versions as well.

Thanks,
Adam

Just wondering how many Canadians are interested in using the QBI?

I just sent Adam a PM to see how many hours it would take (aka how much it will cost ^_~ ) to get QBI working with the Canadian version of QuickBooks Pro. Since it's probably going to be a lot, I'm just wondering if any Canadians would find this helpful, and if anyone would be willing to share the cost with me? :wub:

Taipa:

Just wondering how many Canadians are interested in using the QBI?

I just sent Adam a PM to see how many hours it would take (aka how much it will cost ^_~ ) to get QBI working with the Canadian version of QuickBooks Pro. Since it's probably going to be a lot, I'm just wondering if any Canadians would find this helpful, and if anyone would be willing to share the cost with me? :wub:
I will be leaving soon for summer vacation, so it is highly unlikely I'll have time to add the Carandian version before September.

Thanks,
Adam

Ok - so I take it this means that it doesnt work for the UK version either? :cry:

Rgds,

businesstoweb:

Ok - so I take it this means that it doesnt work for the UK version either? :cry:

Rgds,
Yup. Currently, it works only for US Quickbooks. I put in a huge amount of time getting version 3.0 out before the summer, and unfortunately won't be able to work on any international versions before late summer.

Thanks,
Adam

I have the fedex shipping modules (one module for ground and another for express) installed on my store, but when I try to match it with quickbooks it seems that the qbi module does not detect the fedex modules. It detects all other shipping modules but not the two for fedex!

Anybody else having this problem?
Thanks for your help!
Chris

truffleboy:

I have the fedex shipping modules (one module for ground and another for express) installed on my store, but when I try to match it with quickbooks it seems that the qbi module does not detect the fedex modules. It detects all other shipping modules but not the two for fedex!

Anybody else having this problem?
Thanks for your help!
Chris
Chris,

I will test this. Sometimes there are inconsistencies in the shipping modules with the text that QBI extracts, so I will let you know what corrections to make and work on making QBI detect it properly.

Thanks,
Adam

adam5532:

Chris,

I will test this. Sometimes there are inconsistencies in the shipping modules with the text that QBI extracts, so I will let you know what corrections to make and work on making QBI detect it properly.

Thanks,
Adam

Thanks for your help Adam!

I've installed QBI just fine and I see its potential already. However, when I try to update the configuration, it says it did it successfully, but I receive this error:

Warning: array_walk(): Unable to call strip_quotes_array() - function does not exist in /mywebsitepath/catalog/admin/includes/classes/qbi_classes.php on line 2446

And I think it also has something to do with trying to generate product list/match.

I'm open to any advice!

Thanks!

revmags:

I've installed QBI just fine and I see its potential already. However, when I try to update the configuration, it says it did it successfully, but I receive this error:

Warning: array_walk(): Unable to call strip_quotes_array() - function does not exist in /mywebsitepath/catalog/admin/includes/classes/qbi_classes.php on line 2446

And I think it also has something to do with trying to generate product list/match.

I'm open to any advice!

Thanks!
This was fixed in QBI 3.02. Please download and install the latest version.

Thanks,
Adam

Taipa:

Just wondering how many Canadians are interested in using the QBI?

I just sent Adam a PM to see how many hours it would take (aka how much it will cost ^_~ ) to get QBI working with the Canadian version of QuickBooks Pro. Since it's probably going to be a lot, I'm just wondering if any Canadians would find this helpful, and if anyone would be willing to share the cost with me? :wub:

i am willing share the cost taipa.
just drop me a PM