Jump to content


Photo

Sql Error


  • Please log in to reply
5 replies to this topic

#1 killerbud99

killerbud99
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 14 October 2006 - 03:06 PM

Hello all,
I have a question I have a script that is giving me errors.
Basicly the script allows a user to Purchase a spot on a myspace train.
When the user clicks on Purchase they are directed to a page that allows them to choose there spat and a price.

When the user chooses it should call the database and collect the users info and then direct them to the paypal payment page.

The error I get is.

Error: Can not perform query select count(*) as count from whore_purchase where user_id = 2 and myspace_id = '35453393' and train_id = 21 and train_position = 20 and round = 5 and transaction_status = 'requested'. Unknown column 'user_id' in 'where clause'

I have created a demo account http://www.gamehost-...train/login.php
The user name is demo and the password is 012345 these are all numbers.

You can check the purchase script here http://www.gamehost-...=21&position=20

The script was obtained from here http://www.smartersc...ce-whore-train/

Please let me know if you need more info and I will provide.

Thanks in advance for your support.


#2 AndyB

AndyB
  • Staff Alumni
  • Advanced Member
  • 5,465 posts
  • LocationToronto

Posted 14 October 2006 - 03:12 PM

Unknown column 'user_id'


That's pretty specific.  The database table you're looking in doesn't have a column (field) named user_id.  Perhaps it's User_ID, or userid, or something similar. Check closely.
Legend has it that reading the manual never killed anyone.
My site

#3 killerbud99

killerbud99
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 14 October 2006 - 04:13 PM

Thanks Andy for your quick and correct reply  :)
The field was set to id insted of user_id I changed this and it now works.
Thanks again for your help

#4 opioq

opioq
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 23 November 2006 - 09:16 PM

I am having this error when trying to purchase a spot on the train

Error: Can not perform query select count(*) as count from whore_purchase where user_id = 5 and myspace_id = '1342355' and train_id = 7 and train_position = 1 and round = 141 and transaction_status = 'requested'. Unknown column 'user_id' in 'where clause' Server busy. Try later

How did you fix your error? Where is the field that you chaned?

#5 killerbud99

killerbud99
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 23 November 2006 - 11:02 PM

I am having this error when trying to purchase a spot on the train

Error: Can not perform query select count(*) as count from whore_purchase where user_id = 5 and myspace_id = '1342355' and train_id = 7 and train_position = 1 and round = 141 and transaction_status = 'requested'. Unknown column 'user_id' in 'where clause' Server busy. Try later

How did you fix your error? Where is the field that you chaned?


In your sql Table: whore_purchase I changed The field from id to user_id and this corrected the problem

#6 opioq

opioq
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 24 November 2006 - 07:43 AM

i appreciate it so much.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users