Table 'otrsdb.acl_ticket_attribute_relations' doesn't exist, SQL: '

[greinick]

Hi,

on my znuny 6.2.2 Installation, I do get a lot of Table 'otrsdb.acl_ticket_attribute_relations' doesn't exist, SQL: ' messages.

Any hints or suggestion what might be wrong/broken/missing?

Thanks and regards . Götz

[root]

Hi,

Update or new installation?

- Roy

[Rikimaru]

Hello together,

i got the same issue, after update from 6.2 to 6.3.3 .

Thanks in advance.

Kind Regards
Daniel

[Rikimaru]

Hi,

i checked the DB structure and the table was missing. I've got it working by exporting
the table (empty) from our test installation and imported it to the live DB.

Can this cause any problems in future ? Currently we're not using any ACL's .

Thanks in advance.

Kind regards
Daniel

[hkais]

I would worry

databases are atomic & consistent (ACID)

If you have done an upgrade and things are missing, other things will be probably missing too

so you are building your data-based house on quicksand for the future.

Get back to your backup and rerun the migration and check why you have got an error during that

[root]

Hi,

This table is created during the migration vom 6.1 to 6.2 and part of the migration script. During execution of the migration script there is a step called 'Upgrade database structure'

- Roy

[Rikimaru]

Hi,

Thank's for the replies I've checked the migration script part as recomended and it's seems like
that this was the only change. Here by the import / export works fine for me .


Kind regards
Daniel

[root]

Hi,

Just follow the update instructions, and keep in mind that there is always a migration script which needs to be executed.

- Roy

[greinick]

Currently I'm on znuny 6.4.2 and saw that I still dont have that table.

Is there a best practice to add it? So just run the related migration Script part from the 6.2 update?

znuny-6.2.1/scripts/Migration/Znuny6_2/UpgradeDatabaseStructure/TicketAttributeRelations.pm

Or may I add that table by hand?

Regards . Götz