SQLSTATE[42S22]

[adukes40]

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.

[Roger Saffle]

yep same thing

[Tom Elliott]

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

[adukes40]

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

[Roger Saffle]

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

[adukes40]

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

[Raymond Bell]

@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

[Tom Elliott]

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.

[adukes40]

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

[Raymond Bell]

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

[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:

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

[Raymond Bell]

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

[Tom Elliott]

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

[adukes40]

@Tom-Elliott Lol. OK, updating again.

[adukes40]

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

[Tom Elliott]

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.

[adukes40]

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

[adukes40]

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

[Tom Elliott]

Safe to say this one is solved now?

[Roger Saffle]

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.