Error While Creating Users

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • HugoRoger
    Member
    • Nov 2012
    • 73

    Error While Creating Users

    Hi everyone!

    I need your help again.

    I am trying to create users manually in the fourm but I am getting an error:

    This is the error I get:

    Code:
    Database error in vBulletin 4.2.3:
    
    Invalid SQL:
    INSERT INTO userfield
        (field1, field2, field3, field4, field5, field6, userid)
    VALUES
        ('', '', '', '', 'Yes', 'Yes', 245);
    
    MySQL Error   : Unknown column 'field5' in 'field list'
    Error Number  : 1054
    Request Date  : Friday, February 10th 2017 @ 12:40:56 PM
    Error Date    : Friday, February 10th 2017 @ 12:40:56 PM
    Script        : http://www.iforumelite.com/admincp/user.php?do=update
    Referrer      : https://www.iforumelite.com/admincp/user.php?do=add
    IP Address    : 189.33.122.10
    Username      : admin
    Classname     : vB_Database_MySQLi
    MySQL Version : 5.6.35

    Once I get the error and try to create them, I no longer can because I get a message saying they are created. I try searching for them but I can't find them using search but I can indeed find them in the list of users. I don't know but it seems that it has to do with the recent changes I made going from http to https?

    If you need more information, please let me know.

    Thanks,
    Hugo

    Trying to make a living while helping others! www.beingled.com
  • HugoRoger
    Member
    • Nov 2012
    • 73

    #2
    When I try to post using these user accounts they appear as guests. Please see last post on this page:

    Code:
    https://www.iforumelite.com/showthread.php/286-Pergunta-Como-posso-extender-a-vida-da-bateria-de-meu-telefone-Android?p=857&viewfull=1#post857
    Edit: Tried creating accounts and it seems the database is no longer connected. I'm suspecting the https did something.
    Last edited by HugoRoger; Fri 10 Feb '17, 5:31am.
    Trying to make a living while helping others! www.beingled.com

    Comment

    • Paul M
      Former Lead Developer
      vB.Com & vB.Org
      • Sep 2004
      • 9886

      #3
      That error has nothing to do with http / https.

      You seem to be missing a column in your userfield table, not sure how you have managed that.
      Baby, I was born this way

      Comment

      • HugoRoger
        Member
        • Nov 2012
        • 73

        #4
        Is there a way to rebuild or fix with a rebuild function?
        Trying to make a living while helping others! www.beingled.com

        Comment

        • HugoRoger
          Member
          • Nov 2012
          • 73

          #5
          I tried following the recommendations from this thread.

          Originally posted by Wayne Luke
          You can rebuild the unique indexes in the AdminCP under Maintenance -> Repair / Optimize tables. You will need to make sure the Install directory is uploaded and that your site is in debug mode.

          You can put your site into debug mode by adding this line to your config.php under the <?php line:
          Code:
          $config['Misc']['debug'] = true;

          My forum for some reason just broke completely after running the repair twice, clearing cache and so forth.
          Trying to make a living while helping others! www.beingled.com

          Comment

          • Mark.B
            vBulletin Support
            • Feb 2004
            • 24286
            • 6.0.X

            #6
            We need more information..."broke completely" doesn't tell us anything.
            MARK.B
            vBulletin Support
            ------------
            My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
            My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

            Comment

            • HugoRoger
              Member
              • Nov 2012
              • 73

              #7
              I mean. if you visit the link you will see that its entire structure just corrupted. Makes no sense.

              Code:
               
               https://www.iforumelite.com/
              Trying to make a living while helping others! www.beingled.com

              Comment

              • HugoRoger
                Member
                • Nov 2012
                • 73

                #8
                Getting too many errors such as:

                Unable to add cookies, header already sent.
                File: /home/workinh8/public_html/iforumelite/includes/config.php
                Line: 1

                which wont even let me log in the site.. not even in the admincp.

                entire site structure is broken and invalid..
                Trying to make a living while helping others! www.beingled.com

                Comment

                • HugoRoger
                  Member
                  • Nov 2012
                  • 73

                  #9
                  After two days with a dead forum and unable to fix it I decided to restore using a backup from two weeks ago. I uploaded to my server using:
                  mysql -p -u user_name database_name < file.sql

                  No issues. uploaded.. password inserted okay no errors...

                  but the site still does not work.. not i get both errors. two different errors

                  Have not cleared my cache in one browser and i get this error:

                  Code:
                  Database error in vBulletin 4.2.0:
                  
                  Invalid SQL:
                  
                          SELECT *
                          FROM navigation
                          WHERE state &  = 0
                          ORDER BY navtype, displayorder;
                  
                  MySQL 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 '= 0
                          ORDER BY navtype, displayorder' at line 3
                  Error Number  : 1064
                  Request Date  : Sunday, February 12th 2017 @ 02:36:28 PM
                  Error Date    : Sunday, February 12th 2017 @ 02:36:29 PM
                  Script        : http://www.iforumelite.com/
                  Referrer      : 
                  IP Address    : 189.33.122.10
                  Username      : admin
                  Classname     : vB_Database_MySQLi
                  MySQL Version : 5.6.35
                  when trying to log in to the admincp I get the same error:


                  Code:
                  atabase error in vBulletin 4.2.0:
                  
                  Invalid SQL:
                  
                          SELECT *
                          FROM navigation
                          WHERE state &  = 0
                          ORDER BY navtype, displayorder;
                  
                  MySQL 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 '= 0
                          ORDER BY navtype, displayorder' at line 3
                  Error Number  : 1064
                  Request Date  : Sunday, February 12th 2017 @ 02:39:12 PM
                  Error Date    : Sunday, February 12th 2017 @ 02:39:12 PM
                  Script        : http://www.iforumelite.com/login.php?do=login
                  Referrer      : 
                  IP Address    : 189.33.122.10
                  Username      : admin
                  Classname     : vB_Database_MySQLi
                  MySQL Version : 5.6.35

                  Clearing the cache on the other brwser all I get when trying to attempt anything is:
                  Unable to add cookies, header already sent.
                  File: /home/workinh8/public_html/iforumelite/includes/config.php
                  Line: 1


                  Now I don't know what other guides to read to try to get this most bizar issue resolved which all happened after I simply tried repairing the tables.
                  Trying to make a living while helping others! www.beingled.com

                  Comment

                  • Paul M
                    Former Lead Developer
                    vB.Com & vB.Org
                    • Sep 2004
                    • 9886

                    #10
                    Did you revert to 4.2.0 files ?

                    Your earlier errors suggest you have uploaded 4.2.3 files.
                    They wont run on a 4.2.0 database as the navigation design changed (hence the errors).

                    I suggest you re-run the upgrader.
                    Baby, I was born this way

                    Comment

                    • HugoRoger
                      Member
                      • Nov 2012
                      • 73

                      #11
                      That'e true. It was a back up right before the upgrade. Will run it again.
                      Trying to make a living while helping others! www.beingled.com

                      Comment

                      • HugoRoger
                        Member
                        • Nov 2012
                        • 73

                        #12
                        Did not work. I tried but to not avail.

                        I got this error on the top displaying:

                        Code:
                        [B]Warning[/B]: Cannot modify header information - headers already sent by (output started at /home/workinh8/public_html/iforumelite/includes/config.php:1) in [B]/home/workinh8/public_html/iforumelite/install/includes/class_upgrade_ajax.php[/B] on line [B]745[/B]
                        
                        [B]Warning[/B]: Cannot modify header information - headers already sent by (output started at /home/workinh8/public_html/iforumelite/includes/config.php:1) in [B]/home/workinh8/public_html/iforumelite/install/includes/class_upgrade_ajax.php[/B] on line [B]746[/B]

                        Below I have the run upgrade button. I clicked on it and I got this:




                        Unexpected Text:

                        Code:
                         <?xml version="1.0" encoding="windows-1252"?>
                        <upgrade> <message replace="0">Altering template Table (1 of 1)</message>
                        <status>Status: Processing 4.2.1 Alpha 1, Step 3 of 6</status>
                        <longversion>4.2.1 Alpha 1</longversion> <version>421a1</version> <nextstep>3</nextstep> <upgradenotice><![CDATA[<strong>Upgrading to 4.2.1 Alpha 1</strong>]]></upgradenotice> </upgrade>

                        What should I do?
                        Trying to make a living while helping others! www.beingled.com

                        Comment

                        • HugoRoger
                          Member
                          • Nov 2012
                          • 73

                          #13
                          Originally posted by Paul M
                          Did you revert to 4.2.0 files ?
                          .
                          To answer that question no.. I did not revert. I simply tried loading a database which I had downloaded. No revert was attempted. This is so crazy. :
                          Trying to make a living while helping others! www.beingled.com

                          Comment

                          • Paul M
                            Former Lead Developer
                            vB.Com & vB.Org
                            • Sep 2004
                            • 9886

                            #14
                            Sorry, you are in too much of a mess to sort out by forum posts.
                            You need to log a support ticket, so someone can have a proper look.
                            Baby, I was born this way

                            Comment

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