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

[phpesp-general] Default username and password?

[boardtc <bo...@gm...>]

I am recovering from a robbery last year which exposed holes in my backup
system. Fortunately my survey was online. I am trying to access the
manage.php and can't find the default username and password (admin & ?) in
the documentation, I did find it previously I think but can't see it now
sorry. I don't think I changed the default. What are the defaults please so
I can get into my survey results.

Thanks,

Tom.

[phpesp-general] Japanese characters in survey answer - problem

[<pe...@se...>]

I'm currently setting up a survey in Japanese but there are some=20
problems...

The questions and such shows up just fine when you're taking the survey.=20
The problems however, come when
I try to browse through the answers.=20

I've tried various page char.codings in the config file, like  UTF-8,=20
Shift=5FJIS, EUC-JP to no avail...

This is an example:

From a radiobutton:



都会

Answer in a textbox:




?=B1?=EA?=CD?e?X?g?=C5?=BF?=E3?=A4?=A4?=A4?=A4

How do i fix this? It's paramount that I'm able to see answers typed out=20
in Japanese.

Thanks in advance!

Regards,
Peter

Re: Fixed: [phpesp-general] Zero-length downloads (CSV-Problem)

[Peter F. <pe...@si...>]

Matthew Gregg wrote:
> I've commited a fix for this to CVS and will be releasing a 1.8.1 for 
> testing.

Excellent! Many thanks.

///Peter

Re: Fixed: [phpesp-general] Zero-length downloads (CSV-Problem)

[Matthew G. <mat...@gm...>]

I've commited a fix for this to CVS and will be releasing a 1.8.1 for
testing.

On 3/17/06, Peter Flynn <pe...@si...> wrote:
>
> Mar...@fi... wrote:
> > Howdy Aaron,
> >
> > for Internet Explorer:
> >
> > When using an attachement Content-Dispositon, it seems the following
> > headers are also required:
> >
> > header("Cache-Control: cache, must-revalidate");
> > header("Pragma: public");
> >
> > If you have Cache-Control as no-cache, IE fails.
> >
> > The header "Content-Type: application/force-download" is a hack as wel,
> > but fixed it for IE and FF.
>
> Thanks very much, I'll give it a try.
>
> My impression, though, was that initiating the download wasn't
> the problem. It's that phpESP simply wasn't generating the data.
> This seems to be confirmed by the fact that it also generates a
> zero-length file if you pick "Save to server", where downloading
> is not involved.
>
> ///Peter
>
> > ---- START phpESP/admin/include/where/download.inc ----
> >
> >         default:
> >             // CSV, csv_full_header old method, csv_short_header new
> > method
> >                 header("Cache-Control: cache, must-revalidate");
> >                 header("Pragma: public");
> >                 header("Content-Type: application/force-download");
> >                 header("Content-Disposition: attachment;
> > filename=3D$name.csv");
> >             $output =3D survey_generate_results($type, $sid);
> >             foreach ($output as $row ) {
> >                 echo(implode(',', $row) . "\r\n");
> >             }
> >
> > I have done several tests and those two lines fixed my script. (It was
> > trying to download a .csv)
> >
> > ---- END phpESP/admin/include/where/download.inc ----
> >
> > Cheers
> > Martin
> >
> >
> > php...@li... schrieb am 07.03.200618:45:3=
0:
> >
> >> -----BEGIN PGP SIGNED MESSAGE-----
> >> Hash: SHA1
> >>
> >>
> >>>> Patches against current CVS would be graciously accepted.
> >>> Maybe I can find a PHP hacker here who'd be interested.
> >> I think the main problem is finding someone who has time :).
> >>
> >>
> >>
> >> - -- Aaron
> >> -----BEGIN PGP SIGNATURE-----
> >> Version: GnuPG v1.4.2 (MingW32)
> >> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
> >>
> >> iD8DBQFEDca6uucONIvD0AMRAv0+AJ90PpWHi4Ld6qoHibXcJV6WfQtJjACeNc67
> >> i9VSNo73rRBYQ+NYR3uX8G8=3D
> >> =3Duyq3
> >> -----END PGP SIGNATURE-----
> >>
> >>
> >>
> >> -------------------------------------------------------
> >> This SF.Net email is sponsored by xPML, a groundbreaking scripting
> > language
> >> that extends applications into web and mobile media. Attend the live
> > webcast
> >> and join the prime developer group breaking into this new coding
> > territory!
> >>
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat=
=3D121642
> >> _______________________________________________
> >> phpESP-general mailing list
> >> php...@li...
> >> https://lists.sourceforge.net/lists/listinfo/phpesp-general
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by xPML, a groundbreaking scripting
> language
> > that extends applications into web and mobile media. Attend the live
> webcast
> > and join the prime developer group breaking into this new coding
> territory!
> >
> http://sel.as-us.falkag.net/sel?cmd______________________________________=
_________
> > phpESP-general mailing list
> > php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpesp-general
> >
> >
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting
> language
> that extends applications into web and mobile media. Attend the live
> webcast
> and join the prime developer group breaking into this new coding
> territory!
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat=
=3D121642
> _______________________________________________
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general
>



--
D'oh!

[phpesp-general] Re: [phpesp-dev] SPSS Export Function

[Aaron A. <li...@fr...>]

I have something completed which will need some testing.  Are there any
volunteers to help test the new export function against different
surveys?  I can provide a patch file.

We currently have quite a variety of surveys which I am using to test,
but its always helpful for another set of eye's to take a look at something.

Is anyone interested?

-- Aaron

Aaron Axelsen wrote:
> Hello,
>
> I am currently 90% done or so coding an export function to produce an
> csv file in the proper format suitable for spss.  Ill provide a patch
> against the cvs when completed.
>
> Just thought i'd alert the world of whats coming!
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting
> language
> that extends applications into web and mobile media. Attend the live
> webcast
> and join the prime developer group breaking into this new coding
> territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> _______________________________________________
> phpESP-devel mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel
>
>
> -- 
> Aaron Axelsen
> li...@fr...
>
> Great hosting, low prices.  Modevia Web Services LLC --
> http://www.modevia.com
>

[phpesp-general] Please help with another mysql_populate.sql issue. MySQL 5.0.18

[<dal...@ed...>]

Received the following error message when populating a new database with mysql_populate.sql.  Any ideas as to how to fix it?

I'm running:

MySQL 5.0.18-Debian_1

 MySQL said: Documentation
#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 '
    
    complete    ENUM('Y','N') NOT NULL DEFAULT 'N',
    username    CHAR(64),
    PRIMARY KEY 

' at line 10 

What's wrong with the statements above?

thanks.

Dale R Rogers
dal...@ed...

Re: Fixed: [phpesp-general] Zero-length downloads (CSV-Problem)

[Peter F. <pe...@si...>]

Mar...@fi... wrote:
> Howdy Aaron,
> 
> for Internet Explorer:
> 
> When using an attachement Content-Dispositon, it seems the following 
> headers are also required:
> 
> header("Cache-Control: cache, must-revalidate"); 
> header("Pragma: public");
> 
> If you have Cache-Control as no-cache, IE fails.
> 
> The header "Content-Type: application/force-download" is a hack as wel, 
> but fixed it for IE and FF.

Thanks very much, I'll give it a try.

My impression, though, was that initiating the download wasn't
the problem. It's that phpESP simply wasn't generating the data.
This seems to be confirmed by the fact that it also generates a
zero-length file if you pick "Save to server", where downloading
is not involved.

///Peter

