En cours

Dataimport error when moving to a new mysql version

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]:

Static analysis:

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)

SQL query:

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

Compétences : Linux, Magento, Nginx, Administration Système, Hébergement Web

Voir plus : mysql version control, mysql jsp data truncation error, java mysql connector data truncation error, mysql data truncation incorrect error tomcat, phpprobid mysql version, creload mysql version, cacti mysql version, convert mysql version, mysql version compatible php mvc framework, migrate version mysql version, cre loaded v615 mysql version, php mysql http 500 internal error, mysql version cre loaded, clickatells sms gateway support mysql version mysql

Concernant l'employeur :
( 43 commentaires ) Strommen, Norway

N° du projet : #12629932

Décerné à :

pdq

Ansatt av arbeidsgiveren

50 $ USD en 3 jours
(116 Commentaires)
5.8