You have An Error In Your SQL Syntax
paolo
I have checked all prerequisite to upgrade to pb 5.x and all is corresponding. When start upgrade, at the end the site is in error with this message.
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 ')) AND (a.publish_upIS NULL ORa.publish_up='0000-00-00 00:00:00' OR' at line 6
can help me to resolve? I have made this upgrade in a test web site that I can create an admin access for you. this is the actual situation now: https://www.gemini31.it/31/32/31/
next step form me is to upgrade to joomla 5.x
Atick Eashrak Shuvo
Accepted AnswerPlease check now. I have updated the SP page builder to the latest 5.4.2. Everything seems fine to me.
paolo
Accepted Answermmm... not all is ok. you can verify the original site in production at https://www.gemini31.it and compare with the test site. some pb add on not work fine, and impagination is corrupt in some location.
for example in home page, you can see that in secod line, in article titled "20 anni di sole...." the previw in corrupt. ther is two image below the litle previw extrat they don't have to see.
and this problem is random in varius web site location.
https://postimg.cc/gallery/63R2bBJ in image 1 you can see the error tha I see. in image 2 same error, but not consider the miniature error... thi is real missing image.
Atick Eashrak Shuvo
Accepted AnswerThe issue with the missing images is not related to the page builder. The images used in those blog posts are no longer available, which is why they are not appearing. prnt.sc/b8Oql1r_mN5l prnt.sc/77Um8AtCfoYN
paolo
Accepted Answercorrect, but the problem is related to image 1, the previw in corrupt. ther is two image below the litle previw extrat they don't have to see.
I told you that in image 2 same error, but not consider the miniature error, or image errerror... this is real missing image that i know. the problem is in image 1.
paolo
Accepted Answerok, where you correct this problem? But I see that in some other page still same problem. see this image: https://i.postimg.cc/TPHpgDfV/3.jpg that which refers to this web page: https://www.gemini31.it/31/32/31/index.php/box-enduro/tricker-250-yamaha
paolo
Accepted Answerok, can you explain to me how to resolve this problem in autonomy? this because the link that you use, is a test web site, now i must update the production web site, and correct eventually problem tha appear.
Atick Eashrak Shuvo
Accepted AnswerI have changed the Introtext characters limit from the addon settings prnt.sc/GQYYKeJOE5qW . And used this custom css in your Template Options -> Custom Code -> Custom CSS
.sppb-addon-article .sppb-article-info-wrap .sppb-article-introtext img{
display: none;
}paolo
Accepted Answerok, I thought this was the problem, but I wasn't exactly sure where to go to fix it. now i can try to update joomla from version 4 to version 5.
timwoodrum
Accepted AnswerHaving the same problem "syntax error, unexpected token "\"" Trying to get the Hope Template up. www.godsgloryfwb.com.