I am getting the following error when trying to add a new device

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'b.parent' in 'field list': SELECT b.parent AS parent FROM {browscap} b GROUP BY parent ORDER BY parent ASC; Array ( ) in mobile_tools_browscap_get_browscap_parents() (line 139 of /home/ozonesco/public_html/clients/epm/sites/all/modules/mobile_tools/mobile_tools_browscap/mobile_tools_browscap.module).

CommentFileSizeAuthor
#4 mobiletoolserror.png40.52 KBsridharpandu
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

jlea9378’s picture

jlea9378 CreditAttribution: jlea9378 commented

I'm also getting this error. Any help would be appreciated, thanks.

jlea9378’s picture

jlea9378 CreditAttribution: jlea9378 commented

I installed the patch for Browscap (http://drupal.org/node/1713570) but am still getting this error whenever I try to modify the default device group or add a new device group.

Drupal core 7.17
Chaos tool suite (ctools) 7.x-1.2+7-dev (2012-Nov-16)
Browscap 7.x-2.0
Context 7.x-3.0-beta4
Mobile Tools 7.x-3.x-dev (2012-Aug-07)
Persistent URL 7.x-1.0-beta1+11-dev (2012-Aug-20)
ThemeKey 7.x-2.3+8-dev (2012-Nov-26)

jlea9378’s picture

jlea9378 CreditAttribution: jlea9378 commented

Ok apparently after patching Browscap you need to uninstall the module and reinstall it, since it modifies the .install file. This resolves the error. However there appears to be a problem with the patch that results in a different error.

sridharpandu’s picture

sridharpandu CreditAttribution: sridharpandu commented
FileSize
mobiletoolserror.png40.52 KB

I get this error too. Disabled the module, applied both the patches mentioned in the posts (one in this thread and the other in the thread where the first patch is mentioned), enabled the module and I still got the error while adding a device.

So I disabled the module, uninstalled it and re-enabled the module and now the error is resolved.

(BTW the first patch modifieds the install file while the second modifies the import file)