ldavies83 Posted February 19, 2003 Share Posted February 19, 2003 I downloaded the 2.21 ver first in the hope to upgrade to 2.22 later. however I seem to have a problem. the PHP scripts constantly refer to 'new_value' field in the 'orders_status_history' table where in the original dist files it was 'Orders_status_id'. This is generating errors all throughout the checkout procedure/Admin sections (Invoice, Orders, etc). Is it Ok to just simply replace all occurances of 'new_value' to 'orders_status_id'? Thanks L. Quote Contribs Written: Nochex APC Payment Module, Cheque Payment Module Contribs Updated: Information Pages Unlimited, Latest News V1 You've gotta be Quick on the Draw in this game! Link to comment Share on other sites More sharing options...
ldavies83 Posted February 19, 2003 Author Share Posted February 19, 2003 I dont mean to bump but I forgot to say the version OSc I'm using was 2.22 downloaded 17/Feb/03 Thanks Quote Contribs Written: Nochex APC Payment Module, Cheque Payment Module Contribs Updated: Information Pages Unlimited, Latest News V1 You've gotta be Quick on the Draw in this game! Link to comment Share on other sites More sharing options...
Guest Posted February 20, 2003 Share Posted February 20, 2003 I re-wrote the contribution for MS1 (2/17/03) and just uploaded it today: http://www.oscommerce.com/community/contributions,99 It is a much better version than the past ones anyway! 8) Let me know if you have any troubles with it. Quote Link to comment Share on other sites More sharing options...
ldavies83 Posted February 20, 2003 Author Share Posted February 20, 2003 I'm looking forward to this one, possibly the most important contrib I'll put on, so thanks so much for your dilligence! Will let you know of Praise/Help. Thanks. Leigh, Quote Contribs Written: Nochex APC Payment Module, Cheque Payment Module Contribs Updated: Information Pages Unlimited, Latest News V1 You've gotta be Quick on the Draw in this game! Link to comment Share on other sites More sharing options...
ldavies83 Posted February 24, 2003 Author Share Posted February 24, 2003 By far the best contrib, Very easy to install. Just make sure you do EXACTLY what the txt files say otherwise you will have BIG problems! THANKS JB! Quote Contribs Written: Nochex APC Payment Module, Cheque Payment Module Contribs Updated: Information Pages Unlimited, Latest News V1 You've gotta be Quick on the Draw in this game! Link to comment Share on other sites More sharing options...
micky Posted March 20, 2003 Share Posted March 20, 2003 I have installed this on my site and everything works but, it does not save the cvv number. this field is empty when placing test orders. Is there some other changes that need to be done when using Loaded Snapshot V5.0 (February 2003)??? Installed this CVV on cc.php version 1.23a for OsCommerce 2.2 Milestone Release #1 When I pull up orders in admin Credit Card Type: Visa Credit Card Owner: test Credit Card Number: 0000000000000000 Credit Card Expires: 0106 CVV Number: THis is Blank with delete button next to it. Any help would be appreciated micky Quote Link to comment Share on other sites More sharing options...
Guest Posted March 20, 2003 Share Posted March 20, 2003 First look in your database and check if the cvv number is in there under table_orders and let me know so we can go from there. Quote Link to comment Share on other sites More sharing options...
micky Posted March 20, 2003 Share Posted March 20, 2003 I inserted this into database ALTER TABLE `orders` ADD `cvvnumber` VARCHAR(4) default NULL AFTER `cc_expires`; After placing a test order I checked mysql database to see if it even entered it in the ccvnumber field. Well, it does not. The field is empty no null just blank. It works with every checkout page. even shows the confirmation page with the cvv number there. It just does not get put in the database or in admin orders. Micky Quote Link to comment Share on other sites More sharing options...
Guest Posted March 20, 2003 Share Posted March 20, 2003 Send me a copy of your catalog/checkout_process.php and your catalog/includes/classes/order.php and I will take a look see. I know it works with Loaded 5 as others have added it with no problems...but maybe Ian changed something since then... Quote Link to comment Share on other sites More sharing options...
Guest Posted July 20, 2003 Share Posted July 20, 2003 I installed 1.23a into the latest phesis load -- I am getting the following error message when from the admin panel. Fatal error: Cannot redeclare class cc in /www1/lorihartminerals.com/html/catalog/includes/modules/payment/cc.php on line 13 -- Don't know what this means. -- pretty new to php BTW, The credit card module in the cart still works, but I am not presented with the cc information. thanks Quote Link to comment Share on other sites More sharing options...
Guest Posted July 20, 2003 Share Posted July 20, 2003 I entered the wrong error message: Should have been. Payment Modules Modules Sort Order Status Action Authorize.net function javascript_validation() { Fatal error: Cannot redeclare class cc in /www1/lorihartminerals.com/html/catalog/includes/modules/payment/cc.php on line 13 Problem seems to be with javascript? I am stuck. Quote Link to comment Share on other sites More sharing options...
windmillgirl Posted July 23, 2003 Share Posted July 23, 2003 Hi, I'm having the same problem.. the cvv# isnt showing up.. just Credit Card Type: Visa Credit Card Owner: Test Name Credit Card Number: Test #'s Credit Card Expires: 0104 ENTRY_CREDIT_CARD_CVVNUMBER (REMOVE BUTTON) Have ya'll figured out what the original posters problem was? Sounds like mine is the same as well. I've checked and re-checked the php files and all the modifications are done. The box DOES show up on the order form, but we dont get the info back with the rest of the details. Thanks! Quote Link to comment Share on other sites More sharing options...
Guest Posted July 23, 2003 Share Posted July 23, 2003 I installed 1.23a into the latest phesis load -- I am getting the following error message when from the admin panel.Fatal error: Cannot redeclare class cc in /www1/lorihartminerals.com/html/catalog/includes/modules/payment/cc.php on line 13 -- Don't know what this means. -- pretty new to php BTW, The credit card module in the cart still works, but I am not presented with the cc information. thanks This comes from having another file in your directory calling the cc class. Usually this happens when you leave the back-up copy of your cc.php file in your catalog directory. I assume you probably named the old file something like old_cc.php? Try renaming it to "old_cc.php.bak" so the program will not parse the file. You can also just move the back-up file to a folder outside of OSC so it will not try to parse the file. Quote Link to comment Share on other sites More sharing options...
Guest Posted July 23, 2003 Share Posted July 23, 2003 ENTRY_CREDIT_CARD_CVVNUMBER (REMOVE BUTTON) You have missed at least a portion of the install such as defining " ENTRY_CREDIT_CARD_CVVNUMBER" in the admin language files. Did you follow the install for the admin side as well? Check all of the install files from the admin side to make sure you have completed them all. Quote Link to comment Share on other sites More sharing options...
Guest Posted July 24, 2003 Share Posted July 24, 2003 I've installed about 6 contributions, but for some reason this one has not gone well -- I've made the modifications to all the php files and it still isn't working but I am not getting any error messages either. In going over the install steps, I may not have completed the database alterations. 1. Using mySQL Admin. I've successfully run the "ALTER TABLE via the SQL Query window, but don't know how to insert a row with the following. configuration_title = CVVNUMBER configuration_key = CVVNUMBER_MIN_LENGTH configuration_value = 3 configuration_description = Minimum Length of CVVNumber configuration_group_id = 2 use_function = NULL set_function = NULL Can someone give me a bit of advice to step through it? I am a bit gun shy messing with the database. 2. The is no "cvv2pop.gif" in the 123a zip file -- there is an image "cv_card.gif" -- is that the same image? If so should it be renamed? if not where do I find cvv2pop.gif ? 3. I am totally confused by the following statement. After uploading the catalog/includes/languages/english/modules/payment/cc.php file you need to change the link address for the CVV sample image from (www.yourdomain.com) to the actual path for the gif. - what link? What is the cvv sample image. thanks, Murray Quote Link to comment Share on other sites More sharing options...
Guest Posted July 24, 2003 Share Posted July 24, 2003 Hi Murray, You are confusing me here...this is the directions from CVV1.21 not CVV1.23/1.23a - the install file from 1.23/a has the actual query you need to run. configuration_title = CVVNUMBER configuration_key = CVVNUMBER_MIN_LENGTH configuration_value = 3 configuration_description = Minimum Length of CVVNumber configuration_group_id = 2 use_function = NULL set_function = NULL Can someone give me a bit of advice to step through it? I am a bit gun shy messing with the database. Here are the directions from 1.23a: 1.) SQL statements needed just copy and paste these into your SQL query window and hit 'Go': ALTER TABLE `orders` ADD `cvvnumber` VARCHAR(4) default NULL AFTER `cc_expires`; ***If you have not altered your Configuration Table in the database: INSERT INTO configuration VALUES ( 136, 'CVV2 Number', 'CVVNUMBER_MIN_LENGTH', 3, 'Minimum Length of CVV2 Number', 2, 17, '2003-02-20 10:30:00', '2003-02-20 10:30:00', NULL , NULL ); ***If you have made some alterations to the Configuration Table you will need to change the '136' and '17' to represent the next configuration_id and sort_order(group 2) for your particular database. INSERT INTO configuration VALUES ( 141, 'CVV Max Length', 'CVVNUMBER_MAX_LENGTH', 4, 'Maximum Length of CVV Number', 3, 19, '2003-02-20 10:31:00', '2003-02-20 10:31:00', NULL , NULL ); ***As in the previous entry the '141' and '19' might be different if you have already modified your configuration table. The '4' is the value for maximum length of the CVV number which is needed for American Express cards (the 3 in the query is the group_id so don't change). If you just plan on accepting Visa/MC/Discover you can change this to '3' in the query or the number can also be changed in your admin tool->configuration->maximum values 2. The is no "cvv2pop.gif" in the 123a zip file -- there is an image "cv_card.gif" -- is that the same image? If so should it be renamed? if not where do I find cvv2pop.gif ? Again the cvv2pop.gif file was contained in 1.21 but was changed in 1.23a to cv_amex.gif and cv_card.gif. Are you tring to install 1.23a but using the instructions for 1.21? 3. I am totally confused by the following statement. After uploading the catalog/includes/languages/english/modules/payment/cc.php file you need to change the link address for the CVV sample image from (www.yourdomain.com) to the actual path for the gif. - what link? What is the cvv sample image. Again, this was the directions for 1.21, there is no sample image for 1.23a as it was changed to contain the popup_cvv.php file and the two images cv_card.gif and cv_amex.gif In the install file only read this part: CVV on cc.php version 1.23a for OsCommerce 2.2 Milestone Release #1 Contribution name: CVV 1.23a Released 20th February 2003 Released under the GNU General Public License Download link: http://www.oscommerce.com/community/contributions,99 Contribution Credits: Original creator: Steve Kemp cvv popup window: jchasick This 1.23 release package Contains: Complete php files to simply replace your current files if it is a new install without any previous file edits. Filename.txt files to just show what edits were performed if you have already modified your files and do not want to replace the complete file. SQL commands to perform the database modifications needed. Enhancements added since v 1.21/2: Popup help window for the CVV2 along with new images. Moved admin Remove CVV button to a more convenient location next to the CVV field in admin->edit->orders Remove button now completely deletes the CVV number by changing it to null at the press of a button. CVV number minimum length can be changed in the Configuration->Minimum Values section of your admin panel (no need to dig through files or open DB to change). If you accept AMEX you will need to change the value to 4 rather than 3 which is used by all other cards. Fixed bug that gave 2 warning popups if CVV field was left blank during checkout. All file edits are clearly marked within each php file. Directions: (Remember to back-up all files before editing or replacing!!!) 1.) SQL statements needed just copy and paste these into your SQL query window and hit 'Go': ALTER TABLE `orders` ADD `cvvnumber` VARCHAR(4) default NULL AFTER `cc_expires`; ***If you have not altered your Configuration Table in the database: INSERT INTO configuration VALUES ( 136, 'CVV2 Number', 'CVVNUMBER_MIN_LENGTH', 3, 'Minimum Length of CVV2 Number', 2, 17, '2003-02-20 10:30:00', '2003-02-20 10:30:00', NULL , NULL ); ***If you have made some alterations to the Configuration Table you will need to change the '136' and '17' to represent the next configuration_id and sort_order(group 2) for your particular database. INSERT INTO configuration VALUES ( 141, 'CVV Max Length', 'CVVNUMBER_MAX_LENGTH', 4, 'Maximum Length of CVV Number', 3, 19, '2003-02-20 10:31:00', '2003-02-20 10:31:00', NULL , NULL ); ***As in the previous entry the '141' and '19' might be different if you have already modified your configuration table. The '4' is the value for maximum length of the CVV number which is needed for American Express cards (the 3 in the query is the group_id so don't change). If you just plan on accepting Visa/MC/Discover you can change this to '3' in the query or the number can also be changed in your admin tool->configuration->maximum values 2.) Either replace your files with the complete files provided or do the modifications included with each filename.txt 3.) Upload new file popup_cvv.php 4.) Upload all image files found throughout both directories. Don't go beyond this statement or you will be reading the read-me's from previous versions: Previous versions read me text: (Just in case you want to know it's history) Since you have already installed other contributions I assume you do not want to upload the complete files. So for each file there is a corresponding text file that just highlights the changes. So you just need to read each one of those and make the changes to the file referenced. For instance the catalog/checkout_payment.php file to just see what changes need to be made go to the catalog/checkout_payment.txt file in the zip folder and it will read: ******File edits for catalog/checkout_payment.php****** 1.) Around line 104 find this: // one button is not an array if (document.checkout_payment.payment[0]) { document.checkout_payment.payment[buttonSelect].checked=true; } else { document.checkout_payment.payment.checked=true; } } function rowOverEffect(object) { if (object.className == 'moduleRow') object.className = 'moduleRowOver'; } function rowOutEffect(object) { if (object.className == 'moduleRowOver') object.className = 'moduleRow'; } Add this right after: //begin cvv contribution function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no status=no,menubar=no,scrollbars=yes,resizable=yes,copyhistory=no,width=450,heigh t=450,screenX=150,screenY=150,top=150,left=150') } //end cvv contribution You then just need to follow the instructions for each file listed in both the catalog and admin directories. Quote Link to comment Share on other sites More sharing options...
dvdvideo Posted July 24, 2003 Share Posted July 24, 2003 Has anyone had any luck installing 1.23a on MS2? I had it going on previous CVS2.2 version but now its stufed my admin and cant get to my orders or customers. Parse error: parse error in /dvdvideo/public_html/oscom/catalog/catalog/admin/orders.php on line 187 Help please! There are quite a few changes in MS2 that are quite different to MS1 and I would like to keep it as MS2. Quote Link to comment Share on other sites More sharing options...
risonav Posted March 17, 2005 Share Posted March 17, 2005 Hi. I have the same problem as micky, but the cvv number does show in the database for me. The cvv just doesn't show up in the admin section. When I pull up orders in admin: Credit Card Type: Visa Credit Card Owner: test Credit Card Number: 0000000000000000 Credit Card Expires: 0106 CVV Number: THis is Blank with delete button next to it. Any luck getting it to show? Quote Jen Link to comment Share on other sites More sharing options...
risonav Posted March 17, 2005 Share Posted March 17, 2005 Okay.. I just uploaded everything in Admin again and now it works. So weird cause I tried this like 5 times yeasterday. Quote Jen Link to comment Share on other sites More sharing options...
Guest Posted May 10, 2005 Share Posted May 10, 2005 Can someone explain how I change this one CVV field to being required when they place a credit card order? Right now they can leave it blank and the order still gets processed. Thanks! Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.