Re: 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
Re: Quickbooks Import QBI
Quote:
Originally Posted by 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
Re: Quickbooks Import QBI
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
Re: Quickbooks Import QBI
Quote:
Originally Posted by 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
Re: Quickbooks Import QBI
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
Re: Quickbooks Import QBI
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.
Re: Quickbooks Import QBI
Quote:
Originally Posted by 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.
Quote:
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
Re: Quickbooks Import QBI
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
Re: Quickbooks Import QBI
Hi Adam,
Been waiting for this for a long time. Thanks!
What versions of Zen do you think it will work with?
Tim
Re: Quickbooks Import QBI
Quote:
Originally Posted by 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
