Recently, whenever I try to edit a post on my forum, I keep getting this error to show up:
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:
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: );
Smf version? Mods installed?
SMF 2.0.14
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 ]
I suspect the post anonymously mod is interfering with poster ids
Quote from: Kindred on October 16, 2017, 05:38:01 PM
I suspect the post anonymously mod is interfering with poster ids
It isn't currently installed though.
has it ever been installed ?
i have had mods that cleanly uninstalled but they till left behind code or code fragments.
Oh, I see the problem. Some mod incorrectly edited the code. And m. Before id_member
Quote from: Kindred on October 16, 2017, 08:55:20 PM
Oh, I see the problem. Some mod incorrectly edited the code. And m. Before id_member
Yup, this worked. Thanks.
... 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. :P