Announcement

Collapse
No announcement yet.

mysql in Buddy / Ignore Lists

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

  • mysql in Buddy / Ignore Lists

    I have a few users that are having an issue with error when trying to load the Buddy / Ignore Lists. It's only about 3-4 users, everyone else is having no issues. I will assume that their entry in the database is corrupted, is there a way to "remove" the corruption (try to bring it back to default, to see if that fixes the issue)?

    Code:
    Database error in vBulletin 3.5.3:
    
    Invalid SQL:
    
                            SELECT userid, username FROM user
                            WHERE userid IN (2515,3694,7746,1759,)
                            ORDER BY username;
    
    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 ')
                            ORDER BY username' at line 2
    Error Number : 1064
    Date         : Saturday, February 4th 2006 @ 08:46:34 AM
    Last edited by diettalk; Sat 4 Feb '06, 5:16am.
    John
    diet support at diettalk.com

  • #2
    This could be because one or more files in your vBulletin setup are not uploaded 100% or have been modified.

    Upload the script that reports this error again to your web server, overwriting the one already there. Or uninstall any recently installed hack or plugin to see if that fixes it.

    Comment


    • #3
      If that was the case, wouldn't everyone have the same issue?


      I've uploaded a fresh copy of vb, uploaded a new style (to see if it was a template issue) and it seems not to have fixed the issue. I've disabled all plugins with no luck either.
      Last edited by diettalk; Sat 4 Feb '06, 11:07am.
      John
      diet support at diettalk.com

      Comment


      • #4
        Seems it's a bug?

        http://www.vbulletin.com/forum/bugs3...iew&bugid=2151

        All of the users who are getting this mesage are older (than 3.5.3).

        So, how do I fix this?
        John
        diet support at diettalk.com

        Comment


        • #5
          As posted by Andreas
          --- vb3/profile.php 2005/12/14 22:52:53 1.377.2.1
          +++ vb3/profile.php 2006/01/27 18:03:16 1.377.2.2
          @@ -362,18 +362,18 @@ if ($_REQUEST['do'] == 'editlist')
          $userlist = 'buddy';

          // get buddy ids
          - if ($vbulletin->userinfo['buddylist'])
          + if (trim($vbulletin->userinfo['buddylist']))
          {
          - $buddy_ids = explode(' ', trim($vbulletin->userinfo['buddylist']));
          + $buddy_ids = preg_split('#\s+#si', trim($vbulletin->userinfo['buddylist']), -1, PREG_SPLIT_NO_EMPTY);
          }
          else
          {
          $buddy_ids = array();
          }
          // get ignore ids
          - if ($vbulletin->userinfo['ignorelist'])
          + if (trim($vbulletin->userinfo['ignorelist']))
          {
          - $ignore_ids = explode(' ', trim($vbulletin->userinfo['ignorelist']));
          + $ignore_ids = preg_split('#\s+#si', trim($vbulletin->userinfo['ignorelist']), -1, PREG_SPLIT_NO_EMPTY);
          }
          else
          {
          @@ -2708,7 +2708,7 @@ if ($templatename != '')
          Edit profile.php remove the lines containing the - and replace them with the lines that have a + on them

          eg.
          - if ($vbulletin->userinfo['buddylist'])
          + if (trim($vbulletin->userinfo['buddylist']))
          Means
          Replace:
          if ($vbulletin->userinfo['buddylist'])
          With:
          if (trim($vbulletin->userinfo['buddylist']))
          A bullet may have your name on it, but shrapnel is addressed "to whom it may concern"

          Comment

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