1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysql database errors

Discussion in 'PHP & Perl' started by Comii, Jan 7, 2014.

  1. Comii

    Comii Newbie

    Joined:
    Sep 13, 2011
    Messages:
    45
    Likes Received:
    7
    I've just sold a website to someone, and they wanted to copy it themselves from my server, and now the guy's complaining there's an error in the database and wants a refund. I'm not that skilled with all this, but I'm wondering if he's wanting to con me etc. Is this a valid error? Do you think he might have made it happen on purpose?
    Thanks
    Comii
    db error 2.jpg db error.jpg
     
  2. BeanDH92

    BeanDH92 Regular Member

    Joined:
    Nov 24, 2013
    Messages:
    240
    Likes Received:
    32
    Occupation:
    Web developer
    that sentences for create table in database. but images quality is too low, i can n'tsee exactly
     
  3. SEOEmpire

    SEOEmpire Registered Member

    Joined:
    Dec 14, 2013
    Messages:
    55
    Likes Received:
    32
    The small image shows a strange error, because it looks like he tried to insert html into the db via phpmyadmin. The bigger image is a mistake I saw before. He tries to insert the sql into the db but he first has to select the correct db on the left side of phpmyadmin.
    I dont think he tries to con you, he is just to stupid :)
     
    • Thanks Thanks x 1
  4. seeplusplus

    seeplusplus Power Member

    Joined:
    Aug 18, 2008
    Messages:
    511
    Likes Received:
    163
    Just do a backup via PHPmyAdmin and have him run it on his host.
     
  5. black101

    black101 Supreme Member

    Joined:
    Dec 2, 2010
    Messages:
    1,403
    Likes Received:
    1,567
    Location:
    Switzerland
  6. Orbit143

    Orbit143 Senior Member

    Joined:
    Aug 8, 2010
    Messages:
    893
    Likes Received:
    588
    Location:
    /home
    No database selected. Before sending any queries you need to select a database (and it must exist :) )

    this is how I do it

    PHP:
    $MC MySQL_Connect("127.0.0.1""user""pass");
    $MS MySQL_Select_DB("yourDBname");


    At the beginning of each script (also it's better to include that rather then hardcode it to every script.)
     
    • Thanks Thanks x 1
  7. barigain

    barigain Junior Member

    Joined:
    Aug 23, 2012
    Messages:
    100
    Likes Received:
    12
    You should select a database in your PHPMyAdmin first.
    If database is not created, you should create it first and grant permissions for some user to access this database.
    If you need more assistance, please PM me.
     
    • Thanks Thanks x 1
  8. Comii

    Comii Newbie

    Joined:
    Sep 13, 2011
    Messages:
    45
    Likes Received:
    7
    Thanks everyone! I passed on the information to the buyer, he's been insisting the database is corrupt, and has been asking for a refund (he only paid half the fee upfront). He's now starting to 'scare' me with his lawyer, but I hope what I passed on now will resolve the issue. (He hasn't wanted to make the website live, by which I don't know if it's working or not)
     
  9. bartosimpsonio

    bartosimpsonio Jr. VIP Jr. VIP Premium Member

    Joined:
    Mar 21, 2013
    Messages:
    8,829
    Likes Received:
    7,442
    Occupation:
    ZLinky2Buy SEO Services
    Location:
    ⇩⇩⇩⇩⇩⇩⇩⇩⇩⇩⇩⇩
    Home Page:
    All he has to do is

    USE snifa;

    Before importing the database.
     
    • Thanks Thanks x 1
  10. Gogol

    Gogol Elite Member

    Joined:
    Sep 10, 2010
    Messages:
    3,062
    Likes Received:
    2,872
    Gender:
    Male
    That's the dumbest of mysql db import I have ever seen in my life lol. First create the db and the user from cpanel, then go to phpmyadmin and click on the created db from sidebar. Then do the same thing it will work.

    EDIT: The first error is because you have imported a wrong script(most probably a error page html instead of the sql), not sql. Most probably when you downloaded the backup it was corrupted..
     
    • Thanks Thanks x 1
    Last edited: Jan 13, 2014
  11. jazzc

    jazzc Moderator Staff Member Moderator Jr. VIP

    Joined:
    Jan 27, 2009
    Messages:
    2,468
    Likes Received:
    10,143
    Offer to install the database yourself on his server for free. Otherwise, if it works on your server it 's his problem to learn how to do it - and don't fall for the "lawyer" talk. Tell him that you are not going to be discussing legal matters outside of the channel of properly signed & received legal notices and that you are going to bill him for any legal expenses & time you waste managing it. That will call his bluff.
     
    • Thanks Thanks x 1
  12. SEO Most Wanted

    SEO Most Wanted Junior Member

    Joined:
    Jul 1, 2013
    Messages:
    149
    Likes Received:
    33
    Occupation:
    Professional Web Designer, Web Developer, SEO Rank
    Database is Missing, Just Create It & Fix The Error..
     
  13. WebsiteLiving

    WebsiteLiving Registered Member

    Joined:
    Feb 5, 2014
    Messages:
    99
    Likes Received:
    18
    Home Page:
    I can't believe he wanted his money back with the obvious error message.
     
  14. 101010

    101010 Newbie

    Joined:
    Mar 28, 2008
    Messages:
    17
    Likes Received:
    0
    its his problem, he should have known what hes doing better. Obviously it worked when you sold the site so he can go pay someone and have it fixed in my opinion
     
  15. BaMoon

    BaMoon Newbie

    Joined:
    May 10, 2013
    Messages:
    20
    Likes Received:
    3
    Please select your database first