On Coppermine 1.6.19, we are having a problem with mail NOT being sent out to new users that try to register.
The contact form works fine, however the New User Registration is NOT sending out any email.
Our script is located in a subdirectory.
We found the following errors in the logs for that server:
22-Sep-2022 10:33:56 -0500]: <4851748e> PHP Error: Request security check failed (POST /cpsess0127539898/3rdparty/roundcube/index.php?_task=mail&_action=refresh)
[22-Sep-2022 10:44:43 -0500]: <99379e5b> PHP Error: Request security check failed (POST /cpsess0127539898/3rdparty/roundcube/index.php?_task=mail&_action=refresh)
[22-Sep-2022 10:54:05 -0500]: <d1795878> PHP Error: Request security check failed (POST /cpsess8332004213/3rdparty/roundcube/index.php?_task=mail&_action=refresh)
I also found this error.
<<Sep 24, 2022 am30 01:20 AM - While executing query 'SELECT cid FROM cpgan_categories WHERE lft BETWEEN AND ' in include/functions.inc.php on line 49 the following error was encountered:
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND' at line 1>>
we contacted our tech support for our server and asked them to check it out and were told,
<<The error indicate that there is an issue with the sintax itself and/or the MYSQL version of the server. That said I would like to note that currently your server is running on MYSQL version 8.0.30. Moreover change in the MYSQL version is not possible as your account is located on one of our shared hosting servers. >>
So, does anyone here have any clue as to why Coppermine is sending mail on the contact forum but not for new registrations?
I might also mention that when someone tries to register, there is no message being displayed to the user, indicating if their registration was accepted, or telling them to check their email to authorize it, or anything else.
WE CAN add new users manually, but we are concerned about our reputation when people try to register and get no response from the program or us, if we don’t know they are trying to register.
Thanks.