Error when saving the services

  • rsanto74

    (@rsanto74)


    3 years, 7 months ago

    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

    Can you check it. Thanks…

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Ben

    (@benheu)

    3 years, 6 months ago

    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

    (@rsanto74)

    3 years, 6 months ago

    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

    (@rsanto74)

    3 years, 6 months ago

    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, 6 months ago by rsanto74.
Viewing 3 replies - 1 through 3 (of 3 total)

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