Hello,
Sorry for my bad english. Even so, I'm trying to explain my problem
that is very "strange" for me indeed.
My objective is to build a Cake application on top of an existing PHP
WorkFlow Engine, Galaxia (
http://workflow.tikiwiki.org/tiki-index.php).
Even if Galaxia is an extension of TikiWiki, its API allows to
integrate it in another PHP environnement with its own MySQL db. And I
reached this goal with a basic PHP application.
My approach with Cake :
- Creation of a model with "var $useTable = false;" and use of the
vendor() function to include the API located in the vendors directory
- Creation of corresponding controller and view
Problem description :
A call to any Galaxia specific function returns a generic "mysql error"
whithout other comment. This error comes from the adodb-mysql driver
used by Galaxia-Tiki. But before that call, other queries dealing with
environment, preferences and permissions are all OK. The problem is the
same under windows-XP + Wamp or Linux + Lampp.
Thank you for your help.
Denis.
============================
Hereafter the traces of the sequence :
>> Query MySQL : select `value` from `tiki_preferences` where `name`='language' LIMIT 0,1
result : Resource id #60
>> Query MySQL : select `name` ,`value` from `tiki_preferences`
result : Resource id #61
>> Query MySQL : select `userId` from `users_users` where `login`=NULL LIMIT 0,1
result : Resource id #64
>> Query MySQL : select `groupName` from `users_usergroups` where `userId`=-1
result : Resource id #65
>> Query MySQL : select `permName` from `users_grouppermissions` where `groupName`='Anonymous'
result : Resource id #66
>> Query Galaxia : select * from `galaxia_user_roles` order by `pId`,`roleId`
>> Query MySQL : select * from `galaxia_user_roles` order by `pId`,`roleId`
result :
mysql error: in query:
select * from `galaxia_user_roles` order by `pId`,`roleId`
in C:\wamp\www\tikiwiki\lib\Galaxia\src\common\Base.php on line 54
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake PHP" group.
To post to this group, send email to
[hidden email]
To unsubscribe from this group, send email to
[hidden email]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en-~----------~----~----~----~------~----~------~--~---
Locked
