stevebo

Just to complicate things while my ISP is working on the error... I installed Cubecart on the Fitpacking installation of my new hosting company. It's obviously still in test mode. The new Hosting company has an install button on their cpanel so I just installed it. The install version they have is 5.2.16. I can successfully install it, but once again even though I have migrated the store over to the new database (referenced in global.inc.php) and can see all the items when I browse in PHPMyAdmin, the new store's admin panel shows only the test category and test product. Once again, I cannot seem to link up the database with the store. I must be missing something truly basic. Any ideas? I feel like I've come so far, but it never truly works.

Yeah, I know I just started getting locked out. No idea why. I will probably have to contact my (not so responsive) hosting company again.,

I started messing around with global.inc.php and now I'm completely locked out. I don't even know how to re-install at this point since the setup portion has already been performed and I can't even get an admin login screen anyway. Warning: mysqli::mysqli(): (HY000/1045): Access denied for user 'ssilberberg'@'10.3.25.1' (using password: YES) in \\NAWINFS04\HOME\users\web\b2754\rh.fitpacking\CubeCart\classes\db\mysqli.class.php on line 33Warning: mysqli_options(): Couldn't fetch mysqli in \\NAWINFS04\HOME\users\web\b2754\rh.fitpacking\CubeCart\classes\db\mysqli.class.php on line 35Fatal error: Access denied for user 'ssilberberg'@'10.3.25.1' (using password: YES) in \\NAWINFS04\HOME\users\web\b2754\rh.fitpacking\CubeCart\classes\db\mysqli.class.php on line 38

I have 2 domains hosted at the same hosting company, but I believe they are hosted on different machines / IIS servers. With your help, I was able to get the first domain, Fatpacking.com up and running. The cart works fine, the database is populated and I can connect to both a test and live gateway for payment. So awesome! I have a 2nd domain, Fitpacking.com hosted at the same company but on separate machines (I believe). Using PHPMyAdmin, I exported the MySQL DB from Fatpacking and then imported the DB into Fitpacking. I used different database names, usernames/passwords just to make sure I could differentiate between the two installations. I uploaded a clean Cubecart install into Fitpacking and logged in as administrator. I had to get tech support at my ISP to get the database connection working. I had to do this for Fatpacking as well, so I do know it can work. This gave me a "good" global.inc.php and a fresh admin_xxxxx.php. When I opened the Fitpacking shopping cart, I expected to be able to see categories and products because they were in the uploaded database. But I couldn't see them even though I can see the products when browsing through the database. I figured that images still needed to be transferred and maybe some other connectivity stuff was hiding in the file system so using FTP, I uploaded the entire Cubecart installation from Fatpacking to my machine and subsequently uploaded it to Fitpacking. I attempted not to overwrite the new admin stuff, global.inc.php and admin_xxxxx.php as well as the admin_yyyyyy directory. Unfortunately, I still can't see anything other than the "fresh" install with a test category and a test product. Just for the hell of it, I added another test product. Although I see it when I visit the store, I don't see it in the Fitpacking database nor the Fatpacking database. It is absent in both. I can't for the life of me figure out where cubecart is storing this new product. Any ideas? Thanks, Steve

I have Cubecart installed and working for one of my domains. I am trying to copy the entire installation over to another domain but am having problems. I was able to export the product list (and all the tables) from Domain 1 and import it all into Domain 2. However the Cubecart admin can't see the new database (nor the old one). How do I "link" them up? I looked at global.inc.php and it reflects the new hosts settings. PS: I have not moved the files over yet (like product images for example) because I don't want to wholeheartedly overwrite the entire new Cubecart installation and don't really know what's safe to overwrite and what isn't. Any ideas?

