shiobi

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

32 minutes ago, Marc Stridgen said:

Have you checked all requirements after you have switched to 8.1 using the requirement checker?

Everything is okay.

4 hours ago, Marc Stridgen said:

Let us know if you have any problems once you have switched

Yes, the same issue happens.

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

On 1/31/2023 at 11:07 AM, shiobi said:

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.

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 😪 

1 hour ago, Marc Stridgen said:

You dont seem to have answered the question asked by my colleague there, as to whether this is your test instance?

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

15 hours ago, ThunderBlue said:

Hi. You might try activating this option in Admincp/System/Advanced Configuration.

 

This option is already enabled.

6 hours ago, Jim M said:

Is this your Test URL which you're having issues logging in with? Please disable CloudFlare for the time being to see if it is having any impact. I keep seeing IP address conflicts when attempting to login.

Done!

On 2/1/2023 at 9:21 AM, shiobi said:

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

Bump this

9 minutes ago, Marc Stridgen said:

Please check your conf_global.php file, and ensure if you are using https on the server, you also have your address set to https there. If thats not the cause, please update your access details on file for the new server, and we can get this looked into

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 😀

2 minutes ago, Richard Arch said:

What about a .htaccess file could that have a redirect error.

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;
        }
}

2 minutes ago, Randy Calvert said:

From the admin area, create a new account. Does that new account work?

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.

6 minutes ago, Nathan Explosion said:

Do you have a constants.php file in the root of the installation?

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

17 minutes ago, Richard Arch said:

Have you checked your new server meets the requirements?

 

 

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

8 hours ago, Randy Calvert said:

Try a different browser. If it works, there might be a problem with your cache on the first. Purge it and try again. 

I have already tried it 😓 The problem persists.

31 minutes ago, Randy Calvert said:

What happens if you login to your ACP?  (domain.com/admin) 

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

Hi everyone.

I'm in the process of migrating from Invision Community 4.7.3 to the latest release (4.7.6 at the moment), but before doing so, I'm testing everything on a new server because the current server is somehow... old; it can't even support PHP 8. This new server will host the production community if everything goes well.

Well, the first step was installing Invision Community from scratch, but my problem is very simple: I can't login to frontend. When I enter my login information into the login box, the software redirects me to ?_fromLogin=1 but nothing happens. I keep logging out.

This is a fresh installation, so I don't have any 3rd party customizations installed, and there are no errors in PHP and/or system logs. So I don't know how to continue.

Has anyone had this issue? Thanks!