> ---- START phpESP/admin/include/where/download.inc ----
> 
>         default:
>             // CSV, csv_full_header old method, csv_short_header new 
> method
>                 header("Cache-Control: cache, must-revalidate");
>                 header("Pragma: public");
>                 header("Content-Type: application/force-download");
>                 header("Content-Disposition: attachment; 
> filename=$name.csv");
>             $output = survey_generate_results($type, $sid);
>             foreach ($output as $row ) {
>                 echo(implode(',', $row) . "\r\n");
>             }
> 
> I have done several tests and those two lines fixed my script. (It was 
> trying to download a .csv)
> 
> ---- END phpESP/admin/include/where/download.inc ----
> 
> Cheers
> Martin
> 
> 
> php...@li... schrieb am 07.03.2006 18:45:30:
> 
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>>
>>>> Patches against current CVS would be graciously accepted.
>>> Maybe I can find a PHP hacker here who'd be interested.
>> I think the main problem is finding someone who has time :).
>>
>>
>>
>> - -- Aaron
>> -----BEGIN PGP SIGNATURE-----
>> Version: GnuPG v1.4.2 (MingW32)
>> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>>
>> iD8DBQFEDca6uucONIvD0AMRAv0+AJ90PpWHi4Ld6qoHibXcJV6WfQtJjACeNc67
>> i9VSNo73rRBYQ+NYR3uX8G8=
>> =uyq3
>> -----END PGP SIGNATURE-----
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by xPML, a groundbreaking scripting 
> language
>> that extends applications into web and mobile media. Attend the live 
> webcast
>> and join the prime developer group breaking into this new coding 
> territory!
>> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
>> _______________________________________________
>> phpESP-general mailing list
>> php...@li...
>> https://lists.sourceforge.net/lists/listinfo/phpesp-general
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> that extends applications into web and mobile media. Attend the live webcast
> and join the prime developer group breaking into this new coding territory!
> http://sel.as-us.falkag.net/sel?cmd_______________________________________________
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general
> 
> 

Fixed: [phpesp-general] Zero-length downloads (CSV-Problem)

[<Mar...@fi...>]

Howdy Aaron,

for Internet Explorer:

When using an attachement Content-Dispositon, it seems the following=20
headers are also required:

header("Cache-Control: cache, must-revalidate");=20
header("Pragma: public");

If you have Cache-Control as no-cache, IE fails.

The header "Content-Type: application/force-download" is a hack as wel,=20
but fixed it for IE and FF.

---- START phpESP/admin/include/where/download.inc ----

        default:
            // CSV, csv=5Ffull=5Fheader old method, csv=5Fshort=5Fheader ne=
w=20
method
                header("Cache-Control: cache, must-revalidate");
                header("Pragma: public");
                header("Content-Type: application/force-download");
                header("Content-Disposition: attachment;=20
filename=3D$name.csv");
            $output =3D survey=5Fgenerate=5Fresults($type, $sid);
            foreach ($output as $row ) {
                echo(implode(',', $row) . "\r\n");
            }

I have done several tests and those two lines fixed my script. (It was=20
trying to download a .csv)

---- END phpESP/admin/include/where/download.inc ----

Cheers
Martin


php...@li... schrieb am 07.03.2006 18:45:30:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>=20
>=20
> >> Patches against current CVS would be graciously accepted.
> >
> > Maybe I can find a PHP hacker here who'd be interested.
>=20
> I think the main problem is finding someone who has time :).
>=20
>=20
>=20
> - -- Aaron
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.2 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>=20
> iD8DBQFEDca6uucONIvD0AMRAv0+AJ90PpWHi4Ld6qoHibXcJV6WfQtJjACeNc67
> i9VSNo73rRBYQ+NYR3uX8G8=3D
> =3Duyq3
> -----END PGP SIGNATURE-----
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting=20
language
> that extends applications into web and mobile media. Attend the live=20
webcast
> and join the prime developer group breaking into this new coding=20
territory!
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat=
=3D121642
> =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=
=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general

[phpesp-general] SPSS Export Function

