Closed ansonphong closed 11 years ago
Phong,
We can't reproduce this issue,could you please send me the debug.log file located in: \wordpress\htdocs\wp-content or apache error logs? And let me know if you are using other plugins with postworld to make sure no conflicts occur.
I also removed some warnings that occurred during activation.
ok, I'll give this a try soon. for now this is low priority, although something to fix before it's finished.
On Thu, Oct 3, 2013 at 6:20 PM, hmikhail notifications@github.com wrote:
I also removed some warnings that occurred during activation.
— Reply to this email directly or view it on GitHubhttps://github.com/phongmedia/postworld/issues/26#issuecomment-25670958 .
i can still see postworld generate many characters on activation, also i am not sure if we are done with the warnings cleanup or not.
Nope, we haven't finished with the warning cleanup yet. There's a fair few of them.
Also I have disabled the postworld_debugger.php
from being included, since it's forcing some of the errors. The debugger should be set from within the wp_config.php
file.
@michelhabib , when I activate the plugin now, it doesn't generate any characters. Please confirm.
This is what i get in the log
[Sun Oct 27 12:07:21.433983 2013] [:error] [pid 4816:tid 1500] [client 127.0.0.1:51153] WordPress database error Can't write; duplicate key in table '#sql-9f4_b' for query ALTER TABLE `wp_postworld_a1`.`wp_postworld_user_meta` ADD CONSTRAINT `FK_wp_postworld_user_meta_wp_users` FOREIGN KEY (`user_id`) REFERENCES `wp_postworld_a1`.`wp_users` (`ID`) \r\n\t\t\t\t\t\tON DELETE cascade\r\n\t \t\t\t\t\tON UPDATE NO ACTION; made by activate_plugin, do_action('activate_postworld/postworld.php'), call_user_func_array, postworld_install_Foreign_keys, referer: http://localhost/wordpress/wp-admin/plugins.php?deactivate=true&plugin_status=all&paged=1&s=
[Sun Oct 27 12:07:21.434983 2013] [:error] [pid 4816:tid 1500] [client 127.0.0.1:51153] WordPress database error This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' for query CREATE TRIGGER `wp_postworld_post_points_AfterInsert` AFTER INSERT ON `wp_postworld_post_points` FOR EACH ROW update wp_postworld_post_meta set post_points = (select COALESCE(SUM(post_points),0) from wp_postworld_post_points where post_id = NEW.post_id) where post_id = NEW.post_id; made by activate_plugin, do_action('activate_postworld/postworld.php'), call_user_func_array, postworld_install_Triggers, referer: http://localhost/wordpress/wp-admin/plugins.php?deactivate=true&plugin_status=all&paged=1&s=
[Sun Oct 27 12:07:21.437983 2013] [:error] [pid 4816:tid 1500] [client 127.0.0.1:51153] WordPress database error This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' for query CREATE TRIGGER `wp_postworld_post_points_AfterDelete` AFTER DELETE ON `wp_postworld_post_points` FOR EACH ROW update wp_postworld_post_meta set post_points = (select COALESCE(SUM(post_points),0) from wp_postworld_post_points where post_id = OLD.post_id) where post_id = OLD.post_id; made by activate_plugin, do_action('activate_postworld/postworld.php'), call_user_func_array, postworld_install_Triggers, referer: http://localhost/wordpress/wp-admin/plugins.php?deactivate=true&plugin_status=all&paged=1&s=
[Sun Oct 27 12:07:21.439983 2013] [:error] [pid 4816:tid 1500] [client 127.0.0.1:51153] WordPress database error This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' for query CREATE TRIGGER `wp_postworld_post_points_AfterUpdate` AFTER UPDATE ON `wp_postworld_post_points` FOR EACH ROW update wp_postworld_post_meta set post_points = (select COALESCE(SUM(post_points),0) from wp_postworld_post_points where post_id = NEW.post_id) where post_id = NEW.post_id; made by activate_plugin, do_action('activate_postworld/postworld.php'), call_user_func_array, postworld_install_Triggers, referer: http://localhost/wordpress/wp-admin/plugins.php?deactivate=true&plugin_status=all&paged=1&s=
positive, i checked and the plugin activation generates no warnings now.
I think it's the result of MySQL errors, since when I turn off MySQL errors on various definitions, the number reduces.