Table 'otrs.virtual_fs' doesn't exist

Moderator: crythias

Post Reply
aqueel
Znuny newbie
Posts: 14
Joined: 19 Nov 2014, 12:22
Znuny Version: otrs 3.0
Real Name: AQUEEL
Company: AMANA

Table 'otrs.virtual_fs' doesn't exist

Post by aqueel »

Hi Friends,

Can some one help me!

I have migrated otrs 3.0.6 to 3.1.21. After migration upgaraded ITSM 3.1.10.

Test has been perfomed on virtual machine. Everything works fine but when adding NEW CMDB ITEM it gives this error below
No Definition was defined for class 357!
Nov 19 14:39:09 eti-helpdesk OTRS-CGI-10[28421]: [Error][Kernel::System::VirtualFS::Find][Line:435]: Table 'otrs.virtual_fs' doesn't exist, SQL: 'SELECT vfs.filename, vfsp.preferences_key, vfsp.preferences_value FROM virtual_fs vfs , virtual_fs_preferences vfsp WHERE vfs.id = vfsp.virtual_fs_id AND ((vfsp.preferences_key = ? AND vfsp.preferences_value = ?))'

Need urgent help

Thanks
Aqueel
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Table 'otrs.virtual_fs' doesn't exist

Post by jojo »

For urgent help buy professional services. Also you should upgrade to the latest version (3.3.10)
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
aqueel
Znuny newbie
Posts: 14
Joined: 19 Nov 2014, 12:22
Znuny Version: otrs 3.0
Real Name: AQUEEL
Company: AMANA

Re: Table 'otrs.virtual_fs' doesn't exist

Post by aqueel »

Thanks jojo for the advice. I have just asked for help if some one can help me it would be great.
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Table 'otrs.virtual_fs' doesn't exist

Post by jojo »

you asked for urgent help. Also it seems that you missed some migration step (or got an error during migration). Go back to your current version (backup) and redo migration
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
aqueel
Znuny newbie
Posts: 14
Joined: 19 Nov 2014, 12:22
Znuny Version: otrs 3.0
Real Name: AQUEEL
Company: AMANA

Re: Table 'otrs.virtual_fs' doesn't exist

Post by aqueel »

Thank you very much Jojo here is there error.

Migration started...

Step 1 of 13: Refresh configuration cache...
If you see warnings about 'Subroutine Load redefined', that's fine, no need to w orry!
[Thu Nov 20 12:13:20 2014] DBUpdate-to-3.3.pl: Subroutine Load redefined at /opt /otrs/Kernel/Config/Files/ZZZAAuto.pm line 7.
[Thu Nov 20 12:13:20 2014] DBUpdate-to-3.3.pl: Subroutine Load redefined at /opt /otrs/Kernel/Config/Files/ZZZAuto.pm line 7.
done.

Step 2 of 13: Check framework version... done.

Step 3 of 13: Generate MessageID md5sums... done.

Step 4 of 13: Migrate old settings... done.

Step 5 of 13: Migrate OTRSExternalTicketNumberRecognition... done.

Step 6 of 13: Checking Standard Template table columns...
Check if 'template_type' columns exists.
'template_type' column exists, set new default value.
ALTER TABLE standard_template CHANGE template_type template_type VARCHAR (100) N ULL
ALTER TABLE standard_template ALTER template_type DROP DEFAULT
UPDATE standard_template SET template_type = 'Answer' WHERE template_type IS NUL L
ALTER TABLE standard_template CHANGE template_type template_type VARCHAR (100) D EFAULT 'Answer' NOT NULL
done.

Step 7 of 13: Updating Queue Standard Template relations table...
Cleaning queue_standard_template table
Creating new Foreign Keys for queue_standard_template table

--- Note: ---
If you have already run this script before then the Foreign Keys are already set and you might see errors regarding 'duplicate key' or 'constrain already exists ', that's fine, no need to worry!
---

