Help with MYSQL Error

[SB_GEMINI]

I purchased this myspace train script yesterday from here
http://www.wizscripts.com/store/ind...id=1&p13_fileid=10&com_action=displaycomments

installed it yesterday and was working fine, then after a dozen people or so had added them selves this error accurs when someone tries to add them self...

Invalid query: Duplicate entry '10' for key 1 Whole query: INSERT INTO train ( count, id, display, pictureurl, age, gender, quote, address) values( '10', '69159742', '[Ryan]', 'http://myspace-612.vo.llnwd.net/00696/21/60/696930612_m.jpg', '17', 'Male', 'ADD ME!!', '83.xx.xx.xxx')

Has anyone got any ideas on how i can fix this?

 

[Dan]

You need to go into phpMyAdmin and make ID the primary key.

Right now count is and I don't know what that is..

 

[SB_GEMINI]

Count just seems to just give a new numer to each person like 1,2,3,4,5 etc..

ID is their myspace ID

i dont know how to change the primary key but i had a stab in the dark went into structure in phpmyadmin and saw the area named indexes underneath KEYNAME - primary underneath that FIELD - count.

i edited this to set it to ID, i get this when i click save

"#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key "

Nothing is changed after that, am i doing this right? thxs for your help

 

[Noobie]

This is assuming your count field is NOT your primary key and you want ID to be primary key and unique.
As Dan Friedman said, you need to or should make the ID primary key ...
Delete all your indexes so you start from nothing.
Go to phpmyadmin, select your database ...on the left select your table ... go to structure ... next to the field 'id' click on the key icon, this will make your id your primary key then.. edit the field 'count' ... set the extra drop down list to empty if it was auto increment .

Also i wouldn't use count as a field name

 

[SB_GEMINI]

thxs alot guys that seems to have done it

 

[Noobie]

cool

 

[sdsvtdriver]

thxs alot guys that seems to have done it

Any updates? Did this fix the problem permanently?

I'm asking since I have the same problem.. and I made the same changes a minute ago.

 

[sdsvtdriver]

ok, well that didn't fix my problem.

 

[WizScripts]

The script version is now up to 3.1. The problems above were fixed in version 2.8. Please login to your account and download the latest update.

Thanks

 

[sortmyspace]

train script

hi, i purchased the exact same script but cant install it, pls help

 

[WizScripts]

In order for me to help, you will have to either login to support at WizScripts.com or send me a pm with the PayPal transaction#. After I verify your payment, I will be glad to help you get it installed on your server.