Question Error when running MySql Script file in Dotnet installer

santhoshahp

New member
Joined
Dec 22, 2010
Messages
3
Programming Experience
Beginner
Dear Sir/Madam,

We are using NSIS to install an application. and we have a MySql Script file, which is using inside the installer class. This file is working with Mysql but not from the installer. This is giving a ERROR 42000 syntax error. Any help will be appreciated

Santhosha H P
 

jmcilhinney

VB.NET Forum Moderator
Staff member
Joined
Aug 17, 2004
Messages
14,372
Location
Sydney, Australia
Programming Experience
10+
Apparently you have a syntax error. That's all we can tell you from the information you've provided. To say more, we'd have to know what code you're executing in the script and the installer.
 

santhoshahp

New member
Joined
Dec 22, 2010
Messages
3
Programming Experience
Beginner
Dear jmcilhinney Thanks for your reply, We are using NSIS to install an application and the script file contains normal MySql Create Table syntax for example

delimiter $$
CREATE TABLE 'admin` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`server_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci$$


This script is executing in MySql query Browser but while installing the installer it is showing the following Error.

-------------------------------------ERROR-----------------------------------

2010/12/22 10:41:08,ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.47-community]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 'delimiter $$

CREATE TABLE `admin` (
`id` bigint(20) NOT NULL AUTO_INC' at line 1
 
Last edited:
Top Bottom