ALTER TABLE queue_standard_template ADD CONSTRAINT FK_queue_standard_template_st andard_template_id_id FOREIGN KEY (standard_template_id) REFERENCES standard_tem plate (id)
[Thu Nov 20 12:13:32 2014] DBUpdate-to-3.3.pl: DBD::mysql::db do failed: Can't c reate table 'otrs.#sql-6ce8_13b' (errno: 121) at /opt/otrs/Kernel/System/DB.pm l ine 499.
ERROR: OTRS-DBUpdate-to-3.3-10 Perl: 5.10.1 OS: linux Time: Thu Nov 20 12:13:32 2014

Message: Can't create table 'otrs.#sql-6ce8_13b' (errno: 121), SQL: 'ALTER TABL E queue_standard_template ADD CONSTRAINT FK_queue_standard_template_standard_tem plate_id_id FOREIGN KEY (standard_template_id) REFERENCES standard_template (id) '

Traceback (32595):
Module: main::_AddQueueStandardTemplateForeignKeys (unknown version) Line: 55 7
Module: ./DBUpdate-to-3.3.pl (unknown version) Line: 133

ERROR: OTRS-DBUpdate-to-3.3-10 Perl: 5.10.1 OS: linux Time: Thu Nov 20 12:13:32 2014

Message: Error during execution of 'ALTER TABLE queue_standard_template ADD CON STRAINT FK_queue_standard_template_standard_template_id_id FOREIGN KEY (standard _template_id) REFERENCES standard_template (id)'!

Traceback (32595):
Module: main::_AddQueueStandardTemplateForeignKeys (unknown version) Line: 55 9
Module: ./DBUpdate-to-3.3.pl (unknown version) Line: 133

done.

Step 8 of 13: Migrate OTRSGenericStandardTemplates... done.

Step 9 of 13: Checking if ACL tables already exist... Check if ACL table exists.
ACL tables are present, no need to create them.
done.

Step 10 of 13: Uninstall Merged Feature Add-Ons... done.

Step 11 of 13: Delete the files that are not longer needed... done.

Step 12 of 13: Clean up the cache... done.

Step 13 of 13: Refresh configuration cache another time...
If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry!
[Thu Nov 20 12:13:38 2014] DBUpdate-to-3.3.pl: Subroutine Load redefined at /opt/otrs/Kernel/Config/Files/ZZZAAuto.pm line 7.
[Thu Nov 20 12:13:38 2014] DBUpdate-to-3.3.pl: Subroutine Load redefined at /opt/otrs/Kernel/Config/Files/ZZZAuto.pm line 7.
done.

Migration completed!


Appreciate your help.

Thanks
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Table 'otrs.virtual_fs' doesn't exist

Post by crythias »

change your tables bin/otrs.MySQLInnoDBSwitch.pl

As always, back up your database before making changes. Your data is your responsibility.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
aqueel
Znuny newbie
Posts: 14
Joined: 19 Nov 2014, 12:22
Znuny Version: otrs 3.0
Real Name: AQUEEL
Company: AMANA

Re: Table 'otrs.virtual_fs' doesn't exist

Post by aqueel »

Crythias thanks for response ,Changed successfully but not wroking, can you please guide me hot to manually create otrs.virtual_fs table in otrs database?

Thanks
Aqueel
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Table 'otrs.virtual_fs' doesn't exist

Post by crythias »

The second post of migration has nothing to do with virtual_fs. It has to do with InnoDB. Assuming that worked, the migration should complete successfully (All the Foreign Key stuff).

However, I don't understand why 3.0 you tried to update to 3.3

Nothing about this topic makes sense.

3.0 -> 3.1.latest -> 3.2.latest -> 3.3.latest
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
aqueel
Znuny newbie
Posts: 14
Joined: 19 Nov 2014, 12:22
Znuny Version: otrs 3.0
Real Name: AQUEEL
Company: AMANA

Re: Table 'otrs.virtual_fs' doesn't exist

Post by aqueel »

Thanks crythias,

I have tried all 3.0> 3.1 lates> 3.2 latest> 3.3 lates

My exact problem is after updating ITSM package i am getting log otr.virtual_fs doesn't exists when i add or edit asset in CMDB. please help .

Thanks
Aqueel
aqueel
Znuny newbie
Posts: 14
Joined: 19 Nov 2014, 12:22
Znuny Version: otrs 3.0
Real Name: AQUEEL
Company: AMANA

Re: Table 'otrs.virtual_fs' doesn't exist

Post by aqueel »

Hi Friends

somebody please help!
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Table 'otrs.virtual_fs' doesn't exist

Post by jojo »

virtual_fs was introduced with OTRS 3.0. So you might need to mainupulate the databae directly to have the table
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
aqueel
Znuny newbie
Posts: 14
Joined: 19 Nov 2014, 12:22
Znuny Version: otrs 3.0
Real Name: AQUEEL
Company: AMANA

Re: Table 'otrs.virtual_fs' doesn't exist

Post by aqueel »

Can you help me how to create these tables manually i will be thank for to you and thanks for ongoing help.
reneeb
Znuny guru
Posts: 5018
Joined: 13 Mar 2011, 09:54
Znuny Version: 6.0.x
Real Name: Renée Bäcker
Company: Perl-Services.de
Contact:

Re: Table 'otrs.virtual_fs' doesn't exist

Post by reneeb »

Login to your mysql database:

Code: Select all

mysql -u otrs -p -h localhost otrs
(user and password can be found in Kernel/Config.pm)

Code: Select all

CREATE TABLE virtual_fs (
id BIGINT NOT NULL AUTO_INCREMENT,
filename TEXT NOT NULL,
backend VARCHAR (60) NOT NULL,
backend_key VARCHAR (160) NOT NULL,
create_time DATETIME NOT NULL,
PRIMARY KEY(id),
INDEX virtual_fs_backend (backend(60)),
INDEX virtual_fs_filename (filename(255))
);
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
aqueel
Znuny newbie
Posts: 14
Joined: 19 Nov 2014, 12:22
Znuny Version: otrs 3.0
Real Name: AQUEEL
Company: AMANA

Re: Table 'otrs.virtual_fs' doesn't exist

Post by aqueel »

Thank you very much RENEEB. now able to create vitual_fs table

Nov 19 14:39:09 eti-helpdesk OTRS-CGI-10[28421]: [Error][Kernel::System::VirtualFS::Find][Line:435]: Table 'otrs.virtual_fs' doesn't exist, SQL: 'SELECT vfs.filename, vfsp.preferences_key, vfsp.preferences_value FROM virtual_fs vfs , virtual_fs_preferences vfsp WHERE vfs.id = vfsp.virtual_fs_id AND ((vfsp.preferences_key = ? AND vfsp.preferences_value = ?))'

any idea about vfsp.preferences and error. i am migrating from 3.0 to 4.0 (ofcourse step by stop 3.0,3.1,3.2...)
aqueel
Znuny newbie
Posts: 14
Joined: 19 Nov 2014, 12:22
Znuny Version: otrs 3.0
Real Name: AQUEEL
Company: AMANA

Re: Table 'otrs.virtual_fs' doesn't exist

Post by aqueel »

Hi,
Reneeb thanks for you support. Please help

After creating virtual_fs and virtual_fs_preferences tables i am able to add CMDB items thanks

Now i am getting below error

Dec 3 11:08:36 eti-helpdesk OTRS-CGI-10[8629]: [Error][Kernel::System::VirtualFS::Write][Line:257]: Unknown column 'virtual_fs_id' in 'field list', SQL: 'INSERT INTO virtual_fs_preferences (virtual_fs_id, preferences_key, preferences_value) VALUES ( ?, ?, ?)'
Dec 3 11:08:36 eti-helpdesk OTRS-CGI-10[8629]: [Error][Kernel::System::ITSMConfigItem::ConfigItemAttachmentAdd][Line:616]: Cannot add attachment for config item 2349

I am not able to attach file to CMDB item old or new same.

Thanks for your support
Andre Bauer
Znuny guru
Posts: 2189
Joined: 08 Dec 2005, 17:01
Znuny Version: 5.0.x
Real Name: André Bauer
Company: Magix Software GmbH
Location: Dresden
Contact:

Re: Table 'otrs.virtual_fs' doesn't exist

Post by Andre Bauer »

Maybe you forgot to run the db update script?

