mysql database errors

Comii

Newbie
Joined
Sep 13, 2011
Messages
46
Reaction score
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.jpgdb error.jpg
 
that sentences for create table in database. but images quality is too low, i can n'tsee exactly
 
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 :)
 
Just do a backup via PHPmyAdmin and have him run it on his host.
 
this can help
https://support.flippa.com/entries/21929808-How-Can-I-Transfer-my-WordPress-Site-to-its-New-Owner-
 
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.)
 
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 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)
 
All he has to do is

USE snifa;

Before importing the database.
 
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..
 
Last edited:
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.
 
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
 
Back
Top