how to rebuild album info?

[AlexMack]

during installation somehow the album construction got skipped. I get errors on any thread where the sql attempts to access it.

I don't care if the table's entirely blank, I just need the errors to stop

[Steve Machol]

We need to see the real error message. Right-click on the error page and go to View/Source. Then copy-n-paste the error message here.

[AlexMack]

here's the error:

Database error in vBulletin 3.8.3:

Invalid SQL:

			SELECT album.*,
				picture.pictureid, picture.extension, picture.idhash, album.moderation,
				picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height
				
			FROM album AS album
			LEFT JOIN picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)
			
			WHERE album.userid = 363927
				AND album.state IN ('public', 'private', 'profile')
				AND (album.visible > 0 OR album.moderation > 0)
				
			ORDER BY album.lastpicturedate DESC
			LIMIT 2;

MySQL Error   : Unknown column 'album.visible' in 'where clause'
Error Number  : 1054
Request Date  : Monday, August 24th 2009 @ 02:05:37 PM
Error Date    : Monday, August 24th 2009 @ 02:05:37 PM
Script        : [url]http://forums.ffshrine.org/member.php?u=363927[/url]
Referrer      : [url]http://forums.ffshrine.org/[/url]
IP Address    : 198.150.12.32
Username      : Sarah
Classname     : vB_Database
MySQL Version : 5.0.81-community-log

[Steve Machol]

Please look at the album table in phpMyAdmin and post the structure.

[AlexMack]

userid, gender, realname, othernames, bio, photo, mimetype, ts, state and moderation are the fields

[Steve Machol]

Wow, that's not even close to the default vB album table. Is this a new install to a fresh database? It looks like there was already something in that db.

[AlexMack]

after looking at the fields it looks like this was part of a very very old mod. I've deleted the table.

is there any way to install the default album table?

[Steve Machol]

Here is the query to create that table for vB 3.8.3:

CREATE TABLE album (
albumid INT UNSIGNED NOT NULL AUTO_INCREMENT,
userid INT UNSIGNED NOT NULL DEFAULT '0',
createdate INT UNSIGNED NOT NULL DEFAULT '0',
lastpicturedate INT UNSIGNED NOT NULL DEFAULT '0',
visible INT UNSIGNED NOT NULL DEFAULT '0',
moderation INT UNSIGNED NOT NULL DEFAULT '0',
title VARCHAR(100) NOT NULL DEFAULT '',
description MEDIUMTEXT,
state ENUM('public', 'private', 'profile') NOT NULL DEFAULT 'public',
coverpictureid INT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (albumid),
KEY userid (userid, lastpicturedate)
);

[cam2]

Edit... Ticket sent in.