solidusss Posted February 12, 2003 Share Posted February 12, 2003 well , i havent add anything yet to my db , i reinstall OSC , and add the WU mod , now i got this msg when customer to confirm order : help me , thanks HEADING_ORDER_STATUS 1054 - Champ 'osh.new_value' inconnu dans where clause select os.orders_status_name, osh.date_added from orders_status os, orders_status_history osh where osh.orders_id = '4' and osh.new_value = os.orders_status_id and os.language_id = '1' order by osh.date_added desc [TEP STOP] Quote Link to comment Share on other sites More sharing options...
elari Posted February 12, 2003 Author Share Posted February 12, 2003 did you run the query before ???? # $Id: 2_orders_status_dos_install.sql,v 1.5 2003/01/31 12:02:31 elarifr Exp $ #Payment Dynamic orders Status #Make following change to table orders_status ALTER TABLE `orders_status` ADD `orders_status_need_conf` TINYINT( 1 ) DEFAULT '0'; ALTER TABLE `orders_status` ADD `orders_status_final` CHAR( 1 ) DEFAULT '0' NOT NULL ; #Change 2M1229 ALTER TABLE `orders_status` CHANGE `orders_status_need_conf` `orders_status_need_conf` INT( 1 ) DEFAULT '0' NOT NULL ALTER TABLE orders_status CHANGE orders_status_final orders_status_final INT (1) DEFAULT '0' not null ALTER TABLE `orders_status` ADD `orders_status_need_conf_id` INT( 11 ) NOT NULL AFTER `orders_status_need_conf` ; #Added / changed 2M1231 ALTER TABLE `orders` ADD `date_finished` DATETIME NOT NULL , ADD `orders_status_closed` INT( 10 ) DEFAULT '0' NOT NULL , ADD `orders_status_need_conf` INT( 5 ) DEFAULT '0' NOT NULL ; ALTER TABLE `orders` ADD `orders_status_need_conf_password` VARCHAR( 32 ) ; ########################################################### ##### Package Released 2M1231 Happynew year ########################################################### #Added 2N0109 Auto comment orders_status ALTER TABLE `orders_status` ADD `orders_status_comment` TEXT NOT NULL ; ########################################################### ##### Package Released 2N0109 Added autocomment orders status ########################################################### ########################################################### ##### Package Released 2N0123 Added autocomment orders status ########################################################### # seems to miss check it ALTER TABLE `orders` ADD `orders_date_finished` DATETIME NOT NULL ; ALTER TABLE `orders` ADD `orders_status_need_conf_id` INT( 11 ) NOT NULL AFTER `orders_status_need_conf` ; #Added 2n0207 to recall payment module for confirmation ALTER TABLE `orders` ADD `payment_module` VARCHAR( 32 ) NOT NULL AFTER `payment_method` ; Quote Link to comment Share on other sites More sharing options...
solidusss Posted February 12, 2003 Share Posted February 12, 2003 i got this msg when runs the query that you ask : Error SQL-query : ALTER TABLE `orders` ADD customers_company varchar( 32 ) MySQL said: Nom du champ 'customers_company' d?j? utilis? whats the problem ? Quote Link to comment Share on other sites More sharing options...
elari Posted February 12, 2003 Author Share Posted February 12, 2003 take a book and study php prend un livre et apprend php / mysql as wrote it means the field already exist run query line by line and check where are following error you can have Quote Link to comment Share on other sites More sharing options...
solidusss Posted February 13, 2003 Share Posted February 13, 2003 tried already and it doesnt seems to work still get this appear at the bottom of customer order history HEADING_ORDER_STATUS 1054 - Champ 'osh.new_value' inconnu dans where clause select os.orders_status_name, osh.date_added from orders_status os, orders_status_history osh where osh.orders_id = '2' and osh.new_value = os.orders_status_id and os.language_id = '1' order by osh.date_added desc [TEP STOP] Quote Link to comment Share on other sites More sharing options...
elari Posted February 13, 2003 Author Share Posted February 13, 2003 it seems the table structure has change on lastest cvs since end jan you can 1/ remove call to the field, but will make / need many change 2/ readd this field in your table order status history (check oscmmerce cvs to see the structure of the osh table as it was before change in catalog/install/oscommerce.sql). readd the old field and keep the new one this solution will be the best one until i update payment to lastest chaneg planned for ms1 Quote Link to comment Share on other sites More sharing options...
solidusss Posted February 16, 2003 Share Posted February 16, 2003 still doesnt work .. when are you going to release a new version ? Quote Link to comment Share on other sites More sharing options...
elari Posted February 20, 2003 Author Share Posted February 20, 2003 just back to work i plan to make change for ms1 next week :( Quote Link to comment Share on other sites More sharing options...
tkeats Posted February 26, 2003 Share Posted February 26, 2003 Does anyone know how to modify this code so you can include your 'affiliation link' to WesternUnion in the shopping cart process? I have looked and can not seem to find it.. Thomas Rainbow Computers http://www.stormpay.com/?50381&OSCF for a alternative to paypal. Quote A signature is something that reflects its user. - The dictionary The question is not, 'to code, or not to code' the question is, 'if we do not code, are we really alive?' -- anonymous Link to comment Share on other sites More sharing options...
elari Posted February 26, 2003 Author Share Posted February 26, 2003 what do you mean by afiliation link ? Quote Link to comment Share on other sites More sharing options...
tkeats Posted February 26, 2003 Share Posted February 26, 2003 Affiliation link, you've not only set up to process payments through a service ie: paypal or western Union, but have been setup to get a cut of the action.. say for example 2% of fee's charged to all orders processed. For example, I am set up with stormpay.com as an affiliate (this is automatic) and my advertising link is.. http://www.stormpay.com/?50381 I want to include somthing like that in the processing of the order. In my mind it would allow not only allow the order process to be completed, but that my 'affiliation' be credited for the % fee's from that sale.. I hope that explains it succinckly?(sp?) Thomas Quote A signature is something that reflects its user. - The dictionary The question is not, 'to code, or not to code' the question is, 'if we do not code, are we really alive?' -- anonymous Link to comment Share on other sites More sharing options...
edpierre Posted February 27, 2003 Share Posted February 27, 2003 just back to work i plan to make change for ms1 next week :( 'til the releasing of the ms1 version, can you email me a dos-payment 2n0901 copy, please. I can't download it from your site Merci d'avance, E. Pierre Quote Link to comment Share on other sites More sharing options...
elari Posted February 28, 2003 Author Share Posted February 28, 2003 Affiliation link, you've not only set up to process payments through a service ie: paypal or western Union, but have been setup to get a cut of the action.. say for example 2% of fee's charged to all orders processed. I want to include somthing like that in the processing of the order. In my mind it would allow not only allow the order process to be completed, but that my 'affiliation' be credited for the % fee's from that sale..Thomas it means ? customer pay 100% to payment gateway you need to make an order total module (like ot_xmember) that will calculate x % from order but without changing total order the shop get 100% payment of order .... & the checkout process will then credit your account from the ot x% amount.... ithink it should be done, but it has nothing to do with this thread :) Quote Link to comment Share on other sites More sharing options...
elari Posted February 28, 2003 Author Share Posted February 28, 2003 just back to work i plan to make change for ms1 next week :( 'til the releasing of the ms1 version, can you email me a dos-payment 2n0901 copy, please. I can't download it from your site Merci d'avance, E. Pierre which email ? if you work on ms1 shop, it will not work since comment field have been removed changed from orders/orders_history. it work if you keep old field comment in orders Quote Link to comment Share on other sites More sharing options...
miguelm Posted March 28, 2003 Share Posted March 28, 2003 Hi, elari. Please how i can download your file dos payment 2n0901 ??? :oops: I try to download you file from http://www.unlockgsm.com/dload-osc/pafiledb.php but is loops Thanks Any Help Miguel Quote Link to comment Share on other sites More sharing options...
elari Posted March 28, 2003 Author Share Posted March 28, 2003 i have send by mail to galapago hope this is good mail, or pm your real mail elari Quote Link to comment Share on other sites More sharing options...
miguelm Posted March 28, 2003 Share Posted March 28, 2003 :thumbsup: :lol: Thanks !! Thanks elari !! Thanks to be pending of this forum ! Merci ? ?tre en suspens de ce forum Miguelm :rockedover: Traducci?n de altavista Babel Fish en Fran?ais: Quote Link to comment Share on other sites More sharing options...
miguelm Posted March 29, 2003 Share Posted March 29, 2003 Hi Elari ! please, which is the file accounting.php in /admin/includes/application_top.php define('FILENAME_ACCOUNTING', 'accounting.php'); I can?t see in the zip file or where is my mistake ???? :shock: miguelm Quote Link to comment Share on other sites More sharing options...
Farrukh Posted March 30, 2003 Share Posted March 30, 2003 Elari, while testing out the Western Union Payment Contribution I got this error on the top of the page, while the rest of the page appeared normally. Parse error: parse error in /usr/local/apache/htdocs/unlockgsm/test_checkout/catalog/includes/languages/english/modules/payment/moneyorder.php on line 14 Also, i get this under Payment INformation Make Payable To: First Name: My First Name Last Name: My Last Name Adress: My Adress Zip Code: My Zip City: My City Country: My Country Phone: My Phone Your order will not ship until we receive MCTN payment number !. It does not list my name etc. Moreover, my friend talked to western union and they said that they require a Personal Identification Number (PID) if the Order amount if less than $2000. Is this feature included in your contribution And when will you be releasing the new version of Western Union Thanks Quote Link to comment Share on other sites More sharing options...
Farrukh Posted March 30, 2003 Share Posted March 30, 2003 It is not PID , its MCTN, my friend was mistaken. Also, i am not able to download the contribution from your site. Quote Link to comment Share on other sites More sharing options...
elari Posted March 30, 2003 Author Share Posted March 30, 2003 these are default value for payment field. just have to edit them and enter your own information. WU is not finished, i have to rewrite some part of Dos Payment before finishing WU 1/ order status must be reimplemented the same way decided by hpdl (it is a little bit diff from the way i had made and hpdl did not keep the way i wrote) 2/ with ms1 comment field has been changed and i have to adjust this way for checkout confirmation so that customer can come back after order and complete order with payment information like mctn number 3/ i have already wrote some part of order confirmation by password try to make an order on my demo page by using cod and then use link like http://www.unlockgsm.com/test_checkout/cat...ent_confirm.php it will be used for wu for customer to enter mctn information. 4/ i have to find some time :(( Quote Link to comment Share on other sites More sharing options...
elari Posted March 30, 2003 Author Share Posted March 30, 2003 you can also try wu payment to see how it will work :) just use this link http://www.unlockgsm.com/test_checkout/cat...ent_confirm.php and provide order number and password to confirm wu mctnand sender information i have no information about the PID ??????? here western union nether asked any PID number to make or receive money i will try to make some screenshot of checkout payment confirmation to see how it will be used Quote Link to comment Share on other sites More sharing options...
elari Posted March 30, 2003 Author Share Posted March 30, 2003 ok i have added english language taht was missing :( and screenshot are here http://www.unlockgsm.com/dload-osc0/screen...er_password.jpg http://www.unlockgsm.com/dload-osc0/screen..._confirm_wu.jpg Quote Link to comment Share on other sites More sharing options...
Farrukh Posted March 30, 2003 Share Posted March 30, 2003 HIya elari I checkout out the WU payment contribution and its working great. Also, can this be completed in time. Where can i download this contribution as the download from your site is not working. Can you email me the file? Quote Link to comment Share on other sites More sharing options...
Farrukh Posted April 1, 2003 Share Posted April 1, 2003 elari Can i get it to download the contribution Also, hows the progress on WU payment? Quote Link to comment Share on other sites More sharing options...
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.