[Freeswitch-dev] switch_core_sqldb.c

[Anthony Minessale]

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 at 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=11690aff4c4b819e981c4763abff37c33700f5ab&view=fe
>
> 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 at 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 at hotmail.com
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org
googletalk:conf+888 at conference.freeswitch.org
pstn:+19193869900
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-dev/attachments/20111025/1895f6f5/attachment.html