Announcement

Collapse
No announcement yet.

[URGENT] Database error

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

  • mrbiiggy
    replied
    Looks like a typo:
    mysql error: Unknown column 'p.postddateline' in 'field list'
    If you can't fix that yourself, maybe you should try gzipping the .sql backup before uploading it.. I'm sure it would decrease the size a lot. But maybe you don't have shell access to unzip it, hopefully you do.

    Leave a comment:


  • Zachery
    replied
    Your best off asking at vBulletin.org if you dont want to restore your backup.

    Leave a comment:


  • John Diver
    replied
    Thanks anyway
    John

    Leave a comment:


  • Zachery
    replied
    We really cant support hacked boards :/ try restoring your backup.

    Leave a comment:


  • John Diver
    started a topic [URGENT] Database error

    [URGENT] Database error

    Hey,
    Getting this error
    Database error in vBulletin 2.3.2:

    Invalid SQL:
    SELECT t.title, p.userid, p.postid, p.dateline, p.potddateline, u.username
    FROM post p, thread t, user u
    WHERE u.userid = p.userid
    AND t.threadid = p.threadid
    AND p.potddateline >= 1079672400
    ORDER BY p.potddateline DESC
    mysql error: Unknown column 'p.potddateline' in 'field list'

    mysql error number: 1054

    Date: Friday 19th of March 2004 06:36:24 AM
    Script: http://www.hostingrefuge.com/index.php?s=
    Referer: http://www.hostingrefuge.com/private.php?s=


    I had to run a query for a hack but the forum was fine after running it (checked) then uploaded files I had to modify, and got this error.
    Reverted to all files before the edits but still getting the error.

    The backup .sql file takes at least 20 mins to upload because of the size.

    Anyone know what I can do without uploading my backup?

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