| Author |
Message |
spacy
Joined: 02 Nov 2009
Posts: 4
|
|
Hello,
i have a problem to run mysql -u root -p --database=xinco < /db/xinco_MySQL.sql.
It end's with this error:
ERROR 1064 (42000) at line 702: 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 '1, 1, 1, 1, now(), 'Creation!', 1, 0, 0, '')' at line 1
Could someone help me please ?!
My system - Ubuntu Karmic
Mysql - 5.1.37-1ubuntu5
EDIT
I have download xinco-2.00.05 at 02.11.2009
THX
spacy |
|
|
|
|
|
| |
    |
|
alex
Administrator
Age: 29
Joined: 19 Sep 2004
Posts: 535
Location: Remseck, Germany
|
|
We just found that error in the latest release.
Just replace the last lines of xinco_MySQL.sql with:
-- -----------------------------------------------------
-- Data for table `xinco`.`xinco_core_log`
-- -----------------------------------------------------
SET AUTOCOMMIT=0;
USE `xinco`;
INSERT INTO `xinco_core_log` VALUES (1, 1, 1, 1, now(), 'Creation!', 1, 0, 0, '');
INSERT INTO `xinco_core_log` VALUES (2, 2, 1, 1, now(), 'Creation!', 1, 0, 0, '');
COMMIT; |
|
|
|
|
|
   |
 |
|
spacy
Joined: 02 Nov 2009
Posts: 4
|
|
Cool,
Thx alex
Danke dir. Das ging ja supi schnell
gruß
spacy |
|
|
|
_________________
Ubuntu Karmic (32bit)
Mysql 5.1.37-1ubuntu5
tomcat6 6.0.20-2ubuntu2
Xinco 2.00.05 |
|
| |
|
|
|
|
|
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum
|
All times are GMT + 1 Hour
|
Calendar 
