Help

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • stephen1976
    Member
    • Oct 2006
    • 64

    Help

    I have submitted a ticket but thought some great person might know oh below this is another small problem.

    Hi i just upgraded my forum http://www.penaltychargesforum.co.uk/ from vb3.8 to vbulletin4 thinking of as i don't use any plugin. at http://www.penaltychargesforum.co.uk cms was acting wired so i uninstalled it and reinstalled it like 5 times. But I have having 2 problems. After reinstall default data doesn't load up(evening after uploading files again). 2nd i tried to reinstall it by using upgrade.php file but getting this error. An unexpected error has occured. Please try again later. If this error continues to occur, please notify the administrator.
    Then i set up a test website which is http://www.penaltychargesforum.co.uk/forum/ moved my all data to it. But at test site i am having problem creating a new article and getting database error which is

    Database error in vBulletin 4.0.0 Beta 3:

    Invalid SQL:
    LOCK TABLES cms_node WRITE, language read;

    MySQL Error : Access denied for user '----------z'@'localhost' to database 'penalty2'
    Error Number : 1044
    Request Date : Thursday, November 19th 2009 @ 11:29:02 PM
    Error Date : Thursday, November 19th 2009 @ 11:29:02 PM
    Script : http://www.penaltychargesforum.co.uk...ews/addcontent
    Referrer : http://www.penaltychargesforum.co.uk/forum/

    Any help would be really appreciated.


    Other small problem in user online its says everyone looking at unknown location

    Last Activity
    User Name
    Location
    IP Address Instant Messaging
    11:34 PM*POLTMCM* Unknown Location
    /member.php?u=22167&22167-BankWhacker

    10:57 PMAtish187 Unknown Location
    /forum.php

    11:11 PMBaroque_No_Monet Unknown Location
    /showthread.php?t=54263&54263-Help-please-running-out-of-time-here
    Last edited by stephen1976; Thu 19 Nov '09, 3:46pm.
  • Lynne
    Former vBulletin Support
    • Oct 2004
    • 26255

    #2
    You won't get support via a support ticket since all the betas of the software are unsupported.

    The database error you have there is because the details in your config.php file are wrong. You need to give that user all permissions for your newly created database.

    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

    • stephen1976
      Member
      • Oct 2006
      • 64

      #3
      hi lynne thanks for you reply *but I am only getting this database error when i click creat new article button.
      *If there's any problem in database user permission config file then why is every thing else working properly .
      am i missing something

      Comment

      • Lynne
        Former vBulletin Support
        • Oct 2004
        • 26255

        #4
        I don't know why you are only getting it then. I suggest you upgrade to beta 4 and see if you continue to have these problems.

        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

        • stephen1976
          Member
          • Oct 2006
          • 64

          #5
          Thanks Lynn, if you was here i kiss you, but then i might get a slap, so i will stick with thank you lol

          Comment

          • stephen1976
            Member
            • Oct 2006
            • 64

            #6
            Database error in vBulletin 4.0.0 Beta 4:

            Invalid SQL:
            SELECT node.nodeid , (node.nodeleft = 1) AS isroot, node.contenttypeid, node.contentid, node.url, node.parentnode,
            (CASE WHEN node.contenttypeid = 47 THEN node.styleid ELSE parent.styleid end ) AS styleid, node.userid,
            (CASE WHEN node.contenttypeid = 47 THEN node.layoutid ELSE parent.layoutid end ) AS layoutid,
            node.publishdate, node.setpublish, node.issection, node.permissionsfrom, node.nodeleft, node.noderight,
            node.userid, node.showtitle, node.showuser, node.showpreviewonly, node.lastupdated, node.showall,
            node.showupdated, node.showviewcount, node.showpublishdate, node.settingsforboth, node.includechildren, node.editshowchildren,
            parent.permissionsfrom as parentpermissions, node.publicpreview, node.comments_enabled , info.description, info.title, info.html_title, info.viewcount, info.creationdate, info.workflowdate, info.keywords,
            info.workflowstatus, info.workflowcheckedout, info.workflowlevelid, info.associatedthreadid, info.creationdate,
            user.username, thread.replycount, sectionorder.displayorder

            FROM cms_node AS node
            INNER JOIN cms_nodeinfo AS info ON info.nodeid = node.nodeid
            LEFT JOIN user AS user ON user.userid = node.userid
            LEFT JOIN thread AS thread ON thread.threadid = info.associatedthreadid
            LEFT JOIN cms_sectionorder AS sectionorder ON sectionorder.sectionid = node.parentnode
            AND sectionorder.nodeid = node.nodeid
            LEFT JOIN cms_node AS parent ON parent.nodeid = node.parentnode

            WHERE node.nodeid = 1;

            MySQL Error : Unknown column 'node.showtitle' in 'field list'
            Error Number : 1054
            Request Date : Friday, November 20th 2009 @ 12:26:18 AM
            Error Date : Friday, November 20th 2009 @ 12:26:18 AM
            Script : http://www.penaltychargesforum.co.uk/content.php
            Referrer : http://www.penaltychargesforum.co.uk/forum.php
            IP Address :
            Username :
            Classname : vB_Database
            MySQL Version : 5.0.87-log


            then reverts back to same problem as on beta 3

            Comment

            • Lynne
              Former vBulletin Support
              • Oct 2004
              • 26255

              #7
              Perhaps you should start again. If you had install problems with beta 3, I don't know that upgrading will help. So, instead of doing an upgrade, just start over.

              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

              • Mike Anime
                Senior Member
                • Oct 2004
                • 1841
                • 3.7.x

                #8
                there is a bets 4 out now with many bug fixes i would give that a shot with a clean install

                Comment

                • stephen1976
                  Member
                  • Oct 2006
                  • 64

                  #9
                  yeah trying that now, fingers crossed

                  Comment

                  • stephen1976
                    Member
                    • Oct 2006
                    • 64

                    #10
                    okay the button to add an article has vanished

                    Comment

                    • akglobal
                      New Member
                      • Oct 2009
                      • 2
                      • 3.8.x

                      #11
                      I have exactly the same error 1044 message. All info on config.php is good and I have upgraded to Beta 4 from Beta 3. Still the same error message. Any help?

                      Comment

                      • reefcorals
                        Member
                        • Nov 2009
                        • 34
                        • 4.0.x

                        #12
                        same here! have this problem also.

                        Comment

                        • murdof
                          New Member
                          • Mar 2005
                          • 12
                          • 3.0.7

                          #13
                          I have the same problem on Vbulletin 4.0.0 (final version) on an upgrade install without any default data.
                          When I try to add a new Section in CMS i get that error.

                          Database error in vBulletin 4.0.0:

                          Invalid SQL:
                          LOCK TABLES cms_node WRITE, language read;

                          MySQL Error : Access denied for user 'vb4'@'localhost' to database 'vb4'
                          Error Number : 1044
                          Classname : vB_Database_MySQLi
                          MySQL Version : 5.1.41-community

                          Maybe the problem is with the mysqli calls and not the mysql ones?
                          Server is on Windows 2003 - PHP is 5.2.12.

                          Anyone got a solution already for this issue?

                          Thanks

                          Comment

                          • Shamil.
                            Senior Member
                            • Feb 2008
                            • 4755
                            • 4.2.X

                            #14
                            Is there any specific reaso why you can't post in the vBulletin 4 forums?
                            Shamil Nunhuck, - Radon Systems Ltd.
                            VPS + Dedicated Server Hosting and Management
                            vBulletin Hosting and Services
                            Server / Website Consultation

                            Comment

                            • 04wayne
                              Senior Member
                              • Jul 2009
                              • 424
                              • 6.0.X

                              #15
                              Also, is there any specific reason that you're using Beta's - why not Gold?

                              Comment

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