Title: Error when saving the services
Last modified: August 9, 2022

---

# Error when saving the services

 *  [rsanto74](https://wordpress.org/support/users/rsanto74/)
 * (@rsanto74)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/error-when-saving-the-services/)
 * Hi,
    I just tried this plugin and the function is exactly what I need.. But when
   i change the currency to my country currency and put the price on the service,
   an error occurs when I clicked the save button. This is the error that appears“
   SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column‘
   price’ at row 1 (SQL: insert into `wpb0_wappo_prices` (`reference_id`, `name`,`
   type`, `price`, `updated_at`, `created_at`) values (1, Coaching-TanteDiii!!! –
   60min, 0, 50000000, 2022-08-09 06:10:10, 2022-08-09 06:10:10)) ”
 * This the screenhot : [https://ibb.co/QCmNbNR](https://ibb.co/QCmNbNR)
 * Can you check it. Thanks…

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Contributor [Ben](https://wordpress.org/support/users/benheu/)
 * (@benheu)
 * [3 years, 9 months ago](https://wordpress.org/support/topic/error-when-saving-the-services/#post-15988079)
 * Hi Good point, which currency are you using I’m curious?
 * It seems that our price field is indeed out of range 50 millions is above the
   limit of the table.
 *  Thread Starter [rsanto74](https://wordpress.org/support/users/rsanto74/)
 * (@rsanto74)
 * [3 years, 8 months ago](https://wordpress.org/support/topic/error-when-saving-the-services/#post-16009629)
 * Hi… sorry late replied..
 * The currency i used is Indonesian Rupiah. i want to input a 5 hundred thousand(
   500.000) rupiah than that error occurs
    While waiting for your reply, I tried
   to check the database and I think the problem is because the data type for the
   price field is tiny integer, after I changed it to integer in several tables 
   that store the price, the error doesn’t happen again. maybe you can check it 
   further.
 * I’m waiting for the latest update with the problem I’m experiencing has been 
   resolved. Thank you
 *  Thread Starter [rsanto74](https://wordpress.org/support/users/rsanto74/)
 * (@rsanto74)
 * [3 years, 8 months ago](https://wordpress.org/support/topic/error-when-saving-the-services/#post-16009674)
 * Oh, i forgot… there is another error..
 * When i deactivate the plugin and want to reactivate again, why the wizard for
   new setup come again? when i tried to resetup, it told that the database already
   created and the setup was error. i can’t used the plugin without cleaned up it’s
   database first.
 * please check this also. Thank you again.
    -  This reply was modified 3 years, 8 months ago by [rsanto74](https://wordpress.org/support/users/rsanto74/).

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Error when saving the services’ is closed to new replies.

 * ![](https://ps.w.org/wappointment/assets/icon-256x256.gif?rev=2319476)
 * [Appointment Bookings for Zoom GoogleMeet and more - Wappointment](https://wordpress.org/plugins/wappointment/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wappointment/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wappointment/)
 * [Active Topics](https://wordpress.org/support/plugin/wappointment/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wappointment/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wappointment/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [rsanto74](https://wordpress.org/support/users/rsanto74/)
 * Last activity: [3 years, 8 months ago](https://wordpress.org/support/topic/error-when-saving-the-services/#post-16009674)
 * Status: not resolved