An unexpected error occurred.
Permalink Browser Info Environment
Cant get the blog to work with this theme. Any advise?
mysqlt 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 ') and cvIsApproved = '1' and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and p1.c' at line 1] in EXECUTE("select p1.cID, pt.ctHandle from Pages p1 left join Pages p2 on (p1.cPointerID = p2.cID) left join PagePaths on (PagePaths.cID = p1.cID and PagePaths.ppIsCanonical = 1) left join PageSearchIndex psi on (psi.cID = if(p2.cID is null, p1.cID, p2.cID)) inner join CollectionVersions cv on (cv.cID = if(p2.cID is null, p1.cID, p2.cID) and cvID = (select cvID from CollectionVersions where cvIsApproved = 1 and cID = cv.cID)) left join PageTypes pt on pt.ctID = cv.ctID inner join Collections c on (c.cID = if(p2.cID is null, p1.cID, p2.cID)) left join CollectionSearchIndexAttributes on (CollectionSearchIndexAttributes.cID = if (p2.cID is null, p1.cID, p2.cID)) where 1=1 and cv.cID > 283 and (CHAR_LENGTH(cv.cvName) > 4 OR cv.cvName NOT REGEXP '^[0-9]') and cv.cvDatePublic <= '2014-10-19 21:17:16' and () and cvIsApproved = '1' and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and p1.cIsActive = '1' and (p1.cIsSystemPage = 0 or p2.cIsSystemPage = 0) ")
mysqlt 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 ') and cvIsApproved = '1' and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and p1.c' at line 1] in EXECUTE("select p1.cID, pt.ctHandle from Pages p1 left join Pages p2 on (p1.cPointerID = p2.cID) left join PagePaths on (PagePaths.cID = p1.cID and PagePaths.ppIsCanonical = 1) left join PageSearchIndex psi on (psi.cID = if(p2.cID is null, p1.cID, p2.cID)) inner join CollectionVersions cv on (cv.cID = if(p2.cID is null, p1.cID, p2.cID) and cvID = (select cvID from CollectionVersions where cvIsApproved = 1 and cID = cv.cID)) left join PageTypes pt on pt.ctID = cv.ctID inner join Collections c on (c.cID = if(p2.cID is null, p1.cID, p2.cID)) left join CollectionSearchIndexAttributes on (CollectionSearchIndexAttributes.cID = if (p2.cID is null, p1.cID, p2.cID)) where 1=1 and cv.cID > 283 and (CHAR_LENGTH(cv.cvName) > 4 OR cv.cvName NOT REGEXP '^[0-9]') and cv.cvDatePublic <= '2014-10-19 21:17:16' and () and cvIsApproved = '1' and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and p1.cIsActive = '1' and (p1.cIsSystemPage = 0 or p2.cIsSystemPage = 0) ")
| Type: | |
|---|---|
| Status: | In Progress |
Hi, can you please make sure that you have the "is_featured" boolean attribute in your Dashboard -> page & themes -> attributes area? If not, create one and make sure it is searchable.
ChadStrat
ChadStrat
Hi Chad.
I have no "is_featured" boolean attribute in your Dashboard.
Can you please give me a quick "how to" explanation?
George
I have no "is_featured" boolean attribute in your Dashboard.
Can you please give me a quick "how to" explanation?
George
Found a "How to" I`ll give it a go and get back to you. Thanks
Hi. Well I added the "is_featured" boolean attribute. And added it to the page. But I still get this. Please advice.
George
mysqlt 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 ') and cvIsApproved = '1' and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and p1.c' at line 1] in EXECUTE("select p1.cID, pt.ctHandle from Pages p1 left join Pages p2 on (p1.cPointerID = p2.cID) left join PagePaths on (PagePaths.cID = p1.cID and PagePaths.ppIsCanonical = 1) left join PageSearchIndex psi on (psi.cID = if(p2.cID is null, p1.cID, p2.cID)) inner join CollectionVersions cv on (cv.cID = if(p2.cID is null, p1.cID, p2.cID) and cvID = (select cvID from CollectionVersions where cvIsApproved = 1 and cID = cv.cID)) left join PageTypes pt on pt.ctID = cv.ctID inner join Collections c on (c.cID = if(p2.cID is null, p1.cID, p2.cID)) left join CollectionSearchIndexAttributes on (CollectionSearchIndexAttributes.cID = if (p2.cID is null, p1.cID, p2.cID)) where 1=1 and cv.cID > 272 and (CHAR_LENGTH(cv.cvName) > 4 OR cv.cvName NOT REGEXP '^[0-9]') and cv.cvDatePublic <= '2014-10-20 09:10:53' and () and cvIsApproved = '1' and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and p1.cIsActive = '1' and (p1.cIsSystemPage = 0 or p2.cIsSystemPage = 0) ")
George
mysqlt 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 ') and cvIsApproved = '1' and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and p1.c' at line 1] in EXECUTE("select p1.cID, pt.ctHandle from Pages p1 left join Pages p2 on (p1.cPointerID = p2.cID) left join PagePaths on (PagePaths.cID = p1.cID and PagePaths.ppIsCanonical = 1) left join PageSearchIndex psi on (psi.cID = if(p2.cID is null, p1.cID, p2.cID)) inner join CollectionVersions cv on (cv.cID = if(p2.cID is null, p1.cID, p2.cID) and cvID = (select cvID from CollectionVersions where cvIsApproved = 1 and cID = cv.cID)) left join PageTypes pt on pt.ctID = cv.ctID inner join Collections c on (c.cID = if(p2.cID is null, p1.cID, p2.cID)) left join CollectionSearchIndexAttributes on (CollectionSearchIndexAttributes.cID = if (p2.cID is null, p1.cID, p2.cID)) where 1=1 and cv.cID > 272 and (CHAR_LENGTH(cv.cvName) > 4 OR cv.cvName NOT REGEXP '^[0-9]') and cv.cvDatePublic <= '2014-10-20 09:10:53' and () and cvIsApproved = '1' and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and p1.cIsActive = '1' and (p1.cIsSystemPage = 0 or p2.cIsSystemPage = 0) ")
Hi.
Did all you suggested. But still get the same error. Any ides on what else I could try?
George
Did all you suggested. But still get the same error. Any ides on what else I could try?
George
Chad,
I'm getting this same (or similar error when trying to go to the List page in the dashboard (/dashboard/problog/list/). There was no "is_featured" attribute, but I added it like you mentioned and the error remains. Any idea for a fix?
Scanpers,
Were you able to get this resolved?
I'm getting this same (or similar error when trying to go to the List page in the dashboard (/dashboard/problog/list/). There was no "is_featured" attribute, but I added it like you mentioned and the error remains. Any idea for a fix?
mysqlt 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 ') and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and (p1.cIsSystemPage = 0 or p2' at line 1] in EXECUTE("select p1.cID, pt.ctHandle from Pages p1 left join Pages p2 on (p1.cPointerID = p2.cID) left join PagePaths on (PagePaths.cID = p1.cID and PagePaths.ppIsCanonical = 1) left join PageSearchIndex psi on (psi.cID = if(p2.cID is null, p1.cID, p2.cID)) inner join CollectionVersions cv on (cv.cID = if(p2.cID is null, p1.cID, p2.cID) and cvID = (select max(cvID) from CollectionVersions where cID = cv.cID)) left join PageTypes pt on pt.ctID = cv.ctID inner join Collections c on (c.cID = if(p2.cID is null, p1.cID, p2.cID)) left join CollectionSearchIndexAttributes on (CollectionSearchIndexAttributes.cID = if (p2.cID is null, p1.cID, p2.cID)) where 1=1 and (CHAR_LENGTH(cv.cvName) > 4 OR cv.cvName NOT REGEXP '^[0-9]') and () and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and (p1.cIsSystemPage = 0 or p2.cIsSystemPage = 0) order by cDateAdded desc limit 0,15 ")
Scanpers,
Were you able to get this resolved?
Can you check and make double sure that you have at least one page in your sitemap that has the "blog_section" attribute?
C
C
Ok that was it. Client had checked the blog section attribute but never published the page (only saved it)
Thanks!
Thanks!
Hi Chad.
We were able to work around the problem. Took us days to get it sorted. Not sure what the solution. Was in the end I it wasn't me working on it in the end. But I`ll ask my colleague if he can write a summary.
We were able to work around the problem. Took us days to get it sorted. Not sure what the solution. Was in the end I it wasn't me working on it in the end. But I`ll ask my colleague if he can write a summary.
Talked to my colleague he states that we also found out that the primary cause for this error was that there was no page with a blog_section attribute. a better error message than an sql error would be highly appreciated in this situation.
This is an auto responder to let you know that your support ticket has been forwarded to our entire support team at RadiantWeb!
Support tickets are reviewed Mondays thru Fridays 9am to 9pm & Saturdays 9am to 12pm EST.
A support team member will be following up with you as soon as possible.
Thank for supporting RadiantWeb Products!
RadiantWeb Support
http://goradiantweb.com