Create an account
Login
You are here: Forum Index » Sharing & Voicing  » Tech & General SupportGetting an Error After Posting
Forum Menu - Click/Swipe to open
 

Getting an Error After Posting

You have contributed 0.0% of this topic

Thread Tools
Post New Topic Filter by poster
Appreciate
Topic Appreciation
abu mohammed
View Profile Block User
Rank Image
Rajab's avatar
Offline
Unspecified
2,249
Brother
1,041
Rajab's avatar
#1 [Permalink] Posted on 26th April 2025 06:06
I’m getting an error after posting on the forum. The full message says:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE forum_id = 27' at line 1
UPDATE msf_forums SET forum_last_post_id = WHERE forum_id = 27

After googling a bit, it looks like the system is trying to update the forum’s last post but isn’t passing a value for forum_last_post_id, which causes the SQL error.

From what I understand, it might need to either pass the correct post ID or set it to NULL if there’s no value.
report post quote code quick quote reply
+1 -0Informative x 1
back to top
Rajab
View Profile Block User
Rank Image
abu mohammed's avatar
London
26,967
Brother
9,683
abu mohammed's avatar
#2 [Permalink] Posted on 26th April 2025 11:56
For my information, are you getting these errors when quoting someone?

I've noticed that many posts don't appear as a new post, and most of the times, they have had one thing in common. They were post with a quote within it.

But that was just my observation. Then I saw a post that didn't appear in the recent posts and didn't have a quote.
report post quote code quick quote reply
No post ratings
back to top
Actions are judged by intentions, so each man will have what he intended.
ابو محمد
View Profile Block User
Rank Image
akbar703's avatar
Offline
India
1,808
Brother
166
akbar703's avatar
#3 [Permalink] Posted on 27th April 2025 12:20
I didn't quote here.
report post quote code quick quote reply
+1 -0Informative x 1
back to top
....
View Profile Block User
Rank Image
Abdur Rahman ibn Awf's avatar
Offline
Unspecified
3,836
Brother
3,920
Abdur Rahman ibn Awf's avatar
#4 [Permalink] Posted on 27th April 2025 13:48
Nope in every post with or without quote.
report post quote code quick quote reply
+1 -0Informative x 1
back to top
Abdur Rahman ibn Awf
View Profile Block User
Rank Image
abu mohammed's avatar
London
26,967
Brother
9,683
abu mohammed's avatar
#5 [Permalink] Posted on 30th April 2025 12:32
Please try now and update with error if any, Jzk.
report post quote code quick quote reply
No post ratings
back to top
Actions are judged by intentions, so each man will have what he intended.
ابو محمد
View Profile Block User
Rank Image
akbar703's avatar
Offline
India
1,808
Brother
166
akbar703's avatar
#6 [Permalink] Posted on 30th April 2025 16:51
ping to test

error persists.............
report post quote code quick quote reply
+0 -0Agree x 1
back to top
....
View Profile Block User
Yasin's avatar
UK
6,681
Brother
933
Yasin's avatar
#7 [Permalink] Posted on 1st May 2025 21:58
Testing
report post quote code quick quote reply
No post ratings
back to top
I am not a Mufti
View Profile Block User
Yasin's avatar
UK
6,681
Brother
933
Yasin's avatar
#8 [Permalink] Posted on 1st May 2025 21:59
Hmm, worked for me. Is it the same error?
report post quote code quick quote reply
No post ratings
back to top
I am not a Mufti
View Profile Block User
Rank Image
Abdur Rahman ibn Awf's avatar
Offline
Unspecified
3,836
Brother
3,920
Abdur Rahman ibn Awf's avatar
#9 [Permalink] Posted on 1st May 2025 22:40
Let see
report post quote code quick quote reply
No post ratings
back to top
Abdur Rahman ibn Awf
View Profile Block User
Rank Image
Abdur Rahman ibn Awf's avatar
Offline
Unspecified
3,836
Brother
3,920
Abdur Rahman ibn Awf's avatar
#10 [Permalink] Posted on 1st May 2025 22:41
Yasin wrote:
View original post


You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE forum_id = 90' at line 1
UPDATE msf_forums SET forum_last_post_id = WHERE forum_id = 90

Same error for me.
report post quote code quick quote reply
No post ratings
back to top
Abdur Rahman ibn Awf
View Profile Block User
Rank Image
Asaaghir's avatar
Spinistan Throne
1,108
Brother
737
Asaaghir's avatar
#11 [Permalink] Posted on 2nd May 2025 10:30
I just posted without an error - this is another post (If not edited, then this also without an error)
report post quote code quick quote reply
No post ratings
back to top
Asaaghir
View Profile Block User
Rank Image
Abdur Rahman ibn Awf's avatar
Offline
Unspecified
3,836
Brother
3,920
Abdur Rahman ibn Awf's avatar
#12 [Permalink] Posted on 2nd May 2025 14:47
Still in Error.
report post quote code quick quote reply
No post ratings
back to top
Abdur Rahman ibn Awf
View Profile Block User
Rank Image
abu mohammed's avatar
London
26,967
Brother
9,683
abu mohammed's avatar
#13 [Permalink] Posted on 2nd May 2025 15:10
It seems 3 members are having the same issue. Is there something in common within their profile/permissions etc

They are members:
Rajab
Abdur Rahman ibn Awf
akbar703
report post quote code quick quote reply
+0 -0Agree x 1
back to top
Actions are judged by intentions, so each man will have what he intended.
ابو محمد
View Profile Block User
Rank Image
akbar703's avatar
Offline
India
1,808
Brother
166
akbar703's avatar
#14 [Permalink] Posted on 2nd May 2025 15:31
true!!!
report post quote code quick quote reply
No post ratings
back to top
....
View Profile Block User
Rank Image
bint e aisha's avatar
Offline
Unspecified
2,621
Sister
1,757
bint e aisha's avatar
#15 [Permalink] Posted on 10th May 2025 13:27
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE forum_id = 27' at line 1
UPDATE msf_forums SET forum_last_post_id = WHERE forum_id = 27

Started getting this error today.
report post quote code quick quote reply
No post ratings
back to top
الإسلامُ یَعْلُو وَلَا یُعْلیٰ
Back to top Post New Topic

 

You are here: Forum Index » Sharing & Voicing  » Tech & General SupportGetting an Error After Posting