CreateTables.sql sintax error problem

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
7/10/2006 7:21:49 AM
Ariel B. Vargas
Gravatar
Total Posts 4
View Posts

CreateTables.sql sintax error problem

Hi, when trying to execute 2CreateTables.sql on MSSQL I receive the following error:
Msg 170, Level 15, State 1, Line 10
Line 10: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 15
Line 15: Incorrect syntax near '('.

I assume that the error is near 'WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]'

Thanks for your help,
Regards
7/10/2006 7:33:48 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: CreateTables.sql sintax error problem

You don't mention which version of mojoportal you are using. I just tested the create table procs for both 2.1 and 1.03 and they both ran without errors for me on MS SQL 2005.

What version of MS SQL are you using?
7/10/2006 7:39:42 AM
Ariel B. Vargas
Gravatar
Total Posts 4
View Posts

Re: CreateTables.sql sintax error problem

Hi Joe: Thanks for your quick reply!

I'm using mojoportal 2.1 on MS SQL 2000.

Regards
7/10/2006 9:39:24 AM
Ariel B. Vargas
Gravatar
Total Posts 4
View Posts

Re: CreateTables.sql sintax error problem

Joe: The problem was that my MSSQL 2000 didn't have the SP4 applied. I installed it, and everything worked smoothly.

Thanks for your help!
Ariel
7/10/2006 10:18:08 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: CreateTables.sql sintax error problem

Excellent! Glad you are up and running.

Cheers,

Joe
7/16/2006 11:04:29 AM
Jan Hussaarts
Gravatar
Total Posts 73
View Posts

Re: CreateTables.sql sintax error problem

Hi all,

I tried to install 2.1 today. I am using SQLServer 2000 and encountered the same problems. I upgraded with SP4, but the problems stay.

When I remove the IGNORE_DUP_KEY = OFF, I get the message that sys.objects is an invalid objectname.

Joe, is the script only usable under SQLServer 2005? Ariel, are you sure you are running 2000 SP4?

 

7/16/2006 11:23:19 AM
Ariel B. Vargas
Gravatar
Total Posts 4
View Posts

Re: CreateTables.sql sintax error problem

Jan: Joe sent me an updated database creation script created for sql 2000. Besides having installed the SP4, you need a different script.

Kind Regards,
Ariel
7/16/2006 11:46:26 AM
Jan Hussaarts
Gravatar
Total Posts 73
View Posts

Re: CreateTables.sql sintax error problem

OK Ariel,

Can you send me the script for SQLServer 2000. Please send it to hussaarts@planet.nl

Thanks.

Jan

7/16/2006 12:16:29 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: CreateTables.sql sintax error problem

My bad, I thought after you installed sp4 that the original script worked.

I must have forgot to select the SQL 2000 compatibility option when generating the table script for the release.

I've updated svn branches/2.1.1
and the Novell Forge downloads for 2.1 release and src

with a script that is compatible in bothe MS SQL 2000 and 2005

Joe
7/16/2006 12:45:31 PM
Jan Hussaarts
Gravatar
Total Posts 73
View Posts

Re: CreateTables.sql sintax error problem

Hi Joe,

I downloaded both the new src-zip and the MSSQL release version on Novell Forge.

The scripts are the same; they still won't run under 2000.

Jan

7/17/2006 3:47:04 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: CreateTables.sql sintax error problem

Hi Jan,

The scripts on Novell forge should be the same as the one I sent to Ariel. I sent it also to you, yesterday, did it work for you?

Thanks,

Joe
You must sign in to post in the forums. This thread is closed to new posts.