Hey nathan,
thanks for help… I got it working now. there was a problem with a
sql
table.
I reinstalled the whole database adn now it works.
this time I took your egw+perp-package.
Glad to hear it, I was just about to follow up this morning.
Do you know which table?
Nathan Gray
nathan at goarctic dot com
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H
I still not able to read the errors g
but here’s the error appears:
Database error
Invalid SQL: SELECT perp_work_order_detail.work_order_id,perp_work_order_detail.detail_id,perp_work_order_detail.stock_id,perp_work_order_detail.quantity,perp_work_order_detail.direct_cost,perp_work_order_detail.indirect_cost,option_search,perp_work_order_bill_of_material.bill_of_material_id FROM perp_work_order_detail JOIN perp_bill_of_material ON
perp_bill_of_material.stock_id = perp_work_order_detail.stock_id
JOIN perp_work_order_bill_of_material ON
perp_bill_of_material.bill_of_material_id = perp_bill_of_material.bill_of_material_id AND
perp_work_order_bill_of_material.work_order_id = perp_work_order_detail.work_order_id AND
perp_work_order_bill_of_material.detail_id = perp_work_order_detail.detail_id WHERE perp_work_order_detail.work_order_id = AND perp_work_order_detail.detail_id = :
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 ‘AND perp_work_order_detail.detail_id =’ at line 6
perhaps it helps you…
I’m using pERP in a 20 user company with focus service and small manufacturing.
until now it seems to be a good decision.
Thanks for it smile
I still not able to read the errors g
but here’s the error appears:
…
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 ‘AND
perp_work_order_detail.detail_id =’ at line 6
perhaps it helps you…
It does, thank you. Looks like something went wrong earlier in the
process, and it just carried through.
I’m using pERP in a 20 user company with focus service and small
manufacturing.
until now it seems to be a good decision.
Thanks for it smile
Until now? I thought this particular error had been resolved by re-
installing the database, and you had it working now.
I’m particularly interested in following your experience setting up
and using pERP, as there are relatively few manufacturers testing
pERP. I have many questions for you (later).
Nathan Gray
nathan at goarctic dot com
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H