OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



get this error when import my sql manually

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
What to do if you have a technical problem with OJS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a development question, try the OJS Development subforum.

get this error when import my sql manually

Postby tarkhorani » Sun Jan 06, 2008 10:46 pm

get this error when import my sql manually
mysql ver 5

Code: Select all
Error
There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
----BEGIN CUT----
eNrtzV9rg0AMAPA836fIQx/10Kuuenu6OekK/pvnOuhL0doxobNOLbTffurXWAgJIfmFhHme5hID
GwOBUZhItFHg+slxmS6mBTCm99N0taslDr+XruyHc88vTcW77w59z/NRWNbGtGxzbaPlSUdI1z/g
6VFdx+P4gysWP/R7JNHlFhcbcxjLti77mn3oHFNtoNqGSWHgPpzefTYtxulhF0Vq9iyLlUTBbWu+
ZdlbNjMj1RIdPgVGTXu7s0glW4nn1ryNX6bHlm8B5BCCgmKqCK9Lp+BlSr1M7nCCKxyhhgqeCRMm
TJgwYcKECRMmTJjw/8R/wz9gyA==
----END CUT----
----BEGIN RAW----

ERROR: C1 C2 LEN: 1 2 3645
STR: �

SVN: $Id: sqlparser.lib.php 9889 2007-01-31 08:42:59Z cybot_tm $
MySQL: 5.0.27-standard
USR OS, AGENT, VER: Win MOZILLA 5.0
PMA: 2.10.0.2
PHP VER,OS: 4.4.4 Linux
LANG: en-utf-8
SQL: C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;

----END RAW----

SQL query:

C�R�E�A�T�E� �D�A�T�A�B�A�S�E� �x�c�o�_�d�b�;

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 'C' at line 1
tarkhorani
 
Posts: 91
Joined: Fri May 18, 2007 6:30 am

Re: get this error when import my sql manually

Postby smiri » Mon Jan 07, 2008 10:10 pm

Hi There,

could you please tell me exactly what you were trying to do when you got this error? I'm not sure what you mean by importing your mysql manually. Are you trying to upgrade your ojs?

Thanks,
smiri
 
Posts: 183
Joined: Thu Sep 06, 2007 7:01 pm


Return to OJS Technical Support

Who is online

Users browsing this forum: Bing [Bot], Yahoo [Bot] and 5 guests