I got this error message today. I suspect some code I added is causing the problems. I added a link to the Quick Links menu so users can search for topics with their posts in them. Below is the added code. I've used this many times and received no error messages. Could this be causing problems and why?
<if condition="$show['member']">
<tr>
<td class="vbmenu_option">
<a href="search.php?$session[sessionurl]do=process&showposts=0&exactname=1&searchuser=$bbuserinfo[urlusername]" rel="nofollow" title="My posts">My posts</a>
</td>
</tr>
</if>
<tr>
<td class="vbmenu_option">
<a href="search.php?$session[sessionurl]do=process&showposts=0&exactname=1&searchuser=$bbuserinfo[urlusername]" rel="nofollow" title="My posts">My posts</a>
</td>
</tr>
</if>
Database error in vBulletin 3.6.5:
Invalid SQL:
SELECT postid, post.dateline
, IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.replycount, thread.votenum, thread.votetotal
FROM vb_post AS post
INNER JOIN vb_thread AS thread ON(thread.threadid = post.threadid)
WHERE post.userid IN(1782) AND (postid IN(1517, 1574, 2090, 3290, 3641, 4597, 4626, 4746, 4954, 4958, 4997, 5017, 5026, 5394, 5744, 6642, 7037, 7779, 8503, 8690, 8854, 9142, 9785, 9909, 11022, 11761, 13582, 18499, 18527, 27454, 30981, 31900, 36622, 37178, 37183, 37210, 37623, 39439, 39770, 45307, 47739, 47931, 48011, 53038, 53762, 55176, 55852, 59001, 60525, 60789, 61363, 61722, 62636, 64761, 64926, 65719, 67384, 67841, 68074, 68630, 68665, 68989, 69129, 69798, 71077, 73494, 73507, 73695, 74333, 74936, 75011, 77519, 78367, 81171, 81695, 81711, 82365, 82367, 82441, 82480, 83151, 86254, 90538, 90608, 90611, 90614, 90627, 90631, 90729, 90785, 90787, 90830, 90836, 91264, 91284, 91287, 91323, 91326, 91477, 91489, 91498, 91508, 91516, 97916, 99393, 102516, 102719, 115567, 115700, 123540, 134931, 135180, 140594, 141135, 141239, 141315, 141320, 142123, 147768, 147857, 147859, 148016, 148083, 148584, 148684, 150453, 153779, 155519, 155572, 158342, 163131, 165146, 167548, 167860, 169317, 170675, 171821, 178250, 179840, 184701, 190536, 190715, 195771, 196230, 200527, 201128, 204735, 213583, 215321, 215459, 232179, 232747, 232776, 233010, 233767, 234358, 250576, 255412, 256386, 274589, 285699, 288471, 296007, 300393, 305281, 317674, 326574, 330620, 335301, 339178, 347813, 348097, 354019, 354828, 362024, 381394, 383097, 384787, 384789, 384833, 388145, 388731, 388781, 392190, 392535, 392609, 393096, 395822, 396788, 405294, 412548, 414612) OR postid IN() OR postid IN(3455, 32146, 74690, 174598, 216626, 218657, 222775, 239756, 393059)) AND thread.replycount >= 1;
MySQL 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 ') OR postid IN(3455, 32146, 74690, 174598, 216626, 218657, 222775, 239756, 39305' at line 6
Error Number : 1064
Date : Wednesday, March 21st 2007 @ 02:43:41 PM
Script : [removed]/search.php?do=process
Referrer : [removed]/search.php?do=process
IP Address : [removed]
Username : [removed]
Classname : vB_Database_MySQLi
Invalid SQL:
SELECT postid, post.dateline
, IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.replycount, thread.votenum, thread.votetotal
FROM vb_post AS post
INNER JOIN vb_thread AS thread ON(thread.threadid = post.threadid)
WHERE post.userid IN(1782) AND (postid IN(1517, 1574, 2090, 3290, 3641, 4597, 4626, 4746, 4954, 4958, 4997, 5017, 5026, 5394, 5744, 6642, 7037, 7779, 8503, 8690, 8854, 9142, 9785, 9909, 11022, 11761, 13582, 18499, 18527, 27454, 30981, 31900, 36622, 37178, 37183, 37210, 37623, 39439, 39770, 45307, 47739, 47931, 48011, 53038, 53762, 55176, 55852, 59001, 60525, 60789, 61363, 61722, 62636, 64761, 64926, 65719, 67384, 67841, 68074, 68630, 68665, 68989, 69129, 69798, 71077, 73494, 73507, 73695, 74333, 74936, 75011, 77519, 78367, 81171, 81695, 81711, 82365, 82367, 82441, 82480, 83151, 86254, 90538, 90608, 90611, 90614, 90627, 90631, 90729, 90785, 90787, 90830, 90836, 91264, 91284, 91287, 91323, 91326, 91477, 91489, 91498, 91508, 91516, 97916, 99393, 102516, 102719, 115567, 115700, 123540, 134931, 135180, 140594, 141135, 141239, 141315, 141320, 142123, 147768, 147857, 147859, 148016, 148083, 148584, 148684, 150453, 153779, 155519, 155572, 158342, 163131, 165146, 167548, 167860, 169317, 170675, 171821, 178250, 179840, 184701, 190536, 190715, 195771, 196230, 200527, 201128, 204735, 213583, 215321, 215459, 232179, 232747, 232776, 233010, 233767, 234358, 250576, 255412, 256386, 274589, 285699, 288471, 296007, 300393, 305281, 317674, 326574, 330620, 335301, 339178, 347813, 348097, 354019, 354828, 362024, 381394, 383097, 384787, 384789, 384833, 388145, 388731, 388781, 392190, 392535, 392609, 393096, 395822, 396788, 405294, 412548, 414612) OR postid IN() OR postid IN(3455, 32146, 74690, 174598, 216626, 218657, 222775, 239756, 393059)) AND thread.replycount >= 1;
MySQL 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 ') OR postid IN(3455, 32146, 74690, 174598, 216626, 218657, 222775, 239756, 39305' at line 6
Error Number : 1064
Date : Wednesday, March 21st 2007 @ 02:43:41 PM
Script : [removed]/search.php?do=process
Referrer : [removed]/search.php?do=process
IP Address : [removed]
Username : [removed]
Classname : vB_Database_MySQLi
Comment