Announcement

Collapse
No announcement yet.

Database error about attachments after upgrade

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

  • Lynne
    replied
    They had a different problem and it was fine to just add the new field. The field you are missing, however, gets populated by the upgrade script. So, simply adding the field is not good enough. So, yes, I was suggesting running the upgrade script again in the hopes that it would add that field and populate it for you.

    Leave a comment:


  • |Norman|
    replied
    Do you mean to run again the upgrade script now?

    PS: I found this: http://www.vbulletin.com/forum/showt...eads&p=1966977
    Could it be helpfull for me? I really don't understand if it could be the same problem.

    Leave a comment:


  • Lynne
    replied
    You are missing the contenttypes field. This isn't a field you can just add though. You really should try to run the upgrade script script again and see if it gets added.

    Leave a comment:


  • |Norman|
    replied
    When I enter that table I see this:

    http://i43.tinypic.com/nd69tf.jpg

    In the upgrade process I have a problem in the step 6-7, with really slow loading time (with no ending). I had to change the URL from upgrade_400a1.php?step=6 to upgrade_400a1.php?step=7.

    PS: I get the same error also when I try to reply to existing threads.

    Leave a comment:


  • Lynne
    replied
    Have you looked in your database to see if you have a field called "contenttypes" in your "attachmenttype" table? did you have any problems in your upgrade?

    Leave a comment:


  • |Norman|
    started a topic [Forum] Database error about attachments after upgrade

    Database error about attachments after upgrade

    I get this error when I try to open threads which contains attachments..

    Database error in vBulletin 4.0.3:

    Invalid SQL:

    SELECT
    fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize,
    a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings, a.displayorder,
    at.contenttypes
    FROM attachment AS a
    INNER JOIN filedata AS fd ON (fd.filedataid = a.filedataid)
    LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
    WHERE
    a.contentid IN (31741,31886,31903,31915,31934,32005,32135,32137,32250,32273)
    AND
    a.contenttypeid = 1

    ORDER BY a.contentid, a.displayorder;

    MySQL Error : Unknown column 'at.contenttypes' in 'field list'
    Error Number : 1054
    Request Date : Thursday, May 6th 2010 @ 04:26:27 PM
    Error Date : Thursday, May 6th 2010 @ 04:26:29 PM
    Script : #/forum/showthread.php?6004-RANKING-A.L.G.-2010&p=32250
    Referrer : #/forum/
    IP Address : #
    Username : Norman
    Classname : vB_Database
    MySQL Version : 5.0.32-Debian_7etch8-log
    I tried to repair/optmize tables and to rebuild attachments thumbnails several times. But I still get this error. Can you please help me?

Related Topics

Collapse

Working...
X