Phreesoft Support Forum

Hi Guys,
i have installed the application and it looks very very nice, thanks for the great Job,
i only have one question, while trying to Purchace/ receive inventory i was asked to choose a buyer from the buyers dropdown, but i didnt know where i can define new buyers! i also got this exception while trying to save my choice.

following is the exception:

The failing sql was: insert into journal_main (period, journal_id, post_date, store_id, description, closed, freight, shipper_code, terms, sales_tax, tax_auths, total_amount, currencies_code, currencies_value, so_po_ref_id, purchase_invoice_id, purch_order_id, dept_rep_id, waiting, gl_acct_id, bill_acct_id, bill_address_id, bill_primary_name, bill_contact, bill_address1, bill_address2, bill_city_town, bill_state_province, bill_postal_code, bill_country_code, bill_telephone1, bill_email, ship_acct_id, ship_address_id, ship_primary_name, ship_contact, ship_address1, ship_address2, ship_city_town, ship_state_province, ship_postal_code, ship_country_code, ship_telephone1, ship_email, terminal_date, drop_ship, recur_id) values ('6', '6', '2008-06-18', '', 'Purchase/Receive Entry', '0', '0', ':', '0::::2500.00', '0', '0', '0', 'USD', '1.0', '', '', '', '', '1', '9999', '1', '1', '234', '', '234', '', '234', '234', '23424', 'LBN', '', '', '1', '1', 'Clifton Mayers', '', 'Badaro', '', 'Beirut', 'Beirut', '11111', 'LBN', '', 'omar.bilani@gmail.com', '2008-07-18', '0', '')

1264 Out of range value adjusted for column 'store_id' at row 1



i am really looking forward to use this application and help you guys with your bug fixes and future enhancements.

--BILANI Omar
--CME inc.
--Cell: 0019613032191

A couple of questions:
What version of MySQL are you using?
Do you have Multi-Branch enabled?

The error results from the store_id variable not being set. Try this:

Edit file: /modules/orders/pages/orders/pre_process.php line 269.
replace:
$order->store_id = db_prepare_input($_POST['store_id']);
with :
$order->store_id = db_prepare_input($_POST['store_id']);
if ($order->store_id == '') $order->store_id = 0;

I found this searching the web that might be useful:
http://webomania.wordpress.com/2006/10/01/out-of-range-value-adjusted-for-column-error/

Dave

Hi Dave and thanks for the reply,
i am using MYSQL version 5.

Thanks

Did this solve your problem? If so, I will incorporate it into the svn slated for the next release.

Dave