Posted 1 year ago #
De-activated the 2.x plugin, uploaded 3.x files, re-activated plugin, getting the following error:
There was an error locating the database tables for AdRotate.
under "Manage Ads", "Manage Groups", and "Manage Blocks". "User Stats", "Admin Stats" and "Settings" all work.
Even manually deleted all the database entries for the plugin and re-activated it, still have same issue.
Posted 1 year ago #
This will be addressed in 3.0.1
Posted 1 year ago #
Problem still exists in 3.0.1
I checked the database, it's not creating tables on activation.
Posted 1 year ago #
This became a problem for me when I updated to 3.0.2
Posted 1 year ago #
Yup, same problem in 3.0.2
Checked the database, still not creating tables on activation or re-activation.
Posted 1 year ago #
Sorted and tested in 3.0.3 (for real this time!)
Posted 1 year ago #
I just updated 3.0.3 but I get the same error message.
Posted 1 year ago #
Ah, sorry, I did the deactivation and reactivation and seems to be working now.
Posted 1 year ago #
That fixed it! Thanks so much for your efforts.
Posted 1 year ago #
Yes, thank you. The quick response is appreciated.
Posted 1 year ago #
I ended up writing a new installer similar to what WordPress uses for its upgrades. This seems to work very well, i've had no reports of it not working yet.
Posted 1 year ago #
I'm getting this "Error locating database tables", even after installing/activating the plugin on 3.0.3.
Any solution to fix this? I'm dying to try out this plugin. Thanks!
Posted 1 year ago #
3.0.3
When I activate the plugin the following message comes.
"The plugin generated 220 characters of unexpected output during activation. If you notice “headers already sent” messages, problems with syndication feeds or other issues, try deactivating or removing this plugin."
or on other site
"... 215 characters ..."
and on pluginsite
"There was an error locating the database tables for AdRotate. Please deactivate and re-activate AdRotate from the plugin page!!
If this does not solve the issue please seek support at http://www.adrotateplugin.com/page/support.php"
Nothing changes if I deactivate and re-activate.
Posted 1 year ago #
Check your wp-config.php file and make sure that you have the correct value for DB_CHARSET. Older versions of WordPress used 'utf-8', but it should actually be 'utf8' on newer versions of MySQL. The database install portion of this plugin attempts to use the DB_CHARSET when creating the tables, so if it is invalid, tables won't get created.
I overcame this issue with the following steps:
1. Update DB_CHARSET value in wp-config.php
2. Deactivate and delete the AdRotate plugin
3. Manually remove the wp_options record for 'adrotate_db_version' (the uninstall fails to do this).
4. Re-install AdRotate
Posted 1 year ago #
@ Brownoxford: Odd but true :( I've updated the KB for it. Thanks for the heads up!
Posted 1 year ago #
I have used the charset trick. ;-)
And it runs. :-)
Yes the problem is the different charset versions of wordpress using in the past. I have wordpress installations that uses iso-8859-1 and utf-8 is the past.
So I have cleaned up my database to utf8, use utf8 in wp-config, delete adrotate_db_version and adrotate_config from wp_options table in db. Then I have upgrade from adrotate 2.6.1 to 3.0.3 without deleting adrotate tables in db or uninstall plugin.
Upgrade works fine! And all ads are available. No data lost.
This topic has been closed to new replies.
