Aah, thank you - I hadn't seen the second page of this discussion and your last post.
OK, so I tried that. For example:
SELECT * FROM `zen_address_book` WHERE `entry_street_address` <>...
Type: Posts; User: karma-lab
Aah, thank you - I hadn't seen the second page of this discussion and your last post.
OK, so I tried that. For example:
SELECT * FROM `zen_address_book` WHERE `entry_street_address` <>...
Thanks, I am trying the SQL query. It looks like this:
SELECT * FROM `zen_address_book` WHERE `entry_street_address` NOT REGEXP '[A-Za-z0-9.,- ]'
I am getting:
Error
Thanks, but what do you mean by "tables that have potentially invalid data."? How do I know which tables potentially have invalid data?
Thanks, it seems that both of you (lat9, mc12345678) have been involved in the latest releases of this converter. Is there any more info you can give me about the comment "CAUTION: If your database...
Thanks!
My configure.php has:
define('DB_CHARSET', 'utf8'); // 'utf8' or 'latin1' are most common
While using phpMyAdmin to look at the database shows:
I would guess that the answer to "Has it been fully set to handle utf8mb4 type entries?" is NO.
The store/database has been around for many many years. I'm not sure what was the original first...
I am running 1.56c.
Occasionally I have customers in Russia that create new accounts and type in their information in Cyrillic. What I end up seeing on my end is a bunch of question marks, i.e....
DrByte, first let me say I have great respect for what you do here, so thank you for the clarifications. If I may...
Actually, that's a different question, about the manual MySQL update step...
So I'm trying to upgrade from 1.56a to 1.56c (on a backup first, of course).
I like ZenCart and appreciate the hard work that goes into it, but one of the only real negatives is how difficult it...
Got it, thanks. Database Engine: MySQL 5.6.44
(I always forget about this page in the ZenCart admin settings...)
I don't - shared hosting environment.
But where does it say in the release announcement that this MySQL patch should be performed no matter what regardless of version of MySQL? It doesn't. It...
Thank you for taking the time to reply. I'm still confused.
If I do a phpinfo() on my site, I am told that I have:
mysqli
mysqlnd 5.0.12-dev - 20150407
I am assuming this is my MySQL...
It says in the release notes for 1.56c:
"IS THERE A DATABASE UPGRADE STEP FROM v156 to v156c?
That depends: yes, there is one MANUAL step you must do yourself (and if you didn't do it in 156...
I found one other undefined constant that was causing "Use of undefined constant PAYPAL_DEV_MODE" errors.
I have incorporated all the fixes into a new file, and tested it on 1.56a. No more issues...
Related to the PEAR_LOG_INFO warning:
I checked back into my older 1.38 store backup, and the file includes/modules/payment/paypal/paypal_curl.php contains these lines, among others:
/**...
THANK YOU!!! My website hosting company upgraded to php 7.2.17 last night, and today I woke up to find this exact problem - my paypal modules disappeared from the admin Payment Modules page...
Thanks. How true. ;)
But might I suggest that you include the directions for performing this test in the further information that comes up when you click on this warning?
Something like:
...
Thanks. I meant to say I was upgrading 155f to 156a.
I went ahead and did the upgrade and it completed successfully.
By running the test, I am indeed getting a 403 error page. So it would seem...
Before attempting to upgrade my existing 155a store to 156, I have a demo version of the default 155a installed, that I am trying the upgrade process on.
When running the zc_install script, it is...
Thanks. Is there anything special in ZenCart I need to do to enable php errors to the screen? I have display_errors = on in my .ini file, but I'm not seeing anything...yet...
I've seen some threads that say "yes" - however, the reason I'm asking is:
I am running php 5.6. I recently (maybe 6 months ago) completely upgraded from 1.3.8 to 1.55f in order to fix the paypal...
I found the answer here in this thread:
https://www.zen-cart.com/showthread.php?156873-Not-a-bug-Can-t-override-pages-specials-main_template_vars-php
main_page=specials
It appears that some of the html formatting for the Specials page (for each individual product displayed) is done by this file:
...
I see. Thanks for explaining this. Now I know that I should not be putting them back in to my edited templates!
I don't know that it matters, since v1.5.5f seems to work, but I have noticed missing closing php tags in several files while customizing my templates.
For example, take a look at...
Thanks!
I have SSL enabled on my store (v1.5.5f).
It goes to https during checkout, login etc.
I would like to have all store pages go to https, not just login or checkout.
Is it possible? In...
I am updating from 1.39a to 1.55f. I am now at the step of reinstalling and configuring payment modules.
I Use "PayPal Payflow Pro - Gateway". Does anyone know if this module should be OK to...
I'm in the first steps of upgrading my store from 138a to 155f. I have a fresh copy of 155f installed as a demo to take a look at.
In v138, I am using a module named:
"PayPal Payflow Pro -...
Thanks, but that doesn't really answer my question.
I've already verified that PHP and mySQL versions etc. are compatible. That's not an issue.
I AM reading the instructions for rebuild vs....
I am going to attempt to upgrade from 1.38a to the latest 1.55f, keeping my products, templates and data.
I have been consulting the document "How do I rebuild my site on the new version, instead...
With all due respect, I'd like to point out that my first post was addressed to the original poster (another user) - not you or necessarily any ZenCart employees. But I do thank you for joining the...
But it will be back to working fine (for awhile) once I fix that issue. As I have done for other issues. Beats a solid week or more of work.
But I get it - upgrade, upgrade, upgrade.
I have...
1. PHP Version: 5.6.28 (Zend: 2.6.0). Is that old/obsolete? My ISP updates it every so often. Maybe the "absolutely incompatible" stuff I'm not using. :)
2. Here's the thing. I run a one-person...
ferid,
Did you ever resolve this? I am also using 138a and do not have the resources to upgrade at this time. I also received the similar message from paypal, although they obviously pushed back the...
I understand how a forum works. I moderate my own, and have 17,000+ posts on it. So you're free to give any answer you want. But to say your answer was "the proper answer" when it completely ignored...
Well, I *did* manually apply all the 1.3.8a security patch updates that were recommended back in the day, for what it's worth. PCI patch, admin patch, config patch, security updates etc. I'm not...
Well - your replies weren't helpful, and had nothing to do with the question. I just need to fix the issue; not drop a week of time on an upgrade right now. Nothing personal.
Thanks lat9, I'll...
Thanks for your advice, if I ever have an entire free week to spend on upgrading my heavily customized installation (because I know that's what it will end up taking), I'd love to do it. But that...
I've tried changing the default sort order in Configuration > Featured listing. It seems to have no effect whatsoever, regardless of how it is set. There is no change in the display order. I tried...
Thanks! Curious that this thread is from 2009, yet this is the same thing that PayPal is currently alerting me about. It's like they never did it back in 2009, six years ago...
Yeah, I agree -...
I've been receiving emails recently about upcoming Payflow integration changes. Is there a thread here about this already?
Anyway, today it says:
--------------------------
We want to let you...
I recently also started receiving some of these kinds of spam emails to my customer service email. What I'd like to know, is some of you mention getting the IP address and blocking it - I know how to...
No, it doesn't make sense. If you have 10 orders you received, and you just shipped them all out, it would make sense to be able to process all 10 with one click, not have to manually do each one...
When people order something from the store, the orders are set to "pending[1]" by default. Is there some way to change a whole bunch of orders at the same time? Do you actually have to click on each...
Thanks! I implemented it and it seems to work. :)
It really wasn't necessary to quote the entire huge code dump just to ask a one-line question. ;)
At the time I posted this, I was using 1.3.8a. With a custom theme. As explained. So I cannot...
Yes it's possible.
In the Coupon Admin area, once you have created a coupon, it shows up in the list. You click on the "i" icon (info), and to the right side, there is the area that shows info...
The analogy is not entirely correct. It's more like:
There has been a fix for electric windows that relates to them staying down. However, I always keep them up all the way and never ever use...
Sorry for the late response. Yes, I had independently discovered that, but it seems sort of counter-intuitive to me. Is it actually supposed to work that way, or is that sort of a workaround for...