Results 1 to 5 of 5

Thread: Server error: ALTER TABLE ALTER COLUMN failed

  1. #1
    barrandray is offline Member
    Join Date
    Apr 2007
    Posts
    7

    Default Server error: ALTER TABLE ALTER COLUMN failed

    I upgraded from d to e and a message came up warning of a manual requirement and an unstable database. I went to the logs and I have these errors:

    07/11/07 10:05:50,923 [2396] FATAL SugarCRM - SQL Server error: ALTER TABLE ALTER COLUMN failed because column 'test' does not exist in table 'temp'.
    07/11/07 10:05:50,923 [2396] FATAL SugarCRM - SQL Server error: ALTER TABLE ALTER COLUMN failed because column 'test' does not exist in table 'temp'.
    07/11/07 10:05:50,933 [2396] FATAL SugarCRM - ALTER TABLE DROP COLUMN failed because column 'test' does not exist in table 'temp'.: ALTER TABLE temp DROP COLUMN test
    07/11/07 10:05:50,933 [2396] FATAL SugarCRM - SQL Server error: ALTER TABLE DROP COLUMN failed because column 'test' does not exist in table 'temp'.

    We use SQL 2005 Express and
    Sugar Open Source Version 4.5.1e (Build 1049)

    I have another database to update but would like to inquire more about this prior. Thanks!

  2. #2
    julian's Avatar
    julian is offline Sugar Team Member
    Join Date
    Sep 2004
    Posts
    1,639

    Default Re: Server error: ALTER TABLE ALTER COLUMN failed

    Hello barrandray,

    Had you performed any customizations on your Sugar instance, or installed any 3rd-party modules before performing the d -> e upgrade? Thanks,
    Julian Ostrow
    Systems and Applications Engineer
    SugarCRM Inc.

  3. #3
    barrandray is offline Member
    Join Date
    Apr 2007
    Posts
    7

    Default Re: Server error: ALTER TABLE ALTER COLUMN failed

    Calendar Dashlet 1.2
    CRM Upgrades maps directions & more 5.0a
    Google Map 4.5 patch .01.5

    Are all installed and have been working quite well.

  4. #4
    barrandray is offline Member
    Join Date
    Apr 2007
    Posts
    7

    Default Re: Server error: ALTER TABLE ALTER COLUMN failed

    Hello:

    Do you have any idea what this problem is and what I can do to resolve (if I need to resolve it). I have another instance I would like to update but I am waiting for a response. Thank you for your time. - Barbara

    Quote Originally Posted by julian
    Hello barrandray,

    Had you performed any customizations on your Sugar instance, or installed any 3rd-party modules before performing the d -> e upgrade? Thanks,

  5. #5
    eggsurplus's Avatar
    eggsurplus is offline Sugar Community Member
    Join Date
    Dec 2005
    Location
    Minnesota
    Posts
    2,858

    Default Re: Server error: ALTER TABLE ALTER COLUMN failed

    The error looks like non-important sql that failed. Perhaps it was some test piece that got left in there? Either way, if everything works fine still I'd just ignore the message and not worry about it.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. problemi step 6 di SugarSuite-Full-4.0.1h
    By lucia in forum Italiano
    Replies: 0
    Last Post: 2006-12-27, 09:50 AM
  2. Replies: 1
    Last Post: 2006-09-11, 04:38 PM
  3. Fatal error: Max
    By spokes2k4 in forum Help
    Replies: 3
    Last Post: 2006-01-15, 04:50 PM
  4. SugarCrm 4.0 Patch
    By mgamboa in forum General Discussion
    Replies: 0
    Last Post: 2005-12-21, 05:14 PM
  5. Empty config.php at the end of install
    By aemadrid in forum Help
    Replies: 2
    Last Post: 2005-08-01, 07:29 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •