Jump to content

Sql Error


killerbud99

Recommended Posts

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 [url=http://www.gamehost-online.com/train/login.php]http://www.gamehost-online.com/train/login.php[/url]
The user name is demo and the password is 012345 these are all numbers.

You can check the purchase script here [url=http://www.gamehost-online.com/train/buy.php?train_id=21&position=20]http://www.gamehost-online.com/train/buy.php?train_id=21&position=20[/url]

The script was obtained from here [url=http://www.smarterscripts.com/myspace-whore-train/]http://www.smarterscripts.com/myspace-whore-train/[/url]

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

Thanks in advance for your support.
Link to comment
Share on other sites

  • 1 month later...
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?
Link to comment
Share on other sites

[quote author=opioq link=topic=111488.msg472767#msg472767 date=1164316619]
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?
[/quote]

In your sql Table: whore_purchase I changed The field from id to user_id and this corrected the problem
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.