Issues after try accept payments

[Marco Junior]

INSERT INTO `nexus_purchases` ( `ps_active`, `ps_start`, `ps_renewal_price`, `ps_renewal_currency`, `ps_invoice_pending`, `ps_invoice_warning_sent`, `ps_member`, `ps_name`, `ps_renewals`, `ps_renewal_unit`, `ps_tax`, `ps_expire`, `ps_app`, `ps_type`, `ps_item_id`, `ps_custom_fields`, `ps_original_invoice`, `ps_extra`, `ps_show` ) VALUES ( true, 1648402033, IPS\Math\Number::__set_state(array(
   'positive' => true,
   'beforeDecimalPoint' => 1000,
   'numberOfDecimalPlaces' => 0,
   'afterDecimalPoint' => 0,
)), 'EUR', 0, false, 43, 'MuCMS MPS', 999, 'y', 1, 33173774833, 'nexus', 'package', 11, '[]', 26, 'null', 1 )
IPS\Db\Exception: Out of range value for column 'ps_expire' at row 1 (1264)
#0 /home/techdevteam/public_html/community/system/Db/Db.php(938): IPS\_Db->preparedQuery('/*techdevt_syst...', Array)
#1 /home/techdevteam/public_html/community/system/Patterns/ActiveRecord.php(487): IPS\_Db->insert('nexus_purchases', Array)
#2 /home/techdevteam/public_html/community/system/Node/Model.php(2494): IPS\Patterns\_ActiveRecord->save()
#3 /home/techdevteam/public_html/community/applications/nexus/sources/Invoice/Invoice.php(1807): IPS\Node\_Model->save()
#4 /home/techdevteam/public_html/community/applications/nexus/modules/admin/payments/invoices.php(1165): IPS\nexus\_Invoice->markPaid()
#5 /home/techdevteam/public_html/community/system/Helpers/Wizard/Wizard.php(181): IPS\nexus\modules\admin\payments\_invoices->IPS\nexus\modules\admin\payments\{closure}(Array)
#6 /home/techdevteam/public_html/community/system/Theme/Theme.php(880) : eval()'d code(1956): IPS\Helpers\_Wizard->__toString()
#7 /home/techdevteam/public_html/community/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_core_admin_global->globalTemplate('bc3e3d05ef1102d...', Object(IPS\Helpers\Wizard), Array)
#8 /home/techdevteam/public_html/community/system/Dispatcher/Dispatcher.php(173): IPS\Theme\_SandboxedTemplate->__call('globalTemplate', Array)
#9 /home/techdevteam/public_html/community/system/Dispatcher/Standard.php(113): IPS\_Dispatcher->finish()
#10 /home/techdevteam/public_html/community/init.php(913) : eval()'d code(19): IPS\Dispatcher\_Standard->finish()
#11 /home/techdevteam/public_html/community/system/Dispatcher/Dispatcher.php(155): IPS\Dispatcher\nexus_hook_DispatcherAdmin->finish()
#12 /home/techdevteam/public_html/community/admin/index.php(13): IPS\_Dispatcher->run()
#13 {main}

 

I have this error for change invoice for paid, any solution for this ?

 

[Marc Stridgen]

Please could you confirm which invoice you are trying to mark paid? I can then take a look for you

[Marco Junior]

 

I can't mark it as paid. The invoice contains more than 1 product, but when I click to mark it as paid I have this error generated in my logs.

[Stuart Silvester]

You've got a product that's set to renew in 999 years, that's generating a renewal date that's so far into the future the number is too big to store in the database column. As an immediate work around, I would suggest disabling renewals on your product if you do not want it to renew.