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).

#4 mobiletoolserror.png40.52 KBsridharpandu
Members fund testing for the Drupal project. Drupal Association Learn more


jlea9378’s picture

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

jlea9378’s picture

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

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

40.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)