shiobi

Bump. I would like to know, too 🙂

We are experiencing the same issue. No changes were made on our end.

Hello. When you are trying to mention someone in a comment on Pages application, the following error appears in System Logs: SELECT user FROM `forocms_database_comments` AS `cms_database_comments` WHERE comment_approved = 1 AND comment_record_id=12316 AND cms_database_comments.user IN(SELECT core_members.member_id FROM `forocore_members` AS `core_members` WHERE core_members.name LIKE CONCAT( 'as', '%' )) LIMIT 10 IPS\Db\Exception: Unknown column 'user' in 'field list' (1054) #0 /var/www/html/system/Db/Select.php(388): IPS\_Db->preparedQuery() #1 /var/www/html/system/Db/Select.php(446): IPS\Db\_Select->runQuery() #2 [internal function]: IPS\Db\_Select->rewind() #3 /var/www/html/system/Content/Statistics.php(160): iterator_to_array() #4 /var/www/html/applications/core/modules/front/system/editor.php(356): IPS\cms\_Records->mostRecent() #5 /var/www/html/system/Dispatcher/Controller.php(107): IPS\core\modules\front\system\_editor->mention() #6 /var/www/html/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #7 /var/www/html/index.php(13): IPS\_Dispatcher->run() #8 {main} This started happening after upgrading to 4.7.11. Thanks

Well, I think I have fixed this issue. I replaced Nginx with Apache, and now I can login without problems. I'll continue investigating this. I have been using Nginx since I installed Invision Community for the first time. It is very weird...

Everything is okay.

Yes, the same issue happens.

Perfect, I didn't know that. I changed the PHP version to 8.1.

Update: I deleted the VM and created a new one, this time with Ubuntu 20.04.5 LTS. And also: Upgraded to PHP Version 8.2.2 Upgraded MariaDB to 10.6.11-MariaDB-0ubuntu0.22.04.1 But the same problem 😥

Thanks! Please let me know if there is anything else I can provide.

Well, it's so weird. This is my own server, and I created a VM with Ubuntu specifically for this test installation (twice, indeed, to discard if it was a VM problem). We are migrating to my own server. The production environment is using another host, but it's a bare metal plan with a different distro and PHP version. So in the past, I've installed this software several times, and this is the first time I've encountered a problem like this. 😥

'base_url' in conf_global.php has https in the domain: If there is some caching, I don't know where I should start searching 😪

Yes, sorry. This is happening on my test instance (https://test.xxxxxx).

This option is already enabled. Done!

Bump this

Yes, https is configured on conf_global.php. I updated my access details. Thanks!

Is it possible to move this topic to Help & Support? Thanks 😀

The server runs Nginx. It doesn't use .htaccess. Here is the Nginx configuration file: server { listen 80 default_server; listen [::]:80 default_server; root /var/www/html; # Add index.php to the list if you are using PHP index index.php index.html index.htm index.nginx-debian.html; server_name _; set_real_ip_from 172.10.1.0/24; set_real_ip_from 173.245.48.0/20; set_real_ip_from 103.21.244.0/22; set_real_ip_from 103.22.200.0/22; set_real_ip_from 103.31.4.0/22; set_real_ip_from 141.101.64.0/18; ... real_ip_header CF-Connecting-IP; location / { # First attempt to serve request as file, then # as directory, then fall back to displaying a 404. # try_files $uri $uri/ =404; try_files $uri $uri/ /index.php?$args; } location /api/ { if (!-e $request_filename) { rewrite ^/api/(.*)$ /api/index.php; } } # pass PHP scripts to FastCGI server # location ~ \.php$ { include snippets/fastcgi-php.conf; # With php-fpm (or other unix sockets): fastcgi_pass unix:/run/php/php8.1-fpm.sock; # With php-cgi (or other tcp sockets): # fastcgi_pass 127.0.0.1:9000; } }

No, it doesn't. The same problem happens.

I also tried disabling Cloudflare completely but the issue persists. That's the only non-default thing that could be related.

No, I don't.

Reinstalled and the issue persists 😪 Invision Community Version 4.7.6 PHP Version 8.1.2-1ubuntu2.10 Database Version 5.5.5-10.6.11-MariaDB-0ubuntu0.22.04.1 I can share any additional information if needed.

I will try it and post any updates. Thanks

Yes. I did a fresh install, so the requirements checker passed successfully at the beginning of the installation.

I have already tried it 😓 The problem persists.

Everything is okay. This issue happens only when I try to log in on the frontend.