Find Jobs
Hire Freelancers

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

$30-250 USD

Cancelado
Publicado hace más de 7 años

$30-250 USD

Pagado a la entrega
I have upgraded to a new WAMP installtion and it comes with MYSQL version 5.7.14 while the old version had 5.7.11 I get an error when trying to import two database in the new mysql with version 5.7.14: 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
ID del proyecto: 12642877

Información sobre el proyecto

12 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
12 freelancers están ofertando un promedio de $150 USD por este trabajo
Avatar del usuario
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 milestones Providing the following services ***********************Magento************************** O Magento Installation and Setup O Magento Theme Install and Customization O PSD to Magento O Magento Extension Development O Magento Web Design O Magento Custom Module Development O Magento Bug Fixes O Magento Support and Maintenance O Magento Upgrade Regards p4provider
$155 USD en 3 días
4,9 (120 comentarios)
7,6
7,6
Avatar del usuario
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 día
4,9 (253 comentarios)
7,2
7,2
Avatar del usuario
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 días
5,0 (157 comentarios)
6,1
6,1
Avatar del usuario
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 día
5,0 (36 comentarios)
6,3
6,3
Avatar del usuario
I am mysql dba having more then 10 yrs of experience
$35 USD en 1 día
5,0 (9 comentarios)
3,8
3,8
Avatar del usuario
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 construct them into a that all additional can follow.I Am enthusiastic dedicated and intelligent with WAMP installtion , I am online almost the time and i am very faster and quick worker. You can communication with me through massage I will replay within 5 minute, ---- Thanks For your time. John ( expert of WAMP installtion )
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de NORWAY
Strommen, Norway
5,0
49
Forma de pago verificada
Miembro desde oct 16, 2015

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.