News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Error in your SQL syntax

Started by misus, November 23, 2014, 04:23:57 PM

Previous topic - Next topic

misus

Hello,

I'm having a rather inconvenient issue with my SMF forum  :-\
Whenever i try to edit an older msg. or try to preview the edits i made to a message i get this error :

Database Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM smf_attachments
WHERE id_msg = 49470
AND attachment_type = 0' at line 2
File: /home4/trollngo/public_html/Sources/Post.php
Line: 700

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.9, while your database is at version 2.0.6. The above error might possibly go away if you execute the latest version of upgrade.php.


Could anyone help me please?  :(

Kindred

When do you get that error?

What is your smf version?

Mods installed?
Сл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."

misus

Quote from: Kindred on November 23, 2014, 04:29:53 PM
When do you get that error?

What is your smf version?

Mods installed?
I get that error when i try to edit one of my older posts, when i try to make the preview of the edited msg. before posting

2.0.9

I don't know when the problem started cause i don't use to edit old msg., so it's hard to say what mod could cause the problem. Maybe Mentions   1.1.1 , Say Thanks   1.0.2 , Split and Move   0.1.2 , Inline Hover Spoiler   1.5  or  Good Post/Bad Post Mod   2.0.4 !?


Kindred

I didn't ask what mods you think might be responsible...  I asked what mods you had installed....

So, the error occurs when you edit one specific old post? Or all old posts?
Сл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."

misus

Quote from: Kindred on November 23, 2014, 04:43:29 PM
I didn't ask what mods you think might be responsible...  I asked what mods you had installed....

So, the error occurs when you edit one specific old post? Or all old posts?
When i edit any old post. I get the same error when i try to preview my edit or when i try to save the edit i made.

Should i post the entire list of my mods? I have quite a  lot !  :-\

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

Arantor

Or even the Post.php file that is broken...

misus

Modification Packages
Mod Name   Version   
1.   Related Topics   1.401     [ Uninstall ] [ List Files ] [ Delete ]
2.   Vbulletin New Meta Tags   1.0     [ Uninstall ] [ List Files ] [ Delete ]
3.   Add Avatar To Who Is Online Version 1.1   1.0     [ Uninstall ] [ List Files ] [ Delete ]
4.   SMF 2.0.7 Update   1.0     [ List Files ] [ Delete ]
5.   Member Color Link   3.1     [ List Files ] [ Delete ]
6.   Topic Author   0.1     [ Uninstall ] [ List Files ] [ Delete ]
7.   URL Popup   1.0.2     [ Uninstall ] [ List Files ] [ Delete ]
8.   SMF 1.1.20 / 2.0.9 Update   1.0     [ Uninstall ] [ List Files ] [ Delete ]
9.   SMF 2.0.8 Update   1.0     [ List Files ] [ Delete ]
10.   Smart Pagination   0.8.2     [ Uninstall ] [ List Files ] [ Delete ]
11.   Quick Reply Reposition Mod   1.0     [ Uninstall ] [ List Files ] [ Delete ]
12.   Simple Menu Icons   1.0     [ Uninstall ] [ List Files ] [ Delete ]
13.   Send Locked Topics To Bottom   1.0     [ Uninstall ] [ List Files ] [ Delete ]
14.   Add Social Media Icons To Profiles   1.0.8     [ Uninstall ] [ List Files ] [ Delete ]
15.   NiceTooltips   1.9     [ Uninstall ] [ List Files ] [ Delete ]
16.   Remove Navigation   1.0     [ List Files ] [ Delete ]
17.   ResizeImagesToFitScreen   0.1.5     [ Uninstall ] [ List Files ] [ Delete ]
18.   Best Answer Intergration   1.4     [ Uninstall ] [ List Files ] [ Delete ]
19.   View Only Boards   1.2c     [ Uninstall ] [ List Files ] [ Delete ]
20.   TopicStarter Mod   1.7     [ Uninstall ] [ List Files ] [ Delete ]
21.   Smf seo boards title[   1     [ Uninstall ] [ List Files ] [ Delete ]
22.   SMF Multi Quote   1.1.3     [ List Files ] [ Delete ]
23.   RepliesViewsNewLayout   1.0     [ Uninstall ] [ List Files ] [ Delete ]
24.   SMF Arcade   2.5 RC1     [ List Files ] [ Delete ]
25.   Active Members In Topic   1.8     [ List Files ] [ Delete ]
26.   Recent Forum Topics Boardindex   1.0     [ Uninstall ] [ List Files ] [ Delete ]
27.   ShowBannedMessage   1.3     [ Uninstall ] [ List Files ] [ Delete ]
28.   previous_next_new   1.0     [ Uninstall ] [ List Files ] [ Delete ]
29.   PartyMembers   1.1     [ Uninstall ] [ List Files ] [ Delete ]
30.   Reply Button In Every Post   1.0     [ Uninstall ] [ List Files ] [ Delete ]
31.   Add Facebook Like, Tweet, and Google +1   1.0.3a     [ Uninstall ] [ List Files ] [ Delete ]
32.   Forum Name in Browser Title   2.0.1     [ Uninstall ] [ List Files ] [ Delete ]
33.   PM Informer   4.0.1     [ Uninstall ] [ List Files ] [ Delete ]
34.   Default Avatar   2.3     [ Uninstall ] [ List Files ] [ Delete ]
35.   The BoardJump modification   1.1     [ Uninstall ] [ List Files ] [ Delete ]
36.   Move Right BBCode   1.5     [ Uninstall ] [ List Files ] [ Delete ]
37.   Simple Off-Topic BBC   1.0     [ Uninstall ] [ List Files ] [ Delete ]
38.   ENotify   2.0.2     [ Uninstall ] [ List Files ] [ Delete ]
39.   Users Online Today   2.0.3     [ Uninstall ] [ List Files ] [ Delete ]
40.   NoFollow All Links   1.2.1     [ Uninstall ] [ List Files ] [ Delete ]
41.   Inline Hover Spoiler   1.5     [ Uninstall ] [ List Files ] [ Delete ]
42.   Expire Attachments mod   1.0     [ Uninstall ] [ List Files ] [ Delete ]
43.   Highlight tags   1.1     [ Uninstall ] [ List Files ] [ Delete ]
44.   Optimus Brave   1.8.7     [ Uninstall ] [ List Files ] [ Delete ]
45.   Split and Move   0.1.2     [ Uninstall ] [ List Files ] [ Delete ]
46.   Karma Description Mod   2.7.1   [ List Files ] [ Delete ]
47.   SimplePortal   2.3.5     [ Uninstall ] [ List Files ] [ Delete ]
48.   Avatar on Member List   2.0     [ Uninstall ] [ List Files ] [ Delete ]
49.   httpBL   2.5.1     [ Uninstall ] [ List Files ] [ Delete ]
50.   Aeva ~ Auto-Embed Video & Audio   7.2     [ Uninstall ] [ List Files ] [ Delete ]
51.   Avatar Rounded Corners   1.0     [ Uninstall ] [ List Files ] [ Delete ]
52.   Say Thanks   1.0.2     [ Uninstall ] [ List Files ] [ Delete ]
53.   Time Online on Memberlist   1.00     [ Uninstall ] [ List Files ] [ Delete ]
54.   Ultimate Profile   0.9.1     [ Uninstall ] [ List Files ] [ Delete ]
55.   Remove Index From Title   1.0     [ Uninstall ] [ List Files ] [ Delete ]
56.   Mentions   1.1.1     [ Uninstall ] [ List Files ] [ Delete ]
57.   Skin/PDL for Arcade RC2   1.0.2     [ Uninstall ] [ List Files ] [ Delete ]
58.   Stop Spammer   2.3.9     [ Uninstall ] [ List Files ] [ Delete ]
59.   Drafts   1.1.5     [ List Files ] [ Delete ]
60.   Good Post/Bad Post Mod   2.0.4     [ List Files ] [ Delete ]

misus

and i'll attach here Post.php
Thank you for looking into it.  :-\

Kindred

I am betting it is related to expire attachments.
Сл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."

misus

Quote from: Kindred on November 23, 2014, 05:03:11 PM
I am betting it is related to expire attachments.
5$ ?  :P


I'm trying to uninstall the mod.

misus

OMG!!! No more errors.
I uninstalled the mod and it works perfect again.


Thank you so much, Kindred  :) Thanks!!

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

Advertisement: