Show Posts

Topics - webdevmerc

Pages: [1]
Is there a place someone can point me to for setting this up?  I looked though the docs and didn't find anything talking about this.  I also clicked through my admin, but didn't see where to put this.

New Features and improvements highlight
    Ability for guest customers to access order details

Been hammering away trying to figure out what is causing the auto webUI upgrade to fail and I'm still stuck.  I'm wondering if anyone had any ideas to try or ran into this as well...I tried changing my various php.ini settings to

mysql.connect_timeout = 14400;
default_socket_timeout = 14400;

but it didn't seem to fix it.  I'm wondering if it's some other timeout problem causing the error or max_packets or something else as it does work occasionally.

What's strange is if I try again or blow away my test environment, restore, try again, it would generally work the 2nd time I try the webui upload install on my test environment pretty consistently so it's not failing all the time (NEVER WORKS ON THE 1ST TRY THOUGH).  When I tried it in production, it never worked however, even on multiple attempts.

It's throwing off this error:

tail -f error.txt
2016-01-29 15:20:59 - warning:  AbanteCart core v.1.2.4 Error while sending QUERY packet. PID=43628 in <b>/home/webdevmerc/tst/core/database/amysqli.php</b> on line <b>70</b>
2016-01-29 15:20:59 - database error:  AbanteCart core v.1.2.4 Error: <br />SELECT dataset_id
                                                                                  FROM abc_datasets
                                                                                  WHERE dataset_name = 'install_upgrade_history'
                                                                                                AND dataset_key='admin' LIMIT 1 in <b>/home/webdevmerc/tst/core/database/amysqli.php</b> on line <b>105</b>

I CAN run the above sql statement in the database in PhpMyAdmin and get:

SELECT dataset_id
FROM abc_datasets
WHERE dataset_name = 'install_upgrade_history'
AND dataset_key = 'admin'


The structure of abc_datasets
#   Name      Type      Collation   Attributes   Null   Default   Extra   
1   dataset_id   int(11)                  No    None           AUTO_INCREMENT
2   dataset_name   varchar(255)   utf8_general_ci   No    None
3   dataset_key   varchar(255)   utf8_general_ci   Yes    

DATA of datasets
FROM `abc_datasets`
LIMIT 0 , 30

dataset_id    dataset_name          dataset_key
1       menu             storefront
2       menu             admin
3       menu             storefront_description
4       install_upgrade_history    admin
5       file_uploads          admin

I've considered changing all my database tables to use the ac_ prefix, but saw various unix files using the abc_ prefix so didn't go in that direction yet.

I just manually upgraded a test system (a few times) to 1.2.4 following these docs:

but notice that the login window for the admin page still shows AbanteCart Version 1.2.3 on the bottom.
Is this normal or did something not upgrade correctly in my process?

In my database, I notice in the dataset_values, I see a few references to 1.2.3 still.  (Namely, dataset_column_id = 22)

I also notice that the "Main Page Promo" that I used similar to the demo system not displaying correctly now.  Anyone else run into these issues?

Also tried an auto-update from the link in Abantecart and ended up with the "Page not found error" when it got back to the website after trying to process...

For some reason, I just started getting these in multiple sites...Anyone else notice this?

DEPRECATED: AbanteCart core v.1.2.3 mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in <b>/home/aplacefo/public_html/core/database/mysql.php</b> on line <b>46</b>

Running 1.2.3...Only minor changes to a few storefront view files...

Marketing / Experience with Facebook Pixel integrated with Abantecart?
« on: October 12, 2015, 01:20:53 PM »
I have read this message here:

but wanted to see if anyone else has put a Facebook Pixel on their site or a site they managed?

Also, if I wanted to put this pixel in multiple locations, which file or files would be best to put this code in so you can see where a user visits from Facebook?

I tried to put it in a simple html block and stick it within my layout (like the other tracking codes i have), but I think my site is a little wonky since I keep getting an error after I click submit that " The page you requested cannot be found!"

Thanks for any ideas you have!

I was just wondering if Paypal passes the Abantecart cart contents to Paypal after payment and if not, is there a way to pass it?

Built-in Features / New Embed feature in a facebook post?
« on: September 01, 2015, 11:33:19 PM »
Is it possible to put the new embed feature in a standard Facebook post/message?  I tried to post the embedded code, but it doesn't seem to interpret the script and just show all the code directly.  I'm guessing Facebook would try to block this to get sales themselves?

Just wondering if anyone is using Cloudflare or other CDNs to help speed up delivery of the AbanteCart store in general?  I applied the "free" one to my hosted account and didn't notice any speed difference at all when I ran a test from both pingdom and gtmetrix.

Is the internal caching enough?  I assume there will still be latency due to geography in general without Cloudflare...

I've noticed a strange thing where if you have an item which ships FREE for that one product, and add it with other items in your shopping cart, the free shipping for that item will make the whole cart free shipping.

This only seems to occur if the free shipping product is the last added item in the cart.  If you added another item, the shipping gets recalculated.

To test:
You can test this on the demo site.  The free product I made free ship is "Absolue Eye Precious Cells"

If you have multiple things in the cart, check the shipping cost on checkout.
Now, add the "Absolue Eye Precious Cells" item and check your cart.  The whole shipping is now free.
If you go and add another item, the shipping will again be recalculated correctly.

Thanks for testing if you get this.

My guess is the code isn't reapplying and exiting the free shipping section correctly.  If you can sort free items to top, that would solve it also.

