Posted by nick.thorley on December 7, 2012 at 10:23am
3 followers
| Project: | Mobile Tools |
| Version: | 7.x-3.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
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).
Comments
#1
I'm also getting this error. Any help would be appreciated, thanks.
#2
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)
#3
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.
#4
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)