Announcement

Collapse
No announcement yet.

Lot´s of databse problems.

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

  • Lot´s of databse problems.

    for one thing if i want to send a page link to a friend.
    it emails me this error:
    Code:
    Database error in vBulletin 3.7.0:
     
    Invalid SQL:
     
                    INSERT INTO regimage
                            (regimagehash, imagestamp, dateline)
                    VALUES
                            ('cd38ca3bc9c373e94cdaa209a0b97c10', 'WARHY9', 1210166996);
     
    MySQL Error   : Table 'consolef_forum.regimage' doesn't exist
    Error Number  : 1146
    Request Date  : Wednesday, May 7th 2008 @ 08:29:56 AM
    Error Date    : Wednesday, May 7th 2008 @ 08:29:56 AM
    Script        : [URL="http://www.console-forums.net/sendmessage.php?do=sendtofriend&t=50"][COLOR=#0000ff]http://www.console-forums.net/sendmessage.php?do=sendtofriend&t=50[/COLOR][/URL]
    Referrer      : [URL="http://www.console-forums.net/"][COLOR=#810081]http://www.console-forums.net/[/COLOR][/URL]
    IP Address    : 85.92.84.232
    Username      : Unregistered
    Classname     : vB_Database
    MySQL Version :
    the email is actually sent, so the function works, but the irritation mails about db errors are a pain in the ass.

    in User CP under moderated items, post and tread are giving this error:
    Code:
    Database error in vBulletin 3.7.0:
    Invalid SQL:
      SELECT COUNT(*) AS threads
     
      FROM moderation AS moderation
      INNER JOIN thread AS thread ON (moderation.threadid = thread.threadid)
     
      WHERE type = 'thread'
       AND forumid IN (3, 8, 9, 10, 11, 80, 22, 24, 25, 26, 27, 28, 29, 19, 30, 31, 32, 33, 34, 35, 21, 36, 62, 63, 64, 65, 66, 20, 37, 67, 68, 76, 69, 70, 23, 38, 71, 72, 73, 74, 75, 12, 13, 14, 15, 16, 17, 18, 39, 40, 43, 46, 7, 77, 6, 79);
    MySQL Error   : Unknown column 'moderation.threadid' in 'on clause'
    Error Number  : 1054
    Request Date  : Wednesday, May 7th 2008 @ 08:39:11 AM
    Error Date    : Wednesday, May 7th 2008 @ 08:39:11 AM
    Script        : [URL]http://www.console-forums.net/moderation.php?do=viewthreads&type=moderated[/URL]
    Referrer      : [URL]http://www.console-forums.net/usercp.php[/URL]
    IP Address    : 217.136.238.232
    Username      : admin
    Classname     : vB_Database
    MySQL Version : 5.0.45-community-log
    and
    Visitor Messages
    Social Group Messages
    Picture Comments
    Album Pictures

    all generates blank pages

    this is since i updated to 3.7 from 3.6.9.

    i have not a single plugin or program installed.

    please help me

    www.console-forums.net
    Last edited by Possemaster; Wed 7 May '08, 6:03am.

  • #2
    I would start by reuploading all your 3.7 files and then running the /install/upgrade.php script again and making sure it says it finishes.

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

    Comment

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