remixstore

I got this going on on the user side... :( 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 'order by pd.products_name' at line 1 select count(p.products_id) as total order by pd.products_name [TEP STOP]

#NEW FIELDS FOR DOWNLOADS CONTROLLER INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Downloads Controller Update Status Value', 'DOWNLOADS_ORDERS_STATUS_UPDATED_VALUE', '4', 'What orders_status resets the Download days and Max Downloads - Default is 4', '13', '90', '2003-02-18 13:22:32', '', NULL , NULL); INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Downloads Controller Download on hold message', 'DOWNLOADS_CONTROLLER_ON_HOLD_MSG', '<BR><font color="FF0000">NOTE: Downloads are not available until payment has been confirmed</font>', 'Downloads Controller Download on hold message', '13', '91', '2003-02-18 13:22:32', '', NULL , NULL); INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Downloads Controller Order Status Value', 'DOWNLOADS_CONTROLLER_ORDERS_STATUS', '2', 'Downloads Controller Order Status Value - Default=2', '13', '92', '2003-02-18 13:22:32', '', NULL , NULL);

the first part i got no prob... but this part lower down I don't understand :blink: can you clarify this a lil more...

My exact inquiry... anyone get this working? lemme know if you find a way :) please What I guess I want to know... like in your situation... If you assigned an extra category to say PAINTER 1 then PAINTER 1, Painting 1 and Painting 2 would be also able to be able to add. maybe like a click box option. or if you added a category to SCULPTURES then Sculptures Sculptor 1 Sculpture 1 Sculpture 2 would all have the extra category... and if I understand it doesn't show unless it is filled in, which is cool. My thing is that I have so many categories... like say I was doing dvds. I'd want a field for Actors, Directors, UPC, (description is default), etc... I'd have to add an extra field to each category... like say Drama, Comedy, Music, etc so just for those 3 I'd have to add 9 new fields... the trick is there are a lot more categories and a lot more fields. I guess it's do-able but I wanted to see if anyone was able to remix this thing one more time :)

I third the motion. We have OSCAffiliate almost installed. I got kinda confused... cuz on the contrib listing ( http://www.oscommerce.com/community/contri...all/search,mall ) they list the mall stuff when you scroll down... I just assumed it was all integrated. It looks mostly like banners.

I try and goto OSC2Nuke Admin and I get this where you 'Choose an Action' where all the icons are: I get the icon BOX_HEADING_AFFILIATE BOX_AFFILIATE, BOX_AFFILIATE_BANNERS In the actual contrib folder after unzipping we get the oscaffiliate folder. and an Admin and Catalog folder in that. in the catalog folder is a catalog and a CVS folder. since this is OSC2Nuke where is this CVS support to go ?? up hierarchy up would be the modules folder. Where does this other CVS folder go ???

I am using OSC2NUKE... and none of our Affiliate links work except the main in the general config. For this error in the catalog admin as referenced above I found part of the the fix... I simply commented out the "includes/" der... Smile so it went from this (~line 240): // Include OSC-AFFILIATE require('includes/affiliate_application_top.php'); // End OSC-AFFILIATE MOD to this: // Include OSC-AFFILIATE require('affiliate_application_top.php'); // End OSC-AFFILIATE MOD And it fixed the Left column text link error (althought they goto dead pages) and the icon navigation admin stuff is still broken so now when I click the 2 links I get this error on a new page Sorry, such file doesn't exist... The 2 text links in the left column that t's trying to go to are: https://[domain].com/osc2nuke/modules.php?name=catalog&file=FILENAME_AFFILIATE_ and https://[domain].com/osc2nuke/modules.php?name=catalog&file=affiliate_affiliates and the links it's trying to goto under the osc2nuke > catalog (icon admin page) where it says BOX_HEADING_AFFILIATE BOX_AFFILIATE, BOX_AFFILIATE_BANNERS are https://[domain].com/osc2nuke/modules.php?name=catalog&file=FILENAME_AFFILIATE_SUM&selected_box=affiliate and https://[domain].com/osc2nuke/modules.php?name=catalog&file=FILENAME_AFFIL&selected_box=affiliate and https://remixstore.com/osc2nuke/modules.php...d_box=affiliate

ok, we had same prob too.... we emailed them Thank you for registering to use USPS Web Tools. You will receive an email within 24 hours with a new and unique Web Tools User ID and Password and instructions for next steps. Once you receive your User ID and Password, you can begin your Web Tools integration. Additional permission is required for our Address Information Web Tools. If you wish to use these tools, please contact [email protected] for more information. If you do not receive your email within 24 hours of registration, please contact our Internet Customer Care Center at [email protected].

Has anyone gotten this to work with OSC2Nuke??? http://www.osc2nuke.com/modules.php?name=F...pic&p=3444#3444 I am stuck but so close :blink:

well... after battling with this for DAYS... I think we found the problem. it was with the required fields of our authorize.net settings. Settings and Profile > Payment Form > Form Fields

we're going to try re-installing... there's an update. http://www.oscommerce.com/community/contri...h,authorize.net And fyi... Any of the following card numbers can be used to run tests on your Authorize.Net account. It must be noted that these are not real card accounts, and will not generate an approval if your account is in live mode. They will return a decline in live mode, and an approval in test mode. Use any expiration date after today unless indicated differently. 370000000000002 American Express Test Card 6011000000000012 Discover Test Card 5424000000000015 MasterCard Test Card 4007000000027 Visa Test Card 4012888818888 second Visa Test Card 3088000000000017 JCB Test Expiration Date 0905 38000000000006 Diners Club/ Carte Blanche Test Expiration Date 0905 4222222222222 Visa Error Test The last testing card number is used to generate errors. THIS CARD IS INTENDED TO PRODUCE ERRORS, and should only be used if that is your intent. The system has been designed so that this special test credit card number can be used to generate error responses from Authorize.Net. To cause the system to generate a specific error, send a transaction with the card number 4222222222222, and an amount equal to the number of the error you want the system to return. For example, if a transaction is sent to the system in test mode with a credit card number of 4222222222222, and an amount of 12 dollars, the system will respond with error 12, "Authorization Code is required but is not present"

From what I understand if your server has cURL it should say Compiled and then left blank.

yeah, we are using test CCs but sometimes they go thru... sometimes they don't so i don't think it's that like we can get successful test transactions and have before and in response... we do not host our own site. and as far as the php.ini I have no idea. i've never messed with it

I reloaded the Authorize.net Consolidated for AIM ? 2004 and I did 2 successful MC test transactions... but not in a row. I haven't changed anything else and it gave this error between and after with a different mock account as well "There was an error processing your credit card ():"

and btw, I have the PayPal IPN installed... that works but it doesn't discount