Strange Database error

Permalink
Hi All, tried to install a package and got this error. there seems to be something worng with my database and not sure how to fix it. please could someone look below and see if the can help.

mysql error: [1048: Column 'btDisplayOrder' cannot be null] in EXECUTE("INSERT INTO BlockTypes(btID,btHandle,btName,btDescription,btActiveWhenAdded,btCopyWhenPropagate,btIncludeAll,btIsInternal,btInterfaceWidth,btInterfaceHeight,pkgID,btDisplayOrder) VALUES (NULL,'news_list','News List','List news pages based on area of the site.',1,0,0,0,'500','350','36',NULL)")

agentorange
 
adajad replied on at Permalink Reply
adajad
What version are you on?

Also, see my answer here as it might help you: http://www.concrete5.org/community/forums/customizing_c5/addons-ins...
agentorange replied on at Permalink Reply
agentorange
Hey thanks for your quick response,

I think I have made a real stuff up of this - and I should know better. I ahd at one stage tried to upload to 5.6.0.2 but got an error - then I downgraded.

so now what I have done is after reading the other post you directed me to, I tried to upgrade again.

first upgraded to 5.5.2.1 - all went as it should. as soon as I upgraded to 5.6.0.2 I got this error.

Warning: require_once(/home/barryhil/public_html/updates/concrete5.6.0.2/concrete/models/stack.php) [function.require-once]: failed to open stream: No such file or directory in /home/barryhil/public_html/updates/concrete5.6.0.2/concrete/core/libraries/loader.php on line 40

Fatal error: require_once() [function.require]: Failed opening required '/home/barryhil/public_html/updates/concrete5.6.0.2/concrete/models/stack.php' (include_path='/home/barryhil/public_html/libraries/3rdparty:/home/barryhil/public_html/updates/concrete5.6.0.2/concrete/libraries/3rdparty:.:/usr/lib/php:/usr/local/lib/php') in /home/barryhil/public_html/updates/concrete5.6.0.2/concrete/core/libraries/loader.php on line 40
adajad replied on at Permalink Reply
adajad
Try clearing your cache prior to running the upgrade script again (yourdomain.com/index.php/tools/upgrade) and let me know what happens.
adajad replied on at Permalink Best Answer Reply
adajad
It might also be you need to update all your add-ons before going to 5.6 from 5.5 (and you did upgrade from 5.4.2.2 to 5.5.2.1, right?). If you have an outdated package in a stack then that might throw errors when upgrading.
agentorange replied on at Permalink Reply
agentorange
it worked!!!! - I updated all packages that were out of date, cleared cache and voila I am now upgraded to 5.6.0.2.

thank you for all your help!!!!
adajad replied on at Permalink Reply
adajad
I'm glad you are up and running again. :D