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: [email protected]
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…
@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!
