Quickbooks Import QBI

[brivers]

Hey adam, you were right.

Now after doing all this, I get this error:

Upgrade QBI database from version 3.00 to 3.01?

I click on the button to upgrade, and it says:

Database table upgrades successfull. Now you must go to the configuration page.
1) Recheck your configuration options and configure new options.
2) Click "Update" at the bottom of the page.
Note: You must click update to finish the upgrade, even if you did not change any settings!

Now you must go to the configuration page.

I click on "Now you must go to the configuration page." and it prompts me to "Upgrade QBI database from version 3.00 to 3.01?" again.. and it keeps doing it. Anything I am missing?

[brivers]

Also adam, after the configure, I get this error:

Warning: array_walk() [function.array-walk]: Unable to call strip_quotes_array() - function does not exist in /home/avtec/public_html/admin/includes/classes/qbi_classes.php on line 2446
Configuration successful

And if I go to "match" to create products, I get this error:

Did not find iif import file.
Notice: Query failed: Unknown column 'avtec_qbi_itemsqb_hidden' in 'where clause' SQL: SELECT * FROM avtec_qbi_itemsqb WHERE avtec_qbi_itemsqb_hidden=0 ORDER BY avtec_qbi_itemsqb_name in /home/avtec/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/avtec/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/avtec/public_html/admin/includes/classes/qbi_mysql.php on line 176

Thanks for the help :)

[adam5532]

Also adam, after the configure, I get this error:

Warning: array_walk() [function.array-walk]: Unable to call strip_quotes_array() - function does not exist in /home/avtec/public_html/admin/includes/classes/qbi_classes.php on line 2446
Configuration successful

And if I go to "match" to create products, I get this error:

Did not find iif import file.
Notice: Query failed: Unknown column 'avtec_qbi_itemsqb_hidden' in 'where clause' SQL: SELECT * FROM avtec_qbi_itemsqb WHERE avtec_qbi_itemsqb_hidden=0 ORDER BY avtec_qbi_itemsqb_name in /home/avtec/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/avtec/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/avtec/public_html/admin/includes/classes/qbi_mysql.php on line 176

Thanks for the help :)

Important for anyone upgrading from v3.00 to 3.01:

In the database_tables.php file, remove DB_PREFIX from each line added for QBI. So, for example:

define('TABLE_QBI_CONFIG', DB_PREFIX . 'qbi_config');

becomes:

define('TABLE_QBI_CONFIG', 'qbi_config');

Sorry, I forgot to put this in the Upgrade manual. This will solve your problem!

Thanks,
Adam

[brivers]

Hey it worked. Thanks a lot!

[landshark]

Adam,

I ran the update to 3.0.1 it went flawlessly no more warnings. I also redid all of my synchronization and still no change in the two major problems i'm having.

Have you gotten a chance to talk a look at the PayPal showing up under accounts receivable issue?

Also the Imported previous orders not matching to their proper item and associated account?

I even went to far as to take "merchandise" out of the "sales" catagory and made it top level so now instead of entering "sales:merchandise" in config all i have is "merchandise", updated the config in QBI, re-exported my lists from QuickBooks and imported them into QBI then went through setup, double checked my matches and experted the previous orders. Same results. Duplicate items and the ones that are imported have no associated account, in my case should be merchandise.

Thanks in advance.

[adam5532]

Adam,

I ran the update to 3.0.1 it went flawlessly no more warnings. I also redid all of my synchronization and still no change in the two major problems i'm having.

Have you gotten a chance to talk a look at the PayPal showing up under accounts receivable issue?

I'll take a look at it, and get back to you -- probably on Monday.

Also the Imported previous orders not matching to their proper item and associated account?

I'll look at this also.

Thanks,
Adam

[TommyxD]

Hey Adam,

I'm having a problem when trying to access the match menu... when I hit the update matches on this page button I get an error message saying


"Invalid argument supplied for foreach() in ...qbi_classes.php on line 2050
Matches updated."

I'm guessing it might be my own config problem since no one else is posting about it, but if you get the chance please let me know what I can do to fix this.

Thanks!!

[adam5532]

Hey Adam,

I'm having a problem when trying to access the match menu... when I hit the update matches on this page button I get an error message saying


"Invalid argument supplied for foreach() in ...qbi_classes.php on line 2050
Matches updated."

I'm guessing it might be my own config problem since no one else is posting about it, but if you get the chance please let me know what I can do to fix this.

Thanks!!

Hi,

It isn't your problem, as even if you did something wrong, the program should tell you what to do instead of delivering a cryptic PHP error message!

Tell me if I am correct in these assumptions:
You already completed the Set up before going to Match.
The match page showed a list from ZenCart on the left and drop-downs on the right with a list from QB.
After getting the error, and the "Matches Updated" message, your matches were not actually updated.

Let me know about the above questions.

Thanks,
Adam

[adam5532]

Hey Adam,

I'm having a problem when trying to access the match menu... when I hit the update matches on this page button I get an error message saying


"Invalid argument supplied for foreach() in ...qbi_classes.php on line 2050
Matches updated."

I'm guessing it might be my own config problem since no one else is posting about it, but if you get the chance please let me know what I can do to fix this.

Thanks!!

And, I assume you selected a match in at least one of the dropdowns and didn't leave them all blank?

- Adam

[nels267]

Adam,

I too am getting the below errors, however, my database_tables.php file is entered correctly? This was a new install for me using ZenCart Ver. 1.3.0.1

Also adam, after the configure, I get this error:

Warning: array_walk() [function.array-walk]: Unable to call strip_quotes_array() - function does not exist in /home/avtec/public_html/admin/includes/classes/qbi_classes.php on line 2446
Configuration successful

And if I go to "match" to create products, I get this error:

Did not find iif import file.
Notice: Query failed: Unknown column 'avtec_qbi_itemsqb_hidden' in 'where clause' SQL: SELECT * FROM avtec_qbi_itemsqb WHERE avtec_qbi_itemsqb_hidden=0 ORDER BY avtec_qbi_itemsqb_name in /home/avtec/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/avtec/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/avtec/public_html/admin/includes/classes/qbi_mysql.php on line 176

Thanks in advance,
Keith