[MySql] Im having this incompatibility error, please help me fix it!

Discussion in 'Programming' started by DJuse, Apr 30, 2008.

0
  1. #1
    # Server version: 5.0.37-standard
    # Protocol version: 10

    Hi guys, Im trying to install this mysql database, but for some reason im getting a bunch of errors like; #1067 - Invalid default value for 'membership'

    Looking around i found out that its that the table structure is no compatible with my version of Mysql.
    Can someone please help me make this compatible with my server version.
    I know that while there are a lot of people here that just love to help, I also understand that your time is money, so Im willing to deposit $10 in the paypal or MoneyBookers account of the first one who can help me with this quick task! :)

    Please download -FILE REMOVED FOR SECURITY REASONS- which contain the data.
     
    DJuse, Apr 30, 2008 IP
  2. iam.xavier

    iam.xavier Well-Known Member

    Messages:
    521
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    125
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    first check what is the version of mysql which is running on the server by running a small script

    <?php phpinfo(); ?>

    It will pull put all the details regarding your server... then check the Version of my sql and get back to us..it will be helpfull for me to help you if you could paste the table query here
     
    iam.xavier, Apr 30, 2008 IP
  3. DJuse

    DJuse Active Member

    Messages:
    509
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    60
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #3
    # Server version: 5.0.37-standard
     
    DJuse, Apr 30, 2008 IP
  4. cool_goan

    cool_goan Banned

    Messages:
    250
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #4
    Has this been sorted yet? I can help you with this.
     
    cool_goan, Apr 30, 2008 IP
  5. iam.xavier

    iam.xavier Well-Known Member

    Messages:
    521
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    125
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #5
    It seems that you have some issues with the query.. If you don't mind can you post the Table query which you r running ... only the part of the query.... so that i can debug the query..
     
    iam.xavier, Apr 30, 2008 IP
  6. phpl33t

    phpl33t Banned

    Messages:
    456
    Likes Received:
    33
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #6
    [Thought about it, my post was illogical. Removed. lol]
     
    phpl33t, Apr 30, 2008 IP
  7. DJuse

    DJuse Active Member

    Messages:
    509
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    60
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #7
    The whole DB is atached to the post, only 43kb

    I believe that sawz got it fix it!
    Will let everybody know!
     
    DJuse, Apr 30, 2008 IP
  8. iam.xavier

    iam.xavier Well-Known Member

    Messages:
    521
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    125
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #8
    Sure not a problem... If the problem still persist get back to us.. :)
     
    iam.xavier, Apr 30, 2008 IP
  9. DJuse

    DJuse Active Member

    Messages:
    509
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    60
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #9
    sawz fixed it.
    Thank you very much for the help...all of you!
     
    DJuse, Apr 30, 2008 IP
  10. iam.xavier

    iam.xavier Well-Known Member

    Messages:
    521
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    125
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #10
    U r welcome.... Good work SawZ... :)
     
    iam.xavier, Apr 30, 2008 IP
    sawz likes this.