Is it me, or it seems that I cannot create groups with a "manually entered" Select sql? Neither 1.0.3 nor 1.1 seem to be sending my manual sql query to the database, and adding the sql query directly in the db doesn't work. If I use the assisted method, is all fine, but I have a complex query and I can't use it.
When I add any sql, this is what I get back [code]Error Number: 1064
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 ' system WHERE .system_id = system.system_id AND = '' AND system.man_status = 'p' at line 1
INSERT INTO oa_group_sys (system_id, group_id, group_sys_type) SELECT DISTINCT(system.system_id), '101', 'system' FROM , system WHERE .system_id = system.system_id AND = '' AND system.man_status = 'production' AND .timestamp = system.timestamp
Filename: C:\wamp\www\code_igniter\system\database\DB_driver.php
Line Number: 330[/code]
Did I break my OA?
_________________ Old OA Setup: 500 Windows 7 workstations & 200 Apple OSX with OA v1.5.2 on Windows Server 2003 and WAMP 2 New OA Setup: 100 Windows servers with OA 2.2 on Windows Server 2016 and WAMP 3
|