Page 1 of 1
syntax error in openemm.sql
Posted: Thu Dec 13, 2007 8:23 pm
by kevin_s
I was doing a fresh install of OpenEMM 5.3.2 on Windows XP.
While running setup.bat, I received this message:
Database created, now setting up initial data, please enter again your database super user password:
Enter password: *******
ERROR 1064 (42000) at line 1 in file" 'USR_SHARE\openemm.sql': 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 '∩╗â”
Posted: Fri Dec 14, 2007 9:20 am
by maschoff
Right now we don't understand it either. I just checked the file and it looks fine. It uses Unix line breaks (/n) instead of Windows line breaks (/r/n), but this should not be a problem since MySQL is able to handle it.
I did it
Posted: Mon Dec 17, 2007 1:51 am
by alejo_up
I only delete the line break at the last of the first line and put together the second line with the first line.
Posted: Mon Dec 24, 2007 11:33 am
by ud
The openemm.sql script has some identification bytes at the beginning which may cause mysql to fail. To remove these bytes, you can use this command:
Code: Select all
dd if=openemm.sql of=openemm-correct.sql bs=1 skip=3
and use the file openemm-correct.sql instead of openemm.sql.
-- ud
Posted: Wed Feb 13, 2008 11:21 am
by chill
The openemm.sql script has some identification bytes at the beginning which may cause mysql to fail. To remove these bytes, you can use this command: Code:
dd if=openemm.sql of=openemm-correct.sql bs=1 skip=3
and use the file openemm-correct.sql instead of openemm.sql.
Sorry where i have to use the command and what should i do with openemm.sql only rename i dont really understand ?
thanks for helping out a super nap
Posted: Wed Feb 13, 2008 11:25 am
by maschoff
Alternatively, open file openemm.sql with a simple text editor and delete the first weird characters in the first line before the sequence "-- phpMyAdmin ..."
thx
Posted: Wed Feb 13, 2008 11:34 am
by chill
thx for such a fast reply:D here the first line of my openemm.sql file
(i dont think there are any weird chars) thanks for help again
-- phpMyAdmin SQL Dump
-- version 2.8.0.3
--
http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 23. Juni 2006 um 12:12
-- Server Version: 4.1.11
-- PHP-Version: 5.0.4
--
-- Datenbank: `openEMM`
--
-- --------------------------------------------------------
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `admin_group_permission_tbl`
--
CREATE TABLE `admin_group_permission_tbl` (
`admin_group_id` int(11) NOT NULL default '4',
`security_token` varchar(255) character set utf8 collate
Posted: Wed Feb 13, 2008 11:37 am
by chill
and i think i have the common error:
ERROR 1064 (42000) at line 1 in file: 'USR_SHARE\openemm.sql': You have an error
in your SQL syntax; check the manual that corresponds to your MySQL server vers
ion for the right syntax to use near '´╗â”
Posted: Wed Feb 13, 2008 11:39 am
by chill
i have erased the first line comeplete (all be4 create table) same error again
i have killed all Comments and still the same error it seems that i dont change anything with editing the file openemm.sql any idea?
ok i made some progress open openemm.swl with Word pad erased all be4 create table and he made the table but then the next error appears on next line
ah auch ein deutscher mein english suxort also
ich hab das problem gelöszt
1. die datei nicht mit notepad bearbeiten !!!
2. alle comments löschen (alles zwischen -- --)
dann solltet ihr keine probs damit haben ^^