Announcement

Collapse
No announcement yet.

db error

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

  • PiotrasG
    replied
    i got it to work thx for your help

    Leave a comment:


  • Steve Machol
    replied
    What is the table structure of the forum table in the database?

    Leave a comment:


  • PiotrasG
    replied
    i run the script on vb2 and had no conflitcs updating again to vb3 from backup files

    Leave a comment:


  • PiotrasG
    replied
    ok i do this again thx for the help

    Leave a comment:


  • Scott MacVicar
    replied
    you uploaded the script into a vB3 database.

    It was meant to be uploaded into a vB2 installation with a vB2 database.

    Leave a comment:


  • PiotrasG
    replied
    ooops i didnt run that script did i just fup my db :-( i got a backup of it :-)

    when i run that script i get a db error
    http://www.polskieforum.com/database_conflicts.php

    Leave a comment:


  • Steve Machol
    replied
    mysql error: Unknown column 'lastthread' in 'field list'

    You are missing one of the fileds in the forum table. Did you run the database conflict script prior to upgrading?

    http://www.vbulletin.com/forum/showt...threadid=73163

    Leave a comment:


  • PiotrasG
    replied
    also i get this errors

    Database error in vBulletin 3.0.0 Beta 5:

    Invalid SQL:
    UPDATE forum SET
    replycount = 3090,
    threadcount = 87,
    lastpost = 1060933830,
    lastposter = 'krzysiek',
    lastthread = 'Sonda',
    lastthreadid = 2077,
    lasticonid = -1
    WHERE forumid = 10

    mysql error: Unknown column 'lastthread' in 'field list'

    and this one

    Database error in vBulletin 3.0.0 Beta 5:

    Invalid SQL:
    SELECT forumid
    FROM forum AS forum
    WHERE (forum.options & 4096)

    mysql error: Unknown column 'forum.options' in 'where clause'

    mysql error number: 1054

    Date: Saturday 16th of August 2003 11:30:04 AM
    Script: http://www.polskieforum.com/admincp/misc.php
    Referer:
    Username: admin

    Leave a comment:


  • PiotrasG
    replied
    i upgraded from 2.3 to vb 3 i run upgrade.php in install folder

    Leave a comment:


  • Steve Machol
    replied
    What did you upgrade from and which upgrade scripts did you run?

    Leave a comment:


  • PiotrasG
    started a topic db error

    db error

    hi i get this error after upgrading to vb 3 beta 5
    Database error in vBulletin 3.0.0 Beta 5:

    Invalid SQL:
    ### GET FORUM COUNTERS ###
    SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount
    FROM forum AS forum

    mysql error: Unknown column 'lastthread' in 'field list'

    mysql error number: 1054

    Date: Saturday 16th of August 2003 11:18:07 AM
    Script: http://www.polskieforum.com/index.php
    Referer:

    any idea why
Loading...
Working...
X