Show Posts

Messages - webdevmerc

Pages: 1 [2] 3 4 ... 12
General Support / Re: why 3 things to enter verify a post?
« on: February 24, 2016, 12:16:33 PM »
On the plus side, I haven't been seeing a lot of spam bots lately...

I don't think a lot of the main core blocks are editable.  My system is the same...Things like category, customer, currency, etc...are system generated from data.  You can test this by creating your own block and see if you can edit that one.

Upgrade / Re: 1.2.4 -> 1.2.5 Upgrade
« on: February 01, 2016, 11:12:12 PM »
Maybe turn on (increase the logging level) full logging and see if any errors show anything then?

You can also try manual upgrade:,4407.msg19270.html#msg19270

I am waiting for confirmation if I can just copy over the version.php file before moving to this as my regular upgrade path...

I upgraded with the auto upgrade thing from 1.2.3 -> 1.2.4 and it worked without issues too.  Course, I never liked the whole 'automated' thing personally (don't know what's happening behind the scenes).

I upgraded from 1.2.4 -> 1.2.5 manually and it looks ok, the include option above (not in the docs) seems to do the database delete/update stuff for people who are wondering.

All that said, similar to the other manual process in the docs of just copying files, should we just copy over the version.php over from the latest Abantecart zip file so it doesn't alert us that we still need to upgrade?  None of the docs show how to update that file (and one reason I was hesitant to do it manually in case I miss some stuff that's going on behind the scenes).

Lastly, if someone can answer, is it safe to assume that if I unzip the full install ( and compare my live files to the files in this zip, as long as they are the same, I am good to go?

The auto package update thing hasn't worked well for me probably due to my changes and my hosting provider, but if this is pretty much key (matching the files up and just copying over version.php), then I will probably just do it this way moving forward...

Thanks for any clarification.

You can download the package from the google drive in the link here:

Maybe save the copy locally to your machine and install that upgrade extension directly instead.

General Support / Re: Cart Migration and Picture Questions
« on: January 30, 2016, 08:06:52 AM »
I am not part of admin or development staff (just a fellow user), but to upgrade to the latest version, you MUST upgrade by every point release.  This means to go from 1.2.2 to 1.2.5, you need to first go from 1.2.2 -> 1.2.3, then -> 1.2.4 then -> 1.2.5.

My advice has always been to setup a test environment first.  It is well worth the time and try your upgrade there first.  If you have made any changes at all to the system (which probably everyone has...), you will need to redo those changes.  My method is to just download the upgrade only package, then look through and compare all the new updated files with core and your existing files/changes...

After finding the differences, re-apply all those changes (it helps to have good documentation) again to the new updated files.

Depending on how much you have customized, you can decide if doing an upgrade is "easier" vs. just trying to export all the data and re-import to the new version.  (All that will depend on what skillsets you have and how comfortable you are with databases/abantecart/systems admin stuff).

I can suggest manual upgrade, that I have done many times.

1. Run upgrade.sql manually in PhpMyAdmin.
NOTE: Replace 'ac_' prefix with prefix that you have in your tables.

2. Include (if present in upgrade) upgrade.php file somewhere is admin controller.
Say in admin/controller/common/head.php in about line 30.

Load admin page once!

This will execute PHP update script and will do it's magic. :)

Remove the include line.

3. Replace all the files that are provided in the upgrade package over your files.

Do this on a backup/test copy of the store to prevent errors.

4. Clear cache files

Thanks for posting and sharing this method...I was planning to just copy the files over and "editing" the core/version.php file to make it match the latest version since that was the last piece not mentioned in the docs as to how to get your version numbers to match after the upgrade.

I'll try this with the include path and see how it goes.

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.

Support / Re: I can not add photos to the product! Help, please.
« on: January 26, 2016, 12:22:27 AM »
Do you have any popup blockers or anything?  I think I've seen those block the + thing before.  Also, try a different browser...

Support / Re: version 1.2.1 cannot update to 1.2.2 corrupted upgrade file
« on: January 24, 2016, 04:20:28 PM »
Hi WebDev - 

Check the prefix on your database -  it should be ac_

If you look at the sql update file,  the statements are for datasets ac_ 

I expect you know this,  but in case not,  you can use phpMyAdmin to easily change the prefix on your database

Let us know if this did the trick.


Hi Lee,

My database prefixes are all abc_ actually.  I think this was the default when you do a manual install.

The upgrade.sql individual script does point to using ac_, but I think the script automatically factors in databases using abc_ as running the exact same thing twice seems to work.  I don't know why though.

Also, using the auto network update worked as did when I did the select upgrade_only file going from 1.2.3 -> 1.2.4...

Is there a reason why the docs show abc_

I think we discussed this maybe a year back, trying to find that old post...

Support / Re: version 1.2.1 cannot update to 1.2.2 corrupted upgrade file
« on: January 24, 2016, 03:31:55 PM »
Hi devs, I see this error pop up every so often here, but seeing it myself just now...Maybe someone in the know can help debug it further with additional info.

I am trying to upgrade from 1.2.4 to 1.2.5.  I get the error below when I do the file upload select upgrade:
Extensions -> Install Extension -> Extension Upload
I select my file: "abantecart_1.2.5_upgrade_only.tar.gz"

Click <CONTINUE>, it checks it, then says I am upgrading to 1.2.5...<CLICK AGREE>

Errors out with like a file not found error.

On error log:
2016-01-24 11:43:56 - warning: AbanteCart core v.1.2.4 Error while sending QUERY packet. PID=520142 in <b>/home/webdevmerc/tst/core/database/amysqli.php</b> on line <b>70</b>
2016-01-24 11:43:56 - database error: AbanteCart core v.1.2.4 Error:
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>

Now, however, if I do the exact same thing again (same steps), it will work and update now...

Cause?  Is there a timeout or something I can tweak?

Support / Re: How to check profits?
« on: January 24, 2016, 10:23:32 AM »
I recommend AGAINST this personally...Assuming you use any real or even half hearted accounting program which takes into account your company/business (Quickbooks, etc...), and other various costs to run it, that would be a much much better solution to begin with.

Developing this at all would be a waste of developer resources when there are literally tons of paid/free solutions around already.  Those solutions can also take care of things way out of the scope of a single cart/web solution such as hiring people, other costs to acquire products to sell, Paypal fees, etc...

The link on our html homepage at to our cart brings up our layout with logo and links, but it does not access the categories or other content, nor do any of the links function. In addition, our admin page also cannot be located when I use the ADMIN_PATH ID in config.php.

I thought it was due to the php version discrepancy that I asked about in my previous post, but that is now version 5.3.0 in the index.php file and at the web host.

The cart was created in Nov 2013, so it is probably version 1.1.7. It functioned without problems until it vanished some time after Feb 2015. No changes were made by us to the cart since it was created, so some change at AbanteCart must have triggered the disappearance of the content and admin pages.

I could not find instructions how to upgrade from such an old version to the latest (1.2.5 I think), so could someone please tell me how to recover the cart and Admin pages and separately how to upgrade to the new version without losing the original formatting of the cart in the hope that would resolve everything?

Thank You.

From my experience, most likely something changed at your hosting provider, either more security or something like that causing things to break.  From everything I know, Abantecart can't (and doesn't) update itself or go to any existing sites to make changes so it's really not from Abantecart's end.

