Table 'otrs.virtual_fs' doesn't exist

Moderator: crythias

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

Table 'otrs.virtual_fs' doesn't exist

Post by aqueel » 19 Nov 2014, 12:53

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
Moderator
Posts: 14615
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

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

Post by jojo » 19 Nov 2014, 14:32

For urgent help buy professional services. Also you should upgrade to the latest version (3.3.10)
"Production": 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 :: Share your ideas

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

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

Post by aqueel » 20 Nov 2014, 05:03

Thanks jojo for the advice. I have just asked for help if some one can help me it would be great.

jojo
Moderator
Posts: 14615
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

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

Post by jojo » 20 Nov 2014, 08:33

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™ 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 :: Share your ideas

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

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

Post by aqueel » 20 Nov 2014, 10:15

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: 10109
Joined: 04 May 2010, 18:38
OTRS Version?: 5.0.x
Location: SouthWest Florida, USA
Contact:

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

Post by crythias » 20 Nov 2014, 15:04

change your tables bin/otrs.MySQLInnoDBSwitch.pl

As always, back up your database before making changes. Your data is your responsibility.
OTRS 5.0.x (private/testing/public) on Linux with MySQL database. Also on github.
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
OTRS newbie
Posts: 14
Joined: 19 Nov 2014, 12:22
OTRS Version?: otrs 3.0
Real Name: AQUEEL
Company: AMANA

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

Post by aqueel » 26 Nov 2014, 07:44

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: 10109
Joined: 04 May 2010, 18:38
OTRS Version?: 5.0.x
Location: SouthWest Florida, USA
Contact:

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

Post by crythias » 26 Nov 2014, 14:45

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 5.0.x (private/testing/public) on Linux with MySQL database. Also on github.
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
OTRS newbie
Posts: 14
Joined: 19 Nov 2014, 12:22
OTRS Version?: otrs 3.0
Real Name: AQUEEL
Company: AMANA

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

Post by aqueel » 27 Nov 2014, 06:46

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
OTRS newbie
Posts: 14
Joined: 19 Nov 2014, 12:22
OTRS Version?: otrs 3.0
Real Name: AQUEEL
Company: AMANA

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

Post by aqueel » 30 Nov 2014, 08:47

Hi Friends

somebody please help!

jojo
Moderator
Posts: 14615
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

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

Post by jojo » 30 Nov 2014, 10:32

virtual_fs was introduced with OTRS 3.0. So you might need to mainupulate the databae directly to have the table
"Production": 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 :: Share your ideas

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

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

Post by aqueel » 01 Dec 2014, 09:42

Can you help me how to create these tables manually i will be thank for to you and thanks for ongoing help.

reneeb
OTRS guru
Posts: 4795
Joined: 13 Mar 2011, 09:54
OTRS Version?: 3.3.x
Company: Perl-Services.de
Contact:

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

Post by reneeb » 01 Dec 2014, 09:48

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 / OTRS development: http://perl-services.de
Free OTRS add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de

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

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

Post by aqueel » 03 Dec 2014, 06:34

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
OTRS newbie
Posts: 14
Joined: 19 Nov 2014, 12:22
OTRS Version?: otrs 3.0
Real Name: AQUEEL
Company: AMANA

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

Post by aqueel » 03 Dec 2014, 09:14

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
OTRS guru
Posts: 2191
Joined: 08 Dec 2005, 17:01
OTRS 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 » 03 Dec 2014, 10:00

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
OTRS newbie
Posts: 14
Joined: 19 Nov 2014, 12:22
OTRS Version?: otrs 3.0
Real Name: AQUEEL
Company: AMANA

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

Post by aqueel » 03 Dec 2014, 11:42

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
OTRS newbie
Posts: 14
Joined: 19 Nov 2014, 12:22
OTRS Version?: otrs 3.0
Real Name: AQUEEL
Company: AMANA

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

Post by aqueel » 04 Dec 2014, 13:34

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
Moderator
Posts: 14615
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

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

Post by jojo » 04 Dec 2014, 13:37

you seem to require professional services.
"Production": 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 :: Share your ideas

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

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

Post by aqueel » 04 Dec 2014, 14:15

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
Moderator
Posts: 14615
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

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

Post by jojo » 04 Dec 2014, 14:34

it seems that not all needed tables are existent (which might happen if one of the migrations failed)
"Production": 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 :: Share your ideas

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

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

Post by aqueel » 17 Dec 2014, 08:56

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
Moderator
Posts: 14615
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

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

Post by jojo » 17 Dec 2014, 10:59

"Production": 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 :: Share your ideas

crythias
Moderator
Posts: 10109
Joined: 04 May 2010, 18:38
OTRS Version?: 5.0.x
Location: SouthWest Florida, USA
Contact:

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

Post by crythias » 17 Dec 2014, 14:37

don't forget: If you've upgraded OTRS, you also need to upgrade the ITSM packages.
OTRS 5.0.x (private/testing/public) on Linux with MySQL database. Also on github.
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