sql-ledger-users — SQL-Ledger users

Re: [SL] Receipt Printers

[Michael H. <mh...@it...>]

Virtually all label printers are compatible with the old ESC command  
set, which means they'll work under Linux as a "generic" printer even  
if there isn't a specific driver available.


Thanks,

Michael


On Jun 1, 2008, at 12:46 PM, Jeff Kowalczyk wrote:

> --- George Osvald <geo...@ya...> wrote:
>> I am using DYMO thermal label writer without a problem on Linux.
>> It is really cheap and it runs perfectly.
>
> George, which DYMO thermal printer model(s) have you used and/or  
> know to be
> compatible with Linux?
>
> Thanks.
>
>
>
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Receipt Printers

[Jeff K. <jt...@ya...>]

--- George Osvald <geo...@ya...> wrote:
> I am using DYMO thermal label writer without a problem on Linux.
> It is really cheap and it runs perfectly.

George, which DYMO thermal printer model(s) have you used and/or know to be
compatible with Linux?

Thanks.


      

Re: [SL] Syntax Error

[Peter D. <mer...@ma...>]

Hi,
Thanks for advise. Tried to move to postgres 8.3 but in the end still got the same error posting sales invoice.
Reinstalled mandriva2008 and sql-ledger functioning fine without any errors.
I think that only significant changes in mandriva2008.1 affecting functionality of sql-ledger was upgrade of perl, perl-DBI and perl-DBD-pg. So as other people mentioned on this thread that there must be some incompatibility with above newer libraries

Thanks
Peter
> ----- Original Message -----
> From: "Adrian Blake" <adr...@ie...>
> To: sql...@li...
> Subject: Re: [SL] Syntax Error
> Date: Wed, 28 May 2008 20:53:59 +1000
> 
> 
> Last weekend I did the same upgrade, Mandriva 2008 to Mandriva 
> 2008.1 (Spring).
> 
> First is did a backup from SQL-Ledger to create a file 
> ¨arblake2-2.8.14-20080525.sql¨. I also did a complete copy of
> /var/lib/pgsql and /usr/local/sql-ledger.
> 
> Next a total install of Mandriva 2008.1
> 
> I installed Postgres (version 8.3) and all software as in the 
> SQL-Ledger  ¨README¨
> 
> Next installed SQL-Ledger and copied in my users and templates, 
> just like doing an update of sql-Ledger, etc
> 
> Follow the ¨README¨
> 
> As user postgres:
> 
> createuser -d sql-ledger
> 
> createlang plpgsql template1
> 
> Follow the ¨README¨
> 
> http://localhost/sql-ledger/admin.pl
> 
> This should show the details of your old database. including the  
> dataset name, e.g. newdb
> 
> create a blank database and restore the data.
> 
> psql -U sql-ledger -c "create database newdb;" template1
> psql -U sql-ledger newdb < arblake2-2.8.14-20080525.sql
> 
> Now all should be working.
> 
> I hope I have included all the steps.
> 
> 
> 
> Peter Dabrowski wrote:
> > Hi,
> > Upgraded my mandriva to 2008.1 spring from 2008 and got this 
> > error during posting sales invoice.
> > Database postgresql 8.27 previous was 8.26 DBD pg was updated too 
> > by increment.
> > I was running sql-ledger 8.13 upgraded to 8.14 but no change. 
> > Should I move to postgres 8.3 ?
> >
> > DBD::Pg::db do failed: ERROR: syntax error at or near ")"
> > LINE 4: '11/05/2008', NULL, )
> > ^ at SL/IS.pm line 1077.
> > Error!
> >
> > INSERT INTO acc_trans (trans_id, chart_id, amount,
> > transdate, project_id, id)
> > VALUES (11246, 10032, 138.17,
> > '11/05/2008', NULL, )
> > ERROR: syntax error at or near ")"
> > LINE 4: '11/05/2008', NULL, )
> > ^
> >
> > Thanks
> > Peter
> >
> >
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

>


