Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

voltagexx

Members
  • Content count

    11
  • Joined

  • Last visited

Profile Information

  • Real Name
    Tom Perkins
  1. I'm still wondering if there's any possibility at all that anyone would know a fix for the problem I mentioned previously.... I'm getting an error sometimes where an order can be started and then if you go back in to pay and stuff (like if you have an item saved in your shopping cart and came back a day later to buy it), the code is already in there, and when you try to submit it, the following message comes up, and there's no way to pay. 1062 - Duplicate entry 'myspace-17' for key 1 insert into discount_coupons_to_orders (coupons_id, orders_id) values ('myspace', '17')
  2. Thanks again for the help. I seem to have it working now...most of the time. haha. I'm getting an error sometimes where an order can be started and then if you go back in to pay and stuff, the code is already in there, and when you try to submit it, the following message comes up, and there's no way to pay. 1062 - Duplicate entry 'myspace-17' for key 1 insert into discount_coupons_to_orders (coupons_id, orders_id) values ('myspace', '17') I have no idea what the "17" is. I did a search through this thread and found someone that appeared to have the same problem, but I'm not quite sure what the solution was, so I hoped maybe you wonderful people could explain it to me. Here's a link to the previous page in the thread where someone had the same sort of issue, in the last few posts. http://forums.oscommerce.com/index.php?sho...p;#entry1065450 We're getting one step further every time. :)
  3. I'm still looking for help on this one. I thought maybe I should run the SQL statements from the README file for the discount coupons, but now when I try to do that (I'm not showing all the columns I don't think when I click discount_coupons in phpmyadmin) I get the error message #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 'CREATE TABLE IF NOT EXISTS discount_coupons ( coupons_id VARCHAR ( 32 ) NOT NUL' at line 1 I believe I'm supposed to have 10 columns or something, but I only have coupons_id, coupons_description, coupons_discount_percent, coupons_date_start, coupons_date_end, coupons_max_use, coupons_min_order. Anybody? I feel like I'm right there, but I'm just not sure what's going wrong, or more importantly of course, how I fix it. Is there any other information I need to give in order for someone to be able to help me out??
  4. Of course, I spoke too soon. I'm getting one step further each time before I get another error. ha. I'm sure this is another SQL type problem that will be fixed in a similar way, I'm just not sure how. I can type all the stuff to create a coupon, but then when I click Insert, I get a page with the following: 1136 - Column count doesn't match value count at row 1 insert into discount_coupons values ( 'myspace', 'MySpace Friend 20% off', '.20', 'percent', null, "2008-06-08", 0, 0, null, 100) [TEP STOP]
  5. Ok great, I'll trust that since you have it working and don't seem to have any problems, that I should go ahead and put them on. And that should pretty much fix everything, after two weeks of countless different issues. Muchas gracias! Time to try and promote some more now.
  6. ShaBAM!! This worked! date_start and date_end did not have "coupons_" in front of them, so I added them. There's also max_use and min_order that don't have coupons_ in front. I noticed these didn't show up in the errors, so I tried it without altering these, and it seems to work ok. But do you know if I should be adding the "coupons_" prefix in front of max_use and min_order as well? Thank you SO much for the help. I figured it was going to be some simple little 30-second fix, but it would have taken me forever to figure out I'm sure.
  7. I thought for SURE the link for "Admin Login Issue with OsC RC2" would be exactly what was going wrong for me, but still no luck getting in to be able to create coupons. Someone must understand what would be causing my issue, and how the other person was able to solve it. You people are all smarter than me...have at it. haha
  8. Thank you so much, this did appear to solve that issue. Of course, now I've got a new one (that's how it's been going...haha). I had been uploading in binary apparently, which I didn't realize was bad. Actually I think I had "auto" selected, but regardless, that error has gone away. All the links I mentioned are now working great...except one. The Catalog>Discount Coupons link (it's showing up correctly now instead of the weird "BOX_CATALOG_DISCOUNT_COUPONS") is giving me an error I saw earlier in the thread, and the person says they fixed it, but I don't quite know what they did. I'm now getting the message 1054 - Unknown column 'cd.coupons_date_end' in 'order clause' select * from discount_coupons cd order by cd.coupons_date_end, coupons_date_start limit 0, 20 [TEP STOP] Their reply to this problem said "Fixed ! I found that when creating the tables in the database, the prefix "coupons_" was left off of a few columns" but I don't completely understand what I should be doing to solve this. I've sent this person a private message, but I figured I would reply here as well to let you know that the first problem was fixed, and just in case someone else can help me with the new problem as well. Thanks again for all your help!!!
  9. I installed this and had an error I saw listed here, Discount Coupons 1146 - Table 'store.discount_coupons' doesn't exist select count(*) as total from discount_coupons cd [TEP STOP] (before "store" there was stuff related to my actual link) and I saw the fix posted right below it, with some SQL stuff to run (I really don't know much about all this, but everything I did looked exactly like the directions said) and now I get a new error when I try to go to the catalog section of my admin site and click "BOX_CATALOG_DISCOUNT_COUPONS" in order to make a coupon. Now it's saying 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 '-20, 20' at line 1 select * from discount_coupons cd order by cd.coupons_date_end, coupons_date_start limit -20, 20 [TEP STOP] I'm also getting similar errors when I click on "Manufacturers," "Specials," "Tax Zones," "Tax Classes," "Tax Rates," "BOX_REPORTS_DISCOUNT_COUPONS," and "Newsletter Manager" Does anyone have ANY idea what could be wrong to cause all of this stuff?! Every time in the past two weeks that I've been trying to get this working, I'll fix something and find a new problem. Thank you SO much to anyone who can get me all fixed up. :)
×