Error en curso

  • dexsop

    (@dextrasoporte)


    2 years, 2 months ago

    Tengo el siguiente error en la página del curso
    Fatal error: Uncaught Exception: Unknown column ‘s.section_course_id’ in ‘where clause’ in /home/jessaida/public_html/wp-content/plugins/learnpress/inc/Databases/class-lp-db.php:471 Stack trace: #0 /home/jessaida/public_html/wp-content/plugins/learnpress/inc/Databases/class-lp-material-db.php(131): LP_Database->check_execute_has_error() #1 /home/jessaida/public_html/wp-content/plugins/learnpress/inc/course/abstract-course.php(1456): LP_Material_Files_DB->get_material_by_item_id(1402, 1) #2 /home/jessaida/public_html/wp-content/plugins/learnpress/inc/lp-template-functions.php(97): LP_Abstract_Course->get_downloadable_material() #3 /home/jessaida/public_html/wp-content/plugins/learnpress/templates/single-course/tabs/tabs.php(14): learn_press_get_course_tabs() #4 /home/jessaida/public_html/wp-content/plugins/learnpress/inc/lp-template-functions.php(867): include(‘/home/jessaida/…’) #5 /home/jessaida/public_html/wp-content/plugins/learnpress/inc/templates/abstract-template.php(264): learn_press_get_template(‘single-course/t in /home/jessaida/public_html/wp-content/plugins/learnpress/inc/Databases/class-lp-db.php on line 471

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author ThimPress

    (@thimpress)

    2 years, 2 months ago

    Hi dextrasoporte,

    Please try install LP beta version to check and feedback.

    Thanks.

    Thread Starter dexsop

    (@dextrasoporte)

    2 years, 2 months ago

    Ha salido este error

    [12-Mar-2024 04:53:21 UTC] WordPress database error Unknown column ‘session_key’ in ‘field list’ for query SELECT COUNT(session_key) FROM (SELECT session_key,session_value FROM wp_learnpress_sessions AS ss

    [12-Mar-2024 04:53:21 UTC] WordPress database error Unknown column 'session_key' in 'field list' for query SELECT COUNT(session_key) FROM (SELECT session_key,session_value FROM wp_learnpress_sessions AS ss
		
		WHERE 1=1 AND session_key = 'g-65efdfc1240c1'
		
		
		
		) AS ss made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, LearnPress->plugins_loaded, LearnPress->init, LearnPress->get_session, LP_Session_Handler::instance, LP_Session_Handler->__construct, LP_Session_Handler->init, LP_Session_Handler->get_session_data, LP_Session_Handler->get_session_by_customer_id, LP_Sessions_DB->get_sessions, LP_Database->execute

    Al ingresar en clases
    https://prnt.sc/lJ9pqXFWGiLA

    Thread Starter dexsop

    (@dextrasoporte)

    2 years, 2 months ago

    Al editar el curso sale este error
    Fatal error: Uncaught Exception: Unknown column ‘orders’ in ‘order clause’ in /home/jessaida/public_html/wp-content/plugins/learnpress/inc/Databases/class-lp-db.php:471 Stack trace: #0 /home/jessaida/public_html/wp-content/plugins/learnpress/inc/Databases/class-lp-material-db.php(131): LP_Database->check_execute_has_error() #1 /home/jessaida/public_html/wp-content/plugins/learnpress/inc/admin/views/meta-boxes/fields/materials.php(36): LP_Material_Files_DB->get_material_by_item_id(679, 0, 0, 1) #2 /home/jessaida/public_html/wp-content/plugins/learnpress/inc/admin/views/meta-boxes/course/settings.php(455): LP_Meta_Box_Material_Fields->output(679) #3 /home/jessaida/public_html/wp-admin/includes/template.php(1456): LP_Meta_Box_Course->output(Object(WP_Post), Array) #4 /home/jessaida/public_html/wp-admin/edit-form-advanced.php(714): do_meta_boxes(Object(WP_Screen), ‘normal’, Object(WP_Post)) #5 /home/jessaida/public_html/wp-admin/post.php(206): require(‘/home/jessaida/…’) #6 {main} thrown in /home/jessaida/public_html/wp-content/plugins/learnpress/inc/Databases/class-lp-db.php on line 471

    Plugin Author ThimPress

    (@thimpress)

    2 years, 2 months ago

    Hi dextrasoporte,

    We don’t know why your site create table require of LearnPress not success. So we need to know some info: PHP version, MYSQL version. Please go to Tools/Site Heath check has any problem, then send info to us.

    Thanks.

    Thread Starter dexsop

    (@dextrasoporte)

    2 years, 2 months ago

    ` wp-core

version: 6.4.3
    site_language: es_ES
    user_language: es_ES
    timezone: Europe/Madrid
    permalink: /%postname%/
    https_status: true
    multisite: false
    user_registration: 1
    blog_public: 0
    default_comment_status: open
    environment_type: production
    user_count: 103
    dotorg_communication: true wp-paths-sizes

wordpress_path: /home/jessaida/public_html
    wordpress_size: loading…
    uploads_path: /home/jessaida/public_html/wp-content/uploads
    uploads_size: loading…
    themes_path: /home/jessaida/public_html/wp-content/themes
    themes_size: loading…
    plugins_path: /home/jessaida/public_html/wp-content/plugins
    plugins_size: loading…
    database_size: loading…
    total_size: loading… wp-dropins (1)

object-cache.php: true wp-active-theme

name: Porto Child (porto-child)
    version: 1.1
    author: P-THEMES
    author_website: https://www.portotheme.com/
    parent_theme: Porto (porto)
    theme_features: core-block-patterns, widgets-block-editor, starter-content, post-thumbnails, editor-style, title-tag, automatic-feed-links, woocommerce, menus, post-formats, html5, wp-block-styles, responsive-embeds, align-wide, editor-styles, editor-color-palette, widgets
    theme_path: /home/jessaida/public_html/wp-content/themes/porto-child
    auto_update: Desactivado wp-parent-theme

name: Porto (porto)
    version: 6.12.1
    author: P-THEMES
    author_website: https://www.portotheme.com/
    theme_path: /home/jessaida/public_html/wp-content/themes/porto
    auto_update: Desactivado wp-plugins-active (24)

Akismet Anti-spam: Spam Protection: version: 5.3, author: Automattic - Anti-spam Team (latest version: 5.3.1), Actualizaciones automáticas desactivadas
    Checkout Field Editor for WooCommerce: version: 2.0.0, author: ThemeHigh (latest version: 2.0.1), Actualizaciones automáticas desactivadas
    Classic Editor: version: 1.6.3, author: WordPress Contributors, Actualizaciones automáticas desactivadas
    Contact Form 7: version: 5.8.4, author: Takayuki Miyoshi (latest version: 5.9), Actualizaciones automáticas desactivadas
    Duplicator: version: 1.5.7.1, author: Duplicator (latest version: 1.5.8.1), Actualizaciones automáticas desactivadas
    Easy SVG Support: version: 3.5, author: Benjamin Zekavica (latest version: 3.6), Actualizaciones automáticas desactivadas
    File Manager Advanced: version: 5.2, author: modalweb (latest version: 5.2.2), Actualizaciones automáticas desactivadas
    GBC Payment Gateway for Woocommerce: version: 2.1.5, author: Global Bridge Connections, Actualizaciones automáticas desactivadas
    Joinchat: version: 5.0.15, author: Creame (latest version: 5.0.17), Actualizaciones automáticas desactivadas
    LearnPress: version: 4.2.6.4-beta-1, author: ThimPress, Actualizaciones automáticas desactivadas
    LearnPress - WooCommerce Payment Methods Integration: version: 4.1.1, author: ThimPress, Actualizaciones automáticas desactivadas
    LiteSpeed Cache: version: 5.7.0.1, author: LiteSpeed Technologies (latest version: 6.1), Actualizaciones automáticas desactivadas
    Loco Translate: version: 2.6.6, author: Tim Whitlock, Actualizaciones automáticas desactivadas
    LoftLoader: version: 2.4.0, author: Loft.Ocean, Actualizaciones automáticas desactivadas
    Maintenance: version: 4.08, author: WebFactory Ltd, Actualizaciones automáticas desactivadas
    Porto Theme - Functionality: version: 2.12.1, author: P-Themes, Actualizaciones automáticas desactivadas
    Simple Custom CSS and JS: version: 3.45, author: SilkyPress.com (latest version: 3.46), Actualizaciones automáticas desactivadas
    Slider Revolution: version: 6.6.14, author: ThemePunch, Actualizaciones automáticas desactivadas
    WooCommerce: version: 8.3.1, author: Automattic (latest version: 8.6.1), Actualizaciones automáticas desactivadas
    WPBakery Page Builder: version: 7.3, author: Michael M - WPBakery.com (latest version: 7.5), Actualizaciones automáticas desactivadas
    WP Mail SMTP: version: 3.10.0, author: WP Mail SMTP (latest version: 4.0.1), Actualizaciones automáticas desactivadas
    YITH WooCommerce Ajax Product Filter: version: 4.28.0, author: YITH (latest version: 4.31.0), Actualizaciones automáticas desactivadas
    YITH WooCommerce Ajax Search: version: 1.37.0, author: YITH (latest version: 2.1.0), Actualizaciones automáticas desactivadas
    Yoast Duplicate Post: version: 4.5, author: Enrico Battocchi & Team Yoast, Actualizaciones automáticas desactivadas wp-plugins-inactive (4)

Advanced Custom Fields: version: 6.2.4, author: WP Engine (latest version: 6.2.7), Actualizaciones automáticas desactivadas
    All in One SEO: version: 4.5.2.1, author: All in One SEO Team (latest version: 4.5.8), Actualizaciones automáticas desactivadas
    WPForms Lite: version: 1.8.5.2, author: WPForms (latest version: 1.8.7.2), Actualizaciones automáticas desactivadas
    WP Sitemap Page: version: 1.9.3, author: Tony Archambeau, Actualizaciones automáticas desactivadas wp-media

image_editor: WP_Image_Editor_Imagick
    imagick_module_version: 1692
    imagemagick_version: ImageMagick 6.9.12-93 Q16 x86_64 17898 https://legacy.imagemagick.org
    imagick_version: 3.7.0
    file_uploads: 1
    post_max_size: 1024M
    upload_max_filesize: 1024M
    max_effective_size: 1 GB
    max_file_uploads: 20
    imagick_limits:
    imagick::RESOURCETYPE_AREA: 501 GB
    imagick::RESOURCETYPE_DISK: 9.2233720368548E+18
    imagick::RESOURCETYPE_FILE: 196608
    imagick::RESOURCETYPE_MAP: 251 GB
    imagick::RESOURCETYPE_MEMORY: 125 GB
    imagick::RESOURCETYPE_THREAD: 1
    imagick::RESOURCETYPE_TIME: 9.2233720368548E+18
    imagemagick_file_formats: 3FR, 3G2, 3GP, AAI, AI, APNG, ART, ARW, AVI, AVS, BGR, BGRA, BGRO, BIE, BMP, BMP2, BMP3, BRF, CAL, CALS, CANVAS, CAPTION, CIN, CIP, CLIP, CMYK, CMYKA, CR2, CR3, CRW, CUR, CUT, DATA, DCM, DCR, DCX, DDS, DFONT, DNG, DOT, DPX, DXT1, DXT5, EPDF, EPI, EPS, EPS2, EPS3, EPSF, EPSI, EPT, EPT2, EPT3, ERF, EXR, FAX, FILE, FITS, FLV, FRACTAL, FTP, FTS, G3, G4, GIF, GIF87, GRADIENT, GRAY, GRAYA, GROUP4, GV, H, HALD, HDR, HISTOGRAM, HRZ, HTM, HTML, HTTP, HTTPS, ICB, ICO, ICON, IIQ, INFO, INLINE, IPL, ISOBRL, ISOBRL6, J2C, J2K, JBG, JBIG, JNG, JNX, JP2, JPC, JPE, JPEG, JPG, JPM, JPS, JPT, JSON, K25, KDC, LABEL, M2V, M4V, MAC, MAGICK, MAP, MASK, MAT, MATTE, MEF, MIFF, MKV, MNG, MONO, MOV, MP4, MPC, MPEG, MPG, MRW, MSL, MSVG, MTV, MVG, NEF, NRW, NULL, ORF, OTB, OTF, PAL, PALM, PAM, PANGO, 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, POCKETMOD, 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, SVG, SVGZ, TEXT, TGA, THUMBNAIL, TIFF, TIFF64, TILE, TIM, TTC, TTF, TXT, UBRL, UBRL6, UIL, UYVY, VDA, VICAR, VID, VIDEO, VIFF, VIPS, VST, WBMP, WEBM, WEBP, WMF, WMV, WMZ, 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.27 wp-server

server_architecture: Linux 4.18.0-513.9.1.lve.el8.x86_64 x86_64
    httpd_software: LiteSpeed
    php_version: 7.4.33 64bit
    php_sapi: litespeed
    max_input_variables: 10000
    time_limit: 30
    memory_limit: 512M
    max_input_time: 60
    upload_max_filesize: 1024M
    php_post_max_size: 1024M
    curl_version: 7.61.1 OpenSSL/1.1.1k
    suhosin: false
    imagick_availability: true
    pretty_permalinks: true
    htaccess_extra_rules: true
    current: 2024-03-12T12:51:04+00:00
    utc-time: Tuesday, 12-Mar-24 12:51:04 UTC
    server-time: 2024-03-12T13:51:01+01:00 wp-database

extension: mysqli
    server_version: 10.6.16-MariaDB-cll-lve
    client_version: mysqlnd 7.4.33
    max_allowed_packet: 368435200
    max_connections: 1000 wp-constants

WP_HOME: undefined
    WP_SITEURL: undefined
    WP_CONTENT_DIR: /home/jessaida/public_html/wp-content
    WP_PLUGIN_DIR: /home/jessaida/public_html/wp-content/plugins
    WP_MEMORY_LIMIT: 40M
    WP_MAX_MEMORY_LIMIT: 512M
    WP_DEBUG: true
    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: Sin definir
    WP_DEVELOPMENT_MODE: undefined
    DB_CHARSET: utf8mb4
    DB_COLLATE: undefined wp-filesystem

wordpress: writable
    wp-content: writable
    uploads: writable
    plugins: writable
    themes: writable wp_mail_smtp

version: 3.10.0
    license_key_type: lite
    debug: No se han encontrado avisos de depuración.
    lite_install_date: Dic 11, 2023 @ 5:38pm
    Thread Starter dexsop

    (@dextrasoporte)

    2 years, 2 months ago

    https://prnt.sc/gmx9uQILHqhG

    Thread Starter dexsop

    (@dextrasoporte)

    2 years, 2 months ago

    Y desde el perfil no se puede ver mis cursos, me dice que no tengo accesos
    https://prnt.sc/HlWwC43Moub_

    Plugin Author ThimPress

    (@thimpress)

    2 years, 2 months ago

    Hi dextras,

    Really diffucult to know reason error, we see you use premium addon from us. So please create a topic on the forum Thimpress and send link here. We’ll have enough info to debug it.

    Thanks.

    Thread Starter dexsop

    (@dextrasoporte)

    2 years, 2 months ago

    https://thimpress.com/forums/topic/error-en-curso/#post-965330

    Plugin Author ThimPress

    (@thimpress)

    2 years, 2 months ago

    Hi dextrasoporte,

    Yes, we see it, now we’ll discuss on the forum.

    Thanks.

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

The topic ‘Error en curso’ is closed to new replies.