CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • WordPress Installations (Moderators: Kurund Jalmi, Coleman Watts) »
  • Could not find a valid session key
Pages: [1]

Author Topic: Could not find a valid session key  (Read 844 times)

markandphil

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
  • CiviCRM version: 3.3.5
  • CMS version: 6.20
  • MySQL version: 4
  • PHP version: 5
Could not find a valid session key
November 18, 2014, 05:43:13 am
We're having an issue where trying to make any transaction, heck even selecting Paypal as the payment gateway, results in this session key error.

I've removed all SSL, I've made sure all the domains are the same with http://new.fas.org, and we still get this error. Been trying to figure this out late into the night so I'm all out of ideas on how to fix it at this point.

Any other ideas we should try? BTW, I've searched through the forums here in the Wordpress Installation and tried some of the remedies folks suggested but those didn't help.   :(

We're running WP 4.0 with CiviCRM 4.5.1.

Here's the backtrace I get:
Code: [Select]
Nov 04 06:22:56  [info] $backTrace = #0 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(880): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::nullHandler(Object(DB_Error))
#2 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-content/plugins/civicrm/civicrm/packages/DB.php(975): PEAR_Error->PEAR_Error("DB Error: no such table", -18, 16, (Array:2), "\nSELECT name, group_name, value\nFROM   civicrm_setting\nWHERE  ( group_name...")
#4 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-18, 16, (Array:2), "\nSELECT name, group_name, value\nFROM   civicrm_setting\nWHERE  ( group_name...")
#5 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -18, NULL, NULL, "\nSELECT name, group_name, value\nFROM   civicrm_setting\nWHERE  ( group_name...", "DB_Error", TRUE)
#6 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(899): DB_common->raiseError(-18, NULL, NULL, NULL, "1146 ** Table 'knjewfmedu.civicrm_setting' doesn't exist")
#7 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(328): DB_mysql->mysqlRaiseError()
#8 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("\nSELECT name, group_name, value\nFROM   civicrm_setting\nWHERE  ( group_name...")
#9 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2442): DB_common->query("\nSELECT name, group_name, value\nFROM   civicrm_setting\nWHERE  ( group_name...")
#10 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1634): DB_DataObject->_query("\nSELECT name, group_name, value\nFROM   civicrm_setting\nWHERE  ( group_name...")
#11 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(325): DB_DataObject->query("\nSELECT name, group_name, value\nFROM   civicrm_setting\nWHERE  ( group_name...")
#12 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(1116): CRM_Core_DAO->query("\nSELECT name, group_name, value\nFROM   civicrm_setting\nWHERE  ( group_name...", TRUE)
#13 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/Setting.php(1066): CRM_Core_DAO::executeQuery("\nSELECT name, group_name, value\nFROM   civicrm_setting\nWHERE  ( group_name...", (Array:3), TRUE, NULL, FALSE, TRUE, TRUE)
#14 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/ConfigSetting.php(352): CRM_Core_BAO_Setting::retrieveDirectoryAndURLPreferences((Array:82))
#15 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Config.php(445): CRM_Core_BAO_ConfigSetting::retrieve((Array:82))
#16 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Config.php(222): CRM_Core_Config->_initVariables()
#17 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-content/plugins/civicrm/civicrm.php(381): CRM_Core_Config::singleton()
#18 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-content/plugins/civicrm/civicrm.php(1188): CiviCRM_For_WordPress->initialize()
#19 [internal function](): CiviCRM_For_WordPress->add_form_button("")
#20 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-includes/plugin.php(214): call_user_func_array((Array:2), (Array:1))
#21 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-admin/includes/media.php(546): apply_filters("media_buttons_context", "")
#22 [internal function](): media_buttons("content")
#23 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-includes/plugin.php(505): call_user_func_array("media_buttons", (Array:1))
#24 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-includes/class-wp-editor.php(218): do_action("media_buttons", "content")
#25 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-includes/general-template.php(2319): _WP_Editors::editor("", "content", (Array:5))
#26 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-admin/edit-form-advanced.php(514): wp_editor("", "content", (Array:5))
#27 /home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-admin/post-new.php(73): include("/home/16959-7018.cloudwaysapps.com/yyfzshujhz/public_html/wp-admin/edit-form-...")
#28 {main}
Thanks everybody for any help you can give!
« Last Edit: November 18, 2014, 05:50:00 am by markandphil »

haystack

  • I post occasionally
  • **
  • Posts: 61
  • Karma: 2
  • CiviCRM version: 4.n
  • CMS version: WordPress 4.n
  • MySQL version: 5.n
  • PHP version: 5.n
Re: Could not find a valid session key
November 18, 2014, 05:58:07 am
The error log says: "Table 'knjewfmedu.civicrm_setting' doesn't exist". Do you have the table 'civicrm_setting' present in your database?

I get a similar error on returning from a Paypal transaction - would be interested to find out if these are related.

markandphil

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
  • CiviCRM version: 3.3.5
  • CMS version: 6.20
  • MySQL version: 4
  • PHP version: 5
Re: Could not find a valid session key
November 18, 2014, 06:03:30 am
Thanks for looking at that!

Yes, it does exist. So that makes this even more puzzling.

Still not working.
« Last Edit: November 18, 2014, 06:15:22 am by markandphil »

sonicthoughts

  • Ask me questions
  • ****
  • Posts: 498
  • Karma: 10
Re: Could not find a valid session key
November 18, 2014, 05:59:02 pm
Check that everything conforms to utf8.  I can't remember the culprit by that seemed to help.  Also check drupal cookie domain and base path in settings as that can mess with the session table. I struggled with this last year.

markandphil

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
  • CiviCRM version: 3.3.5
  • CMS version: 6.20
  • MySQL version: 4
  • PHP version: 5
Re: Could not find a valid session key
November 18, 2014, 06:56:32 pm
Thanks @sonicthoughts - this is on Wordpress though.

What specifically do you mean should be in UTF-8? Never heard that be any sort of requirement in web dev before.

haystack

  • I post occasionally
  • **
  • Posts: 61
  • Karma: 2
  • CiviCRM version: 4.n
  • CMS version: WordPress 4.n
  • MySQL version: 5.n
  • PHP version: 5.n
Re: Could not find a valid session key
November 19, 2014, 06:23:02 am
What does the shortcode look like?

You could perhaps try the new civicrm-wordpress plugin and see if that fixes things:
https://github.com/civicrm/civicrm-wordpress

sonicthoughts

  • Ask me questions
  • ****
  • Posts: 498
  • Karma: 10
Re: Could not find a valid session key
November 19, 2014, 07:04:03 am
Quote from: markandphil on November 18, 2014, 06:56:32 pm
Thanks @sonicthoughts - this is on Wordpress though.

What specifically do you mean should be in UTF-8? Never heard that be any sort of requirement in web dev before.

Sorry , I just realized that you are on WP.  I've not done WP - Civicrm work so please ignore my drupal comments.  It may still be worthwhile to ensure encoding is the same.  see
UTF-8 http://en.wikipedia.org/wiki/UTF-8....
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • WordPress Installations (Moderators: Kurund Jalmi, Coleman Watts) »
  • Could not find a valid session key

This forum was archived on 2017-11-26.