[Aaron A. <li...@fr...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
 
Hello,

I am currently 90% done or so coding an export function to produce an
csv file in the proper format suitable for spss.  Ill provide a patch
against the cvs when completed.

Just thought i'd alert the world of whats coming!

- --
Aaron Axelsen
li...@fr...

Great hosting, low prices.  Modevia Web Services LLC --
http://www.modevia.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
 
iD8DBQFEGYDzuucONIvD0AMRAi0eAJ4tz6c0IYJE/IS6Bi6NMjQJ0dKEygCfT5Sz
pD3Zjwh1VhW1vYeaIee8qDw=
=DTmy
-----END PGP SIGNATURE-----

[phpesp-general] PHPEsp and EasyPHP

[<Jea...@DM...>]

Hi,

I am new to PHPEsp and have installed it, ran the installation SQL 
scripts.

I can log in into PHPEsp and was able to change the password too.

But, when I attempt to create a new survey, I get the following error:

Has anyone seen this one? What would be the fix?

Fatal error: Call to a member function on a non-object in c:\program 
files\easyphp1-8\www\phpesp\admin\include\lib\espdatalib.inc on line 124 

Thanks!


Jean-Francois Gagnon

[phpesp-general] PHPEsp and EasyPHP

[<Jea...@DM...>]

Hi,

I am new to PHPEsp and have installed it, ran the installation SQL=20
scripts.

I can log in into PHPEsp and was able to change the password too.

But, when I attempt to create a new survey, I get the following error:

Has anyone seen this one? What would be the fix?

Fatal error: Call to a member function on a non-object in c:\program=20
files\easyphp1-8\www\phpesp\admin\include\lib\espdatalib.inc on line 124=20

Thanks!


Jean-Francois Gagnon
DMR Conseil, une soci=E9t=E9 Fujitsu.
2960 Boulevard Laurier, Bureau 400
Sainte-Foy, QC  G1V 4S1
CANADA
Bureau/Desk:(418)653-6882x3962
Cell:(418)953-3172

Re: [phpesp-general] Zero-length downloads

[Aaron A. <li...@fr...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
 

>> Patches against current CVS would be graciously accepted.
>
> Maybe I can find a PHP hacker here who'd be interested.

I think the main problem is finding someone who has time :).



- -- Aaron
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
 
iD8DBQFEDca6uucONIvD0AMRAv0+AJ90PpWHi4Ld6qoHibXcJV6WfQtJjACeNc67
i9VSNo73rRBYQ+NYR3uX8G8=
=uyq3
-----END PGP SIGNATURE-----

[phpesp-general] Problem with sessions?

[Mika <ar...@gm...>]

I have a problem with phpesp 1.8 which is possibly related to
sessions. The error message I get is printed at the top of the page.
This error comes usually atleast when I'm creating a survey with alot
of questions, or even a fairly simple one with section test followed
by a few Rate (scale 1...5)'s. It will print the error upon trying to
add a question, and not proceed at all.

Error message:

---------------------------------------------------------------------------=
---------------------
*Warning*: Call-time pass-by-reference has been deprecated - argument
passed by value; If you would like to pass it by reference, modify the
declaration of intval(). If you would like to enable call-time
pass-by-reference, you can set allow_call_time_pass_reference to true
in your INI file. However, future versions may not support this any
longer. in */home/apache/sites/php/phpesp/admin/include/where/tab.inc*
on line *37*
---------------------------------------------------------------------------=
-----------------------

I can hide the error message by modifying the tab.inc file mentioned
in the error:

---------------------------------------------------------------------------=
-----------------------
$ diff tab.inc tab.inc.modified
37c37
<               $_SESSION['survey_id']  =3D intval(&$survey_id);
---
>               $_SESSION['survey_id']  =3D intval($survey_id);
---------------------------------------------------------------------------=
-----------------------

I have also changed the phpESP.ini.php file (and another file with
HTTP_HOST) to work with our apache, but I don't think this will cause
problems:

---------------------------------------------------------------------------=
-----------------------

$ diff phpESP.ini.php phpESP.ini.php.ORIGINAL
23c23
< $ESPCONFIG['base_url'] =3D $ESPCONFIG['proto'] .
$server['HTTP_X_FORWARDED_HOST'] . '/phpesp/';
---
> $ESPCONFIG['base_url'] =3D $ESPCONFIG['proto'] . $server['HTTP_HOST'] . '=
/phpesp/';

---------------------------------------------------------------------------=
-----------------------


But it will only hide the message, not let me go forward in creating
the questionare.

Problem is, the server which would be running this is running some
other apps (intranet, work ticket system ect) using php, and I would
prefere not to change the allow_call_time_pass_reference value in the
global php settings. Php version on the host is PHP 4.3.9 (cgi).

Output of test.php:

---------------------------------------------------------------------------=
-----------------------
PHP Information

   * Version: 4.3.9
   * OS: Linux
   * SAPI: apache2handler
   * register_globals: Yes
   * magic_quotes_gpc: Yes
   * magic_quotes_runtime: No
   * safe_mode: No
   * open_basedir:

PHP Extensions

   * dBase: No
   * GD: No
   * 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: /home/apache/sites/php/phpesp/
   * Expected base_url: localhost/phpesp/
   * Loading phpESP.ini.php ...
   * ESP_BASE: /home/apache/sites/php/phpesp/
   * base_url: https://intra-temp.sulake.com/phpesp/
   * Version: 1.8
   * Debug: No

phpESP Language Settings

   * GNU Gettext: Real
   * default_lang: en_US
   * current lang: en_US
   * available langs: fi_FI, da_DK, hu_HU, de_DE, pt_BR, pt_PT,
nl_NL, ja_JP, el_GR, fi, it_IT, fr_FR, es_ES, en_US, 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: /var/lib/php/session
   * Counter: 1

---------------------------------------------------------------------------=
-----------------------

phpESP.ini.php file:

---------------------------------------------------------------------------=
-----------------------


# cat phpESP.ini.php
<?php

/* $Id: phpESP.ini.php,v 1.37 2005/11/18 15:25:39 greggmc Exp $ */

/* vim: set tabstop=3D4 shiftwidth=3D4 expandtab: */

// Written by James Flemer
// For eGrad2000.com
// <jf...@al...>

if (!defined('ESP_BASE')) define('ESP_BASE', dirname(dirname(__FILE__)) .'/=
');
if (isset($_SERVER))  $server =3D& $_SERVER;
else                  $server =3D& $HTTP_SERVER_VARS;

/**
 * Here are all the configuration options.
 */

// use http or https?
$ESPCONFIG['proto'] =3D 'https://';

// Base URL for phpESP
$ESPCONFIG['base_url'] =3D $ESPCONFIG['proto'] .
$server['HTTP_X_FORWARDED_HOST'] . '/phpesp/';

// URL of the images directory (for <img src=3D'...'> tags)
$ESPCONFIG['image_url'] =3D $ESPCONFIG['base_url'] . 'images/';

// URL of the automatic survey publisher
$ESPCONFIG['autopub_url'] =3D $ESPCONFIG['base_url'] . 'public/survey.php';

// URL of the CSS directory (for themes)
$ESPCONFIG['css_url'] =3D $ESPCONFIG['base_url'] . 'public/css/';

//URL for management javascript
$ESPCONFIG['js_url'] =3D $ESPCONFIG['base_url'] . 'js/';

// Database connection information
$ESPCONFIG['db_host'] =3D 'localhost';
$ESPCONFIG['db_user'] =3D 'xxxxxxxxx';
$ESPCONFIG['db_pass'] =3D 'xxxxxxxxxx;
$ESPCONFIG['db_name'] =3D 'xxxxxxxxx';

// ADODB
$ESPCONFIG['adodb_path'] =3D ESP_BASE . 'admin/include/lib/adodb/';
$ESPCONFIG['adodb_database_type'] =3D 'mysql';
$ESPCONFIG['adodb_dbpersist'] =3D 'true';
$ESPCONFIG['adodb_pathto_db'] =3D "/var/www/phpESP/scripts/db/esp.dbm";

// Allow phpESP to send email (BOOLEAN)
$ESPCONFIG['allow_email'] =3D true;

// Send human readable email, rather than machine readable (BOOLEAN)
$ESPCONFIG['human_email'] =3D true;

// Use authentication for designer interface (BOOLEAN)
$ESPCONFIG['auth_design'] =3D true;

// Use authentication for survey responders (BOOLEAN)
$ESPCONFIG['auth_response'] =3D true;

// Choose authentication type: { 'default', 'ldap' }
$ESPCONFIG['auth_type'] =3D 'default';

// LDAP connection information
// (Set these values if you choose 'ldap' as the authentication type.)
$ESPCONFIG['ldap_server'] =3D 'ldap://example.com';
$ESPCONFIG['ldap_port']   =3D '389    ';
$ESPCONFIG['ldap_dn']     =3D 'dc=3Dexample,dc=3Dcom';
$ESPCONFIG['ldap_filter'] =3D 'uid=3D';

// Group to add responders to via the sign-up page
// (Set to "null", without quotes, to disable the sign-up page.)
$ESPCONFIG['signup_realm'] =3D 'auto';

// Default language for designer interface
// (Must have gettext support avaiable.)
$ESPCONFIG['default_lang'] =3D 'en_US';

// HTML character set used by phpESP
// (Try 'Windows-1251' for Cryillic, etc.)
$ESPCONFIG['charset'] =3D 'ISO-8859-1';

// Default number of option lines for new questions
$ESPCONFIG['default_num_choices'] =3D 10;

// Colors used by phpESP
$ESPCONFIG['main_bgcolor']      =3D '#FFFFFF';
$ESPCONFIG['link_color']        =3D '#0000CC';
$ESPCONFIG['vlink_color']       =3D '#0000CC';
$ESPCONFIG['alink_color']       =3D '#0000CC';
$ESPCONFIG['dim_bgcolor']       =3D '#3399CC';
$ESPCONFIG['error_color']       =3D '#FF0000';
$ESPCONFIG['warn_color']        =3D '#FF0000';
$ESPCONFIG['reqd_color']        =3D '#FF0000';
$ESPCONFIG['bgalt_color1']      =3D '#FFFFFF';
$ESPCONFIG['bgalt_color2']      =3D '#EEEEEE';

/*******************************************************************
 * Most users will not need to change anything below this line.    *
 *******************************************************************/
// Enable debugging code (BOOLEAN)
$ESPCONFIG['DEBUG'] =3D false;

// Name of application
$ESPCONFIG['name'] =3D 'phpESP';

// Application version
$ESPCONFIG['version'] =3D '1.8';

// Extension of support files
$ESPCONFIG['extension'] =3D '.inc';

// Choose authentication mode: { 'basic', 'form' }
$ESPCONFIG['auth_mode'] =3D 'form';

// Survey handler to use
$ESPCONFIG['handler']        =3D ESP_BASE . '/public/handler.php';
$ESPCONFIG['handler_prefix'] =3D ESP_BASE . '/public/handler-prefix.php';

// Valid tabs when editing surveys
$ESPCONFIG['tabs'] =3D array('general', 'questions', 'preview', 'order',
'finish');

// Copy of PHP_SELF for later use
$ESPCONFIG['ME'] =3D $server['PHP_SELF'];

// CSS stylesheet to use for designer interface
$ESPCONFIG['style_sheet'] =3D $ESPCONFIG['base_url'] . 'admin/style.css';

// Status of gettext extension
$ESPCONFIG['gettext'] =3D extension_loaded('gettext');

// HTML page title
$ESPCONFIG['title'] =3D $ESPCONFIG['name'] .', v('. $ESPCONFIG['version'].'=
)';

// phpESP include path
$ESPCONFIG['include_path'] =3D ESP_BASE . '/admin/include/';

// phpESP css path
$ESPCONFIG['css_path'] =3D ESP_BASE . '/public/css/';

// phpESP locale path
$ESPCONFIG['locale_path'] =3D ESP_BASE . '/locale/';

// Unsuported web server configuration check values
$ESPCONFIG['unsupported'] =3D array('cgi', 'sapi');

// Database Table Names:
$DB_PREFIX =3D "";        // If your database uses a prefix, set it here.
$ESPCONFIG['access_table']              =3D $DB_PREFIX."access";
$ESPCONFIG['designer_table']            =3D $DB_PREFIX."designer";
$ESPCONFIG['question_table']            =3D $DB_PREFIX."question";
$ESPCONFIG['question_choice_table']     =3D $DB_PREFIX."question_choice";
$ESPCONFIG['question_type_table']       =3D $DB_PREFIX."question_type";
$ESPCONFIG['realm_table']               =3D $DB_PREFIX."realm";
$ESPCONFIG['respondent_table']          =3D $DB_PREFIX."respondent";
$ESPCONFIG['response_table']            =3D $DB_PREFIX."response";
$ESPCONFIG['response_bool_table']       =3D $DB_PREFIX."response_bool";
$ESPCONFIG['response_date_table']       =3D $DB_PREFIX."response_date";
$ESPCONFIG['response_multiple_table']   =3D $DB_PREFIX."response_multiple";
$ESPCONFIG['response_other_table']      =3D $DB_PREFIX."response_other";
$ESPCONFIG['response_rank_table']       =3D $DB_PREFIX."response_rank";
$ESPCONFIG['response_single_table']     =3D $DB_PREFIX."response_single";
$ESPCONFIG['response_text_table']       =3D $DB_PREFIX."response_text";
$ESPCONFIG['survey_table']              =3D $DB_PREFIX."survey";

// Load I18N support
require_once($ESPCONFIG['include_path'] . '/lib/espi18n' .
$ESPCONFIG['extension']);
esp_setlocale_ex();

// default thank you messages
$ESPCONFIG['thank_head'] =3D _('Thank You For Completing This Survey.');
$ESPCONFIG['thank_body'] =3D _('Please do not use the back button on
your browser to go
back.');

if (!file_exists($ESPCONFIG['include_path']. '/funcs'.
$ESPCONFIG['extension'])) {
   printf('<b>'. _('Unable to find the phpESP %s directory.
                       Please check %s to ensure that all paths are
set correctly.') .
                       '</b>', 'include', 'phpESP.ini.php');
   exit;
}
if (!file_exists($ESPCONFIG['css_path'])) {
   printf('<b>'. _('Unable to find the phpESP %s directory.
                       Please check %s to ensure that all paths are
set correctly.') .
                       '</b>', 'css', 'phpESP.ini.php');
   exit;
}

if (isset($GLOBALS)) {
   $GLOBALS['ESPCONFIG'] =3D $ESPCONFIG;
} else {
   global $ESPCONFIG;
}

require_once($ESPCONFIG['include_path'].'/funcs'.$ESPCONFIG['extension']);

?>

---------------------------------------------------------------------------=
-----------------------

[phpesp-general] Problem with sessions?

[Mika <ar...@gm...>]

I have a problem with phpesp 1.8 which is possibly related to
sessions. The error message I get is printed at the top of the page.
This error comes usually atleast when I'm creating a survey with alot
of questions, or even a fairly simple one with section test followed
by a few Rate (scale 1...5)'s. It will print the error upon trying to
add a question, and not proceed at all.

Error message:

---------------------------------------------------------------------------=
---------------------
*Warning*: Call-time pass-by-reference has been deprecated - argument
passed by value; If you would like to pass it by reference, modify the
declaration of intval(). If you would like to enable call-time
pass-by-reference, you can set allow_call_time_pass_reference to true
in your INI file. However, future versions may not support this any
longer. in */home/apache/sites/php/phpesp/admin/include/where/tab.inc*
on line *37*
---------------------------------------------------------------------------=
-----------------------

I can hide the error message by modifying the tab.inc file mentioned
in the error:

---------------------------------------------------------------------------=
-----------------------
$ diff tab.inc tab.inc.modified
37c37
<               $_SESSION['survey_id']  =3D intval(&$survey_id);
---
>               $_SESSION['survey_id']  =3D intval($survey_id);
---------------------------------------------------------------------------=
-----------------------

I have also changed the phpESP.ini.php file (and another file with
HTTP_HOST) to work with our apache, but I don't think this will cause
problems:

---------------------------------------------------------------------------=
-----------------------

$ diff phpESP.ini.php phpESP.ini.php.ORIGINAL
23c23
< $ESPCONFIG['base_url'] =3D $ESPCONFIG['proto'] .
$server['HTTP_X_FORWARDED_HOST'] . '/phpesp/';
---
> $ESPCONFIG['base_url'] =3D $ESPCONFIG['proto'] . $server['HTTP_HOST'] . '=
/phpesp/';

---------------------------------------------------------------------------=
-----------------------


But it will only hide the message, not let me go forward in creating
the questionare.

Problem is, the server which would be running this is running some
other apps (intranet, work ticket system ect) using php, and I would
prefere not to change the allow_call_time_pass_reference value in the
global php settings. Php version on the host is PHP 4.3.9 (cgi).

Output of test.php:

---------------------------------------------------------------------------=
-----------------------
PHP Information

    * Version: 4.3.9
    * OS: Linux
    * SAPI: apache2handler
    * register_globals: Yes
    * magic_quotes_gpc: Yes
    * magic_quotes_runtime: No
    * safe_mode: No
    * open_basedir:

PHP Extensions

    * dBase: No
    * GD: No
    * 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: /home/apache/sites/php/phpesp/
    * Expected base_url: localhost/phpesp/
    * Loading phpESP.ini.php ...
    * ESP_BASE: /home/apache/sites/php/phpesp/
    * base_url: https://intra-temp.sulake.com/phpesp/
    * Version: 1.8
    * Debug: No

phpESP Language Settings

    * GNU Gettext: Real
    * default_lang: en_US
    * current lang: en_US
    * available langs: fi_FI, da_DK, hu_HU, de_DE, pt_BR, pt_PT,
nl_NL, ja_JP, el_GR, fi, it_IT, fr_FR, es_ES, en_US, 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: /var/lib/php/session
    * Counter: 1

---------------------------------------------------------------------------=
-----------------------

phpESP.ini.php file:

---------------------------------------------------------------------------=
-----------------------


# cat phpESP.ini.php
<?php

/* $Id: phpESP.ini.php,v 1.37 2005/11/18 15:25:39 greggmc Exp $ */

/* vim: set tabstop=3D4 shiftwidth=3D4 expandtab: */

// Written by James Flemer
// For eGrad2000.com
// <jf...@al...>

if (!defined('ESP_BASE')) define('ESP_BASE', dirname(dirname(__FILE__)) .'/=
');
if (isset($_SERVER))  $server =3D& $_SERVER;
else                  $server =3D& $HTTP_SERVER_VARS;

/**
 * Here are all the configuration options.
 */

// use http or https?
$ESPCONFIG['proto'] =3D 'https://';

// Base URL for phpESP
$ESPCONFIG['base_url'] =3D $ESPCONFIG['proto'] .
$server['HTTP_X_FORWARDED_HOST'] . '/phpesp/';

// URL of the images directory (for <img src=3D'...'> tags)
$ESPCONFIG['image_url'] =3D $ESPCONFIG['base_url'] . 'images/';

// URL of the automatic survey publisher
$ESPCONFIG['autopub_url'] =3D $ESPCONFIG['base_url'] . 'public/survey.php';

// URL of the CSS directory (for themes)
$ESPCONFIG['css_url'] =3D $ESPCONFIG['base_url'] . 'public/css/';

//URL for management javascript
$ESPCONFIG['js_url'] =3D $ESPCONFIG['base_url'] . 'js/';

// Database connection information
$ESPCONFIG['db_host'] =3D 'localhost';
$ESPCONFIG['db_user'] =3D 'xxxxxxxxx';
$ESPCONFIG['db_pass'] =3D 'xxxxxxxxxx;
$ESPCONFIG['db_name'] =3D 'xxxxxxxxx';

// ADODB
$ESPCONFIG['adodb_path'] =3D ESP_BASE . 'admin/include/lib/adodb/';
$ESPCONFIG['adodb_database_type'] =3D 'mysql';
$ESPCONFIG['adodb_dbpersist'] =3D 'true';
$ESPCONFIG['adodb_pathto_db'] =3D "/var/www/phpESP/scripts/db/esp.dbm";

// Allow phpESP to send email (BOOLEAN)
$ESPCONFIG['allow_email'] =3D true;

// Send human readable email, rather than machine readable (BOOLEAN)
$ESPCONFIG['human_email'] =3D true;

// Use authentication for designer interface (BOOLEAN)
$ESPCONFIG['auth_design'] =3D true;

// Use authentication for survey responders (BOOLEAN)
$ESPCONFIG['auth_response'] =3D true;

// Choose authentication type: { 'default', 'ldap' }
$ESPCONFIG['auth_type'] =3D 'default';

// LDAP connection information
// (Set these values if you choose 'ldap' as the authentication type.)
$ESPCONFIG['ldap_server'] =3D 'ldap://example.com';
$ESPCONFIG['ldap_port']   =3D '389    ';
$ESPCONFIG['ldap_dn']     =3D 'dc=3Dexample,dc=3Dcom';
$ESPCONFIG['ldap_filter'] =3D 'uid=3D';

// Group to add responders to via the sign-up page
// (Set to "null", without quotes, to disable the sign-up page.)
$ESPCONFIG['signup_realm'] =3D 'auto';

// Default language for designer interface
// (Must have gettext support avaiable.)
$ESPCONFIG['default_lang'] =3D 'en_US';

// HTML character set used by phpESP
// (Try 'Windows-1251' for Cryillic, etc.)
$ESPCONFIG['charset'] =3D 'ISO-8859-1';

// Default number of option lines for new questions
$ESPCONFIG['default_num_choices'] =3D 10;

// Colors used by phpESP
$ESPCONFIG['main_bgcolor']      =3D '#FFFFFF';
$ESPCONFIG['link_color']        =3D '#0000CC';
$ESPCONFIG['vlink_color']       =3D '#0000CC';
$ESPCONFIG['alink_color']       =3D '#0000CC';
$ESPCONFIG['dim_bgcolor']       =3D '#3399CC';
$ESPCONFIG['error_color']       =3D '#FF0000';
$ESPCONFIG['warn_color']        =3D '#FF0000';
$ESPCONFIG['reqd_color']        =3D '#FF0000';
$ESPCONFIG['bgalt_color1']      =3D '#FFFFFF';
$ESPCONFIG['bgalt_color2']      =3D '#EEEEEE';

/*******************************************************************
 * Most users will not need to change anything below this line.    *
 *******************************************************************/
// Enable debugging code (BOOLEAN)
$ESPCONFIG['DEBUG'] =3D false;

// Name of application
$ESPCONFIG['name'] =3D 'phpESP';

// Application version
$ESPCONFIG['version'] =3D '1.8';

// Extension of support files
$ESPCONFIG['extension'] =3D '.inc';

// Choose authentication mode: { 'basic', 'form' }
$ESPCONFIG['auth_mode'] =3D 'form';

// Survey handler to use
$ESPCONFIG['handler']        =3D ESP_BASE . '/public/handler.php';
$ESPCONFIG['handler_prefix'] =3D ESP_BASE . '/public/handler-prefix.php';

// Valid tabs when editing surveys
$ESPCONFIG['tabs'] =3D array('general', 'questions', 'preview', 'order',
'finish');

// Copy of PHP_SELF for later use
$ESPCONFIG['ME'] =3D $server['PHP_SELF'];

// CSS stylesheet to use for designer interface
$ESPCONFIG['style_sheet'] =3D $ESPCONFIG['base_url'] . 'admin/style.css';

// Status of gettext extension
$ESPCONFIG['gettext'] =3D extension_loaded('gettext');

// HTML page title
$ESPCONFIG['title'] =3D $ESPCONFIG['name'] .', v('. $ESPCONFIG['version'].'=
)';

// phpESP include path
$ESPCONFIG['include_path'] =3D ESP_BASE . '/admin/include/';

// phpESP css path
$ESPCONFIG['css_path'] =3D ESP_BASE . '/public/css/';

// phpESP locale path
$ESPCONFIG['locale_path'] =3D ESP_BASE . '/locale/';

// Unsuported web server configuration check values
$ESPCONFIG['unsupported'] =3D array('cgi', 'sapi');

// Database Table Names:
$DB_PREFIX =3D "";        // If your database uses a prefix, set it here.
$ESPCONFIG['access_table']              =3D $DB_PREFIX."access";
$ESPCONFIG['designer_table']            =3D $DB_PREFIX."designer";
$ESPCONFIG['question_table']            =3D $DB_PREFIX."question";
$ESPCONFIG['question_choice_table']     =3D $DB_PREFIX."question_choice";
$ESPCONFIG['question_type_table']       =3D $DB_PREFIX."question_type";
$ESPCONFIG['realm_table']               =3D $DB_PREFIX."realm";
$ESPCONFIG['respondent_table']          =3D $DB_PREFIX."respondent";
$ESPCONFIG['response_table']            =3D $DB_PREFIX."response";
$ESPCONFIG['response_bool_table']       =3D $DB_PREFIX."response_bool";
$ESPCONFIG['response_date_table']       =3D $DB_PREFIX."response_date";
$ESPCONFIG['response_multiple_table']   =3D $DB_PREFIX."response_multiple";
$ESPCONFIG['response_other_table']      =3D $DB_PREFIX."response_other";
$ESPCONFIG['response_rank_table']       =3D $DB_PREFIX."response_rank";
$ESPCONFIG['response_single_table']     =3D $DB_PREFIX."response_single";
$ESPCONFIG['response_text_table']       =3D $DB_PREFIX."response_text";
$ESPCONFIG['survey_table']              =3D $DB_PREFIX."survey";

// Load I18N support
require_once($ESPCONFIG['include_path'] . '/lib/espi18n' .
$ESPCONFIG['extension']);
esp_setlocale_ex();

// default thank you messages
$ESPCONFIG['thank_head'] =3D _('Thank You For Completing This Survey.');
$ESPCONFIG['thank_body'] =3D _('Please do not use the back button on
your browser to go
back.');

if (!file_exists($ESPCONFIG['include_path']. '/funcs'.
$ESPCONFIG['extension'])) {
    printf('<b>'. _('Unable to find the phpESP %s directory.
                        Please check %s to ensure that all paths are
set correctly.') .
                        '</b>', 'include', 'phpESP.ini.php');
    exit;
}
if (!file_exists($ESPCONFIG['css_path'])) {
    printf('<b>'. _('Unable to find the phpESP %s directory.
                        Please check %s to ensure that all paths are
set correctly.') .
                        '</b>', 'css', 'phpESP.ini.php');
    exit;
}

if (isset($GLOBALS)) {
    $GLOBALS['ESPCONFIG'] =3D $ESPCONFIG;
} else {
    global $ESPCONFIG;
}

require_once($ESPCONFIG['include_path'].'/funcs'.$ESPCONFIG['extension']);

?>

---------------------------------------------------------------------------=
-----------------------

Re: [phpesp-general] French does not work even if it is the default in phpESP.ini.php

[Ron W. <rwh...@ar...>]

I did not have the French locale installed.

It is not mentioned in the prerequisites.
It took a bit of digging to find out that it was needed. I had to rea=
d=20
and screw around with the espi8n.inc code to see how it was working a=
nd=20
to be sure that the code actually worked.

I have submitted a bug report with a suggested fix to the documentati=
on.

Thanks for the help. I have phpESP1.8 working with the 64 bit version=
s=20
of Apache 2.0, MySql 4.1.2 and PHP 5 on the 64 bit version of Madriva=
 2006 .

Ron




Mario CASTELLAZZI wrote:
> I had this problem. And I found a solution that i posted on this li=
st=20
> in january of 2005.
>
> Here it is.
>
> 2003-01-05 05:40
>  I had problems in order to have the internalization work correctly=
.
> =20
>  After having read the mailing list, i found an (very good) arricle=
 at the URL
> http://zez.org/article/articleprint/42/ which explains the internat=
ionalization with PHP and
> gettext (this article is referenced in the news of phpesp).
> =20
>  That"s why i have modified PHPESP.INI by replacing setlocale (LC_A=
LL, $ESPCONFIG["lang"])
> by what is written in this former article, that is : putenv ("LC_AL=
L=3D" . $ESPCONFIG["lang"])
> =20
>  And then it worked (at least for the french language that i have t=
ried).
> =20
>  NOTE :
>  I have installed PHP 4.1.1 and APACHE 1.3
>  When i tried to install the gettext extension with PHP 4.2.3 and A=
PACHE 2, i had problems.
> A message told me that it couldn"t find the php_gettext.dll althoug=
h this dll was present
> and that libintl-1.dll was well installed in my WINNT/SYSTEM32 dire=
ctory (i have windows
> 2000 professional).
>  That"s why i decided to install back prior versions of APACHE and =
PHP.
>  Now, it works.
>      =20
>
>
>
> Wish it can help you.
>
>
>
> Ron Wheeler a =E9crit :
>> The administration page is still in English even though the  test=
=20
>> page output seems to indicate that everything is set to French.
>> How is the language string selected?
>>
>> Ron
>>
>> PHP Information
>>
>>    * Version: 5.0.4
>>    * OS: Linux
>>    * SAPI: apache2handler
>>    * register_globals: No
>>    * magic_quotes_gpc: No
>>    * magic_quotes_runtime: No
>>    * safe_mode: No
>>    * open_basedir:
>>
>> PHP Extensions
>>
>>    * dBase: No
>>    * GD: Yes -- 2.0 or higher
>>    * GNU Gettext: Yes
>>    * LDAP: Yes
>>    * MySQL: Yes
>>    * PHP Extension Dir (compiled): /usr/lib64/php/extensions
>>    * PHP Extension Dir (run time): /usr/lib64/php/extensions
>>
>> phpESP Settings
>>
>>    * Expected ESP_BASE: /home/usr/local/www/www.eduxxx
>>    * Expected base_url: www.eduxxx
>>    * *Loading phpESP.ini.php ...*
>>    * ESP_BASE: /home/usr/local/www/www.eduxxx/
>>    * base_url: http://www.eduxxx
>>    * Version: 1.8
>>    * Debug: No
>>
>> phpESP Language Settings
>>
>>    * GNU Gettext: Real
>>    * default_lang: fr_FR
>>    * current lang: fr_FR
>>    * 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
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by xPML, a groundbreaking scripting=
=20
>> language
>> that extends applications into web and mobile media. Attend the li=
ve=20
>> webcast
>> and join the prime developer group breaking into this new coding=
=20
>> territory!
>> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D24172=
0&dat=3D121642
>> _______________________________________________
>> phpESP-general mailing list
>> php...@li...
>> https://lists.sourceforge.net/lists/listinfo/phpesp-general
>>
>>
> ------------------------------------------------------- This SF.Net=
=20
> email is sponsored by xPML, a groundbreaking scripting language tha=
t=20
> extends applications into web and mobile media. Attend the live=
=20
> webcast and join the prime developer group breaking into this new=
=20
> coding territory!=20
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720=
&dat=3D121642=20
> _______________________________________________ phpESP-general mail=
ing=20
> list php...@li...=20
> https://lists.sourceforge.net/lists/listinfo/phpesp-general=20

Re: [phpesp-general] Zero-length downloads

[Peter F. <pe...@si...>]

Matthew Gregg wrote:
> The export code is a mess.  An unfortunate legacy of the code base.   

Aaaaah. *Now* we're getting somewhere near :-)

> I do however have a few large surveys with 1000+ responses that export 
> without a problem using phpESP 1.8.  I think it is a combination of 
> question types in the survey + a "large" number of responses and 

The one in question had one open text, two binary questions and all
the rest were radiobutton choices. Not very complex. Maybe it just
doen't cope well with a lot of radiobutton questions.

> possibly some interaction with php 5.x/mysql 5.x that is the issue.  
> Anyone willing to rewrite/fix the export code would be much 
> appreciated.  

I did post recently asking if anyone could suggest where I could set
breakpoints in the code, and what statement to put in there to log
the program's presence at each breakpoint (to a file in /tmp, for
example). I don't know PHP but I'd be capable of adding the relevant
code if someone can suggest it.

> Sounds like the XSLT routine you have is a start.   

It's a bit slow, but it does at least allow me to see what it's doing.

> Patches against current CVS would be graciously accepted.

Maybe I can find a PHP hacker here who'd be interested.

///Peter

Re: [phpesp-general] French does not work even if it is the default in phpESP.ini.php

[Mario C. <mar...@wa...>]

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
I had this problem. And I found a solution that i posted on this list
in january of 2005.<br>
<br>
Here it is.<br>
<br>
<table width="100%">
  <tbody>
    <tr>
      <td bgcolor="#dddddd" nowrap="nowrap">2003-01-05 05:40 </td>
    </tr>
    <tr>
      <td>
      <pre> I had problems in order to have the internalization work correctly.
 
 After having read the mailing list, i found an (very good) arricle at the URL
<a href="http://zez.org/article/articleprint/42/" target="_NEW">http://zez.org/article/articleprint/42/</a> which explains the internationalization with PHP and
gettext (this article is referenced in the news of phpesp).
 
 That"s why i have modified PHPESP.INI by replacing setlocale (LC_ALL, $ESPCONFIG["lang"])
by what is written in this former article, that is : putenv ("LC_ALL=" . $ESPCONFIG["lang"])
 
 And then it worked (at least for the french language that i have tried).
 
 NOTE :
 I have installed PHP 4.1.1 and APACHE 1.3
 When i tried to install the gettext extension with PHP 4.2.3 and APACHE 2, i had problems.
A message told me that it couldn"t find the php_gettext.dll although this dll was present
and that libintl-1.dll was well installed in my WINNT/SYSTEM32 directory (i have windows
2000 professional).
 That"s why i decided to install back prior versions of APACHE and PHP.
 Now, it works.
      </pre>
      </td>
    </tr>
  </tbody>
</table>
<br>
<br>
Wish it can help you.<br>
<br>
<br>
<br>
Ron Wheeler a &eacute;crit&nbsp;:
<blockquote cite="mid...@ar..." type="cite">The
administration page is still in English even though the&nbsp; test page
output seems to indicate that everything is set to French.
  <br>
How is the language string selected?
  <br>
  <br>
Ron
  <br>
  <br>
PHP Information
  <br>
  <br>
&nbsp;&nbsp; * Version: 5.0.4
  <br>
&nbsp;&nbsp; * OS: Linux
  <br>
&nbsp;&nbsp; * SAPI: apache2handler
  <br>
&nbsp;&nbsp; * register_globals: No
  <br>
&nbsp;&nbsp; * magic_quotes_gpc: No
  <br>
&nbsp;&nbsp; * magic_quotes_runtime: No
  <br>
&nbsp;&nbsp; * safe_mode: No
  <br>
&nbsp;&nbsp; * open_basedir:
  <br>
  <br>
PHP Extensions
  <br>
  <br>
&nbsp;&nbsp; * dBase: No
  <br>
&nbsp;&nbsp; * GD: Yes -- 2.0 or higher
  <br>
&nbsp;&nbsp; * GNU Gettext: Yes
  <br>
&nbsp;&nbsp; * LDAP: Yes
  <br>
&nbsp;&nbsp; * MySQL: Yes
  <br>
&nbsp;&nbsp; * PHP Extension Dir (compiled): /usr/lib64/php/extensions
  <br>
&nbsp;&nbsp; * PHP Extension Dir (run time): /usr/lib64/php/extensions
  <br>
  <br>
phpESP Settings
  <br>
  <br>
&nbsp;&nbsp; * Expected ESP_BASE: /home/usr/local/www/www.eduxxx
  <br>
&nbsp;&nbsp; * Expected base_url: <a class="moz-txt-link-abbreviated" href="http://www.eduxxx">www.eduxxx</a>
  <br>
&nbsp;&nbsp; * *Loading phpESP.ini.php ...*
  <br>
&nbsp;&nbsp; * ESP_BASE: /home/usr/local/www/www.eduxxx/
  <br>
&nbsp;&nbsp; * base_url: <a class="moz-txt-link-freetext" href="http://www.eduxxx">http://www.eduxxx</a>
  <br>
&nbsp;&nbsp; * Version: 1.8
  <br>
&nbsp;&nbsp; * Debug: No
  <br>
  <br>
phpESP Language Settings
  <br>
  <br>
&nbsp;&nbsp; * GNU Gettext: Real
  <br>
&nbsp;&nbsp; * default_lang: fr_FR
  <br>
&nbsp;&nbsp; * current lang: fr_FR
  <br>
&nbsp;&nbsp; * available langs: da_DK, de_DE, el_GR, en_US, es_ES, fi, fi_FI,
  <br>
&nbsp;&nbsp;&nbsp;&nbsp; fr_FR, hu_HU, it_IT, ja_JP, nl_NL, pt_BR, pt_PT, sv_SE
  <br>
&nbsp;&nbsp;&nbsp;&nbsp; (da, de, el, en, es, fi, fr, it, ja, nl, pt, sv)
  <br>
&nbsp;&nbsp; * GNU Gettext test: Passed
  <br>
&nbsp;&nbsp; * Catalog Open Test: Yes
  <br>
  <br>
PHP Session Test
  <br>
  <br>
&nbsp;&nbsp; * session.save_path: /tmp
  <br>
&nbsp;&nbsp; * Counter: 2
  <br>
  <br>
  <br>
  <br>
-------------------------------------------------------
  <br>
This SF.Net email is sponsored by xPML, a groundbreaking scripting
language
  <br>
that extends applications into web and mobile media. Attend the live
webcast
  <br>
and join the prime developer group breaking into this new coding
territory!
  <br>
<a class="moz-txt-link-freetext" href="http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642">http://sel.as-us.falkag.net/sel?cmd=lnk&amp;kid=110944&amp;bid=241720&amp;dat=121642</a>
  <br>
_______________________________________________
  <br>
phpESP-general mailing list
  <br>
<a class="moz-txt-link-abbreviated" href="mailto:php...@li...">php...@li...</a>
  <br>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/phpesp-general">https://lists.sourceforge.net/lists/listinfo/phpesp-general</a>
  <br>
  <br>
  <br>
</blockquote>
</body>
</html>

Re: [phpesp-general] Zero-length downloads

[Matthew G. <mat...@gm...>]

The export code is a mess.  An unfortunate legacy of the code base.  I do
however have a few large surveys with 1000+ responses that export without a
problem using phpESP 1.8.  I think it is a combination of question types in
the survey + a "large" number of responses and possibly some interaction
with php 5.x/mysql 5.x that is the issue.  Anyone willing to rewrite/fix th=
e
export code would be much appreciated.  Sounds like the XSLT routine you
have is a start.   Patches against current CVS would be graciously accepted=
.


On 3/1/06, Peter Flynn <pe...@si...> wrote:
>
> Thanks to Aaron Axelsen, who tested a survey on my server, I have
> ascertained that a minimal survey (three questions, one response)
> *will* download a CSV file when you try to extract the data.
>
> I am now thinking that the problem is simply size: the survey
> that won't download is 75 questions and 924 responses. Is this
> perhaps just too big for phpESP to handle?
>
> If so, what's the way to split the download into chunks?
>
> I looked a bit harder at the code for survey_export_csv.inc
> and it appears to try and do the job by creating an array.
> Surely it's not trying to dynamically stuff an array with the
> entire results of a survey?
>
> I really hate bugging an author about this kind of thing, but
> I'm BCCing this to the author's name in the script in case he
> can shed any light on the problem.
>
> In the meantime, anyone else stuck with this problem can look
> at the routine I wrote to dump out all the data and rewrite it
> as CSV (two bash scripts and an XSLT routine):
>
> http://silmaril.ie/downloads/software/phpESP_csv-via-xml.tar.gz
>
> ///Peter
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting
> language
> that extends applications into web and mobile media. Attend the live
> webcast
> and join the prime developer group breaking into this new coding
> territory!
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat=
=3D121642
> _______________________________________________
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general
>



--
D'oh!

Re: [phpesp-general] Zero-length downloads

[Peter F. <pe...@si...>]

Aaron Axelsen wrote:
> In my phpesp install (1.8), I have a survey that has 588 responses,
> and the survey itself has only 17 questions though.  I wonder if
> anyone else have ever had a survey of your size that they have tried
> to export?  It very well sounds like it could be timing out php just
> because of the amount of time it could take the script to run.

Could be...but what would be making PHP time out? Surely it will simply
carry on processing until it's finished: it shouldn't be entering any
wait states.

> Have you tried the "Save to server" option?  What does that result
> produce?

Exactly the same: a null file in /tmp

///Peter

Re: [phpesp-general] Zero-length downloads

[Aaron A. <li...@fr...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
 
Peter,

In my phpesp install (1.8), I have a survey that has 588 responses,
and the survey itself has only 17 questions though.  I wonder if
anyone else have ever had a survey of your size that they have tried
to export?  It very well sounds like it could be timing out php just
because of the amount of time it could take the script to run.

Have you tried the "Save to server" option?  What does that result
produce?

- --
Aaron Axelsen
li...@fr...

Great hosting, low prices.  Modevia Web Services LLC --
http://www.modevia.com



Peter Flynn wrote:
> Thanks to Aaron Axelsen, who tested a survey on my server, I have
> ascertained that a minimal survey (three questions, one response)
> *will* download a CSV file when you try to extract the data.
>
> I am now thinking that the problem is simply size: the survey
> that won't download is 75 questions and 924 responses. Is this
> perhaps just too big for phpESP to handle?
>
> If so, what's the way to split the download into chunks?
>
> I looked a bit harder at the code for survey_export_csv.inc
> and it appears to try and do the job by creating an array.
> Surely it's not trying to dynamically stuff an array with the
> entire results of a survey?
>
> I really hate bugging an author about this kind of thing, but
> I'm BCCing this to the author's name in the script in case he
> can shed any light on the problem.
>
> In the meantime, anyone else stuck with this problem can look
> at the routine I wrote to dump out all the data and rewrite it
> as CSV (two bash scripts and an XSLT routine):
>
> http://silmaril.ie/downloads/software/phpESP_csv-via-xml.tar.gz
>
> ///Peter
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting
> language
> that extends applications into web and mobile media. Attend the live
> webcast
> and join the prime developer group breaking into this new coding
> territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
>
> _______________________________________________
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
 
iD8DBQFEBxKTuucONIvD0AMRAkAJAKCrlNeZHY01ijK7qySKeOTyu/nQFwCgsys+
XVrTbEPnDL+y/OUiRuGRQzM=
=COIv
-----END PGP SIGNATURE-----

Re: [phpesp-general] Zero-length downloads

[Peter F. <pe...@si...>]

Thanks to Aaron Axelsen, who tested a survey on my server, I have 
ascertained that a minimal survey (three questions, one response)
*will* download a CSV file when you try to extract the data.

I am now thinking that the problem is simply size: the survey
that won't download is 75 questions and 924 responses. Is this
perhaps just too big for phpESP to handle?

If so, what's the way to split the download into chunks?

I looked a bit harder at the code for survey_export_csv.inc
and it appears to try and do the job by creating an array.
Surely it's not trying to dynamically stuff an array with the
entire results of a survey?

I really hate bugging an author about this kind of thing, but
I'm BCCing this to the author's name in the script in case he
can shed any light on the problem.

In the meantime, anyone else stuck with this problem can look
at the routine I wrote to dump out all the data and rewrite it
as CSV (two bash scripts and an XSLT routine):

http://silmaril.ie/downloads/software/phpESP_csv-via-xml.tar.gz

///Peter

Re: [phpesp-general] Sender e-mail address

[David L. <lio...@co...>]

Thanks, Matthew --

Matthew Gregg wrote:

> It is possible but you need to edit some code.  Edit line 797 or so in
> admin/include/lib/espresponse.inc.  Changing:
> return(mail($email,$subject,$body,$headers));
> to
> return(mail($email,$subject,$body,$headers,'- fe...@fo...'));
> Replace em...@fo... with a valid "from" address.

Just to clarify, what worked is this (misplaced space in the line above):

return(mail($email,$subject,$body,$headers,'-f em...@fo...'));

Interestingly, the sender address shown to the recipient of this e-mail
is not the one I typed in, namely lio...@co..., but this one: 
phpESP 1.7-rc2 <ph...@ma...>, where the program is running.

The main point is that this did solve the problem and got the mail past
the smtp filters. Thanks!

>
> This should be a configurable item in phpESP.ini.  Could you also post
> a feature request for this on Sourceforge.

Done.

Best,
Dave

>
>
>
> On 2/28/06, *David Liontooth* <lio...@co...
> <mailto:lio...@co...>> wrote:
>
>
>     In the Survey Design form is an option to enter an e-mail address and
>     get a copy of each survey submission. On my system, the sender e-mail
>     <www-data@machine> isn't recognized by the local smtp server and
>     bounces. Is it possible to set the value of the sender address
>     somewhere
>     in phpESP?
>
>     Dave
>
>
>     -------------------------------------------------------
>     This SF.Net email is sponsored by xPML, a groundbreaking scripting
>     language
>     that extends applications into web and mobile media. Attend the
>     live webcast
>     and join the prime developer group breaking into this new coding
>     territory!
>     http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
>     <http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642>
>     _______________________________________________
>     phpESP-general mailing list
>     php...@li...
>     <mailto:php...@li...>
>     https://lists.sourceforge.net/lists/listinfo/phpesp-general
>
>
>
>
> -- 
> D'oh! 

Re: [phpesp-general] Sender e-mail address

[Matthew G. <mat...@gm...>]

It is possible but you need to edit some code.  Edit line 797 or so in
admin/include/lib/espresponse.inc.  Changing:
return(mail($email,$subject,$body,$headers));
to
return(mail($email,$subject,$body,$headers,'-f...@fo...'));
Replace em...@fo... with a valid "from" address.

This should be a configurable item in phpESP.ini.  Could you also post a
feature request for this on Sourceforge.


On 2/28/06, David Liontooth <lio...@co...> wrote:
>
>
> In the Survey Design form is an option to enter an e-mail address and
> get a copy of each survey submission. On my system, the sender e-mail
> <www-data@machine> isn't recognized by the local smtp server and
> bounces. Is it possible to set the value of the sender address somewhere
> in phpESP?
>
> Dave
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting
> language
> that extends applications into web and mobile media. Attend the live
> webcast
> and join the prime developer group breaking into this new coding
> territory!
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat=
=3D121642
> _______________________________________________
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general
>



--
D'oh!

[phpesp-general] French does not work even if it is the default in phpESP.ini.php

[Ron W. <rwh...@ar...>]

The administration page is still in English even though the  test page 
output seems to indicate that everything is set to French.
How is the language string selected?

Ron

PHP Information

    * Version: 5.0.4
    * OS: Linux
    * SAPI: apache2handler
    * register_globals: No
    * magic_quotes_gpc: No
    * magic_quotes_runtime: No
    * safe_mode: No
    * open_basedir:

PHP Extensions

    * dBase: No
    * GD: Yes -- 2.0 or higher
    * GNU Gettext: Yes
    * LDAP: Yes
    * MySQL: Yes
    * PHP Extension Dir (compiled): /usr/lib64/php/extensions
    * PHP Extension Dir (run time): /usr/lib64/php/extensions

phpESP Settings

    * Expected ESP_BASE: /home/usr/local/www/www.eduxxx
    * Expected base_url: www.eduxxx
    * *Loading phpESP.ini.php ...*
    * ESP_BASE: /home/usr/local/www/www.eduxxx/
    * base_url: http://www.eduxxx
    * Version: 1.8
    * Debug: No

phpESP Language Settings

    * GNU Gettext: Real
    * default_lang: fr_FR
    * current lang: fr_FR
    * 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

[phpesp-general] Sender e-mail address

[David L. <lio...@co...>]

In the Survey Design form is an option to enter an e-mail address and
get a copy of each survey submission. On my system, the sender e-mail
<www-data@machine> isn't recognized by the local smtp server and
bounces. Is it possible to set the value of the sender address somewhere
in phpESP?

Dave