SQL Errors
Perry Smith
pedz at easesoftware.net
Thu Jul 15 16:59:42 EDT 2004
I'm checking out IBM's nl_langinfo code to see what it does (what does
it look at... LANG? NLSPATH?)
I have only one langinfo.h on my system but I may have a library in the
fink system somewhere that I'm linking to instead of Apple's.
Still exploring...
On Jul 15, 2004, at 3:49 PM, Derek Atkins wrote:
> 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
>
More information about the gnucash-devel
mailing list