-- 
Mail.com Autos- Powered by Oncars.com: Drive By Today!
http://www.oncars.com 

Re: [SL] Receipt Printers

[George O. <geo...@ya...>]

On Saturday 31 May 2008, Andrew @ ATM Logic wrote:
> I am also wondering, I have a few serial recipt printers I would love to
> try.  Mine are "ITHACA SERIES 90 RECEIPT PRINTERS ITH-93S"

All you need to do is to set up the reciept printer for your operating system 
and then adjust the receipt tremplate for optimal nuber of lines. I am using 
DYMO thermal label writer without a problem on Linux. It is really cheap and 
it runs perfectly.

> > -----Original Message-----
> > From: sql...@li...
> > [mailto:sql...@li...] On
> > Behalf Of Michael Anderson
> > Sent: Monday, May 26, 2008 7:19 PM
> > To: SQL-Ledger
> > Subject: [SL] Receipt Printers
> >
> > I see that SQL-Ledger will be supporting receipt printers.
> > Does anyone know what models are supported?  I'm trying to
> > get a handle on overall costs so that I can budget for both
> > the till and getting the support for SQL-Ledger.
> > --------------------------------------------------------------
> > -----------
> > This SF.net email is sponsored by: Microsoft Defy all
> > challenges. Microsoft(R) Visual Studio 2008.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users



-- 
George
AUSTRALIA
http://www.okstudio.com.au

Re: [SL] Adding new part from New assembly page creates apache error.

[Dieter S. <dsi...@sq...>]

If Apache croaks because of a URL limitation set the dropdown limit to 0.


On Fri, 30 May 2008, Roy W Pennington wrote:

> On May 29, 2008, Mark J. Small wrote:
>
>> And the previous line looks like it has all the info for the assembly.  It
>> also lists ALL of my customers, which for privacy reasons I don't want to
>> show, but I imagine that this is what is causing the line to be too long.
>
>
> This is normal.
> The HTML of the page has all the names available in the drop down list not just the one that is currently selected on the screen.
>
> Can't help on your error though...
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Adding new part from New assembly page creates apache error.

[Mark J. S. <ms...@ea...>]

On May 30, 2008, Roy W Pennington wrote:
> On May 29, 2008, Mark J. Small wrote:
> > And the previous line looks like it has all the info for the assembly. 
> > It also lists ALL of my customers, which for privacy reasons I don't want
> > to show, but I imagine that this is what is causing the line to be too
> > long.
>
> This is normal.
> The HTML of the page has all the names available in the drop down list not
> just the one that is currently selected on the screen.
>
> Can't help on your error though...
>
>

Yes, but it looks like it is in the URL, or a filename.  Is the page source 
embedded in a filename?

Mark

[SL] Trend analysis

[Munroe S. <so...@di...>]

I am wondering how people perform trend analysis?

I am looking to graph my AR and AP and different journals  etc...  It
looks like sql-ledger has some very standard reports built-in but is
there another tool that people use other than a spreadsheet?

-- 
Munroe Sollog
Systems Engineer
Digirati Consulting, Inc
so...@di...

Re: [SL] Adding new part from New assembly page creates apache error.

[Roy W P. <arc...@mt...>]

On May 29, 2008, Mark J. Small wrote:

> And the previous line looks like it has all the info for the assembly.  It 
> also lists ALL of my customers, which for privacy reasons I don't want to 
> show, but I imagine that this is what is causing the line to be too long.


This is normal.
The HTML of the page has all the names available in the drop down list not just the one that is currently selected on the screen.

Can't help on your error though...

Re: [SL] Receipt Printers

[Andrew @ A. L. <atm...@km...>]

I am also wondering, I have a few serial recipt printers I would love to
try.  Mine are "ITHACA SERIES 90 RECEIPT PRINTERS ITH-93S" 