Lastly, who was the admin or webmaster of the site?  They should have the admin url...if you have host access either through linux or cpanel, you can look in this file (default location): public_html/system/config.php

for all the login info and admin url also.

Lastly, upgrading from 1.1.7 to 1.2.5 requires upgrading to every single point release like 1.1.8 -> 1.1.9 -> 1.2.0 -> ... -> 1.2.5

It would probably be a lot of work and maybe easier to just go straight to 1.2.5, backup and import the old data and move on...

As your site looks custom too, you may need to hire professional tech to fix it.

Good luck.

Opinions / Re: What Version are you using?
« on: January 20, 2016, 09:17:20 AM »
I am on 1.2.4...I tend to upgrade a little bit after the new version is released and still formulating the best way to do this quickly with my custom changes...

Manual upgrade doesn't work very good since the system doesn't recognize it when you have changed the files so I'd like the developers to make that work better (I might be the only one though who seems to want this)...

Thank you for all your time and helpful posts here.

New Features Discussion / Re: Pl fix the pricing issue ...
« on: January 10, 2016, 05:01:54 PM »
You need to take a chill pill... you don't even know how much money I donate to free freeware developers. And I don't have to prove anything to you.
I had this suggestion and I still have it. I posted it.
You don't like it close the post and move on.
Had I chosen to goto presta  I wouldn't have bothered to try to make the abate software better with suggestions.

You are the one who is being rude and not proactive.

Yes, you definitely don't have a to prove a thing to me and you are free and welcome to post your opinions and suggestions like everyone else is free to post theirs as well (including me).  I have posted mine and find your post on this topic and "whining" on this topic weak when someone else has already offered 3 suggestions to you.  If you don't like it, that's ok as well and you can keep posting the same thing if you want to include it in core.

I suppose like I said, I actually don't care that much either way what happens (enough to post of course) :) on what people do, but I just had to chime in that I do find your jab annoying and I don't want the developers to waste their time if it takes a lot of time to fix this and instead, work on other things.

As this is the world wide Internet, everyone is free to post their thoughts and opinions and you have lots of fine comments.  I just like to post mine every once in a while as well when I start to find some posters as "whiny" and "annoying" so I like say my piece too to at least let the devs know and extension developers know that I do support that paid model for people earning some money for stuff that solves things the developers don't want to or have time to fix.

Also, if this is put into core that'd be LESS incentive for people to offer extensions and the extension developers would have wasted their time.

All that said, this will be my last post on this topic as these debates can be endless and a waste of time for all.  I simply voiced my immediate thoughts when reading your message.  If another cart does it better I'm sure we'd try to improve Abantecart if we can and if not possible, move on as our business depends on it.

Pages: 1 [2] 3 4 ... 12

Powered by SMFPacks Social Login Mod