Plugin Database Error

  • Resolved tekhnologica

    (@tekhnologica)


    8 years, 3 months ago

    Hi,

    I recently migrated my site to a new server and everything is running fine except for this plugin. When trying to view folders through the plugin, WordPress hangs and then the following error is repeated over and over (with debug enabled):

    [17-Feb-2018 21:26:33 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 4 for query
    select post_title, ID, mgmlp_folders.folder_id from dposts LEFT JOIN dmgmlp_folders ON(posts.ID = mgmlp_folders.post_id)
    where ID = made by do_action(‘toplevel_page_media-library-folders’), WP_Hook->do_action, WP_Hook->apply_filters, MaxGalleriaMediaLib->media_library, MaxGalleriaMediaLib->get_parents

    Any idea what might be going on?

Viewing 1 replies (of 1 total)
  • Plugin Author AlanP57

    (@alanp57)

    8 years, 3 months ago

    After migrating your site, it may be a good idea to reset and scan the Media Library Folders folder data. After migrating your site, did you use something like the Better Search and Replace plugin to update all the URLs in your database?

    If not I would suggest

    1. Backup up your current database
    2. Deactivate Media Library Folders, activate Media Library Folders Reset and run the Database Reset option to remove folder data from the database. Files and folders on your server are not affected by this action
    3. Install, activate and run Better Search and Replace. Check the option to update guid fields and uncheck the dry run option. Also in the change from and change to fields do not include the ‘http://’ or ‘https://’ part of the URL. Otherwise these will be repeated (‘http://http://’).
    4, Update your permalinks.
    5. Verify that your site is working correctly.
    6. Activate Media Library Folders which will do a fresh scan of the items in your media library. Now check if this error is still occurring.

Viewing 1 replies (of 1 total)

The topic ‘Plugin Database Error’ is closed to new replies.

Tags