Loading...
 
Galaxia Workflow Engine

Galaxia Workflow Engine


SQL Error?

Hello!

I have installed Galaxia but I can do nothing with it. I was able to create a simple proccess, but from there I can go nowhere. I cannot access the Activities page, for example. I get this error:

PHP Warning: mysql error: 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 '' at line 1 in query:
select actFromId from galaxia_transitions where actToId=
in G:\virtuais1\gnosisbr\tiki\lib\Galaxia\src\common\Base.php on line 52

I am using Tiki 1.9.4 with MySQL (I do not know the version, it's a hosted server... but I deem it is current enough) and M$ IIS (sorry, can do nothing about it and it gives me a lot of problems :-( ). if MySQL version info is indispensable, I'll go after it.

Thanks for any help!

p.s. It seems that one of the guys behind Galaxia, georger_br is brazilian as me. Georger_br, se vc estiver "na escuta" e puder ajudar, agradeço antecipadamente.

I don't like Galaxia bugs. Since all the errors are thrown from Base.php line 52, it makes even finding the culprit file insanely difficult. Anywho, I've fixed a number of SQL related bugs in the tiki workflow engine. It mainly has to do with the fact that the query is using the full name of the table, then assigns an alias to it in another part of the query. Just change the SQL to keep it consistent. This happened to me while trying to delete a workflow. Hope it helps.



> Hello!
>
> I have installed Galaxia but I can do nothing with it. I was able to create a simple proccess, but from there I can go nowhere. I cannot access the Activities page, for example. I get this error:
>
> PHP Warning: mysql error: 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 '' at line 1 in query:
> select actFromId from galaxia_transitions where actToId=
> in G:\virtuais1\gnosisbr\tiki\lib\Galaxia\src\common\Base.php on line 52
>
> I am using Tiki 1.9.4 with MySQL (I do not know the version, it's a hosted server... but I deem it is current enough) and M$ IIS (sorry, can do nothing about it and it gives me a lot of problems :-( ). if MySQL version info is indispensable, I'll go after it.
>
> Thanks for any help!
>
> p.s. It seems that one of the guys behind Galaxia, georger_br is brazilian as me. Georger_br, se vc estiver "na escuta" e puder ajudar, agradeço antecipadamente.


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting