Axapta : เปลียนสีและ background และตัวหนังสือ ของข้อความใน Grid

 

Axapta : เปลียนสีและ background และตัวหนังสือ ของข้อความใน Grid

 

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/user-interface/specify-color-font-background-controls

 

Set its AutoDeclaration property to 'Yes'.

1.    SalesLine_ItemId.colorScheme(FormColorScheme::RGB);
2.     SalesLine_ItemId.backgroundColor(WinAPI::RGB2int(255,255,146));
3.     SalesLine_ItemId.foregroundColor(WinAPI::RGB2int(255,0,0));

Next cloud Update : 15 To 21 Ubuntu 18.04

Next cloud Update : 15 To 21 Ubuntu 18.04

แก้ Wranning

MySQL is used as database but does not support 4-byte characters. To be able to handle 4-byte characters (like emojis) without issues in filenames or comments for example it is recommended to enable the 4-byte support in MySQL. For further details read the documentation page about this.

1. mysql -V
2. /etc/mysql/mariadb.conf.d/50-server.cnf

เพิ่ม ไว้ใต้ [mysqld]

innodb_large_prefix=true
innodb_file_format=barracuda
innodb_file_per_table=1

1. service mysqld restart
2. mysql -u root -p
3. Enter password: database

show databases;

1. SELECT NAME, SPACE, FILE_FORMAT FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME like "nextcloud%";

https://www.allerstorfer.at/enabling-my ... ntu-18-04/

ทำต่อ

1. show variables like 'innodb_file_per_table';

เข้าใน Terminal ไม่ต้องเข้า sql

1. cd /var/www/nextcloud
2. sudo -u www-data php occ maintenance:mode --on

Run ใน mysql

1. ALTER DATABASE nextcloud CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

Run ใน Terminal

1. sudo -u www-data php occ config:system:set mysql.utf8mb4 --type boolean --value="true"
2. sudo -u www-data php occ maintenance:repair

รอสักพัก เสร็จ Run ใน Terminal

1. sudo -u www-data php occ maintenance:mode --off

https://docs.nextcloud.com/server/21/ad ... pport.html

The PHP memory limit is below the recommended value of 512MB.

1. php -v
2. nano /etc/php/7.0/apache2/php.ini

หา memory_limit จาก 128 เป็น 512

1. nano /etc/php/7.0/cli/php.ini

หา memory_limit จาก 128 เป็น 512

1. restart apache
2. /etc/init.d/apache2 restart

https://help.nextcloud.com/t/the-php-me ... 12mb/42719

The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added automatically. By running "occ db:add-missing-indices" those missing indexes could be added manually while the instance keeps running. Once the indexes are added queries to those tables are usually much faster.
Missing index "parent_index" in table "oc_share".
Missing index "owner_index" in table "oc_share".
Missing index "initiator_index" in table "oc_share".
Missing index "fs_mtime" in table "oc_filecache".

แก้

1. cd /var/www/nextcloud
2. sudo -u www-data php occ db:add-missing-indices

ต้องแก้ memory_limit

PHP Fatal error: Allowed memory size of 2097152 bytes exhausted (tried to allocate 36864 bytes) in /var/www/nextcloud/3rdparty/composer/autoload_static.php on line 2439

1. nano /etc/php/7.0/apache2/php.ini

memory_limit จาก 512 เป็น 2048M

1. nano /etc/php/7.0/cli/php.ini

memory_limit จาก 512 เป็น 2048M (ใส่ M ด้วย)

1. /etc/init.d/apache2 restart 

แล้วค่อย Run

1. sudo -u www-data php occ db:add-missing-indices

https://help.nextcloud.com/t/some-indic ... ally/37852

Some columns in the database are missing a conversion to big int. Due to the fact that changing column types on big tables could take some time they were not changed automatically. By running 'occ db:convert-filecache-bigint' those pending changes could be applied manually. This operation needs to be made while the instance is offline. For further details read the documentation page about this.

filecache.mtime
filecache.storage_mtime
mounts.storage_id
mounts.root_id
mounts.mount_id

แก้

1. sudo -u www-data php occ db:convert-filecache-bigint

ตอบ y แล้วenter

Your web server is not properly set up to resolve "/.well-known/caldav". Further information can be found in the documentation.
Your web server is not properly set up to resolve "/.well-known/carddav". Further information can be found in the documentation.

วิธีแก้
https://help.nextcloud.com/t/caldav-and ... ving/39435

