Announcement

Collapse
No announcement yet.

problem with user profile

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

  • problem with user profile

    Hi when i want view the profile the any user this database error appear, mmm i can restore a user profile ?

    thanks


    PHP Code:
    Database error in vBulletin 3.6.8:

    Invalid SQL:

            
    SELECT FROM profilefieldcategory
            ORDER BY displayorder
    ;

    MySQL Error  Table 'desconectadoz.profilefieldcategory' doesn't exist
    Error Number : 1146
    Date         : Friday, December 14th 2007 @ 11:51:08 PM
    Script       : http://www.desconectados.net/admincp/profilefield.php?do=modify
    Referrer     : http://www.desconectados.net/admincp/index.php?do=nav
    IP Address   : 201.240.242.59
    Username     : desconectado
    Classname    : vb_database 



  • #2
    You are missing one of the default tables (profilefieldcategory). Did you recently upgrade to 3.6.x? If so, make sure you ran the "install/upgrade.php" file to completion. Otherwise you can manually add the missing table by running this query:

    CREATE TABLE profilefieldcategory (
    profilefieldcategoryid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
    displayorder SMALLINT NOT NULL DEFAULT '0',
    PRIMARY KEY (profilefieldcategoryid)
    )

    Comment


    • #3
      hi how i run this query ... sorry i am a newbie

      Comment


      • #4
        To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:

        // ****** USERS WITH QUERY RUNNING PERMISSIONS ******
        // The users specified here will be allowed to run queries from the control panel.
        // See the above entries for more information on the format.
        // Please note that the ability to run queries is quite powerful. You may wish
        // to remove all user IDs from this list for security reasons.
        $config['SpecialUsers']['canrunqueries'] = 'x';


        ...with x being your userid number.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          Hi!

          i did that .. mm and look!

          Ha ocurrido un error mientras se intentaba ejecutar tu consulta. La siguiente información fue devuelta.
          número de error: 1064
          descripción del error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Reply With Quote' at line 6

          Comment


          • #6
            It looks like the ; is missing. Try this:

            CREATE TABLE profilefieldcategory (
            profilefieldcategoryid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
            displayorder SMALLINT NOT NULL DEFAULT '0',
            PRIMARY KEY (profilefieldcategoryid)
            );
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment


            • #7


              now this

              Ha ocurrido un error mientras se intentaba ejecutar tu consulta. La siguiente información fue devuelta.
              número de error: 1064
              descripción del error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
              Reply With Quote' at line 5

              Comment


              • #8
                That query is correct. I just tried it myself. Make sure you copy-n-paste it exactly.
                Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                Change CKEditor Colors to Match Style (for 4.1.4 and above)

                Steve Machol Photography


                Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                Comment


                • #9
                  check, I paste this

                  http://img177.imageshack.us/img177/8...sqldescqk0.png

                  same

                  Ha ocurrido un error mientras se intentaba ejecutar tu consulta. La siguiente información fue devuelta.
                  número de error: 1064
                  descripción del error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
                  Reply With Quote' at line 5

                  Comment


                  • #10
                    Delete the last line. You have copied too much and have the extra text Reply With Quote on the last line that you have pasted.
                    Kerry-Anne :)

                    Twitter Blog

                    www.peterska2.com www.worldnewszone.com www.popularusenetgroups.com www.superclickers.co.uk www.forumsforchrist.com www.browsergameplanet.com

                    Comment


                    • #11
                      my bad! sorry ... I did again and check

                      http://img176.imageshack.us/img176/2...sqldescvj4.png

                      but when I want view the profile... show me that.

                      http://img510.imageshack.us/img510/3...abaseereb3.png

                      Comment


                      • #12
                        Please submit a support ticket then we can look into this.
                        http://www.vbulletin.com/members/mem...ontactform.php
                        Kerry-Anne :)

                        Twitter Blog

                        www.peterska2.com www.worldnewszone.com www.popularusenetgroups.com www.superclickers.co.uk www.forumsforchrist.com www.browsergameplanet.com

                        Comment

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