[SPTUsers] Re: SPTUsers Digest, Vol 6, Issue 16

[zou yuanzhi]

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
> ***************************************-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://scout.wisc.edu/pipermail/sptusers/attachments/20030702/b7f2aee1/attachment.htm