#292 Unable to successfully run upgrade (MSSQL) script

data
closed-fixed
nobody
None
5
2003-05-10
2003-05-09
No

Michael,

There seems to be a problem with the 0.93 SQL
upgrade script, at least with MS SQL....

There is at least two problems...

1) Unknown data type INT4
2) Unable to index table account (table doesn't exist)

Here's the "messages" from the SQL server, after
running the upgrade script:

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(11 row(s) affected)

Server: Msg 2715, Level 16, State 7, Line 2
Column or parameter #31: Cannot find data type int4.
Server: Msg 1906, Level 11, State 1, Line 3
Cannot create an index on 'account', because this table
does not exist in database 'dcl_4_ppress'.

Instead of account did you mean: dcl_wo_account ??

Discussion

  • Logged In: YES
    user_id=6207

    Yep - darn copy/paste. Try the attached file.

     
  •  
    Attachments
  • This file is for Sybase. Use the other file for MSSQL

     
    Attachments
  • Logged In: YES
    user_id=6207

    Checked into CVS

     
    • status: open --> closed-fixed