[SPTUsers] Re: give me help, please

Arbit 1202 arbit1202 at yahoo.com
Thu Jul 3 21:36:26 CDT 2003 

After following the directions for copying the
directories etc, the program still has to be installed
by browsing to spt--install.php. On my system, after
copying the directories etc, I entered the following
in my browser address bar -
http://localhost/spt/spt--install.php? This is needed
to create and fill the database.

Check if your database has been created and is OK. You
can do this by using phpmyadmin (www.phpmyadmin.net)

If that is OK, it might be because of using MySql 4. I
use it without any problems on Mysql 3.23.55, and I
think the program is tested only with 3.2x. MySQL 4x
is still experimental, and I would suggest you stick
to 3.23.xx.

PC

--- zou yuanzhi <yzzou at jdl.ac.cn> wrote:
> hi,everybody
> 
>     According to SPTUsers mailing,I have installed
> SPT(1.1.3) under Windows professional
> 2000,APache(Version 1.3),MySql4.0.13 and
> PhP-4.3.2.But there is a following error.Hope you
> give a solution to me quickly. 
>     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 '' at line 1
> 
> my email:
>       yzzou at jdl.ac.cn
>       yuan-zhi at 263.net
>       
> ----- Original Message ----- 
> From: <sptusers-request at scout.wisc.edu>
> To: <sptusers at scout.wisc.edu>
> Sent: Saturday, June 28, 2003 2:28 AM
> Subject: SPTUsers Digest, Vol 6, Issue 16
> 
> 
> > Send SPTUsers mailing list submissions to
> > sptusers at scout.wisc.edu
> > 
> > To subscribe or unsubscribe via the World Wide
> Web, visit
> > http://scout.wisc.edu/mailman/listinfo/sptusers
> > or, via email, send a message with subject or body
> 'help' to
> > sptusers-request at scout.wisc.edu
> > 
> > You can reach the person managing the list at
> > sptusers-owner at scout.wisc.edu
> > 
> > When replying, please edit your Subject line so it
> is more specific
> > than "Re: Contents of SPTUsers digest..."
> > 
> > 
> > Today's Topics:
> > 
> >    1. Re: Re: continually give me help about
> problems under
> >       windows professional 200 (Arbit 1202)
> > 
> > 
> >
>
----------------------------------------------------------------------
> > 
> > Date: Fri, 27 Jun 2003 02:04:40 -0700 (PDT)
> > From: Arbit 1202 <arbit1202 at yahoo.com>
> > To: zou yuanzhi <yzzou at jdl.ac.cn>, SPT UserList
> <sptusers at scout.wisc.edu>
> > Subject: [SPTUsers] Re: Re: continually give me
> help about problems under
> > windows professional 200
> > Message-ID:
> <20030627090440.49145.qmail at web21304.mail.yahoo.com>
> > In-Reply-To:
> <001601c33bb8$9543dde0$7401a8c0 at yzzou>
> > Content-Type: text/plain; charset=us-ascii
> > MIME-Version: 1.0
> > Precedence: list
> > Message: 1
> > 
> > Please check if the directory spt\include has the
> file
> > spt--config.php. If not, you must first install
> spt as
> > follows.
> > 
> > 1. Give the spt file system path a virtual path eg
> > /spt/. In my case, it is http://localhost/spt/
> > 2. Browse to /spt/spt--install.php
> > 3. Follow the directions, which will include
> giving
> > details of the mysql server etc.
> > 
> > After the setup is over, browse to spt--home.php.
> > 
> > You can also run spt on IIS by making a few
> changes -
> > see my notes on running spt under Win98 in the
> March
> > issue.
> > --- zou yuanzhi <yzzou at jdl.ac.cn> wrote:
> > > Hi,
> > >    My SPT is not still run, but it has changed
> with
> > > the following error.
> > >     
> > >     Warning: mysql_connect(): Unknown MySQL
> Server
> > > Host 'X-DBHOST-X' (11001) in
> > > c:\netpub\spt\Axis--Database.php on line 28
> > > could not connect to database
> > >     
> > >   
> > >   
> > > ----- Original Message ----- 
> > > From: "Arbit 1202" <arbit1202 at yahoo.com>
> > > To: "zou yuanzhi" <yzzou at jdl.ac.cn>; "SPT
> UserList"
> > > <sptusers at scout.wisc.edu>
> > > Sent: Thursday, June 26, 2003 3:14 PM
> > > Subject: Re: continually give me help about
> problems
> > > under windows professional 200
> > > 
> > > 
> > > > The errors are due to a wrong setting in the
> > > php.ini
> > > > file. 
> > > > 1. Open the php.ini file (in your windows
> system
> > > > directory)
> > > > 2. Search for the session.save_path variable
> > > > 3. Set this to a windows file system directory
> > > that
> > > > exists and is writable by the server.
> Currently,
> > > in
> > > > your system, this appears to be set to /tmp,
> which
> > > is
> > > > for linux. For example, my setting is
> > > > c:\php\sessiondata
> > > > 4. Restart the server and browse to your spt
> url.
> > > > 
> > > > Let me know if it works.
> > > > 
> > > > PC
> > > > --- zou yuanzhi <yzzou at jdl.ac.cn> wrote:
> > > > > hi,
> > > > >     I have installed and configuree my SPT
> > > according
> > > > > to your advices under Windows professionla
> > > 2000,but
> > > > > the following errors have happened.
> > > > >     Give me help, in addition , Are there
> > > > > configurations needed among Mysql, Apahce
> and
> > > SPT.
> > > > >     
> > > > >     yuanzhi zou 
> > > > >     yzzou at jdl.ac.cn yuan-zhi at 263.net
> > > > > 
> > > > > Warning: session_start():
> > > > >
> open(/tmp\sess_ad62117a7f0dc51df391a88413d9b19b,
> > > > > O_RDWR) failed: No such file or directory
> (2) in
> > > > > c:\netpub\spt\Axis--Session.php on line 22
> > > > > 
> > > > > Warning: session_start(): Cannot send
> session
> > > cookie
> > > > > - headers already sent by (output started at
> > > > > c:\netpub\spt\Axis--Session.php:22) in
> > > > > c:\netpub\spt\Axis--Session.php on line 22
> > > > > 
> > > > > Warning: session_start(): Cannot send
> session
> > > cache
> > > > > limiter - headers already sent (output
> started
> > > at
> > > > > c:\netpub\spt\Axis--Session.php:22) in
> > > > > c:\netpub\spt\Axis--Session.php on line 22
> > > > > 
> > > > > Warning: mysql_connect(): Unknown MySQL
> Server
> > > Host
> > > > > 'X-DBHOST-X' (11001) in
> > > > > c:\netpub\spt\Axis--Database.php on line 28
> > > > > could not connect to database
> > > > > Warning: Unknown():
> > > > >
> open(/tmp\sess_ad62117a7f0dc51df391a88413d9b19b,
> > > > > O_RDWR) failed: No such file or directory
> (2) in
> > > > > Unknown on line 0
> > > > > 
> > > > > Warning: Unknown(): Failed to write session
> data
> > > > > (files). Please verify that the current
> setting
> > > of
> > > > > session.save_path is correct (/tmp) in
> Unknown
> > > on
> > > > > line 0
> > > > 
> > > > 
> > > > __________________________________
> > > > Do you Yahoo!?
> > > > SBC Yahoo! DSL - Now only $29.95 per month!
> > > > http://sbc.yahoo.com
> > > > 
> > 
> > 
> > __________________________________
> > Do you Yahoo!?
> > SBC Yahoo! DSL - Now only $29.95 per month!
> > http://sbc.yahoo.com
> > ------------------------------
> > 
> > _______________________________________________
> > SPTUsers mailing list
> > SPTUsers at scout.wisc.edu
> > http://scout.wisc.edu/mailman/listinfo/sptusers
> > 
> > 
> > End of SPTUsers Digest, Vol 6, Issue 16
> > *************************************** 


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

More information about the SPTUsers mailing list