I just updated from 7.x-1.0-beta19 to 7.x-1.0.

I can do nothing, and all users have been logged out.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'friendly_aimbl-va.file_managed' doesn't exist: SELECT u.uid, u.name,f.uri, MAX(s.timestamp) AS max_timestamp, gu.status AS status_indicator FROM {users} u INNER JOIN {sessions} s ON u.uid = s.uid INNER JOIN {googlechat_users} gu ON gu.uid = u.uid LEFT JOIN file_managed f ON u.picture = f.fid WHERE s.timestamp >= :interval AND s.uid > 0 AND u.uid <> :uid AND u.uid IN (:buddylist_0, :buddylist_1, :buddylist_2, :buddylist_3, :buddylist_4, :buddylist_5, :buddylist_6, :buddylist_7, :buddylist_8, :buddylist_9, :buddylist_10, :buddylist_11, :buddylist_12, :buddylist_13, :buddylist_14, :buddylist_15, :buddylist_16, :buddylist_17, :buddylist_18, :buddylist_19, :buddylist_20, :buddylist_21, :buddylist_22, :buddylist_23, :buddylist_24, :buddylist_25, :buddylist_26, :buddylist_27, :buddylist_28, :buddylist_29, :buddylist_30, :buddylist_31, :buddylist_32, :buddylist_33, :buddylist_34, :buddylist_35, :buddylist_36, :buddylist_37, :buddylist_38, :buddylist_39, :buddylist_40, :buddylist_41, :buddylist_42, :buddylist_43, :buddylist_44, :buddylist_45, :buddylist_46, :buddylist_47, :buddylist_48, :buddylist_49, :buddylist_50, :buddylist_51, :buddylist_52, :buddylist_53, :buddylist_54, :buddylist_55, :buddylist_56, :buddylist_57, :buddylist_58, :buddylist_59, :buddylist_60, :buddylist_61, :buddylist_62, :buddylist_63, :buddylist_64, :buddylist_65, :buddylist_66, :buddylist_67, :buddylist_68, :buddylist_69, :buddylist_70, :buddylist_71, :buddylist_72, :buddylist_73) AND gu.status <> :offline GROUP BY u.uid, u.name, gu.status ORDER BY status_indicator ASC, u.name ASC, max_timestamp DESC LIMIT 0, 10; Array ( [:interval] => 1489548192 [:uid] => 1 [:offline] => 4 [:buddylist_0] => 1 [:buddylist_1] => 2 [:buddylist_2] => 3 [:buddylist_3] => 4 [:buddylist_4] => 15 [:buddylist_5] => 16 [:buddylist_6] => 17 [:buddylist_7] => 18 [:buddylist_8] => 19 [:buddylist_9] => 20 [:buddylist_10] => 21 [:buddylist_11] => 22 [:buddylist_12] => 24 [:buddylist_13] => 26 [:buddylist_14] => 27 [:buddylist_15] => 28 [:buddylist_16] => 30 [:buddylist_17] => 31 [:buddylist_18] => 32 [:buddylist_19] => 34 [:buddylist_20] => 35 [:buddylist_21] => 36 [:buddylist_22] => 37 [:buddylist_23] => 38 [:buddylist_24] => 39 [:buddylist_25] => 40 [:buddylist_26] => 41 [:buddylist_27] => 43 [:buddylist_28] => 44 [:buddylist_29] => 46 [:buddylist_30] => 71 [:buddylist_31] => 72 [:buddylist_32] => 73 [:buddylist_33] => 77 [:buddylist_34] => 80 [:buddylist_35] => 91 [:buddylist_36] => 120 [:buddylist_37] => 126 [:buddylist_38] => 127 [:buddylist_39] => 128 [:buddylist_40] => 257 [:buddylist_41] => 374 [:buddylist_42] => 384 [:buddylist_43] => 439 [:buddylist_44] => 525 [:buddylist_45] => 601 [:buddylist_46] => 615 [:buddylist_47] => 618 [:buddylist_48] => 624 [:buddylist_49] => 626 [:buddylist_50] => 636 [:buddylist_51] => 657 [:buddylist_52] => 664 [:buddylist_53] => 668 [:buddylist_54] => 679 [:buddylist_55] => 681 [:buddylist_56] => 721 [:buddylist_57] => 742 [:buddylist_58] => 751 [:buddylist_59] => 763 [:buddylist_60] => 773 [:buddylist_61] => 803 [:buddylist_62] => 819 [:buddylist_63] => 821 [:buddylist_64] => 831 [:buddylist_65] => 845 [:buddylist_66] => 864 [:buddylist_67] => 931 [:buddylist_68] => 966 [:buddylist_69] => 998 [:buddylist_70] => 1002 [:buddylist_71] => 1032 [:buddylist_72] => 1050 [:buddylist_73] => 1104 ) in googlechat_chatbuddylistonline() (line 791 of /home/friendly/public_html/sites/all/modules/googlechat/googlechat.module).