https://otrs.github.io/doc/manual/admin ... ading.html
Prod: Ubuntu Server 16.04 / Zammad 1.2

DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!

OtterHub.org
aqueel
Znuny newbie
Posts: 14
Joined: 19 Nov 2014, 12:22
Znuny Version: otrs 3.0
Real Name: AQUEEL
Company: AMANA

Re: Table 'otrs.virtual_fs' doesn't exist

Post by aqueel »

Dear Andre thanks for your help

I have run all migration scripts required. its the same. i am not able attach any file to cmdb items.

Thanks
aqueel
Znuny newbie
Posts: 14
Joined: 19 Nov 2014, 12:22
Znuny Version: otrs 3.0
Real Name: AQUEEL
Company: AMANA

Re: Table 'otrs.virtual_fs' doesn't exist

Post by aqueel »

Any body can help me please when adding attachement to CMDB i am getting this error

Error Message: Cannot add attachment for config item 2220


Backend ERROR: OTRS-CGI-10 Perl: 5.10.1 OS: linux Time: Thu Dec 4 15:33:27 2014 Message: Cannot add attachment for config item 2220 RemoteAddress: 192.168.0.20 RequestURI: /otrs/index.pl Traceback (13328): Module: Kernel::System::ITSMConfigItem::ConfigItemAttachmentAdd (v1.39.2.1) Line: 616 Module: Kernel::Modules::AgentITSMConfigItemEdit::Run (v1.41) Line: 356 Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.16) Line: 863 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41 Module: (eval) (v1.99) Line: 206 Module: ModPerl::RegistryCooker::run (v1.99) Line: 206 Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 172 Module: ModPerl::Registry::handler (v1.99) Line: 31

in tail -f /var/log/messages

Dec 4 15:35:36 eti-helpdesk OTRS-CGI-10[13326]: [Error][Kernel::System::VirtualFS::Find][Line:430]: Unknown column 'vfsp.preferences_key' in 'field list', SQL: 'SELECT vfs.filename, vfsp.preferences_key, vfsp.preferences_value FROM virtual_fs vfs , virtual_fs_preferences vfsp WHERE vfs.id = vfsp.virtual_fs_id AND ((vfsp.preferences_key = ? AND vfsp.preferences_value = ?))'
Dec 4 15:35:36 eti-helpdesk OTRS-CGI-10[13326]: [Error][Kernel::System::VirtualFS::Write][Line:214]: File already exists 'ConfigItem/2220/weekly_report_Created_nov 24-30.pdf'!
Dec 4 15:35:36 eti-helpdesk OTRS-CGI-10[13326]: [Error][Kernel::System::ITSMConfigItem::ConfigItemAttachmentAdd][Line:616]: Cannot add attachment for config item 2220
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Table 'otrs.virtual_fs' doesn't exist

Post by jojo »

you seem to require professional services.
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
aqueel
Znuny newbie
Posts: 14
Joined: 19 Nov 2014, 12:22
Znuny Version: otrs 3.0
Real Name: AQUEEL
Company: AMANA

Re: Table 'otrs.virtual_fs' doesn't exist

Post by aqueel »

Thanks jojo for your advice but i am very near to solve this issue.

I am able to edit and add new CMDB items and everything working fine only when adding Attachement i am getting this error. i will be thankfull if you give some idea.

Thanks
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Table 'otrs.virtual_fs' doesn't exist

Post by jojo »

it seems that not all needed tables are existent (which might happen if one of the migrations failed)
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
aqueel
Znuny newbie
Posts: 14
Joined: 19 Nov 2014, 12:22
Znuny Version: otrs 3.0
Real Name: AQUEEL
Company: AMANA

Re: Table 'otrs.virtual_fs' doesn't exist

Post by aqueel »

Hi jojo,

How should i get professional support only for migration from 3.0 to 4.0. Please help i will be more than happy for once paid service.

Thanks
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Table 'otrs.virtual_fs' doesn't exist

Post by jojo »

"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Table 'otrs.virtual_fs' doesn't exist

Post by crythias »

don't forget: If you've upgraded OTRS, you also need to upgrade the ITSM packages.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Post Reply