Hi Chris OK that fixed it, which now gets me back to the same error message I had a few months ago when I tried to move to 1.1.1c
I'll forward the last error to your gmail account You may recall that at that point you offered to send sql to identify dup key values looks like this would be a good time to send it! thanks if you can help with this Chris Travers wrote: > Yes. You can drop these tables first. > > On 5/1/07, G. Net <[EMAIL PROTECTED]> wrote: >> yes they both exist. should I delete them? >> >> >> --- Chris Travers <[EMAIL PROTECTED]> wrote: >> >>> the session table and the session_session_id_seq >>> sequence. >>> >>> Do those exist? >>> >>> On 5/1/07, G. Net <[EMAIL PROTECTED]> wrote: >>>> Chris >>>> >>>> thanks for reply, which tables are you wondering >>>> about? >>>> >>>> >>>> --- Chris Travers <[EMAIL PROTECTED]> wrote: >>>> >>>>> If you are upgrading, you don't need to apply >>> our >>>>> fix. And due to >>>>> the other security issues fixed, it probably >>> doesn't >>>>> make any >>>>> difference anyway if you are on SQL-Ledger >>> 2.6.16 >>>>> I was just wondering where the tables came from. >>>>> >>>>> Best Wishes, >>>>> Chris Travers >>>>> >>>>> On 5/1/07, G. Net <[EMAIL PROTECTED]> wrote: >>>>>> Chris >>>>>> >>>>>> thanks for reply >>>>>> >>>>>> --- Chris Travers <[EMAIL PROTECTED]> >>> wrote: >>>>>>> Try dropping the session table and the >>>>>>> session_session_id_seq sequence first. >>>>>> OK >>>>>> >>>>>>> Did you run our security fix in 2.6.16's >>>>> timestamp >>>>>>> issue by any chance? >>>>>> No. where can I find this please? >>>>>> >>>>>>> Best Wishes, >>>>>>> Chris Travers >>>>>>> >>>>>>> On 4/30/07, G. Net <[EMAIL PROTECTED]> >>> wrote: >>>>>>>> HI SL >>>>>>>> >>>>>>>> Am using SL 2.6.16 and have tried >>>>> (unsuccessfuly) >>>>>>>> moving to lsmb some months back. >>>>>>>> >>>>>>>> I decided to have another go. >>>>>>>> >>>>>>>> I found README.sql-ledger and have copied >>>>> files >>>>>>> over >>>>>>>> and run SL2LS.plSL2LS.pl. >>>>>>>> On login I get this error... >>>>>>>> >>>>>>>> Upgrading to Version 1.1.12 ... >>>>>>>> Error! >>>>>>>> >>>>>>>> CREATE SEQUENCE session_session_id_seq >>>>>>>> ERROR: relation "session_session_id_seq" >>>>> already >>>>>>>> exists >>>>>>>> >>>>>>>> >>>>>>>> There is a page on the web site about >>>>> upgrading >>>>>>> from >>>>>>>> SL but no practical stuff there. >>>>>>>> >>>>>>>> what did I miss please? >>>>>>>> >>>>>>>> Thanks >>>>>>>> >>>>>>>> g. >>>>>> >>>>>> >> ------------------------------------------------------------------------- >>>>>> This SF.net email is sponsored by DB2 Express >>>>>> Download DB2 Express C - the FREE version of >>> DB2 >>>>> express and take >>>>>> control of your XML. No limits. Just data. >>> Click >>>>> to get it now. >>>>>> http://sourceforge.net/powerbar/db2/ >>>>>> >>> _______________________________________________ >>>>>> Ledger-smb-users mailing list >>>>>> [email protected] >>>>>> >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >>>>> >> ------------------------------------------------------------------------- >>>>> This SF.net email is sponsored by DB2 Express >>>>> Download DB2 Express C - the FREE version of DB2 >>>>> express and take >>>>> control of your XML. No limits. Just data. Click >>> to >>>>> get it now. >>>>> http://sourceforge.net/powerbar/db2/ >>>>> _______________________________________________ >>>>> Ledger-smb-users mailing list >>>>> [email protected] >>>>> >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >>>> >>>> >> ------------------------------------------------------------------------- >>>> This SF.net email is sponsored by DB2 Express >>>> Download DB2 Express C - the FREE version of DB2 >>> express and take >>>> control of your XML. No limits. Just data. Click >>> to get it now. >>>> http://sourceforge.net/powerbar/db2/ >>>> _______________________________________________ >>>> Ledger-smb-users mailing list >>>> [email protected] >>>> >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >>> >> ------------------------------------------------------------------------- >>> This SF.net email is sponsored by DB2 Express >>> Download DB2 Express C - the FREE version of DB2 >>> express and take >>> control of your XML. No limits. Just data. Click to >>> get it now. >>> http://sourceforge.net/powerbar/db2/ >>> _______________________________________________ >>> Ledger-smb-users mailing list >>> [email protected] >>> >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >> >> ------------------------------------------------------------------------- >> This SF.net email is sponsored by DB2 Express >> Download DB2 Express C - the FREE version of DB2 express and take >> control of your XML. No limits. Just data. Click to get it now. >> http://sourceforge.net/powerbar/db2/ >> _______________________________________________ >> Ledger-smb-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >> > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Ledger-smb-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
