DB Error and SMF Not Recognizing Current Version

Started by Greyhound, April 23, 2023, 08:43:23 AM

Previous topic - Next topic

Cypheros

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

Steve

@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.
My pet rock is not feeling well. I think it's stoned.

Kindred

Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Greyhound

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: Critical
Error messageSelect
The database value you're trying to insert does not exist: smiley_set
Function: parsesmileys


#2
Type of error: Database
Error messageSelect
Database 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. 

Cypheros

Yes, exact the same problem. Versions are not shown correctly and strange log entries.

You cannot view this attachment.

You cannot view this attachment.

sah62

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: parsesmileys

Guest
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 1

It 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.

DeadMan...

I tell it how I see it... Don't like it? Hit Alt+F4!

gpatechss

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?


Panoulis64

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"

Doug Heffernan

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.

CurtisS

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

Cypheros

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.

Kindred

Quote from: DeadMan... on April 24, 2023, 08:02:51 AM
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


Seriously... do you people not read the thread?
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

shawnb61

A question worth asking is born in experience & driven by necessity. - Fripp

DeadMan...

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.
I tell it how I see it... Don't like it? Hit Alt+F4!

Arantor

Quote from: Kindred on April 25, 2023, 09:17:58 AM
Quote from: DeadMan... on April 24, 2023, 08:02:51 AM
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


Seriously... do you people not read the thread?

How long have you been on the internet? Of course not.
Holder of controversial views, all of which my own.


Kindred

Lol, yes, it was somewhat of a rhetorical question
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Cypheros

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.


DeadMan...

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.
I tell it how I see it... Don't like it? Hit Alt+F4!

Advertisement: