PHP version bump?

[CarlSinclair]

PHP version bump?

[alextselegidis]

Hello!

What is the exact issue you are experiencing?

Alex Tselegidis, Easy!Appointments Creator Need a customization? Get a free quote!

[CarlSinclair]

I couldn't remember the issue I ran into so I completely removed the working directory and recloned it and it failed to install.

npm WARN deprecated [email protected]: CircularJSON is in maintenance only, flatted is its successor.
npm ERR! code ECONNREFUSED
npm ERR! syscall read
npm ERR! errno -111
npm ERR! Error: read ECONNREFUSED
npm ERR!     at TLSWrap.onStreamRead (node:internal/stream_base_commons:217:20)
npm ERR!  Error: read ECONNREFUSED
npm ERR!     at TLSWrap.onStreamRead (node:internal/stream_base_commons:217:20) {
npm ERR!   errno: -111,
npm ERR!   code: 'ECONNREFUSED',
npm ERR!   syscall: 'read'
npm ERR! }
npm ERR!
npm ERR! If you are behind a proxy, please make sure that the
npm ERR! 'proxy' config is set properly.  See: 'npm help config'

npm ERR! A complete log of this run can be found in: /root/.npm/_logs/2024-06-26T05_15_21_473Z-debug-0.log

This is from the full log:

2686 timing metavuln:cache:put:security-advisory:loader-utils:1sF2d2kRk0rCaucKb27PCBAqzUCYbhdBzRwoo5rxF/uoXZUrmcjSgxDkzMXyLB/atKKHPvA15V2wA99dxlrncg== Completed in 992ms
2687 timing metavuln:calculate:security-advisory:loader-utils:1095055 Completed in 30235ms
2688 timing metavuln:cache:put:security-advisory:loader-utils:v7Ifph5qavsi9CgJh5wB3PsIOi/3F8gd3zNXA1qRhTWv7kn6fc9Jnd4YaugKqsiK/Hxi4qTcp/pRjytD7+Gl/w== Completed in 992ms
2689 timing metavuln:calculate:security-advisory:loader-utils:1097143 Completed in 30235ms
2690 http fetch GET 200 https://registry.npmjs.org/js2xmlparser/-/js2xmlparser-4.0.1.tgz 29335ms (cache miss)
2691 timing reifyNode:node_modules/js2xmlparser Completed in 32136ms
2692 timing metavuln:cache:put:security-advisory:y18n:QAat+cWNJ5Ijyx8ozBGCUC/lL/NzgUPks9N+j5r3aUiTPgGk5T0PtpgW8EhdlktHyX34Ct2/pJCG4Mxn/FH38w== Completed in 1151ms
2693 timing metavuln:calculate:security-advisory:y18n:1095086 Completed in 30306ms
2694 timing reifyNode:node_modules/@nodelib/fs.walk Completed in 31719ms
2695 verbose stack Error: read ECONNREFUSED
2695 verbose stack     at TLSWrap.onStreamRead (node:internal/stream_base_commons:217:20)
2696 verbose cwd /var/www/html/easy
2697 verbose Linux 5.14.0-427.20.1.el9_4.x86_64
2698 verbose node v20.12.2
2699 verbose npm  v10.5.0
2700 error code ECONNREFUSED
2701 error syscall read
2702 error errno -111
2703 error Error: read ECONNREFUSED
2703 error     at TLSWrap.onStreamRead (node:internal/stream_base_commons:217:20) {
2703 error   errno: -111,
2703 error   code: 'ECONNREFUSED',
2703 error   syscall: 'read'
2703 error }
2704 error
2704 error If you are behind a proxy, please make sure that the
2704 error 'proxy' config is set properly.  See: 'npm help config'
2705 verbose exit -111
2706 timing npm Completed in 35045ms
2707 verbose unfinished npm timer command:install 1719378921867
2708 verbose unfinished npm timer reify 1719378921873
2709 verbose unfinished npm timer reify:audit 1719378924207
2710 verbose unfinished npm timer reify:unpack 1719378924249
2711 verbose unfinished npm timer reifyNode:node_modules/yargs-parser 1719378924251
2712 verbose unfinished npm timer reifyNode:node_modules/yargs 1719378924252

The unfinished npm timer continues until the end:

4184 verbose unfinished npm timer metavuln:cache:put:security-advisory:follow-redirects:zA/oqIdGuxN4me/fprcgj/YqPMzVawutoOnpdU59Mh5Ry8HDIEFb+IZboXNwyTJJZ9cZOa5pGEKLh/NJoww51g== 17193789563>4185 verbose unfinished npm timer metavuln:cache:put:security-advisory:semver:g1vJG11wXBTamuqcp6anLd2yC0AnCjlhaLFglyJx4rEfKLK+YF116HpQw1CsB0bwCPUkxcSemSBkmLIdEXe6xw== 1719378956359
4186 verbose unfinished npm timer metavuln:cache:put:security-advisory:semver:YpN6YES21bdtFcj77J4gyDAcoFtVQs6y6pK52a0QXHM6ITXJjpkpE9IpjL8F/hL80Wqt9oIs2axXssYOcSOYHA== 1719378956363
4187 verbose code -111
4188 error A complete log of this run can be found in: /root/.npm/_logs/2024-06-26T05_15_21_473Z-debug-0.log

[CarlSinclair]

I just tried the 1.5 alpha linked on the website and got this:

