phpesp-general — General discussion, questions, and annoucements about phpESP

Re: [phpesp-general] Language help

[Emil R. <em...@no...>]

Natalia Pacheco wrote:

> I'm trying to change the language of phpesp, I've already changed the
> phpesp.ini.php file to pt_BR, but everything still in english, even
> though gettext is working, as seen in:
> http://escrevendo.procurandooque.net/phpESP/admin/test.php

I had the same experience. In my setup it was due to the language 
setting in my browser (HTTP_ACCEPT_LANGUAGE).

You can force a language by adding the following to your phpESP.ini.php:

esp_setlocale_ex('pt_BR');

I dont know if this is the "correct" way to handle the situation, but it 
works for me.

Regards Emil
-- 
Emil Rasmussen
http://novicell.dk

[phpesp-general] Stylesheet woes

[Kent V. <kvi...@up...>]

Hi,

I upgraded to phpESP 1.8.2 and not the style sheet no longer works in 
any version of Firefox - it still works in IE 7 (I'm not sure about 
older version as I don't have access). Can anyone offer any advice, 
there is no styles showing up in the Management interface or the survey!

thanks
Kent

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Kent Villard                       KVI...@UP...

[phpesp-general] Language help

[Natalia P. <de...@gm...>]

Hi,

I'm trying to change the language of phpesp, I've already changed the
phpesp.ini.php file to pt_BR, but everything still in english, even
though gettext is working, as seen in:
http://escrevendo.procurandooque.net/phpESP/admin/test.php

An example of a survey:
http://escrevendo.procurandooque.net/phpESP/public/survey.php?name=3Dwtert
(the text Questions maked etc is still in english).

I even tried to translate manually from locale/en_US and nothing
changed, I also tried to delete all the files from locale but the text
still in english, I mean, are these texts anywhere else?

Thanks a lot,

Nat=E1lia

[phpesp-general] Cross Tabulation ADODB BugFix

[Matt M. <jma...@gm...>]

Hello, I just fixed the issue I reported 2 hours ago.

On about line 203 of where/crosstab.inc

                $sql1 = "SELECT count(*) FROM
".$GLOBALS['ESPCONFIG'][$tbl[0].'_table']." r1,
".$GLOBALS['ESPCONFIG'][$tbl[1].'_table']." r2
                WHERE (r1.question_id = ${qids[0]} AND r1.choice_id =
'${xx}')
                AND (r2.question_id = ${qids[1]} AND r2.choice_id = '${yy}')


I added the single quotes around ${xx} and ${yy}

The lack of single quotes was throwing an error, thinking I was looking at
columns named Y or N as opposed to looking at the value within the column.

-Matt Miller

[phpesp-general] Cross Tabulation ADODB errors...

[Matt M. <jma...@gm...>]

Hi there, I'm using phpESP, and I'm trying to do cross tabulation, and i'm
getting the errors listed below.  Everything else works just fine, except
cross tabulation. (Cross analysis works)

I've tried running this on a php5 server and a php4.4 server, both hitting
the same database, and i get the same errors.

Is this a known bug? Is there a fix?

Thanks for putting out a good product,
-Matt Miller*

Notice*: Only variable references should be returned by reference in *
/var/www/survey/admin/include/lib/adodb/adodb.inc.php* on line *859*

*Notice*: Trying to get property of non-object in *
/var/www/survey/admin/include/lib/espdatalib.inc* on line *49*

*Notice*: Only variable references should be returned by reference in *
/var/www/survey/admin/include/lib/adodb/adodb.inc.php* on line *859*

*Notice*: Trying to get property of non-object in *
/var/www/survey/admin/include/lib/espdatalib.inc* on line *49*

*Notice*: Only variable references should be returned by reference in *
/var/www/survey/admin/include/lib/adodb/adodb.inc.php* on line *859*

*Notice*: Trying to get property of non-object in *
/var/www/survey/admin/include/lib/espdatalib.inc* on line *49*

*Notice*: Only variable references should be returned by reference in *
/var/www/survey/admin/include/lib/adodb/adodb.inc.php* on line *859*

*Notice*: Trying to get property of non-object in *
/var/www/survey/admin/include/lib/espdatalib.inc* on line *49*

*Notice*: Undefined offset: 0 in *
/var/www/survey/admin/include/where/crosstab.inc* on line *276*

*Notice*: Undefined offset: 2 in *
/var/www/survey/admin/include/where/crosstab.inc* on line *280*

*Notice*: Undefined offset: 1 in *
/var/www/survey/admin/include/where/crosstab.inc* on line *276*

*Notice*: Undefined offset: 3 in *
/var/www/survey/admin/include/where/crosstab.inc* on line *280*

Re: [phpesp-general] public url redirects to admin url

[Comic J. <com...@gm...>]

sounds like you are going to the wrong url, whats the url that you are
going to and what is the directory name of the phpesp software ?

On 10/10/06, Craig Dalton <cra...@ex...> wrote:
> Help. every time I set up a survey in phpESP 1.7.5 and attempt to go to the
> public url to enter data into it  or even when people on other computers
> attempt to enter data, whey the public url is entered into their web browser
> and they hit "enter" they are automatically redirected to the admin page
> i.e. "admin/manage.php" is automatically added to the public url address in
> the browser and it goes to the admin login which means users cant see the
> survey - any ideas - reinstalled 3 times - any ideas?
>

[phpesp-general] public url redirects to admin url

[Craig D. <cra...@ex...>]

Help. every time I set up a survey in phpESP 1.7.5 and attempt to go to =
the public url to enter data into it  or even when people on other =
computers attempt to enter data, whey the public url is entered into =
their web browser and they hit "enter" they are automatically redirected =
to the admin page i.e. "admin/manage.php" is automatically added to the =
public url address in the browser and it goes to the admin login which =
means users cant see the survey - any ideas - reinstalled 3 times - any =
ideas?

[phpesp-general] Calculate Survey Response

[Stephen C. <ste...@gm...>]

Hi

Could anyone please direct me to the correct file or give me an approach on
how I should do this?

Instead of directing a user to a page, I would like to direct the user to a
result page.  The result page would calculate the score of the answers.

I have some ideas on how to do this but I would just like to get a general
idea before i start.

Thanks

-- 
--~--~---------~--~----~------------~-------~--~----~
Stephen Chan

"You must be the change you wish to see in the world"
--~--~---------~--~----~------------~-------~--~----~

[phpesp-general] database software.

[Jesse C. <the...@ya...>]

I've been using phpESP with success.  I'm curious what
software you use to analyze your results off line?

-- http://artdc.org/-- http://jessecohen.com/

[phpesp-general] Results and percentages

[Michael G. <mi...@bi...>]

Hi everyone.
=20
My apologies if this topic has been discussed already...I wasn't able to
find anything specifically regarding this topic in the list archives.
This is also my first post...hello everyone.
=20
My question is regarding results and percentages.  It seems to me that
some results presented can be misleading.  Take a simple question about
gender, for example.  This question is optional, so not everyone may
answer:
=20
5. Gender:
Male    48.0%  (84)
Female    50.3%  (88)
TOTAL    98.3%  175
=20
A casual user would most likely conclude that 48% of the people who took
the survey are male and 50.3% are female. In reality, 48% are male,
50.3% are female, and 1.7% did not answer the question.  I have had
several users make this mistake.  Furthermore, the "TOTAL" of 175 may be
confusing to some because it is not the sume of 84 and 88.  It seems
that one of the following two options might make more sense:
=20
A)
5. Gender:
Male    48.0%  (84)
Female    50.3%  (88)
No response    1.7%    (3)
TOTAL    100%  175
=20
OR
=20
B)
5. Gender:
Male    48.8%  (84)
Female    51.2%  (88)
TOTAL    100%  172
3 survey respondents (1.7%) did not answer this question and 98.3% did
answer the question
=20
I am in favor of option B.  Any thoughts on this?
=20
Thanks very much,
=20
Michael
Chicago, IL

