Results 1 to 5 of 5

Thread: All Database Errors (affecting login and other areas) have now been fixed.

  1. #1
    Administrator Andres Kello's Avatar
    Join Date
    Jun 2007
    Location
    Barcelona
    Posts
    3,548

    Thumbs up All Database Errors (affecting login and other areas) have now been fixed.

    Hi Folks,

    Just a quick update to let you know that all DB problems should have now been fixed.

    One of the DB Tables had crashed and the host just repaired it.

    Please let me know if you're still getting errors.
    My .mobi's: Dating.mobi | Dubai.mobi | Adult.mobi | Banking.mobi | Student.mobi | Call.mobi | Horoscope.mobi | Messenger.mobi | Classifieds.mobi | LiveTV.mobi

    Developed: Yup.mobi | Mobility
    | Why .mobi? | Banking | Vuelos | Airline Complaints | Random Site | Whois | Free Mobile Dating | Free Dictionary | Free Thesaurus | Horoscope | Astrology | Free Translation | Exchange Rates


  2. #2
    Pred
    Guest

    Thumbs up

    phew
    good job getting fixed mate
    first time been able to log on all day

  3. #3
    Senior Member newton's Avatar
    Join Date
    Jun 2007
    Location
    Near a golf course
    Posts
    1,711

    Default

    Snap
    The speed of light is faster than sound that's why some people appear bright until they open their mouths

    To everyone who thinks a profitable viral marketing campaign is so easy to accomplish I would suggest to go and do it instead of complaining that others aren't - Scandiman

  4. #4
    Senior Member andymoore's Avatar
    Join Date
    Aug 2008
    Posts
    1,612

    Default

    You shouldn't have to wait for your host, repairing a table is easy enough if you have access to phpmyadmin

    From there you tick the table, select repair from the list and you're done!

    Or.... Schedule an hourly cron, check table status, if overhead or need to repair ect do it and if that fails have it email you so you can follow it up manually.

    But.... If that works it should auto fix itself within an hour or tell you about the error first hand.

    It only effect me for a couple of pages yesterday, nice it's back now tho!


  5. #5
    Senior Member andymoore's Avatar
    Join Date
    Aug 2008
    Posts
    1,612

    Default

    A wee script to optimise tables with overhead:
    PHP Code:
    $db mysql_connect('','','');
    mysql_select_db('',$db);

    $result mysql_query('show table status');
    $num mysql_numrows($result);

    while (
    $i $num) {
        echo 
    '<b> '.mysql_result($result,$i,"Name").'</b><br />';
        echo 
    'Rows: '.number_format(mysql_result($result,$i,"Rows")).'<br />';
        echo 
    'Index size: '.number_format(mysql_result($result,$i,"Index_length")).'<br />';
        if((
    $overhead mysql_result($result,$i,"Data_free")) > 0){
            echo 
    'Overhead: '.number_format($overhead).'<br />';
            if(
    mysql_query('OPTIMIZE TABLE ' mysql_result($result,$i,"Name"))){
                echo 
    'Table optimized!<br />';
            }else{
                echo 
    'Unable to optimise table<br />';
            }
        }else{
            echo 
    'No overhead';
        }
        echo 
    '<hr />';
        
    ob_flush();
      
    flush();
      ++
    $i;
    }

    mysql_close(); 
    That's just a hack to keep overhead down, if you want something which will check table status and run repairs if needed check out this link which seems to do the job:

    http://www.purplepixie.org/myrep/source.php

    Databases can be *******, nice bits of code like this give them the slap they need every so often!

    Andy Moore
    i don't do tech / mobi anymore - why do something that annoys and stresses lol

    New: Most Minty Tooth Oil - GMO and fluoride free toothpaste alternative

    100% natural botanical extracts to whiten teeth, freshen breath and strengthen gums
    Used, recommended and sold by Harley Street private dentists

    My other websites:

    http://sellyoursongs.info/ - Sell Your Songs using Mobile Payments
    http://detectmobilebrowsers.mobi/ - Detect Mobile Browsers
    http://andymoore.info/m-commerce-php/ - M-Commerce PHP (sell stuff on the mobile web)
    http://locationdetection.mobi/ - Detect a mobile browser's latitude & longitude
    http://andymoore.info/mysql-lyrics-database/ - Half a million lyrics


Similar Threads

  1. Login problem ?
    By GijsZePa in forum Suggestions / Comments / Criticisms
    Replies: 6
    Last Post: 11-30-2009, 12:52 PM
  2. No mobile signal in border areas: Govt to telcos - Hindu
    By Scavenger in forum Mobile Industry News
    Replies: 0
    Last Post: 08-10-2008, 08:50 AM
  3. Ftp login process
    By domainitrix in forum mobiSiteGalore (Akmin)
    Replies: 1
    Last Post: 07-14-2008, 07:57 PM
  4. Govt Procures Mobile Clinics for Rural Areas - AllAfrica.com
    By Scavenger in forum Mobile Industry News
    Replies: 0
    Last Post: 03-25-2008, 09:50 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
A Yup.mobi Mobile Site
Mobile Dating