Title: Cannot create new membership, database error Last modified: June 10, 2022 --- # Cannot create new membership, database error * Resolved [Gerard Blanco](https://wordpress.org/support/users/sixaxis/) * (@sixaxis) * [3 years, 12 months ago](https://wordpress.org/support/topic/cannot-create-new-membership-database-error/) * Hi there, * I’m trying to create a new membership, but it is not working. When I hit the button “Add Membership Level”, it throws this error: * ``` WordPress database error: [Table 'lalior_1645455054.wp_restrict_content_pro' doesn't exist] SELECT COUNT(*) FROM wp_restrict_content_pro ml WordPress database error: [Table 'lalior_1645455054.wp_restrict_content_pro' doesn't exist] SELECT COUNT(*) FROM wp_restrict_content_pro ml WHERE ml.status = 'active' WordPress database error: [Table 'lalior_1645455054.wp_restrict_content_pro' doesn't exist] SELECT COUNT(*) FROM wp_restrict_content_pro ml WHERE ml.status = 'inactive' WordPress database error: [Table 'lalior_1645455054.wp_restrict_content_pro' doesn't exist] SELECT ml.id FROM wp_restrict_content_pro ml ORDER BY ml.list_order ASC LIMIT 10 WordPress database error: [Table 'lalior_1645455054.wp_restrict_content_pro' doesn't exist] SELECT COUNT(*) FROM wp_restrict_content_pro ml ``` * This is my debug data. Could you help me, please? * ``` ### wp-core ### version: 6.0 site_language: en_US user_language: en_US timezone: +00:00 permalink: /%postname%/ https_status: false multisite: false user_registration: 0 blog_public: 1 default_comment_status: open environment_type: production user_count: 9 dotorg_communication: true ### wp-paths-sizes ### wordpress_path: /home/runcloud/webapps/lalior wordpress_size: 55.06 MB (57731777 bytes) uploads_path: /home/runcloud/webapps/lalior/wp-content/uploads uploads_size: 7.86 MB (8247007 bytes) themes_path: /home/runcloud/webapps/lalior/wp-content/themes themes_size: 13.14 MB (13780058 bytes) plugins_path: /home/runcloud/webapps/lalior/wp-content/plugins plugins_size: 67.14 MB (70404184 bytes) database_size: 10.25 MB (10747904 bytes) total_size: 153.46 MB (160910930 bytes) ### wp-active-theme ### name: Blocksy Child (blocksy-child) version: undefined author: Creative Themes author_website: (undefined) parent_theme: Blocksy (blocksy) theme_features: core-block-patterns, widgets-block-editor, automatic-feed-links, responsive-embeds, html5, title-tag, custom-logo, lifterlms-sidebars, boostify-header-footer, fl-theme-builder-headers, fl-theme-builder-footers, fl-theme-builder-parts, editor-styles, editor-style, editor-color-palette, editor-gradient-presets, post-thumbnails, menus, align-wide, customize-selective-refresh-widgets, header-footer-elementor, widgets theme_path: /home/runcloud/webapps/lalior/wp-content/themes/blocksy-child auto_update: Disabled ### wp-parent-theme ### name: Blocksy (blocksy) version: 1.8.36 author: CreativeThemes author_website: https://creativethemes.com theme_path: /home/runcloud/webapps/lalior/wp-content/themes/blocksy auto_update: Disabled ### wp-themes-inactive (1) ### Twenty Twenty-Two: version: 1.2, author: the WordPress team, Auto-updates disabled ### wp-plugins-active (11) ### Blocksy Companion (Premium): version: 1.8.34, author: CreativeThemes, Auto-updates disabled Enable Media Replace: version: 3.6.3, author: ShortPixel, Auto-updates disabled LiteSpeed Cache: version: 4.6, author: LiteSpeed Technologies, Auto-updates disabled Resize Image After Upload: version: 1.8.6, author: ShortPixel, Auto-updates disabled Restrict Content: version: 3.0.5, author: iThemes, Auto-updates disabled Simple Local Avatars: version: 2.4.0, author: Jake Goldman, 10up, Auto-updates disabled Stackable - Gutenberg Blocks: version: 3.3.3, author: Gambit Technologies, Inc, Auto-updates disabled WPForms Lite: version: 1.7.4.2, author: WPForms, Auto-updates disabled WP SVG Images: version: 4.0, author: ShortPixel, Auto-updates disabled WPvivid Backup Plugin: version: 0.9.73, author: WPvivid Team, Auto-updates disabled Yoast Duplicate Post: version: 4.4, author: Enrico Battocchi & Team Yoast, Auto-updates disabled ### wp-media ### image_editor: WP_Image_Editor_Imagick imagick_module_version: 1690 imagemagick_version: ImageMagick 6.9.10-23 Q16 x86_64 20190101 https://imagemagick.org imagick_version: 3.7.0 file_uploads: File uploads is turned off post_max_size: 256M upload_max_filesize: 256M max_effective_size: 256 MB max_file_uploads: 20 imagick_limits: imagick::RESOURCETYPE_AREA: 122 MB imagick::RESOURCETYPE_DISK: 1073741824 imagick::RESOURCETYPE_FILE: 786432 imagick::RESOURCETYPE_MAP: 512 MB imagick::RESOURCETYPE_MEMORY: 256 MB imagick::RESOURCETYPE_THREAD: 1 imagemagick_file_formats: 3FR, 3G2, 3GP, AAI, AI, ART, ARW, AVI, AVS, BGR, BGRA, BGRO, BIE, BMP, BMP2, BMP3, BRF, CAL, CALS, CANVAS, CAPTION, CIN, CIP, CLIP, CMYK, CMYKA, CR2, CRW, CUR, CUT, DATA, DCM, DCR, DCX, DDS, DFONT, DNG, DPX, DXT1, DXT5, EPDF, EPI, EPS, EPS2, EPS3, EPSF, EPSI, EPT, EPT2, EPT3, ERF, FAX, FILE, FITS, FRACTAL, FTP, FTS, G3, G4, GIF, GIF87, GRADIENT, GRAY, GRAYA, GROUP4, H, HALD, HDR, HISTOGRAM, HRZ, HTM, HTML, HTTP, HTTPS, ICB, ICO, ICON, IIQ, INFO, INLINE, IPL, ISOBRL, ISOBRL6, JBG, JBIG, JNG, JNX, JPE, JPEG, JPG, JPS, JSON, K25, KDC, LABEL, M2V, M4V, MAC, MAGICK, MAP, MASK, MAT, MATTE, MEF, MIFF, MKV, MNG, MONO, MOV, MP4, MPC, MPEG, MPG, MRW, MSL, MTV, MVG, NEF, NRW, NULL, ORF, OTB, OTF, PAL, PALM, PAM, PATTERN, PBM, PCD, PCDS, PCL, PCT, PCX, PDB, PDF, PDFA, PEF, PES, PFA, PFB, PFM, PGM, PGX, PICON, PICT, PIX, PJPEG, PLASMA, PNG, PNG00, PNG24, PNG32, PNG48, PNG64, PNG8, PNM, PPM, PREVIEW, PS, PS2, PS3, PSB, PSD, PTIF, PWP, RADIAL-GRADIENT, RAF, RAS, RAW, RGB, RGBA, RGBO, RGF, RLA, RLE, RMF, RW2, SCR, SCT, SFW, SGI, SHTML, SIX, SIXEL, SPARSE-COLOR, SR2, SRF, STEGANO, SUN, TEXT, TGA, THUMBNAIL, TIFF, TIFF64, TILE, TIM, TTC, TTF, TXT, UBRL, UBRL6, UIL, UYVY, VDA, VICAR, VID, VIFF, VIPS, VST, WBMP, WEBP, WMV, WPG, X, X3F, XBM, XC, XCF, XPM, XPS, XV, XWD, YCbCr, YCbCrA, YUV gd_version: bundled (2.1.0 compatible) gd_formats: GIF, JPEG, PNG, WebP, BMP, XPM ghostscript_version: 9.50 ### wp-server ### server_architecture: Linux 5.4.0-89-generic x86_64 httpd_software: LiteSpeed php_version: 7.4.30 64bit php_sapi: litespeed max_input_variables: 1000 time_limit: 30 memory_limit: 256M max_input_time: 60 upload_max_filesize: 256M php_post_max_size: 256M curl_version: 7.68.0 OpenSSL/1.1.1f suhosin: false imagick_availability: true pretty_permalinks: true htaccess_extra_rules: true ### wp-database ### extension: mysqli server_version: 10.5.16-MariaDB-1:10.5.16+maria~focal client_version: mysqlnd 7.4.30 max_allowed_packet: 67108864 max_connections: 4096 ### wp-constants ### WP_HOME: undefined WP_SITEURL: undefined WP_CONTENT_DIR: /home/runcloud/webapps/lalior/wp-content WP_PLUGIN_DIR: /home/runcloud/webapps/lalior/wp-content/plugins WP_MEMORY_LIMIT: 40M WP_MAX_MEMORY_LIMIT: 256M WP_DEBUG: false WP_DEBUG_DISPLAY: true WP_DEBUG_LOG: false SCRIPT_DEBUG: false WP_CACHE: true CONCATENATE_SCRIPTS: undefined COMPRESS_SCRIPTS: undefined COMPRESS_CSS: undefined WP_ENVIRONMENT_TYPE: Undefined DB_CHARSET: utf8 DB_COLLATE: undefined ### wp-filesystem ### wordpress: writable wp-content: writable uploads: writable plugins: writable themes: writable ### wpforms ### version: 1.7.4.2 lite: May 2, 2022 @ 1:49pm upload_dir: Writable db_tables: wp_wpforms_tasks_meta total_forms: 1 total_submissions: undefined ``` Viewing 2 replies - 1 through 2 (of 2 total) * Plugin Support [jkleinithemes](https://wordpress.org/support/users/jkleinithemes/) * (@jkleinithemes) * [3 years, 11 months ago](https://wordpress.org/support/topic/cannot-create-new-membership-database-error/#post-15764495) * Hi. It sounds like your database is corrupted, and likely missing columns needed by RC to function. Sometimes this happens when you upgrade from a very old copy of the software to a very new version. Sometimes it occurs when you go back and forth between non consecutive installs of the software. If you can export your Members, keep a record of your Member Levels and totally uninstall RC (there is a setting Restrict > Settings > Misc > Remove Data on Uninstall that need to be enabled), you can start from scratch. * Thread Starter [Gerard Blanco](https://wordpress.org/support/users/sixaxis/) * (@sixaxis) * [3 years, 9 months ago](https://wordpress.org/support/topic/cannot-create-new-membership-database-error/#post-15957386) * Thank you, that worked 🙂 Viewing 2 replies - 1 through 2 (of 2 total) The topic ‘Cannot create new membership, database error’ is closed to new replies. * ![](https://ps.w.org/restrict-content/assets/icon.svg?rev=3529325) * [Membership Plugin - Kadence Memberships](https://wordpress.org/plugins/restrict-content/) * [Frequently Asked Questions](https://wordpress.org/plugins/restrict-content/#faq) * [Support Threads](https://wordpress.org/support/plugin/restrict-content/) * [Active Topics](https://wordpress.org/support/plugin/restrict-content/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/restrict-content/unresolved/) * [Reviews](https://wordpress.org/support/plugin/restrict-content/reviews/) ## Tags * [corrupt database](https://wordpress.org/support/topic-tag/corrupt-database/) * 2 replies * 2 participants * Last reply from: [Gerard Blanco](https://wordpress.org/support/users/sixaxis/) * Last activity: [3 years, 9 months ago](https://wordpress.org/support/topic/cannot-create-new-membership-database-error/#post-15957386) * Status: resolved