SQL Errors

[Derek Atkins]

I think we've crossed the line into gnucash-devel territory.
All I can think is that CODESET is getting multiply-defined,
or fink isn't pulling in the right langinfo.h, or...  I don't
know.  I've not got a Mac to play with, nor have I ever
built the existing sql backend.

-derek

Perry Smith <pedz at easesoftware.net> writes:

> Small curious update:
>
> A seperate standalone program that calls nl_langinfo works.
>
> #include <langinfo.h>
>
> int main(int argc, char *argv[])
> {
>      char *temp = nl_langinfo(CODESET);
>
>      printf("CODESET = '%s'\n", temp);
>      return 0;
> }
>
> returns:
>
> CODESET = 'US-ASCII'
>
> The above snippet was compiled outside of fink, etc.  Just gcc on a
> normal user command line.
>
> On Jul 15, 2004, at 3:18 PM, Perry Smith wrote:
>
>> The null encoding is coming from a call to nl_langinfo(CODESET)
>> where CODESET appears to be #define to 0 but I"m not sure of that.
>>
>> This is new to me.  I found nl_langinfo doing a google search but,
>> again, I thought if someone has tracked this down before, it would
>> save me time.
>>
>> Thanks,
>> Perry
>> p.s. should we move this to gnucash-devel ?  I subscribed to it as
>> well.
>>
>> On Jul 14, 2004, at 1:15 PM, Derek Atkins wrote:
>>
>>> Well, it looks like it's using an empty "encoding name", whatever
>>> that is.  I've never compiled the pg backend, let alone used it,
>>> so I have no clue.
>>>
>>> -derek
>>>
>>> Perry Smith <pedz at easesoftware.net> writes:
>>>
>>>> This is a run time error.  To recap, the README in the
>>>> backend/postgres directory says to start gnucash with your data file
>>>> and then to do a "Save As" with a path of postgres://localhost/tempdb
>>>> and that will create the database and populate it.
>>>>
>>>> When I do this, I get the errors below.
>>>>
>>>> I'm been digging around and I see there is a set-log-level where you
>>>> can get the code to record the entry and exit of routines.  So far, I
>>>> haven't figured out how to call set-log-level.  Is it hooked up to a
>>>> GUI thingy?  I was just assuming it would be on the command line.
>>>>
>>>> As far as CVS and getting the latest, I'm figuring that the
>>>> backend/postgres code hasn't changed much.  If I actually figure out
>>>> and fix something I'll ask about what to do at that point.
>>>>
>>>> Thanks
>>>> Perry
>>>>
>>>> On Jul 14, 2004, at 11:30 AM, Derek Atkins wrote:
>>>>
>>>>> I dont know if we've ever tested with pg-7.4..
>>>>>
>>>>> Is this a configure-time, build-time, or run-time error?
>>>>> What other errors do you get?
>>>>>
>>>>> -derek
>>>>>
>>>>> PS: If you're building gnucash, you should use 1.8.9 (if not the
>>>>> 1-8-branch from CVS).
>>>>>
>>>>> Perry Smith <pedz at easesoftware.net> writes:
>>>>>
>>>>>> I'm going to start digging into this error but thought I would post
>>>>>> it. (Let me know if this might should be moved to the developers
>>>>>> list).
>>>>>>
>>>>>> I got gnucash rebuilt with --enable-sql.  Now I get:
>>>>>>
>>>>>> ERROR:   is not a valid encoding name
>>>>>>
>>>>>> (plus other errors but I think that is the root cause of the
>>>>>> errors)
>>>>>> when I try to do the initial save as.
>>>>>>
>>>>>> If someone out there can say "Oh... thats XYZ" let me know.
>>>>>> Otherwise, I plan to dig into the source and see what it is
>>>>>> attempting
>>>>>> to do.
>>>>>>
>>>>>> FYI: I have gnucash 1.8.8 and postpresql 7.4.1
>>>>>>
>>>>>> Thank you,
>>>>>> Perry
>>>>>>
>>>>>> _______________________________________________
>>>>>> gnucash-user mailing list
>>>>>> gnucash-user at gnucash.org
>>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>>>>
>>>>>>
>>>>>
>>>>> -- 
>>>>>        Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>>>>>        Member, MIT Student Information Processing Board  (SIPB)
>>>>>        URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>>>>>        warlord at MIT.EDU                        PGP key available
>>>>>
>>>>
>>>>
>>>>
>>>
>>> -- 
>>>        Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>>>        Member, MIT Student Information Processing Board  (SIPB)
>>>        URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>>>        warlord at MIT.EDU                        PGP key available
>>>
>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
>

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available