• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

    SQLSTATE[42S22]

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    4
    32
    10.8k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Roger SaffleR
      Roger Saffle
      last edited by

      no change for me. Still chain loader error SVN 5722. i just did the main. Ill do the node now.

      1 Reply Last reply Reply Quote 0
      • adukes40A
        adukes40 @Tom Elliott
        last edited by

        @Tom-Elliott Ok, updated all nodes, the Location can be set now, but still getting the SQLSTATE[42000] chainload issue

        Raymond BellR 1 Reply Last reply Reply Quote 0
        • Raymond BellR
          Raymond Bell Testers @adukes40
          last edited by

          @adukes40 said in SQLSTATE[42S22]:

          @Tom-Elliott Ok, updated all nodes, the Location can be set now, but still getting the SQLSTATE[42000] chainload issue

          Confirm this issue … Guest stick in boot loop

          Raymond Bell
          WiKi: https://wiki.fogproject.org/wiki/index.php/Main_Page

          1 Reply Last reply Reply Quote 0
          • Tom ElliottT
            Tom Elliott
            last edited by

            Issue is now fixed, again, please update. This time it’s for sure. Last time the “fix” was to stop a die from occurring by simply removing the “die” element.

            Now the die is left in place so queries can error straight to the user to allow us better finding of issues. Sorry about the issue this caused.

            Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

            Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

            Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

            adukes40A Raymond BellR 2 Replies Last reply Reply Quote 0
            • adukes40A
              adukes40 @Tom Elliott
              last edited by

              @Tom-Elliott OK, updating now, be back in a few

              adukes40A 1 Reply Last reply Reply Quote 0
              • Raymond BellR
                Raymond Bell Testers @Tom Elliott
                last edited by

                @Tom-Elliott Confirm Boot is working now with rev 5723

                Raymond Bell
                WiKi: https://wiki.fogproject.org/wiki/index.php/Main_Page

                1 Reply Last reply Reply Quote 0
                • adukes40A
                  adukes40 @adukes40
                  last edited by adukes40

                  @adukes40 OK, the boot now goes through. However, the host screen now look different and there is a SQL error at the bottome of the page, can’t change location again. Here are some screenshots:

                  0_1466518568135_upload-beea1cf6-ebb0-442d-aba5-835ebd2ad31f

                  This is at the bottom of the above page:

                  SQLSTATE[42000]: Syntax error or access violation: 1064 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 ‘) ORDER BY LOWER(printers.pAlias) ASC’ at line 1 SQL: [103] SELECT pID FROM printers WHERE printers.pID NOT IN () ORDER BY LOWER(printers.pAlias) ASC Params: 0

                  And when changing the location I get this:

                  SQLSTATE[42000]: Syntax error or access violation: 1064 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 ‘) ORDER BY LOWER(modules.name) ASC’ at line 1 SQL: [89] SELECT * FROM modules WHERE modules.id IN () ORDER BY LOWER(modules.name) ASC Params: 0

                  1 Reply Last reply Reply Quote 0
                  • Raymond BellR
                    Raymond Bell Testers @Tom Elliott
                    last edited by

                    @Tom-Elliott @adukes40 Confirm the issue with the host screen

                    Raymond Bell
                    WiKi: https://wiki.fogproject.org/wiki/index.php/Main_Page

                    1 Reply Last reply Reply Quote 0
                    • Tom ElliottT
                      Tom Elliott
                      last edited by

                      Fixed. Again. Better. Faster. Stronger, or something.

                      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                      adukes40A 2 Replies Last reply Reply Quote 1
                      • adukes40A
                        adukes40 @Tom Elliott
                        last edited by

                        @Tom-Elliott Lol. OK, updating again.

                        1 Reply Last reply Reply Quote 0
                        • adukes40A
                          adukes40 @Tom Elliott
                          last edited by

                          @Tom-Elliott Alright, my issues seems to be checking out now. All looks good so far. Thanks Tom!

                          1 Reply Last reply Reply Quote 1
                          • Tom ElliottT
                            Tom Elliott
                            last edited by

                            Update again, I found another issue with imaging that it couldn’t find the right field.

                            This is now fixed, and I think imaging is more important than GUI. Hopefully all will be well.

                            Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                            Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                            Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                            adukes40A 2 Replies Last reply Reply Quote 0
                            • adukes40A
                              adukes40 @Tom Elliott
                              last edited by

                              @Tom-Elliott I was getting ready to say that there was an error Attempting to checkin during deployment. Updating now.

                              1 Reply Last reply Reply Quote 0
                              • adukes40A
                                adukes40 @Tom Elliott
                                last edited by

                                @Tom-Elliott OK, looks like imaging is running now. And the other parts still look good.

                                1 Reply Last reply Reply Quote 0
                                • Tom ElliottT
                                  Tom Elliott
                                  last edited by

                                  Safe to say this one is solved now?

                                  Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                                  Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                  Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                                  Roger SaffleR 1 Reply Last reply Reply Quote 0
                                  • Roger SaffleR
                                    Roger Saffle
                                    last edited by

                                    im seeing some cert errors in my clients after doing all these updates. I went into our all group and hit the cert update button. Is that all I need to do? Doing latest update now.

                                    Tom ElliottT 1 Reply Last reply Reply Quote 0
                                    • Tom ElliottT
                                      Tom Elliott @Roger Saffle
                                      last edited by

                                      @Roger-Saffle You mean invalid security token?

                                      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                                      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                                      Roger SaffleR adukes40A 2 Replies Last reply Reply Quote 0
                                      • Roger SaffleR
                                        Roger Saffle @Tom Elliott
                                        last edited by

                                        @Tom-Elliott yes

                                        1 Reply Last reply Reply Quote 0
                                        • Roger SaffleR
                                          Roger Saffle @Tom Elliott
                                          last edited by

                                          @Tom-Elliott the reboot problem is fixed, yes

                                          1 Reply Last reply Reply Quote 0
                                          • adukes40A
                                            adukes40 @Tom Elliott
                                            last edited by

                                            @Tom-Elliott Just set an image and came back to it in sleep mode. Checked machine and the snapins did not run. I found this in the log:


                                            --------------------------------Authentication--------------------------------

                                            6/21/2016 8:56 AM Client-Info Version: 0.9.12
                                            6/21/2016 8:56 AM Middleware::Communication URL: http://10.103.72.49/fog/management/other/ssl/srvpublic.crt
                                            6/21/2016 8:56 AM Middleware::Authentication ERROR: Could not get security token
                                            6/21/2016 8:56 AM Middleware::Authentication ERROR: Could not find file ‘C:\Windows\system32\token.dat’.
                                            6/21/2016 8:56 AM Data::RSA FOG Server CA cert found
                                            6/21/2016 8:56 AM Data::RSA ERROR: Certificate validation failed
                                            6/21/2016 8:56 AM Data::RSA ERROR: Trust chain did not complete to the known authority anchor. Errors: A required certificate is not within its validity period when verifying against the current system clock or the timestamp in the signed file. (NotTimeValid)
                                            6/21/2016 8:56 AM Middleware::Authentication ERROR: Could not authenticate
                                            6/21/2016 8:56 AM Middleware::Authentication ERROR: Certificate is not from FOG CA
                                            6/21/2016 8:56 AM Service Sleeping for 120 seconds

                                            Tom ElliottT Roger SaffleR 2 Replies Last reply Reply Quote 0
                                            • 1
                                            • 2
                                            • 1 / 2
                                            • First post
                                              Last post

                                            154

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project