I noticed the below error from this morning @ 2:19am.
The database value you're trying to insert does not exist: smiley_set
Function: parsesmileys
Additionally, for some reason the forum also is not recognizing the current version of software.
Version Information:
Forum version: SMF 2.1.3
Current SMF version: [object HTMLElement]
I am on 2.1.3.
Ideas on what's going on?
The current version thing is due to an issue with our servers here...
The other... what was the triggering url and the rest of the error message?
I think this is what you're looking for.
call_integration_hook('integrate_smileys', array(&$smileyPregSearch, &$smileyPregReplacements));
3878:
3879: // If smileyPregSearch hasn't been set, do it now.
3880: if (empty($smileyPregSearch))
3881: {
3882: // Cache for longer when customized smiley codes aren't enabled
3883: $cache_time = empty($modSettings['smiley_enable']) ? 7200 : 480;
3884:
3885: // Load the smileys in reverse order by length so they don't get parsed incorrectly.
3886: if (($temp = cache_get_data('parsing_smileys_' . $user_info['smiley_set'], $cache_time)) == null)
3887: {
3888: $result = $smcFunc['db_query']('', '
3889: SELECT s.code, f.filename, s.description
3890: FROM {db_prefix}smileys AS s
3891: JOIN {db_prefix}smiley_files AS f ON (s.id_smiley = f.id_smiley)
3892: WHERE f.smiley_set = {string:smiley_set}' . (empty($modSettings['smiley_enable']) ? '
3893: AND s.code IN ({array_string:default_codes})' : '') . '
3894: ORDER BY LENGTH(s.code) DESC',
3895: array(
3896: 'default_codes' => array('>:D', ':D', '::)', '>:(', ':))', ':)', ';)', ';D', ':(', ':o', '8)', ':P', '???', ':-[', ':-X', ':-*', ':\'(', ':-\\', '^-^', 'O0', 'C:-)', 'O:-)'),
==>3897: 'smiley_set' => $user_info['smiley_set'],
3898: )
3899: );
3900: $smileysfrom = array();
3901: $smileysto = array();
3902: $smileysdescs = array();
3903: while ($row = $smcFunc['db_fetch_assoc']($result))
3904: {
3905: $smileysfrom[] = $row['code'];
3906: $smileysto[] = $smcFunc['htmlspecialchars']($row['filename']);
3907: $smileysdescs[] = !empty($txt['icon_' . strtolower($row['description'])]) ? $txt['icon_' . strtolower($row['description'])] : $row['description'];
3908: }
3909: $smcFunc['db_free_result']($result);
3910:
3911: cache_put_data('parsing_smileys_' . $user_info['smiley_set'], array($smileysfrom, $smileysto, $smileysdescs), $cache_time);
3912: }
3913: else
3914: list ($smileysfrom, $smileysto, $smileysdescs) = $temp;
3915:
3916: // The non-breaking-space is a complex thing...
3917: $non_breaking_space = $context['utf8'] ? '\x{A0}' : '\xA0';
Not exactly, the question was asked what URL you were on - because that's relevant for why that piece of code doesn't get the values it needs, specifically why $user_info['smiley_set'] isn't set up properly.
There were two urls:
mydomain.com/index.php?scheduled=task;ts=1682228880
and
/public_html/Sources/Subs.php
Quote from: Greyhound on April 23, 2023, 09:56:43 AMThere were two urls:
mydomain.com/index.php?scheduled=task;ts=1682228880
and
/public_html/Sources/Subs.php
What version of Smf are you using? This seems to be related to a bug that has been fixed.
https://github.com/SimpleMachines/SMF/issues/5868
He said in the OP he was on 2.1.3. In any case that bug relates to the cron, not the scheduled tasks.
If you check the scheduled tasks log, what task ran at the same time as the error?
Nothing in the tasks log shows it ran at the same time as the error. In the code of the error seems like it may have been a birthday notify?
I'm not sure how you arrived at that from the information given.
The error as listed is a generic failure to do some bbc parsing, triggered from a scheduled task.
Now, birthday notify *is* a task but it triggers a different task which *isn't* handled by the scheduled tasks system. Which is specifically the URL you pointed out... so either you have more information than you've shared or it's not that...
I was looking at the wrong error. There were two.
Looks like the main error was
'smiley_set' => $user_info['smiley_set'],
We already know this is the line that's at fault - that's evident from what you did outline, that some point a scheduled task calls for bbc parsing, and fails because the current user's smiley set isn't known (because the scheduled task doesn't have a current user)
My questions are about trying to find which bbcode that is and making sure the correct setup is done for it...
There were no posts or tasks at the same time as this so error so I can't provide examples. I had two errors both at 2:39am this morning (Eastern Time). I can't tie the error to anything as was asked previously.
I also got this error at the same time: https://www.simplemachines.org/community/index.php?topic=585695.0
That error was listed as being SMF server related so maybe they both are.
No, they're really not. The one about the Fetch SM Files is not related to the smileys error you reported.
-sigh- I'm sorry, I can't help you.
Instead of posting bits and pieces, please post what I asked for.
Please post THE ENTIRE error message. Don't post just one line, don't post code. Post the entire message as displayed in your error log
Same here.
First error:
https://myforum.de/forum_ger/index.php?PHPSESSID=f36462fe41b4dd9dcb1d6bf76c12eafa&?scheduled=task;ts=1682277540
/...forum_folder.../Sources/Subs.php (Zeile 3897)
The database value you're trying to insert does not exist: smiley_set
Function: parsesmileys
Second one:
https://myforum.de/forum_ger/index.php?PHPSESSID=f36462fe41b4dd9dcb1d6bf76c12eafa&?scheduled=task;ts=1682277540
/...forum_folder.../Sources/ScheduledTasks.php (Zeile 1109)
Database error: Data too long for column 'data' at row 1
This is basically same thing I reported before:
Scheduled Task Error (https://www.simplemachines.org/community/index.php?topic=585695.0)
Looks like some kind of hacking attempt.
Two days at the same time.
No, it's not a hack. ::) You didn't include timestamps with error messages, but work was being done on server stack over past couple of days that may have caused some db errors. Are you still logging errors?
Quote from: Kindred on April 23, 2023, 08:55:43 AMThat's due to some server bumps here. We're fixing some stuff in the stack
First:
22 April 2023, 21:30:42
22 April 2023, 21:30:42
Second:
23 April 2023, 21:26:37
23 April 2023, 21:26:37
@Cypheros - are you saying you have the exact same problem as the OP reported? If not, please start a new topic with as much information as possible.
Quote from: Kindred on April 23, 2023, 04:53:14 PMInstead of posting bits and pieces, please post what I asked for.
Please post THE ENTIRE error message. Don't post just one line, don't post code. Post the entire message as displayed in your error log
I thought I posted the entire error previously.
I had two errors today both at 2:39am.
#1
Type of error: CriticalError messageSelectThe database value you're trying to insert does not exist: smiley_set
Function: parsesmileys #2
Type of error: DatabaseError messageSelectDatabase Error: Data too long for column 'data' at row 1 It does seem to be the same error as the other poster in this thread.
Yes, exact the same problem. Versions are not shown correctly and strange log entries.
smf_2.jpg
smf_1.JPG
I'm seeing the same error reported by
@Greyhound :
Guest
https://www.mysite.org/forum/index.php?scheduled=task;ts=1682310900
/var/www/mysite/web/forum/Sources/Subs.php (Line 3909) Backtrace information
Type of error: Critical
Error message: [Select]
The database value you're trying to insert does not exist: smiley_set
Function: parsesmileysGuest
https://www.mysite.org/forum/index.php?scheduled=task;ts=1682310900
/var/www/mysite/web/forum/Sources/ScheduledTasks.php (Line 1109) Backtrace information
Type of error: Database
Error message: [Select]
Database Error: Data too long for column 'data' at row 1It appeared yesterday for the first time, and again this morning. There are no scheduled tasks in my task log that have the same timestamps. My forum is also running 2.1.3.
Quote from: Kindred on April 23, 2023, 08:55:43 AMThat's due to some server bumps here. We're fixing some stuff in the stack
Hello everyone,
same here.
Today I got this:
Critical
The database value you're trying to insert does not exist: smiley_set
Function: parsesmileys ##domaincom/index.php?PHPSESSID=6713657d5428fbb624cd92b65fc459c7&?scheduled=task;ts=1682326080
/home/user/public_html/Sources/Subs.php (Γραμμή 3897)
11:51:42
Yesterday around the same time (11:54:18)
Critical
The database value you're trying to insert does not exist: smiley_set
Function: parsesmileys ##domaincom/index.php?scheduled=task;ts=1682239680
/home/user/public_html/Sources/Subs.php (Γραμμή 3897)
No further information, nothing scheduled no activity on or around the same time.
Maybe the backtrace information can shed some light on this?
Me too
Release information:
Forum version: SMF 2.1.3
Current SMF version: [object HTMLElement]
I just saw that I get in Error log file, 3 Unspecified errors from visitors, if it matters.
public_html/Sources/LightPortal/Integration.php (Line 231) Flashback information
Error Type: Undefined
Error message[Selection]
2: Undefined array key "allow_light_portal_manage_pages_any"
public_html/Sources/LightPortal/Integration.php (Line 252) Flashback information
Error Type: Undefined
Error message[Selection]
2: Undefined array key "lp_portal"
public_html/Sources/LightPortal/Integration.php (Line 262) Flashback information
Error Type: Undefined
Error message[Selection]
2: Undefined array key "lp_forum"
Quote from: Panoulis64 on April 24, 2023, 11:51:27 AMI just saw that I get in Error log file, 3 Unspecified errors from visitors, if it matters.
The errors that you posted seem to have been caused by third party mods.
We are seeing these errors for the first time as well. Same time/date stamp:
Today at 02:14:36 AM
Guest
https://huntron.com/forum/index.php?PHPSESSID=206641e0e9f2f168723fe624bbc44796&?scheduled=task;ts=1682325840
/homepages/28/d913845233/htdocs/huntron/forum/Sources/Subs.php (Line 3897) Backtrace information
Type of error: Critical
Error messageSelect
The database value you're trying to insert does not exist: smiley_set
Function: parsesmileys
---
Today at 02:14:36 AM
Guest
https://huntron.com/forum/index.php?PHPSESSID=206641e0e9f2f168723fe624bbc44796&?scheduled=task;ts=1682325840
/homepages/28/d913845233/htdocs/huntron/forum/Sources/ScheduledTasks.php (Line 1109) Backtrace information
Type of error: Database
Error messageSelect
Database Error: Data too long for column 'data' at row 1
Looks like a problem with the scheduled task "Fetch Simple Machine files".
Could that be?
I disabled the task and maybe that fixes the problem. Tomorrow I will see.
Quote from: DeadMan... on April 24, 2023, 08:02:51 AMQuote from: Kindred on April 23, 2023, 08:55:43 AMThat's due to some server bumps here. We're fixing some stuff in the stack
Seriously... do you people not read the thread?
I believe this has been addressed.
If the problem still exists with the active task "Fetch Simple Machines files", you might have to wait until the next run, or do like I did and do a run now for it.
After doing a run now, it seems to be fixed.
Quote from: Kindred on April 25, 2023, 09:17:58 AMQuote from: DeadMan... on April 24, 2023, 08:02:51 AMQuote from: Kindred on April 23, 2023, 08:55:43 AMThat's due to some server bumps here. We're fixing some stuff in the stack
Seriously... do you people not read the thread?
How long have you been on the internet? Of course not.
Lol, yes, it was somewhat of a rhetorical question
Strange. After disable "Fetch Simple Machine files" the error "Data too long for column 'data' at row 1" is gone.
"The database value you're trying to insert does not exist: smiley_set
Function: parsesmileys" problem still persists.
Quote from: Cypheros on April 25, 2023, 05:15:48 PMStrange. After disable "Fetch Simple Machine files" the error "Data too long for column 'data' at row 1" is gone.
"The database value you're trying to insert does not exist: smiley_set
Function: parsesmileys" problem still persists.
As stated above:
The issue is fixed, but you'll have to wait for the next time the scheduled tasks run, in order to have it stop the error.