Table 'otrs.virtual_fs' doesn't exist
Moderator: crythias
-
- 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
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
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
Re: Table 'otrs.virtual_fs' doesn't exist
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- 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
Thanks jojo for the advice. I have just asked for help if some one can help me it would be great.
Re: Table 'otrs.virtual_fs' doesn't exist
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- 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
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
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
-
- 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
change your tables bin/otrs.MySQLInnoDBSwitch.pl
As always, back up your database before making changes. Your data is your responsibility.
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
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
-
- 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
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
Thanks
Aqueel
-
- 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
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
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
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
-
- 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
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
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
-
- 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
Hi Friends
somebody please help!
somebody please help!
Re: Table 'otrs.virtual_fs' doesn't exist
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- 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
Can you help me how to create these tables manually i will be thank for to you and thanks for ongoing help.
-
- 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
Login to your mysql database:
(user and password can be found in Kernel/Config.pm)
Code: Select all
mysql -u otrs -p -h localhost otrs
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
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
-
- 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
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...)
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...)
-
- 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
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
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
-
- 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
Maybe you forgot to run the db update script?
https://otrs.github.io/doc/manual/admin ... ading.html
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
DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!
OtterHub.org
-
- 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
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
I have run all migration scripts required. its the same. i am not able attach any file to cmdb items.
Thanks
-
- 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
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
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
Re: Table 'otrs.virtual_fs' doesn't exist
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- 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
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
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
Re: Table 'otrs.virtual_fs' doesn't exist
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- 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
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
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
Re: Table 'otrs.virtual_fs' doesn't exist
"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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- 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
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
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