Can't add prices

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

    (@jan-maat)

    This is a low level error message saying that either an insert or an update of a price record fails.
    If you have phpMyAdmin access inspect the table “wp_availabilitybooking_prices”.
    The structure should be:

    id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
name varchar(100) NOT NULL DEFAULT 'default',
date date NOT NULL default '0000-00-00',
price varchar(100) NOT NULL DEFAULT '',
week varchar(100) NOT NULL DEFAULT '',
weekend varchar(100) NOT NULL DEFAULT '',
midweek varchar(100) NOT NULL DEFAULT '',
add_person varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY  (id)

    If this is correct delete all the records and try again.

    Regards,

    If this is correct delete all the records and try again.

    Regards,

    Jan

    Thread Starter niktip

    (@niktip)

    Hi Jan,

    I have zero rows

    this is the structure:

    1 idPrimary bigint(20) UNSIGNED No None AUTO_INCREMENT
    2 name varchar(100) utf8mb4_unicode_ci No default
    3 date date No 0000-00-00
    4 price varchar(100) utf8mb4_unicode_ci No
    5 week varchar(100) utf8mb4_unicode_ci No
    6 weekend varchar(100) utf8mb4_unicode_ci No
    7 midweek varchar(100) utf8mb4_unicode_ci No
    8 add_person varchar(100) utf8mb4_unicode_ci No

    BRs,
    Niksa

    Thread Starter niktip

    (@niktip)

    Hi Jan,

    Reinstalled plugin, works now

    Niksa

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Can't add prices’ is closed to new replies.