Database error, blog 2.0

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • pab
    New Member
    • Jun 2008
    • 24
    • 3.7.x

    Database error, blog 2.0

    Ok so I just uploaded all the 2.0 files but now sadly my blog is not working.
    This website is for sale! pokeralsbijbaan.nl is your first and best source for all of the information you’re looking for. From general topics to more of what you would expect to find here, pokeralsbijbaan.nl has it all. We hope you find what you are searching for!


    In my admin screen things are also messed up:

    It says *[blog_categories]* instead of blog categories.

    Anyone know what I have done? Why oh why did I had to upgrade....
  • Yves R.
    vBulletin QA
    • Nov 2003
    • 3856
    • 5.6.X

    #2
    Code:
    <!--
    Database error in vBulletin 3.7.3:
    
    Invalid SQL:
    
                        SELECT languageid,
                phrasegroup_global AS phrasegroup_global,
                phrasegroup_posting AS phrasegroup_posting,
                phrasegroup_vbblogglobal AS phrasegroup_vbblogglobal,
                phrasegroup_postbit AS phrasegroup_postbit,
                phrasegroup_vbblogcat AS phrasegroup_vbblogcat,
                phrasegroup_prefix AS phrasegroup_prefix,
                options AS lang_options,
                languagecode AS lang_code,
                charset AS lang_charset,
                locale AS lang_locale,
                imagesoverride AS lang_imagesoverride,
                dateoverride AS lang_dateoverride,
                timeoverride AS lang_timeoverride,
                registereddateoverride AS lang_registereddateoverride,
                calformat1override AS lang_calformat1override,
                calformat2override AS lang_calformat2override,
                logdateoverride AS lang_logdateoverride,
                decimalsep AS lang_decimalsep,
                thousandsep AS lang_thousandsep
                        FROM language
                        WHERE languageid = 2;
    
    MySQL Error   : Unknown column 'phrasegroup_vbblogcat' in 'field list'
    Error Number  : 1054
    Request Date  : Saturday, October 4th 2008 @ 05:24:00 PM
    Error Date    : Saturday, October 4th 2008 @ 05:24:00 PM
    Script        : http://www.pokeralsbijbaan.nl/forums/blog.php
    Referrer      : http://www.vbulletin.com/forum/showthread.php?p=1633028
    IP Address    : 82.244.129.149
    Username      : 
    Classname     : vB_Database
    MySQL Version : 
    -->
    Have you imported the product XML file?

    vBulletin QA - vBulletin Support French - Lead Project Tools developer

    Next release? Soon(tm)

    Comment

    • pab
      New Member
      • Jun 2008
      • 24
      • 3.7.x

      #3
      I fixed it already, didn't have vbulletin 3.7.3 yet...

      It's all working now, but where can I change the layout of these statistics:
      Weblogs: 9, Entries: 19, Last 24 Hours: 0
      I can;t find them in the template...



      They seem a bit out of place at the moment, I suppose it lies in this piece of code?
      $template_hook[forumhome_wgo_stats]

      Comment

      • Yves R.
        vBulletin QA
        • Nov 2003
        • 3856
        • 5.6.X

        #4
        Template 'blog_forumhome_stats'

        vBulletin QA - vBulletin Support French - Lead Project Tools developer

        Next release? Soon(tm)

        Comment

        • 1QuickSI
          Senior Member
          • Oct 2001
          • 881
          • 4.2.5

          #5
          How did you enable the blog stats??? I can not find the setitng anywhere and it is not on by default or at least not on my site.

          TIA
          -----------------------------------------------------------
          Running custom version of vBulletin based on v4.2.5
          PHP 7.4.14 :: MariaDB 10.5.8

          Comment

          • Yves R.
            vBulletin QA
            • Nov 2003
            • 3856
            • 5.6.X

            #6
            In the usergroup permission, if the usergroup can view others blogs, you can view statistics

            vBulletin QA - vBulletin Support French - Lead Project Tools developer

            Next release? Soon(tm)

            Comment

            • 1QuickSI
              Senior Member
              • Oct 2001
              • 881
              • 4.2.5

              #7
              Well as an Admin I can not see any blog stats Check the Admin user group and everything is checked as yes. Sigh...
              -----------------------------------------------------------
              Running custom version of vBulletin based on v4.2.5
              PHP 7.4.14 :: MariaDB 10.5.8

              Comment

              • Yves R.
                vBulletin QA
                • Nov 2003
                • 3856
                • 5.6.X

                #8
                There is a bug with permissions just after install. Folow the last Freddie's comment on this issue


                vBulletin QA - vBulletin Support French - Lead Project Tools developer

                Next release? Soon(tm)

                Comment

                • 1QuickSI
                  Senior Member
                  • Oct 2001
                  • 881
                  • 4.2.5

                  #9
                  Nope, placed in debug mode (why this has to be done to rebuild bit field makes no sense but whatever)

                  Ran...


                  Rebuilt.

                  Removed Debug from Config.

                  Still nothing.
                  -----------------------------------------------------------
                  Running custom version of vBulletin based on v4.2.5
                  PHP 7.4.14 :: MariaDB 10.5.8

                  Comment

                  • pab
                    New Member
                    • Jun 2008
                    • 24
                    • 3.7.x

                    #10
                    Ah I just removed the stats, since I've integrated the last blogs using feedburner.
                    But thanks for the help everyone!

                    Comment

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