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)")
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)")
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
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
Try clearing your cache prior to running the upgrade script again (yourdomain.com/index.php/tools/upgrade) and let me know what happens.
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.
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!!!!
thank you for all your help!!!!
I'm glad you are up and running again. :D
Also, see my answer here as it might help you: http://www.concrete5.org/community/forums/customizing_c5/addons-ins...