I think that was already fixed. It always pays to update to GIT HEAD when in doubt. On Sun, Jul 17, 2011 at 2:39 PM, Robert Huddleston <rhuddleston@gmail.com>wrote:
Wondering if I should log this to Jira?
Looks like a recent code addition - so not sure protocol here - also never having logged a Jira before.
In switch_core_sqldb.c there are some PRAGMA calls.
I'm finding that in my MYSQL unixODBC environment - these PRAGMA calls are causing syntax errors.
I'm not familiar with the syntax - I've seen equivalents on MS-SQL and Oracle etc - but never seen such on MYSQL.
http://fisheye.freeswitch.org/changelog/freeswitch.git/?showid=11690aff4c4b8...
Any ideas?
switch_cache_db_execute_sql(sql_manager.event_db, "PRAGMA synchronous=OFF;", NULL); switch_cache_db_execute_sql(sql_manager.event_db, "PRAGMA count_changes=OFF;", NULL); switch_cache_db_execute_sql(sql_manager.event_db, "PRAGMA temp_store=MEMORY;", NULL); switch_cache_db_execute_sql(sql_manager.event_db, "PRAGMA journal_mode=OFF;", NULL);
_______________________________________________ Join us at ClueCon 2011, Aug 9-11, Chicago http://www.cluecon.com 877-7-4ACLUE
FreeSWITCH-dev mailing list FreeSWITCH-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900