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[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= ANDhostMAC.hmIgnoreClient= ORDER BYhostMAC.`h’ at line 1Any 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.
-
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-systemPretty sure this commit broke it.
https://github.com/FOGProject/fogproject/commit/4407dfe257c015aa62881adcea1845f2683923e3The @Senior-Developers are aware.
-
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
-
@Roger-Saffle This should be fixed in latest
-
@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. -
yep. Fog menu never show up. Just starts PXE gets an IP an then reboots.
-
@Roger-Saffle I am having something similar. Posted here. https://forums.fogproject.org/topic/7848/sqlstate-42s22/1
upgraded this morning
-
@adukes40 @Roger-Saffle please update again.
-
@Tom-Elliott same thing. BTW, no need to update both threads. Ill pop over to the other thread since its more on topic