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 »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Could not find valid value for ct
Pages: [1] 2

Author Topic: Could not find valid value for ct  (Read 8143 times)

cpelham

  • Guest
Could not find valid value for ct
February 24, 2008, 12:44:32 pm
Hi. I just installed a fresh CiviCRM Beta2 with new database, rather than upgrade, and from the beginning I cannot add or edit any   contacts at all, not even one field. I get the "Could not find valid value for ct" error every time. I have read the previous threads about this but they have not been helpful. I do not have SimpleNews installed, for example. I am perplexed. Did anyone ever get to the root of this error?

cpelham

  • Guest
Re: Could not find valid value for ct
February 24, 2008, 12:50:14 pm
Check that. I found one post which suggested syncing contacts to users. I did that and now I can successfully save an edited contact. I still find it odd that this would correct the error and wonder what this implies.

cpelham

  • Guest
Re: Could not find valid value for ct
February 24, 2008, 12:51:55 pm
And...the error is back again...

cpelham

  • Guest
Re: Could not find valid value for ct
February 24, 2008, 10:20:39 pm
Should I just delete everything and re-install?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Could not find valid value for ct
February 24, 2008, 11:43:19 pm

I suspect there is something else wrong in your install, so deleting everything and reinstalling may or may not fix it. However it might be your best option at this time. You might want to try it with a new clean install of drupal also

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

madjoe

  • Guest
Re: Could not find valid value for ct
March 27, 2008, 06:17:09 am
I had the same issue and I solved it by increasing PHP allowed memory size to 128M (files to change: php.ini, settings.php, civicrm.settings.php). Yes, I know it sounds odd, but I had a huge form for adding new Organizations (because of numerous of Custom Fields) and previous setup of 64M was just not good enough somehow. I hope this helps!

Quote from: cpelham on February 24, 2008, 12:44:32 pm
I get the "Could not find valid value for ct" error every time.

jdowd

  • I’m new here
  • *
  • Posts: 17
  • Karma: -5
Re: Could not find valid value for ct
April 02, 2008, 09:04:18 am
Quote from: madjoe on March 27, 2008, 06:17:09 am
I had the same issue and I solved it by increasing PHP allowed memory size to 128M (files to change: php.ini, settings.php, civicrm.settings.php). Yes, I know it sounds odd, but I had a huge form for adding new Organizations (because of numerous of Custom Fields) and previous setup of 64M was just not good enough somehow. I hope this helps!

Quote from: cpelham on February 24, 2008, 12:44:32 pm
I get the "Could not find valid value for ct" error every time.

This did not work for me.  Though, I did not see a memory value in the settings.php file.  can you tell me what you did in there?

Regards,

jdowd

  • I’m new here
  • *
  • Posts: 17
  • Karma: -5
Re: Could not find valid value for ct
April 03, 2008, 12:45:49 pm
I am pretty frustrated by this error.  I need some help on it.  Pretty badly.  I have upgraded to civicrm but I am still getting this error.  Can anyone tell me what ct is and where civicrm is trying to find it?  This is as completely vague an error message as one can get.

Thanks,

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Could not find valid value for ct
April 03, 2008, 01:18:37 pm

I do agree that this is a vague error message. To a large extent, the message can be rephrased as: "We have no idea how your system got into this state, this is not expected or anticipated behavior and we have no clue what to do."

It does not help that we cannot reproduce this either on any of our machines. If you can reproduce on demo, we can track, investigate and fix

lobo

A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

jdowd

  • I’m new here
  • *
  • Posts: 17
  • Karma: -5
Re: Could not find valid value for ct
April 04, 2008, 10:08:11 am
So, I downloaded the devel module for drupal... I am looking at the update statement that seems to be generating this error message... I can't post it here because it is 27,529 spaces long.  Does that sound unusual to you?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Could not find valid value for ct
April 04, 2008, 10:57:14 am

1. the devel module does not instrument civicrm queries (we use a different db abstraction layer)

2. i assume the update statement is for the session, and u mean it is 27K characters (rather than spaces?). if characters, no. If spaces then it is quite wierd and u might want to debug that

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

jdowd

  • I’m new here
  • *
  • Posts: 17
  • Karma: -5
Re: Could not find valid value for ct
April 04, 2008, 11:07:58 am
Quote from: Donald Lobo on April 04, 2008, 10:57:14 am

1. the devel module does not instrument civicrm queries (we use a different db abstraction layer)

2. i assume the update statement is for the session, and u mean it is 27K characters (rather than spaces?). if characters, no. If spaces then it is quite wierd and u might want to debug that

lobo

Sorry, yes, I meant characters long.  Can you tell me the best way to see what queries are being run?  Is there a tool like the dev module for civicrm?

Thanks

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Could not find valid value for ct
April 04, 2008, 11:39:17 am

There is no devel module equivalent for civicrm (but maybe you can step up and contribute one :)

We use the mysql query log to see what queries are being run. You could also instrument and echo the queries in packages/DB/DataObject.php (uncomment out line 2280)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

jdowd

  • I’m new here
  • *
  • Posts: 17
  • Karma: -5
Re: Could not find valid value for ct
April 04, 2008, 11:58:15 am
Quote from: Donald Lobo on April 04, 2008, 11:39:17 am

There is no devel module equivalent for civicrm (but maybe you can step up and contribute one :)

We use the mysql query log to see what queries are being run. You could also instrument and echo the queries in packages/DB/DataObject.php (uncomment out line 2280)

lobo

Thanks for that... I think I am on to something...

This is the errormessage that I got back...

Error Details:

[db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="explain /*!40101 SET NAMES utf8 */ [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET NAMES utf8 */' at line 1]"]

As I look at the collation... I am seeing that my drupal tables are all MISAM utf8_general_ci while my civicrm tables are all InnoDB and utf8_unicode_ci

do you think that this is the cause of my problem and if so, can you recommend a solution?

Regards,

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Could not find valid value for ct
April 04, 2008, 04:02:32 pm

1. what version of mysql are you using

2. the statement: "explain /*!40101 SET NAMES utf8 */" does not appear in CiviCRM. That does give a syntax error in my version. CiviCRM does execute the statement: "/*!40101 SET NAMES utf8 */" when it opens up the db connection.

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Could not find valid value for ct

This forum was archived on 2017-11-26.