What is going on here?

Discussion in 'MySQL' started by Sleeping Troll, Sep 16, 2008.

0
  1. #1
    I am hosted on godaddy.com, today all of a sudden my mysql database is returning null for int fields with a zero value, anybody else having a problem or is it just me? How can I fix it?
     
    Sleeping Troll, Sep 16, 2008 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    Have you checked with mysqladmin or another administration tool to verify that the fields aren't set to null?

    If they are null you can do an update UPDATE table SET field = 0 WHERE field IS NULL;

    If not, it's most likely an issue with your website and not the DB. Did they upgrade apache or anything else that you know of?
     
    jestep, Sep 16, 2008 IP