You can subscribe to this list here.
2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(13) |
Dec
(16) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2002 |
Jan
(46) |
Feb
(68) |
Mar
(90) |
Apr
(38) |
May
(35) |
Jun
(36) |
Jul
(32) |
Aug
(35) |
Sep
(36) |
Oct
(49) |
Nov
(64) |
Dec
(31) |
2003 |
Jan
(70) |
Feb
(35) |
Mar
(74) |
Apr
(50) |
May
(26) |
Jun
(24) |
Jul
(26) |
Aug
(45) |
Sep
(18) |
Oct
(21) |
Nov
(33) |
Dec
(13) |
2004 |
Jan
(40) |
Feb
(53) |
Mar
(48) |
Apr
(51) |
May
(39) |
Jun
(9) |
Jul
(11) |
Aug
(30) |
Sep
(30) |
Oct
(12) |
Nov
(8) |
Dec
(12) |
2005 |
Jan
(37) |
Feb
(43) |
Mar
(57) |
Apr
(33) |
May
(23) |
Jun
(26) |
Jul
(43) |
Aug
(27) |
Sep
(39) |
Oct
(17) |
Nov
(27) |
Dec
(5) |
2006 |
Jan
(7) |
Feb
(35) |
Mar
(32) |
Apr
(39) |
May
(5) |
Jun
(4) |
Jul
(3) |
Aug
(6) |
Sep
(3) |
Oct
(17) |
Nov
(9) |
Dec
(10) |
2007 |
Jan
(2) |
Feb
(8) |
Mar
(14) |
Apr
(5) |
May
(2) |
Jun
(17) |
Jul
(13) |
Aug
(8) |
Sep
(3) |
Oct
(1) |
Nov
(40) |
Dec
(25) |
2008 |
Jan
(15) |
Feb
(13) |
Mar
(21) |
Apr
(44) |
May
(17) |
Jun
(26) |
Jul
(3) |
Aug
(10) |
Sep
|
Oct
(2) |
Nov
(6) |
Dec
|
2009 |
Jan
(14) |
Feb
(21) |
Mar
(9) |
Apr
(11) |
May
(4) |
Jun
|
Jul
(3) |
Aug
(9) |
Sep
(1) |
Oct
(4) |
Nov
(11) |
Dec
(6) |
2010 |
Jan
(8) |
Feb
|
Mar
(8) |
Apr
(1) |
May
|
Jun
(8) |
Jul
|
Aug
(4) |
Sep
(5) |
Oct
(4) |
Nov
|
Dec
|
2011 |
Jan
(2) |
Feb
(1) |
Mar
(1) |
Apr
(2) |
May
|
Jun
(3) |
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
2012 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(4) |
Oct
|
Nov
(2) |
Dec
(2) |
2013 |
Jan
(1) |
Feb
|
Mar
(15) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2014 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
(13) |
Oct
(1) |
Nov
|
Dec
|
2016 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
(1) |
Jun
(3) |
Jul
|
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
|
2017 |
Jan
(3) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: Matthew G. <gr...@mu...> - 2005-03-15 22:45:07
|
I think you've found a bug. I'm looking at it. On Fri, 2005-03-11 at 13:49 -0500, weisberg wrote: > Thank you for the response. I'm running ESP 1.7 (from the web site). My > test.php results follow: > > PHP Information > > * Version: 4.3.10 > * OS: Linux > * SAPI: apache2handler > * register_globals: Yes > * magic_quotes_gpc: No > * 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/phpESP/ > * Expected base_url: iamboard.hopto.org/phpESP/ > * Loading phpESP.ini.php ... > * ESP_BASE: /var/www/html/phpESP/ > * base_url: https://iamboard.hopto.org/phpESP/ > * Version: 1.7 > * Debug: No > > phpESP Language Settings > > * GNU Gettext: Real > * default_lang: en_US > * current lang: en_US > * available langs: es_ES, nl_NL, el_GR, fi_FI, ja_JP, fr_FR, de_DE, hu_HU, > pt_PT, pt_BR, en_US, fi, da_DK, sv_SE, it_IT > (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: /var/lib/php/session > * Counter: 3 > > > ------ > > Thank you once again > > Michael > > > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click > _______________________________________________ > phpESP-general mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-general > -- mcg ------------------------------------- The IT Lab (http://www.itlab.musc.edu) |
From: Matthew G. <gr...@mu...> - 2005-03-15 22:42:45
|
I know of no known issues that could cause this. Something with your setup. Perhaps a very short timeout or very low memory limit set in you php.ini? Please provide the output of phpesp/admin/test.php. On Tue, 2005-03-15 at 12:09 -0800, Jesse Lenihan wrote: > I'm having a problem with surveys fully posting for the end user. About > 1-in-5 to 1-in-10 page loads fail to completely load. The first half to > three quarters of the page will load, but the rest of the questions as > well as the submit button are missing. Refreshing the page often but not > always fixes the problem. > Any assistance would be appreciated. > Jesse Lenihan > University Place School District > Tech Services/Web Design > > PhpESP v1.6.1 > Apache/2.0.48 (Unix) DAV/2 PHP/4.3.4 > Running on OS X - v10.3.7 > > > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click > _______________________________________________ > phpESP-general mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-general > > -- mcg ------------------------------------- The IT Lab (http://www.itlab.musc.edu) |
From: Jesse L. <jle...@up...> - 2005-03-15 20:10:27
|
I'm having a problem with surveys fully posting for the end user. About 1-in-5 to 1-in-10 page loads fail to completely load. The first half to three quarters of the page will load, but the rest of the questions as well as the submit button are missing. Refreshing the page often but not always fixes the problem. Any assistance would be appreciated. Jesse Lenihan University Place School District Tech Services/Web Design PhpESP v1.6.1 Apache/2.0.48 (Unix) DAV/2 PHP/4.3.4 Running on OS X - v10.3.7 |
From: Mark R. <mar...@co...> - 2005-03-15 04:26:30
|
Thank you for your message. I will be out of town until Friday March 18. While I will be checking voicemails and emails I ask your patience as my response time may be slower than normal. If you need immediate assistance please contact my office at 717-299-3822. Mark Rebert 717.666.4072 Managing Director |
From: Matthew G. <gr...@mu...> - 2005-03-15 01:41:56
|
You're probably seeing the mySQL 4.1 password length bug. mySQL changed the password hash length from in versin 4.1. Did the ESP, mySQL create/update scripts run successfully? This is the bug: http://sourceforge.net/tracker/index.php?func=detail&aid=1153614&group_id=8956&atid=108956 it's fixed in CVS. If this is a new ESP install, I would drop the DB and recreate using the mySQL scripts from CVS. Unfortunately, SourceForges public CVS is down at the moment so I can't link directly to the files. Browse CVS from here http://sourceforge.net/cvs/?group_id=8956 get the latest mysql_populate.sql script from the scripts/db directory. On Mon, 2005-03-14 at 20:27 -0500, L. Curtis Muldrew wrote: > To provide further clarification, I am running PHP as a module. > > From my http.conf file: > LoadModule php4_module "c:/Program > Files/php-4.3.10-Win32/sapi/php4apache2.dll" > > AddType application/x-httpd-php .php > > Configuration: > Apache 2 > Windows XP SP2 > PHP 4.3.10 > MySQL 4.1 > phpESP 1.7 > > Again any assistance would be appreciated. > > L. Curtis Muldrew > L.C...@th... > > > > L. Curtis Muldrew wrote: > > When I am prompted for the "Management Interface" credentials, I type > > the following: > > > > Username: root > > Password: esp > > > > phpESP does not accept these credentials, and it continues to prompt me > > for a username and password. > > > > Any assistance would be appreciated. > > > > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click > _______________________________________________ > phpESP-general mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-general > > -- mcg ------------------------------------- The IT Lab (http://www.itlab.musc.edu) |
From: L. C. M. <l.c...@th...> - 2005-03-15 01:28:08
|
To provide further clarification, I am running PHP as a module. From my http.conf file: LoadModule php4_module "c:/Program Files/php-4.3.10-Win32/sapi/php4apache2.dll" AddType application/x-httpd-php .php Configuration: Apache 2 Windows XP SP2 PHP 4.3.10 MySQL 4.1 phpESP 1.7 Again any assistance would be appreciated. L. Curtis Muldrew L.C...@th... L. Curtis Muldrew wrote: > When I am prompted for the "Management Interface" credentials, I type > the following: > > Username: root > Password: esp > > phpESP does not accept these credentials, and it continues to prompt me > for a username and password. > > Any assistance would be appreciated. > |
From: L. C. M. <l.c...@th...> - 2005-03-14 23:03:43
|
When I am prompted for the "Management Interface" credentials, I type the following: Username: root Password: esp phpESP does not accept these credentials, and it continues to prompt me for a username and password. Any assistance would be appreciated. -- L. Curtis Muldrew L.C...@th... |
From: fa <sf...@mt...> - 2005-03-12 03:11:23
|
`E`E`E`E`E`E`E`E`E`E`E`E`E`E`E`E` jÅ̱lÁÄá¤ñ¾ËIH´^ȺÉÀÁÄl¾Á½èc »ñÈ´^ȺÅà¦Á¿D«ÈØÅ·I ȽÌD«È^CvÍúH »êÆà©ªÅê©ççÄéÙ¤H ¢ëñÈyµÝ´¶Ä¾³¢B http://beauti-channel.com/a-t/ ÉÅ«¥µ¿áÁ½lȳñÌ̱ȳc´¶¿á¢Ü·æËIH qª éöxå«ÈÁÄ«½ç âÁÏècöµ½¢ÁÄv¤Ý½Å·æA«ÍII Å·æË¥cUߪèµÄêÈ©Á½çc»Á¿èÜ·æËc http://beauti-channel.com/a-t/ `E`E`E`E`E`E`E`E`E`E`E`E`E`E`E`E` oq NWbgJ[hÌVbsOgð»à» XsvE³R¸E³_ñE¦ú¨U J[hªÈÄàåäv ¨dbĄ̊\ http://59862777.com/ Øèüê̽¢ûAXÌx¥¢àz̽¢ûÉàIXXÅ·B ¦¾ÐÍÁïÒàZÅͲ´¢Ü¹ñ oq `E`E`E`E`E`E`E`E`E`E`E`E`E`E`E`E` CɵȢûͱ¿çÅCɵȢMðc pau...@ya... |
From: Matthew G. <gr...@mu...> - 2005-03-11 20:50:44
|
Crosstab functionality may have some unconfirmed bugs and may get removed soon if someone doesn't pickup support for it. Search the mail/bug list for details. You're probably better off, exporting and doing analysis outside of ESP. On Fri, 2005-03-11 at 12:03 -0800, David Liontooth wrote: > What is the status of the crosstab functionality? A friend's student > writes, > > Professor, > > I'm trying to figure out how to cross-tabulate the results from my survey > so that I can find out when people answer to spending more than x amount > of time playing video games, what their other answers are. I don't want > to hand by hand go through 90 surveys. > > Thanks! > Megan > > > Is this something phpESP can deal with? Please respond to the list > and cc: Megan <mte...@uc...> > > I'd in general be interested to hear how people use crosstab, and > any instructions available. > > Dave > > > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click > _______________________________________________ > phpESP-general mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-general > -- mcg ------------------------------------- The IT Lab (http://www.itlab.musc.edu) |
From: David L. <lio...@co...> - 2005-03-11 20:04:05
|
What is the status of the crosstab functionality? A friend's student writes, Professor, I'm trying to figure out how to cross-tabulate the results from my survey so that I can find out when people answer to spending more than x amount of time playing video games, what their other answers are. I don't want to hand by hand go through 90 surveys. Thanks! Megan Is this something phpESP can deal with? Please respond to the list and cc: Megan <mte...@uc...> I'd in general be interested to hear how people use crosstab, and any instructions available. Dave |
From: weisberg <wei...@sy...> - 2005-03-11 18:49:07
|
Thank you for the response. I'm running ESP 1.7 (from the web site). My test.php results follow: PHP Information * Version: 4.3.10 * OS: Linux * SAPI: apache2handler * register_globals: Yes * magic_quotes_gpc: No * 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/phpESP/ * Expected base_url: iamboard.hopto.org/phpESP/ * Loading phpESP.ini.php ... * ESP_BASE: /var/www/html/phpESP/ * base_url: https://iamboard.hopto.org/phpESP/ * Version: 1.7 * Debug: No phpESP Language Settings * GNU Gettext: Real * default_lang: en_US * current lang: en_US * available langs: es_ES, nl_NL, el_GR, fi_FI, ja_JP, fr_FR, de_DE, hu_HU, pt_PT, pt_BR, en_US, fi, da_DK, sv_SE, it_IT (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: /var/lib/php/session * Counter: 3 ------ Thank you once again Michael |
From: Matthew G. <gr...@mu...> - 2005-03-11 18:19:09
|
Please provide more details of your installation. ESP version, output from test.php, etc.. On Fri, 2005-03-11 at 13:06 -0500, weisberg wrote: > Ok, I've searched the archive, so I have to ask: > > I've just installed phpESP, built a survey, made it private, added a group > with <Forward/Back> and <Save>, tested, and made the survay active. I can > enter responses, and if I complete the survey everything is fine. (i.e. it is > tallied, results are recorded, etc.) If I try to save, and go back in via the > link presented, after re-authenticating I am returned to the beginning of the > survey with no previous answers displayed. > > What am I doing wrong? > > Michael > > > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click > _______________________________________________ > phpESP-general mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-general > -- mcg ------------------------------------- The IT Lab (http://www.itlab.musc.edu) |
From: weisberg <wei...@sy...> - 2005-03-11 18:06:10
|
Ok, I've searched the archive, so I have to ask: I've just installed phpESP, built a survey, made it private, added a group with <Forward/Back> and <Save>, tested, and made the survay active. I can enter responses, and if I complete the survey everything is fine. (i.e. it is tallied, results are recorded, etc.) If I try to save, and go back in via the link presented, after re-authenticating I am returned to the beginning of the survey with no previous answers displayed. What am I doing wrong? Michael |
From: Matthew G. <gr...@mu...> - 2005-03-10 15:15:08
|
You should probably file a proper bug report on Source Forge with more details of your installation, ESP version etc... On Thu, 2005-03-10 at 09:09 -0600, Christopher Rivard wrote: > In a previous version of php-ESP, I had been using the functionality that > lets me display the real-time results on a public web page. Like so (from > the documentation): > > "If you would like to insert the (real-time) results of a survey into a web > page, use the following PHP code. > > <?php $sid=SID; $results=1; > include('F:\wwwroot\home\survey\admin/public/handler.php'); ?>" > > Since upgrading, I have been getting errors on my results page (actual > results display correctly below the errors): > > Notice: Undefined variable: precision in > F:\wwwroot\home\survey\admin\public\handler.php on line 37 > > Notice: Undefined variable: totals in > F:\wwwroot\home\survey\admin\public\handler.php on line 37 > > Notice: Undefined variable: qid in > F:\wwwroot\home\survey\admin\public\handler.php on line 37 > > Notice: Undefined variable: cids in > F:\wwwroot\home\survey\admin\public\handler.php on line 37 > > Do I need to provide values for those variables (precision, totals, qid, > cids), before calling the handler include? > > Thank you in advance for any information anyone can give me. -- mcg ------------------------------------- The IT Lab (http://www.itlab.musc.edu) |
From: Christopher R. <ri...@uw...> - 2005-03-10 15:09:09
|
In a previous version of php-ESP, I had been using the functionality that lets me display the real-time results on a public web page. Like so (from the documentation): "If you would like to insert the (real-time) results of a survey into a web page, use the following PHP code. <?php $sid=SID; $results=1; include('F:\wwwroot\home\survey\admin/public/handler.php'); ?>" Since upgrading, I have been getting errors on my results page (actual results display correctly below the errors): Notice: Undefined variable: precision in F:\wwwroot\home\survey\admin\public\handler.php on line 37 Notice: Undefined variable: totals in F:\wwwroot\home\survey\admin\public\handler.php on line 37 Notice: Undefined variable: qid in F:\wwwroot\home\survey\admin\public\handler.php on line 37 Notice: Undefined variable: cids in F:\wwwroot\home\survey\admin\public\handler.php on line 37 Do I need to provide values for those variables (precision, totals, qid, cids), before calling the handler include? Thank you in advance for any information anyone can give me. -- Christopher Rivard University of Wisconsin-Stout (715)232-5267 |
From: Matthew G. <gr...@mu...> - 2005-03-10 14:15:05
|
You should confirm that your bug isn't already fixed, by searching the bug list on Source Forge. If it's not, file a new bug. On Wed, 2005-03-09 at 19:15 -0800, David Liontooth wrote: > In the "Survey Design" page, under the General tab, is a line that reads > > The information on this tab applies to the whole survey. Fill out > this page then go to the Fields tab to edit individual fields. > > However, the "Fields" tab no longer exists -- it's called "Questions". > > How does stuff like that get corrected? > > Dave > > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click > _______________________________________________ > phpESP-general mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-general > -- mcg ------------------------------------- The IT Lab (http://www.itlab.musc.edu) |
From: David L. <lio...@co...> - 2005-03-10 03:16:52
|
In the "Survey Design" page, under the General tab, is a line that reads The information on this tab applies to the whole survey. Fill out this page then go to the Fields tab to edit individual fields. However, the "Fields" tab no longer exists -- it's called "Questions". How does stuff like that get corrected? Dave |
From: David L. <lio...@co...> - 2005-03-10 03:14:52
|
When you archive a survey in phpESP, the survey is removed from view and the results become inaccessible. The following is what you can do to reinstate an archived survey -- it's submitted here for the record. In brief, you need to go into the mysql database that phpESP uses and reset the status of the archived survey. 1. First you need to locate the ID of the survey -- the number assigned consequtively to each new survey. If you already have this information, you can skip this step. To locate the ID, issue mysql -e 'select * from survey order by changed desc limit 5' phpesp | more This asks for a listing, in descending order, of the latest changes made to the fields in the survey table. Set the limit to ensure your archived survey is included; you can use a range such as 10,15. The status field of the archived survey in my case was set to 15; an active survey has status 1. 2. Second, to be on the safe side, you may want to backup your table of surveys, in case something goes wrong: mysqldump phpesp survey > survey-table-backup-2005-03-09.txt If you need to recreate the survey table, you have the data in this file. 3. Third, take out the knife and perform a slight incision and surgical manipulation as follows: mysql -e 'update survey set status = 1 where id=101' phpesp The number -- in this example 101 -- is the ID of your survey, determined in step 1 above. That's all there's to it. The archived survey is now reactivated, and the results are again available. Dave P.S. In order to use "mysql -e" and "mysqldump" commands in this manner, you need to have your user name and password entered in a file called ~/.my.cnf. Alternatively you can add "-u root -p" to the commands and enter the password manually: mysql -u root -p -e 'select * from survey order by changed desc limit 5' phpesp Finally, changing the status of a survey is likely also possible from phpmyadmin, a web interface to your mysql databases; I've just installed it and not played around with it much, but it has a very user-friendly interface. |
From: David L. <lio...@co...> - 2005-03-10 02:13:39
|
Hi Brian, Thank you for the instructions. Brian Wood wrote: > David, > > You can often find your answer by searching the mailing list archive > (linked from the phpESP homepage). > > http://sourceforge.net/mailarchive/message.php?msg_id=5559358 This is good, but the line below is the real goods. I was able to change the status successfully, to the immense relief of my student. The status of the survey when I looked in the database was 15, and I changed it to 1. I'll post the steps for reference. Best, Dave > > The SQL would be: > > update survey set status = 1 where id='[id]' > > [id] is the id number of the survey. > > Be really careful running update sql statements. if you get the Where > clause wrong you can overwrite data. > > Brian Wood > Programmer/Analyst > UC Berkeley Human Resources > > > > David Liontooth wrote: > >> One of my students accidentally archived a survey, and now cannot >> access the results. >> Is there a way to retrieve them -- even in comma-delimited form? >> >> Dave >> >> >> ------------------------------------------------------- >> SF email is sponsored by - The IT Product Guide >> Read honest & candid reviews on hundreds of IT Products from real users. >> Discover which products truly live up to the hype. Start reading now. >> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click >> _______________________________________________ >> phpESP-general mailing list >> php...@li... >> https://lists.sourceforge.net/lists/listinfo/phpesp-general > > > > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click > _______________________________________________ > phpESP-general mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-general |
From: Brian W. <br...@be...> - 2005-03-09 20:24:48
|
David, You can often find your answer by searching the mailing list archive (linked from the phpESP homepage). http://sourceforge.net/mailarchive/message.php?msg_id=5559358 The SQL would be: update survey set status = 1 where id='[id]' [id] is the id number of the survey. Be really careful running update sql statements. if you get the Where clause wrong you can overwrite data. Brian Wood Programmer/Analyst UC Berkeley Human Resources David Liontooth wrote: > One of my students accidentally archived a survey, and now cannot > access the results. > Is there a way to retrieve them -- even in comma-delimited form? > > Dave > > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click > _______________________________________________ > phpESP-general mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-general |
From: David L. <lio...@co...> - 2005-03-09 19:58:17
|
One of my students accidentally archived a survey, and now cannot access the results. Is there a way to retrieve them -- even in comma-delimited form? Dave |
From: dasf <sa...@ma...> - 2005-03-09 18:28:55
|
Q/Q/Q/Q/Q/Q/Q/Q/Q/Q/Q/Q/Q/Q/Q/Q/ äXÍ¢ÂàÌ\âss`àð©Ä«½B ±±Å긮µÄ¢±¤Æv¤B »ÌOÉ È½ûÆÓ©â¼Éà 鯢¤\âss`àðbµÁÄ¢«½¢ http://sunstory.info/ps/uwasa/ ±êͱÌn ã±ÌuÔÌ éêÌ\âss`à¾ÆvíêéB ū龯Ì\âss`àðÝñÈÉL°Ä¢±¤!! http://sunstory.info/ps/uwasa/ Q/Q/Q/Q/Q/Q/Q/Q/Q/Q/Q/Q/Q/Q/Q/Q/ ss`à¢È Ƚͱ±ÉÔðêI ßµ¢±Æ¾ª¨Êê¾B pau...@ya... |
From: Jack C. <jc...@uo...> - 2005-03-05 16:25:41
|
I am interested in doing a direct database extract of survey response data into another database. Is there a schematic diagram of the database design for phpESP available that would illustrate the table relationships? I'm using mysql query generator tool to explore the database, but I can't figure out some of the relationships between the response types and question tables.. Cheers, Jack Cooper, University of Guelph |
From: Matthew G. <gr...@mu...> - 2005-03-04 21:04:44
|
Either your server for some reason isn't providing $server['HTTP_HOST'] or your edits have corrupted phpesp.ini in some way. Can you send me the output of test.php(in the admin directory of the phpesp install). What version of ESP are you using? On Fri, 2005-03-04 at 15:44 -0500, Ron Wheeler wrote: > I have got it installed to the point where I can get through the login. > > It is not putting the HTTP_HOST in the addresses that it generates for > the menus. > The menus have hrefs as shown in the view source shown below. > > <table border="0" cellspacing="0" cellpadding="0" align="center"><tr><td> > > <ul> > <li><a href="//admin/manage.php?where=new">Create a New Survey</a></li> > <li><a href="//admin/manage.php?where=edit">Edit an Existing Survey</a></li> > <li><a href="//admin/manage.php?where=test">Test a Survey</a></li> > <li><a href="//admin/manage.php?where=copy">Copy an Existing Survey</a></li> > <li><a href="//admin/manage.php?where=status">Change the Status of a Survey</a> > > (active/end/delete)</li> > > > Clicking on a menu item sends me to odd sites but not where I want to > go - the menu item. > > The top of my phpESP.ini.php is as follows. > I changes the username and password and modified the following line > since the code is not under a phpesp subdirectory. > $ESPCONFIG['base_url'] = 'http://' . $server['HTTP_HOST'] . '/'; > > > <?php > > # $Id: phpESP.ini.php,v 1.13.2.1 2003/04/23 00:07:09 jimmerman Exp $ > > // Written by James Flemer > // For eGrad2000.com > // <jf...@al...> > > if (!defined('ESP_BASE')) define('ESP_BASE', dirname(dirname(__FILE__)) > .'/'); > if (isset($_SERVER)) $server =& $_SERVER; > else $server =& $HTTP_SERVER_VARS; > > /** > * Here are all the configuration options. > */ > > // Base URL for phpESP > // The string $server['HTTP_HOST'] will be replaced by the server name > $ESPCONFIG['base_url'] = 'http://' . $server['HTTP_HOST'] . '/'; > > // URL of the images directory (for <img src='...'> tags) > $ESPCONFIG['image_url'] = $ESPCONFIG['base_url'] . 'images/'; > > // URL of the automatic survey publisher > $ESPCONFIG['autopub_url'] = $ESPCONFIG['base_url'] . 'public/survey.php'; > > // URL of the CSS directory (for themes) > $ESPCONFIG['css_url'] = $ESPCONFIG['base_url'] . 'public/css/'; > > // Database connection information > $ESPCONFIG['db_host'] = 'localhost'; > $ESPCONFIG['db_user'] = 'xxxxx'; > $ESPCONFIG['db_pass'] = 'yyyyy'; > $ESPCONFIG['db_name'] = 'phpesp'; > > // Allow phpESP to send email (BOOLEAN) > $ESPCONFIG['allow_email'] = true; > > > > Where are the menus created and what do I have to do to get the right URL? > > Ron > > > > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click > _______________________________________________ > phpESP-general mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-general > -- mcg ------------------------------------- The IT Lab (http://www.itlab.musc.edu) |
From: Ron W. <rwh...@ar...> - 2005-03-04 20:44:34
|
I have got it installed to the point where I can get through the login. It is not putting the HTTP_HOST in the addresses that it generates for the menus. The menus have hrefs as shown in the view source shown below. <table border="0" cellspacing="0" cellpadding="0" align="center"><tr><td> <ul> <li><a href="//admin/manage.php?where=new">Create a New Survey</a></li> <li><a href="//admin/manage.php?where=edit">Edit an Existing Survey</a></li> <li><a href="//admin/manage.php?where=test">Test a Survey</a></li> <li><a href="//admin/manage.php?where=copy">Copy an Existing Survey</a></li> <li><a href="//admin/manage.php?where=status">Change the Status of a Survey</a> (active/end/delete)</li> Clicking on a menu item sends me to odd sites but not where I want to go - the menu item. The top of my phpESP.ini.php is as follows. I changes the username and password and modified the following line since the code is not under a phpesp subdirectory. $ESPCONFIG['base_url'] = 'http://' . $server['HTTP_HOST'] . '/'; <?php # $Id: phpESP.ini.php,v 1.13.2.1 2003/04/23 00:07:09 jimmerman Exp $ // Written by James Flemer // For eGrad2000.com // <jf...@al...> if (!defined('ESP_BASE')) define('ESP_BASE', dirname(dirname(__FILE__)) .'/'); if (isset($_SERVER)) $server =& $_SERVER; else $server =& $HTTP_SERVER_VARS; /** * Here are all the configuration options. */ // Base URL for phpESP // The string $server['HTTP_HOST'] will be replaced by the server name $ESPCONFIG['base_url'] = 'http://' . $server['HTTP_HOST'] . '/'; // URL of the images directory (for <img src='...'> tags) $ESPCONFIG['image_url'] = $ESPCONFIG['base_url'] . 'images/'; // URL of the automatic survey publisher $ESPCONFIG['autopub_url'] = $ESPCONFIG['base_url'] . 'public/survey.php'; // URL of the CSS directory (for themes) $ESPCONFIG['css_url'] = $ESPCONFIG['base_url'] . 'public/css/'; // Database connection information $ESPCONFIG['db_host'] = 'localhost'; $ESPCONFIG['db_user'] = 'xxxxx'; $ESPCONFIG['db_pass'] = 'yyyyy'; $ESPCONFIG['db_name'] = 'phpesp'; // Allow phpESP to send email (BOOLEAN) $ESPCONFIG['allow_email'] = true; Where are the menus created and what do I have to do to get the right URL? Ron |