3.7 RC2 User Profile error...

[kgregc1@mac.com]

When I click on my user name to bring up my profile, I get the following:


SELECT COUNT(*) AS albumcount, SUM(album.picturecount) AS picturecount
FROM album AS album
WHERE album.userid = 3
AND album.state IN ('public', 'private', 'public');

MySQL Error : Unknown column 'album.picturecount' in 'field list'
Error Number : 1054
Date : Friday, April 4th 2008 @ 12:45:36 AM
Script : http://www.unionhillsolutions.com/forum/member.php?u=3
Referrer : http://www.unionhillsolutions.com/forum/index.php

Username : Admin II
Classname : vB_Database
MySQL Version : 5.0.45-community-log

Can anyone help, please?

Thanks.

[Wayne Luke]

You will need to add this field.

ALTER TABLE album ADD picturecount INT unsigned NOT NULL DEFAULT '0'

[kgregc1@mac.com]

Thanks, Wayne...but I'm not really "literate" in these things.. Can you point me in the direction as to how and where I would add the "field"?

Thanks.

[Wayne Luke]

You need to run the query above on your database. You can run queries within the vBulletin Admin Control Panel by going to Maintenance -> Execute SQL Queries.

To run Queries in the Admin Control Panel you need to edit your config.php file and add your user ID to the Can Run Queries section. It looks like:

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '';

Place your user id between the single quotes.

[kgregc1@mac.com]

Wayne,

Thanks, that fixed that problem, but now I have another that showed up. It seems that one of the "layers" that make up the screen is on top where it shouldn't be, is the only way I know how to describe it. One area is just below my user name, and the other is at the bottom of where the Album drop down window opens to.

25822

25823

I have logged out, logged back in, different user names..Safari, FireFox and Opera browsers, and I still have the problem.

Any help will be greatly appreciated,

Greg

[Wayne Luke]

Revert your "Additional CSS" box under Styles & Templates -> Style Manager -> Main CSS.