I've installed APK and dependencies in to an almost empty Drupal installation in order to have a look-see.

Although not a newbee and I have used cck and views extensively and panels a little, I am still learning, and so I have started with an 'as-given' installation.

I'd appreciate it if you could point me in the right direction.

The problem...

When looking at the account page with APK on and the page variant enabled I get an error, listed below.

This is also listed in the preview of the variant.

The profile can be edited, and when viewed as a simple node it it fine.

All the views from APK work fine -

It is just this somewhat essential panel variant

i've tried deleting it and re-creating it using your documentation, but have the same result - so I realise that the actual problem lies elsewhere, but I'm lost for looking.

My Drupal database has the somewhat unfortunate prefix bo_

The following error message (repeated down the page on different line numbers of views.inc) appear instead of the user profile and in the preview of the page variant.

I notice that many of the columns referenced do not have the database prefix, although the column it complains about is one that does exist in the database.

user warning: Unknown column 'bo_users.uid' in 'where clause' query: SELECT COUNT(*) FROM (SELECT users.uid AS uid, facebook_status.sid AS facebook_status_sid, users.picture AS users_picture, users.name AS users_name, users.mail AS users_mail, facebook_status.message AS facebook_status_message, facebook_status.sender AS facebook_status_sender, facebook_status.recipient AS facebook_status_recipient, facebook_status.type AS facebook_status_type, facebook_status.created AS facebook_status_created, facebook_status.private AS facebook_status_private, fbsmp.sid AS fbsmp_sid, fbsmp.type AS fbsmp_type, fbsmp.data AS fbsmp_data FROM bo_users users LEFT JOIN bo_user_relationships user_relationships ON users.uid = user_relationships.requestee_id LEFT JOIN bo_users users_user_relationships ON user_relationships.requester_id = users_user_relationships.uid INNER JOIN bo_facebook_status facebook_status ON users.uid = facebook_status.recipient LEFT JOIN bo_fbsmp fbsmp ON facebook_status.sid = fbsmp.sid WHERE (facebook_status.type in ('user')) AND (facebook_status.message <> '' OR ( fbsmp.type IS NOT NULL AND fbsmp.type IN ('link','photo','video','slideshare') )) AND ( ((user_relationships.requestee_id = 1 OR user_relationships.requester_id = 1) AND user_relationships.approved = 1) OR bo_users.uid = 1 ) GROUP BY facebook_status.sid, uid, facebook_status_sid, users_picture, users_name, users_mail, facebook_status_message, facebook_status_sender, facebook_status_recipient, facebook_status_type, facebook_status_created, facebook_status_private, fbsmp_sid, fbsmp_type, fbsmp_data ORDER BY facebook_status_sid DESC ) count_alias in /home/brinkedout/domains/brinkedout.com/public_html/sites/all/modules/views/includes/view.inc on line 745.

I've been staring at this too long - could you help me look in the right places!

Many thanks

Comments

michelle’s picture

Status: Active » Closed (duplicate)
mylesorme’s picture

Sorry - When I was unable to find the previous post I thought I must have failed to submit the form