Hello,
On 25/03/15 11:37, Janoz wrote:
> Thank you Daniel.
>
> As correctly stated by canuck15, this problem arises by using the reserved
> (in MySql) word "group" as a name of a table. You can circumvent this by
> adding back ticks around this reserved word, but I'd rather change this
> reserved
Thank you Daniel.
As correctly stated by canuck15, this problem arises by using the reserved
(in MySql) word "group" as a name of a table. You can circumvent this by
adding back ticks around this reserved word, but I'd rather change this
reserved word in a future release.
Anyway, the solution you
Hello,
On 24/03/15 18:03, Janoz wrote:
> I am having the same error here, applying the back ticks patch is not
> working. Looks like the back ticks are not finding their way to the SQL
> quesry, as I get this error:
>
> [2015-03-24 16:41:38 (GMT)] An exception occurred while executing this
> scri
Looks like there is another place used to return the "group" table name.
Once I get some time, I am going to look at the code and try to spot the
place where backticks have to be added for "group".
Cheers,
Daniel
On 24/03/15 15:41, canuck15 wrote:
> Thanks for the suggestion.
>
> It doesn't seem
I am having the same error here, applying the back ticks patch is not
working. Looks like the back ticks are not finding their way to the SQL
quesry, as I get this error:
[2015-03-24 16:41:38 (GMT)] An exception occurred while executing this
script:
Error message: #0, Error in query:: *SELECT T0.i
Thanks for the suggestion.
It doesn't seem to work. It produces the following query.
SELECT T0.id, T0.name, T0.description FROM group T0 INNER JOIN
`user_group` TX ON TX.group_id = T0.id WHERE TX.user_id = '1'
On 3/23/2015 2:59 PM, Daniel-Constantin Mierla wrote:
The right solution is to enc
The right solution is to enclose the table name in between the
quotations marks that allow any value there, including the reserved
keywords.
In mysql you can use the back ticks, e.g:
SELECT * FROM `group`;
The above will just work. But is not standard SQL, just mysql specific.
That was the purpo
Ok, so the complete fix is:
edit ...openbiz/bin/data/BizDataSql.php
go to line 237
replace the line with.
$xtable = $assoc["XTable"];
mysql -p
> USE siremis;
> RENAME TABLE group TO grouptable;
Or pick some other new name for the group table.
edit ..siremis/modules/system/do
Go through all t
Hi,
I figured that part out which is when I got the database error about the
"group" table. So I will need to find where to change that table name.
I should have mentioned that.
On 3/23/2015 1:18 AM, Daniel-Constantin Mierla wrote:
The issue is calling a function which is not member of the
The issue is calling a function which is not member of the object
referred to.
We will look into fixing it properly, for the moment do following changes:
- editi the file: /var/www/html/openbiz/bin/data/BizDataSql.php
- go to line 237
- replace the line with:
$xtable = $assoc["XTable"];
Thanks
I think I found the root cause.
Siremis database has a table called "group". That is a reserved word in
mysql that cannot be used as a table name.
http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html
Do the following to prove it.
mysql
> USE siremis;
> SELECT * FROM group;
error
> REN
When you add/update/view Administrator usernames
To reproduce
Administration > User Management >
Click on any existing username. The browser goes blank.
Error in apache logs is:
PHP Fatal error: Call to a member function getQuoted() on a non-object
in /var/www/html/openbiz/bin/data/BizDataSql
12 matches
Mail list logo