> -----Original Message-----
> From: sql...@li... 
> [mailto:sql...@li...] On 
> Behalf Of Michael Anderson
> Sent: Monday, May 26, 2008 7:19 PM
> To: SQL-Ledger
> Subject: [SL] Receipt Printers
> 
> I see that SQL-Ledger will be supporting receipt printers.  
> Does anyone know what models are supported?  I'm trying to 
> get a handle on overall costs so that I can budget for both 
> the till and getting the support for SQL-Ledger.
> --------------------------------------------------------------
> -----------
> This SF.net email is sponsored by: Microsoft Defy all 
> challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] Adding new part from New assembly page creates apache error.

[Mark J. S. <ms...@ea...>]

Hi everybody.

I recently updated to 2.8.14 from 2.6.X, and also moved my database to a 
different server.

I was adding a new assembly today, and it includes a couple of new parts.

Previously, if I put a new part number in the assembly, it gave me the add 
part/add service option, and I'd create the new part, save it, and be sent 
back to the new assembly page.

Now when I do this, I get:

Internal Server Error
 The server encountered an internal error or misconfiguration and was unable 
to complete your request.
 Please contact the server administrator, yo...@yo...dress and inform them of 
the time the error occurred, and anything you might have done that may have 
caused the error.
 More information about this error may be available in the server error log

Checking my apache logs, I see a real mess.  The last line is 
Premature end of script headers: /usr/local/www/sql-ledger/ic.pl

And the previous line looks like it has all the info for the assembly.  It 
also lists ALL of my customers, which for privacy reasons I don't want to 
show, but I imagine that this is what is causing the line to be too long.

The new part DOES get created, since I now have 8 copies of the Western 
Digital 320 GB SATA drive in my parts list (oops).

If I create the parts first, then the assembly, everything works fine.  So I 
can work around.

Mark

Re: [SL] Receipt Printers

[George O. <geo...@ya...>]

On Tuesday 27 May 2008, Michael Anderson wrote:
> I see that SQL-Ledger will be supporting receipt printers.  Does anyone
> know what models are supported?  I'm trying to get a handle on overall
> costs so that I can budget for both the till and getting the support for

It will support whatever your operating system does.


> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users



-- 
George
AUSTRALIA
http://www.okstudio.com.au

[SL] Statement Variables

[Shawn J. <sh...@cs...>]

Hi Guys,

I'm busy setting up my statements. I would like at add a column that
indicated payments, and also add a line that indicated a balance brought
forward.

I had a look in the manual, and it doesn't seem to explain how to do this,
and I've also had a look at wiki.ledger123.com where is refers to a <%paid%>
variable. But I can't get the paid variable to work.

Has someone got a statement running like this? If so, could you perhaps show
me the variables that you are using?

Thanks in advance,

Shawn

Re: [SL] Postgres replication

[<la...@cl...>]

Dear Dr.

Yes, we do need the data near real time and it seems that Postgres is
currently working on a readable hot standby so if you can wait may be it
is a good idea to deploy the readable hot standby when it is available. We
are probably going to head down the direction of Slony-I and there is a
catch with it as it does require the replicated tables to have a primary
key. That probably shouldn't be an issue as it may be alright to add a
primary key if there isn't one by the way of composite pirmay key or just
plain adding a new column.

BTW, as for the steps there are more then a few...

http://slony.info/documentation/

Regards,

Tim

> With sufficient bandwidth it'll be trivial to pg_dump every hour or even
> more often. But that does not solve the issue of having access to the
> invoice data in real time.
>
> ANd, I don't think setting someting up is overkill because you only
> do it once. Unless of course the learning curve is very steep and/or
> the overhead is large.
>
> If someone comes up with a plan, please publish the cookbook on how
> to do it :-)-O
>
> MySQL has got this feature too, hasn't it?
>
> el
>
> on 5/28/08 3:27 PM Adam Vandemore said the following:
>> la...@cl... wrote:
>>> hello all...our business has now the need to replicate our sl/postgres
>>> db
>>> from our main office in ca to ny as the ny system (public and outside
>>> of
>>> our firewall) has the need to generate non-critical read only invoice
>>> and
>>> inventory reports. our requirements are real simple and slony-i seems
>>> to
>>> be an overkill. we have also evaluated pgpool-ii but it was ruled out
>>> as
>>> it doesn't support x509 ssl connection (a must for business data).
>>> oralce
>>> and informix would have been nice as they both provide standby
>>> read-only
>>> databases that are very simple to manage. it is too bad that you cannot
>>> access a standby postgres database.
>>>
>>> so my question is anyone has any comments on what other tools out there
>>> that may allow us to create a postgres standby read-only database? if
>>> nothing we may just have to walk down the slony-i path...thanks ahead
>>> for
>>> any comments.
>>>
>>> regards,
>>>
>>> tim
>> If you go the route you intent on, I'd guess slony is your best option.
>> Of course there are other ways to do this too, like manually scripting a
>> db export import daily.
>>
>> However with knowing just the info you provided, setting up a
>> master-slave itself seems like overkill.  What about a VPN?  Or setting
>> up SL on it's own host?  My SL server isn't sharing it's IP with other
>> domains, so for me a default to deny firewall covers virtually all my
>> security needs.  You can always run SSL on it if you like.
>>
>
> --
> Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
> el...@li... el108-ARIN / *     |   Telephone: +264 81 124 6733 (cell)
> PO Box 8421             \     /   Please do NOT email to this address
> Bachbrecht, Namibia     ;____/        if it is DNS related in ANY way
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Postgres replication

[Dr E. L. <el...@li...>]

With sufficient bandwidth it'll be trivial to pg_dump every hour or even
more often. But that does not solve the issue of having access to the
invoice data in real time.

ANd, I don't think setting someting up is overkill because you only
do it once. Unless of course the learning curve is very steep and/or
the overhead is large.

If someone comes up with a plan, please publish the cookbook on how
to do it :-)-O

MySQL has got this feature too, hasn't it?

el

on 5/28/08 3:27 PM Adam Vandemore said the following:
> la...@cl... wrote:
>> hello all...our business has now the need to replicate our sl/postgres db
>> from our main office in ca to ny as the ny system (public and outside of
>> our firewall) has the need to generate non-critical read only invoice and
>> inventory reports. our requirements are real simple and slony-i seems to
>> be an overkill. we have also evaluated pgpool-ii but it was ruled out as
>> it doesn't support x509 ssl connection (a must for business data). oralce
>> and informix would have been nice as they both provide standby read-only
>> databases that are very simple to manage. it is too bad that you cannot
>> access a standby postgres database.
>>
>> so my question is anyone has any comments on what other tools out there
>> that may allow us to create a postgres standby read-only database? if
>> nothing we may just have to walk down the slony-i path...thanks ahead for
>> any comments.
>>
>> regards,
>>
>> tim
> If you go the route you intent on, I'd guess slony is your best option.  
> Of course there are other ways to do this too, like manually scripting a 
> db export import daily.
> 
> However with knowing just the info you provided, setting up a 
> master-slave itself seems like overkill.  What about a VPN?  Or setting 
> up SL on it's own host?  My SL server isn't sharing it's IP with other 
> domains, so for me a default to deny firewall covers virtually all my 
> security needs.  You can always run SSL on it if you like.
> 

-- 
Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
el...@li... el108-ARIN / *     |   Telephone: +264 81 124 6733 (cell)
PO Box 8421             \     /   Please do NOT email to this address
Bachbrecht, Namibia     ;____/        if it is DNS related in ANY way

Re: [SL] Postgres replication

[Adam V. <amv...@gm...>]

la...@cl... wrote:
> hello all...our business has now the need to replicate our sl/postgres db
> from our main office in ca to ny as the ny system (public and outside of
> our firewall) has the need to generate non-critical read only invoice and
> inventory reports. our requirements are real simple and slony-i seems to
> be an overkill. we have also evaluated pgpool-ii but it was ruled out as
> it doesn't support x509 ssl connection (a must for business data). oralce
> and informix would have been nice as they both provide standby read-only
> databases that are very simple to manage. it is too bad that you cannot
> access a standby postgres database.
>
> so my question is anyone has any comments on what other tools out there
> that may allow us to create a postgres standby read-only database? if
> nothing we may just have to walk down the slony-i path...thanks ahead for
> any comments.
>
> regards,
>
> tim
If you go the route you intent on, I'd guess slony is your best option.  
Of course there are other ways to do this too, like manually scripting a 
db export import daily.

