Annulé

Dataimport error when moving to a new mysql version - open to bidding

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 :

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

N° du projet : #12642877

13 freelance ont fait une offre moyenne de 156 $ pour ce travail

p4provider

Hello, Here are Magento Experts , 1. Easy access on IMs like Gtalk, Skype, Yahoo and MSN 2. Excellent Communication Skills 3. Immediate response to concerns and queries 4. Payments linked to delivery mileston Plus

155 $ USD en 3 jours
(116 Commentaires)
7.5
hardikmemagara

Hello Sir, I have gone through your requirements in brief and understand your idea and preference for job as you are looking for. I have more than 5+ years of experience in Magento. I have developed more than 100 w Plus

178 $ USD en 2 jours
(357 Commentaires)
7.1
TakeReal

Hello, My name is Sergey. I am Freelancer from [url removed, login to view], Russia. I can help you as SQL expert to move your database to MYSQL version 5.7.14 And make sure it working without errors. This is list of various Plus

150 $ USD en 3 jours
(407 Commentaires)
6.6
tlchung

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.

155 $ USD en 3 jours
(90 Commentaires)
5.7
bdsiddhi

Hi, Greetings !! We are a team of 35 full time, dedicated developers having expertise on native iOS & Android app development, Core PHP, Joomla, Magento, Wordpress, Moodle, Expression Engine, Prestashop, OpenCart, Plus

505 $ USD en 10 jours
(6 Commentaires)
5.9
rinsadsl

Hi there I can sort this issue immediately via Teamviewer. I have a great track record here. Looking forward to work with you. Thanks Rinsad

84 $ USD en 0 jours
(25 Commentaires)
5.6
extreamcode

HI, I can assist you with this Project. Here is a sampling of the few of my work contained at my portfolio: [url removed, login to view] I highly value professionalism and hold myself strictly accountable Plus

155 $ USD en 3 jours
(16 Commentaires)
5.7
scriptphp87

Hello, I'm a professional programmer for web programming with php language to build the system website, Besides, I'm also expert in MySQL , HTML,HTML5,CSS, JS I'm always top in Vietnam freelancer [url removed, login to view] Plus

155 $ USD en 3 jours
(34 Commentaires)
6.1
ambientinfotech

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

100 $ USD en 1 jour
(14 Commentaires)
3.6
infinitydot

Hi, Hope you are doing great. I have 5+ years of experience in wordpress,Megento,Php,Software architecture,Webite Desgning,HTML,CSS,Graphic designing.I have understood your requirement and i am very much confident tha Plus

55 $ USD en 1 jour
(5 Commentaires)
2.9
vinaysinghh

I am mysql dba having more then 10 yrs of experience

35 $ USD en 1 jour
(5 Commentaires)
3.1
nima0938843

Greeting !-- i can do it in 24 hour full project. i have been through your requirement and I have read it your full job post very carefully, to complete your initial project i would review your existing assets and Plus

155 $ USD en 3 jours
(0 Commentaires)
0.0
225 $ USD en 3 jours
(0 Commentaires)
0.0
junaidgulzar0786

I read through the job details extremely carefully and I am absolutely sure that I can do the project very well.

77 $ USD en 0 jours
(0 Commentaires)
0.0