Announcement

Collapse
No announcement yet.

MySQL Error after upgrade to 2.0.2

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

  • Trevor Hannant
    replied
    Cures a lot of evils does that!

    Glad it's working now...

    Leave a comment:


  • Jenan
    replied
    the line is thier and yet not working so...
    I reupload the files from member area
    reupload files FTP
    then reinsert the xml file

    and its work

    Leave a comment:


  • Trevor Hannant
    replied
    Open the XML file that you downloaded from here and search for 'options_everyone'. You should be taken to a line that says:

    Code:
    CHANGE options_everyone options_member INT UNSIGNED NOT NULL DEFAULT '0'
    If not, then you've either got an incomplete download or it's been corrupted in some way.

    Try downloading the package from the members area on here again, re-upload the files then import the product-vbblog.xml file again in AdminCP.

    Leave a comment:


  • Jenan
    replied
    i did
    same error

    Leave a comment:


  • Trevor Hannant
    replied
    Looks like you haven't imported the XML file or it hasn't happened correctly as the options_everyone table was changed in 2.0.2 to options_member.

    Try re-importing the XML file again.

    Leave a comment:


  • Jenan
    started a topic MySQL Error after upgrade to 2.0.2

    MySQL Error after upgrade to 2.0.2

    Database error in vBulletin 3.8.2:

    Invalid SQL:

    SELECT blogid
    FROM blog AS blog
    LEFT JOIN blog_user AS blog_user ON (blog_user.bloguserid = blog.userid)

    WHERE dateline <= 1242903484 AND blog.pending = 0 AND state = 'visible' AND options_buddy & 1 AND options_everyone & 1
    ORDER BY RAND()
    LIMIT 1;

    MySQL Error : Unknown column 'options_everyone' in 'where clause'
    Error Number : 1054
    Request Date : Thursday, May 21st 2009 @ 05:58:04 AM
    Error Date : Thursday, May 21st 2009 @ 05:58:04 AM
    Script : http://www.takfeed.com/forum/blog.php
    Referrer : http://www.takfeed.com/forum/index.php
    IP Address : 87.109.165.184
    Username : admin
    Classname : vB_Database
    MySQL Version : 4.1.22-standard

Related Topics

Collapse

Working...
X