However with knowing just the info you provided, setting up a 
master-slave itself seems like overkill.  What about a VPN?  Or setting 
up SL on it's own host?  My SL server isn't sharing it's IP with other 
domains, so for me a default to deny firewall covers virtually all my 
security needs.  You can always run SSL on it if you like.

-- 
Adam Vandemore
Systems Administrator
IMED Mobility

Re: [SL] Syntax Error

[Adrian B. <adr...@ie...>]

Last weekend I did the same upgrade, Mandriva 2008 to Mandriva 2008.1 (Spring).

First is did a backup from SQL-Ledger to create a file ¨arblake2-2.8.14-20080525.sql¨. I also did a complete copy of
/var/lib/pgsql and /usr/local/sql-ledger.

Next a total install of Mandriva 2008.1

I installed Postgres (version 8.3) and all software as in the SQL-Ledger  ¨README¨

Next installed SQL-Ledger and copied in my users and templates, just like doing an update of sql-Ledger, etc

Follow the ¨README¨

As user postgres:

createuser -d sql-ledger

createlang plpgsql template1

Follow the ¨README¨

http://localhost/sql-ledger/admin.pl

This should show the details of your old database. including the  dataset name, e.g. newdb

create a blank database and restore the data.

psql -U sql-ledger -c "create database newdb;" template1
psql -U sql-ledger newdb < arblake2-2.8.14-20080525.sql

Now all should be working.

I hope I have included all the steps.



Peter Dabrowski wrote:
> Hi,
> Upgraded my mandriva to 2008.1 spring from 2008 and got this error 
> during posting sales invoice.
> Database postgresql 8.27 previous was 8.26 DBD pg was updated too by 
> increment.
> I was running sql-ledger 8.13 upgraded to 8.14 but no change. Should 
> I move to postgres 8.3 ?
> 
> DBD::Pg::db do failed: ERROR: syntax error at or near ")"
> LINE 4: '11/05/2008', NULL, )
> ^ at SL/IS.pm line 1077.
> Error!
> 
> INSERT INTO acc_trans (trans_id, chart_id, amount,
> transdate, project_id, id)
> VALUES (11246, 10032, 138.17,
> '11/05/2008', NULL, )
> ERROR: syntax error at or near ")"
> LINE 4: '11/05/2008', NULL, )
> ^
> 
> Thanks
> Peter
> 
> 

Re: [SL] Postgres replication (me three)

[Dr E. L. <el...@li...>]

Tim,

we would be extremely interested in a solution for exactly this issue.
Not only for SL, by the way, we have another database that we would like
to replicate read-only in a simple fashion.

Please post any solution that you may find, or if it's not of interest
to the list, please email me directly.

greetings, el

on 5/28/08 8:04 AM la...@cl... said the following:
> hello all...our business has now the need to replicate our sl/postgres db
> from our main office in ca to ny as the ny system (public and outside of
> our firewall) has the need to generate non-critical read only invoice and
> inventory reports. our requirements are real simple and slony-i seems to
> be an overkill. we have also evaluated pgpool-ii but it was ruled out as
> it doesn't support x509 ssl connection (a must for business data). oralce
> and informix would have been nice as they both provide standby read-only
> databases that are very simple to manage. it is too bad that you cannot
> access a standby postgres database.
> 
> so my question is anyone has any comments on what other tools out there
> that may allow us to create a postgres standby read-only database? if
> nothing we may just have to walk down the slony-i path...thanks ahead for
> any comments.
> 
> regards,
> 
> tim
						
