syntax error in openemm.sql

[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 '∩╗â”

[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.

[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.

[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

[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

[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 ..."

[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

[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 '´╗â”

[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 ^^