Comments

oneblankspace created an issue. See original summary.

oneblankspace’s picture

oneblankspace commented

I was able to reinstall 1.0-beta19 and the site is working.

I have now disabled Google chat.

ankitchauhan’s picture

ankitchauhan commented

Thankyou for reporting the issue. Are you not using user picture in profile? If not, Please allow for once and let me know if you still face the issue.

I'll fix it asap in next release.

Ankit

ankitchauhan’s picture

ankitchauhan commented

In your error message, Base table or view not found: 1146 Table 'friendly_aimbl-va.file_managed' doesn't exist.

I'm very surprised now. Did you delete the table somehow? Or did you upgrade your drupal application from D6 to D7? The table "file_managed" is created during installation which you are missing. I've generated the code for you again:-

-- Table structure for table `file_managed`

CREATE TABLE `file_managed` (
  `fid` int(10) UNSIGNED NOT NULL COMMENT 'File ID.',
  `uid` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The users.uid of the user who is associated with the file.',
  `filename` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name of the file with no path components. This may differ from the basename of the URI if the file is renamed to avoid overwriting an existing file.',
  `uri` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'The URI to access the file (either local or remote).',
  `filemime` varchar(255) NOT NULL DEFAULT '' COMMENT 'The file’s MIME type.',
  `filesize` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The size of the file in bytes.',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'A field indicating the status of the file. Two status are defined in core: temporary (0) and permanent (1). Temporary files older than DRUPAL_MAXIMUM_TEMP_FILE_AGE will be removed during a cron run.',
  `timestamp` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'UNIX timestamp for when the file was added.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores information for uploaded files.';
ALTER TABLE `file_managed`
  ADD PRIMARY KEY (`fid`),
  ADD UNIQUE KEY `uri` (`uri`),
  ADD KEY `uid` (`uid`),
  ADD KEY `status` (`status`),
  ADD KEY `timestamp` (`timestamp`);
ALTER TABLE `file_managed`
  MODIFY `fid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'File ID.';

Run the above queries in your database. and you can use the chat again.

regards
ankit

ankitchauhan’s picture

ankitchauhan commented
Status: Active » Closed (cannot reproduce)
agarwal.sudhanshu’s picture

agarwal.sudhanshu commented

I am able to reproduce the error, this error produce when you are using prefix on your table

error is at line number 776 following code
$query_range = 'SELECT u.uid, u.name,f.uri, MAX(s.timestamp) AS max_timestamp, gu.status AS status_indicator ' . $field . ' FROM {users} u INNER JOIN {sessions} s ON u.uid = s.uid INNER JOIN {googlechat_users} gu ON gu.uid = u.uid ' . $join . ' LEFT JOIN file_managed f ON u.picture = f.fid WHERE s.timestamp >= :interval AND s.uid > 0 AND u.uid <> :uid AND u.uid IN (:buddylist) AND gu.status <> :offline GROUP BY u.uid, u.name, gu.status ORDER BY status_indicator ASC, u.name ASC, max_timestamp DESC';

here table name file_managed is not closed with the braces thus any site with table prefix will face the same issue

correct code should be following

$query_range = 'SELECT u.uid, u.name,f.uri, MAX(s.timestamp) AS max_timestamp, gu.status AS status_indicator ' . $field . ' FROM {users} u INNER JOIN {sessions} s ON u.uid = s.uid INNER JOIN {googlechat_users} gu ON gu.uid = u.uid ' . $join . ' LEFT JOIN {file_managed} f ON u.picture = f.fid WHERE s.timestamp >= :interval AND s.uid > 0 AND u.uid <> :uid AND u.uid IN (:buddylist) AND gu.status <> :offline GROUP BY u.uid, u.name, gu.status ORDER BY status_indicator ASC, u.name ASC, max_timestamp DESC';

Thanks
Sudhanshu agarwal
DICE INFOCOM PRIVATE LIMITED

agarwal.sudhanshu’s picture

agarwal.sudhanshu commented
Status: Closed (cannot reproduce) » Needs work
ankitchauhan’s picture

ankitchauhan commented

Thank you for the issue identification. I'll incorporate your(sudhanshu) suggestion in next release.

regards
ankit

ankitchauhan’s picture

ankitchauhan commented
Status: Needs work » Fixed

This is fixed now

Status: Fixed » Closed (fixed)

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