MonoX support board

Start the conversation, ask questions and share tips and solutions with fellow developers.

Non-registered users can only browse through our support boards. Please register now if you want to post your questions. It takes a second and it is completely free. Alternatively, you can log in without registration using your credentials at major sites such as Google, Microsoft Live, OpenId, Facebook, LinkedIn or Yahoo.

Installation issue: Incorrect syntax near '4'.  (Zatvorena) (Mono Support )

37471 put(a) pogledan, 12 odgovor(a) 5.5.2014. 22:37:30Kreirao(la) theAmazingZar
idrazic

idrazic

26.6.2014. 11:49:54
My guess would be that your database name starts with a "4".
Some of the install scripts don't have [] brackets around database name
So "USE 4real" would produce "Incorrect syntax near '4'."

You could replace in files (\MonoX\Installer\Sql\*.sql) all instances of "USE MonoX2;" to "USE [MonoX2]", or change database name to start with a letter.

Ocjena 5,00, 1 glas(ova). 
1384 Reputacija 152 Ukupno objava
theAmazingZar

theAmazingZar

5.5.2014. 22:39:14
I'm trying to test the most recent version of MonoX on a Windows 2003 Enterprise server, IIS 6, SQL Server 2005, and ASP.NET 4.0

After a few errors, I made sure all the file/folder permissions were taken care of... 

After a few more errors about the NT AUTHORITY/NETWORK SERVICE, I made sure that database access was taken care of... 

Now I get the following incorrect syntax error, and I'm stuck. Any ideas?

 
Ovaj sadržaj još nije ocijenjen. 
41 Reputacija 6 Ukupno objava
vzakanj

vzakanj

6.5.2014. 14:47:11
Hi TheAmazingZar,
could you profile your database queries during the installation using the SQL Server Profiler and post any possible errors here?

If not, you can try using the latest stable version (MonoX 4.9) and let me know if this issue still persists.

Regards,
Vedran
Ovaj sadržaj još nije ocijenjen. 
345 Reputacija 61 Ukupno objava
theAmazingZar

theAmazingZar

6.5.2014. 20:28:17
I'm not too familiar with SQL Server Profiler, but I am using MonoX 4.9.40.4907

Is this the correct version?
Ovaj sadržaj još nije ocijenjen. 
41 Reputacija 6 Ukupno objava
vzakanj

vzakanj

7.5.2014. 9:03:55
Oh, sorry, since you said 'most recent version' I was under the impression you were using one of the nightly builds.

We will try to reproduce this locally and I'll get back to you with more information.

Regards,
Vedran
Ovaj sadržaj još nije ocijenjen. 
345 Reputacija 61 Ukupno objava
vzakanj

vzakanj

8.5.2014. 9:30:19
I have tested this and it seems to be a bug in the install script password character encoding. I presume you have used special characters in your username or password (e.g. ').

To confirm this please try using a username and password which does not contain special characters (or you can just leave the password empty which should default it to 'admin') and let me know if this solves the issue.

I have logged a report and this will be resolved in future MonoX releases.

Regards,
Vedran

Ovaj sadržaj još nije ocijenjen. 
345 Reputacija 61 Ukupno objava
theAmazingZar

theAmazingZar

23.6.2014. 21:28:19
Nope, no special characters. 

I tried the entire installation over again on a different server (Win Server 2003, IIS6, MS Sql 2005), and got the same result: Incorrect syntax near '4'.

Can't seem to get past that part. 
Ovaj sadržaj još nije ocijenjen. 
41 Reputacija 6 Ukupno objava
theAmazingZar

theAmazingZar

23.6.2014. 21:34:36
Oh, and leaving the username / password blank also resulted in the same message. This is what keeps happening: 

2014-06-23 14:32:13Z: Installation starting ... 
2014-06-23 14:32:13Z: Creating database ... 
2014-06-23 14:32:22Z: Database created. 
2014-06-23 14:32:22Z: Importing data ... 
2014-06-23 14:32:22Z: Importing "aspnet_Applications" ... 
2014-06-23 14:32:22Z: Incorrect syntax near '4'. 
Ovaj sadržaj još nije ocijenjen. 
41 Reputacija 6 Ukupno objava
tihomir-kit

tihomir.kit

24.6.2014. 9:06:52
Have you tried installing the same version with same username and password on a different environment (a dev station - perhaps win7 or win8)?
Ovaj sadržaj još nije ocijenjen. 
526 Reputacija 43 Ukupno objava
theAmazingZar

theAmazingZar

24.6.2014. 16:07:05
Not yet. I guess I'll try that, then start stepping through the queries.. unless one of the developers wants to jump in and help? 
Ovaj sadržaj još nije ocijenjen. 
41 Reputacija 6 Ukupno objava
khorvat

khorvat

25.6.2014. 12:07:41
We will review and test in our environment and get back to you.

Regards
Ovaj sadržaj još nije ocijenjen. 
15993 Reputacija 2214 Ukupno objava
1 2