เพิ่ม Redirect 301 ไว้ในไฟล์

1. nano /etc/apache2/sites-available/000-default.conf

เพิ่มไว้ล่างสุด

Redirect 301 /.well-known/carddav https://nextcloud.sci.com/remote.php/dav
Redirect 301 /.well-known/caldav https://nextcloud.sci.com/remote.php/dav

1. /etc/init.d/apache2 restart

https://stackoverflow.com/questions/644 ... g-to-redis

1. nano /var/www/nextcloud/config/config.php

เพิ่ม เข้าไปในไฟล์ ก่อน 'redis' => array (

'memcache.local' => '\OC\Memcache\APCu',
'memcache.locking' => '\OC\Memcache\Redis',
'memcache.distributed' => '\OC\Memcache\Redis',

The "X-Content-Type-Options" HTTP header is not set to "nosniff". This is a potential security or privacy risk, as it is recommended to adjust this setting accordingly.

1. nano /etc/apache2/conf-enabled/ssl-params.conf

ใส่ # หน้า

#Header always set X-Content-Type-Options nosniff

ถ้าไม่หายในไฟล์ .htaccess ด้วย

Update Version 15.0.14 --> 16.0.11
ไม่มีปุ่ม ต้อง Update PHP 7.0 --> 7.1

Update php 7.0 to 7.1

1. sudo apt install -y php7.1 php7.1-cli libapache2-mod-php7.1
2. sudo apt install -y php-imagick php-gettext php-memcache php-apcu php-pear php-xml php-xmlrpc
3. sudo apt install -y php-memcached php-mysql php-intl php-mbstring php-curl php-gd php-imagick
4. sudo apt install -y php7.1-common php7.1-mysql php7.1-cgi
5. sudo apt install -y php7.1-curl php7.1-zip php7.1-mbstring php7.1-xmlrpc php7.1-gd php7.1-xml php7.1-xsl
6. sudo apt install -y php7.1-dev php7.1-bz2 php7.1-intl php7.1-json php7.1-opcache php7.1-readline
7. sudo apt install -y php7.1-imap php7.1-pspell php7.1-recode php7.1-sqlite3 php7.1-tidy php7.1-bcmath php7.1-mcrypt

# Update the Apache's PHP version

1. sudo a2dismod php7.0
2. sudo a2enmod php7.1
3. sudo systemctl restart apache2.service

# Update the CLI PHP version

1. sudo update-alternatives --set php /usr/bin/php7.1

Restart apache

https://itectec.com/ubuntu/ubuntu-upgra ... ntu-16-04/

OC\ServerNotAvailableException: Connection to LDAP server could not be established

ติดตั้ง php7.1-ldap

1. apt-get install php7.1-ldap

1. sudo -u apache /usr/bin/php /var/www/html/nextcloud/occ upgrade

Restart apache

The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added automatically. By running "occ db:add-missing-indices" those missing indexes could be added manually while the instance keeps running. Once the indexes are added queries to those tables are usually much faster.]

Missing index "twofactor_providers_uid" in table "oc_twofactor_providers".
Missing index "version" in table "oc_whats_new".
Missing index "cards_abid" in table "oc_cards".
Missing index "cards_prop_abid" in table "oc_cards_properties".

แก้

1. sudo -u www-data php occ db:add-missing-indices

Update Version 16 --> 17 แก้คำเตือน

The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added automatically. By running "occ db:add-missing-indices" those missing indexes could be added manually while the instance keeps running. Once the indexes are added queries to those tables are usually much faster.

Missing index "twofactor_providers_uid" in table "oc_twofactor_providers".
Missing index "version" in table "oc_whats_new".
Missing index "cards_abid" in table "oc_cards".
Missing index "cards_prop_abid" in table "oc_cards_properties".

1. sudo -u www-data php occ db:add-missing-indices

Update Version 17 --> 18 ไม่มีปุ่ม
1. Update php 7.1 --> 7.3 Up ข้ามไป 7.4 ไม่ได้เพราะ Vesion nexcloud 17 ไม่รองรับ
ไม่มีปุ่ม ต้อง Update PHP 7.1 --> 7.3

Update php 7.1 to 7.3

