Announcement

Collapse
No announcement yet.

how to rebuild album info?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • how to rebuild album info?

    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

  • #2
    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.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      here's the error:

      Code:
      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        : http://forums.ffshrine.org/member.php?u=363927
      Referrer      : http://forums.ffshrine.org/
      IP Address    : 198.150.12.32
      Username      : Sarah
      Classname     : vB_Database
      MySQL Version : 5.0.81-community-log

      Comment


      • #4
        Please look at the album table in phpMyAdmin and post the structure.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


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

          Comment


          • #6
            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.
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment


            • #7
              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?

              Comment


              • #8
                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)
                );
                Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                Change CKEditor Colors to Match Style (for 4.1.4 and above)

                Steve Machol Photography


                Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                Comment


                • #9
                  Edit... Ticket sent in.
                  Last edited by cam2; Thu 8th Oct '09, 2:33pm.

                  Currently running XenForo, knee jerk to vB4 release. I'm back home, can't wait for vB5 GOLD release.

                  Comment

                  widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                  Working...
                  X