1 Topic by vernonr (edited by vernonr 02/28/2011 05:05:25 pm)

  • From: UK, Kensington / Reading
  • Registered: 03/06/2009
  • Posts: 23

Topic: Error creating new recurrent invoice

I'm getting an error trying to create a new recurrent invoice

DATABASE ERROR : The recurrent invoice could not be updated or added
error code : 1366
error message : Incorrect integer value: '' for column 'debtor_no' at row 1
sql that failed was : INSERT INTO 1_recurrent_invoices (description, order_no, debtor_no, group_no, days, monthly, begin, end, last_sent) VALUES ('Fast Forward Monthly Membership', '276', '', '4', 0, 1, '2010-12-01', '2010-12-31', '2005-12-01')

Will report as bug on Mantis as I I think I can see the reason for this bug is confirmed...

vernonr's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,085

Re: Error creating new recurrent invoice

Fixed in release 2.3. You can download the fixed file on Mantis.

/Joe