1. sudo apt install -y php7.3 php7.3-cli libapache2-mod-php7.3 php7.3-ldap
2. sudo apt install -y php-imagick php-gettext php-memcache php-apcu php-pear php-xml php-xmlrpc
3. sudo apt install -y php-memcached php-mysql php-intl php-mbstring php-curl php-gd php-imagick
4. sudo apt install -y php7.3-common php7.3-mysql php7.3-cgi
5. sudo apt install -y php7.3-curl php7.3-zip php7.3-mbstring php7.3-xmlrpc php7.3-gd php7.3-xml php7.3-xsl
6. sudo apt install -y php7.3-dev php7.3-bz2 php7.3-intl php7.3-json php7.3-opcache php7.3-readline
7. sudo apt install -y php7.3-imap php7.3-pspell php7.3-recode php7.3-sqlite3 php7.3-tidy php7.3-bcmath php7.3-mcrypt

# Update the Apache's PHP version

1. sudo a2dismod php7.1
2. sudo a2enmod php7.3
3. sudo systemctl restart apache2.service

# Update the CLI PHP version

1. sudo update-alternatives --set php /usr/bin/php7.3

Restart apache

2. Run
sudo -u www-data /usr/bin/php7.3 occ upgrade

Update version 18 --> 19 แก้คำเตือน

The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added automatically. By running "occ db:add-missing-indices" those missing indexes could be added manually while the instance keeps running. Once the indexes are added queries to those tables are usually much faster.

Missing index "calendarobject_calid_index" in table "oc_calendarobjects_props".
Missing index "schedulobj_principuri_index" in table "oc_schedulingobjects".

1. sudo -u www-data php occ db:add-missing-indices

Some columns in the database are missing a conversion to big int. Due to the fact that changing column types on big tables could take some time they were not changed automatically. By running 'occ db:convert-filecache-bigint' those pending changes could be applied manually. This operation needs to be made while the instance is offline. For further details read the documentation page about this.

filecache_extended.fileid

1. sudo -u www-data php occ db:convert-filecache-bigint

ตอบ y แล้ว enter

Update version 19 --> 20 แก้คำเตือน

The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added automatically. By running "occ db:add-missing-indices" those missing indexes could be added manually while the instance keeps running. Once the indexes are added queries to those tables are usually much faster.

Missing index "properties_path_index" in table "oc_properties".

1. sudo -u www-data php occ db:add-missing-indices

The database is missing some optional columns. Due to the fact that adding columns on big tables could take some time they were not added automatically when they can be optional. By running "occ db:add-missing-columns" those missing columns could be added manually while the instance keeps running. Once the columns are added some features might improve responsiveness or usability.

Missing optional column "reference_id" in table "oc_comments".

1. sudo -u www-data php occ db:add-missing-columns

This instance is missing some recommended PHP modules. For improved performance and better compatibility it is highly recommended to install them.

gmp

ติดตั้ง

1. apt-get install php7.3-gmp
2. /etc/init.d/apache2 restart
   

 

Update version 20.0.11 --> 21.0.3 แก้ Error

PHP configuration option output_buffering must be disabled

แก้

1. nano /etc/php/7.3/apache2/php.ini

output_buffering = 4096
เป็น
output_buffering = off

https://www.a2hosting.com/kb/developer- ... -directive
ถ้าไม่หายใน .htaccess file
https://help.nextcloud.com/t/false-outp ... ing/102791

The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added automatically. By running "occ db:add-missing-indices" those missing indexes could be added manually while the instance keeps running. Once the indexes are added queries to those tables are usually much faster.

Missing index "cards_abiduri" in table "oc_cards".

1. sudo -u www-data php occ db:add-missing-indices

The database is missing some primary keys. Due to the fact that adding primary keys on big tables could take some time they were not added automatically. By running "occ db:add-missing-primary-keys" those missing primary keys could be added manually while the instance keeps running.

Missing primary key on table "oc_federated_reshares".
Missing primary key on table "oc_systemtag_object_mapping".
Missing primary key on table "oc_comments_read_markers".
Missing primary key on table "oc_collres_resources".
Missing primary key on table "oc_collres_accesscache".
Missing primary key on table "oc_filecache_extended".

1. sudo -u www-data php occ db:add-missing-primary-keys

Some columns in the database are missing a conversion to big int. Due to the fact that changing column types on big tables could take some time they were not changed automatically. By running 'occ db:convert-filecache-bigint' those pending changes could be applied manually. This operation needs to be made while the instance is offline. For further details read the documentation page about this.

federated_reshares.share_id
share_external.id
share_external.parent

1. sudo -u www-data php occ db:convert-filecache-bigint

