Opened 9 years ago

Closed 9 years ago

#599 closed bug (worksforme)

SQL error message. No date and other attributes are shown.

Reported by: jewgenij Owned by:
Priority: trivial Milestone:
Component: Core Version: 7.3
Keywords: Cc:

Description

On Uploading a new document, I filled a date. After that I've got the error message: Unknown column 'ld_pages' in 'field_list': SQL [n/a]; ...

I looked in the MYSQL database and didn't found the table "ld_pages".
I just updated from 7.1.3 to 7.3 also using the MYSQL upgrading scripts in the right order.

Change History (3)

comment:1 Changed 9 years ago by car031

  • Milestone 7.4 deleted
  • Priority changed from Major to Trivial
  • Resolution set to worksforme
  • Status changed from new to closed

The scripts adds that column, anyways you can add it by executing these commands against your database:

alter table ld_document add column ld_pages int not null default -1;
alter table ld_version add column ld_pages int not null default -1;

comment:2 Changed 9 years ago by jewgenij

  • Priority changed from Trivial to Blocker
  • Resolution worksforme deleted
  • Status changed from closed to reopened

I executed the SQL commands. Now the tab "History" is shown.
These commands are definitely not in the upgrade.mysql.sql scripts! Maybe there are more missing. I get another error message on uploading a new document. The other thing is, that additional attributes are still not shown (no date, author and so on...).

comment:3 Changed 9 years ago by car031

  • Priority changed from Blocker to Trivial
  • Resolution set to worksforme
  • Status changed from reopened to closed

This thread will be follows by the support team at support@…. If you are a customer please write an email to them putting the following informations:

  • Your UserNo?(license number)
  • What upgrade packages have you executed
  • What is your actual logicaldoc version

This threas is closed here, please leave this closed

Note: See TracTickets for help on using tickets.