Re: update of apsona_functions.php to use mysqli
argh, tried a different browser and success. dummy.....
Re: update of apsona_functions.php to use mysqli
I too am having the problem with the blank page and the "loading" circle thingy'. I have Zen 1.51, godaddy servers and have my admin section set to secure in my configure file. My ShopAdmin used to work, and at some time in the past months it quit working. (I don't know if it's related or not, but my Authorize.net AIM module quit working also, but I was able to fix that by uploading the current v1.54 updated Authorize.net AIM files). I uploaded the apsona_functions.php from post #601. After I do that, the 'loading circle thingy' disappears, but page is still blank. Then, I believe that I tried every combination of the other recommended changes, including the changes at the top portion of the quote below. Actually, I don't know if I tried 'not' doing the changes at the top, and only doing the changes at the bottom (I assume there is a typo in that bottom code on post #608, but not post #592?). I see the changes are for v1.53, but I tried them all anyway. I also tried different browsers. I have looked through many pages of these posts, and I can't seem to find a fix. I could be missing something. Heck, I don't even know what version of mysql is being used. I know very little about the tech part of all of this. If anyone can give me some help, I would really appreciate it. If I missed something I will apologize in advance; I don't want to waste anyone's time because I didn't read something. I have 2000 products, and it's almost impossible to update products without spending a few days. Any help or advice would be greatly appreciated. Thanks!!
Quote:
Originally Posted by
delia
To recap all the issues I've run into and their solutions:
all zen cart versions
secure admin: if you are running admin in secure mode two changes must be made to the files provided by apsona
apsona_config.php - change url to
https://service.apsona.com
apsona_index.php - about line 42 change the url to
https://ajax.googleapis.com/ajax/lib.../jquery.min.js (adding in the s for https)
1.5.3
Use the apsona_functions.php file posted twice in this thread most recently in post
601
Change the admin configure file to hard code in the admin path as it used to be done. This is not difficult simply comment out this line in yourShopAdmin/includes/configure.php:
PHP Code:
define('DIR_WS_ADMIN', preg_replace('#^' . str_replace('-', '\-', zen_parse_url(HTTP_SERVER, '/path')) . '#', '', dirname($_SERVER['SCRIPT_NAME'])) . '/');
and replace it with this
PHP Code:
define('DIR_WS_ADMIN', '/your shop admin folder/');//steve apsona
Then replace this line
PHP Code:
define('DIR_WS_ADMIN', preg_replace('#^' . str_replace('-', '\-', zen_parse_url(HTTP_SERVER, '/path')) . '#', '', dirname($_SERVER['SCRIPT_NAME'])) . '/');
with this line
PHP Code:
define('DIR_WS_HTTPS_ADMIN', DIR_WS_ADMIN);//steve apsona
(Commenting out means placing // with a following space before the line.)
If you have done both of these for 1.5.3 and still get an error, try using an entirely new browser to check again. If nothing works your hosting company may be the problem. I've tested this on three different servers including my own which is highly secure with many closed ports etc. Apsona does not require anything special in the way of a hosting environment but there was mention earlier in this thread of possible mysql problems with a hosting company. This should work on every server.
wtashby, I was not getting anywhere until I made those changes to the admin configure and was getting both loading with that error message and a load of a non-working apsona page where no data was displayed between the three servers. Let me know if this works for you.
Re: update of apsona_functions.php to use mysqli
I use Apsona a lot and have not had that problem now. I was having a similar problem a while ago, and what was happening is that my login to my Zencart Admin site had timed out, and Apsona could no longer access it. I am not a programmer, so I really don't understand how all of this works, but try to login to your ZenCart Admin site and then immediately go to Apsona to do what you need to do. If you get the swirly thing again, log out of your admin site and relog in and try it again.
Additionally, I have 10,000 SKUs, and the admin site times out before I can update all of them, so I have to create 4 seperate batches. While I very much appreciate all of the work that the Zencart team is doing, sometimes the "improvements" that zencart makes to improve security can actually be detrimental to some of us.
Hope that works.
Re: update of apsona_functions.php to use mysqli
Thanks SPembletonk, but that didn't work. Still get the swirly thing. Anyone else with suggestions would be greatly appreciated. Is there another plugin that will allow me to edit my price, qty, etc via a spreadsheet on my computer and then upload?
Re: update of apsona_functions.php to use mysqli
I am updating and redesigning my ZenCart to 1.5.4 from 1.5.1 and I want to use Apsona Shop Admin on it. I don't use it often but I find it extremely effective/time saving when I do. I found that I need to recover my welcome packet and my password (normally I keep things like that religiously but for some reason I didn't or it might have been that someone was helping me out and they didn't keep it when they put on the Apsona). I have used their form and written to them three times and called them once and left a message (I don't think that anyone answers that phone but they do have an answering machine). Is there some other way to contact them, or are they impossible to get hold of and I would be better off registering as another e-mail address and just make sure to keep all of the information myself this time? Or would that just cause more problems than it solves and I would be better off doing something else? Thank you.
Re: update of apsona_functions.php to use mysqli
Please refer back to post 608 for instructions. Apsona does not provide support.
Re: update of apsona_functions.php to use mysqli
Delia, I believe you. Perhaps my problem was that I believed this on their site:
Get Apsona ShopAdmin to work for you today!http://apsona.com/img/satisfaction-100.jpg
- ShopAdmin is offered free of charge for as long as you want to use it.
- Free e-mail support
...their words, not mine. I will go back and read your post #608 carefully. If anyone else knows how to contact them, please say so. Thanks.
Re: update of apsona_functions.php to use mysqli
I have tried contacting apsona, with no luck. I have also followed all instructions that I can in this post, but nothing I have tried has worked. I believe our best bet is to start a new thread about this specific problem. ZenCart Forum folks will eventually get to the bottom of this, I'm sure. They always do. Not that they're not helping here, but perhaps with another thread, specific to this problem, more people will see it. This is the best Forum I have ever been a part of, so I'm positive we will get this fixed. If anyone reading this starts a new thread or finds a solution, please IM me and let me know where the thread is located. Thanks!
Re: update of apsona_functions.php to use mysqli
They have not updated their site I think since it went up. They aren't supporting it. period . the . end.
1 Attachment(s)
Re: Apsona ShopAdmin install does not work
Aspona was totally impressive in exporting my stuff from Zen Cart 1.39H and I know your probably tired of the questions, but if they would only come up with a working installation for 1.54 would not only be awesome, but worthy of a fee.. Great tool/Utility, change $20-30 per license and you might be surprised how many are willing to pay for something like this.
OK, off my soap box and back to reality.. Zen Cart 1.54, PHP 5.4, Godaddy Linux CPanel hosting.. Any chance of getting a working installation or at least one set of how to's all together?? All I get is "The server is not responding, Please check your network connection. Status Error." Going to blow away new 1.54 installation and start over, but really would love to have one set of working docs..
Thanks!!