Dataimport error when moving to a new mysql version - open to bidding
$30-250 USD
Abgesagt
Veröffentlicht vor mehr als 7 Jahren
$30-250 USD
Bezahlt bei Lieferung
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
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
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
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.
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 )