[phpesp-general] help

[<Ed...@av...>]

I would like to change my e-mail address to com...@gm...

Thanks

-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of
php...@li...
Sent: 17 September 2006 09:17 PM
To: php...@li...
Subject: phpESP-general Digest, Vol 4, Issue 1

Send phpESP-general mailing list submissions to
=09p...@li...

To subscribe or unsubscribe via the World Wide Web, visit
=09https://lists.sourceforge.net/lists/listinfo/phpesp-general
or, via email, send a message with subject or body 'help' to
=09p...@li...

You can reach the person managing the list at
=09p...@li...

When replying, please edit your Subject line so it is more specific
than "Re: Contents of phpESP-general digest..."


Today's Topics:

=20  1. PHPESP (Ed...@av...)


----------------------------------------------------------------------

Message: 1
Date: Thu, 7 Sep 2006 12:45:21 +0200
From: <Ed...@av...>
Subject: [phpesp-general] PHPESP
To: <php...@li....>
Message-ID:
=09
<D2A...@dk...>
Content-Type: text/plain; charset=3D"us-ascii"

Hi All

=20

=20

I want to adjust the spacing for the bullet and radio buttons on the
survey.

But using a CSS file, I cannot seem to get it right.

I can reduce and adjust the paragraph settings, but moving /tabbing
bullet and radio buttons left and right I cannot seem to do.