-- 
Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
el...@li... el108-ARIN / *     |   Telephone: +264 81 124 6733 (cell)
PO Box 8421             \     /   Please do NOT email to this address
Bachbrecht, Namibia     ;____/        if it is DNS related in ANY way

[SL] Postgres replication

[<la...@cl...>]

hello all...our business has now the need to replicate our sl/postgres db
from our main office in ca to ny as the ny system (public and outside of
our firewall) has the need to generate non-critical read only invoice and
inventory reports. our requirements are real simple and slony-i seems to
be an overkill. we have also evaluated pgpool-ii but it was ruled out as
it doesn't support x509 ssl connection (a must for business data). oralce
and informix would have been nice as they both provide standby read-only
databases that are very simple to manage. it is too bad that you cannot
access a standby postgres database.

so my question is anyone has any comments on what other tools out there
that may allow us to create a postgres standby read-only database? if
nothing we may just have to walk down the slony-i path...thanks ahead for
any comments.

regards,

tim

Re: [SL] Syntax Error

[Mark S. <ms...@ea...>]

On May 26, 2008 04:54:56 pm Rolf Stöckli wrote:
> Mark J. Small schrieb:
> > and got the usual silence for a response.  Other people have had the same
> > problem over the last few months, and nobody has posted a proper fix.
>
> Maybe the reason for the (unusual) silence is, that this error is very
> difficult to reproduce. Me personally, I've never seen it neither on
> SUSE, nor on Ubuntu. I've tried again on Ubuntu 8.04 after Peter's
> message, and everything works fine.
>
> > I "fixed" it by migrating the database to an older computer running
> > debian stable, so it has an old version of dbd-pg, perl, and other helper
> > stuff.
>
> The error message Peter posted
>
> DBD::Pg::db do failed: ERROR: syntax error at or near ")"
> LINE 4: '11/05/2008', NULL, )
> ^ at SL/IS.pm line 1077.
>
> doesn't seem to be a dbd or a Postres error. My conjecture (only a
> conjecture!) is that the source is in the foreach-loop following line
> 823, where at line 1001 the id should be set. Is someone able to debug
> this area on a system that doesn't work properly?
>
> Rolf
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users


Well,  several other folks have had these problems after 
perl/dbd-pg/distrubution upgrades.  There have been various errors: syntax 
errors because of a missing parameter in a database lookup, bizarre array 
copies, unreferenced hash things.  I've seen all three since the 
perl/dbd-pg-dbi upgrade.

http://abacus.sql-ledger.com/userforum/forum_entry.php?id=941

http://sourceforge.net/mailarchive/forum.php?thread_name=200804171345.34024.archdist%40mts.net&forum_name=sql-ledger-users

http://sourceforge.net/mailarchive/forum.php?thread_name=200805211043.57773.msmall%40eastlink.ca&forum_name=sql-ledger-users

The last one is my post from last week.

Mark

[SL] Receipt Printers

[Michael A. <mi...@yo...>]

I see that SQL-Ledger will be supporting receipt printers.  Does anyone know what models are supported?  I'm trying to get a handle on overall costs so that I can budget for both the till and getting the support for SQL-Ledger.

Re: [SL] Syntax Error

[Rolf S. <in...@to...>]

Mark J. Small schrieb:
> and got the usual silence for a response.  Other people have had the same 
> problem over the last few months, and nobody has posted a proper fix.

Maybe the reason for the (unusual) silence is, that this error is very 
difficult to reproduce. Me personally, I've never seen it neither on 
SUSE, nor on Ubuntu. I've tried again on Ubuntu 8.04 after Peter's 
message, and everything works fine.

> I "fixed" it by migrating the database to an older computer running debian 
> stable, so it has an old version of dbd-pg, perl, and other helper stuff.  

The error message Peter posted

DBD::Pg::db do failed: ERROR: syntax error at or near ")"
LINE 4: '11/05/2008', NULL, )
^ at SL/IS.pm line 1077.

