cinolas

Hello, I tried installing this contribution but encountered some problems so I decided to uninstall it. Besides I've found that duplicating the product then changing the main info and adjusting the attributes (basically using a product as an attribute template) was good enough for me. The problem is that before deciding to uninstall it I went and tried to edit a product's page in the admin panel and I do believe that triggered a modification in the DBs. I now get the following error when I try to add an attribute to a product: 1136 - Column count doesn't match value count at row 1 insert into products_attributes values ('', '68', '9', '107', '', '+', '') [TEP STOP] And I can also see 2 new tables: am_attributes_to_templates am_templates So I deleted the attributeManager folder and restored my categories.php to what it was before trying to install this mod. How do I undo the changes to the DBs so as to completely uninstall this contrib and so that I can add attributes again ? I figure I can safely delete the 2 new tables but it seems (judging by the error message) the products_attributes table has been modified and that's what the main problem is. How do I undo those changes ? I'm using phpMyAdmin. Thank you very much for the help.

Introducing: a brand new problem with PSI Gates XML payment module for OC. We have two installations of OsCommerce: one for Canadian shoppers and one for US and International shoppers. In our US-International shopping cart we offer the prices in Euro and in USD using OsCommerce built-in currency system since we frequently get sales from the EU. With the previous PSI Gate payment module (pre-XML) all was well, the price would get converted to USD using the OsCommerce exchange rate (which we would keep up to date) and then be passed to PSI Gate. The CC would get charged the correct USD equivalent of the Euro price. With the current XML PSI Gate payment module however the price arrives unconverted to PSI Gate but in USD, so an item at 100Euro would end up being charged as 100USD on the CC. Looking at the now infamous line 201 of psigate_xml.php: $psi->setSubTotal(number_format($order->info['total'] * $currencies->get_value($currency), 2)); or $psi->setSubTotal(number_format($order->info['total'] * $currencies->get_value($currency), 2,'.','')); with the comma thousands separator fix (This is not our Canadian store so I don't have to involve the fix for missing taxes on shipping which has a different line 201). It seems to me there is some attempt at currency conversion. Anyone has any idea what's wrong ? Thanks in advance.

Check the other topics regarding this problem, one of them has the solution.

Thank you SO MUCH ! It worked as advertised and solved all of our problems... well that problem anyway :D Cheers

Same problem here, have you figured it out ? Thanks

Same problem here, have you figured it out ? Thanks

Hello all, I am having a problem where osCommerce is adding everything nicely but the PSI Gate XML payment module forgets to charge taxes on shipping, as described and discussed in this topic and also in this topic but without any posted solutions. I would appreciate the solution if someone figured it out, or a hand in getting rid of the problem. It seems to if I could only get line 201: $psi->setSubTotal(number_format($order->info['total'] * $currencies->get_value($currency), 2)); to take the right total, the one that includes the taxes on shipping, I'd be set, but have no idea how. That line calls for the field "total" in "order" but the SQL DB name is "orders" and doesn't contain a field called "total"... shows that I don't get it... Little help ? Thanks !

Thank you! I have been eagerly awaiting your update, hopefully including a fix for the encoding issue :) Thanks again !

I tried this and it didn't work, I still get encoding errors on the same characters but I think the misinterpreted character is different (still not the right encoding but a different one none the less). Any ideas ? FlyingMonkey: Thanks for the contrib, good stuff. I'm sure you are aware that we are all eagerly awaiting a fix for the encoding problem (I sure am), we are wishing you good luck in vanquishing the problem :D Cheers

I should also mention: The RewriteBase line of the .htaccess is properly set to my cart directory. The "Use Search-Engine Safe URLs (still in development)" option of osCommerce is disabled.

Hello, I'm trying to install Ultimate SEO URLs 2.2.1 on my osCommerce 2.2 MS2 installation (running on Apache 1.3.34 (Unix) with PHP 4.4.2). After following the installation instructions carefully I try accessing my shopping cart and get an "Internal Server Error (500)" and my error log reports "/home/lisa/public_html/cadcart/.htaccess: Illegal option RewriteEngine". I contacted my host and they assure me that the server is capable of mod_rewrite. I found that if I comment out the "Options +FollowSymLinks" line of the .htaccess file of cart directory that problem goes away. Not knowing too much about .htaccess files I'd like to know if the FollowSymlinks line is mandatory ? What if I put it in the .htaccess file of my root instead ? Any idea why I get this error ? Once I comment out that line I am able to access the front page of my store, but then going to a product or category (I can see the URL being rewriten) but I get a 404 since the page doesn't exist... I believe I have seen this documented somewhere else but haven't seen a clear answer to the problem, so if someone woudn't mind too much pointing me in the right deirection :D

Sorry double post, cant delete, see here under:

I think you are both forgetting about the tare weight (weight of packing materials), you can set that to 0 if necessary in Configuration - Shipping/Packaging - Package Tare weight. Cheers

We've been using PSIGate with OSC for a year now and they are OK, not great but functional. Their reporting is really hard to make any sense of and impossible to add up as verification... and they do sometimes make mistakes, so you have to be on your toes to catch them. They apparently have a more secure OSC module coming up with better reporting.... So we're looking for better. Please let us know if you do find better, we'll do the same. Cheers

I guess I can just add a region can't I ! Much simpler and less involving... DOH Thanks :D

It would work but my 3 zones are already full: 1 for continental USA, 1 for Alaska and Hawaii and 1 for the rest of the countries we sell to.... Thanks for the help!

Great contribution! But I am still having problems because of the field size limit. Anyone knows which field in which database needs to be changed to "longint" as described here: QUOTE "The module doesnt take all the states enteres because of the coding of OSC and the structure of the database. The database field allows for only so much data stored. To let the field take more. Edit the mySQL database and change/modify the field. Similar to "int vs. longint"?" Instructions on how to apply this change using MyPhpAdmin would also be appreciated. Thanks!

Hi all, We are almost done setting up OSC with PSI-Gate. We've been approved by PSI gate and our account has been enabled. I am having difficulties setting up the PSI-Gate payment module: We are wanting to use their remote secure server for the credit card collection as we do not have SSL ourselves. When trying to process a payment we get the errror: "Credit Card Information must be supplied" As though PSI-Gate's server was expecting to receive the credit card info with the query. Weird considering that the PSI-Gate payment module is set to Credit Card Collection: Remote Anyone knows what were doing wrong ? Cheers