Page List Error
Permalink
I am running version 5.6.0.2. When I attempt to add this add-on I am getting the following error message
An unexpected error occurred. mysql error: [1048: Column 'includeAllDescendents' cannot be null] in EXECUTE("INSERT INTO btPageList (bID,num,orderBy,cParentID,cThis,paginate,displayAliases,ctID,rss,rssTitle,rssDescription,truncateSummaries,displayFeaturedOnly,truncateChars,includeAllDescendents) VALUES (1005,0,'display_asc',191,1,0,1,0,0,'','',0,0,0,NULL)") < Back to Home
Any ideas as to why this is happening?
An unexpected error occurred. mysql error: [1048: Column 'includeAllDescendents' cannot be null] in EXECUTE("INSERT INTO btPageList (bID,num,orderBy,cParentID,cThis,paginate,displayAliases,ctID,rss,rssTitle,rssDescription,truncateSummaries,displayFeaturedOnly,truncateChars,includeAllDescendents) VALUES (1005,0,'display_asc',191,1,0,1,0,0,'','',0,0,0,NULL)") < Back to Home
Any ideas as to why this is happening?
Got identical error, any fixes yet?
You should try by editing in database and make the field "includeAllDescendents" in table "btPageList" , make NULL to yes and try it.
Hope that helps
Hope that helps
I got the same error too. Does somebody has a solution yet?
Savan, I tried to do like you said, but I can't fing the table "btPageList", and I can't find "include AllDescendents" in any file. Could you maybe give something of a step by step explanation?
I would like to fix this.
Savan, I tried to do like you said, but I can't fing the table "btPageList", and I can't find "include AllDescendents" in any file. Could you maybe give something of a step by step explanation?
I would like to fix this.
Hello
Sorry for late reply, I am not sure you have sorted out this issue or not but this table should be there see the attachment for it.
And this is not to be in any file but this is in DATABASE.
Let me know still if any issue.
Sorry for late reply, I am not sure you have sorted out this issue or not but this table should be there see the attachment for it.
And this is not to be in any file but this is in DATABASE.
Let me know still if any issue.
Yes, sorted it out two days ago thanks to c5mix. Just refreshed the database and now it works.
Hello CapntainSlow,
Can you let me know how to "refresh the database"? Is this something you ran via Concrete5 or something you did via a mysql command prompt (or other tool like phpMyAdmin)?
I have the exact same issue but don't have direct access to the database at the moment.
Thanks in advance!
Cheers,
Alex
Can you let me know how to "refresh the database"? Is this something you ran via Concrete5 or something you did via a mysql command prompt (or other tool like phpMyAdmin)?
I have the exact same issue but don't have direct access to the database at the moment.
Thanks in advance!
Cheers,
Alex
FYI: I managed to get access to the database and changed the "includeAllDescendents" column to allow NULLs and it seems to work now.
Cheers,
Alex
Cheers,
Alex
"An unexpected error occurred. mysql error: [1048: Column 'cParentID' cannot be null] in EXECUTE("INSERT INTO btPageList (bID,num,orderBy,cParentID,cThis,paginate,displayAliases,ctID,rss,rssTitle,rssDescription,truncateSummaries,displayFeaturedOnly,truncateChars,includeAllDescendents) VALUES (1030,0,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,0,0,0,NULL)") < Back to Home"
Did you ever fix it?