Announcement

Collapse
No announcement yet.

Database error

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

  • borbole
    replied
    What was the latest mod/modification you did to your forum prior to getting that issue?

    Leave a comment:


  • Lynne
    replied
    It looks like this is from a modification. Try disabling your modifications/plugins and see if you still have this problem.
    Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

    PHP Code:
    define('DISABLE_HOOKS'true); 

    Leave a comment:


  • desi-boy
    started a topic [Forum] Database error

    Database error

    help me with this plezzzz


    Code:
    Database error in vBulletin 4.0.3:
    
    Invalid SQL:
    
                    SELECT
                            IF(votenum >= 1, votenum, 0) AS votenum,
                            IF(votenum >= 1 AND votenum > 0, votetotal  / votenum, 0) AS voteavg,
                     post.pagetext AS thumb,
                            thread.threadid, thread.title AS threadtitle,  thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS  threadiconid,
                            thread.dateline, notes, thread.visible, sticky,  votetotal, thread.attach, thread.lastpost, thread.lastposter,  thread.lastposterid, thread.lastpostid, thread.replycount,  IF(thread.views<=thread.replycount, thread.replycount+1,  thread.views) AS views,
                            thread.prefixid, thread.taglist, hiddencount,  deletedcount,
                            user.usergroupid, user.homepage, user.options AS  useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend
    
    
    
    
    
                    FROM thread AS thread
                            LEFT JOIN user AS user ON (user.userid =  thread.lastposterid)
                            LEFT JOIN userlist AS userlist ON  (userlist.relationid = user.userid AND userlist.type = 'buddy' AND  userlist.userid = 0)
    
    
    
    
    
    
    
                    WHERE thread.threadid IN (0)
                    ORDER BY sticky DESC, lastpost DESC;
    
    MySQL Error   : Unknown column 'post.pagetext' in 'field list'
    Error Number  : 1054
    Request Date  : Saturday, May 15th 2010 @ 05:49:09 PM
    Error Date    : Saturday, May 15th 2010 @ 05:49:09 PM
    Script        : [URL]http://www.justdesiz.com/forumdisplay.php/4-Suggestions-amp-Feedback[/URL]
    Referrer      :
    IP Address    : 212.95.54.122
    Username      : Unregistered
    Classname     : vB_Database
    MySQL Version :
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X