I have upgraded to a new WAMP installtion and it comes with MYSQL version [url removed, login to view] while the old version had [url removed, login to view]
I get an error when trying to import two database in the new mysql with version [url removed, login to view]:
3 errors were found during analysis.
A comma or a closing bracket was expected. (near "`minutes`" at position 755)
Unexpected beginning of statement. (near "6" at position 876)
Unrecognized statement type. (near "NOT NULL" at position 879)
CREATE TABLE `wp_psp_post_planner_cron` ( `id` bigint(20) UNSIGNED NOT NULL, `id_post` bigint(20) NOT NULL, `post_to` text COLLATE utf8_unicode_ci, `post_to-page_group` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `post_privacy` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `email_at_post` enum('off','on') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'off', `status` smallint(1) NOT NULL DEFAULT '0', `response` text COLLATE utf8_unicode_ci, `started_at` timestamp NULL DEFAULT NULL, `ended_at` timestamp NULL DEFAULT NULL, `run_date` datetime DEFAULT NULL, `repeat_status` enum('off','on') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'off' COMMENT 'one-time | repeating', `repeat_interval` int(11) DEFAULT NULL COMMENT AS `minutes`, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `attempts` smallint(6) NOT NULL, `deleted` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS `minutes`,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDA' at line 14
I also have redis installed and running, located at c:\wamp\bin\redis\
Looks to work just fine, i just need to have someone verify that its actualy working correctly.
Using the older version of mysql is not really an options when there is a new version out. Thanks
13 freelance font une offre moyenne de $156 pour ce travail
I am a skilled server admin, i can help you on this. you can simply remove 'COMMENT AS `minutes`', it will import correcctly. let discuss more via private message, thanks.
Hello I have great command over mysql & WAMP installation . I hope my 7 year experienced skill help you to fix the bugs & i like to test complete module working fine or not . Please contact me Thank you