.sql file error when uploading on the cpanel.
Posted by: wafs (154.70.36.---)
Date: December 23, 2017 09:20PM

My .sql file when i upload to another server, this error its brings export from wampserver


Error
Static analysis:
1 errors were found during analysis.
1. A closing bracket was expected. (near "winking smiley" at position 272)
SQL query:
-- -- Database: `p` -- -- -------------------------------------------------------- -- -- Table structure for table `xl805_assets` -- CREATE TABLE `xl805_assets` ( `id` int(10) UNSIGNED NOT NULL COMMENT 'Primary Key', `parent_id` int(11) NOT NULL DEFAULT '0'COMMENT )
MySQL said:
#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 ')' at line 14

Options: ReplyQuote
Re: .sql file error when uploading on the cpanel.
Posted by: Otomatic (Moderator)
Date: December 23, 2017 10:09PM

Hi,

Please : READ (and answer) BEFORE YOU ASK A QUESTION

What are the PhpMyAdmin version's for SQL export and SQL import ?

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.4 32 bit - Apache 2.4.35 - PHP 7.2.11/7.1.23/7.0.32/5.6.38 - MySQL 5.7.23 - MariaDB 10.3.10
Wampserver 3.1.4 64 bit - Apache 2.4.35 - PHP 7.2.11/7.1.23/7.0.32/5.6.38 - MySQL 5.7.23 - MariaDB 10.3.10
PhPMyadmin 4.8.3 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: .sql file error when uploading on the cpanel.
Posted by: wafs (154.70.36.---)
Date: December 24, 2017 02:19AM

Mysql version is 5.7.11

Options: ReplyQuote
Re: .sql file error when uploading on the cpanel.
Posted by: wafs (154.70.36.---)
Date: December 24, 2017 02:22AM

Mysql version is 5.7.11for export and import 5.6 though past versions didn't disturb when import or exporting database.

Options: ReplyQuote
Re: .sql file error when uploading on the cpanel.
Posted by: Otomatic (Moderator)
Date: December 24, 2017 10:14AM

Hi,

> NOT NULL DEFAULT '0'COMMENT
The errors occur because the exported data is incorrect. The problem is there is no space between the '0' and COMMENT and the rest of the table is not exported.
This is not a Wampserver problem, but an export and SQL file creation problem.

I think the server on which you exported SQL is running under Fedora and, it's a Fedora problem only.
See the bug report : Invalid sql with export import The problem is that Fedora packages do not use sqlparser shipped with phpMyAdmin, but some older version, which does have this bug (and many others).

The problem is that the package uses obsolete package:

Requires: php-composer(udan11/sql-parser) >= 3.4.0

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.4 32 bit - Apache 2.4.35 - PHP 7.2.11/7.1.23/7.0.32/5.6.38 - MySQL 5.7.23 - MariaDB 10.3.10
Wampserver 3.1.4 64 bit - Apache 2.4.35 - PHP 7.2.11/7.1.23/7.0.32/5.6.38 - MySQL 5.7.23 - MariaDB 10.3.10
PhPMyadmin 4.8.3 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote


Sorry, only registered users may post in this forum.