Go Back  HTML Forums - Free Webmaster Forums and Help Forums > WEBSITE DEVELOPMENT > Databasing
User Name:
Password:
 

Reply
Thread Tools   Display Modes
  View First Unread
 
Old 10-25-2009, 01:37 AM
  #1
loverboy420
Fighter (Level 4)
 
Join Date: Oct 2009
Posts: 36
iTrader: (0)
loverboy420 is an unknown quantity at this point
Unhappy MySQL probem! Dear VEGE!

this is error occuring!


PLZ HELP!!!
loverboy420 is offline   Add to del.icio.us Add to del.icio.us    Can you digg it?Can you digg it? Reply With Quote
Old 10-25-2009, 08:50 PM
  #2
Horus_Kol
Mod of the Underlay
 
Horus_Kol's Avatar
 
Join Date: Jun 2002
Location: At a desk, hooked up and ready to rock
Posts: 17,350
iTrader: (0)
Horus_Kol is a glorious beacon of lightHorus_Kol is a glorious beacon of lightHorus_Kol is a glorious beacon of lightHorus_Kol is a glorious beacon of lightHorus_Kol is a glorious beacon of light
you have a duplicate set in your values - (1, 360)

since you've set the two columns as your primary key - you can only have 1 pair with those values...
__________________
New Photo Gallery: Modus InOperandi
Personal Blog: HorusKol
Articles on Programming and Development (PHP/HTML/CSS, C/C++, more): RandomTweak
Horus_Kol is offline   Add to del.icio.us Add to del.icio.us    Can you digg it?Can you digg it? Reply With Quote
Old 10-26-2009, 09:05 AM
  #3
Vege
master of bloody obvious
 
Vege's Avatar
 
Join Date: Sep 2004
Location: Finland
Posts: 3,550
iTrader: (0)
Vege is just really niceVege is just really niceVege is just really niceVege is just really niceVege is just really nice
When inserting to that table you need to put every value that starts with zero inside ''
INSERT INTO TABLE VALUES ('01',22),('02',44)...

You need to edit that dump file in editor that understands utf8 or your data will be altered.
Notepad++ is a good free one.
There should be "encoding" option in the toolbar -menus, choose UTF8 without bom.

Horus: it's a table where columns are varchar and for some reason dump don't add '' around those numeric variables, even thou columns is varchar.
thats why (01,444) is converted to 1,444 and collision is made.

Last edited by Vege : 10-26-2009 at 09:07 AM.
Vege is offline   Add to del.icio.us Add to del.icio.us    Can you digg it?Can you digg it? Reply With Quote
Old 10-26-2009, 05:20 PM
  #4
Horus_Kol
Mod of the Underlay
 
Horus_Kol's Avatar
 
Join Date: Jun 2002
Location: At a desk, hooked up and ready to rock
Posts: 17,350
iTrader: (0)
Horus_Kol is a glorious beacon of lightHorus_Kol is a glorious beacon of lightHorus_Kol is a glorious beacon of lightHorus_Kol is a glorious beacon of lightHorus_Kol is a glorious beacon of light
oh... i see.

strange...
__________________
New Photo Gallery: Modus InOperandi
Personal Blog: HorusKol
Articles on Programming and Development (PHP/HTML/CSS, C/C++, more): RandomTweak
Horus_Kol is offline   Add to del.icio.us Add to del.icio.us    Can you digg it?Can you digg it? Reply With Quote

Reply
KEEP TABS
SPONSORS
 
Boxedart



 
 


 
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
  
 
 
 



 
  POSTING RULES
 
 
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Thread Tools
Display Modes

Forum Jump

 

All times are GMT -5. The time now is 06:12 PM.

   

Mascot team created by Drawshop.com

Powered by vBulletin® Version 3.6.7
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.

Server Monitoring by ENIACmonitor 0.01
HTMLforums.com © Big Resources, Inc. Web Design by BoxedArt.com
vRewrite 1.5 beta SEOed URLs completed by Tech Help Forum and Chalo Na.