After the last 3 upgrades the message started to come:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE only allows columns to be added that can contain nulls or have a DEFAULT definition specified. Column 'Data' cannot be added to table 'OfficeRichiesta' because it does not allow nulls and does not specify a DEFAULT definition

It apperars on first load of default.asp but not when you try a second time

Can this table be altered manually so that the message don't appear. Or is something else wrong?

I use MS SQL server

Original Message

| After the last 3 upgrades the message started to come:
| Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
|
| [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE only allows
| columns to be added that can contain nulls or have a DEFAULT definition
| specified. Column 'Data' cannot be added to table 'OfficeRichiesta' because
| it does not allow nulls and does not specify a DEFAULT definition
|
|Reply Message

In Table "OfficeRichiesta" of your database the field "Data" not is present. It not is common situation. In new release 2.58 we have change polulate procedure for re-create destroied field, but if you want can be solve the problem also now:

1) Do in Administrative area.
2) In "Tools" execute Copy of your principal database in database access backup.mdb. (It is empty database)
3) When the procedure done you find all your portal data in new database backup.mdb with correct structure.
4) In Tools select "Change Database" and select backup.mdb as principal database.
5) Now STOP IIS Admin Service or Restart Server. When the portal start no error are displayed.

If you want now you can delete all table in database.mdb, repair and compact database and do same process from backup.mdb to database.mdb for move data in original path.

Good Work.
Giuseppe Giardina
Support and Development
Store Portal Stuff.