Announcement

Collapse
No announcement yet.

Error 1064

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Error 1064

    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&amp;showposts=0&amp;exactname=1&amp;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

  • #2
    SQL Syntax errors are almost always related to modified code. To troubleshoot this, the first thing you need to do is remove any hacks or plugins, then see if you still have this problem.

    If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

    Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X