tomolimo
Error in entering dates. The starting date is later than the ending date, Undefined array key "id"
Hi,
Every time i add a new case to a ticket (following Tutorial 1) this error is shown:
Also this warning appears in /var/log/glpi/php-errors.log:
glpiphplog.WARNING: *** PHP Warning (2): Undefined array key "id" in /var/www/html/glpi/plugins/processmaker/front/processmaker.form.php at line 55 Backtrace : public/index.php:82 require()
55 Session::setActiveTab('PluginProcessmakerCase', 'PluginProcessmakerTask$'.$task->fields['id']);
As a result the dynaform is not visible (entry is visible in dynaforms tab, but preview button does nothing)
GLPI: 10.0.16 php: 8.2.20 apache: 2.4.62 sql: 10.11.6-MariaDB-0+deb12u1
ProcessMaker: 3.3.0-community-RE-2.5 Apache/2.4.6 (CentOS) PHP/7.1.33 MySql (Version 5.7.44)
Hello @sas060 Could you post the version of the ProcessMaker plugin? Thank you Regards, Tomolimo
@tomolimo
Version in glpi is 5.0.3
But the plugin was installed by cloning this repo into glpi/plugins
When i originally tried installing by unzipping processmaker-5.0.3.zip, it wouldnt show up in installed plugins in glpi with this error:
glpiphplog.WARNING: *** PHP User Warning (512): Unable to load plugin "processmaker" information. in /var/www/html/glpi/src/Plugin.php at line 654
Backtrace :
src/Plugin.php:654 trigger_error()
src/Plugin.php:538 Plugin->checkPluginState()
front/marketplace.php:43 Plugin->checkStates()
public/index.php:82 require()
Hello @sas060 The correct installation procedure is to take the zip file that is provided with the release and not to clone the repo... Zip file is here: https://github.com/tomolimo/processmaker/releases/tag/5.0.3 Using a clone of the repo, means that you want to help developing the plugin :) thank you Regards, Tomolimo
Hello @sas060 Could you go back to the zip file content instead of the repo clone? Delete the processmaker folder content before unzipping the zip file. And then we'll try to fix the initial issue. Thank you Regards, Tomolimo
Hi @tomolimo
I found my issue with plugin installation using the zip file.
I had to chown www-data:www-data -R processmaker after unzipping the archive.
Now the plugin shows up in glpi interface, however the original error still persists (error in entering dates)
Sorry for the late reply
Hello @sas060 Could you check the PHP error log files: the one from GLPI, and the one from the PM server? Thank you, Regards, Tomolimo
glpi-apache.txt glpi-php-error.txt processmaker-httpd.txt The full log is just the same errors repeated
Hello @sas060 I can't download these files: my organization blocks them. Could you post them to Discord in private messages? Discord account: Tomolimo Thank you, Regards, Tomolimo
Hello @sas060 Could you post screenshots of the entire configuration of PM server and of PM plugin? Thank you Regards, Tomolimo
the ones like shown here: https://github.com/tomolimo/processmaker-server/wiki/ProcessMaker-server-configuration-check plus the environment tab, and whatever you think that can be of any help to find the root cause
Hello @sas060 I searched on PM server side, but it seems to be in GLPI / PM plugin itself. I'll be in holidays for 10 days, and after I'll be in touch with you to continue to debug this. Thank you, Regards, Tomolimo
Hello @yxing-hub Could you post screenshots of the timezone settings in GLPI and in PM? Could you post screenshots of the MySQL timezone tables (it's in the mysql database, in time_zone_name table (I just want to be sure that TZ are correctly enabled)? I need that for the MySQL server used by GLPI and for the MySQL server used by ProcessMaker server. Thank you, Regards, Tomolimo
Problem solved by setting timezone in Mariadb config.
/etc/mysql/mariadb.conf.d/50-server.cnf
[mariadb]
default_time_zone = 'Asia/Almaty'
You must use the same timezone in ProcessMaker.
But I got another error.
The session has expired. (9)
Hello @tomolimo, this is my configuration. 192.168.19.133 GLPI+mariadb, 192.168.19.132 ProcessMaker, ProcessMaker connected to mariadb on 192.168.19.133
SELECT * FROM mysql.time_zone_name;
MariaDB [(none)]> SELECT * FROM mysql.time_zone_name; +--------------------------------+--------------+ | Name | Time_zone_id | +--------------------------------+--------------+ | Africa/Abidjan | 1 | | Africa/Accra | 2 | | Africa/Addis_Ababa | 3 | | Africa/Algiers | 4 | | Africa/Asmara | 5 | | Africa/Bamako | 6 | | Africa/Bangui | 7 | | Africa/Banjul | 8 | | Africa/Bissau | 9 | | Africa/Blantyre | 10 | | Africa/Brazzaville | 11 | | Africa/Bujumbura | 12 | | Africa/Cairo | 13 | | Africa/Casablanca | 14 | | Africa/Ceuta | 15 | | Africa/Conakry | 16 | | Africa/Dakar | 17 | | Africa/Dar_es_Salaam | 18 | | Africa/Djibouti | 19 | | Africa/Douala | 20 | | Africa/El_Aaiun | 21 | | Africa/Freetown | 22 | | Africa/Gaborone | 23 | | Africa/Harare | 24 | | Africa/Johannesburg | 25 | | Africa/Juba | 26 | | Africa/Kampala | 27 | | Africa/Khartoum | 28 | | Africa/Kigali | 29 | | Africa/Kinshasa | 30 | | Africa/Lagos | 31 | | Africa/Libreville | 32 | | Africa/Lome | 33 | | Africa/Luanda | 34 | | Africa/Lubumbashi | 35 | | Africa/Lusaka | 36 | | Africa/Malabo | 37 | | Africa/Maputo | 38 | | Africa/Maseru | 39 | | Africa/Mbabane | 40 | | Africa/Mogadishu | 41 | | Africa/Monrovia | 42 | | Africa/Nairobi | 43 | | Africa/Ndjamena | 44 | | Africa/Niamey | 45 | | Africa/Nouakchott | 46 | | Africa/Ouagadougou | 47 | | Africa/Porto-Novo | 48 | | Africa/Sao_Tome | 49 | | Africa/Timbuktu | 50 | | Africa/Tripoli | 51 | | Africa/Tunis | 52 | | Africa/Windhoek | 53 | | America/Adak | 54 | | America/Anchorage | 55 | | America/Anguilla | 56 | | America/Antigua | 57 | | America/Araguaina | 58 | | America/Argentina/Buenos_Aires | 59 | | America/Argentina/Catamarca | 60 | | America/Argentina/Cordoba | 61 | | America/Argentina/Jujuy | 62 | | America/Argentina/La_Rioja | 63 | | America/Argentina/Mendoza | 64 | | America/Argentina/Rio_Gallegos | 65 | | America/Argentina/Salta | 66 | | America/Argentina/San_Juan | 67 | | America/Argentina/San_Luis | 68 | | America/Argentina/Tucuman | 69 | | America/Argentina/Ushuaia | 70 | | America/Aruba | 71 | | America/Asuncion | 72 | | America/Atikokan | 73 | | America/Atka | 74 | | America/Bahia | 75 | | America/Bahia_Banderas | 76 | | America/Barbados | 77 | | America/Belem | 78 | | America/Belize | 79 | | America/Blanc-Sablon | 80 | | America/Boa_Vista | 81 | | America/Bogota | 82 | | America/Boise | 83 | | America/Cambridge_Bay | 84 | | America/Campo_Grande | 85 | | America/Cancun | 86 | | America/Caracas | 87 | | America/Cayenne | 88 | | America/Cayman | 89 | | America/Chicago | 90 | | America/Chihuahua | 91 | | America/Ciudad_Juarez | 92 | | America/Coral_Harbour | 93 | | America/Costa_Rica | 94 | | America/Creston | 95 | | America/Cuiaba | 96 | | America/Curacao | 97 | | America/Danmarkshavn | 98 | | America/Dawson | 99 | | America/Dawson_Creek | 100 | | America/Denver | 101 | | America/Detroit | 102 | | America/Dominica | 103 | | America/Edmonton | 104 | | America/Eirunepe | 105 | | America/El_Salvador | 106 | | America/Ensenada | 107 | | America/Fort_Nelson | 108 | | America/Fortaleza | 109 | | America/Glace_Bay | 110 | | America/Goose_Bay | 111 | | America/Grand_Turk | 112 | | America/Grenada | 113 | | America/Guadeloupe | 114 | | America/Guatemala | 115 | | America/Guayaquil | 116 | | America/Guyana | 117 | | America/Halifax | 118 | | America/Havana | 119 | | America/Hermosillo | 120 | | America/Indiana/Indianapolis | 121 | | America/Indiana/Knox | 122 | | America/Indiana/Marengo | 123 | | America/Indiana/Petersburg | 124 | | America/Indiana/Tell_City | 125 | | America/Indiana/Vevay | 126 | | America/Indiana/Vincennes | 127 | | America/Indiana/Winamac | 128 | | America/Inuvik | 129 | | America/Iqaluit | 130 | | America/Jamaica | 131 | | America/Juneau | 132 | | America/Kentucky/Louisville | 133 | | America/Kentucky/Monticello | 134 | | America/Kralendijk | 135 | | America/La_Paz | 136 | | America/Lima | 137 | | America/Los_Angeles | 138 | | America/Lower_Princes | 139 | | America/Maceio | 140 | | America/Managua | 141 | | America/Manaus | 142 | | America/Marigot | 143 | | America/Martinique | 144 | | America/Matamoros | 145 | | America/Mazatlan | 146 | | America/Menominee | 147 | | America/Merida | 148 | | America/Metlakatla | 149 | | America/Mexico_City | 150 | | America/Miquelon | 151 | | America/Moncton | 152 | | America/Monterrey | 153 | | America/Montevideo | 154 | | America/Montreal | 155 | | America/Montserrat | 156 | | America/Nassau | 157 | | America/New_York | 158 | | America/Nipigon | 159 | | America/Nome | 160 | | America/Noronha | 161 | | America/North_Dakota/Beulah | 162 | | America/North_Dakota/Center | 163 | | America/North_Dakota/New_Salem | 164 | | America/Nuuk | 165 | | America/Ojinaga | 166 | | America/Panama | 167 | | America/Pangnirtung | 168 | | America/Paramaribo | 169 | | America/Phoenix | 170 | | America/Port-au-Prince | 171 | | America/Port_of_Spain | 172 | | America/Porto_Acre | 173 | | America/Porto_Velho | 174 | | America/Puerto_Rico | 175 | | America/Punta_Arenas | 176 | | America/Rainy_River | 177 | | America/Rankin_Inlet | 178 | | America/Recife | 179 | | America/Regina | 180 | | America/Resolute | 181 | | America/Rio_Branco | 182 | | America/Santa_Isabel | 183 | | America/Santarem | 184 | | America/Santiago | 185 | | America/Santo_Domingo | 186 | | America/Sao_Paulo | 187 | | America/Scoresbysund | 188 | | America/Shiprock | 189 | | America/Sitka | 190 | | America/St_Barthelemy | 191 | | America/St_Johns | 192 | | America/St_Kitts | 193 | | America/St_Lucia | 194 | | America/St_Thomas | 195 | | America/St_Vincent | 196 | | America/Swift_Current | 197 | | America/Tegucigalpa | 198 | | America/Thule | 199 | | America/Thunder_Bay | 200 | | America/Tijuana | 201 | | America/Toronto | 202 | | America/Tortola | 203 | | America/Vancouver | 204 | | America/Virgin | 205 | | America/Whitehorse | 206 | | America/Winnipeg | 207 | | America/Yakutat | 208 | | America/Yellowknife | 209 | | Antarctica/Casey | 210 | | Antarctica/Davis | 211 | | Antarctica/DumontDUrville | 212 | | Antarctica/Macquarie | 213 | | Antarctica/Mawson | 214 | | Antarctica/McMurdo | 215 | | Antarctica/Palmer | 216 | | Antarctica/Rothera | 217 | | Antarctica/Syowa | 218 | | Antarctica/Troll | 219 | | Antarctica/Vostok | 220 | | Arctic/Longyearbyen | 221 | | Asia/Aden | 222 | | Asia/Almaty | 223 | | Asia/Amman | 224 | | Asia/Anadyr | 225 | | Asia/Aqtau | 226 | | Asia/Aqtobe | 227 | | Asia/Ashgabat | 228 | | Asia/Atyrau | 229 | | Asia/Baghdad | 230 | | Asia/Bahrain | 231 | | Asia/Baku | 232 | | Asia/Bangkok | 233 | | Asia/Barnaul | 234 | | Asia/Beirut | 235 | | Asia/Bishkek | 236 | | Asia/Brunei | 237 | | Asia/Chita | 238 | | Asia/Choibalsan | 239 | | Asia/Chongqing | 240 | | Asia/Colombo | 241 | | Asia/Damascus | 242 | | Asia/Dhaka | 243 | | Asia/Dili | 244 | | Asia/Dubai | 245 | | Asia/Dushanbe | 246 | | Asia/Famagusta | 247 | | Asia/Gaza | 248 | | Asia/Harbin | 249 | | Asia/Hebron | 250 | | Asia/Ho_Chi_Minh | 251 | | Asia/Hong_Kong | 252 | | Asia/Hovd | 253 | | Asia/Irkutsk | 254 | | Asia/Istanbul | 255 | | Asia/Jakarta | 256 | | Asia/Jayapura | 257 | | Asia/Jerusalem | 258 | | Asia/Kabul | 259 | | Asia/Kamchatka | 260 | | Asia/Karachi | 261 | | Asia/Kashgar | 262 | | Asia/Kathmandu | 263 | | Asia/Khandyga | 264 | | Asia/Kolkata | 265 | | Asia/Krasnoyarsk | 266 | | Asia/Kuala_Lumpur | 267 | | Asia/Kuching | 268 | | Asia/Kuwait | 269 | | Asia/Macau | 270 | | Asia/Magadan | 271 | | Asia/Makassar | 272 | | Asia/Manila | 273 | | Asia/Muscat | 274 | | Asia/Nicosia | 275 | | Asia/Novokuznetsk | 276 | | Asia/Novosibirsk | 277 | | Asia/Omsk | 278 | | Asia/Oral | 279 | | Asia/Phnom_Penh | 280 | | Asia/Pontianak | 281 | | Asia/Pyongyang | 282 | | Asia/Qatar | 283 | | Asia/Qostanay | 284 | | Asia/Qyzylorda | 285 | | Asia/Riyadh | 286 | | Asia/Sakhalin | 287 | | Asia/Samarkand | 288 | | Asia/Seoul | 289 | | Asia/Shanghai | 290 | | Asia/Singapore | 291 | | Asia/Srednekolymsk | 292 | | Asia/Taipei | 293 | | Asia/Tashkent | 294 | | Asia/Tbilisi | 295 | | Asia/Tehran | 296 | | Asia/Tel_Aviv | 297 | | Asia/Thimphu | 298 | | Asia/Tokyo | 299 | | Asia/Tomsk | 300 | | Asia/Ulaanbaatar | 301 | | Asia/Urumqi | 302 | | Asia/Ust-Nera | 303 | | Asia/Vientiane | 304 | | Asia/Vladivostok | 305 | | Asia/Yakutsk | 306 | | Asia/Yangon | 307 | | Asia/Yekaterinburg | 308 | | Asia/Yerevan | 309 | | Atlantic/Azores | 310 | | Atlantic/Bermuda | 311 | | Atlantic/Canary | 312 | | Atlantic/Cape_Verde | 313 | | Atlantic/Faroe | 314 | | Atlantic/Jan_Mayen | 315 | | Atlantic/Madeira | 316 | | Atlantic/Reykjavik | 317 | | Atlantic/South_Georgia | 318 | | Atlantic/St_Helena | 319 | | Atlantic/Stanley | 320 | | Australia/Adelaide | 321 | | Australia/Brisbane | 322 | | Australia/Broken_Hill | 323 | | Australia/Canberra | 324 | | Australia/Currie | 325 | | Australia/Darwin | 326 | | Australia/Eucla | 327 | | Australia/Hobart | 328 | | Australia/Lindeman | 329 | | Australia/Lord_Howe | 330 | | Australia/Melbourne | 331 | | Australia/Perth | 332 | | Australia/Sydney | 333 | | Australia/Yancowinna | 334 | | CET | 335 | | CST6CDT | 336 | | EET | 337 | | EST | 338 | | EST5EDT | 339 | | Etc/GMT | 340 | | Etc/GMT+0 | 341 | | Etc/GMT+1 | 342 | | Etc/GMT+10 | 343 | | Etc/GMT+11 | 344 | | Etc/GMT+12 | 345 | | Etc/GMT+2 | 346 | | Etc/GMT+3 | 347 | | Etc/GMT+4 | 348 | | Etc/GMT+5 | 349 | | Etc/GMT+6 | 350 | | Etc/GMT+7 | 351 | | Etc/GMT+8 | 352 | | Etc/GMT+9 | 353 | | Etc/GMT-0 | 354 | | Etc/GMT-1 | 355 | | Etc/GMT-10 | 356 | | Etc/GMT-11 | 357 | | Etc/GMT-12 | 358 | | Etc/GMT-13 | 359 | | Etc/GMT-14 | 360 | | Etc/GMT-2 | 361 | | Etc/GMT-3 | 362 | | Etc/GMT-4 | 363 | | Etc/GMT-5 | 364 | | Etc/GMT-6 | 365 | | Etc/GMT-7 | 366 | | Etc/GMT-8 | 367 | | Etc/GMT-9 | 368 | | Etc/GMT0 | 369 | | Etc/Greenwich | 370 | | Etc/UCT | 371 | | Etc/UTC | 372 | | Etc/Universal | 373 | | Etc/Zulu | 374 | | Europe/Amsterdam | 375 | | Europe/Andorra | 376 | | Europe/Astrakhan | 377 | | Europe/Athens | 378 | | Europe/Belfast | 379 | | Europe/Belgrade | 380 | | Europe/Berlin | 381 | | Europe/Bratislava | 382 | | Europe/Brussels | 383 | | Europe/Bucharest | 384 | | Europe/Budapest | 385 | | Europe/Busingen | 386 | | Europe/Chisinau | 387 | | Europe/Copenhagen | 388 | | Europe/Dublin | 389 | | Europe/Gibraltar | 390 | | Europe/Guernsey | 391 | | Europe/Helsinki | 392 | | Europe/Isle_of_Man | 393 | | Europe/Istanbul | 394 | | Europe/Jersey | 395 | | Europe/Kaliningrad | 396 | | Europe/Kirov | 397 | | Europe/Kyiv | 398 | | Europe/Lisbon | 399 | | Europe/Ljubljana | 400 | | Europe/London | 401 | | Europe/Luxembourg | 402 | | Europe/Madrid | 403 | | Europe/Malta | 404 | | Europe/Mariehamn | 405 | | Europe/Minsk | 406 | | Europe/Monaco | 407 | | Europe/Moscow | 408 | | Europe/Nicosia | 409 | | Europe/Oslo | 410 | | Europe/Paris | 411 | | Europe/Podgorica | 412 | | Europe/Prague | 413 | | Europe/Riga | 414 | | Europe/Rome | 415 | | Europe/Samara | 416 | | Europe/San_Marino | 417 | | Europe/Sarajevo | 418 | | Europe/Saratov | 419 | | Europe/Simferopol | 420 | | Europe/Skopje | 421 | | Europe/Sofia | 422 | | Europe/Stockholm | 423 | | Europe/Tallinn | 424 | | Europe/Tirane | 425 | | Europe/Tiraspol | 426 | | Europe/Ulyanovsk | 427 | | Europe/Vaduz | 428 | | Europe/Vatican | 429 | | Europe/Vienna | 430 | | Europe/Vilnius | 431 | | Europe/Volgograd | 432 | | Europe/Warsaw | 433 | | Europe/Zagreb | 434 | | Europe/Zurich | 435 | | GMT | 436 | | HST | 437 | | Indian/Antananarivo | 438 | | Indian/Chagos | 439 | | Indian/Christmas | 440 | | Indian/Cocos | 441 | | Indian/Comoro | 442 | | Indian/Kerguelen | 443 | | Indian/Mahe | 444 | | Indian/Maldives | 445 | | Indian/Mauritius | 446 | | Indian/Mayotte | 447 | | Indian/Reunion | 448 | | MET | 449 | | MST | 450 | | MST7MDT | 451 | | PST8PDT | 452 | | Pacific/Apia | 453 | | Pacific/Auckland | 454 | | Pacific/Bougainville | 455 | | Pacific/Chatham | 456 | | Pacific/Chuuk | 457 | | Pacific/Easter | 458 | | Pacific/Efate | 459 | | Pacific/Fakaofo | 460 | | Pacific/Fiji | 461 | | Pacific/Funafuti | 462 | | Pacific/Galapagos | 463 | | Pacific/Gambier | 464 | | Pacific/Guadalcanal | 465 | | Pacific/Guam | 466 | | Pacific/Honolulu | 467 | | Pacific/Johnston | 468 | | Pacific/Kanton | 469 | | Pacific/Kiritimati | 470 | | Pacific/Kosrae | 471 | | Pacific/Kwajalein | 472 | | Pacific/Majuro | 473 | | Pacific/Marquesas | 474 | | Pacific/Midway | 475 | | Pacific/Nauru | 476 | | Pacific/Niue | 477 | | Pacific/Norfolk | 478 | | Pacific/Noumea | 479 | | Pacific/Pago_Pago | 480 | | Pacific/Palau | 481 | | Pacific/Pitcairn | 482 | | Pacific/Pohnpei | 483 | | Pacific/Port_Moresby | 484 | | Pacific/Rarotonga | 485 | | Pacific/Saipan | 486 | | Pacific/Samoa | 487 | | Pacific/Tahiti | 488 | | Pacific/Tarawa | 489 | | Pacific/Tongatapu | 490 | | Pacific/Wake | 491 | | Pacific/Wallis | 492 | | Pacific/Yap | 493 | | UTC | 494 | | WET | 495 | | localtime | 496 | | posixrules | 497 | +--------------------------------+--------------+ 497 rows in set (0.061 sec)
/etc/mysql/mariadb.conf.d/50-server.cnf
[mariadb]
default_time_zone = 'Asia/Almaty'
php.ini
[Date]
date.timezone = Asia/Almaty
Hello @USG738 You may also need to define the timezone in the PHP.INI of GLPI and of PM server Thank you, Regards, Tomolimo
@tomolimo The same configuration in PHP of both servers
[Date] date.timezone = Asia/Almaty
Hello @USG738 Did you also install the TZ tables in the DB server of GLPI? Thank you Regards, Tomolimo
@tomolimo Yep.
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -p -u root mysql MariaDB [(none)]> GRANT SELECT ON
mysql.time_zone_nameTO 'root'@'%';
Hello @USG738 Ok for me How could we proceed? Thank you, Regards, Tomolimo
Hello @USG738
I've suceeded to log into the VM and to log into GLPI and PM :)
I can see that the PM server configuration has not been done like requested in the wiki, here:
The glpi dedicated skins are missing, see https://github.com/tomolimo/processmaker-server/wiki/Skins
It strongly advise to follow the PM server configuration check to be sure that everything has been configured as needed:
https://github.com/tomolimo/processmaker-server/wiki/ProcessMaker-server-configuration-check
Thank you Regards, Tomolimo