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

Moderator: crythias

Post Reply
greinick
Znuny newbie
Posts: 14
Joined: 26 Apr 2021, 10:22
Znuny Version: 6.2.2
Real Name: GR

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

Post by 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
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

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

Post by root »

Hi,

Update or new installation?

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
Rikimaru
Znuny newbie
Posts: 21
Joined: 04 Jul 2017, 12:11
Znuny Version: 6.3.3
Real Name: Daniel

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

Post by Rikimaru »

Hello together,

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

Thanks in advance.

Kind Regards
Daniel
Rikimaru
Znuny newbie
Posts: 21
Joined: 04 Jul 2017, 12:11
Znuny Version: 6.3.3
Real Name: Daniel

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

Post by 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
Znuny expert
Posts: 280
Joined: 16 Apr 2016, 08:55
Znuny Version: see in post
Real Name: Hans
Contact:

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

Post by 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
Elected 2022-06 as an IT Governance Portal Expert. The portal for Znuny, OTRS and OTOBO users
root
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

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

Post by 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
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
Rikimaru
Znuny newbie
Posts: 21
Joined: 04 Jul 2017, 12:11
Znuny Version: 6.3.3
Real Name: Daniel

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

Post by 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
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

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

Post by root »

Hi,

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

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
greinick
Znuny newbie
Posts: 14
Joined: 26 Apr 2021, 10:22
Znuny Version: 6.2.2
Real Name: GR

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

Post by 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
Post Reply