Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: Panoulis64 on July 19, 2021, 08:39:07 AM

Title: Database error: .../Sources / Subs-Post.php
Post by: Panoulis64 on July 19, 2021, 08:39:07 AM
When I post a topic, I get a message

Database error
/home/triglian/public_html/Sources/Subs-Post.php
Line: 1839
Recently, before receiving these, I made changes, after questions here.

1. Question for birthday text
https://www.simplemachines.org/community/index.php?topic=578114.0

2. Subject title, larger
https://www.simplemachines.org/community/index.php?topic=578180.0

In the second issue, I reset the values I changed, but I continue to receive the same message.
I also reset the settings to the second question of the first question.
Without solving the problem.
What he advises me
Title: Re: Database error: .../Sources / Subs-Post.php
Post by: vbgamer45 on July 19, 2021, 09:12:43 AM
Can you attach that file might assist in troubleshooting
Title: Re: Database error: .../Sources / Subs-Post.php
Post by: Panoulis64 on July 19, 2021, 09:30:03 AM
This is exactly what I see, like the picture.

The Subs-Post.php
writes this on the line 1839
array('id_msg')
Title: Re: Database error: .../Sources / Subs-Post.php
Post by: Shambles on July 19, 2021, 10:49:14 AM
Check out the Quick Translation support topic  (https://www.simplemachines.org/community/index.php?topic=405224.0), or

https://www.simplemachines.org/community/index.php?topic=563372.msg3996410#msg3996410
Title: Re: Database error: .../Sources / Subs-Post.php
Post by: Panoulis64 on July 19, 2021, 11:02:23 AM
The packages I have are those of the attached image. There is no translation package.
also a month ago we did a big upgrade
Title: Re: Database error: .../Sources / Subs-Post.php
Post by: Shambles on July 19, 2021, 11:17:11 AM
Maybe you had a QT package previously?  In any case, just try what was suggested:

QuoteSolution 1: Edit the table messages , field qt_lang and add as default value "en"
Title: Re: Database error: .../Sources / Subs-Post.php
Post by: Panoulis64 on July 19, 2021, 12:06:47 PM
Thanks for your answer.
However, the server administrator should see this and make the changes.

Really very old, I had a QT package.
Title: Re: Database error: .../Sources / Subs-Post.php
Post by: Panoulis64 on July 20, 2021, 12:24:42 PM
Good evening, we did what you mentioned and now there is no problem.
I would like to ask, if you know.
In PHP my admin, I saw that there are many tables from old packages.
If they are removed and if I have kept backups. I will have a problem;
I say this because my problem here was with an old package that I had uninstalled, if I understood correctly.
Title: Re: Database error: .../Sources / Subs-Post.php
Post by: Shambles on July 20, 2021, 01:42:20 PM
Quote from: Panoulis64 on July 20, 2021, 12:24:42 PM
In PHP my admin, I saw that there are many tables from old packages.
If they are removed and if I have kept backups. I will have a problem;

Leave them alone, unless they cause you issues in the future, would be my advice.

Quote
I say this because my problem here was with an old package that I had uninstalled, if I understood correctly.

Yes, that was the cause. The uninstaller may have left the table there and a more strict version of your database query software may now be insisting on fields within it having default values.