[SOLVED] After populating customer_company+customer_user

Moderator: crythias

Locked
HervE
Znuny wizard
Posts: 391
Joined: 03 Jan 2011, 17:15
Znuny Version: 3.3.8
Location: France

[SOLVED] After populating customer_company+customer_user

Post by HervE »

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
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
HervE
Znuny wizard
Posts: 391
Joined: 03 Jan 2011, 17:15
Znuny Version: 3.3.8
Location: France

Re: Issues after populating customer_company and customer_us

Post by HervE »

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
OTRS 3.3.8 - Windows 7 - IIS7 - SQL Server - Firefox 30
crythias
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

Post by crythias »

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
HervE
Znuny wizard
Posts: 391
Joined: 03 Jan 2011, 17:15
Znuny Version: 3.3.8
Location: France

Re: Issues after populating customer_company and customer_us

Post by HervE »

Interesting.

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
crythias
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

Post by crythias »

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
HervE
Znuny wizard
Posts: 391
Joined: 03 Jan 2011, 17:15
Znuny Version: 3.3.8
Location: France

Re: Issues after populating customer_company and customer_us

Post by HervE »

OK, many thanks.

Regards,
HervE
OTRS 3.3.8 - Windows 7 - IIS7 - SQL Server - Firefox 30
HervE
Znuny wizard
Posts: 391
Joined: 03 Jan 2011, 17:15
Znuny Version: 3.3.8
Location: France

Perl script issue

Post by HervE »

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
OTRS 3.3.8 - Windows 7 - IIS7 - SQL Server - Firefox 30
Locked