แก้คำเตือน

The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added automatically. By running "occ db:add-missing-indices" those missing indexes could be added manually while the instance keeps running. Once the indexes are added queries to those tables are usually much faster.

Missing index "fs_size" in table "oc_filecache".

1.  
2. sudo -u www-data php occ db:add-missing-indices

Module php-imagick in this instance has no SVG support. For better compatibility it is recommended to install it.

1.  
2. apt-get install php7.3-imagick imagemagick
3. /etc/init.d/apache2 restart

https://help.nextcloud.com/t/how-to-ena ... k/108646/5

Your web server is not properly set up to resolve "/.well-known/webfinger". Further information can be found in the documentation.
Your web server is not properly set up to resolve "/.well-known/nodeinfo". Further information can be found in the documentation.

1. nano /etc/apache2/sites-available/000-default.conf

เพิ่มไว้ล่าง

Redirect 301 /.well-known/webfinger https://nextcloud.sci.com/index.php/.well-known/webfinger
Redirect 301 /.well-known/nodeinfo https://nextcloud.sci.com/index.php/.well-known/nodeinfo

Your installation has no default phone region set. This is required to validate phone numbers in the profile settings without a country code. To allow numbers without a country code, please add "default_phone_region" with the respective ISO 3166-1 code ↗ of the region to your config file.

แก้

1. nano /var/www/nextcloud/config/config.php

เพิ่ม ไว้ล่างสุดก่อนปิด );

'default_phone_region' => 'TH',

https://www.reddit.com/r/NextCloud/comm ... ud_server/

A background job is pending that checks for user imported SSL certificates. Please check back later.

1. ที่ menu Basic settings ส่วน Background jobs เลือกเป็น Cron
2. ติดตั้ง php-cgi

1. apt-get install php-cgi

3. เพิ่ม Cron

1. crontab -u www-data -e

เพิ่ม

*/5 * * * * php -f /var/www/nextcloud/cron.php

run คำสั่งตรวจความถูกต้อง

1. crontab -u www-data -l

https://docs.nextcloud.com/server/21/ad ... ation.html

phpmyadmin PHP Warning: Unsupported declare 'strict_types'

 phpmyadmin PHP Warning: Unsupported declare 'strict_types'

Unsupported declare 'strict_types' in /usr/share/php/PhpMyAdmin/MoTranslator/Loader.php on line 23

Linuxmint 20.1
php 5.6

วิธีแก้
1. Install phpmyadmin ตามปกติ
2. โหลด phpMyAdmin 4.9.7
https://www.phpmyadmin.net/downloads/
3. ลบ Folder /usr/share/phpmyadmin ออก
4. แตกไฟล์ ข้อ 2 เปลี่ยนชื่อเป็น phpmyadmin
5. ย้ายไปไว้ Folder /usr/share/

ก็จะสามารถใช้ php5.6 ร่วมกับ phpmyadmin 4.9 ได้ แต่ Version ที่สูงกว่าไม่รองรับ ต้องลง php ตัวใหม่เท่านั้น เนื่องจากโปรแกรม php เก่าไม่รองรับ คำสั่งใหม่ใน phpmyadmin

มี Error

The configuration file now needs a secret passphrase (blowfish_secret).

แก้

1. cp /usr/share/phpmyadmin/config.sample.inc.php /usr/share/phpmyadmin/config.inc.php
2. $cfg['blowfish_secret'] = 'qtdRoGmbc9{8IZr323xYcSN]0s)r$9b_JUnb{~Xz';

The $cfg['TempDir'] (./tmp/) is not accessible. phpMyAdmin is not able to cache templates and will be slow because of this.

แก้

1. cd /usr/share/phpmyadmin/
2. mkdir tmp
3. chmod 777 tmp
4. nano config.inc.php

เพิ่มไว้ในไฟล์ล่างสุด

1. $cfg ['TempDir'] = 'tmp';

Bug Lightsquid Stop Working in 2021

Bug Lightsquid Stop Working in 2021
ที่ไฟล์ lightparser.pl มีการ Fix ปี 2020 ไว้

1. /usr/local/lightsquid/lightparser.pl

เปิดไฟล์

1. nano /usr/local/lightsquid/lightparser.pl

พบ

my $filterdatestop =timelocal(59,59,23,31,12-1,2020-1900)+1000;

ทดลองเปลี่ยนเป็น 2021

