Announcement

Collapse
No announcement yet.

Upgraded to 3.85 and added the blog and now get an error

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

  • Upgraded to 3.85 and added the blog and now get an error

    I upgraded to 3.85 today and installed the blog. Everything seemed fine. However the blog link on the profile goes to a blank page even though the php file is there and I keep getting this error sent to me via email:
    Database error in vBulletin 3.8.5:

    Invalid SQL:

    SELECT
    userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
    language.phrasegroup_global AS phrasegroup_global,
    language.phrasegroup_posting AS phrasegroup_posting,
    language.phrasegroup_vbblogglobal AS phrasegroup_vbblogglobal,
    language.phrasegroup_postbit AS phrasegroup_postbit,
    language.phrasegroup_vbblogcat AS phrasegroup_vbblogcat,
    language.phrasegroup_inlinemod AS phrasegroup_inlinemod,
    language.options AS lang_options,
    language.languagecode AS lang_code,
    language.charset AS lang_charset,
    language.locale AS lang_locale,
    language.imagesoverride AS lang_imagesoverride,
    language.dateoverride AS lang_dateoverride,
    language.timeoverride AS lang_timeoverride,
    language.registereddateoverride AS lang_registereddateoverride,
    language.calformat1override AS lang_calformat1override,
    language.calformat2override AS lang_calformat2override,
    language.logdateoverride AS lang_logdateoverride,
    language.decimalsep AS lang_decimalsep,
    language.thousandsep AS lang_thousandsep
    , blog_user.bloguserid, blog_user.entries, blog_user.options AS blog_options, blog_user.subscribeown AS blog_subscribeown,
    blog_user.subscribeothers AS blog_subscribeothers, blog_user.title AS blog_title, blog_user.description AS blog_description, blog_user.allowsmilie AS blog_allowsmilie, blog_user.draft AS blog_draft, blog_user.pending AS blog_pending, blog_user.options_everyone, blog_user.options_buddy, blog_user.options_ignore, blog_user.uncatentries, blog_user.moderation AS blog_moderation, blog_user.deleted AS blog_deleted, blog_user.akismet_key AS blog_akismet_key, isblogmoderator, blog_user.comments_moderation AS blog_comments_moderation, blog_user.lastblog, blog_user.lastblogid, blog_user.lastblogtitle, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight
    FROM user AS user
    LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
    LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

    LEFT JOIN blog_user AS blog_user ON (blog_user.bloguserid = user.userid)
    LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid)
    WHERE user.userid = 1;

    MySQL Error : Unknown column 'language.phrasegroup_vbblogcat' in 'field list'
    Error Number : 1054
    Request Date : Friday, April 9th 2010 @ 07:15:46 PM
    Error Date : Friday, April 9th 2010 @ 07:15:46 PM
    Script : http://forum.drunkmanager.com/blog.p...ist&m=1&y=2009
    Referrer :
    IP Address : 78.105.13.80
    Username :
    Classname : vb_database
    MySQL Version :
    Could anyone help please?

    Thanks

  • #2
    In Product Manager, what version of vBulletin Blog does it say you are running?
    My Live vB5 Site - NZEating.com
    vBulletin Hosting | vBulletin Services - Need hosting for your vB? Need it installed? Something else? Let me take that hassle off your hands.

    Comment


    • #3
      Click image for larger version

Name:	error.jpg
Views:	1
Size:	100.3 KB
ID:	3678480

      Here is also a quick screen shot when running a diagnostic check also check the blog menu.

      How do I find the product manager section? I checked everywhere for it.

      Thanks

      Comment


      • #4
        vBulletin Blog 1.0.5 Personal web log, integrated with vBulletin.

        Comment


        • #5
          ok I see there is a later release available. Should I install that?

          Comment


          • #6
            Originally posted by Tomsk View Post
            vBulletin Blog 1.0.5 Personal web log, integrated with vBulletin.
            Hmmm.

            1.0.5 is pretty old.. 2.0.2 should be available to download if your license was active when it was released.
            My Live vB5 Site - NZEating.com
            vBulletin Hosting | vBulletin Services - Need hosting for your vB? Need it installed? Something else? Let me take that hassle off your hands.

            Comment


            • #7
              Originally posted by Tomsk View Post
              ok I see there is a later release available. Should I install that?
              Yes!
              My Live vB5 Site - NZEating.com
              vBulletin Hosting | vBulletin Services - Need hosting for your vB? Need it installed? Something else? Let me take that hassle off your hands.

              Comment


              • #8
                Ok installing now. I thought I installed the latest version today. Maybe this will work.

                Comment


                • #9
                  OK everything was seeming fine untill I hit this page http://forum.drunkmanager.com/blog_usercp.php

                  and this error appeared:
                  Fatal error: Cannot redeclare can_moderate_blog() (previously declared in /home/httpd/html/forum.drunkmanager.com/public_html/includes/blog_functions_shared.php:43) in /home/httpd/html/forum.drunkmanager.com/public_html/includes/blog_functions_shared.php on line 43

                  Comment


                  • #10
                    and now this is emailed:
                    Database error in vBulletin 3.8.5:

                    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_inlinemod AS phrasegroup_inlinemod,
                    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 = 1;

                    MySQL Error : Unknown column 'phrasegroup_vbblogcat' in 'field list'
                    Error Number : 1054
                    Request Date : Friday, April 9th 2010 @ 07:46:02 PM
                    Error Date : Friday, April 9th 2010 @ 07:46:02 PM
                    Script : http://forum.drunkmanager.com/blog.p...ist&m=1&y=2009
                    Referrer :
                    IP Address : 74.218.200.2
                    Username :
                    Classname : vb_database
                    MySQL Version :

                    Comment


                    • #11
                      Actually thanks for the help my host just did something dont know what but all is working now!

                      Right just got to get the forum going! http://forum.drunkmanager.com

                      Comment

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