Hello forum,
Sorry if it is already on this forum somewhere. A quick search didn't make it appear to me.
I created then ran 4 scripts to:
- add columns to customer_company
- populate customer_company
- add columns to customer_user
- populate customer_user
In Config.pm I mapped the new columns, and I switched CustomerCompanySupport on.
As a result I've got 2 issues, but maybe they're linked.
1) In Customer Company edit screen, the boxes of the new fields remain empty (even though the new fields are filled when I request the database)... but the boxes of the new fields of Customer Users are OK!
2) All the Customer Companies that have a Customer User don't appear in the company list screen... although they are present in the database!
Could anybody help?
What do you think of this?
Best regards,
HervE
[SOLVED] After populating customer_company+customer_user
Moderator: crythias
[SOLVED] After populating customer_company+customer_user
Last edited by HervE on 25 Sep 2014, 16:38, edited 1 time in total.
OTRS 3.3.8 - Windows 7 - IIS7 - SQL Server - Firefox 30
Re: Issues after populating customer_company and customer_us
Hello,
The 2 issues are solved today, although I did nothing.
I guess the system was 'synchronized' with the database but how?
Is one of the two Cron actions below responsible of this?
20 0 * * 0 C:\otrs\StrawberryPerl\perl\bin\perl.exe C:/otrs/OTRS/bin/otrs.DeleteCache.pl --expired
30 0 * * 0 C:\otrs\StrawberryPerl\perl\bin\perl.exe C:/otrs/OTRS/bin/otrs.LoaderCache.pl -o delete
Or is there something else?
Regards,
HervE
The 2 issues are solved today, although I did nothing.
I guess the system was 'synchronized' with the database but how?
Is one of the two Cron actions below responsible of this?
20 0 * * 0 C:\otrs\StrawberryPerl\perl\bin\perl.exe C:/otrs/OTRS/bin/otrs.DeleteCache.pl --expired
30 0 * * 0 C:\otrs\StrawberryPerl\perl\bin\perl.exe C:/otrs/OTRS/bin/otrs.LoaderCache.pl -o delete
Or is there something else?
Regards,
HervE
OTRS 3.3.8 - Windows 7 - IIS7 - SQL Server - Firefox 30
-
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Issues after populating customer_company and customer_us
cache. As you note, the cache was deleted/expired at midnight:20 or midnight:30 Which means you could have run that yourself.
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
Re: Issues after populating customer_company and customer_us
Interesting.
Which one of the 2 scripts do I have to run myself?
Regards,
HervE
Which one of the 2 scripts do I have to run myself?
Regards,
HervE
OTRS 3.3.8 - Windows 7 - IIS7 - SQL Server - Firefox 30
-
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Issues after populating customer_company and customer_us
deletcache
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
Re: Issues after populating customer_company and customer_us
OK, many thanks.
Regards,
HervE
Regards,
HervE
OTRS 3.3.8 - Windows 7 - IIS7 - SQL Server - Firefox 30
Perl script issue
Hello,
Actually I cannot run any Perl script, for I always get something like this:
U:\>C:\otrs\StrawberryPerl\perl\bin\perl.exe C:/otrs/OTRS/bin/otrs.DeleteCache.pl --expired
Undefined subroutine &Encode::find_encoding called at C:/otrs/OTRS/Kernel/cpan-lib/Encode/Locale.pm line 83.
Compilation failed in require at C:\otrs\OTRS\Kernel\System\/Encode.pm line 16.
BEGIN failed--compilation aborted at C:\otrs\OTRS\Kernel\System\/Encode.pm line 16.
Compilation failed in require at C:/otrs/OTRS/Kernel/System/Encode.pm line 15.
BEGIN failed--compilation aborted at C:/otrs/OTRS/Kernel/System/Encode.pm line 15.
Compilation failed in require at C:/otrs/OTRS/bin/otrs.DeleteCache.pl line 34.
BEGIN failed--compilation aborted at C:/otrs/OTRS/bin/otrs.DeleteCache.pl line 34.
An idea of what could be wrong?
Edited: I've created a new thread for this to have the 2 issues separated, that's better.
Regards,
HervE
Actually I cannot run any Perl script, for I always get something like this:
U:\>C:\otrs\StrawberryPerl\perl\bin\perl.exe C:/otrs/OTRS/bin/otrs.DeleteCache.pl --expired
Undefined subroutine &Encode::find_encoding called at C:/otrs/OTRS/Kernel/cpan-lib/Encode/Locale.pm line 83.
Compilation failed in require at C:\otrs\OTRS\Kernel\System\/Encode.pm line 16.
BEGIN failed--compilation aborted at C:\otrs\OTRS\Kernel\System\/Encode.pm line 16.
Compilation failed in require at C:/otrs/OTRS/Kernel/System/Encode.pm line 15.
BEGIN failed--compilation aborted at C:/otrs/OTRS/Kernel/System/Encode.pm line 15.
Compilation failed in require at C:/otrs/OTRS/bin/otrs.DeleteCache.pl line 34.
BEGIN failed--compilation aborted at C:/otrs/OTRS/bin/otrs.DeleteCache.pl line 34.
An idea of what could be wrong?
Edited: I've created a new thread for this to have the 2 issues separated, that's better.
Regards,
HervE
OTRS 3.3.8 - Windows 7 - IIS7 - SQL Server - Firefox 30