Good catch - I'll bet that's what happened.
Printable View
Good catch - I'll bet that's what happened.
Thanks MC12345678
Your assumption was correct and that issue is now sorted, thanks.
[QUOTE]ALTER TABLE customers ADD customers_secret varchar(64) NOT NULL default ' ';
As I ran the above query, it flagged up issues with the dates in the gdpr columns, which are all "0000-00-00 00:00:00". I have tried to use the query below in @Install SQL Patches and it just says "an error has occurred, etc."
If I run this query in the console in PHPmyadmin, it does not like "SET"? It saysQuote:
ALTER TABLE zen_customers ALTER gdpr_accept_date SET DEFAULT '0001-01-01 00:00:00';
Looked at the posts you flagged up and tried several different combinations of coding, but no luck yet!!Quote:
X A new statement was found, but no delimiter between it and the previous one. (near SET)
also, if i update a product, the screen goes blank after pressing "Update" and I get this warning
This is line 27Quote:
[01-Dec-2021 08:49:06 Europe/London] Request URI: /admin1/index.php?cmd=product&cPath=29&pID=174&action=new_product_preview, IP address: 86.168.218.100
#1 header() called at [/admin1/includes/init_includes/init_templates.php:27]
#2 require_once(/admin1/includes/init_includes/init_templates.php) called at [/includes/autoload_func.php:37]
#3 require(/includes/autoload_func.php) called at [/admin1/includes/application_top.php:37]
#4 require(/admin1/includes/application_top.php) called at [/admin1/product.php:8]
#5 require(/admin1/product.php) called at [/admin1/index.php:11]
--> PHP Warning: Cannot modify header information - headers already sent by (output started at /admin1/includes/languages/english/product.php:93) in /admin1/includes/init_includes/init_templates.php on line 27.
Quote:
header("Content-Type: text/html; charset=" . CHARSET);
You have to fix gdpr_accept_date but you need a different set of steps.
UPDATE customers SET gdpr_accept_date = '0001-01-01 00:00:00' WHERE gdpr_accept_date < '0001-01-01' and gdpr_accept_date is not null;
ALTER TABLE customers MODIFY COLUMN gdpr_accept_date datetime NOT NULL default '0001-01-01 00:00:00';
Thanks SWGUY
All that updated and now getting a lot less Debug log files.
Still getting the blank screen after modify/adding products and getting this
Any ideas?Quote:
[01-Dec-2021 13:34:54 Europe/London] Request URI: /admin1/index.php?cmd=product&cPath=25&pID=195&action=update_product, IP address: 86.168.218.100
#1 header() called at [/admin1/includes/init_includes/init_templates.php:27]
#2 require_once(/admin1/includes/init_includes/init_templates.php) called at [/includes/autoload_func.php:37]
#3 require(/includes/autoload_func.php) called at [/admin1/includes/application_top.php:37]
#4 require(/admin1/includes/application_top.php) called at [/admin1/product.php:8]
#5 require(/admin1/product.php) called at [/admin1/index.php:11]
--> PHP Warning: Cannot modify header information - headers already sent by (output started at /admin1/includes/languages/english/product.php:93) in /admin1/includes/init_includes/init_templates.php on line 27.
[01-Dec-2021 13:34:54 Europe/London] Request URI: /admin1/index.php?cmd=product&cPath=25&pID=195&action=update_product, IP address: 86.168.218.100
#1 header() called at [/admin1/includes/functions/general.php:19]
#2 zen_redirect() called at [/admin1/includes/modules/update_product.php:130]
#3 require(/admin1/includes/modules/update_product.php) called at [/admin1/product.php:33]
#4 require(/admin1/product.php) called at [/admin1/index.php:11]
--> PHP Warning: Cannot modify header information - headers already sent by (output started at /admin1/includes/languages/english/product.php:93) in /admin1/includes/functions/general.php on line 19.
that's just a warning - it doesn't cause a blank screen. You'll have to find the issue that's causing a blank screen.
Look in /admin1/includes/languages/english/product.php and see at the bottom if you have text after the closing ?>
If so, remove that text (you don't even need the closing ?> but if it's there it must be the last thing in the file.
Thanks swguy
Its fixed, but I have no idea what the problem was??? There was no text after the ?> I deleted some text above that related to Youtube plugin that has stopped work since uggrade, but that made no difference. So I deleted the ?> and then retyped it back in and it now works properly.
Any idea why some of my descriptions are a box within a box?? Whilst most are just a single box?
See here https://www.lrbits.co.uk/index.php?m...roducts_id=130
Cheers Mick
Please create a new post to ask about the boxes - I think this post has been completed, and different people will answer your next questions.
I actually like your box within a box... looks funky and modern :-)Quote:
Originally Posted by Jabbawocky