[quote=“Rick Urdahl, post: 39127, member: 27117”]I am getting an error when doing the install update SQL from the webpage.
[CODE]Database Schema Installer / Updater
Update/Install Failed!
The following errors occured
Update ID: 1 - 10
Database Error:
Incorrect integer value: ‘’ for column ‘uId’ at row 1
Database SQL:
INSERT INTO fog.users VALUES (‘’,‘fog’, MD5(‘password’),‘0000-00-00 00:00:00’,‘’)
Update ID: 1 - 11
Database Error:
Incorrect integer value: ‘’ for column ‘osID’ at row 1
Database SQL:
INSERT INTO fog.supportedOS VALUES (‘’,‘Windows XP’, ‘1’)
Update ID: 1 - 12
Database Error:
Incorrect integer value: ‘’ for column ‘vID’ at row 1
Database SQL:
INSERT INTO fog.schemaVersion VALUES (‘’,‘1’)
Update ID: 2 - 0
Database Error:
Incorrect integer value: ‘’ for column ‘osID’ at row 1
Database SQL:
INSERT INTO fog.supportedOS VALUES (‘’,‘Windows Vista’, ‘2’)
Update ID: 5 - 2
Database Error:
Incorrect integer value: ‘’ for column ‘osID’ at row 1
Database SQL:
INSERT INTO fog.supportedOS VALUES (‘’,‘Other’, ‘99’)
Update ID: 16 - 9
Database Error:
Field ‘ngmKey’ doesn’t have a default value
Database SQL:
INSERT INTO
fog.nfsGroupMembers
(ngmMemberName, ngmMemberDescription, ngmIsMasterNode, ngmGroupID, ngmRootPath, ngmIsEnabled, ngmHostname, ngmMaxClients, ngmUser, ngmPass)
VALUES
(‘DefaultMember’, ‘Auto generated fog nfs group member’, ‘1’, ‘1’, ‘/images/’, ‘1’, ‘192.168.1.176’, ‘10’, ‘fog’, ‘’)[/CODE]
FOG Version: v1.2.0
OS Version: openSUSE 13.1 (x86_64)
Can you provide your installation details? Yes, below is the contents of /var/log/foginstall.log
Have you checked your apache error logs? Can you provide information from these logs?
/var/log/apache2/error_log
[CODE][Sun Nov 16 17:04:00.162488 2014] [php5:error] [pid 10355] [client X.X.X.X:38018] PHP Warning: array_key_exists() expects parameter 2 to be array, null given in /srv/www/htdocs/fog/lib/db/MySQL.class.php on line 150, referer: http://X.X.X.X/fog/commons/schemaupdater/index.php?redir=1
[/CODE]
Debian based Location (normally)
/var/log/apache2/error.log
Redhat based Location (normally)
/var/log/httpd/error_log
Have you searched the forums for your issue yet? Yes, and they have been very helpful. I
Have you checked the wiki yet? Yes, and they have been very helpful.
Kernel Issues: [url]http://fogproject.org/wiki/index.php/FAQ[/url][/quote]
You’ve ensured iptables and/or firewall and selinux is disabled?
It sounds like it’s not passing info to the database (more like the database isn’t accessible.)