Announcement

Collapse
No announcement yet.

Site not operational

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

  • Lats
    replied
    Try recreating the table with this in phpmyadmin...
    Code:
    CREATE TABLE IF NOT EXISTS `vbull.session` (
      `sessionhash` char(32) COLLATE latin1_general_ci NOT NULL DEFAULT '',
      `userid` int(10) unsigned NOT NULL DEFAULT '0',
      `host` char(15) COLLATE latin1_general_ci NOT NULL DEFAULT '',
      `idhash` char(32) COLLATE latin1_general_ci NOT NULL DEFAULT '',
      `lastactivity` int(10) unsigned NOT NULL DEFAULT '0',
      `location` char(255) COLLATE latin1_general_ci NOT NULL DEFAULT '',
      `useragent` char(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
      `styleid` smallint(5) unsigned NOT NULL DEFAULT '0',
      `languageid` smallint(5) unsigned NOT NULL DEFAULT '0',
      `loggedin` smallint(5) unsigned NOT NULL DEFAULT '0',
      `inforum` smallint(5) unsigned NOT NULL DEFAULT '0',
      `inthread` int(10) unsigned NOT NULL DEFAULT '0',
      `incalendar` smallint(5) unsigned NOT NULL DEFAULT '0',
      `badlocation` smallint(5) unsigned NOT NULL DEFAULT '0',
      `bypass` tinyint(4) NOT NULL DEFAULT '0',
      `profileupdate` smallint(5) unsigned NOT NULL DEFAULT '0',
      PRIMARY KEY (`sessionhash`)
    ) ENGINE=MEMORY DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

    Leave a comment:


  • jakaroo
    replied
    Vbull version 3.7.4
    MySQL client version: 4.1.20
    PHP 4.4.9
    Last edited by jakaroo; Tue 20 Dec '11, 6:17am.

    Leave a comment:


  • Lynne
    replied
    What version of php and mysql are you running and what version of vb?

    Leave a comment:


  • jakaroo
    replied
    MySQL Error : Table 'vbull.session' doesn't exist
    Error Number : 1146


    In PHPadmin I see this below... and the same on CPsession




    315 HEAP latin1_swedish_ci 611.8 kb 151.1 kb

    Leave a comment:


  • Lats
    replied
    Originally posted by jakaroo View Post
    ..."The Forum database has encountered a problem" Is there anywhere that I can find what the actual error is...
    Yes, right-click and view the source of the page - that will show the actual error message.

    Post back what that error message.

    Leave a comment:


  • jakaroo
    replied
    The host did a server upgrade about 3 weeks ago, all has been fine until today. doing a repair in PHPadmin... I get 2 tables that have a error
    cpsession repair note The storage engine for the table doesn't support repair
    session repair note The storage engine for the table doesn't support repair

    Leave a comment:


  • Videx
    replied
    Originally posted by Lynne View Post
    Have you asked your host if they have done anything to your server lately (upgraded php or mysql or anything)?
    This is my #1 suspect. Don't make the mistake of talking to chat support - they're just first-tier. File a ticket with whatever system is in place there. Ask specifically if they changed anything recently. I know you said your other dbs are working, but it's possible vb exercises different functions. What type of hosting is this anyway (shared, VPS, dedicated)?

    And give us a link so we can at least let you know if we're (not) getting the same error.

    Oh and PS on the db repair - you'll probably get timed out if you 'select all', so you'll probably have to at least do the larger tables separately.

    Leave a comment:


  • Lynne
    replied
    Do you have a backup or does your host have a backup? Have you asked your host if they have done anything to your server lately (upgraded php or mysql or anything)?

    Leave a comment:


  • Videx
    replied
    I'm no db expert. But in my phpmyadmin I go to table view by selecting my db on the left, then I "check all" at the bottom of the page, then just to the right of that I "With selected - Repair table".

    Leave a comment:


  • jakaroo
    replied
    ok, not sure how I can fix the DB, if I don't show any errors? Where do I start to "correct" the issue that I can' t see in PHPadmin?

    Leave a comment:


  • Videx
    replied
    The first thing I would do is try to repair the db in phpmyadmin. If that didn't work I would just upload this morning's backup.

    Leave a comment:


  • jakaroo
    replied
    I have no additional information, all has been working fine until about a hour ago. All other Databases on my server are working fine.

    Leave a comment:


  • Ramsesx
    replied
    Don't you have more informations about this error? Best may be opening a support ticket.

    Leave a comment:


  • jakaroo
    started a topic Site not operational

    Site not operational

    I'm running Vbull version 3.7.4 and all has been working fine until today, then suddenly I get a DB error when trying to load the forum or access the Admin CP. My host shows no errors on their end and all I see is "The Forum database has encountered a problem" Is there anywhere that I can find what the actual error is, or what is the best way to troubleshoot this error?

    Thanks for any help to get my site back up and running quickly!

Related Topics

Collapse

Working...
X