savagegerbil Posted April 19, 2004 Posted April 19, 2004 Hi, my website is located at www.xboxrepairguide.com. It's live but I am receiving emails regarding people making new accounts and logging in. Whenever I try to create an account and log in I have no problems and have tried it on three differant computers around the house as well as with various browsers. If you have a chance could you create an account and purchase one of the guides? Use the following discount code to bring the total to $0, 1234567890 Thanks!
mattwho Posted April 19, 2004 Posted April 19, 2004 your create_account_success page had a ?> at the top of it and when I clicked a buy now button on this page http://www.xboxrepairguide.com/index.php/cPath/21 i got this error 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 delete from customers_wishlist WHERE customers_id=75 AND products_id= [TEP STOP] I don't know how to fix it but i hope this helps.
savagegerbil Posted April 20, 2004 Author Posted April 20, 2004 your create_account_success page had a ?> at the top of it and when I clicked a buy now button on this page http://www.xboxrepairguide.com/index.php/cPath/21 i got this error1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 delete from customers_wishlist WHERE customers_id=75 AND products_id= [TEP STOP] I don't know how to fix it but i hope this helps. Wow, I didnt even notice that ?> thanks for the eagle eyes. I am still trying to figure out the buy now button, thanks for pointing that out. I just received one email from a customer which is... "Are you having any problems with your site? I've tried several times to place the order, from two different PC's, but clicking the final confirm order button produces a runtime error, hangs up for several minutes, and then returns me to the payment screen. I can't complete the checkout process." It weird how some people dont have a problem yet others do.....
savagegerbil Posted April 20, 2004 Author Posted April 20, 2004 Btw, yes by all means download the guide, keep it as a gift for helping me sort this problem out :D
Guest Posted April 20, 2004 Posted April 20, 2004 your sql errors deal with the wishlist contribution, other errors are most likely the way cookies are being handled on your site.
nrlatsha Posted April 20, 2004 Posted April 20, 2004 All worked well for me. I do have a question/comment for people who offer downloadable products. I noticed the checkout_success page says: "Your order has been successfully processed! Your products will arrive at their destination within 2-5 working days." I don't offer downloads, but is there a way to set that up so if a product or order is downloadable, say: "view download options below" or just kill it completely? Nother question, I see you have linkpoint and gift vouchers/certs working, is there anything special you did? I've been through 118 pages of striders contrib, tried the suggested actions (error in logic...) but can't get it to pass the correct values to linkpoint. Is there a way you can point me in the right direction for how you accomplished this? 9 times out of 10 its a PEBCAK Error (Problem exists between chair and keyboard) Replace that and you're fine...
Guest Posted April 20, 2004 Posted April 20, 2004 yes, it can be set by doing an 'if' statement against the product type, etc.
savagegerbil Posted April 20, 2004 Author Posted April 20, 2004 All worked well for me. I do have a question/comment for people who offer downloadable products. I noticed the checkout_success page says: "Your order has been successfully processed! Your products will arrive at their destination within 2-5 working days." I don't offer downloads, but is there a way to set that up so if a product or order is downloadable, say: "view download options below" or just kill it completely? Nother question, I see you have linkpoint and gift vouchers/certs working, is there anything special you did? I've been through 118 pages of striders contrib, tried the suggested actions (error in logic...) but can't get it to pass the correct values to linkpoint. Is there a way you can point me in the right direction for how you accomplished this? ah I vaguely remember running into a problem with the vouchers but I used the I just installed the linkpoint contribution. I do remember it took a few hours for me to figure out but if you give me some time I will try to find out the fix. I actually stayed up all night and found out why it was being delayed, I am getting the curl error when processing credit cards. When I first set it up I had no problems, I successfully tested it and went live and was receiving orders processed. I am wondering if my host has blocked the port as I have been reading throughout the forums and see that it sometimes happens. I am waiting to hear back from them though. yes, you can change it in /includes/languages/english/checkout_success.php I would be interested though in being able to have both a downloadable text and a time frame text depending on the product. That would be pretty cool
nrlatsha Posted April 20, 2004 Posted April 20, 2004 Just thought that would be cool for those with download stuff... Ahhhh cURL... It has to be compiled with the rest of the php code. Easiest way to see if its installed is to go to admin-->tools-->server info. Do a search for curl and should come up with "CURL support enabled" along with some other curl stuff. If its not, then you go to your host, or, there is another option in that linkpoint contrib... lpphp.php --> there are some comments at the top about curl, it doesn't have to be compiled, but if you have the curl functions available to you, you can point the contrib to them. When I installed on my localmachine, I played with it, but didn't get it to work, then I was like wait a minute, I control the php compiling now, I'll just add curl myself, then it worked of course.... 9 times out of 10 its a PEBCAK Error (Problem exists between chair and keyboard) Replace that and you're fine...
Guest Posted April 20, 2004 Posted April 20, 2004 one note to consider, as you are using [edited], your posts/questions need to be posted there, as they do their own support and know what they have modified in the code. is not a stock osCommerce version and not supported in this forum.
savagegerbil Posted April 20, 2004 Author Posted April 20, 2004 one note to consider, as you are using [edited], your posts/questions need to be posted there, as they do their own support and know what they have modified in the code. is not a stock osCommerce version and not supported in this forum. My Bad, I didnt even think about that. One last question though, I am considering just blowing what I have already and just starting from scratch with a stock OSC, is there a way to copy the database over so I dont lose all of my customer's information/product details?
nrlatsha Posted April 26, 2004 Posted April 26, 2004 My Bad, I didnt even think about that. One last question though, I am considering just blowing what I have already and just starting from scratch with a stock OSC, is there a way to copy the database over so I dont lose all of my customer's information/product details? I'm sure you already found the answer to this, but you can export the database and reimport it to your new store. Installing yourself is always the very best way to learn what you are doing, it may take longer, but in the long run, it'll be faster for you to implement contribs and modify your own code. 9 times out of 10 its a PEBCAK Error (Problem exists between chair and keyboard) Replace that and you're fine...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.