Database Error: Unknown column 'mem.posts' in 'field list'

Aperto da Flavio93Zena, Martedì - 25 Novembre 2014 - 13:04

0 Utenti e 1 Visitatore stanno visualizzando questa discussione.

Flavio93Zena

Non riesco mica a capire quale sia il problema, quella colonna è presente e la query è presente anche nell'installazione di default, pur se diversa.

Beh il messaggio di errore è questo
Citazione
http://vige.altervista.org/forum/index.php?action=jsmodify;topic=116;ab0ad7e46=806ad07e478d835ce46a4656aa80d4e5;xml
Database Error: Unknown column 'mem.posts' in 'field list'
File: /Sources/Post.php
Line: 2852
e succede quando si prova a modificare un messaggio con la modifica rapida (cioè il tastino piccolo) invece della funzione "modifica" che carica una nuova pagina.

La lista delle mod segue (un'altra volta - e ora sono 124...), pur avendo cercato non ho idea se una di esse vada ad intralciare con quella funzione... Quando si prova a modificare il messaggio comunque tramite il pulsantino non si riesce mentre la modifica normale funziona...

1. Advanced Signature 0.3.0 beta 1 N/A [ Install Mod ] [ List Files ] [ Delete ]
2. Browser Language Detection and Loading 0.1.0 N/A [ Install Mod ] [ List Files ] [ Delete ]
3. Custom blocks 2.3.2 N/A [ Install Mod ] [ List Files ] [ Delete ]
4. detectBrowser Update 1.0.1 N/A [ Install Mod ] [ List Files ] [ Delete ]
5. Enhanced PM System 2.5 N/A [ Install Mod ] [ List Files ] [ Delete ]
6. Forum Firewall 2.0.0 N/A [ Install Mod ] [ List Files ] [ Delete ]
7. jQLightbox 0.6 N/A [ Install Mod ] [ List Files ] [ Delete ]
8. MCLegendII RC3 3.0 N/A [ Install Mod ] [ List Files ] [ Delete ]
9. nneonneo's AJAX ShoutBox 1.22 N/A [ Install Mod ] [ List Files ] [ Delete ]
10. Reason For Editing Mod 2.3.2 N/A [ Install Mod ] [ List Files ] [ Delete ]
11. ResizeImagesToFitScreen 0.1.6 N/A [ Install Mod ] [ List Files ] [ Delete ]
12. Slash through Banned Usernames 3.0 N/A [ Install Mod ] [ List Files ] [ Delete ]
13. SMF Likes Plus 1.5 N/A [ Install Mod ] [ List Files ] [ Delete ]
14. SPB: Smart PostBit 1.0.0 N/A [ Install Mod ] [ List Files ] [ Delete ]
15. User Agreement Update 1.0.3 N/A [ Install Mod ] [ List Files ] [ Delete ]
16. Delete Spam Posts 1.6  April 21, 2014, 06:33:04 PM [ Uninstall ] [ List Files ] [ Delete ]
17. ShowBannedMessage 1.3  April 21, 2014, 06:35:20 PM [ Uninstall ] [ List Files ] [ Delete ]
18. Move Topic Notification 1.2  April 21, 2014, 06:36:28 PM [ Uninstall ] [ List Files ] [ Delete ]
19. open mod reports 1.0  April 21, 2014, 06:43:56 PM [ Uninstall ] [ List Files ] [ Delete ]
20. Admin Notes 2.0  April 21, 2014, 06:45:28 PM [ Uninstall ] [ List Files ] [ Delete ]
21. Karma/Rep Limit 1.0.1  April 21, 2014, 06:48:26 PM [ Uninstall ] [ List Files ] [ Delete ]
22. Anti Bot: Are You Human/Bot? 3.0  April 21, 2014, 06:49:20 PM [ Uninstall ] [ List Files ] [ Delete ]
23. Quick Ban on Account Delete 1.0.1  April 22, 2014, 02:07:56 AM [ Uninstall ] [ List Files ] [ Delete ]
24. SMFPacks Shoutbox 1.0.5  April 22, 2014, 02:08:43 AM [ Uninstall ] [ List Files ] [ Delete ]
25. Order Custom Profile Fields 1.1.1  April 22, 2014, 02:26:56 AM [ Uninstall ] [ List Files ] [ Delete ]
26. Disable to send EMail with Forum-System for Users lower than Admin 1.0  April 22, 2014, 02:59:53 AM [ Uninstall ] [ List Files ] [ Delete ]
27. TalkBox3 2.0  April 22, 2014, 06:11:20 AM [ Uninstall ] [ List Files ] [ Delete ]
28. last login 2.9  April 23, 2014, 04:44:41 AM [ Uninstall ] [ List Files ] [ Delete ]
29. Next Post Level 1.3.3  April 24, 2014, 11:27:35 PM [ Uninstall ] [ List Files ] [ Delete ]
30. Post History 1.03  April 25, 2014, 02:31:33 AM [ Uninstall ] [ List Files ] [ Delete ]
31. Topic Solved 1.1.1  April 26, 2014, 06:35:12 AM [ Uninstall ] [ List Files ] [ Delete ]
32. Bad Behavior mod 1.5.18  April 26, 2014, 04:05:42 PM [ Uninstall ] [ List Files ] [ Delete ]
33. CloudFlare 1.1  April 26, 2014, 04:58:14 PM [ Uninstall ] [ List Files ] [ Delete ]
34. Users Online Today 2.1  April 26, 2014, 09:11:12 PM [ Uninstall ] [ List Files ] [ Delete ]
35. Ban List 2.0  April 27, 2014, 01:48:40 AM [ Uninstall ] [ List Files ] [ Delete ]
36. 'Read the Rules' Link Above Post Button 2.0  April 27, 2014, 02:28:50 AM [ Uninstall ] [ List Files ] [ Delete ]
37. Enhanced PM Popup 1.0.1  April 27, 2014, 02:54:16 AM [ Uninstall ] [ List Files ] [ Delete ]
38. Sortable Packages (and Installed Time) 1.3.5  April 30, 2014, 01:45:39 AM [ Uninstall ] [ List Files ] [ Delete ]
39. Anti-Spam Links 1.0.1  April 30, 2014, 02:36:24 PM [ Uninstall ] [ List Files ] [ Delete ]
40. Add Facebook Like to Posts 1.1  May 01, 2014, 12:40:38 AM [ Uninstall ] [ List Files ] [ Delete ]
41. PM to New Members 1.2  May 02, 2014, 06:25:55 PM [ Uninstall ] [ List Files ] [ Delete ]
42. Allow Access while in Maintenance Mode 1.2  May 03, 2014, 09:19:17 PM [ Uninstall ] [ List Files ] [ Delete ]
43. Activity in Profile 1.1  May 03, 2014, 09:27:56 PM [ Uninstall ] [ List Files ] [ Delete ]
44. Ad Managment 3.2  May 03, 2014, 09:54:28 PM [ Uninstall ] [ List Files ] [ Delete ]
45. Custom Copyright 1.0.4  May 04, 2014, 02:57:46 AM [ Uninstall ] [ List Files ] [ Delete ]
46. Fake Topic Views 0.1  May 06, 2014, 12:01:47 AM [ Uninstall ] [ List Files ] [ Delete ]
47. Ban Filter 1.0  May 06, 2014, 12:05:46 AM [ Uninstall ] [ List Files ] [ Delete ]
48. Bookmarks 2.5  May 17, 2014, 12:36:49 AM [ Uninstall ] [ List Files ] [ Delete ]
49. Global Topics 2.2  May 20, 2014, 12:30:45 AM [ Uninstall ] [ List Files ] [ Delete ]
50. Register Redirect 1.0  May 28, 2014, 10:20:43 AM [ Uninstall ] [ List Files ] [ Delete ]
51. Tinypic Plugin 1.0.0  May 31, 2014, 09:51:08 PM [ Uninstall ] [ List Files ] [ Delete ]
52. SimpleDesk - Integrated Helpdesk for Simple Machines Forum 2.0  May 31, 2014, 10:37:17 PM [ Uninstall ] [ List Files ] [ Delete ]
53. To Buddies 1.01  June 01, 2014, 11:06:29 PM [ Uninstall ] [ List Files ] [ Delete ]
54. Time Online on Memberlist 1.00  June 04, 2014, 06:30:40 AM [ Uninstall ] [ List Files ] [ Delete ]
55. Profile Song Player 1.0 Beta  June 06, 2014, 05:42:26 PM [ Uninstall ] [ List Files ] [ Delete ]
56. Permissions Info 1.6  June 06, 2014, 05:48:00 PM [ Uninstall ] [ List Files ] [ Delete ]
57. Ignore Topics 2.3  June 14, 2014, 12:33:12 AM [ Uninstall ] [ List Files ] [ Delete ]
58. Caps_Lock_Detection_on_Login 1.1.0.2  June 21, 2014, 09:45:33 AM [ Uninstall ] [ List Files ] [ Delete ]
59. SimpleColorizer 1.1  June 23, 2014, 08:46:32 PM [ Uninstall ] [ List Files ] [ Delete ]
60. Board Index Unread Icon Fix 1.0  June 27, 2014, 02:28:34 PM [ Uninstall ] [ List Files ] [ Delete ]
61. Country Flags 2.1  June 28, 2014, 05:27:51 PM [ Uninstall ] [ List Files ] [ Delete ]
62. PM Settings 1.0.1  June 29, 2014, 09:13:36 PM [ Uninstall ] [ List Files ] [ Delete ]
63. Undeletables topics PMs and users 0.1.5  June 30, 2014, 05:09:57 AM [ Uninstall ] [ List Files ] [ Delete ]
64. Working top level links for drop menus 1.0  July 04, 2014, 04:21:40 AM [ Uninstall ] [ List Files ] [ Delete ]
65. Email Inactive Users 1.1  July 15, 2014, 02:10:39 PM [ Uninstall ] [ List Files ] [ Delete ]
66. Similar Topics 0.6  July 15, 2014, 03:08:26 PM [ Uninstall ] [ List Files ] [ Delete ]
67. Custom Pages and Tabs (2) SMF 2 - RC3 1.1  July 15, 2014, 06:06:40 PM [ Uninstall ] [ List Files ] [ Delete ]
68. Add [li] Button 1.0  July 24, 2014, 05:49:39 PM [ Uninstall ] [ List Files ] [ Delete ]
69. Multiple QA support 1.0.1  July 24, 2014, 05:53:51 PM [ Uninstall ] [ List Files ] [ Delete ]
70. Add Honey Pot to Track IP 1.1  August 04, 2014, 03:56:46 PM [ Uninstall ] [ List Files ] [ Delete ]
71. Misc Anti Spam 1.0  August 04, 2014, 04:00:43 PM [ Uninstall ] [ List Files ] [ Delete ]
72. Stop Forum Spam 1.0  August 04, 2014, 04:06:56 PM [ Uninstall ] [ List Files ] [ Delete ]
73. Word Censor List 1.1  August 04, 2014, 06:29:11 PM [ Uninstall ] [ List Files ] [ Delete ]
74. Prevent Topic View Increase by Author 1.0  August 06, 2014, 06:51:58 AM [ Uninstall ] [ List Files ] [ Delete ]
75. Confirmation message to Mark as Read 1.00  August 06, 2014, 06:53:27 AM [ Uninstall ] [ List Files ] [ Delete ]
76. Add [nobbc] button 1.1  August 06, 2014, 06:58:31 AM [ Uninstall ] [ List Files ] [ Delete ]
77. Admin Ban Button in Post 3.0  August 06, 2014, 07:38:48 AM [ Uninstall ] [ List Files ] [ Delete ]
78. Change All Subjects 1.3  August 06, 2014, 07:46:52 AM [ Uninstall ] [ List Files ] [ Delete ]
79. Drafts 2.0.5  August 06, 2014, 08:23:17 PM [ Uninstall ] [ List Files ] [ Delete ]
80. Minimum Characters for Search 1.2.1  August 06, 2014, 08:43:28 PM [ Uninstall ] [ List Files ] [ Delete ]
81. Order Stickied Topics 1.01  August 06, 2014, 09:38:34 PM [ Uninstall ] [ List Files ] [ Delete ]
82. Referrals System 3.1  August 06, 2014, 09:45:02 PM [ Uninstall ] [ List Files ] [ Delete ]
83. Annoy User 1.2.4  August 06, 2014, 11:24:46 PM [ Uninstall ] [ List Files ] [ Delete ]
84. Restrict Email Providers on Registration 1.2  August 06, 2014, 11:40:08 PM [ Uninstall ] [ List Files ] [ Delete ]
85. Groups See Hidden Users 1.0  August 06, 2014, 11:51:30 PM [ Uninstall ] [ List Files ] [ Delete ]
86. BBC In Custom Title 2.0r2 - SMF 2.0.x  August 07, 2014, 12:08:24 AM [ Uninstall ] [ List Files ] [ Delete ]
87. Integration Hooks Report 1.5.3  August 07, 2014, 10:03:01 PM [ Uninstall ] [ List Files ] [ Delete ]
88. Member Color Link 3.1  August 22, 2014, 05:45:11 PM [ List Files ] [ Delete ]
89. Invitation Message In Your Face (IMIYF) 0.3.2  August 22, 2014, 05:47:50 PM [ Uninstall ] [ List Files ] [ Delete ]
90. Google Wallet Subscriptions 1.0.3.2  August 27, 2014, 02:18:14 AM [ Uninstall ] [ List Files ] [ Delete ]
91. Additional Topic Authors 0.1.1  August 28, 2014, 05:28:21 PM [ Uninstall ] [ List Files ] [ Delete ]
92. Rank Image Drop Down 1.0  August 29, 2014, 04:56:55 PM [ Uninstall ] [ List Files ] [ Delete ]
93. Buddies List 1.0.1  August 29, 2014, 06:05:11 PM [ Uninstall ] [ List Files ] [ Delete ]
94. Moderator and Administrator Comment Tags 1.8.1  September 03, 2014, 05:11:24 PM [ Uninstall ] [ List Files ] [ Delete ]
95. Sisyphus 1.0  September 04, 2014, 07:55:40 AM [ Uninstall ] [ List Files ] [ Delete ]
96. Login Detector 1.0  September 05, 2014, 06:06:20 AM [ Uninstall ] [ List Files ] [ Delete ]
97. LUP: Logout Under Profile 1.0.0  September 05, 2014, 06:22:32 PM [ Uninstall ] [ List Files ] [ Delete ]
98. Spoiler BBCode 1.1.3  September 11, 2014, 08:21:22 PM [ Uninstall ] [ List Files ] [ Delete ]
99. Hide PM Text in Email Notifications 1.0  September 13, 2014, 06:03:20 PM [ Uninstall ] [ List Files ] [ Delete ]
100. Users mass actions 0.1.1  September 16, 2014, 12:17:50 AM [ Uninstall ] [ List Files ] [ Delete ]
101. Yellow: Highlight Package On Hover 1.1.0  September 16, 2014, 03:09:55 AM [ Uninstall ] [ List Files ] [ Delete ]
102. Group Key Order and Style 1.1  September 16, 2014, 06:14:02 PM [ Uninstall ] [ List Files ] [ Delete ]
103. Stars to Profile 2.1  September 17, 2014, 03:11:51 PM [ Uninstall ] [ List Files ] [ Delete ]
104. Back to Top 1.1  September 17, 2014, 03:39:14 PM [ Uninstall ] [ List Files ] [ Delete ]
105. Permission to Edit Display Name 1.2  September 17, 2014, 03:58:27 PM [ Uninstall ] [ List Files ] [ Delete ]
106. Permission for Website Url Of Users 1.4  September 17, 2014, 04:08:57 PM [ Uninstall ] [ List Files ] [ Delete ]
107. Topic_Locked_Message 2.2  September 17, 2014, 04:33:08 PM [ Uninstall ] [ List Files ] [ Delete ]
108. Track User Logins 1.1  September 19, 2014, 02:29:56 AM [ Uninstall ] [ List Files ] [ Delete ]
109. Off-Topic BBC 1.0  September 23, 2014, 07:22:44 PM [ Uninstall ] [ List Files ] [ Delete ]
110. EmailValidator 1.0  September 25, 2014, 09:00:21 PM [ Uninstall ] [ List Files ] [ Delete ]
111. SMF 1.1.20 / 2.0.9 Update 1.0  October 03, 2014, 09:52:39 PM [ Uninstall ] [ List Files ] [ Delete ]
112. Logout Prompt 1.0  October 13, 2014, 05:09:14 PM [ Uninstall ] [ List Files ] [ Delete ]
113. Install & Uninstall Mods Quickly 1.4  October 13, 2014, 05:20:15 PM [ Uninstall ] [ List Files ] [ Delete ]
114. Reply Button In Every Post 1.0  October 15, 2014, 02:04:50 AM [ Uninstall ] [ List Files ] [ Delete ]
115. Admin Toolbox 1.0  October 15, 2014, 08:33:46 PM [ Uninstall ] [ List Files ] [ Delete ]
116. Styled Maintenance Mode Message 1.0  October 16, 2014, 05:23:47 PM [ Uninstall ] [ List Files ] [ Delete ]
117. 6 Custom buttons / tabs with Sub Menus (4) 0.5  October 16, 2014, 06:00:28 PM [ Uninstall ] [ List Files ] [ Delete ]
118. SA Chat 0.1.5 Rev110 October 16, 2014, 09:50:29 PM [ Uninstall ] [ List Files ] [ Delete ]
119. Mark as Read Redirect 1.0  October 17, 2014, 08:15:21 AM [ Uninstall ] [ List Files ] [ Delete ]
120. Mark PM Unread 0.1.0  October 17, 2014, 09:04:00 AM [ Uninstall ] [ List Files ] [ Delete ]
121. Advance Fake Guests n Users Online (fguo) 1.0  October 17, 2014, 09:05:49 AM [ Uninstall ] [ List Files ] [ Delete ]
122. LMGTFY BBcode 3.7.4  October 17, 2014, 09:54:45 AM [ Uninstall ] [ List Files ] [ Delete ]
123. ICAP: Info Center Access Permission 1.0.0  October 18, 2014, 10:02:35 AM [ Uninstall ] [ List Files ] [ Delete ]
124. Language on Register 1.0  October 23, 2014, 10:21:14 PM [ Uninstall ] [ List Files ] [ Delete ]
125. Enhancements to reattribute posts 1.5.7  October 23, 2014, 11:46:39 PM [ Uninstall ] [ List Files ] [ Delete ]
126. Switch Permissions 1.0  October 24, 2014, 02:00:40 AM [ Uninstall ] [ List Files ] [ Delete ]
127. Personalized BBC 1.8  October 24, 2014, 06:44:39 AM [ Uninstall ] [ List Files ] [ Delete ]
128. Better Profile Menu 1.7  November 02, 2014, 11:21:03 PM [ Uninstall ] [ List Files ] [ Delete ]
129. Ohara YouTube Embed 1.2  November 11, 2014, 09:57:48 AM [ Uninstall ] [ List Files ] [ Delete ]
130. Time Button [time] 1.0  November 18, 2014, 09:32:39 AM [ Uninstall ] [ List Files ] [ Delete ]
131. Poll Moderation Logging 1.0  November 18, 2014, 09:39:20 AM [ Uninstall ] [ List Files ] [ Delete ]
132. Redirect on Login and/or Logout mod 0.4  November 18, 2014, 10:03:09 AM [ Uninstall ] [ List Files ] [ Delete ]
133. Member Awards 3.0  November 18, 2014, 06:26:20 PM [ Uninstall ] [ List Files ] [ Delete ]
134. cbi 1.0 1.8.0  November 19, 2014, 05:07:11 PM [ Uninstall ] [ List Files ] [ Delete ]
135. Say Thanks 1.1  November 21, 2014, 10:52:44 AM [ Uninstall ] [ List Files ] [ Delete ]
136. SimplePortal 2.3.6  November 22, 2014, 10:37:33 AM [ Uninstall ] [ List Files ] [ Delete ]
137. Lazy Admin Menu 1.12  November 22, 2014, 08:33:14 PM [ Uninstall ] [ List Files ] [ Delete ]
138. Administration Center Security 1.0  November 22, 2014, 08:38:11 PM [ Uninstall ] [ List Files ] [ Delete ]
139. Remove "Last edit" mod 0.2.5  November 24, 2014, 11:04:48 AM [ Uninstall ] [ List Files ] [ Delete ]

Allego il file ovviamente e grazie in anticipo :(

emanuele

Anti-Spam-Links

postcount che io veda non è usato nel codice successivo (anzi, viene fatta un'ulteriore query qualche riga dopo), quindi togliendo:
IFNULL(mem.posts, 0) AS postcount,
dovrebbe andare a posto.

Flavio93Zena

Ad essere onesto avevo pensato di rimuoverlo per la stessa identica ragione, però non riuscivo a capire che mod avesse fatto quella modifica... Ora mi viene da pensare come mai faccia così visto che a quanto ne so è installata anche su sm.org ma senza questo errore...

Per la cronaca grazie mille, risolto ^_^

emanuele

Probabilmente perché qualcuno si è preso la briga di testare il codice prima di metterlo on-line su sm.org (dato che risale a prima che io abbandonassi il team dato che è già nel repo SVN che ho io del sito), ma nessuno si è preso la briga di testare il codice del mod dopo che è stato "aggiornato"? :P

Flavio93Zena

Mi viene da vomitare, ho capito la sfumatura :) grazie per la spiegazione!

emanuele

Beh, (e con questo termino l'OT) è lo stesso problema con SMF stesso: testarlo è l'ultima cosa che viene fatta, ed il testare viene confuso con l'esprimere opinioni sulle scelte fatte. Ma non biasimo chi dovrebbe testare, è un'attività ripetitiva e noiosa che porta via un macello di tempo. Però, non biasimo gli sviluppatori, che in 10 anni di sviluppo non han mai pensato di introdurre anche solo un minimo di test automatizzati (che, per quanto pochi possano essere, sono sempre d'aiuto).

Flavio93Zena

Difatti continua qui (quando puoi/vuoi) visto che mi interessa anche quello ma non voglio andare OT --> http://www.italiansmf.net/forum/index.php?topic=1202.0 :)

Discussioni simili (3)