Announcement

Collapse
No announcement yet.

VB CP List visitors in the last 24 hours MYSQL error

Collapse
X
 
  • 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
    Script: http://www.mydomain.com/forums/forum...=edit&userid=3
    Referer: http://www.mydomain.com/forums/admin/index.php?s=$session[sessionhash]

  • #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 [ vbulletin.com blog summary ]

    Comment


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

      Comment


      • #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.

        update:

        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, 6:14am.

        Comment

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