| 
Daisy - General

Problem saving documents

View: New views
3 Messages — Rating Filter:   Alert me  

Problem saving documents

by Tim McDonald-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi

After upgrading from one of the 2.3 preview releases to the final version of 2.3 I'm experiencing problems saving documents. I get the following error:

Error
Sitemap: error calling continuation
Received exception from repository server.
Problem storing document.
Column 'liveversion_id' cannot be null

Using MySQL to have a quick poke about the database it seems to have the correct schema version:

mysql> SELECT * FROM daisy_system;
+---------------------+-----------+
| propname            | propvalue |
+---------------------+-----------+
| jbpm_schema_version | 3.2       |
| schema_version      | 2.3       |
+---------------------+-----------+

but I'm guessing some of the values in the 'Null' column in this table are incorrect:

mysql> DESCRIBE document_variants;
+------------------------------+--------------+------+-----+---------+-------+
| Field                        | Type         | Null | Key | Default | Extra |
+------------------------------+--------------+------+-----+---------+-------+
| doc_id                       | bigint(20)   | NO   | PRI | NULL    |       |
| ns_id                        | bigint(20)   | NO   | PRI | NULL    |       |
| branch_id                    | bigint(20)   | NO   | PRI | NULL    |       |
| lang_id                      | bigint(20)   | NO   | PRI | NULL    |       |
| link_search                  | varchar(100) | NO   | MUL | NULL    |       |
| variant_search               | varchar(100) | NO   | MUL | NULL    |       |
| doctype_id                   | bigint(20)   | NO   | MUL | NULL    |       |
| retired                      | char(1)      | NO   |     | NULL    |       |
| lastversion_id               | bigint(20)   | NO   |     | NULL    |       |
| liveversion_id               | bigint(20)   | NO   |     | NULL    |       |
| last_major_change_version_id | bigint(20)   | YES  |     | NULL    |       |
| live_major_change_version_id | bigint(20)   | YES  |     | NULL    |       |
| last_modified                | datetime     | NO   |     | NULL    |       |
| last_modifier                | bigint(20)   | NO   | MUL | NULL    |       |
| updatecount                  | bigint(20)   | NO   |     | NULL    |       |
| created_from_branch_id       | bigint(20)   | NO   |     | NULL    |       |
| created_from_lang_id         | bigint(20)   | NO   |     | NULL    |       |
| created_from_version_id      | bigint(20)   | NO   |     | NULL    |       |
+------------------------------+--------------+------+-----+---------+-------+

Any idea where I've gone wrong and if directly editing this table is likely to fix it?

Cheers

Tim



_______________________________________________
daisy community mailing list
Professional Daisy support: http://outerthought.org/en/services/daisy/support.html
mail to: daisy@...
list information: http://lists.cocoondev.org/mailman/listinfo/daisy

Re: Problem saving documents

by Freya Impens-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

did you execute the daisy-2_2-to-2_3.sql script?

In this script there's two lines that should do the trick:

alter table `document_variants` change column `liveversion_id` `liveversion_id` bigint(20) default NULL;
update document_variants set `liveversion_id` = NULL where `liveversion_id` = -1;

regards Freya


Tim McDonald schreef:
Hi

After upgrading from one of the 2.3 preview releases to the final version of 2.3 I'm experiencing problems saving documents. I get the following error:

Error
Sitemap: error calling continuation
Received exception from repository server.
Problem storing document.
Column 'liveversion_id' cannot be null

Using MySQL to have a quick poke about the database it seems to have the correct schema version:

mysql> SELECT * FROM daisy_system;
+---------------------+-----------+
| propname            | propvalue |
+---------------------+-----------+
| jbpm_schema_version | 3.2       |
| schema_version      | 2.3       |
+---------------------+-----------+

but I'm guessing some of the values in the 'Null' column in this table are incorrect:

mysql> DESCRIBE document_variants;
+------------------------------+--------------+------+-----+---------+-------+
| Field                        | Type         | Null | Key | Default | Extra |
+------------------------------+--------------+------+-----+---------+-------+
| doc_id                       | bigint(20)   | NO   | PRI | NULL    |       |
| ns_id                        | bigint(20)   | NO   | PRI | NULL    |       |
| branch_id                    | bigint(20)   | NO   | PRI | NULL    |       |
| lang_id                      | bigint(20)   | NO   | PRI | NULL    |       |
| link_search                  | varchar(100) | NO   | MUL | NULL    |       |
| variant_search               | varchar(100) | NO   | MUL | NULL    |       |
| doctype_id                   | bigint(20)   | NO   | MUL | NULL    |       |
| retired                      | char(1)      | NO   |     | NULL    |       |
| lastversion_id               | bigint(20)   | NO   |     | NULL    |       |
| liveversion_id               | bigint(20)   | NO   |     | NULL    |       |
| last_major_change_version_id | bigint(20)   | YES  |     | NULL    |       |
| live_major_change_version_id | bigint(20)   | YES  |     | NULL    |       |
| last_modified                | datetime     | NO   |     | NULL    |       |
| last_modifier                | bigint(20)   | NO   | MUL | NULL    |       |
| updatecount                  | bigint(20)   | NO   |     | NULL    |       |
| created_from_branch_id       | bigint(20)   | NO   |     | NULL    |       |
| created_from_lang_id         | bigint(20)   | NO   |     | NULL    |       |
| created_from_version_id      | bigint(20)   | NO   |     | NULL    |       |
+------------------------------+--------------+------+-----+---------+-------+

