MySql error after svn 5719 upgraded

[Roger Saffle]

ran svn up , then ./install and it looked like it went well. I am able to login to fog. Able to search for a host. But once I click on a host name I get a webpage that says

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 ‘AND hostMAC.hmHostID= AND hostMAC.hmIgnoreClient= ORDER BY hostMAC.`h’ at line 1

Any ideas? Every thing else seems to work, I can look at printer objects. images, groups.
The sql server seem ok because I can pull it up in webmin and look at a table.

Thanks.

[Wayne Workman]

Moved to bugs.

Tom was working on this bug:
https://forums.fogproject.org/topic/7838/host-import-from-production-fog-system-into-another-production-fog-system

Pretty sure this commit broke it.
https://github.com/FOGProject/fogproject/commit/4407dfe257c015aa62881adcea1845f2683923e3

The @Senior-Developers are aware.

[Roger Saffle]

As always thanks for the fast reply. Network guy (Scott) is out this week. Hell to pay if his manager guy (me) broke his server, LOL

[Tom Elliott]

@Roger-Saffle This should be fixed in latest

[Roger Saffle]

@Tom-Elliott yep all seem fine now. Thanks.
EDIT…May have spoken too soon. PXE is just exiting and starting over. Rebooting fog server now.

[Roger Saffle]

yep. Fog menu never show up. Just starts PXE gets an IP an then reboots.

[adukes40]

@Roger-Saffle I am having something similar. Posted here. https://forums.fogproject.org/topic/7848/sqlstate-42s22/1

upgraded this morning

[Tom Elliott]

@adukes40 @Roger-Saffle please update again.

[Roger Saffle]

@Tom-Elliott same thing. BTW, no need to update both threads. Ill pop over to the other thread since its more on topic

https://forums.fogproject.org/topic/7848/sqlstate-42s22/1