Trisphee

Trisphee (http://www.trisphee.com/forums/index.php)
-   Help & Support (http://www.trisphee.com/forums/forumdisplay.php?f=3)
-   -   Database Error (http://www.trisphee.com/forums/showthread.php?t=6773)

Duchess 11-01-2011 05:10 AM

Database Error
 
I got one when I tried to do a trade with my mule

Database error in vBulletin 3.8.3:

Invalid SQL:
INSERT INTO vb_trade_item (tradeID, inv_id, itemID, userid) VALUES (14716, 204285, 6234, 53),(14716, 204140, 6227, 53),(14716, 202220, 6227, 53),(14716, 202463, 6227, 53),(14716, 202464, 6227, 53),(14716, 201751, 6227, 53),(14716, 204493, 6227, 53),(14716, 201879, 6227, 53),(14716, 203004, 6227, 53),(14716, 199999, 6227, 53),(14716, 203216, 6226, 53),(14716, 204139, 6226, 53),(14716, 204895, 6226, 53),(14716, 201928, 6226, 53),(14716, 200468, 6226, 53),(14716, 203463, 6226, 53),(14716, 204287, 6226, 53),(14716, 201925, 6226, 53),(14716, 202751, 6226, 53),(14716, 205407, 6226, 53),(14716, 203814, 6226, 53),(14716, 202752, 6226, 53),(14716, 203815, 6226, 53),(14716, 205408, 6226, 53),(14716, 204615, 6226, 53),(14716, 205494, 6226, 53),(14716, 203005, 6226, 53),(14716, 205496, 6225, 53),(14716, 197510, 6225, 53),(14716, 202222, 6225, 53),(14716, 200065, 6224, 53),(14716, 203218, 6224, 53),(14716, 203466, 6224, 53),(14716, 203217, 6223, 53),(14716, 199062, 6223, 53),(14716, 204494, 6223, 53),(14716, 204494, 6223, 53),(14716, 203461, 6223, 53),(14716, 205409, 6223, 53),(14716, 204896, 6189, 53);

MySQL Error : Duplicate entry '14716-204494' for key 1
Error Number : 1062
Request Date : Tuesday, November 1st 2011 @ 02:07:35 AM
Error Date : Tuesday, November 1st 2011 @ 02:07:54 AM
Script : http://www.trisphee.com/forums/trade.php
Referrer : http://www.trisphee.com/forums/trade.php?user=1375
IP Address : 190.213.187.39
Username : Duchess
Classname : vB_Database
MySQL Version : 5.0.92-community

Turns out that the trade went through... it just gave me that for some weird reason. Just thought I'd report it anyways.

Coda 11-01-2011 09:39 AM

That happens when you're clicking too fast. It's not SUPPOSED to happen but when the server lags just right you can sometimes add the same item to the trade twice.


All times are GMT -4. The time now is 09:13 AM.

Powered by vBulletin®