Any one else have this problem


************************************************************************
*******************************=20

Disclaimer: The information contained in this communication is
confidential and may be legally privileged.=20

It is intended solely for the use of the individual or entity to whom it
is addressed and others authorised to receive it.=20

Any review, retransmission, dissemination, copying, disclosure or other
use of, or taking of any action in reliance upon, this information by
person or entities other then the intended recipient is prohibited.=20

If you have received this message in error, please notify the sender
immediately by e-mail, facsimile or telephone and return and/or destroy
the original message and all copies from any computer.=20


Denel (Pty) Ltd exercises no editorial control over e-mail messages
originating in the organisation and does not accept any responsibility
for either the contents of the message or any copyright laws that may
have been violated by the person sending this message.=20

Denel (Pty) Ltd is neither liable for the proper and complete
transmission of the information contained in this communication nor any
delay in its receipt.=20

This message should not be copied or used for any purpose other than
intended, nor should it be disclosed to any other person.=20

************************************************************************
*******************************=20
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://sourceforge.net/mailarchive/forum.php?forum=3Dphpesp-general/attac=
h
ments/20060907/f2fe4d7c/attachment.html=20

------------------------------

------------------------------------------------------------------------
-
Using Tomcat but need to do more? Need to support web services,
security?
Get stuff done quickly with pre-integrated technology to make your job
easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache
Geronimo
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=3D=
121642

------------------------------

_______________________________________________
phpESP-general mailing list
php...@li...
https://lists.sourceforge.net/lists/listinfo/phpesp-general


End of phpESP-general Digest, Vol 4, Issue 1
********************************************

*************************************************************************=
******************************=20

Disclaimer: The information contained in this communication is confidenti=
al and may be legally privileged.=20

It is intended solely for the use of the individual or entity to whom it =
is addressed and others authorised to receive it.=20

Any review, retransmission, dissemination, copying, disclosure or other u=
se of, or taking of any action in reliance upon, this information by pers=
on or entities other then the intended recipient is prohibited.=20

If you have received this message in error, please notify the sender imme=
diately by e-mail, facsimile or telephone and return and/or destroy the o=
riginal message and all copies from any computer.=20


Denel (Pty) Ltd exercises no editorial control over e-mail messages origi=
nating in the organisation and does not accept any responsibility for eit=
her the contents of the message or any copyright laws that may have been =
violated by the person sending this message.=20

Denel (Pty) Ltd is neither liable for the proper and complete transmissio=
n of the information contained in this communication nor any delay in its=
=20receipt.=20

This message should not be copied or used for any purpose other than inte=
nded, nor should it be disclosed to any other person.=20

*************************************************************************=
******************************=20

[phpesp-general] PHPESP

[<Ed...@av...>]

Hi All

=20

=20

I want to adjust the spacing for the bullet and radio buttons on the
survey.

But using a CSS file, I cannot seem to get it right.

I can reduce and adjust the paragraph settings, but moving /tabbing
bullet and radio buttons left and right I cannot seem to do.

Any one else have this problem


*************************************************************************=
******************************=20

Disclaimer: The information contained in this communication is confidenti=
al and may be legally privileged.=20

It is intended solely for the use of the individual or entity to whom it =
is addressed and others authorised to receive it.=20

Any review, retransmission, dissemination, copying, disclosure or other u=
se of, or taking of any action in reliance upon, this information by pers=
on or entities other then the intended recipient is prohibited.=20

If you have received this message in error, please notify the sender imme=
diately by e-mail, facsimile or telephone and return and/or destroy the o=
riginal message and all copies from any computer.=20


Denel (Pty) Ltd exercises no editorial control over e-mail messages origi=
nating in the organisation and does not accept any responsibility for eit=
her the contents of the message or any copyright laws that may have been =
violated by the person sending this message.=20