An uncaught Exception was encountered
Type
mysqli_sql_exception

Message
No such file or directory

Filename
/var/www/html/res/system/database/drivers/mysqli/mysqli_driver.php

Line Number
203

Of course the file exists at that location and all files are owned by the web server user. Here's my config.php:

class Config {

    // ------------------------------------------------------------------------
    // GENERAL SETTINGS
    // ------------------------------------------------------------------------

    const BASE_URL      = 'https://easyappointments.domain.com';
    const LANGUAGE      = 'english';
    const DEBUG_MODE    = TRUE;

    // ------------------------------------------------------------------------
    // DATABASE SETTINGS
    // ------------------------------------------------------------------------

    const DB_HOST       = 'localhost';
    const DB_NAME       = '[redacted];
    const DB_USERNAME   = '[redacted]';
    const DB_PASSWORD   = '[redacted]';

    // ------------------------------------------------------------------------
    // GOOGLE CALENDAR SYNC
    // ------------------------------------------------------------------------

    const GOOGLE_SYNC_FEATURE   = FALSE; // Enter TRUE or FALSE
    const GOOGLE_PRODUCT_NAME   = '';
    const GOOGLE_CLIENT_ID      = '';
    const GOOGLE_CLIENT_SECRET  = '';
    const GOOGLE_API_KEY        = '';
}

/* End of file config.php */

The "stable" v1.4.3 zip from the website throws the following errors in the browser, which I assume are related to the PHP version:

A PHP Error was encountered
Severity: 8192

Message: Creation of dynamic property CI_URI::$config is deprecated

Filename: core/URI.php

Line Number: 101

A PHP Error was encountered
Severity: 8192

Message: Creation of dynamic property CI_Router::$uri is deprecated

Filename: core/Router.php

Line Number: 127

A PHP Error was encountered
Severity: 8192

Message: Creation of dynamic property Appointments::$benchmark is deprecated

Filename: core/Controller.php

Line Number: 82

A PHP Error was encountered
Severity: 8192

Message: Creation of dynamic property Appointments::$config is deprecated

Filename: core/Controller.php

Line Number: 82

A PHP Error was encountered
Severity: 8192

Message: Creation of dynamic property Appointments::$log is deprecated

Filename: core/Controller.php

Line Number: 82

A PHP Error was encountered
Severity: 8192

Message: Creation of dynamic property Appointments::$hooks is deprecated

Filename: core/Controller.php

Line Number: 82

A PHP Error was encountered
Severity: 8192

Message: Creation of dynamic property Appointments::$utf8 is deprecated

Filename: core/Controller.php

Line Number: 82

A PHP Error was encountered
Severity: 8192

Message: Creation of dynamic property Appointments::$uri is deprecated

Filename: core/Controller.php

Line Number: 82

A PHP Error was encountered
Severity: 8192

Message: Creation of dynamic property Appointments::$exceptions is deprecated

Filename: core/Controller.php

Line Number: 82

A PHP Error was encountered
Severity: 8192

Message: Creation of dynamic property Appointments::$router is deprecated

Filename: core/Controller.php

Line Number: 82

A PHP Error was encountered
Severity: 8192

Message: Creation of dynamic property Appointments::$output is deprecated

Filename: core/Controller.php

Line Number: 82

A PHP Error was encountered
Severity: 8192

Message: Creation of dynamic property Appointments::$security is deprecated

Filename: core/Controller.php

Line Number: 82

A PHP Error was encountered
Severity: 8192

Message: Creation of dynamic property Appointments::$input is deprecated

Filename: core/Controller.php

Line Number: 82

A PHP Error was encountered
Severity: 8192

Message: Creation of dynamic property Appointments::$lang is deprecated

Filename: core/Controller.php

Line Number: 82

A PHP Error was encountered
Severity: 8192

Message: Creation of dynamic property Appointments::$db is deprecated

Filename: core/Loader.php

Line Number: 397

A PHP Error was encountered
Severity: 8192

Message: Creation of dynamic property CI_DB_mysqli_driver::$autoinit is deprecated

Filename: database/DB_driver.php

Line Number: 371

A PHP Error was encountered
Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /var/www/html/res/system/core/Exceptions.php:283)

Filename: core/Common.php

Line Number: 574

An uncaught Exception was encountered
Type: mysqli_sql_exception

Message: No such file or directory

Filename: /var/www/html/res/system/database/drivers/mysqli/mysqli_driver.php

Line Number: 203

[alextselegidis]

Hello!

Thanks for the info.

Let's stick with 1.5 for now as this is the release that supports the latest PHP versions

An uncaught Exception was encountered
Type
mysqli_sql_exception

Message
No such file or directory

Filename
/var/www/html/res/system/database/drivers/mysqli/mysqli_driver.php

Line Number
203

This error means that the connection to MySQL failed

Please check your connection info and try again.

Re-open if you find new php errors with the latest 1.5 package (beta)

Alex Tselegidis, Easy!Appointments Creator Need a customization? Get a free quote!

[CarlSinclair]

I'm not sure what happened but the issue seems to have fixed itself. I now have a fully working v1.5 install with webhooks working! Hopefully WebDAV comes soon. And the custom sorting of services, but I was able to alphabetically hack it.

Question. Is it possible to increase the time slot interval? 15 minutes is too frequent. I'd like to make it hourly or at the most every half hour.