Error creating supplier

[PCS-Lists]

Nathan,

perp svn 3345. In AP>>supplier>>new supplier I put supplier id and name. When I click save this happens:
Database error

Invalid SQL: SELECT count(supplier_code) AS count
                                FROM perp_supplier_stock LEFT JOIN perp_stock
                                        ON (perp_stock.stock_id = perp_supplier_stock.stock_id)
                                LEFT JOIN perp_unit_of_measure AS stock_uom ON
                                        perp_stock.unit_of_measure = stock_uom.uom_id LEFT JOIN egw_categories
                                        ON (perp_stock.stock_category = egw_categories.cat_id )
                                LEFT JOIN perp_unit_of_measure AS supplier_uom ON
                                        perp_supplier_stock.supplier_uom = supplier_uom.uom_id
                                LEFT JOIN (
                                        SELECT
                                                stock_id,
                                                sum(quantity_on_hand) AS total_on_hand
                                        FROM perp_location_stock
                                        GROUP BY stock_id
                                ) AS total_inventory ON
                                        total_inventory.stock_id = perp_supplier_stock.stock_id

                                NATURAL JOIN perp_supplier  WHERE supplier_id='2' AND (perp_stock.status_flag IN ('E', 'P') OR perp_stock.status_flag IS NULL ):
Column 'supplier_id' in where clause is ambiguous


What does it mean?

[Nathan Gray]

On 20-Apr-09, at 10:49 AM, PCS-Lists wrote:

> ...
> Column 'supplier_id' in where clause is ambiguous
>
> What does it mean?

It means your version of MySQL doesn't understand NATURAL JOIN for  
some reason.
Which version of MySQL, any non-standard config settings?

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Stay on top of everything new and different, both inside and
around Java (TM) technology - register by April 22, and save
$200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
300 plus technical and hands-on sessions. Register today.
Use priority code J9JMT32. http://p.sf.net/sfu/p
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

[PCS-Lists]

>...
>It means your version of MySQL doesn't understand NATURAL JOIN for  
>some reason.
>Which version of MySQL, any non-standard config settings?

My Client MySQL version is 4.1.22.

[Nathan Gray]

On 24-Apr-09, at 12:05 PM, PCS-Lists wrote:

>
>> ...
>> It means your version of MySQL doesn't understand NATURAL JOIN for
>> some reason.
>> Which version of MySQL, any non-standard config settings?
>
> My Client MySQL version is 4.1.22.

That's not enough.
http://www.projecterp.org/mediawiki/index.php/Requirements

This could be the reason for some of your other database trouble as  
well.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensign option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers