Okay
  Public Ticket #2976344
Layer Slider database error
Closed

Comments

  • Thomas Dalton started the conversation

    Layer slider is not saving/importing any of my slides in Wordpress. My web developer has tried to update the database on the server but it has an errors saying it can't find certain files. I have attached a screenshot to show. Please could you advise how to fix this issue? Thanks

    Attached files:  Screen Shot 2022-02-08 at 12.21.39.png

  •  41
    John replied

    Hi Thomas,

    This isn't normal, LayerSlider should automatically update the database in the background. You can force a database update by navigating to System Status and pressing the Update Database button. This should attempt to fix any database related issue.

    Best Regards,
    John | Kreatura Dev Team

  • Thomas Dalton replied

    Thanks for your reply John. I did try to update the database via the System Status but it didn't seem to make a difference. Do you know anything else to try? Thanks   

  •  41
    John replied

    In that case it must be a server configuration issue. For example, misconfigured database permissions can prevent LayerSlider to make the necessary changes. Since this is an area that we don't have access to, you might need to contact the web hosting company to look into this issue. 

    Also, I can send you the database table definitions, so your web developer can manually recreate them.

    CREATE TABLE wp_layerslider (
        id int(10) NOT NULL AUTO_INCREMENT,
        group_id int(10),
        author int(10) NOT NULL DEFAULT 0,
        name varchar(100) DEFAULT '',
        slug varchar(100) DEFAULT '',
        data mediumtext NOT NULL,
        date_c int(10) NOT NULL,
        date_m int(10) NOT NULL,
        schedule_start int(10) NOT NULL DEFAULT 0,
        schedule_end int(10) NOT NULL DEFAULT 0,
        flag_dirty tinyint(1) NOT NULL DEFAULT 0,
        flag_hidden tinyint(1) NOT NULL DEFAULT 0,
        flag_deleted tinyint(1) NOT NULL DEFAULT 0,
        flag_popup tinyint(1) NOT NULL DEFAULT 0,
        flag_group tinyint(1) NOT NULL DEFAULT 0,
        PRIMARY KEY (id)
    ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
    CREATE TABLE wp_layerslider_drafts (
        id int(10) NOT NULL AUTO_INCREMENT,
        slider_id int(10) NOT NULL,
        author int(10) NOT NULL DEFAULT 0,
        data mediumtext NOT NULL,
        date_c int(10) NOT NULL,
        date_m int(10) NOT NULL,
        PRIMARY KEY  (id),
        UNIQUE KEY slider_id (slider_id)
    ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
    CREATE TABLE wp_layerslider_revisions (
        id int(10) NOT NULL AUTO_INCREMENT,
        slider_id int(10) NOT NULL,
        author int(10) NOT NULL DEFAULT 0,
        data mediumtext NOT NULL,
        date_c int(10) NOT NULL,
        PRIMARY KEY  (id)
    ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
    

    Best Regards,
    John | Kreatura Dev Team

  •  41
    John replied

    Just a quick follow-up: If it's a permission issue, which is very likely, it's probably affecting the CREATE and ALTER privileges of the database user. Otherwise, your whole site would be unusable. If my assumption is correct, then manually recreating the database tables would solve this without any side effects. However, I would still recommend going after the permission issues to eliminate such issues that might affect other plugins on your site in the future.

    Best Regards,
    John | Kreatura Dev Team

  • kevin replied

    Hi,

    i have the same problem and tried everything from deactivating plugins, deleting caches, update database, etc. 

    My projects are loading in frontend but i decided to update some slider projects recently. However, i cant open a single slider anymore in backend. It loads to death and does nothing. The Chrome and Edge dev tool show no error either because, beside the fency layerslider loading symbol, nothing loads at all that could then show an error.

    I dont know why this has happened that im suddenly unable to edit my work with Layslider in backend. I was browsing through all the good and bad tips online but cant find a plausible solution. When i bought LS and set things up, all worked and the frontend slider still works today. But for some odd reason Layerslider plugin decided to not work anymore in backend. I can see my projects but thats it. 1 click on any project and im in a neverending loading loop. Even creating an "empty project" (!) leads to a dead end.

    What happened and how can i fix my Premium Layer Slider for good?

    I attached a Screenshot of the LS database table as well as the neverending loading screen.

    By the way: I tried to open a new ticket with my purchase code but i cant because the ticket system wants me to buy a new license first to get support for my product. I purchased LS more than 6 month ago for a good amount of money to have a peaceful and stable solution. So i hope you will still reply to me here and give me the chance to understand why Layerslider stop suddenly working in backend.

    Attached files:  image_2022_08_03T18_29_36_829Z.png

  •  41
    John replied

    Hi Kevin,

    Of course, we'll help you. We want our customers to have a good experience using our products, and it's important to us that you have a working plugin that you can continue using for as long as you wish. Also, I'd like to thank you for the extensive and very professional report that has already helped us eliminate many possible issues.

    Since this is someone else's ticket, we don't want to bother them or accidentally share sensitive information, so we ask you to reach out to us from our contact page: https://layerslider.com/contact/

    Please send us a temporary WP admin access, and then we'll investigate the issue and email you back as soon as we have a solution.

    Please note that these kinds of issues are almost always caused by external factors like updating your WordPress theme or other plugins. Since we have to do a lot of investigative work to find the source of the problem, we kindly ask you to have proper support coverage in the future if another issue arises. I don't ask you to purchase anything now. However, since you bought LayerSlider, we've introduced subscriptions that cost less than the old support extension while providing a usable license and double the support coverage. I understand that this might be strange at first, but the new model is a way better deal for customers and offers much more for less money. 

    Best Regards,
    John | Kreatura Dev Team