Cannot create new membership, database error

  • Resolved Gerard Blanco

    (@sixaxis)


    2 years, 5 months ago

    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

    (@jkleinithemes)

    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

    (@sixaxis)

    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.