Announcement

Collapse
No announcement yet.

Upgrade error from V7.5 Multiuser

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Upgrade error from V7.5 Multiuser

    Hmmm

    Getting the following error message when I try to upgrade

    "Failed to run SQL statement

    ALTER TABLE [Product] ALTER COLUMN [Product Reference] TEXT(30)

    when upgrading - fatal error.
    Reported error was:

    Cannot change field 'Product Reference'. It is part of one or more relationships."

    Anyone come across this before

    We havent changed the underlying database in 7.5

    Jim
    www.tutor2u.net

    Smarta Marketing Firm of the Year 2011

    tutor2u on Facebook

    tutor2u on Twitter

    #2
    Anyone got any ideas?
    www.tutor2u.net

    Smarta Marketing Firm of the Year 2011

    tutor2u on Facebook

    tutor2u on Twitter

    Comment


      #3
      Hello Jim,

      Do you have any forms or table settings in the database that use the product reference field. Actinic trying to drop the field so that it can be recreated as a slightly larger field internally to cope with duplicate product references but it can't because something is relying on it.

      I've never seen this before, it's a bit weird.

      Regards,
      Jan Strassen, Mole End

      Comment

      Working...
      X