Error publishing ontology tables

albert_b

Hi,

We have two tables, “objects” and “pictures”, in our diffusion ontology that are not working properly, we are unable to publish anything.

Initially we got an error about a space character in the field “related_bibliography _data”. This field comes from the default "catalog" table in the "Tangible Heritage" diffusion group.

We removed the space character which resolved that error, but we still can't publish anything. Now it says that "web_masle.objects" and "web_masle.pictures" do not exist, even though these table aliases are defined in our ontology.

What can we do?

Thanks

PaCo

Hi @albert_b

That seems a specific MySQL error.
The Dédalo code is trying to insert a record into the database and the execution fails:

INSERT INTO $database_name.$table_name (".implode(',', $ar_field_name).") VALUES (".implode(',', $ar_field_value).");

You must to ensure that the current MySQL user has the privileges to access and create tables into the web_masle database.

For check it easily, you can install a database manager like Admin neo, phpMyAdmin, etc. and enter with the current Dédalo diffusion user to check if the user can access and create tables in the web_masle database.
If not, see the documentation in MYSQL privileges.

Remember that the MySQL/MariaDB config is from file:

/dedalo/config/config_db.php

The username and password are the same for every publication database that you use for publishing.

More info about in diffusion Diffusion documentation.

I hope this helps

Let me know how you got rid of this.

Best

albert_b

Hi Paco,

The privileges and configuration are correct. We haven't had any issues with the rest of the tables. The error only appears for these two table aliases, which depend on the default "catalog" table that previously had the incorrectly named field.

We're not sure how to proceed from here.

Thanks

cbrianso

Checkeing the error log, we found som errors, in create the objects o pictures table, the next error is showing
DEBUG_LOG [ERROR]
diffusion_mysql::exec_mysql_query database_name
database_name: web_masle
msg: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
connection error: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

Thanks

cbrianso

solved, we have created a table with the fields we need, and thus avoid the limitation imposed by mysql

Thanks

PaCo

OK, great!

What column was the problem ?

Alex

Seems that the filed_text is not enough to set the amount of information to be published. If you define a file_text that has a 65k characters limit, and you try to include a 70k or 100k characters, MySQL and MariaDB will stop the publication.

Posible solution:
Try to change it to field_medium in the ontology, and if you have lots of records published, you can change the mySQL/MariaDB column with a large type, as:

ALTER TABLE catalog 
MODIFY COLUMN related_bibliography_data MEDIUMTEXT;

Or you can delete the table catalog and re-publish all catalog records. It will recreate the table with the new configuration.

I hope it helps.

Best