If you a Cubecart user who needs to integrate with the Payeezy Gateway, here is how I did it. Hopefully, this guide will be useful to you. Much of this guide’s content was provided by bsmither with some help from njohn and in other threads around the web. Note: I have not yet, "gone live" so who knows what other bugs may be out there waiting for me? But this should get you connected to a test Gateway. Although Cubecart officially says it doesn’t work on a Windows Server, I was able to get it running on one. I have tried to denote these steps with WINDOWS SERVER ONLY. Cubecart comes with many free gateway “extensions” which install the code necessary to link your Cubecart shopping cart with a Payment Gateway, for example Stripe or Paypal. One of these is Authorize.net, which is the extension used to connect to Payeezy. Don’t get fooled by the First Data extension. Even though First Data and Payeezy are somehow the same (but different?) installing the First Data extension just seems to generate errors. I wasn’t able to get it to work anyway, maybe you can. As an aside, I cannot for the life of me determine whether Payeezy and First Data are one and the same, somehow related or not related at all. Step 1 (Cubecart side): Enable the Authorize.net SIM extension: https://www.cubecart.com/extensions/payment-gateways/authorize-net-aim-sim Click the lightning bolt Copy and paste the token into Extensions > Manage Extensions > Token on the Cubecart admin Click Go to install Under Available Extensions, Authorize.net should now appear. Check the Status box and click Save to make it “live” Click on Authorize.net (Dashboard > Manage Extensions > Authorize) Make sure Mode is SIM unless you are writing your own Payment API (along with all the PCI security codes – who’s got the life force to do that?) in which case you’d choose AIM Check Test Mode (Eventually uncheck and save when going live) You will need to provide an API Login ID and a Transaction Key. You can’t do this until you have set up a Payeezy Gateway Account (Demo account to figure this all out, but eventually a live working account). On the Payeezy Gateway Side: Step 2 (Payeezy side): To establish a Demo Account. Register for a Demo Payeezy account at: https://provisioning.demo.globalgatewaye4.firstdata.com/signup Once registered you will receive welcome emails with your Demo Login Credentials. You should choose Hosted Checkout (HCO) unless you want to write your own Payment API with all the security issues that come with it. HCO allows you to press a submit button from the Cubecart Payment Confirmation page and leave the actual credit card entry page up to the Payeezy Gateway. Cubecart’s free Authorize.net extension sends all the information and fields that the Payeezy Gateway expects such as price and merchant ID (your store name) in order to process the transaction. Next, we’re going to link your Payeezy Demo Merchant Account with Cubecart Log into Payeezy Go to Payment Pages Click on Payment Page ID Choose 10. Hash Calculator Copy x_login and transaction_key into Cubecart > Dashboard > Manage Extensions > Authorize > API Login ID & Transaction Key Click Save Now you are ready to modify the Authorize.net code so that it works with Payeezy. Step 3 (Cubecart again): Change the following code on the server in the file <cubecart folder>/modules/gateway/Authorize/gateway.class.php Find: $this->_url = $this->_module['testMode'] ? 'test.authorize.net' : 'secure.authorize.net'; $this->_path = '/gateway/transact.dll'; Change to: $this->_url = $this->_module['testMode'] ? 'demo.globalgatewaye4.firstdata.com' : 'checkout.globalgatewaye4.firstdata.com'; $this->_path = '/payment'; Also: You must capitalize CC and PAYMENT_FORM in <cubecart folder>/modules/gateway/Authorize/gateway.class.php as specified here: https://support.payeezy.com/hc/en-us/articles/204686725-First-Data-Payeezy-Gateway-Payment-Page-Field-Validation Change 'x_method' => 'cc', To 'x_method' => 'CC', Change 'x_show_form' => 'payment_form', To 'x_show_form' => 'PAYMENT_FORM', WINDOWS SERVER ONLY: add the following code to Web.config: <!--This is for Cubecart!!!--> <system.webServer> <httpErrors errorMode="Detailed"/> <rewrite> <rules> <rule name="rule 1R" stopProcessing="true"> <match url="^cubecart/(.*)\.html?$" /> <action type="Rewrite" url="/cubecart/index.php?seo_path={R:1}" appendQueryString="true" /> </rule> </rules> </rewrite> WINDOWS SERVER ONLY One other issue you might have on a Windows Server is that index.php isn’t recognized as a start page. You can easily create a page that loads automatically that transfers control over to index.php. So create a file called index.html consisting of the following code. If it’s not obvious, make sure to replace YourDomain with your website’s domain name and <cubecart folder> to the directory where you installed Cubecart. <html> <head> <title>[Your shopping cart name] Shopping Cart</title> <meta http-equiv="refresh" content="0; URL=http://www.YourDomain.com/<cubecart folder>/index.php"> <meta name="keywords" content="automatic redirection"> </head> <body> If your browser doesn't automatically go there within a few seconds, <a href="http://www.YourDomain.com/<cubecart folder /index.php">Click Here</a>. </body> </html> I’m sure there’s stuff I’ve forgotten. For example when debugging Cubecart it helps to refresh your browser after every change you implement. But I hope this is useful for someone else who wants to do the same integration.

OMG Success!!! Thank you both so much for all the help! This process was way more involved than it seems like it should be. I am going to post the steps necessary to make it work so that the next person can integrate Payeezy with Cubecart. But for the moment, I'll post the receipt

