Hi Anousak, I fixed the bug. It was a "USE BTREE" option in the database what seems not supported in the mysql version of this XAMPP.
The new database dump is on the repository, you can update your version now. Robert Am Donnerstag, den 29.03.2012, 13:16 +0700 schrieb Anousak Souphavanh: > Hi Robert, > > I am using ubuntu version 10.04 with XAMP version 1.6.4. > > Anousak > > On Thu, Mar 29, 2012 at 12:34 PM, Robert Meggle <meg...@merotech.de> > wrote: > Hi, > > Sorry about that. Please let me check today here for the > apache+mysql > version you've used. > > Are you using Windows or Linux? > > Robert > > Am Donnerstag, den 29.03.2012, 11:47 +0700 schrieb Anousak > Souphavanh: > > Robert and all, > > > > > > I was able to get XAMPP version 1.6.4 installed and trying > to install > > Care2x_elct but there are many permision issues. What do you > suggest > > on resolving permision issues? I did SVN by my user name > instead of > > sudo from Ubuntu. > > > > I also installed care2x.sql manually but it gives me an > error of: > > > > > anousak@anousak-laptop:/opt/lampp/htdocs/his/install/mysql/manual$ > > sudo /opt/lampp/bin/./mysql -uroot care2x < care2x.sql > > ERROR 1064 (42000) at line 5149: 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 'USING BTREE > > ) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=latin1 > COLLATE=lat' > > at line 4 > > > > how can I get rid of it? > > > > > > Many thanks, > > Anousak > > > > On Wed, Mar 28, 2012 at 7:39 PM, Mauri Niemi > <mauri.ni...@gmail.com> > > wrote: > > Hi, > > > > Care2x_tz was customized from Care2x. Tz version has > billin > > module > > linked with lab and drug prescription and other > services > > because > > hospitals normally sell these services. When > requests are > > directly > > linked to billing it will reduce errors and also > fraud. Also > > diagnosis > > module was rebuilt and it is fast and easy to use. > > Robert can tell the difference od trunk and brach > > > > Mauri > > > > 2012/3/28, Anousak Souphavanh <anou...@gmail.com>: > > > Thanks, Robert et al. > > > > > > looks promising, will give this a try and will > update you > > all later. > > > > > > Anousak > > > On 2012 3 28 16:42, "Robert Meggle" > <meg...@merotech.de> > > wrote: > > > > > >> Hi, > > >> > > >> Did you gave apache writing permissions on > following > > folder? > > >> > > >> /gui/smarty_template/templates_c/ > > >> > > >> Are you using the correct database? (It is > different from > > main care2x > > >> development) > > >> > > >> Best way to make it sure: Stop apache and mysql > with > > >> ~$ sudo /etc/init.d/apache2 stop > > >> ~$ sudo stop mysql > > >> > > >> and install in /opt lampp from: > > >> > http://http://sourceforge.net/projects/xampp/files/XAMPP% > > 20Linux/ > > >> > > >> (This elct-branch is based on XAMPP Linux 1.6.4) > > >> > > >> Please do not forget to install it via the "-c" > param: > > >> > > >> tar xvfz xampp-linux-1.6.4.tar.gz -C /opt > > >> > > >> Extract the elct branch now in the htdocs folder, > start > > xampp and > > >> install then the database manually by the xampp > > mysql-client. > > >> > > >> Then you can switch easily between your ubuntu > standard > > apache/mysql and > > >> care2x_elct settings. I will try to catch the PHP > issues > > that it will > > >> work with php 5.3.2 (There seems to be some > issues left, > > sorry). > > >> > > >> Robert > > >> > > >> Am Mittwoch, den 28.03.2012, 13:24 +0700 schrieb > Anousak > > Souphavanh: > > >> > Hi all, > > >> > > > >> > I still cannot pass the first stage of install > (from SVN, > > >> > Care2002/care2x_TZ/branches, Care2x_elct) via: > > >> > > > >> > http://localhost/care2x/installer/install.php > > >> > > > >> > I got blank screen at this point. > > >> > > > >> > My system are: > > >> > > > >> > Ubuntu 10.04 > > >> > Php 5.3.2 > > >> > Apache 2.2.14 > > >> > Mysql 5.1.41 > > >> > > > >> > Though I was abvle to install using download > version: > > >> > Care2x-HIS-2.6.27.zip > > >> > > > >> > Please help, > > >> > > > >> > Anousak > > >> > > > >> > On Wed, Mar 28, 2012 at 12:24 PM, Tim Schofield > > <t...@weberpafrica.com> > > >> > wrote: > > >> > I don't believe it should give a > problem except > > some > > >> > E_DEPRECATED > > >> > warnings in PHP 5.3. These can be > hidden by > > ensuring that > > >> > error_reporting is set to not show > these > > warnings. > > >> > > > >> > Thanks > > >> > Tim > > >> > > > >> > > > >> > On 28 March 2012 03:19, Anousak > Souphavanh > > <anou...@gmail.com> > > >> > wrote: > > >> > > Looks like mysql, apache, and php are > latest > > version on my > > >> > ubuntu 10.04. > > >> > > Will have to reinstall them manually. > > >> > > > > >> > > Will give it a try and many thanks to > all. > > >> > > > > >> > > regards, > > >> > > anousak > > >> > > > > >> > > On 2012 3 27 19:48, "Rogério P. > Falcone" > > >> > <roge...@falconeit.com.br> wrote: > > >> > >> > > >> > >> Look version mysql, php and apache . > This is > > very > > >> > important. > > >> > >> > > >> > >> I'm problem with version. Now is > very good. > > >> > >> > > >> > >> I'm Install with version : > > >> > >> mysql 5.0.45, php 4.4.7, apache > 2.0.50 > > >> > >> > > >> > >> Software very simple on the > install : > > wampserver > > >> > >> > > >> > >> Rogério > > >> > >> > > >> > >> > > >> > >> > > >> > >> > > >> > >> -----Original Message----- > > >> > >> From: Robert Meggle > > [mailto:robert.meg...@care2x.org] > > >> > >> Sent: martes, 27 de marzo de 2012 > 04:42 a.m. > > >> > >> To: > care2002-developers@lists.sourceforge.net > > >> > >> Subject: Re: [Care2002-developers] > Trunk and > > Branches? > > >> > >> > > >> > >> Hi, > > >> > >> > > >> > >> Yes, the installer seems to > deactivated in > > this branch. But > > >> > there is an > > >> > >> database dump in the repository: > > >> > >> > > >> > >> > care2x_elct/install/mysql/manual/care2x.sql > > >> > >> > > >> > >> You can install it manually by doing > following > > steps: > > >> > >> > > >> > >> - create a database > > >> > >> - xammp [1]: > > >> > >> - search for mysql.exe > > >> > >> - go in that folder with > command line > > >> > >> - type: mysql.exe -uroot > [name of db] < > > [care2x.sql] > > >> > >> - linux: > > >> > >> - type: mysql -uroot [name of > db] < > > [care2x.sql] > > >> > >> - open > care2x_elct/include/inc_init_main.php > > >> > >> - type in dbname, username > and password > > for db > > >> > >> > > >> > >> for linux: Make sure that following > folder: > > >> > > >> /care2x_elct/gui/smarty_template/templates_c > > >> > >> has write permissions (chmod 777) > > >> > >> > > >> > >> Robert > > >> > >> > > >> > >> [1] Example: When you have installed > xampp > > under C: and you > > >> > have mysql.exe > > >> > >> in a bin folder there: > > >> > >> > > >> > >> c:\xampp\bin\mysql.exe -uroot > > >> > >> Type 'help;' or '\h' for help. Type > '\c' to > > clear the > > >> > current input > > >> > >> statement. > > >> > >> mysql> create database c2x; > > >> > >> Query OK, 1 row affected (0.00 sec) > > >> > >> > > >> > >> mysql> quit > > >> > >> > > >> > >> c:\xampp\bin\mysql.exe -uroot c2x < > C:\xampp > > \htdocs\care2x > > >> > \install\mysql > > >> > >> \manual\care2x.sql > > >> > >> > > >> > >> > > >> > >> > > >> > >> > > >> > >> Am Dienstag, den 27.03.2012, 14:31 > +0700 > > schrieb Anousak > > >> > Souphavanh: > > >> > >> > Thank you, Robert. > > >> > >> > > > >> > >> > By the way, can you or is there a > HOW TO > > INSTALL from > > >> > branch or Trunk? > > >> > >> > > > >> > >> > I tried install from the branch > per your > > suggestion but > > >> > NOTHING > > >> > >> > happens when: > > >> > >> > > > >> > >> > htp://localhost/care2x > > >> > >> > > > >> > >> > it gives > > >> > >> > > > >> > >> > > htp://localhost/care3x/installer/install.php > > >> > >> > > > >> > >> > though, but no furhter > instructions. > > >> > >> > > > >> > >> > Thanks, > > >> > >> > Anousak > > >> > >> > > > >> > >> > > > >> > >> > On Tue, Mar 27, 2012 at 12:26 PM, > Robert > > Meggle > > >> > <meg...@merotech.de> > > >> > >> > wrote: > > >> > >> > Hi Anousak, > > >> > >> > > > >> > >> > You can give a try. The > other > > branches came out > > >> > of the history > > >> > >> > of this > > >> > >> > development. When the elct > branch is > > working > > >> > perfect, the > > >> > >> > other branches > > >> > >> > will be dropped out. > > >> > >> > > > >> > >> > Robert > > >> > >> > > > >> > >> > Am Dienstag, den > 27.03.2012, 12:03 > > +0700 schrieb > > >> > Anousak > > >> > >> > Souphavanh: > > >> > >> > > Hi Robert, > > >> > >> > > > > >> > >> > > Thanks for your reply. > So I can > > give it a try > > >> > using > > >> > >> > Care2x_elct? I > > >> > >> > > know there are Tags and > Utu > > folders there are > > >> > well. > > >> > >> > > > > >> > >> > > Regards, > > >> > >> > > Anousak > > >> > >> > > > > >> > >> > > On Tue, Mar 27, 2012 at > 11:56 AM, > > Robert Meggle > > >> > >> > <meg...@merotech.de> > > >> > >> > > wrote: > > >> > >> > > Hi, > > >> > >> > > > > >> > >> > > The branch > "care2x_elct" > > is a merge > > >> > from several > > >> > >> > individual > > >> > >> > > developments. It > is > > located as branch > > >> > till it will > > >> > >> > be work > > >> > >> > > completely > > >> > >> > > without any > issues. So far > > there is an > > >> > issue > > >> > >> > reported that > > >> > >> > > some reports > > >> > >> > > are not working > as it > > should. When I do > > >> > have a space > > >> > >> > in my > > >> > >> > > schedule I > > >> > >> > > will look for. > > >> > >> > > > > >> > >> > > Robert > > >> > >> > > > > >> > >> > > Am Dienstag, den > > 27.03.2012, 11:34 > > >> > +0700 schrieb > > >> > >> > Anousak > > >> > >> > > Souphavanh: > > >> > >> > > > Hi all, > > >> > >> > > > > > >> > >> > > > I just > completed a > > download using SNV > > >> > and found > > >> > >> > two maIn > > >> > >> > > components > > >> > >> > > > under > Care2x_TZ: Trunk > > and Branches. > > >> > May I ask > > >> > >> > what is the > > >> > >> > > proper > > >> > >> > > > component to > install? It > > looks like > > >> > Trunk has > > >> > >> > updated files > > >> > >> > > and > > >> > >> > > > functions... > Also what > > would be a big > > >> > differences > > >> > >> > between > > >> > >> > > Care2X_TZ > > >> > >> > > > and Care2x? > Can't decide > > what to > > >> > install. I will > > >> > >> > wait for > > >> > >> > > your reply. > > >> > >> > > > > > >> > >> > > > Many thanks > for your > > kind suggestions > > >> > in advance. > > >> > >> > > > -- > > >> > >> > > > Regards, > > >> > >> > > > Anousak > (Anthony) > > Souphavanh > > >> > >> > > > > > >> > >> > > > > >> > >> > > > > > >> > >> > > > > >> > >> > > > >> > >> > > >> > >> > > >> > > > >> > > > > ---------------------------------------------------------------------------- > > >> > >> -- > > >> > >> > > > This SF email > is > > sponsosred by: > > >> > >> > > > Try Windows > Azure free > > for 90 days > > >> > Click Here > > >> > >> > > > > > http://p.sf.net/sfu/sfd2d-msazure > > >> > >> > > > > > >> > > _______________________________________________ > > >> > >> > > > Care2002-developers > > mailing list > > >> > >> > > > > >> > > Care2002-developers@lists.sourceforge.net > > >> > >> > > > > >> > >> > > > >> > > > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > >> > >> > > > > >> > >> > > -- > > >> > >> > > > > >> > > -------------------------------------------- > > >> > >> > > MEROTECH IT > Engineering > > >> > >> > > > > >> > >> > > Robert Meggle > > >> > >> > > St.-Mang-Str. 8 > > >> > >> > > 87616 > Marktoberdorf > > >> > >> > > > > >> > >> > > Germany > > >> > >> > > > > >> > >> > > Tel: +49(0)8342 > - 8956729 > > >> > >> > > Fax: +49(0)8342 > - 8956730 > > >> > >> > > > mailto:meg...@merotech.de > > >> > >> > > > > >> > >> > > > > >> > >> > > > > >> > >> > > > > >> > >> > > > >> > >> > > >> > >> > > >> > > > >> > > > > ---------------------------------------------------------------------------- > > >> > >> -- > > >> > >> > > This SF email is > > sponsosred by: > > >> > >> > > Try Windows > Azure free for > > 90 days > > >> > Click Here > > >> > >> > > > > http://p.sf.net/sfu/sfd2d-msazure > > >> > >> > > > > >> > > _______________________________________________ > > >> > >> > > > Care2002-developers > > mailing list > > >> > >> > > > > >> > > Care2002-developers@lists.sourceforge.net > > >> > >> > > > > >> > >> > > > >> > > > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > >> > >> > > > > >> > >> > > > > >> > >> > > > >> > >> > > >> > >> > > >> > > > >> > > > > ---------------------------------------------------------------------------- > > >> > >> -- > > >> > >> > > This SF email is > sponsosred by: > > >> > >> > > Try Windows Azure free > for 90 days > > Click Here > > >> > >> > > > http://p.sf.net/sfu/sfd2d-msazure > > >> > >> > > > > _______________________________________________ > > >> > >> > Care2002-developers > mailing list > > >> > >> > > > Care2002-developers@lists.sourceforge.net > > >> > >> > > > >> > >> > > > >> > > > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > >> > >> > > > >> > >> > -- > > >> > >> > > > -------------------------------------------- > > >> > >> > MEROTECH IT Engineering > > >> > >> > > > >> > >> > Robert Meggle > > >> > >> > St.-Mang-Str. 8 > > >> > >> > 87616 Marktoberdorf > > >> > >> > > > >> > >> > Germany > > >> > >> > > > >> > >> > Tel: +49(0)8342 - 8956729 > > >> > >> > Fax: +49(0)8342 - 8956730 > > >> > >> > mailto:meg...@merotech.de > > >> > >> > > > >> > >> > > > >> > >> > > > >> > >> > > > >> > >> > > >> > >> > > >> > > > >> > > > > ---------------------------------------------------------------------------- > > >> > >> -- > > >> > >> > This SF email is > sponsosred by: > > >> > >> > Try Windows Azure free for > 90 days > > Click Here > > >> > >> > > http://p.sf.net/sfu/sfd2d-msazure > > >> > >> > > > _______________________________________________ > > >> > >> > Care2002-developers > mailing list > > >> > >> > > > Care2002-developers@lists.sourceforge.net > > >> > >> > > > >> > >> > > > >> > > > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > >> > >> > > > >> > >> > > > >> > >> > > > >> > >> > > > >> > > > >> > > > ---------------------------------------------------------------------- > > >> > >> > -------- > > >> > >> > This SF email is sponsosred by: > > >> > >> > Try Windows Azure free for 90 days > Click > > Here > > >> > >> > http://p.sf.net/sfu/sfd2d-msazure > > >> > >> > > > _______________________________________________ > > >> > Care2002-developers > > >> > >> > mailing list > > Care2002-developers@lists.sourceforge.net > > >> > >> > > > >> > > > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > >> > >> > > >> > >> -- > > >> > >> -- > > >> > >> > -------------------------------------------- > > >> > >> CARE2X - free Integ Hospital Info > System > > >> > >> > https://sourceforge.net/projects/care2002/ > > >> > >> http://www.care2x.org > > >> > >> > > >> > >> > > >> > >> > > >> > >> > > >> > > > >> > > > > ---------------------------------------------------------------------------- > > >> > >> -- > > >> > >> This SF email is sponsosred by: > > >> > >> Try Windows Azure free for 90 days > Click Here > > >> > >> http://p.sf.net/sfu/sfd2d-msazure > > >> > >> > > _______________________________________________ > > >> > >> Care2002-developers mailing list > > >> > >> > Care2002-developers@lists.sourceforge.net > > >> > >> > > >> > > > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > >> > >> > > >> > >> > > >> > >> > > >> > >> > > >> > >> > > >> > > > >> > > > > ------------------------------------------------------------------------------ > > >> > >> This SF email is sponsosred by: > > >> > >> Try Windows Azure free for 90 days > Click Here > > >> > >> http://p.sf.net/sfu/sfd2d-msazure > > >> > >> > > _______________________________________________ > > >> > >> Care2002-developers mailing list > > >> > >> > Care2002-developers@lists.sourceforge.net > > >> > >> > > >> > > > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > >> > > > > >> > > > > >> > > > > >> > > > >> > > > > ------------------------------------------------------------------------------ > > >> > > This SF email is sponsosred by: > > >> > > Try Windows Azure free for 90 days > Click Here > > >> > > http://p.sf.net/sfu/sfd2d-msazure > > >> > > > _______________________________________________ > > >> > > Care2002-developers mailing list > > >> > > > Care2002-developers@lists.sourceforge.net > > >> > > > > >> > > > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > >> > > > > >> > > > >> > > > >> > > > >> > > > >> > -- > > >> > WebERP Africa Ltd > > >> > +447710427049 > > >> > +254706554559 > > >> > www.weberpafrica.com > > >> > @TimSchofield2 > > >> > > > >> > > > >> > > > > ------------------------------------------------------------------------------ > > >> > This SF email is sponsosred by: > > >> > Try Windows Azure free for 90 days > Click Here > > >> > http://p.sf.net/sfu/sfd2d-msazure > > >> > > _______________________________________________ > > >> > Care2002-developers mailing list > > >> > > Care2002-developers@lists.sourceforge.net > > >> > > > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > > ------------------------------------------------------------------------------ > > >> > This SF email is sponsosred by: > > >> > Try Windows Azure free for 90 days Click Here > > >> > http://p.sf.net/sfu/sfd2d-msazure > > >> > _______________________________________________ > > Care2002-developers > > >> mailing list > Care2002-developers@lists.sourceforge.net > > >> > > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > >> > > >> -- > > >> -------------------------------------------- > > >> MEROTECH IT Engineering > > >> > > >> Robert Meggle > > >> St.-Mang-Str. 8 > > >> 87616 Marktoberdorf > > >> > > >> Germany > > >> > > >> Tel: +49(0)8342 - 8956729 > > >> Fax: +49(0)8342 - 8956730 > > >> mailto:meg...@merotech.de > > >> > > >> > > >> > > >> > > >> > > > > ------------------------------------------------------------------------------ > > >> This SF email is sponsosred by: > > >> Try Windows Azure free for 90 days Click Here > > >> http://p.sf.net/sfu/sfd2d-msazure > > >> _______________________________________________ > > >> Care2002-developers mailing list > > >> Care2002-developers@lists.sourceforge.net > > >> > > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > >> > > > > > > > > > -- > > Lähetetty matkaviestimestäni > > > > > > ------------------------------------------------------------------------------ > > This SF email is sponsosred by: > > Try Windows Azure free for 90 days Click Here > > http://p.sf.net/sfu/sfd2d-msazure > > _______________________________________________ > > Care2002-developers mailing list > > Care2002-developers@lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > > > > > > > > > ------------------------------------------------------------------------------ > > This SF email is sponsosred by: > > Try Windows Azure free for 90 days Click Here > > http://p.sf.net/sfu/sfd2d-msazure > > _______________________________________________ > Care2002-developers mailing list > Care2002-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > -- > -------------------------------------------- > MEROTECH IT Engineering > > Robert Meggle > St.-Mang-Str. 8 > 87616 Marktoberdorf > > Germany > > Tel: +49(0)8342 - 8956729 > Fax: +49(0)8342 - 8956730 > mailto:meg...@merotech.de > > > > > ------------------------------------------------------------------------------ > This SF email is sponsosred by: > Try Windows Azure free for 90 days Click Here > http://p.sf.net/sfu/sfd2d-msazure > _______________________________________________ > Care2002-developers mailing list > Care2002-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > > ------------------------------------------------------------------------------ > This SF email is sponsosred by: > Try Windows Azure free for 90 days Click Here > http://p.sf.net/sfu/sfd2d-msazure > _______________________________________________ Care2002-developers mailing > list Care2002-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/care2002-developers -- -------------------------------------------- MEROTECH IT Engineering Robert Meggle St.-Mang-Str. 8 87616 Marktoberdorf Germany Tel: +49(0)8342 - 8956729 Fax: +49(0)8342 - 8956730 mailto:meg...@merotech.de ------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