Denel (Pty) Ltd is neither liable for the proper and complete transmissio=
n of the information contained in this communication nor any delay in its=
=20receipt.=20

This message should not be copied or used for any purpose other than inte=
nded, nor should it be disclosed to any other person.=20

*************************************************************************=
******************************=20

Re: [phpesp-general] when does 1.6 break? adminless upgrade?

[<ha...@mc...>]

I am dredging the memory banks, and I think there was a move from a 16 bit
password field that made me scratch my head when we upgarded databases.

Look here first.

Have fun...  Tom


> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642> _______________________________________________
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general

[phpesp-general] when does 1.6 break? adminless upgrade?

[Christopher K. <ck...@im...>]

Hi everyone.  For historical purposes (ok, laziness about changing 
something on a production box) I am running 1.6.1.  This week the 
authentication broke and I am unable to log in.  Public surveys 
appear to be working still, but none of us are able to log in (we 
loop back to the login).  I was wondering if there is a reason that I 
would break under php 4.4.2?  When I eventually get around to 
cancelling the login I get a [ Incorrect User ID or Password, or your 
account has been disabled/expired. ]  message.  I know that it is 
actually the correct u/p and we never expire anything, so I am confused.

And lets assume that it is time for me to go to php 5.x.x and I need 
to upgrade to 1.8.2 -- I can log in and do everything in the shell to 
get it ready, but can anyone familiar with the process let me know if 
I will run into a problem because the login is failing?  My hope is 
that upgrading to 1.8 and switching to 5.x will magically make the 
login problem go away.

Thanks,

--chris




/////\\\\\/////\\\\\
Christopher G. Kolar
    Coordinator of Research and Evaluation
    Illinois Mathematics and Science Academy
  ck...@im...  -- 
<http://staff.imsa.edu/~ckolar>staff.imsa.edu/~ckolar --  PGP Public 
Key ID: 0x43879C9B  

[phpesp-general] Zero-Length CVS Exports

[Philip L. <phi...@gm...>]

Hi All,


I'm a relatively new user of phpESP and am having a problem with creating
CVS/Tab exports from my phpESP install.  

All exports from the management interface are downloading fine, but with
file sizes of zero.  I've searched through documentation on this issue and
found some suggestions related to modifying the
'admin/include/where/download.inc' file.  This has resulted in no changes to
the output file, but has lead me to believe that the function
'survey_generate_results' is operating but producing no output.  

I know it is operating because I've commented that line of code out and
watched system load and the request's return time.  The output is the empty
string in all cases however when it is running.  For reference I'm running
the phpESP environment, 1.8.2.  

Any suggestions?

Philip

[phpesp-general] Population script via phpMyAdmin?

[Joseph W. <jw...@bu...>]

Hello all,



Thank you for your consideration of my newbie troubles.  I am having trouble running the population script off of phpMyAdmin.  I currently use 1&1 internet and have created a database, which has been given the name db174209121 and resides on a different server (db487.perfora.net) than where my web server is (s169227519.onlinehome.us).



My web server has a subdirectory, which I have a domain name pointed to.  In that subdirectory, I have phpESP installed to another subdirectory, called "phpESP."



Whenever I open phpMyAdmin from my server admin to run any of the following commands (to try to find the script):



$ mysql -u root -p db174209121 < s169227519.onlinehome.us/josephjwilk/phpESP/scripts/db/mysql_populate.sql

$ mysql -u root -p db174209121 < josephjwilk/phpESP/scripts/db/mysql_populate.sql

$ mysql -u root -p db174209121 < phpESP/scripts/db/mysql_populate.sql

$ mysql -u root -p db174209121 < scripts/db/mysql_populate.sql



I get the following result (verbatim, except for the [insert path] which is just a copy of what I used to try and find the database):



SQL query:



$ mysql - u root - p db174209121 & lt;



phpESP / scripts / db / mysql_populate.sql



MySQL said: 



#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 '$ mysql -u root -p db174209121 < [insert path]/scripts/db/mysql_popula 



I also tried installing to my web space's root, from which I tried the following commands:



$ mysql -u root -p db174209121 < phpESP/scripts/db/mysql_populate.sql

$ mysql -u root -p db174209121 < scripts/db/mysql_populate.sql



with exactly the same result.



1&1 has MySQL 4 & PHP 5 installed.  It seems like I'm not even getting the install script to run in the first place.  Does anyone have any ideas for what I might be able to do to get phpESP running?  Thank you all so much for your time.



