database value you're trying to insert does not exist: smiley_set

Started by PrimalPrime, October 22, 2023, 09:16:08 AM

Previous topic - Next topic

PrimalPrime

I've read a few threads about this and I had this error months ago and thought I fixed it by restoring default smileys files even though we aren't using them. This sequence of errors happened twice at the same time shown. I don't see any scheduled tasks at that time. I appreciate any help. Thank you.

Guest
88ac5023d30f078fc94a2aa5a069bb2b
https://mysite.com/index.php?seomod=logout%2Fd3066f4201%3D9188c1a646ed178512043426adcc9ecb;action=logout;logout=1;d3066f4201=9188c1a646ed178512043426adcc9ecb
/home/mysite/public_html/Sources/Subs.php (Line 3955)
Backtrace information

Type of error: Critical
Error message Select
The database value you're trying to insert does not exist: smiley_set
Function: parsesmileys
24
Today at 12:18 AM
Guest
88ac5023d30f078fc94a2aa5a069bb2b
https://chatcuck.com/index.php?seomod=logout%2Fd3066f4201%3D9188c1a646ed178512043426adcc9ecb;action=logout;logout=1;d3066f4201=9188c1a646ed178512043426adcc9ecb
/home/mysite/public_html/Sources/Subs.php (Line 3955)
Backtrace information

Type of error: Undefined
Error message Select
2: Undefined array key "smiley_set"
23
Today at 12:18 AM
Guest
88ac5023d30f078fc94a2aa5a069bb2b
https://mysite.com/index.php?seomod=logout%2Fd3066f4201%3D9188c1a646ed178512043426adcc9ecb;action=logout;logout=1;d3066f4201=9188c1a646ed178512043426adcc9ecb
/home/mysite/public_html/Sources/Subs.php (Line 3944)
Backtrace information

Type of error: Undefined
Error message Select
2: Undefined array key "smiley_set"
22
Today at 12:18 AM
Guest
88ac5023d30f078fc94a2aa5a069bb2b
https://mysite.com/index.php?seomod=logout%2Fd3066f4201%3D9188c1a646ed178512043426adcc9ecb;action=logout;logout=1;d3066f4201=9188c1a646ed178512043426adcc9ecb
Backtrace information

Type of error: Logins
Error message Select
Sorry, but you've reached your login attempts threshold for account XXXXXX. Please wait 30 seconds and try again later.
21
Today at 12:18 AM
Guest
88ac5023d30f078fc94a2aa5a069bb2b
https://mysite.com/index.php?seomod=logout%2Fd3066f4201%3D9188c1a646ed178512043426adcc9ecb;action=logout;logout=1;d3066f4201=9188c1a646ed178512043426adcc9ecb
/home/mysite/public_html/Sources/Errors.php (Line 222)
Backtrace information

Type of error: General
Error message Select
2: Trying to access array offset on value of type null
20
Today at 12:18 AM
Guest
196a0ac648fd34394a28b4258e853603
https://mysite.com/index.php?seomod=logout%2Fd3066f4201%3D9188c1a646ed178512043426adcc9ecb;action=logout;logout=1;d3066f4201=9188c1a646ed178512043426adcc9ecb
/home/mysite/public_html/Sources/Subs.php (Line 3955)
Backtrace information

Type of error: Critical
Error message Select
The database value you're trying to insert does not exist: smiley_set
Function: parsesmileys
19
Today at 12:18 AM
Guest
196a0ac648fd34394a28b4258e853603
https://mysite.com/index.php?seomod=logout%2Fd3066f4201%3D9188c1a646ed178512043426adcc9ecb;action=logout;logout=1;d3066f4201=9188c1a646ed178512043426adcc9ecb
/home/mysite/public_html/Sources/Subs.php (Line 3955)
Backtrace information

Type of error: Undefined
Error message Select
2: Undefined array key "smiley_set"
18
Today at 12:18 AM
Guest
196a0ac648fd34394a28b4258e853603
https://mysite.com/index.php?seomod=logout%2Fd3066f4201%3D9188c1a646ed178512043426adcc9ecb;action=logout;logout=1;d3066f4201=9188c1a646ed178512043426adcc9ecb
/home/mysite/public_html/Sources/Subs.php (Line 3944)

PrimalPrime

I see the default smileys sets aren't installed, though the files are there. Could be source of problem? Add the sets back?

Screenshot: https://prnt.sc/eKne89C6Vkkd

Thank you


PrimalPrime

I noticed that also. There is a cache setting at Cloudflare that causes problems with our menu when enabled, ignore query string, that impacts the login-logout button badly. I was experimenting with an ignore querty string setting on a different page but that page is in the menu. It is possible this was causing this problem. I did notice when I logged out, it asked me if I was sure. That behavior was associated with that cache setting. It is supposed to take you right to the home page and normally does. And, yes, we are using the smf packs seo mod.

Advertisement: