Upgraded module on a D6 site & following error occurred:

user warning: Unknown column 'type' in 'field list' query: SELECT module, type FROM drupal_captcha_points WHERE form_id = 'search_theme_form' in /path/to/drupal/sites/all/modules/captcha/captcha.inc on line 60.

Now, captchas are no longer appearing on forms.

Comments

xaav’s picture

btw, pretty sad that I could only find one "fixed" issue.

soxofaan’s picture

Category: bug » support

You didn't upgrade correctly: line 60 of captcha.inc from 6.x-2.4 is

  $result = db_query("SELECT module, captcha_type FROM {captcha_points} WHERE form_id = '%s'", $form_id);

you still have code from 6.x-2.3 and probably didn't overwrite the old module's code correctly.

And please inform yourself better instead of making condescending remarks: fixed issues are closed automatically after two weeks of inactivity: http://drupal.org/project/issues/captcha?text=&status=7&priorities=All&c...

elachlan’s picture

@geoffreyfishing - I suggest that you uninstall the module and then reinstall it. This will allow you to re-add captchas onto your forms.

Note: if you uninstall then you will have to re-setup any settings, such as where to place the captchas.

soxofaan’s picture

probably no need to uninstall and reinstall
just replacing the old module's code with the new version should be enough

Stomper’s picture

@#4, I replaced the 2.3 code with latest 2.4 code, by deleting the entire "captcha" file and replacing with the new file. The error still showed.

elachlan’s picture

Overwrite the whole directory with 6x-2.4. Then run the update.php page.

Stomper’s picture

So do what I did but run update.php?

elachlan’s picture

login to drupal and then navigate to /update.php this will give you a prompt to run the code that updates the drupal database in regards to the new modules that you add.

elachlan’s picture

elachlan’s picture

Status: Active » Closed (works as designed)

marking as closed due to inactivity.

kenziem’s picture

What was the fix?
The site I'm looking after seems to have similar problem, captcha is no longer appearing on forms.

We have run update.php.

soxofaan’s picture

@kenziem: "no longer": does that mean after upgrade from 6.x-2.3 o 6.x-2.4? Or is it after installation of another module?
What does the CAPTCHA settings page say? Are there still forms specified there?

mustang’s picture

@soxofan - Can't speak to kenziem's site, but on mine the forms do -not- appear on the CAPTCHA configuration page after the upgrade. Because of this and my inability to find documentation on the forms produced by Drupal, I've made several stabs in the dark trying to ensure CAPTCHA/reCaptcha shows on the forms.

Any resolution on this matter?

Anonymous’s picture

Ran upgrade & all seems well; would just point out that the warning that pops up just before you commit to the database update caused me some hesitation.

My warning was different, but similar:
Unknown column 'captcha_type' in 'field list' query: SELECT module, captcha_type FROM captcha_points WHERE form_id = 'update_script_selection_form' in /Library/WebServer/Documents/eetdsurveys-drupal-6.20/sites/all/modules/captcha/captcha.inc on line 60.

This isn't a support request, not sure how to categorize it. I only mention it because I did back off from the upgrade because of the warning, but in the end it seemed not to be a problem.

Eduart’s picture

StatusFileSize
new108.19 KB

I have update capcha -not the drupal core- and I found the same issue, capcha form did not appear at any place of the site. Only I have the settings: admin/user/captcha ; But The capcha settings did not show the id (see the image attached)
I follow the instruction of the captcha settings:

You can easily add arbitrary forms with textfield at the bottom of the table or with the help of the 'Add CAPTCHA administration links to forms' option below.

then when i fill the texfield with the id, nothing happen

Then, I have re-install captcha 6x-2.4, And When I run update.php.... Drupal show the following message:

The following update warning should be carefully reviewed before continuing:
Operations on Unicode strings are emulated on a best-effort basis. Install the PHP mbstring extension for improved Unicode support. (Currently using Unicode library Standard PHP)

Some body have an experience with this issue?

There is hundred of web sites on line showing the same issue.

Eduart’s picture

StatusFileSize
new88.62 KB
new22.97 KB

I have found the solution (in my case):

1) go to admin/build/modules
2) uncheck 'captcha-image' module and save
3) uncheck 'captcha' module and then save
4) go to admin/build/modules/uninstall and sellect uninstall captcha module.
5) download capcha module from drupal.org, then upload to your host, and then sellect the modules again in admin/bluild/modules and then install again, go to captcha and cofigure again.

soxofaan’s picture

If you update modules (and also core for that matter),
you always have to check if you have to run the update.php script (example.com/update.php)
http://drupal.org/upgrade/running-update-php

I think this is the issue here