No announcement yet.

VB CP List visitors in the last 24 hours MYSQL error

  • Filter
  • Time
  • Show
Clear All
new posts

  • VB CP List visitors in the last 24 hours MYSQL error

    Hello, i get following error when in VB CP and click link 'List visitors in the last 24 hours '

    version 2.2.6
    php ver 4.2.2

    error =

    Database error in vBulletin Control Panel 2.2.6:

    Invalid SQL: SELECT *,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,FROM_UNIXTIME(awaydate) AS awaydate
    avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
    FROM user
    LEFT JOIN avatar ON avatar.avatarid=user.avatarid
    LEFT JOIN customavatar ON customavatar.userid=user.userid
    WHERE user.userid=3
    mysql error: You have an error in your SQL syntax near 'avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
    ' at line 2

    mysql error number: 1064

    Date: Thursday 22nd of August 2002 09:32:56 PM

  • #2
    try reuploading a fresh copy of all php files in /admin from your vB 2.2.6 zip file
    :: Always Back Up Forum Database + Attachments BEFORE upgrading !
    :: Nginx SPDY SSL - World Flags Demo [video results]
    :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ blog summary ]


    • #3
      ok will try, will check to see if i have any hack in there first!


      • #4
        I checked vb settings and i had turned off upload in safe mode, i thought it was disabled, but recent php upgrade must have set it be on, all seems ok but will test some more.


        now edit user repots error, php files should be ok with php 4.2.2 as it was clean install of vb 2.2.6!
        Last edited by carpman; Fri 23 Aug '02, 5:14am.


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