MySql error after svn 5719 upgraded
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: 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
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.
@Tom-Elliott same thing. BTW, no need to update both threads. Ill pop over to the other thread since its more on topic
@Roger-Saffle I am having something similar. Posted here. https://forums.fogproject.org/topic/7848/sqlstate-42s22/1
upgraded this morning
yep. Fog menu never show up. Just starts PXE gets an IP an then reboots.
@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 This should be fixed in latest
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
Moved to bugs.
Tom was working on this bug:
Pretty sure this commit broke it.
The @Senior-Developers are aware.