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

SQLSTATE[42S22]

Scheduled Pinned Locked Moved Solved
FOG Problems
4
32
10.9k
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.
  • A
    adukes40
    last edited by adukes40 Jun 21, 2016, 6:31 AM Jun 21, 2016, 12:13 PM

    Just updated to 8187. I get this error when trying to set the Location on a host. I can set Snapins, and images.

    SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘locationAssoc.’ in ‘where clause’ SQL: [145] SELECT laID FROM locationAssoc WHERE locationAssoc.laLocationID=‘2’ AND locationAssoc.``=‘hostID’ ORDER BY locationAssoc.laID ASC Params: 0

    Also receive error after PXE boot. Chainloading error, but also calls the SQLSTATE error.

    1 Reply Last reply Reply Quote 0
    • R
      Roger Saffle
      last edited by Jun 21, 2016, 12:51 PM

      0_1466513481403_IMG_20160621_084349[1].jpg

      yep same thing

      1 Reply Last reply Reply Quote 0
      • T
        Tom Elliott
        last edited by Jun 21, 2016, 12:53 PM

        Please update. The SQLSTATE error was the location having a bad closing value. It was closing without using the proper information.

        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

        A R 3 Replies Last reply Jun 21, 2016, 12:57 PM Reply Quote 0
        • A
          adukes40 @Tom Elliott
          last edited by Jun 21, 2016, 12:57 PM

          @Tom-Elliott updating now. master almost done, then I will hit nodes. Let you know in a few

          1 Reply Last reply Reply Quote 0
          • R
            Roger Saffle
            last edited by Jun 21, 2016, 1:05 PM

            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
            • A
              adukes40 @Tom Elliott
              last edited by Jun 21, 2016, 1:05 PM

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

              R 1 Reply Last reply Jun 21, 2016, 1:07 PM Reply Quote 0
              • R
                Raymond Bell Testers @adukes40
                last edited by Jun 21, 2016, 1:07 PM

                @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
                • T
                  Tom Elliott
                  last edited by Jun 21, 2016, 2:00 PM

                  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

                  A R 2 Replies Last reply Jun 21, 2016, 2:05 PM Reply Quote 0
                  • A
                    adukes40 @Tom Elliott
                    last edited by Jun 21, 2016, 2:05 PM

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

                    A 1 Reply Last reply Jun 21, 2016, 2:19 PM Reply Quote 0
                    • R
                      Raymond Bell Testers @Tom Elliott
                      last edited by Jun 21, 2016, 2:09 PM

                      @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
                      • A
                        adukes40 @adukes40
                        last edited by adukes40 Jun 21, 2016, 8:20 AM Jun 21, 2016, 2:19 PM

                        @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
                        • R
                          Raymond Bell Testers @Tom Elliott
                          last edited by Jun 21, 2016, 2:22 PM

                          @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
                          • T
                            Tom Elliott
                            last edited by Jun 21, 2016, 2:44 PM

                            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

                            A 2 Replies Last reply Jun 21, 2016, 2:44 PM Reply Quote 1
                            • A
                              adukes40 @Tom Elliott
                              last edited by Jun 21, 2016, 2:44 PM

                              @Tom-Elliott Lol. OK, updating again.

                              1 Reply Last reply Reply Quote 0
                              • A
                                adukes40 @Tom Elliott
                                last edited by Jun 21, 2016, 2:53 PM

                                @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
                                • T
                                  Tom Elliott
                                  last edited by Jun 21, 2016, 2:57 PM

                                  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

                                  A 2 Replies Last reply Jun 21, 2016, 3:09 PM Reply Quote 0
                                  • A
                                    adukes40 @Tom Elliott
                                    last edited by Jun 21, 2016, 3:09 PM

                                    @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
                                    • A
                                      adukes40 @Tom Elliott
                                      last edited by Jun 21, 2016, 3:28 PM

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

                                      1 Reply Last reply Reply Quote 0
                                      • T
                                        Tom Elliott
                                        last edited by Jun 21, 2016, 4:03 PM

                                        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

                                        R 1 Reply Last reply Jun 21, 2016, 4:11 PM Reply Quote 0
                                        • R
                                          Roger Saffle
                                          last edited by Jun 21, 2016, 4:03 PM

                                          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.

                                          T 1 Reply Last reply Jun 21, 2016, 4:04 PM Reply Quote 0
                                          • 1
                                          • 2
                                          • 1 / 2
                                          1 / 2
                                          • First post
                                            18/32
                                            Last post

                                          164

                                          Online

                                          12.0k

                                          Users

                                          17.3k

                                          Topics

                                          155.2k

                                          Posts
                                          Copyright © 2012-2024 FOG Project