Re: [CK-Ledger-users] Database error: Invalid SQL: SELECT * from gl +WHERE+1%3D1+ order by transdate ASC

[Derrick Lo <hy...@ya...>]

Hi CK,

Need to bother you again:

1) How do you "uninstall" eGroupWare? Would dropping the DB and deleting
the eGroupWare dir be sufficient? Do I need to re-install CK-Ledger after
installing phpGroupWare 0.9.14.006?

2) Can we have 2 instances of CK-Ledger running on the same machine at the
same time?
   a) Existing setup of:
   - CK-Ledger 0.7.1
   - eGroupWare 0.9.99.004
   
   AND

   b) Stable setup of:
   - CK-Ledger 0.7.1
   - phpGroupWare 0.9.14.006

   If it's possible to have 2 instances of CK-Ledger at the same time, I'll
leave 2a for testing, and install a new instance of 2b.

Many thanks again!
Derrick

--- C K Wu <ck...@ho...> wrote:
> Derrick Lo ??:
> 
> >Hi CK,
> >
> >Thanks for your quick response. I have already done Pt2 before
> encountering
> >the error:
> >Admin/Setup -> 1 - Setup Data Tables
> >Admin/Setup -> 2 - Build Chart -> Default Chart
> >Admin/Setup -> 3 - Create Test Data
> >Play around with the various features. If stuck,
> >Admin/Setup -> 4 - Delete all Data and repeat the process
> >*Default data and COA were setup properly. 
> >
> >I discovered that this Database error not only occurs in CK-Ledger, but
> >also in ALL modules.
> >
> Yes. It would. Since it's a change in the internal API. All modules that
> are not
> in sync with such change, will encounter the same problem.
> 
> >
> >This urlencode/decode problem that you mentioned in Pt 1, is it easily
> >solved (or by-passed), or do you recommend re-install with phpgroupware
> >0.9.14.006?
> >  
> >
> No. it's not easily by-passed. The best bet is to re-install phpgw
> 0.9.14.006 if
> you are eager to test out phpgw along with its various add-on modules.
> Since phpgw
> 0.9.16 is a major upgrade, there may yet be other teething problems
> waiting to be
> discovered.
> 
> >I believe CK-Ledger have huge potential, and because it is built on top
> of
> >a groupware, is able to extend functions easily. Also look at new JiNN
> >function that came with the eGroupWare installation, though don't know
> how
> >to use it yet.
> >  
> >
> I like to add a word of caution here. Since eGroupWare is a fork
> resulting from
> internal argument amongst phpgroupware project team members, it is
> expected
> that pretty soon phpgroupware and eGroupWare will divert in their
> development path,
> you may like to choose carefully which platform to invest your time and
> effort.
> I have yet to decide for myself whether to ensure CK-Ledger is compatible
> to future release of eGroupWare.
> 
> Cheers,
> CK
> 
> >Thanks,
> >Derrick
> >
> >--- C K Wu <ck...@ho...> wrote:
> >  
> >
> >>Hi Derrick,
> >>
> >>Thank you for checking out CK-Ledger.
> >>
> >>There are probably two things that you have to watch out for,
> >>
> >>a) The '+WHERE+1%3D1+' that you saw in the error message is
> >>most likely caused by a recent change in phpgroupware's api.
> >>AFAIK, eGroupWare is a fork of the most recent version of phpgroupware,
> >>so eGroupWare/CK-Ledger will probably suffer from the same problem
> >>exhibited by phpgw/CK-Ledger. If you look through the postings to
> >>ck-...@li... during this month, you'll see a
> lot
> >>of discussion on the urlencode/decode problem, which is the source of
> the
> >>error that you encounter. Bottom line is CK-Ledger v.0.7.1 will only
> >>work properly with phpgroupware 0.9.14.006. However, the next
> >>release of CK-Ledger should work nicely with phpgw 0.9.16RC1 and
> >>by corollary, eGroupWare. But, I am afraid the next release of
> CK-Ledger
> >>is not quite there yet.
> >>
> >>b) After successful installation of CK-Ledger and before doing
> >>any testing, you have to build the default data tables. At the
> >>index page of any CK-Ledger module and some way down the
> >>User/Administrator column, it reads, "The best way to study
> >>LedgerAdmin is to follow the steps: ......."
> >>
> >>Follow the steps listed and the default data tables will be created.
> >>
> >>Cheers,
> >>CK
> >>
> >>Derrick Lo ??:
> >>
> >>    
> >>
> >>>Hi,
> >>>
> >>>I have just installed eGroupWare-0.9.99.004-0.tar.gz and
> >>>ck-ledger-0.7.1.tar.gz. Things look fine, was able to create default
> >>>      
> >>>
> >>users
> >>    
> >>
> >>>and login to CK.
> >>>
> >>>However, when I tried CK-Ledger -> Ledger A/Cs, and click "Start
> Search"
> >>>      
> >>>
> >>to
> >>    
> >>
> >>>view all accounts, I got this error:
> >>>
> >>>"Database error: Invalid SQL: SELECT * from gl +WHERE+1%3D1+ order by
> >>>transdate ASC
> >>>MySQL Error: 1064 (You have an error in your SQL syntax. Check the
> >>>      
> >>>
> >>manual
> >>    
> >>
> >>>that corresponds to your MySQL server version for the right syntax to
> >>>      
> >>>
> >>use
> >>    
> >>
> >>>near '+WHERE+1%3D1+ order by transdate ASC' at line 1)
> >>>
> >>>Session halted. "
> >>>
> >>>Did anyone encounter this? How do you solve this? Is there any
> >>>      
> >>>
> >>Bugs/Tracker
> >>    
> >>
> >>>page for CK?
> >>>
> >>>Many Thanks and have a good week-end!
> >>>Derrick


__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com