Quickbooks Import QBI

[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:

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

[adam5532]

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

[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

[adam5532]

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

[sarahbn]

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

[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

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.

[adam5532]

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

[adam5532]

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

[northfork]

Hi Adam,

Been waiting for this for a long time. Thanks!

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

Tim

[adam5532]

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