Update, I've had some success!!!! I removed the extension and re-installed it to get it to work. Now I am apparently getting through to the Gateway, but receive this Unable to proceed with payment We cannot proceed with payment because of technical difficulties. Please try again later Hosted Checkout Test Assistance Hosted Checkout test mode detected. Hosted Checkout uses security mechanisms to block repeated payment attempts. During integration with Hosted Checkout these may interfere with development and testing from time to time. The result is that you may see this page, independently of whether your shopping cart, or other integration server, is configured properly. To continue testing and developing your Hosted Checkout integration, you should try following this link to reset your session.

Here is the store: http://www.fatpacking.com/cubecart/index.php When I get to the final checkout, http://www.fatpacking.com/cubecart/index.php?_a=confirm and click the checkout button, I am brought to http://www.fatpacking.com/cubecart/index.php?_a=gateway to enter Credit Card info. Unfortunately, before I can do anything, the cart redirects me to test.authorize.net and I'm served the error. I'm pretty sure that the cart is caching this from a prior session when I was trying various things. I have found that any time I change either the cart set-up configuration or any of the .php code that I have to refresh (F5) each page for the changes to take place. If I could only refresh the gateway page, I think the error might go away although I don't know. I am attaching gateway.class.php. I actually messed around with it a bit so it's possible that I deleted or altered something important, but I don't think so. gateway.class.php

Oh no, I'm not sure what I did, but now it's trying to redirect me to test.authorize.net instead of demo.globalgatewaye4.firstdata.com. I don't even get to a credit card input screen. There is no reference to test.authorize.net anywhere in the cubecart / Authorize codebase. I do see authorize.net referred to in config.xml and language\module.definitions.xml however. There might be some weird caching thing going on that latched onto test.authorize.net while I was trying various things, but I've cleared the browser cache and refresh every page. Maybe you have some suggestion because this makes no sense at all.

I have a demo account. Is that insufficient?

This is great! With your help, I'm almost there. I am successfully transported to a gateway screen to fill in credit card info. When I fill it in and submit, I now receive this: The following errors were detected: The merchant login ID or password is invalid or the account is inactive. I'm not sure how the credentials are passed. It would seem like a bad idea to hard code them into the .php code. Any ideas?

Any other advice you can give me to get set up like you did? I have been through the same frustrating exercise of getting the above error and am at a loss as to how this all works.

Hi NJOHN, I cannot seem to log into Zendesk. Is there any chance you still read these forums and can send me the contents of that link? Thanks, Steve

OMG it works! But now I can't get it to fail the way it has been failing. I blame my browser cache. I discovered this when I noticed that when checking out, Cubecart stopped prompting me for customer info and populated the screen with my previous order's information. So now every time I make a change to the admin panel, I make sure to refresh the browser for each page of the Cubecart system. This seems to work and as I mentioned, I now cannot get it to fail. I really appreciate all your help. Can I send you some kind of gift card?

Good idea! I just checked and no other emails were generated according to the log. Maybe I've got some setting selected that prevents confirmation messages? It's just strange. I could understand if it never sent a message, but only when I mark a transaction completed is odd.

OK that's good info. I did the things you suggested. I've attached a screenshot of the setup. Once I make the purchase (but just before I go to the Gateway) I see the purchase in Customers > Orders > Orders Overview. I've attached both the order screen and the order screen. But still no email verification. However, once I go to the order itself and mark it as Complete, then the email is sent. And even then, it only gets sent to the customer. Am I missing something basic here? Many thanks, Steve

Hi Bsmither, thank you for taking the time to respond. I was finally able to get the system to generate an email by -- as you said -- changing the status on an order in the Admin > Orders page to Completed. However the only message generated went to the customer (me). The admin (also me with a different email address) receives nothing. Not when the order was placed, not when I change the status and not when the Gateway approves the transaction. I wonder if I just don't understand how the system is supposed to work. I just assume that once a cart is paid for that everyone (admin and customer) receives an email message. Is this assumption correct? Thanks, Steve

Note: I have installed Cubecart on a Windows Hosting Server, so that might be the problem, even though everything else about Cubecart seems to work. Anyway, I cannot for the life of me figure out how to get email confirmation of an order / purchase. I can successfully receive email using "Test (After Save)" from Dashboard > Settings > Advanced Settings When I complete my purchase (and pay via the Braintree / PayPal extension) I receive no email confirmation. However, my credit card is indeed getting charged through the Gateway each time I run a test. In Settings > Features > Misc > Order status for admin email notifications I have tried both Processing and Order Complete to no avail. I also check Force Order Completed Emails but nothing works. What am I missing? What event triggers sending an email? If it makes any difference, I do not sell anything that requires shipping, but I still want to receive notifications. Any help appreciated. Thanks, Steve