开发者

Database returning different errors for same query. Instead of column name, column id is returning

I am very much annoyed with servers...

I have seen so many problems which didn't occurs on local system environment, and when the code is uploaded on server... everything seems to be against developers.

Problem :

On my local system I m using database error returned from mysql like :

  0 => string '23000' (length=5)
  1 => int 1062
  2 => string 开发者_Go百科'Duplicate entry 'xyzabc.com' for key 'domain'' (length=46)

and moulding error msg as my wish like:

string 'Error: xyzabc.com already exist/used.' (length=38)

for jquery flashing message as it didin't look good to display exactly same error returned by database.

X-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-X

Now when I uploaded on server to make it live it responded like this:

array(3) {
[0]=>  string(5) "23000"
[1]=>  int(1062) 
[2]=>  string(39) "Duplicate entry 'xyzabc.com' for key 2" 

}

Field       Type                 Collation
id      int(11) 
domain      varchar(50)              latin1_swedish_ci
added       datetime    
is_delete   enum('no','yes')   latin1_swedish_ci

I can only use 1062 message,but I m posting multiple values, so for that I need to go through every posted value to check, that for which the error is coming.

Now where this key '2' came from?? :-/ as it should be domain. I am assuming that it is column_id. But how to solve this problem?? what I need to change in server to response like my local sytem environment?


I think the problem may be that you have locally

  2 => string 'Duplicate entry 'xyzabc.com' for key 'domain'' (length=46) 

and remotely

[2]=>  string(39) "Duplicate entry 'xyzabc.com' for key 2" 

NB Different quotes!

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