Installed module, ran update.php , filled settings? and got this warnings. Can anyone explain what is the issue please?

Warning comes out at this page /users/%

user warning: Unknown column 'status' in 'field list' query: INSERT INTO facebook_status (uid, pid, status_time, status) VALUES (4, 4, 1247850771, 'tired') in /includes/common.inc on line 3436.

And at /user/%/status i get this warning:

* user warning: Unknown column 'facebook_status.status' in 'where clause' query: SELECT COUNT(*) FROM (SELECT users.uid AS uid FROM users users INNER JOIN facebook_status facebook_status ON users.uid = facebook_status.uid WHERE ((facebook_status.status) != ('')) AND (users.name = 'Skirr') ) count_alias in /sites/all/modules/views/includes/view.inc on line 729.
* user warning: Unknown column 'facebook_status.status' in 'field list' query: SELECT users.uid AS uid, facebook_status.sid AS facebook_status_sid, facebook_status.pid AS facebook_status_pid, facebook_status.status AS facebook_status_status, facebook_status.status_time AS facebook_status_status_time FROM users users INNER JOIN facebook_status facebook_status ON users.uid = facebook_status.uid WHERE ((facebook_status.status) != ('')) AND (users.name = 'Skirr') ORDER BY facebook_status_sid DESC LIMIT 0, 10 in /sites/all/modules/views/includes/view.inc on line 755.

And node contains:

$account = user_load(array('uid' => arg(1)));
if (!$account->uid) {
echo t('This user has no statuses yet.');
return;
}
$count = facebook_status_has_status(arg(1));
if (!$count) {
global $user;
if ($user->uid == $account->uid) {
echo t('You have no statuses yet.');
}
else {
echo t('@name has no statuses yet.', array('@name' => check_plain($account->name)));
}
}

Comments

icecreamyou’s picture

Status: Active » Postponed (maintainer needs more info)

First and foremost, never report a database error without saying what type and version of database you're using.

Is this an upgrade or a new installation? If it's a new installation, why in the world did you run update.php?

There is no Drupal path users/%.

Check your database and see if the "status" column is there. If it isn't, disable the module, uninstall it, delete the folder, upload the latest dev, enable it, revert your Views if necessary, refresh your system and browser cache, and adjust your settings.

FBSS has nothing to do with nodes. I don't know what you're talking about there. But it looks similar to #507316.

Skirr’s picture

Status: Postponed (maintainer needs more info) » Fixed

Sorry for not a full report. Not a programmer, and didnt know about it, till now.
I used Facebook-style Statuses (Microblog) 1.0 and when updated to 2.0rc1 didnt uninstall it, but just deleted the old files.

Now when i followed your instructions, everything works (i did everything that you wrote above). Thanks a lot, for your time and full answer. And of course for the module.

icecreamyou’s picture

It's fine. I'm glad it works.

Status: Fixed » Closed (fixed)

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

MeagerMaiden’s picture

Issue tags: +Facebook-style Statuses
StatusFileSize
new23.43 KB
new10.11 KB

It's not closed for me. I too am experiencing the same problem as the main one from above. Also, I have a screenshot of the warning messages I am getting after posting status updates. (using Drupal 6, current php)

screenshots attached. Any help would be terrific. Thanks..

icecreamyou’s picture

@MeagerMaiden: your problem is with the Mentions module, not FBSS. I recommend that you use the Tags submodule of FBSS instead. Additionally, you should be using FBSS 3.x, not 2.x; and instead of posting in old, closed support requests you should open new issues and explain what research you've already done (including links to other relevant issues).