Announcement

Collapse
No announcement yet.

Attachments not showing in cms

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

  • [CMS] Attachments not showing in cms

    vBulletin 4.1.1 Patch Level 1 Some of my vBulletin attachments are missing...

    I am not aware of any changes in the system the attachments show up in the attachment manager in cp but once clicked I get this error "The service is unavailable."

    How can this be fixed?

  • #2
    That sounds like a server error, not a vbulletin error - is it? If so, then check your error_logs (if you don't know where they are, ask your host) and see what is in there. If it is a vbulletin error, then disable all Products except the vBulletin Blog and vBulletin CMS (Admin CP -> Plugins & Products -> Manage Products -> Disable) AND uncheck all the plugins except those related to the vBulletin Blog and vBulletin CMS by (Admin CP -> Plugins & Products -> Plugin Manager). You must do BOTH of those steps in order to disable all non vBulletin Modifications. Then see if you still get the same error.

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

    Comment


    • #3
      Thank you, I will check that lynne



      If it is a server error why are only attachments from this domain gone?

      Other domains still work

      www.geirinn.is
      Last edited by geiri; Tue 26th Jun '12, 6:08pm.

      Comment


      • #4
        I really couldn't tell you. Did you check the error_logs? Did you try contacting your host? Have you tried disabling all plugins? Are attachments stored in the database or filesystem?

        Please don't PM or VM me for support - I only help out in the threads.
        vBulletin Manual & vBulletin 4.0 Code Documentation (API)
        Want help modifying your vbulletin forum? Head on over to vbulletin.org
        If I post CSS and you don't know where it goes, throw it into the additional.css template.

        W3Schools <- awesome site for html/css help

        Comment


        • #5
          All attachments are in the file system I tried disabling and changing plugins and products activity but it changes nothing.

          I see nothing wrong in the error logs. I have two vBulletin sites on a win2008 server and the other one is just fine.

          All help is appreciated

          Comment


          • #6
            Well, the error is not a vbulletin error - it is coming from the server itself. So, there is something in your server configuration that is causing the problem. Do you have suhosin or mod_security enabled? Or, do you have any .htaccess for the site? Or for the attachement directory?

            Please don't PM or VM me for support - I only help out in the threads.
            vBulletin Manual & vBulletin 4.0 Code Documentation (API)
            Want help modifying your vbulletin forum? Head on over to vbulletin.org
            If I post CSS and you don't know where it goes, throw it into the additional.css template.

            W3Schools <- awesome site for html/css help

            Comment


            • #7
              No .htaccess file I dont have suhosin or mod_security enabled

              I have changed nothing all other programs work fine photopost etc..

              My other site is running on same server with same settings and nothing is wrong there?

              Comment


              • #8
                I can not find out what is wrong..

                Any one have a clue?

                Comment


                • #9
                  Have you shown the error to your host? As I already said - it isn't vbulletin giving the error, it is your server giving the error.

                  Please don't PM or VM me for support - I only help out in the threads.
                  vBulletin Manual & vBulletin 4.0 Code Documentation (API)
                  Want help modifying your vbulletin forum? Head on over to vbulletin.org
                  If I post CSS and you don't know where it goes, throw it into the additional.css template.

                  W3Schools <- awesome site for html/css help

                  Comment


                  • #10
                    I run the server my self and have been since 2002. Windows server 2008


                    vBulletin 4.1.1 Patch Level 1 There are no errors I can see there.

                    Images upload correctly. I see the attachments in the attachment manager but not on the page. Attachments are the only images that wont show on my site. See screen

                    Click image for larger version

Name:	vberror.jpg
Views:	1
Size:	102.7 KB
ID:	3689671

                    Comment


                    • #11
                      Have you tried moving the attachments back into the database and seen if you still get the same error?

                      Please don't PM or VM me for support - I only help out in the threads.
                      vBulletin Manual & vBulletin 4.0 Code Documentation (API)
                      Want help modifying your vbulletin forum? Head on over to vbulletin.org
                      If I post CSS and you don't know where it goes, throw it into the additional.css template.

                      W3Schools <- awesome site for html/css help

                      Comment


                      • #12
                        I did and got some errors did not catch them.

                        This is the outcome
                        ==============================
                        Attachments in Database: 170
                        Total Attachments Processed: 170

                        The above two values should be the same!

                        Number of Attachments that could not be read or are 0 bytes: 21



                        =============================
                        This is from the error log


                        Database error in vBulletin 4.1.1:

                        Invalid SQL:
                        INSERT INTO vb_attachmentviews (attachmentid)
                        VALUES (184);

                        MySQL Error : Incorrect file format 'vb_attachmentviews'
                        Error Number : 130
                        Request Date : Saturday, July 21st 2012 @ 05:31:34 PM
                        Error Date : Saturday, July 21st 2012 @ 05:31:35 PM
                        Script : http://www.geirinn.is/attachment.php...tid=184&cid=18
                        Referrer : http://www.geirinn.is/
                        Classname : vB_Database
                        MySQL Version : 5.1.53-community

                        Comment


                        • #13
                          It sounds like your attachmentviews table is corrupt. You may want to truncate it and see if things are OK. If not, you may need to drop it (and may need your hosts help with that if necessary) and then rebuild it.

                          Please don't PM or VM me for support - I only help out in the threads.
                          vBulletin Manual & vBulletin 4.0 Code Documentation (API)
                          Want help modifying your vbulletin forum? Head on over to vbulletin.org
                          If I post CSS and you don't know where it goes, throw it into the additional.css template.

                          W3Schools <- awesome site for html/css help

                          Comment


                          • #14
                            Looking at the database I see Huge amount of vb_aaggregate_temp_ tables piling up over 1000. What are these tables? Can I delete them?

                            vb_attachmentviews is empty. Is it ok to delete it and create a new?

                            Like in this thread?
                            https://www.vbulletin.com/forum/show...l=1#post508089

                            Comment


                            • #15
                              Yes, you may delete them. They are probably there because they couldn't finish the transfer of data from them to the attachmentviews table which is 'broken'.

                              And yes, you may recreate it like in that thread (wow, the table is actually exactly the same after 9 years!), except instead of attachmentviews, call the table vb_attachmentviews.

                              Please don't PM or VM me for support - I only help out in the threads.
                              vBulletin Manual & vBulletin 4.0 Code Documentation (API)
                              Want help modifying your vbulletin forum? Head on over to vbulletin.org
                              If I post CSS and you don't know where it goes, throw it into the additional.css template.

                              W3Schools <- awesome site for html/css help

                              Comment

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