<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
I think I found the root cause.<br>
<br>
Siremis database has a table called "group". That is a reserved
word in mysql that cannot be used as a table name.<br>
<a class="moz-txt-link-freetext" href="http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html">http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html</a><br>
<br>
Do the following to prove it.<br>
mysql<br>
> USE siremis;<br>
> SELECT * FROM group;<br>
<br>
error<br>
<br>
> RENAME TABLE group TO group1;<br>
> SELECT * FROM group1;<br>
<br>
no error<br>
<br>
<div class="moz-cite-prefix">On 3/21/2015 4:39 PM, canuck15 wrote:<br>
</div>
<blockquote
cite="mid:BLU436-SMTP9166C1D95F4229D900C771DA0F0@phx.gbl"
type="cite">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
When you add/update/view Administrator usernames<br>
<br>
To reproduce<br>
Administration > User Management ><br>
<br>
Click on any existing username. The browser goes blank.<br>
<span style="color: rgb(51, 51, 51); font-family: 'Helvetica
Neue', Helvetica, 'Segoe UI', Arial, freesans, sans-serif;
font-size: 14px; font-style: normal; font-variant: normal;
font-weight: normal; letter-spacing: normal; line-height:
22.3999996185303px; orphans: auto; text-align: start;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px;
display: inline !important; float: none; background-color:
rgb(255, 255, 255);"><br>
Error in apache logs is:</span><br style="box-sizing:
border-box; color: rgb(51, 51, 51); font-family: 'Helvetica
Neue', Helvetica, 'Segoe UI', Arial, freesans, sans-serif;
font-size: 14px; font-style: normal; font-variant: normal;
font-weight: normal; letter-spacing: normal; line-height:
22.3999996185303px; orphans: auto; text-align: start;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px;
background-color: rgb(255, 255, 255);">
<span style="color: rgb(51, 51, 51); font-family: 'Helvetica
Neue', Helvetica, 'Segoe UI', Arial, freesans, sans-serif;
font-size: 14px; font-style: normal; font-variant: normal;
font-weight: normal; letter-spacing: normal; line-height:
22.3999996185303px; orphans: auto; text-align: start;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px;
display: inline !important; float: none; background-color:
rgb(255, 255, 255);">PHP Fatal error: Call to a member function
getQuoted() on a non-object in
/var/www/html/openbiz/bin/data/BizDataSql.php on line 237</span><br
style="box-sizing: border-box; color: rgb(51, 51, 51);
font-family: 'Helvetica Neue', Helvetica, 'Segoe UI', Arial,
freesans, sans-serif; font-size: 14px; font-style: normal;
font-variant: normal; font-weight: normal; letter-spacing:
normal; line-height: 22.3999996185303px; orphans: auto;
text-align: start; text-indent: 0px; text-transform: none;
white-space: normal; widows: 1; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
255);">
<span style="color: rgb(51, 51, 51); font-family: 'Helvetica
Neue', Helvetica, 'Segoe UI', Arial, freesans, sans-serif;
font-size: 14px; font-style: normal; font-variant: normal;
font-weight: normal; letter-spacing: normal; line-height:
22.3999996185303px; orphans: auto; text-align: start;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px;
display: inline !important; float: none; background-color:
rgb(255, 255, 255);">This is on the latest Siremis v4.2.0
downloaded today</span><br>
<br>
I am using CentOS v6.6, php v5.3.3<br>
<br>
</blockquote>
<br>
</body>
</html>