doesn't seem to be a dbd or a Postres error. My conjecture (only a 
conjecture!) is that the source is in the foreach-loop following line 
823, where at line 1001 the id should be set. Is someone able to debug 
this area on a system that doesn't work properly?

Rolf

Re: [SL] Syntax Error

[Mark J. S. <ms...@ea...>]

On May 26, 2008, Peter Dabrowski wrote:
> Hi,
> Upgraded my mandriva to 2008.1 spring from 2008 and got this error
> during posting sales invoice.
> Database postgresql 8.27 previous was 8.26 DBD pg was updated too by
> increment.
> I was running sql-ledger 8.13 upgraded to 8.14 but no change. Should
> I move to postgres 8.3 ?
>
> DBD::Pg::db do failed: ERROR: syntax error at or near ")"
> LINE 4: '11/05/2008', NULL, )
> ^ at SL/IS.pm line 1077.
> Error!
>
> INSERT INTO acc_trans (trans_id, chart_id, amount,
> transdate, project_id, id)
> VALUES (11246, 10032, 138.17,
> '11/05/2008', NULL, )
> ERROR: syntax error at or near ")"
> LINE 4: '11/05/2008', NULL, )
> ^
>
> Thanks
> Peter

I had the same problem last week, though I misidentified it as from a perl 
upgrade.  I'm pretty sure that it was dbd-pg.  I posted about it on this list 
and got the usual silence for a response.  Other people have had the same 
problem over the last few months, and nobody has posted a proper fix.

I "fixed" it by migrating the database to an older computer running debian 
stable, so it has an old version of dbd-pg, perl, and other helper stuff.  
Not a practical solution for everybody, but it was something I had planned on 
for a long time anyway.  

If you can't downgrade the helper stuff, my only advice would be to pay Dieter 
to make this issue a big priority.  

Mark

[SL] Syntax Error

[Peter D. <mer...@ma...>]

Hi,
Upgraded my mandriva to 2008.1 spring from 2008 and got this error 
during posting sales invoice.
Database postgresql 8.27 previous was 8.26 DBD pg was updated too by 
increment.
I was running sql-ledger 8.13 upgraded to 8.14 but no change. Should 
I move to postgres 8.3 ?

DBD::Pg::db do failed: ERROR: syntax error at or near ")"
LINE 4: '11/05/2008', NULL, )
^ at SL/IS.pm line 1077.
Error!

INSERT INTO acc_trans (trans_id, chart_id, amount,
transdate, project_id, id)
VALUES (11246, 10032, 138.17,
'11/05/2008', NULL, )
ERROR: syntax error at or near ")"
LINE 4: '11/05/2008', NULL, )
^

Thanks
Peter


-- 
Mail.com Autos- Powered by Oncars.com: Drive By Today!
http://www.oncars.com 

Re: [SL] LaTex templates

[J.M. \Jersey\ M. <je...@ib...>]

Sorry Guys :),

Got it. Just went through the archives.

Best regards
"Jersey"

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of J.M.
"Jersey" Miszczyk
Sent: 23 May 2008 01:48 PM
To: sql...@li...
Subject: [SL] LaTex templates

Hi,

 

How could I use "if" and "else" statements in the LaTex templates:

 

For example:

 

If  <%terms%> 'text'

else 'another text'

 

Or

if <%somevalue%> => 10 'text'

else 'another text'

 

<%if terms%> will process "text" and "another text" in case when terms have
a value.

 

Best regards

"Jersey"

 

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users


-- 
No virus found in this incoming message.
Checked by AVG. 
Version: 7.5.524 / Virus Database: 269.24.0/1461 - Release Date: 5/22/2008
4:44 PM

[SL] LaTex templates

[J.M. \Jersey\ M. <je...@ib...>]

Hi,

 

How could I use "if" and "else" statements in the LaTex templates:

 

For example:

 

If  <%terms%> 'text'

else 'another text'

 

Or

if <%somevalue%> => 10 'text'

else 'another text'

 

<%if terms%> will process "text" and "another text" in case when terms have
a value.

 

Best regards

"Jersey"