Hi bruy,
I’ll assume you are on a current version of WordPress. Any errors or warnings in console or WP_DEBUG mode?
What version of PHP are you using?
What short-codes are not working?
What was the error you received from”My SQL failure?”
Thread Starter
bruy
(@bruy)
Yes / No / 8.1.16 / No shortcodes work; I want to use auto or auto+category / just that – Nothing saved – My SQL failure
What are the server requirements?
Requires at least: WordPress 4.2.2
Could also check the database for proper rights and table structure
quote_id, quote, title_name, first_name, last_name, source, img_url, author_icon, source_icon, category UNIQUE KEY quote_id
Not able to reproduce the problem. Is your database MySQL?
Thread Starter
bruy
(@bruy)
I had them check the server and database and they’re saying that side everything is fine, so that it’s a plugin issue. //yes, of course it’s MySQL. Everything server side is updated, checked, and in order.
I don’t know what else to try – I did all the troubleshooting. The fields all turn up blank in editing if I open them. I cannot change or save anything. From the shortcode on the pages it all comes up blank or undefined. I wasn’t doing anything extra to it – made no modifications. Just straight up was using the auto shortcode. It worked fine and no longer does.
“My SQL failure” is not an error message generated by Quotes Llama and MySQL errors typically give something useful to what is actually happening: https://dev.mysql.com/doc/mysql-errors/8.0/en/server-error-reference.html
If you notice any warnings or errors that might provide something I can work with that would be great. I cannot troubleshoot your environment to pinpoint where that response (Nothing saved – My SQL failure) is generated. Did they verify the table structure and permission for the account defined in your config file?
WordPress can run on a number of databases: https://codex.wordpress.org/Using_Alternative_Databases
You could always revert back to the version that functioned for you. Do NOT use a version previous to 1.0.0. Security issues in lower versions. If you aren’t sure how to do that, on the plugin homepage, click advanced view and you should see a version drop list on the page.
Another user today who when using [quotes-llama mode=’page’] would get just blank, but all other short-codes worked fine… we found that the issue was the caching function of the plugin. It’s only used on a few datasets which ‘page’ is one. When he disabled the caching it began displaying. Could you please try that and let me know?
Disable the "Use the WordPress Cache" in the Quotes Llama options tab.
I’ve asked about verifying the table structure since a return of “undefined” has so far always been a database table field is not found. Usually the category field.
Thread Starter
bruy
(@bruy)
Tried your suggestions to no avail.
I had to delete the plugin and everything from the database and start over from zero. At least it’s working now.
Thanks.
Great to hear it’s working now!