Best wishes,

Joseph Wilk

Re: [phpesp-general] Forgotten root password

[James D. <ja...@jm...>]

Stuart Hunter wrote:
> Aaarghhh, I set up phpESP in May and my survey has been running nicely
> since
> them, now it is time to collate the results and I find I have forgotten the
> root password!!!!  Tried all my usual suspects.
> 
> Any way to reset it?

Login to mysql and select your phpESP database. The following command
should set your password.

update designer set password=password('passwordhere') where username =
'root';

HTH,

James

[phpesp-general] Forgotten root password

[Stuart H. <st...@sp...>]

Aaarghhh, I set up phpESP in May and my survey has been running nicely since
them, now it is time to collate the results and I find I have forgotten the
root password!!!!  Tried all my usual suspects.

Any way to reset it?

Re: [phpesp-general] Broken links

[James D. <ja...@jm...>]

James Davis wrote:
> I'm installing phpesp on a Debian Sarge system. I've successfully logged
> into my phpesp install but all my links on the management interface page
> appear to be broken. What should be

I think it's something to do with placing the files into the root of the
 virtual domain, copying the files to a folder

http://surveys.free.charity.org.uk/phpESP/

corrects the problem. Is there a way of running the files directly
within the root of the virtual domain?

James



-- 
http://www.freecharity.org.uk/ - Free hosting for charities
http://jamesd.ukgeeks.co.uk/

[phpesp-general] Broken links

[James D. <ja...@jm...>]

I'm installing phpesp on a Debian Sarge system. I've successfully logged
into my phpesp install but all my links on the management interface page
appear to be broken. What should be

http://surveys.free.charity.org.uk/admin/manage.php?where=groups

appears as...

http://admin/manage.php?where=groups

Any ideas what I've done wrong?

Many thanks,

James

-- 
http://www.freecharity.org.uk/ - Free hosting for charities
http://jamesd.ukgeeks.co.uk/

[phpesp-general] Can't log out

[Alan M. <am...@ab...>]

I have been running 1.8.1 on a FreeBSD server for some time with no problems.

The client wanted me to install on their server (windows) and I used the
1.8.2  code I d/l'd over the weekend.

Everything works great except when I try to log off. I get the following:

Warning: session_destroy(): Session object destruction failed in
d:\Domains\example.com\wwwroot\phpESP\admin\include\lib\espauth-default.inc
on line 271
Logged out.
Log back in.

And when I click the "Log back in." link, I don't get prompted to log in.
If I close the browser and relaunch, then I can log in again.

Any ideas?

---

Here is the result of admin/test.php:

PHP Information

    * Version: 4.3.9
    * OS: WINNT
    * SAPI: cgi-fcgi
    * register_globals: No
    * magic_quotes_gpc: Yes
    * magic_quotes_runtime: No
    * safe_mode: No
    * open_basedir:

PHP Extensions

    * dBase: No
    * GD: Yes -- bundled (2.0.15 compatible)
    * GNU Gettext: No
    * LDAP: No
    * MySQL: Yes
    * PHP Extension Dir (compiled): c:\php4
    * PHP Extension Dir (run time): ./

phpESP Settings

    * Expected ESP_BASE: d:\Domains\example.com\wwwroot\phpESP/
    * Expected base_url: www.example.com/
    * Loading phpESP.ini.php ...
    * ESP_BASE: d:\Domains\example.com\wwwroot\phpESP/
    * base_url:
      Notice: Undefined index: REQUEST_URI in
d:\Domains\example.com\wwwroot\phpESP\admin\test.php on line 130
      http://www.example.com/phpESP/
    * Version: 1.8.2
    * Debug: No

phpESP Language Settings

    * GNU Gettext: Emulated
    * default_lang: en_US
    * current lang: en_US
    * available langs: da_DK, de_DE, el_GR, en_US, es_ES, fi, fi_FI,
fr_FR, hu_HU, it_IT, ja_JP, nl_NL, pt_BR, pt_PT, sv_SE
      (da, de, el, en, es, fi, fr, it, ja, nl, pt, sv)
    * GNU Gettext test: %%%% Gettext Test Failed
    * Catalog Open Test: Yes

PHP Session Test

    * session.save_path: D:\PHP\sessiondata
    * Counter: 1

Thanks!

[phpesp-general] Problem when i include the survey

[lfj <blo...@gm...>]

