Recently I have had a lot of problems with giving users new passwords, and with new users registering.
I will be paying a friend of mine to get to the bottom of this problem, because its so important to me, but I want to gather info from all corners in order to (1) help him and save his time and my cost, and (2) provide a good solution to the community. Probably the root cause is me doing something stupid, but if I have a working solution then I will post it for others.
Problem 1: The links received when resetting the password don't work, even within seconds of sending them. They send you to the login screen, but the new passwords provided do not work and that is with multiple attempts.
Problem 2: New users sign up but can't confirm their email, I will get info on what is happening in these cases. I can see them signing up multiple times...
This seems to happen regularly, like 3 out of every 15 new registrations or so. I do not believe they are bots or anything like that, the user names and emails all sort of check out as being real users.
I have many, many errors in my log, I let them build up, stupidly. I hope they may be helpful to find some fixes.
The log file is huge, but just focusing on recent reports, I have two which repeat again and again, with many in a row before changing to the other one, they are:
[2014-10-07 18:42:11] (ERROR @ /home/rayxilaw/public_html/core/components/discuss/hooks/board/post/getlist.php : 153) PHP warning: substr() expects parameter 3 to be long, string given
[2014-10-07 21:59:25] (ERROR @ /home/rayxilaw/public_html/core/cache/includes/elements/modsnippet/16.include.cache.php : 39) PHP warning: in_array() expects parameter 2 to be array, string given
Here is a sample of the logfile, there are lots of repeated warnings about the above, and then sometimes a small bit of some other issue, hope this isn't throwing too much at people:
[2014-09-28 04:08:49] (ERROR @ /home/rayxilaw/public_html/core/components/discuss/hooks/board/post/getlist.php : 153) PHP warning: substr() expects parameter 3 to be long, string given
[2014-09-29 11:02:41] (ERROR @ /index.php) Could not get table class for class: modAccess
[2014-09-29 11:02:41] (ERROR @ /index.php) Could not get table name for class: modAccess
[2014-09-29 11:02:41] (ERROR @ /index.php) Error 42000 executing statement:
Array
(
[0] => 42000
[1] => 1064
[2] => 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 'AS `modAccess` WHERE `modAccess`.`principal` = 196' at line 1
)
[2014-09-30 01:06:28] (ERROR @ /home/rayxilaw/public_html/core/cache/includes/elements/modsnippet/16.include.cache.php : 39) PHP warning: in_array() expects parameter 2 to be array, string given
[2014-10-07 18:42:11] (ERROR @ /home/rayxilaw/public_html/core/components/discuss/hooks/board/post/getlist.php : 153) PHP warning: substr() expects parameter 3 to be long, string given
[2014-10-07 21:59:25] (ERROR @ /home/rayxilaw/public_html/core/cache/includes/elements/modsnippet/16.include.cache.php : 39) PHP warning: in_array() expects parameter 2 to be array, string given
[2014-10-07 22:32:01] (ERROR @ /index.php) disThread: Attempt to set NOT NULL field class_key to NULL
[2014-10-07 22:32:49] (ERROR @ /index.php) disThread: Attempt to set NOT NULL field class_key to NULL
[2014-10-07 22:33:38] (ERROR @ /index.php) disThread: Attempt to set NOT NULL field class_key to NULL
[2014-10-07 22:34:21] (ERROR @ /index.php) disThread: Attempt to set NOT NULL field class_key to NULL
[2014-10-07 22:35:15] (ERROR @ /index.php) disThread: Attempt to set NOT NULL field class_key to NULL
[2014-10-07 22:35:49] (ERROR @ /index.php) disThread: Attempt to set NOT NULL field class_key to NULL
[2014-10-07 23:47:53] (ERROR @ /home/rayxilaw/public_html/core/cache/includes/elements/modsnippet/16.include.cache.php : 39) PHP warning: in_array() expects parameter 2 to be array, string given
[2014-10-07 23:47:53] (ERROR @ /home/rayxilaw/public_html/core/cache/includes/elements/modsnippet/16.include.cache.php : 39) PHP warning: in_array() expects parameter 2 to be array, string given
Ok, hope I can get some feedback to direct my friend a bit, thanks in advance!