Any idea where I've gone wrong and if directly editing this table is likely to fix it?

Cheers

Tim



_______________________________________________
daisy community mailing list
Professional Daisy support: http://outerthought.org/en/services/daisy/support.html
mail to: daisy@...
list information: http://lists.cocoondev.org/mailman/listinfo/daisy


_______________________________________________
daisy community mailing list
Professional Daisy support: http://outerthought.org/en/services/daisy/support.html
mail to: daisy@...
list information: http://lists.cocoondev.org/mailman/listinfo/daisy

Re: Problem saving documents

by Tim McDonald-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Running the commands from the script fixed the problem appropriate commands from the script fixed the problems. 

For the record, the daisy-2_2-to-2_3.sql script commands appeared to have been run up until the set of eight command that altered the document_variant table. Running these in the sql console fixed everything.

Many Thanks

Tim


On 5 Aug 2009, at 12:37, Freya Impens wrote:

Hi,

did you execute the daisy-2_2-to-2_3.sql script?

In this script there's two lines that should do the trick:

alter table `document_variants` change column `liveversion_id` `liveversion_id` bigint(20) default NULL;
update document_variants set `liveversion_id` = NULL where `liveversion_id` = -1;

regards Freya


Tim McDonald schreef:
Hi

After upgrading from one of the 2.3 preview releases to the final version of 2.3 I'm experiencing problems saving documents. I get the following error:

Error
Sitemap: error calling continuation
Received exception from repository server.
Problem storing document.
Column 'liveversion_id' cannot be null

Using MySQL to have a quick poke about the database it seems to have the correct schema version:

mysql> SELECT * FROM daisy_system;
+---------------------+-----------+
| propname            | propvalue |
+---------------------+-----------+
| jbpm_schema_version | 3.2       |
| schema_version      | 2.3       |
+---------------------+-----------+

but I'm guessing some of the values in the 'Null' column in this table are incorrect:

mysql> DESCRIBE document_variants;
+------------------------------+--------------+------+-----+---------+-------+
| Field                        | Type         | Null | Key | Default | Extra |
+------------------------------+--------------+------+-----+---------+-------+
| doc_id                       | bigint(20)   | NO   | PRI | NULL    |       |
| ns_id                        | bigint(20)   | NO   | PRI | NULL    |       |
| branch_id                    | bigint(20)   | NO   | PRI | NULL    |       |
| lang_id                      | bigint(20)   | NO   | PRI | NULL    |       |
| link_search                  | varchar(100) | NO   | MUL | NULL    |       |
| variant_search               | varchar(100) | NO   | MUL | NULL    |       |
| doctype_id                   | bigint(20)   | NO   | MUL | NULL    |       |
| retired                      | char(1)      | NO   |     | NULL    |       |
| lastversion_id               | bigint(20)   | NO   |     | NULL    |       |
| liveversion_id               | bigint(20)   | NO   |     | NULL    |       |
| last_major_change_version_id | bigint(20)   | YES  |     | NULL    |       |
| live_major_change_version_id | bigint(20)   | YES  |     | NULL    |       |
| last_modified                | datetime     | NO   |     | NULL    |       |
| last_modifier                | bigint(20)   | NO   | MUL | NULL    |       |
| updatecount                  | bigint(20)   | NO   |     | NULL    |       |
| created_from_branch_id       | bigint(20)   | NO   |     | NULL    |       |
| created_from_lang_id         | bigint(20)   | NO   |     | NULL    |       |
| created_from_version_id      | bigint(20)   | NO   |     | NULL    |       |
+------------------------------+--------------+------+-----+---------+-------+

Any idea where I've gone wrong and if directly editing this table is likely to fix it?

Cheers

Tim



_______________________________________________
daisy community mailing list
Professional Daisy support: http://outerthought.org/en/services/daisy/support.html
mail to: daisy@...
list information: http://lists.cocoondev.org/mailman/listinfo/daisy

_______________________________________________
daisy community mailing list
Professional Daisy support: http://outerthought.org/en/services/daisy/support.html
mail to: daisy@...
list information: http://lists.cocoondev.org/mailman/listinfo/daisy


_______________________________________________
daisy community mailing list
Professional Daisy support: http://outerthought.org/en/services/daisy/support.html
mail to: daisy@...
list information: http://lists.cocoondev.org/mailman/listinfo/daisy
Free embeddable forum powered by Nabble Forum Help