Quickbooks Import QBI

Notice: Query failed: 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 '. MODULE_PAYMENT_OFFSITEPAYMENT_SUPPORTED . ')
',NULL)' at line 1 SQL: INSERT INTO qbi_paycart (qbi_paycart_mod,language_id,qbi_paycart_text, added) VALUES ('offsitepayment','1','Offsite Payment
(Supported Payment options: ' . MODULE_PAYMENT_OFFSITEPAYMENT_SUPPORTED . ')
',NULL) in /includes/classes/qbi_mysql.php on line 119




Can someone please help me with this error! Is it a SQL command I need to run? Im LOST!

Please help! Im unable to upload .iff files to QB, and im gathering this is why?

Using Zen 1.3.7 and QB 2007 Pro (accountants edition)

Melissa

Quote:

---

Originally Posted by sassayone

Notice: Query failed: 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 '. MODULE_PAYMENT_OFFSITEPAYMENT_SUPPORTED . ')
',NULL)' at line 1 SQL: INSERT INTO qbi_paycart (qbi_paycart_mod,language_id,qbi_paycart_text, added) VALUES ('offsitepayment','1','Offsite Payment
(Supported Payment options: ' . MODULE_PAYMENT_OFFSITEPAYMENT_SUPPORTED . ')
',NULL) in /includes/classes/qbi_mysql.php on line 119




Can someone please help me with this error! Is it a SQL command I need to run? Im LOST!

Please help! Im unable to upload .iff files to QB, and im gathering this is why?

Using Zen 1.3.7 and QB 2007 Pro (accountants edition)

Melissa

---

It looks like the payment module "off-site payment" has an error in that it contains a constant that isn't defined. This is causing the problem in the MySQL statement. If you aren't using this payment module, then remove it from your payment modules directory. If you are, let me know and I then we can fix it or manually correct the database.

Thanks,
Adam

Quote:

---

Originally Posted by adam5532

It looks like the payment module "off-site payment" has an error in that it contains a constant that isn't defined. This is causing the problem in the MySQL statement. If you aren't using this payment module, then remove it from your payment modules directory. If you are, let me know and I then we can fix it or manually correct the database.

Thanks,
Adam

---

Hi Adam,

yes i am using the module.. Any help would be appreciated. Im wasting precious time hand entering all my orders!

its also crashing out when i try to import orders.. im assuming (hoping) due to same problem

I did try to manually add the module to the data base.. im a beginner so coulda overlooked something.

Thanks!!!
Melissa

Quote:

---

Originally Posted by sassayone

Hi Adam,

yes i am using the module.. Any help would be appreciated. Im wasting precious time hand entering all my orders!

its also crashing out when i try to import orders.. im assuming (hoping) due to same problem

I did try to manually add the module to the data base.. im a beginner so coulda overlooked something.

Thanks!!!
Melissa

---

Disable the automatic payment module detection as follows:
File: qbi_paymatch
Lines: 40, 41
Action: Add // before these lines to disable as follows:
// $matching->match_find_lang('payment');
// $matching->match_parse('pay',TABLE_QBI_PAYCART);

Now, you will need to use phpMyAdmin, open the qbi_paycart table, and find and correct the bad entry. If you need help with this please contact me by pm.

Thanks,
Adam

Sent you PM Adam

Thanks

I got the error message to go away by disabling those lines.. Did not know what you meant by "correct the bad entry". Please explain.. it seems to be fixed (?)

Can import products etc, When I try to import orders it crashes Quickbooks. All required options are filled in under configure.. anyone have an idea of where to start troubleshooting? Id love to get it working instead of entering the stack of orders i have here ;-(

Thanks!
M

I am using quickbooks 2007/08 for record keeping. I seem to find the initial information to help me get data from Zencart to quickbooks. Can someone please point me in the right direction.
Thanks
M

My Daughter and I are currently working on a new ZenCart for her web store.

She uses Quickbooks Point of Sale module, which keeps her inventory, etc.

In her current scenario, the Web store is completely independent of the Point of Sale module, so she has to enter sales from the web store manually into QB/POS at the cash register terminals....

She is just positive that this QBI will not work for her, because of the Point of Sale Module - is she correct?

Does POS have iif import/export capabilities?

Is anyone using QB/POS with a ZenCart and QBI?

I would really like to hear from you....

I have already installed QBI into a test ZenCart, with lots of other stuff.

QBI appears to function (on the Zencart/Admin side, at least).

Thanks

HI

I was told by my graphic designer that the QBI download does not work due to the guy who created it not giving his approval to use the program. Is this correct info? If not where do I go to get the up to date download.

Thank you

Quote:

---

Originally Posted by MPaul

HI

I was told by my graphic designer that the QBI download does not work due to the guy who created it not giving his approval to use the program. Is this correct info? If not where do I go to get the up to date download.

Thank you

---

Try here:

http://www.zen-cart.com/index.php?ma...roducts_id=144