Security / Data Encryption Manager Questions
« on: August 18, 2015, 07:40:06 PM »
I have read most of the forum messages that popped up in a search and the install documentation for Data Encryption Manager.  I also have it setup and encrypted my addresses, customers and orders tables...Everything is working so I don't have an issue with that part.

I was wondering, what permissions should things have on the web server?  A lot of docs have 777 and most files everywhere seem to be 755 as well.

Having lived as a Unix admin person in my past life, a lot of these files seem world readable.  Even the system/config.php has 755 permissions.  Is this normal and is this a security concern?  The config.php file has all the database login info there so with that, you can access all the information (I used to have root access everywhere so maybe this is normal?, I was never in web-development)...

Also, what is the best or safe security practice for what I should or where should I store my encryption keys?  Do I just leave them both in my keys folder on the server or delete the key pair on the server under my /path/to/keys/ folder?

Leave the .pub and delete the .prv?

I wasn't sure what is needed to allow the store to just work and I can run scheduled encryptions of customer data regularly I guess.

Thanks for any tips and info you can share.

Also, what is this line?
// Encryption key for protecting sensitive information. NOTE: Change of this key will cause a loss of all existing
 encrypted information!
define('ENCRYPTION_KEY', 'somekey');

If I pasted a shipper tracking url there, it doesn't seem to be clickable and just has the text from it.  Is there a way to format it so it is clickable for say, tracking info?

Thanks for any tips.

I was just wondering if there is a way to remove/hide the old provided shipping or billing address if someone is paying by Paypal?  If you checkout normally and fill all the buyer info, you get a payment option choice for all your enabled payment options (maybe ideas to hide Paypal here?).

If you click on the "Pay with Paypal box" prior to checkout, you go to Paypal right away and don't have to enter another address.

I am trying to eliminate the usual problems of multiple provided addresses in an order and where to ship something.

Thanks for any ideas/tips of where to look.

Payment Modules / Stripe Questions
« on: May 30, 2015, 07:20:30 PM »
Just wondering if other people have setup and used the Stripe Payment extension?  I have read all the docs I could find here I believe, but wasn't sure where I can get more info as to what's happening behind the scenes?

Also, I am not as clear as to how to force it to use the test environment vs. the live environment.  It doesn't seem to give me a choice or much fields for configuration.  This is good and bad I guess.  I set it up by just following the info in the guide, but I don't have a place to put the stripe keys in Abantecart as I see in some of the docs.  I just clicked on the "Connect with Stripe" button, entered my Stripe info and that was it.  In the Additional Settings tab, I only see disconnect Stripe and Connect with Stripe (live).

I can change my stripe account to be live or test and it seemed to funnel my test payment transaction to the test area (I assume this is how you actually control it)...but wasn't sure if Abantecart has a setting as well.

I will spend more time reading the stuff on Stripe's website, but just wanted to see if what I am seeing is normal.

I WAS able to send a test purchase using stripe payment and it all looked ok from my end and I see the payment on my stripe account in the test area, but wasn't sure if there was more to configure in Abantecart.  Also, om the Connected Apps section of Stripe, I see Abantecart ( as the connected app.  I assume this is normal?

Thanks for sharing any links to read more and general info.

Support / Default image sort order in products and sorting images
« on: May 08, 2015, 09:39:44 AM »
Did the recent upgrade remove the option to sort images in the product media tab?  I remember being able to do that in maybe version 1.1.8, but didn't see where to do it in 1.2.1.

Also, I was trying to figure out where the default sort order of images occurs in the DB and it seems to be based on the database entry in the resource_map table and when the row is initially added.  However, changing the sort entry in that table only changes the image order in the Media tab in the admin tool, but on a product and overall page, it still shows the old order.

I can unlink and relink the image and that works, but would take too long to process hundreds of images.

Does anyone have any pointers as to where to look?  I thought the image order was based on filename originally, but that doesn't seem to be the case.

Sorry if this has been asked before, I but I searched and didn't see anything and old topics show the old method working.

It doesn't let me post external links so maybe someone can see if this is even an issue or if something changed with the USPS or maybe their test server was down this morning...

Anyhow, I was having a tough time triggering the default_usps extension to fire to calculate shipping in my cart this morning...When I entered a zipcode and hit enter, it does it's thing, but nothing shipping from USPS shows up.  I entered my USPS Web Tools User ID and password, but nothing...

Anyhow, I was looking at the php code on the server and noticed that compared to my email, the URL for the USPS server that it's checking is hard coded as:
File I was looking at: ./extensions/default_usps/storefront/model/extension/default_usps.php

Line 127:
                                curl_setopt($curl, CURLOPT_, 'uspswebapiaddress/ShippingAPITest.dll?' . $request);

On the email after I created my USPS Webapi account, I get:

 ----- Forwarded Message -----
Subject: Important USPS Web Tool Registration Notice

***** Please DO NOT REPLY to this automated message.  Contact information is provided below. *****

Thank you for registering for the U. S. Postal Service's Web Tools Application Program Interfaces (APIs).  We are providing you with a Username to allow for access to the Production Servers, either through a third party ecommerce shipping software or through direct integration.

Your Username is myusername
Your Password is mypassword

The URLs you will use for the Production Servers are:

There is no "Test" in the address.

Was there another location where we can enter the USPS shipping apis website?

Wasn't sure if I'm looking in the wrong spot or not.

On version 1.1.9.  Once I changed the address without test, it ran off a calculation of the shipping.

Pages: [1]

Powered by SMFPacks Social Login Mod