johnr3

Answering my own question here but removing the following line from the install function of /admin/modules.php made it work (line 230) //tep_db_query("ALTER TABLE ". TABLE_CONFIGURATION ." CHANGE `configuration_value` `configuration_value` TEXT NOT NULL"); No idea why this line is causing the problem or whether it is bad to remove it? thanks John

help please! i've been developing a new site for a while and it was using google checkout 1.3 - everything was fine but tonight i decided to update to 1.4.5. i got as far as 1.4 and i "removed" the module in admin, but now when i try to put it back I get an error. I even went back to my backup of the site using 1.3 and it still says the same :- 1044 - Access denied for user 'user'@'localhost' to database 'database' ALTER TABLE configuration CHANGE `configuration_value` `configuration_value` TEXT NOT NULL [TEP STOP] any advice please! how can I at least get back to a working installation! trying to remove or install other modules works fine. thanks john

I've just tested it on our development server and i'm getting basket error again if I have no delivery address. Any idea?

Hi Tom, is this fix in the new version? Thanks John

Now had two orders where payment has been taken but the order hasn't been confirmed in oscommerce so there is no order. As I've had to turn "send basket contents" off, this is a real problem! Any idea? Thanks John

Exact same problem and same temporary solution. Is there a fix?

Who's Shopping Contribution - July 26 2007 - a simple modification to the Who's Online admin page The contribution removes the need to click on everyone in the Who's Online list to see if they are active shoppers or not. It adds a new column in the Who's Online report in the admin section. The column is called Shopping and by default it shows N for (N)o they are not shopping. When a shopper places an item in their basket, it changes to Y for (Y)es they are shopping. If a user removes the last item from their basket and the basket is now empty, it changes to E for (E)mpty basket but customer was shopping. You can find the simple instructions - 4 file edits and 1 line of sql - at http://www.oscommerce.com/community/contributions,5319 Any problems please let me know.

Hi Tom I'm having some problems with users getting failed payments. When I checked the failed transactions on Protx it seems that the billing address, name, card details etc are not being passed over (or at least not saved at Protx) but the delivery address and shopping basket etc is being passed over. Have you seen this before, any ideas? Thanks John

Tom, found a small bug. We allow users to collect, in which case no delivery address is passed. The code as it is automatically adds commas (,) between the delivery lines, ie. $delivery_add .= ",\r\n" . $order->delivery['suburb']; This was causing an INVALID error and "If you provide a DeliveryAddress you must provide and DeliveryPostCode and vice versa." so I've changed the code to if($order->delivery['suburb']) $delivery_add .= ",\r\n" . $order->delivery['suburb']; for all those lines and it now works fine. Thanks John

Ah, just the test page Tom, sorry. Not gone live with 4.3 yet, should have it live later today. Thanks for your work Tom.

Hi Tom, The fixed width iframe rule, what is it? Does it have to be 400x400 or can it be any size as long as it is fixed-width? 400x400 is too small and gives scroll bars. Thanks John

Finally found someone at Protx who seemed to want to solve the problem. It's still not working (problem at their end) but we've fixed that error about the entity. Barclaycard had put an & in our name! Hence the XML parser was failing... Thanks

Any idea what file the "line 4" error is relating to?

Hi Tom, It is yes. I've just changed my 3d secure rules (so all options are ticked) to allow errors to proceed and it is now working but the 3d secure section on the transaction is saying "The initial authentication request returned an ERROR. No 3D-Authentication occurred! Please e-mail [email protected] to inform us of this error." I guess what matters is whether or not it has tried to authenticate. If I've understood it correctly, if it tries to authenticate but fails, it will still be allowed to proceed after the 1st which, for now, will do but obviously I need to get this working! Sadly, protx have been next to useless with this as well. I asked them to turn on simulator mode a month ago and they said to call them and they'll do it there and then. I've just called them and they have said they will have to email a request and it *might* be done today! Thanks John

Hello, I too am trying to get 3d secure on before the end of the month and we're getting this error: Your 3D Secure rulebase Rejected this transaction. 3D-Secure validation returned a status of ERROR - Unable to form PAReq : Error at line 4 in The entity name must immediately follow the \' Has anyone got any suggestions please? Thanks John