Error messages when editing posts

[confuseamuse]

Recently, whenever I try to edit a post on my forum, I keep getting this error to show up:

Code Select Expand


Database Error: Column 'id_member' in field list is ambiguousApply Filter: Only show the errors from this file File: /var/www/vhosts/path/Sources/Post.php
Line: 695


And line 695 reads:

Code Select Expand


675: // Previewing an edit?
676: if (isset($_REQUEST['msg']) && !empty($topic))
677: {
678: // Get the existing message.
679: $request = $smcFunc['db_query']('', '
680: SELECT
681: id_member, m.anonymous, m.modified_time, m.smileys_enabled, m.body, t.id_prefix,
682: m.poster_name, m.poster_email, m.subject, m.icon, m.approved,t.add_authors,
683: IFNULL(a.size, -1) AS filesize, a.filename, a.id_attach,
684: a.approved AS attachment_approved, t.id_member_started AS id_member_poster,
685: m.poster_time
686: FROM {db_prefix}messages AS m
687: INNER JOIN {db_prefix}topics AS t ON (t.id_topic = {int:current_topic})
688: LEFT JOIN {db_prefix}attachments AS a ON (a.id_msg = m.id_msg AND a.attachment_type = {int:attachment_type})
689: WHERE m.id_msg = {int:id_msg}
690: AND m.id_topic = {int:current_topic}
691: ORDER BY a.id_attach',
692: array(
693: 'current_topic' => $topic,
694: 'attachment_type' => 0,
==>695: 'id_msg' => $_REQUEST['msg'],
696: )
697: );


[Kindred]

Smf version? Mods installed?

[confuseamuse]

SMF 2.0.14

Code Select Expand


1. Auto Twitter Embed 1.0.1 [ Install Mod ] [ List Files ] [ Delete ]
2. @mention members 1.1.2  [ Uninstall ] [ List Files ] [ Delete ]
3. Label for banned members 1.0  [ Uninstall ] [ List Files ] [ Delete ]
4. Embed Tweet BBCode 1.1.1  [ Uninstall ] [ List Files ] [ Delete ]
5. Emoji One 0.3.2 [ Install Mod ] [ List Files ] [ Delete ]
6. Super Simple Thread Tags 1.2  [ Uninstall ] [ List Files ] [ Delete ]
7. Unread PMs Favicon 1.0 [ Install Mod ] [ List Files ] [ Delete ]
8. Code Highlighting 1.2  [ Uninstall ] [ List Files ] [ Delete ]
9. Prevent Topic View Increase by Author 1.2  [ Uninstall ] [ List Files ] [ Delete ]
10. Post Anonymously In Topic 2.7 [ Install Mod ] [ List Files ] [ Delete ]
11. Post Notifier 1.0.1  [ Uninstall ] [ List Files ] [ Delete ]
12. Post History 1.03  [ Uninstall ] [ List Files ] [ Delete ]
13. SMF Post Prefix 2.0.3  [ Uninstall ] [ List Files ] [ Delete ]
14. Inline Hover Spoiler 1.5  [ Uninstall ] [ List Files ] [ Delete ]
15. Sisyphus 1.2 [ Install Mod ] [ List Files ] [ Delete ]
16. Multiple Smiley Aliases 1.1  [ Uninstall ] [ List Files ] [ Delete ]
17. Spiders Don't Increase Topic Views 1.1.1  [ Uninstall ] [ List Files ] [ Delete ]
18. Edit All Message Titles 0.1.1  [ Uninstall ] [ List Files ] [ Delete ]
19. New Board Stat Style 1.2 [ Install Mod ] [ List Files ] [ Delete ]
20. Emoji Parser 1.1.0 [ Install Mod ] [ List Files ] [ Delete ]
21. Visible, Invisible and NoQuote Tags 2.0  [ Uninstall ] [ List Files ] [ Delete ]
22. BBC In Custom Title 2.0r2 - SMF 2.0.x  [ Uninstall ] [ List Files ] [ Delete ]
23. List Of Users In Forum/Board/Topic 2.2 [ Install Mod ] [ List Files ] [ Delete ]
24. My Posts SMF2 1.3  [ Uninstall ] [ List Files ] [ Delete ]
25. Split Forum Mod 1.39  [ Uninstall ] [ List Files ] [ Delete ]
26. NiceTooltips 1.17 [ Install Mod ] [ List Files ] [ Delete ]
27. UnreadMessagesForTitle 1.0  [ Uninstall ] [ List Files ] [ Delete ]
28. dQuoteSelection 2.6.3  [ Uninstall ] [ List Files ] [ Delete ]
29. Inuitive Age 1.0  [ List Files ] [ Delete ]
30. Country Flags 3.0  [ Uninstall ] [ List Files ] [ Delete ]
31. Bad Behavior mod 1.5.19  [ Uninstall ] [ List Files ] [ Delete ]
32. Embed Streamable Videos BBCode 1.0  [ Uninstall ] [ List Files ] [ Delete ]
33. Log Karma Actions 3.0  [ Uninstall ] [ List Files ] [ Delete ]
34. Pretty URLs 1.1.3  [ Uninstall ] [ List Files ] [ Delete ]
35. SimplePortal 2.3.6 [ Install Mod ] [ List Files ] [ Delete ]
36. Reason For Editing Mod 2.3.3  [ Uninstall ] [ List Files ] [ Delete ]
37. Users Online Today 2.1 [ Install Mod ] [ List Files ] [ Delete ]
38. Post and PM Inline Attachments 5.10  [ Uninstall ] [ List Files ] [ Delete ]
39. Additional Topic Authors 0.1.1  [ Uninstall ] [ List Files ] [ Delete ]
40. Clone Topic 0.4.5  [ Uninstall ] [ List Files ] [ Delete ]
41. Ohara YouTube Embed 1.2.9  [ Uninstall ] [ List Files ] [ Delete ]
42. Embed Instagram BBCode 1.21  [ Uninstall ] [ List Files ] [ Delete ]
43. PageDropdown 1.4 [ List Files ] [ Delete ]
44. View Single Category 2.5 [ Install Mod ] [ List Files ] [ Delete ]
45. Post Karma 0.2 [ Install Mod ] [ List Files ] [ Delete ]
46. Simple Image Upload 2.0.0  [ Uninstall ] [ List Files ] [ Delete ]
47. IPv6 Support 1.0.1  [ Uninstall ] [ List Files ] [ Delete ]
48. Original Poster in Topic View 0.1.1  [ Uninstall ] [ List Files ] [ Delete ]
49. SMFPacks Alerts Pro 2.0.17  [ Uninstall ] [ List Files ] [ Delete ]
50. Optimus 1.9.4  [ Uninstall ] [ List Files ] [ Delete ]
51. Default Avatar by Username 1.1.0  [ Uninstall ] [ List Files ] [ Delete ]
52. Redirector 1.2 [ Install Mod ] [ List Files ] [ Delete ]
53. Characters remaining of post 1.0.4  [ Uninstall ] [ List Files ] [ Delete ]
54. Event Registration Mod for SMF2 2.26  [ Uninstall ] [ List Files ] [ Delete ]
55. AJAX Board Reordering 2.0  [ Uninstall ] [ List Files ] [ Delete ]
56. TinyPortal 1.3  [ Uninstall ] [ List Files ] [ Delete ]
57. Updated Registration Agreement 1.0 [ Install Mod ] [ List Files ] [ Delete ]
58. Forum Hit Hard Preventer 1.3  [ Uninstall ] [ List Files ] [ Delete ]
59. LUP: Logout Under Profile 1.0.0  [ Uninstall ] [ List Files ] [ Delete ]
60. Simple Theme Changer 1.0.2  [ Uninstall ] [ List Files ] [ Delete ]
61. Board Icons 1.0  [ Uninstall ] [ List Files ] [ Delete ]
62. Thumbnail Topic Mod 3.0.1  [ Uninstall ] [ List Files ] [ Delete ]
63. Soundcloud BBcode 1.7  [ Uninstall ] [ List Files ] [ Delete ]
64. PM Attachments 2.5.1 [ Install Mod ] [ List Files ] [ Delete ]
65. SimpleColorizer 1.1  [ Uninstall ] [ List Files ] [ Delete ]
66. Similar Topics 0.7  [ Uninstall ] [ List Files ] [ Delete ]



[Kindred]

 I suspect the post anonymously mod is interfering with poster ids

[confuseamuse]

I suspect the post anonymously mod is interfering with poster ids

It isn't currently installed though.

[aegersz]

has it ever been installed ?

i have had mods that cleanly uninstalled but they till left behind code or code fragments.

[Kindred]

Oh, I see the problem. Some mod incorrectly edited the code.  And m. Before id_member

[confuseamuse]

Oh, I see the problem. Some mod incorrectly edited the code.  And m. Before id_member

Yup, this worked. Thanks.

[Kindred]

...  and it looks like, as is suspected, it might have been the anonymous mod, since the anonymous code is still present in your code excerpt.