Customizer CSS not restored

(@joeboemoe)

Just installed WP Clone on my website and on a local MAMP setup. Backing up went smoothly, the restore also ran thru, but with errors. Here’s an excerpt from the restore log:

Thursday, 27-Feb-2020 17:19:05 - mysql query failed. error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"#eme-td {
	padding: 5px 0px' at line 1 - query : "INSERT INTO wp_posts VALUES("61", "1", "2018-04-10 15:05:44", "2018-04-10 13:05:44", "#eme-td {
	padding: 5px 0px"
Thursday, 27-Feb-2020 17:19:05 - mysql query failed. error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'vertical-align: middle' at line 1 - query : "vertical-align: middle"
Thursday, 27-Feb-2020 17:19:05 - mysql query failed. error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '}
#eme-titel {font-weight: bold;}
.tooltip {
    position: relative' at line 1 - query : "}
#eme-titel {font-weight: bold;}
.tooltip {
    position: relative"
Thursday, 27-Feb-2020 17:19:05 - mysql query failed. error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'display: flex' at line 1 - query : "display: flex"
Thursday, 27-Feb-2020 17:19:05 - mysql query failed. error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'border-bottom: 0px dotted black' at line 1 - query : "border-bottom: 0px dotted black"
Thursday, 27-Feb-2020 17:19:05 - mysql query failed. error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '}
.tooltip .tooltiptext {
    visibility: hidden' at line 1 - query : "}
.tooltip .tooltiptext {
    visibility: hidden"
Thursday, 27-Feb-2020 17:19:05 - mysql query failed. error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'width: 500px' at line 1 - query : "width: 500px"
Thursday, 27-Feb-2020 17:19:05 - mysql query failed. error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'overflow: scroll' at line 1 - query : "overflow: scroll"
Thursday, 27-Feb-2020 17:19:05 - mysql query failed. error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'background-color: #555' at line 1 - query : "background-color: #555"
Thursday, 27-Feb-2020 17:19:05 - mysql query failed. error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'color: #fff' at line 1 - query : "color: #fff"

Problem is, that the CSS specified in the customizer of the theme is not restored!

Viewing 10 replies - 1 through 10 (of 10 total)

wpclonesupport
(@wpclonesupport)

6 years, 3 months ago

Hello @joeboemoe,

Thanks for reporting this. I will try to re-produce this and let you know if this is any error that we can fix.

Thank you.

Fred Schenk
(@faschenk)

6 years, 2 months ago

Same here. Just curious where to find the log @joeboemoe mentions.

Plus another issue:
I assume WP Clone makes a ‘real’ clone of the backed up site, but I also noticed that I have more plug ins at the restored site than at the backed up site. I did try some plug ins on the restored site, so it made sence, but I assumed they would be deleted by the restore.

Thread Starter joeboemoe
(@joeboemoe)

6 years, 2 months ago

you can find the log in wp-content/uploads/wp-clone on the restored site.

Fred Schenk
(@faschenk)

6 years, 2 months ago

Wow, loads of error messages about invalid SQL in the log-file. 35 times a ‘mysql query failed. error : 1064’ and once a ‘mysql query failed. error : 1065’.

The shortest message was:
– mysql query failed. error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘</span><span style=\”font-weight: 400;\”> $blog_posts = new WP_Query( $ar’ at line 1 – query : “</span><span style=\”font-weight: 400;\”> $blog_posts = new WP_Query( $args )”

Also very long onces with special characters in it, so it might be some sort of problem with code pages, differences between database settings and the proper syntax to prevent this from happening…

wpclonesupport
(@wpclonesupport)

6 years, 1 month ago

Hi @joeboemoe,
Thanks for reporting this. Can you please provide your css which caused that MySQL errors? It would be helpful to reproduce.

Thanks.

wpclonesupport
(@wpclonesupport)

6 years, 1 month ago

Hi @faschenk,
Can you please tell me which WP and DB version are you using?

There can be some compatibility issue I hope.

Thanks,

Thread Starter joeboemoe
(@joeboemoe)

6 years, 1 month ago

Here’s the CSS I was using:
`/* Blog Beiträge auf der Blog Page */
section.category-allgemein div.post-heading {
display: none;
}
.post-heading h2 {
display: none;
}
.blog-titel-mit-link a {
color: black;
}
div.post-divider {
margin: 15px;
}
.blog-pagination {
margin-top: 1.5rem;
}
/* a.older-posts {
visibility: hidden;
} */

/* Kommentare */
p.no-comments {
display: none;
}
.title-meta-comments, .title-meta-divider {
display: none;
}

/* events made easy */
#eme-td {
padding: 5px 0px;
vertical-align: middle;
}
#eme-titel {font-weight: bold;}
.tooltip {
position: relative;
display: flex;
border-bottom: 0px dotted black;
}
.tooltip .tooltiptext {
visibility: hidden;
width: 500px;
overflow: scroll;
background-color: #555;
color: #fff;
text-align: center;
border-radius: 0px;
padding: 0px 0;
position: fixed;
z-index: 1;
top: -10%;
left: 60%;
margin-left: -60px;
opacity: 0;
transition: opacity 0.3s;
}

Thread Starter joeboemoe
(@joeboemoe)

6 years, 1 month ago

And WP was 5.3 (now upgraded to 5.4)
DB is 5.6.19

wpclonesupport
(@wpclonesupport)

6 years, 1 month ago

Thanks @joeboemoe for providing those necessary info. I will try to reproduce this issue and will write about our findings or fix.

Thanks.

Fred Schenk
(@faschenk)

6 years, 1 month ago

I see s special character in the css of joeboemoe (in the comment line an “ä”). So thuis might be the same problem I mentioned…

Viewing 10 replies - 1 through 10 (of 10 total)

The topic ‘Customizer CSS not restored’ is closed to new replies.