Need help understanding a repeating msql error in c5 log
Permalink
When I look at my c5 log via the dashboard I see the below error. It seems to show up pretty often in the log, and has been happening pretty much since I re installed c5. Any help figuring out what it all means would be greatly appreciated. The site is apoprecords.com
---------------------------------------------------
Exception Occurred: mysql error: [1048: Column 'cID' cannot be null] in EXECUTE("INSERT INTO Areas (cID,arHandle,arIsGlobal) VALUES (NULL,'Site Name','1')")
#0 /home/apoprecords/apoprecords.com/updates/concrete5.5.2/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1048, 'Column 'cID' ca...', 'INSERT INTO Are...', false, Object(ADODB_mysql))
#1 /home/apoprecords/apoprecords.com/updates/concrete5.5.2/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('INSERT INTO Are...', false)
#2 /home/apoprecords/apoprecords.com/updates/concrete5.5.2/concrete/libraries/3rdparty/adodb/adodb-lib.inc.php(212): ADOConnection->Execute('INSERT INTO Are...')
#3 /home/apoprecords/apoprecords.com/updates/concrete5.5.2/concrete/libraries/3rdparty/adodb/adodb.inc.php(1658): _adodb_replace(Object(ADODB_mysql), 'Areas', Array, Array, true, false)
#4 /home/apoprecords/apoprecords.com/updates/concrete5.5.2/concrete/models/area.php(174): ADOConnection->Replace('Areas', Array, Array, true)
#5 /home/apoprecords/apoprecords.com/updates/concrete5.5.2/concrete/models/global_area.php(11): Area->getOrCreate(Object(Page), 'Site Name', 1)
#6 /home/apoprecords/apoprecords.com/packages/theme_silence/themes/silence/elements/header.php(53): GlobalArea->display(Object(Page))
#7 /home/apoprecords/apoprecords.com/updates/concrete5.5.2/concrete/libraries/view.php(345): include('/home/apoprecor...')
#8 /home/apoprecords/apoprecords.com/packages/theme_silence/themes/silence/full.php(2): View->inc('elements/header...')
#9 /home/apoprecords/apoprecords.com/updates/concrete5.5.2/concrete/libraries/view.php(849): include('/home/apoprecor...')
#10 /home/apoprecords/apoprecords.com/updates/concrete5.5.2/concrete/dispatcher.php(188): View->render('/page_not_found')
#11 /home/apoprecords/apoprecords.com/concrete/startup/updated_core_check.php(6): require('/home/apoprecor...')
#12 /home/apoprecords/apoprecords.com/concrete/dispatcher.php(14): require('/home/apoprecor...')
#13 /home/apoprecords/apoprecords.com/index.php(2): require('/home/apoprecor...')
#14 {main}
-------------------------------------------------------
---------------------------------------------------
Exception Occurred: mysql error: [1048: Column 'cID' cannot be null] in EXECUTE("INSERT INTO Areas (cID,arHandle,arIsGlobal) VALUES (NULL,'Site Name','1')")
#0 /home/apoprecords/apoprecords.com/updates/concrete5.5.2/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1048, 'Column 'cID' ca...', 'INSERT INTO Are...', false, Object(ADODB_mysql))
#1 /home/apoprecords/apoprecords.com/updates/concrete5.5.2/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('INSERT INTO Are...', false)
#2 /home/apoprecords/apoprecords.com/updates/concrete5.5.2/concrete/libraries/3rdparty/adodb/adodb-lib.inc.php(212): ADOConnection->Execute('INSERT INTO Are...')
#3 /home/apoprecords/apoprecords.com/updates/concrete5.5.2/concrete/libraries/3rdparty/adodb/adodb.inc.php(1658): _adodb_replace(Object(ADODB_mysql), 'Areas', Array, Array, true, false)
#4 /home/apoprecords/apoprecords.com/updates/concrete5.5.2/concrete/models/area.php(174): ADOConnection->Replace('Areas', Array, Array, true)
#5 /home/apoprecords/apoprecords.com/updates/concrete5.5.2/concrete/models/global_area.php(11): Area->getOrCreate(Object(Page), 'Site Name', 1)
#6 /home/apoprecords/apoprecords.com/packages/theme_silence/themes/silence/elements/header.php(53): GlobalArea->display(Object(Page))
#7 /home/apoprecords/apoprecords.com/updates/concrete5.5.2/concrete/libraries/view.php(345): include('/home/apoprecor...')
#8 /home/apoprecords/apoprecords.com/packages/theme_silence/themes/silence/full.php(2): View->inc('elements/header...')
#9 /home/apoprecords/apoprecords.com/updates/concrete5.5.2/concrete/libraries/view.php(849): include('/home/apoprecor...')
#10 /home/apoprecords/apoprecords.com/updates/concrete5.5.2/concrete/dispatcher.php(188): View->render('/page_not_found')
#11 /home/apoprecords/apoprecords.com/concrete/startup/updated_core_check.php(6): require('/home/apoprecor...')
#12 /home/apoprecords/apoprecords.com/concrete/dispatcher.php(14): require('/home/apoprecor...')
#13 /home/apoprecords/apoprecords.com/index.php(2): require('/home/apoprecor...')
#14 {main}
-------------------------------------------------------
I tried to visit your site, and it appears to be down.
Just guessing based on the stack trace, but here is what I think is happening: the theme is trying to access the Stack 'Site Name' through the 'Area::getOrCreate()' method. For some reason it doesn't have a legitimate value for the Page object ('cID' in the logs), so it fails.
In the context of the stack trace you sent, this is happening on the 404 page. I don't remember off the top of my head if those have actual collection IDs associated with them, but I don't think they do. If all your stack traces reference "View->render('/page_not_found')" then this is only happening when somebody visits a page that doesn't exist. However, whoever gets there is likely not having a good experience.
It looks like you have a purchased theme from the marketplace, and this appears to be something that the theme developer can fix with a null test on the Page object... but that's just a guess too, since I don't have the source in front of me.
In short, file a support ticket with the developer.
Just guessing based on the stack trace, but here is what I think is happening: the theme is trying to access the Stack 'Site Name' through the 'Area::getOrCreate()' method. For some reason it doesn't have a legitimate value for the Page object ('cID' in the logs), so it fails.
In the context of the stack trace you sent, this is happening on the 404 page. I don't remember off the top of my head if those have actual collection IDs associated with them, but I don't think they do. If all your stack traces reference "View->render('/page_not_found')" then this is only happening when somebody visits a page that doesn't exist. However, whoever gets there is likely not having a good experience.
It looks like you have a purchased theme from the marketplace, and this appears to be something that the theme developer can fix with a null test on the Page object... but that's just a guess too, since I don't have the source in front of me.
In short, file a support ticket with the developer.
Thank you, I will file a request with the developer of the theme. Does it seem likely that the above warning would have anything to do wit h the site being down intermittently?
Really hard to say. My guess is no, but software is always surprising. You could try temporarily switching to a default theme to test this theory.
oddly ebough, I deleted the theme and now my page seems to load just fine. of course now I have to start from scratch on finding a new theme and putting together a new site, but atleast it will load.
----Maybe shouldnt have said anything. site worked and loaded great for about 10 minutes, but is ow back to being intermittent.
----Maybe shouldnt have said anything. site worked and loaded great for about 10 minutes, but is ow back to being intermittent.
----------------------------------
# concrete5 Version
5.5.2
# concrete5 Packages
AddThis (1.0), eCommerce (2.7.1), eCommerce Import (2.0.2), Silence Theme (1.3), WordPress for Concrete5 (1.4.9).
# concrete5 Overrides
blocks/cst_facebook_opengraph_product, jobs/aob.log, jobs/aob_import.php
# Server Software
Apache
# Server API
cgi-fcgi
# PHP Version
5.3.5
# PHP Extensions
bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dom, ereg, exif, filter, ftp, gd, gettext, hash, iconv, imap, json, libxml, mbstring, mcrypt, mhash, mysql, mysqli, openssl, pcntl, pcre, PDO, pdo_mysql, pdo_sqlite, posix, pspell, Reflection, session, SimpleXML, soap, sockets, SPL, SQLite, sqlite3, standard, suhosin, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib.
# PHP Settings
log_errors_max_len - 1024
max_execution_time - 5
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - -1
memory_limit - 90M
post_max_size - 7M
safe_mode - Off
safe_mode_exec_dir - /usr/local/php/bin
safe_mode_gid - Off
safe_mode_include_dir - <i>no value</i>
sql.safe_mode - Off
upload_max_filesize - 7M
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 100000
pcre.recursion_limit - 100000
session.cache_limiter - nocache
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5
safe_mode_allowed_env_vars - PHP_
safe_mode_protected_env_vars - LD_LIBRARY_PATH
suhosin.cookie.max_array_depth - 50
suhosin.cookie.max_array_index_length - 64
suhosin.cookie.max_name_length - 64
suhosin.cookie.max_totalname_length - 256
suhosin.cookie.max_value_length - 10000
suhosin.cookie.max_vars - 100
suhosin.executor.include.max_traversal - 0
suhosin.executor.max_depth - 0
suhosin.get.max_array_depth - 50
suhosin.get.max_array_index_length - 64
suhosin.get.max_name_length - 64
suhosin.get.max_totalname_length - 256
suhosin.get.max_value_length - 512
suhosin.get.max_vars - 100
suhosin.log.phpscript.is_safe - Off
suhosin.memory_limit - 0
suhosin.post.max_array_depth - 50
suhosin.post.max_array_index_length - 64
suhosin.post.max_name_length - 64
suhosin.post.max_totalname_length - 256
suhosin.post.max_value_length - 1000000
suhosin.post.max_vars - 1000
suhosin.request.max_array_depth - 50
suhosin.request.max_array_index_length - 64
suhosin.request.max_totalname_length - 256
suhosin.request.max_value_length - 1000000
suhosin.request.max_varname_length - 64
suhosin.request.max_vars - 1000
suhosin.session.max_id_length - 128
suhosin.upload.max_uploads - 25