Marco Junior Posted March 27, 2022 Posted March 27, 2022 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 Posted March 28, 2022 Posted March 28, 2022 Please could you confirm which invoice you are trying to mark paid? I can then take a look for you
Marco Junior Posted March 28, 2022 Author Posted March 28, 2022 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 Posted March 28, 2022 Posted March 28, 2022 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.
Recommended Posts