my $filterdatestop =timelocal(59,59,23,31,12-1,2021-1900)+1000;

แล้ว Run

/usr/local/lightsquid/lightparser.pl

เกิดข้อมูล Reports วันปัจจุบัน

หาข้อมูลจาก Internet พบเป็น Bug ของ Program สร้าง Reports
https://finisky.github.io/2021/01/03/lightsquidhardcodeyear.en/

จึงแก้ตาม Web

my $filterdatestop =timelocal(59,59,23,31,11,2100)+1000;

ข้อมูล Reports ปี 2021 เหลือ 3 วันเนื่องจาก access.log ถูกเคลีย์

Axapta 2009 : Axapta สร้าง List Department ให้เลือก จาก Dimension Group

 Axapta 2009 : Axapta สร้าง List Department ให้เลือก จาก Dimension Group
If you want to use a particular dimension as a dialog field in Dynamics AX 2009 (or earlier versions), you can create your own Extended Data Type (derived from Criterias) as described below. The decisive factors are the relations of this EDT.

In the example, the cost center is to be offered as a dialog field.

Create Dialog

1. protected Object dialog(DialogRunbase dialog, boolean forceOnClient)
2. {
3.     Object ret;
4.     ret = super(dialog, forceOnClient);
5.     df_project = ret.addField(TypeId(DimensionACEdit));
6.     return ret;
7. }

Button Edit Show Dialog
Code In GL Edit Department AC

1. void clicked()
2. {
3.     //LedgerJournalTrans_ds.allowEdit(true);
4.     Dialog              myDialog;
5.     DialogField         myDialogFieldDepartment;
6.     LedgerJournalTrans  myLedgerJournalTrans;
7.     LedgerJournalTrans  LedgerJournalTransUpdate;
8.     ;
9.  
10.     super();
11.     myLedgerJournalTrans = ledgerJournalTrans_ds.cursor();
12.  
13.     myDialog = new Dialog("Department Edit.");
14.     myDialogFieldDepartment = myDialog.addFieldValue(typeId(DimensionACEdit), '', "void clicked()
15. {
16.     //LedgerJournalTrans_ds.allowEdit(true);
17.     Dialog              myDialog;
18.     DialogField         myDialogFieldDepartment;
19.     LedgerJournalTrans  myLedgerJournalTrans;
20.     LedgerJournalTrans  LedgerJournalTransUpdate;
21.     ;
22.  
23.     super();
24.     myLedgerJournalTrans = ledgerJournalTrans_ds.cursor();
25.  
26.     myDialog = new Dialog("Department Edit.");
27.     myDialogFieldDepartment = myDialog.addFieldValue(typeId(DimensionACEdit), '', "Departmaint :");
28.  
29.     if(myDialog.run()){
30.         //if(box::yesNo("Press 'Yes' to Confirm / Press 'No' to Cancel", DialogButton::No, "Please select...") == DialogButton::Yes){
31.             ttsbegin;
32.                 SELECT FORUPDATE * FROM LedgerJournalTransUpdate
33.                 WHERE LedgerJournalTransUpdate.RecId == myLedgerJournalTrans.RecId;
34.                 {
35.                     LedgerJournalTransUpdate.DimensionACEdit[1] = myDialogFieldDepartment.value();
36.                     LedgerJournalTransUpdate.update();
37.                     LedgerJournalTrans_ds.reread();
38.                     LedgerJournalTrans_ds.refresh();
39.                 }
40.             ttscommit;
41.         //} //Close If.
42.     } //Close If.
43. }:");
44.  
45.     if(myDialog.run()){
46.         //if(box::yesNo("Press 'Yes' to Confirm / Press 'No' to Cancel", DialogButton::No, "Please select...") == DialogButton::Yes){
47.             ttsbegin;
48.                 SELECT FORUPDATE * FROM LedgerJournalTransUpdate
49.                 WHERE LedgerJournalTransUpdate.RecId == myLedgerJournalTrans.RecId;
50.                 {
51.                     LedgerJournalTransUpdate.DimensionACEdit[1] = myDialogFieldDepartment.value();
52.                     LedgerJournalTransUpdate.update();
53.                     LedgerJournalTrans_ds.reread();
54.                     LedgerJournalTrans_ds.refresh();
55.                 }
56.             ttscommit;
57.         //} //Close If.
58.     } //Close If.
59. }

ตัวอย่าง : https://www.schweda.net/blog_ax.php?bid=555&wdl=en