Support » Plugin: Smart Slider 3 » Won’t even install correctly.

  • Tried to install and this is what I got:

    Unexpected database error.

    Try to repair database

    If you see this message after the repair database process, please contact us with the log:
    Can’t DROP ‘thumbnail’; check that column/key exists
    ALTER TABLE wp_nextend2_smartslider3_slides DROP INDEX thumbnail
    Unexpected database error.

    Try to repair database

    If you see this message after the repair database process, please contact us with the log:
    Duplicate key name ‘thumbnail’
    ALTER TABLE wp_nextend2_smartslider3_slides ADD INDEX thumbnail (thumbnail(100))

    If you can’t even install your product correctly, no way am I going to let you repair the DB.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Gabor

    (@nextendweb_gabor)

    Hi @doingsomewordpress!

    I’m sorry the installation didn’t worked. The way this part of our code should run is, that we are checking whether or not your nextend2_smartslider3_slides table has the thumbnail key. If it does, we are removing it, then we are adding it again with a modified limit. In your case for some reason the removal didn’t happened, as you see in your error:
    “Can’t DROP ‘thumbnail” because it doesn’t exists, but then you cannot add thumbnail, because it exists. So the error already seems weird and usually this kind of issue happens, when there is a database limitation created by the server host. If you would like, we can help identifying the exact problem, just contact us at: support@nextendweb.com

    Plugin Author Nextendweb

    (@nextendweb)

    Hi @doingsomewordpress,
    I’m not sure why don’t you contact with our support staff. If you identify a problem it is better to contact with the developer to be able to address and fix the issue as it might help other people too. That is how the community could help to make WordPress, plugins and themes even better.

    I tried to reconstruct this error based on the given information. Our code were prepared for this error, this is why I’m not sure why do you got these errors.

    – #1 line: Check if there is an existing key
    – #2-#4 lines: If there was an existing key, delete it
    – #5 line: Create the key with the new format

    $hasIndex = Database::queryRow(Database::parsePrefix("SHOW INDEXES FROM #__nextend2_smartslider3_slides WHERE Key_name = 'thumbnail'"));
    if ($hasIndex) {
    	$this->query("ALTER TABLE #__nextend2_smartslider3_slides DROP INDEX thumbnail");
    }
    $this->query("ALTER TABLE #__nextend2_smartslider3_slides ADD INDEX thumbnail (thumbnail(100))");

    I your case you can only get those 2 errors, if #1 tells that the key exists. But then in #3 based on your error message, MySQL tells that the key is not exists. Then in #5, MySQL tells that the key exists. Very strange…

    Plugin Author Nextendweb

    (@nextendweb)

    @doingsomewordpress, please open your PHPMyAdmin, then run the following query:
    SHOW CREATE TABLE wp_nextend2_smartslider3_slides

    This will display the current structure of your table and it could help us to identify this bug.

    Here is an example how you can get it: https://i.imgur.com/FXM6zWq.png

    Thank you!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Won’t even install correctly.’ is closed to new replies.