With the new version 1.8.2, when I include my survey in a page and I don't
fill all the required questions it reffers to phpESP/public/survey.php
instead of the page it's included.

In the old version 1.8.1 it didn't reffer to phpESP/public/survey.php when
not all the required fields were filled.

I would like to know how I can fix it.

TIA

[phpesp-general] Problem logging in

[Ian S. <mfo...@ya...>]

None of my respondent accounts can log in.  I can only
log into the admin panel.

The message I get is:

"
[ Incorrect User ID or Password, or your account has
been disabled/expired. ]
"

The output of test.php is:

PHP Information

    * Version: 4.3.10
    * OS: Linux
    * SAPI: cgi
    * register_globals: No
    * magic_quotes_gpc: Yes
    * magic_quotes_runtime: No
    * safe_mode: No
    * open_basedir:

PHP Extensions

    * dBase: No
    * GD: Yes -- bundled (2.0.28 compatible)
    * GNU Gettext: Yes
    * LDAP: Yes
    * MySQL: Yes
    * PHP Extension Dir (compiled): /usr/lib/php4
    * PHP Extension Dir (run time): /usr/lib/php4

phpESP Settings

    * Expected ESP_BASE: /var/www/html/vote/
    * Expected base_url: www.e-aa.org/vote/
    * Loading phpESP.ini.php ...
    * ESP_BASE: /var/www/html/vote/
    * base_url: http://www.e-aa.org/vote/
    * Version: 1.8.2
    * Debug: Yes

phpESP Language Settings

    * GNU Gettext: Real
    * default_lang: en_US
    * current lang: en_US
    * available langs: da_DK, de_DE, el_GR, en_US,
es_ES, fi, fi_FI, fr_FR, hu_HU, it_IT, ja_JP, nl_NL,
pt_BR, pt_PT, sv_SE
      (da, de, el, en, es, fi, fr, it, ja, nl, pt, sv)
    * GNU Gettext test: Passed
    * Catalog Open Test: Yes

PHP Session Test

    * session.save_path: /tmp
    * Counter: 2


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[phpesp-general] install-errors ....while proceeding the mysql-population

[Urs B. <urs...@we...>]

Dear all phpESP user and developers. 


i am kinda new to the list here.  I have learned about phpESP  some days ago and have been  thrilled to see an open source  project to help with surveys.  However, as soon as I tried to install  it, I ran into problems.  Apparantly, i got stuck within the installation routine; sorry for being the newbie here. 


so what happened: after creating the db with my phpMyadmin-tool i wanted to populate the db with the mysql-populate-file; while executing the sql-statement on phpMyadmin-frontend i got a error back; 

MySQL response:  #1064 - You have an error in your SQL syntax near 'CURRENT_TIMESTAMP,PRIMARY KEY(name))' at line 27 


what is wrong here - what can i do!?

Any help provide would be much appreciated here


urs


ps. the phpESP is a great tool and i like it much! 


_____________________________________________________________________
Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
http://smartsurfer.web.de/?mc=100071&distributionid=000000000071

Re: [phpesp-general] new install, can not get past login screen

[Sridhar <sr...@gm...>]

 <WaltHodges <at> financial.wellsfargo.com> writes:

> 
> when accessing
> 	 x.x.x.x/phpESP
> I am redirected to: 
> 	http://x.x.x.x/phpESP/admin/manage.php
> 	
> 	phpESP Management Login
> 	Login
> 	Password
> 
> I have followed the install instructions and have modified mysql_create.sql 
to accommodate this change:
> 		INSERT INTO user (host, user, password) VALUES ( 'localhost','phpesp
', PASSWORD('happy'));
> 
> I have followed the install instructions and have modified phpESP.ini.php to 
accommodate this change:
> // Database connection information
> $ESPCONFIG['db_host'] = 'localhost';
> $ESPCONFIG['db_user'] = 'phpesp';
> $ESPCONFIG['db_pass'] = 'happy';
> $ESPCONFIG['db_name'] = 'phpesp';
> 
> when I submit phpesp & happy, I receive:
> [ Incorrect User ID or Password, or your account has been disabled/expired. ]
> 
> Please point me to where I might correct this error as I am unable to login 
to verify account expiration.
> 
> Thanks,
> 
> Walt Hodges
> 
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid0709&bid&3057&dat1642
> 


Log in as 'root' as the username and 'esp' as the password. You shouldn't use 
your MySQL DB access info to log in as admin.

Regards,
Sridhar (http://www.sridhareena.com)