Re: [CK-Ledger-users] Database error: Invalid SQL: SELECT * from gl +WHERE+1%3D1+ order by transdat
Status: Beta
Brought to you by:
ckwu
Menu
▾
▴
Re: [CK-Ledger-users] Database error: Invalid SQL: SELECT * from gl +WHERE+1%3D1+ order by transdate ASC
|
From: C K Wu <ck...@ho...> - 2003-09-28 00:30:18
|
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 >>> >>> >>>------------------------------------------------------- >>>This sf.net email is sponsored by:ThinkGeek >>>Welcome to geek heaven. >>>http://thinkgeek.com/sf >>>_______________________________________________ >>>CK-Ledger-users mailing list >>>CK-...@li... >>>https://lists.sourceforge.net/lists/listinfo/ck-ledger-users >>> >>> > > >__________________________________ >Do you Yahoo!? >The New Yahoo! Shopping - with improved product search >http://shopping.yahoo.com > > > > |
