Hi Browse Cap team & users!

I have a problem when installing browsecap,

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ROB.browscap' doesn't exist: SELECT * FROM {browscap} WHERE :useragent LIKE useragent ORDER BY LENGTH(useragent) DESC; Array ( [:useragent] => Mozilla/5.0 (Windows NT 6.2) AppleWebKit/537.10 (KHTML, like Gecko) Chrome/23.0.1262.0 Safari/537.10 ) in browscap_get_browser() (line 172 of /var/www/rob/modules/moduledownload/browscap/browscap.module).

i have tried to install the dev version but the result is the same,
I've installed it with no problem on another drupal installation.
I think it might be related to other modules I have installed on the server.

Here is the list of all modules installed on my drupal install.
-rw-r--r-- 1 root root 14205 Mar 19 05:25 browscap-7.x-1.3.tar.gz
-rw-r--r-- 1 root root 62201 May 19 12:15 calendar-7.x-3.4.tar.gz
-rw-r--r-- 1 root root 407345 Aug 18 19:46 ctools-7.x-1.2.tar.gz
-rw-r--r-- 1 root root 13875 Sep 22 2011 custom_pagers-7.x-1.x-dev.tar.gz
-rw-r--r-- 1 root root 213301 Aug 13 09:27 date-7.x-2.6.tar.gz
rw-r--r-- 1 root root 106628 May 25 21:25 entity-7.x-1.0-rc3.tar.gz
-rw-r--r-- 1 root root 30501 May 30 21:05 entityreference-7.x-1.0-rc3.tar.gz
-rw-r--r-- 1 root root 221015 Mar 28 17:05 fivestar-7.x-2.0-alpha2.tar.gz
-rw-r--r-- 1 root root 31440 Oct 23 2011 link-7.x-1.0.tar.gz
-rw-r--r-- 1 root root 339088 Aug 18 19:52 panels-7.x-3.3.tar.gz
-rw-r--r-- 1 root root 20799 Jul 11 13:22 panels_everywhere-7.x-1.0-rc1.tar.gz
-rw-r--r-- 1 root root 8810 Sep 2 2011 panels_tabs-7.x-1.x-dev.tar.gz
-rw-r--r-- 1 root root 38900 Aug 9 15:13 pathauto-7.x-1.2.tar.gz
-rw-r--r-- 1 root root 74329 Mar 29 00:21 quicktabs-7.x-3.4.tar.gz
-rw-r--r-- 1 root root 168867 Aug 3 07:58 rules-7.x-2.2.tar.gz
-rw-r--r-- 1 root root 76039 Nov 16 2011 services-7.x-3.1.tar.gz
rw-r--r-- 1 root root 43170 Aug 10 21:37 token-7.x-1.2.tar.gz
-rw-r--r-- 1 root root 50563 Aug 23 2011 userpoints-7.x-1.0.tar.gz
-rw-r--r-- 1 root root 16421 Nov 12 2011 userpoints_nc-7.x-1.0.tar.gz
-rw-r--r-- 1 root root 1632919 Aug 24 17:29 views-7.x-3.5.tar.gz
-rw-r--r-- 1 root root 31868 Feb 27 2012 votingapi-7.x-2.6.tar.gz
-rw-r--r-- 1 root root 68074 Jun 19 2011 wysiwyg-7.x-2.1.tar.gz

Thanks, Sylvain

Comments

devin carlson’s picture

devin carlson commented
Status: Active » Fixed

It look like you have Browscap installed but the {browscap} table that Browscap uses to store useragent information in has been dropped.

I'd suggest you take a look through your database and make sure the following tables do not exist (and drop them if they do):

  • browscap
  • browscap_statistics
  • cache_browscap

Once you've done that, disable the Browscap module, uninstall it and then try reinstalling it.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.