Forums

Add pagelist error in 5.3

Permalink
Trying to add a basic page list block to my site after upgrading from 5.2.1 to 5.3.

When I click to add the block I get the following:

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1048: Column 'paginate' cannot be null] in EXECUTE("INSERT INTO btPageList (bID,num,orderBy,cParentID,cThis,ctID,rss,rssTitle,rssDescription,truncateSummaries,displayFeaturedOnly,truncateChars,paginate) VALUES (222,0,'display_asc',0,0,0,0,'','',1,0,128,NULL)") ' in C:\apache\htdocs\concrete\libraries\3rdparty\adodb\adodb-exceptions.inc.php:78 Stack trace: #0 C:\apache\htdocs\concrete\libraries\3rdparty\adodb\adodb.inc.php(1042): adodb_throw('mysql', 'EXECUTE', 1048, 'Column 'paginat...', 'INSERT INTO btP...', false, Object(ADODB_mysql)) #1 C:\apache\htdocs\concrete\libraries\3rdparty\adodb\adodb.inc.php(1017): ADOConnection->_Execute('INSERT INTO btP...', false) #2 C:\apache\htdocs\concrete\libraries\3rdparty\adodb\adodb-lib.inc.php(212): ADOConnection->Execute('INSERT INTO btP...') #3 C:\apache\htdocs\concrete\libraries\3rdparty\adodb\adodb.inc.php(1663): _adodb_replace(Object(ADODB_mysql), 'btPageList', Array, Array, false, false) #4 C:\apache in C:\apache\htdocs\concrete\libraries\3rdparty\adodb\adodb-exceptions.inc.php on line 78

I haven't run into this previously. Any ideas?

Thanks for your help.
chunksmurray
 
chunksmurray replied on at Permalink Reply
chunksmurray
OK so after a bit of trial and error I've discovered that this error does not appear if I select the 'Pagination' option.

Leaving it unchecked, no matter the size of the page list, produces an error.

Strangely, once I have saved the list with the 'Pagination' option selected, I then can't go back in un-select it.

So it works, just have to select 'Pagination'.
TammyM replied on at Permalink Reply
TammyM
I am having a similar error since updating from 5.4.2.1 to 5.5.1. However, mine isn't resolving with selecting Pagination. Anyone else?

(Also, the error message doesn't let me select/copy/paste the text & it's really long, in a small window, & not screen-shot-able.)
TammyM replied on at Permalink Reply
TammyM
Figured it out after noticing the older dashboard was also showing up. We moved everything to a VPS after dreamhost hacking incident and looks like the config file was accidentally overwritten with an older version when changing the IP address to the domain name.

found this article:http://www.concrete5.org/documentation/installation/upgrading_concr...

and re-ran the script found at:http://www.crystalsinger.com//index.php/tools/required/upgrade...

need to remove that upgrade file for security reasons, but it looks like that script cleaned up the mistake
poshpiglet replied on at Permalink Reply
poshpiglet
hey i am having the same problem....but i dont understand what you did.... i am new to this and i am a bit confused....so pls can you tell me step by step what to do, because i am stuck!!!
TammyM replied on at Permalink Reply
TammyM
I can try. I'm more of a designer than a developer, so this stuff is not my strong-suit. I kind of hack my way through things and then get developer help when I need it.

So, when you log in, do you notice if it's the old dashboard or the new dashboard? (Do you know which version you are running?)
poshpiglet replied on at Permalink Reply
poshpiglet
Just upgrade to the latest. Version...I am also a design! So this is really not my field but I m trying to lern quick...my problem is 2 things I can't redirect images to another page when I set it to link to another page it gives me a page not. Found screen....also I can't edit certain pages in my websit it's very annoying cos I can't put any new work up.



Thank you for replying x
poshpiglet replied on at Permalink Reply
poshpiglet
On the home page it's the new dashboard but the older pages have no eit button so I can't even edit,
poshpiglet replied on at Permalink Reply
poshpiglet
My spelling is super bad because I am very tired it's 4.50 am I have ben trying to figure this out all day....so pls excuse the grammar etc


Becksx
TammyM replied on at Permalink Reply
TammyM
No worries, it's been a long week for me, too. Can you post a link to your site, or a screenshot of the error(s)?
TammyM replied on at Permalink Reply
TammyM
What version were you running before you upgraded? Also, did the site work fine before you upgraded?

"To upgrade your Concrete5 installation from a previous version, do the following (**note, if you are running a version before: 5.3.2 you must first upgrade to 5.3.2 and only then will automatic updates behave. **)."
poshpiglet replied on at Permalink Reply
poshpiglet
I am using the last version so

My site iswww.www.poshpigletdesigns.co.uk...


If you go to galleries
The logos
Then on the sideshow on the top of the page try clicking learn more... It will direct you to a page not found site....


Thanks x
TammyM replied on at Permalink Reply
TammyM
It could be that the url line is missing the index.php...

Looks like it should be:
http://www.poshpigletdesigns.co.uk/index.php/...whatever-page/...

but it currently is:
http://www.poshpigletdesigns.co.uk/...whatever-page/...
poshpiglet replied on at Permalink Reply
poshpiglet
Still the same problem this was all fine before the update! Now I can't link any images to the older pages, how do I get those index phps back?
TammyM replied on at Permalink Reply
TammyM
Are those image links created within a slideshow plugin (aka add-on)? It could be that the add-on isn't 5.5.1 version ready. You may have to revert back to an older version that's compatible with the add-on, or upgrade the add-on, if it an upgrade is available. Check the add-on page in the marketplace, it might say, if not, you might send a message to the developer to see if/when a compatible version is expected.