ronetbus Posted November 13, 2017 Report Posted November 13, 2017 I get this error message: PDOStatement: Cannot add or update a child row: a foreign key constraint fails (`s3x`.`s3x_session`, CONSTRAINT `session_browser` FOREIGN KEY (`browserid`) REFERENCES `browser` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) Error Details: [lib/base.php:2152] Base->error() [lib/db/sql/mapper.php:422] DB\SQL->exec() [ui/account/sessions.php:40] DB\SQL\Mapper->insert() [ui/account/index.php:244] createSession() [lib/base.php:1599] Base->call() [index.php:514] Base->run()
Administrators rawTOP Posted November 13, 2017 Author Administrators Report Posted November 13, 2017 Sorry for the delay. Everything worked when I tested it, but then I took the weekend off. Unfortunately as soon as there were zero people in the chatroom things failed because it tested to see if >0 were in there to do something critical. I've changed it to >=0 and now everything should work. ronetbus – I'm not sure the problem you reported is the same problem, so I'll look into that next.
Moderators drscorpio Posted November 13, 2017 Moderators Report Posted November 13, 2017 PDOStatement: Cannot add or update a child row: a foreign key constraint fails (`s3x`.`s3x_session`, CONSTRAINT `session_browser` FOREIGN KEY (`browserid`) REFERENCES `browser` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) Error Details: [lib/base.php:2152] Base->error() [lib/db/sql/mapper.php:422] DB\SQL->exec() [ui/account/sessions.php:40] DB\SQL\Mapper->insert() [ui/account/index.php:244] createSession() [lib/base.php:1599] Base->call() [index.php:514] Base->run() Got this just now.
Guest BBBeard Posted November 13, 2017 Report Posted November 13, 2017 Hi RawTop I still cannot come into the chat. Now i get the message that This is a members-only chat. You must login to see the discussion. I hope this problem will be solved soon too. Thanks BBBeard
Administrators rawTOP Posted November 13, 2017 Author Administrators Report Posted November 13, 2017 1 hour ago, BBBeard said: Hi RawTop I still cannot come into the chat. Now i get the message that This is a members-only chat. You must login to see the discussion. I hope this problem will be solved soon too. Thanks BBBeard The short version of a long explanation is you now have to wait for the check of how many people are in chat before you can go into chat. I've changed it so there's just a . while those stats are loading. When they're loading it changes to "Chat". At that point it's safe to click.
Administrators rawTOP Posted November 13, 2017 Author Administrators Report Posted November 13, 2017 2 hours ago, drscorpio said: PDOStatement: Cannot add or update a child row: a foreign key constraint fails (`s3x`.`s3x_session`, CONSTRAINT `session_browser` FOREIGN KEY (`browserid`) REFERENCES `browser` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) If anyone is still seeing this error, please let me know. I've made some changes, but I may not have fixed what's causing the problem, so need to know details. UPDATE: The fact that I'm the only one in chat right now makes me think something is wrong. But there were some guys who got in a little while ago…
Guest Posted November 13, 2017 Report Posted November 13, 2017 Chat still not working correctly. I am logged in. It says there are two people in the chat room, when I try to enter I get a message saying you must be a member. I even tried rebooting. Nothing.
constructionguy Posted November 13, 2017 Report Posted November 13, 2017 can't get into the chat...says I must log in after I have already logged in
Administrators rawTOP Posted November 13, 2017 Author Administrators Report Posted November 13, 2017 I have something else I'm gonna try. So give me a half hour or so… [A few of you can get into chat (including me), but not everyone. I think I know why…]
GeorgiaBoy Posted November 13, 2017 Report Posted November 13, 2017 Hey--it is still not working. It is asking for me to log in again--but I'm logged in.
Administrators rawTOP Posted November 13, 2017 Author Administrators Report Posted November 13, 2017 19 minutes ago, GeorgiaBoy said: Hey--it is still not working. It is asking for me to log in again--but I'm logged in. My comment just above yours answers your question.
Administrators rawTOP Posted November 13, 2017 Author Administrators Report Posted November 13, 2017 I think I'm closer. Now I'm seeing a problem with the authentication keys I'm passing after you're logged into the new system. If they contain a + things don't work. So let me work on that now. But those of you lucky enough to not get a + in your login hashes should be able to get in right now.
Recommended Posts