uRGENT : NUBUILDER cRASHING

[at_rcc]

Hi Dear friend, i am having the error described below on clicking on a customer form on my webserver. Please tell me how to modify the max_join_zize in nuBuilder or any other solution please.

An error has occurred while running this query. Please contact technical support and quote error reference: 2aea7b2.

SQL
SELECT transaction.tra_amount- SUM(tbl_paymentsbatch.amount_paid) FROM tbl_paymentsbatch,transaction WHERE tbl_paymentsbatch.customer_id = '14cfc62384b53b' AND transaction.tra_customer_id ='14cfc62384b53b' AND transaction.tra_customer_id = tbl_paymentsbatch.customer_id AND transaction.tra_posted = 1 AND tbl_paymentsbatch.posted = 1

Error
1104: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

URL
http://icltraining.com/tryscript/produc ... &d=&debug=

[admin]

at_rcc,

I don't think nuBuilder is crashing..


SELECT transaction.tra_amount- SUM(tbl_paymentsbatch.amount_paid) FROM tbl_paymentsbatch,transaction WHERE tbl_paymentsbatch.customer_id = '14cfc62384b53b' AND transaction.tra_customer_id ='14cfc62384b53b' AND transaction.tra_customer_id = tbl_paymentsbatch.customer_id AND transaction.tra_posted = 1 AND tbl_paymentsbatch.posted = 1


I don't believe SUM will work here!

try this..

Code: Select all

SELECT transaction.tra_amount 
FROM tbl_paymentsbatch
INNER JOIN transaction  ON paymentsbatch.customer_id = transaction.customer_id
WHERE transaction.customer_id = '14cfc62384b53b'
AND transaction.tra_posted = 1 
AND tbl_paymentsbatch.posted = 1

btw
Your URL points nowhere.

Steven