[phpesp-dev] [ phpesp-Bugs-1537769 ] Add Section Break Fails

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Bugs item #1537769, was opened at 2006-08-10 02:31
Message generated for change (Comment added) made by liedekef
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1537769&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Admin
Group: v1.8
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Add Section Break Fails

Initial Comment:

Email: itw...@ya...

Get this error when trying to add a section break.

[I'm relatively new at this.  Sorry if this is 
 something bone-headed.]

====================

Notice: Only variable references should be returned by
reference in
C:\webserver\apache\Apache2\htdocs\esp\admin\include\lib\adodb\adodb.inc.php
on line 859

=====================

I've already had to fix one error by modifying php.ini.
Had to set:

allow_call_time_pass_reference = On

====================

Running as 'root/superuser'

phpESP version: v1.8.2
PHP Version 4.4.0

===========
PHPINFO (slightly redacted)

System 	Windows NT
Build Date 	Jul 11 2005 16:08:47
Server API 	CGI/FastCGI
Virtual Directory Support 	enabled
Configuration File (php.ini) Path 	C:\WINDOWS\php.ini
PHP API 	20020918
PHP Extension 	20020429
Zend Extension 	20050606
Debug Build 	no
Zend Memory Manager 	enabled
Thread Safety 	enabled
Registered PHP Streams 	php, http, ftp, compress.zlib

Zend logo This program makes use of the Zend Scripting
Language Engine:
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend
Technologies

PHP Credits
Configuration
PHP Core
Directive	Local Value	Master Value
allow_call_time_pass_reference	On	On
allow_url_fopen	On	On
always_populate_raw_post_data	Off	Off
arg_separator.input	&	&
arg_separator.output	&	&
asp_tags	Off	Off
auto_append_file	no value	no value
auto_prepend_file	no value	no value
browscap	no value	no value
default_charset	no value	no value
default_mimetype	text/html	text/html
define_syslog_variables	Off	Off
disable_classes	no value	no value
disable_functions	no value	no value
display_errors	On	On
display_startup_errors	Off	Off
doc_root	no value	no value
docref_ext	no value	no value
docref_root	no value	no value
enable_dl	On	On
error_append_string	no value	no value
error_log	no value	no value
error_prepend_string	no value	no value
error_reporting	2047	2047
expose_php	On	On
extension_dir	./	./
file_uploads	On	On
gpc_order	GPC	GPC
highlight.bg	#FFFFFF	#FFFFFF
highlight.comment	#FF8000	#FF8000
highlight.default	#0000BB	#0000BB
highlight.html	#000000	#000000
highlight.keyword	#007700	#007700
highlight.string	#DD0000	#DD0000
html_errors	On	On
ignore_repeated_errors	Off	Off
ignore_repeated_source	Off	Off
ignore_user_abort	Off	Off
implicit_flush	Off	Off
include_path	.;c:\php4\pear	.;c:\php4\pear
log_errors	Off	Off
log_errors_max_len	1024	1024
magic_quotes_gpc	Off	Off
magic_quotes_runtime	Off	Off
magic_quotes_sybase	Off	Off
max_execution_time	30	30
max_input_time	60	60
open_basedir	no value	no value
output_buffering	4096	4096
output_handler	no value	no value
post_max_size	8M	8M
precision	14	14
register_argc_argv	Off	Off
register_globals	On	On
report_memleaks	On	On
safe_mode	Off	Off
safe_mode_exec_dir	no value	no value
safe_mode_gid	Off	Off
safe_mode_include_dir	no value	no value
sendmail_from	no value	no value
sendmail_path	no value	no value
serialize_precision	100	100
short_open_tag	On	On
SMTP	localhost	localhost
smtp_port	25	25
sql.safe_mode	Off	Off
track_errors	Off	Off
unserialize_callback_func	no value	no value
upload_max_filesize	2M	2M
upload_tmp_dir	no value	no value
user_dir	no value	no value
variables_order	GCPS	GCPS
xmlrpc_error_number	0	0
xmlrpc_errors	Off	Off
y2k_compliance	On	On

bcmath
BCMath support 	enabled

calendar
Calendar support 	enabled

com
Directive	Local Value	Master Value
com.allow_dcom	Off	Off
com.autoregister_casesensitive	On	On
com.autoregister_typelib	Off	Off
com.autoregister_verbose	Off	Off
com.typelib_file	no value	no value

ctype
ctype functions 	enabled

ftp
FTP support 	enabled

mysql
MySQL Support	enabled
Active Persistent Links 	0
Active Links 	0
Client API version 	3.23.49

Directive	Local Value	Master Value
mysql.allow_persistent	On	On
mysql.connect_timeout	60	60
mysql.default_host	no value	no value
mysql.default_password	no value	no value
mysql.default_port	no value	no value
mysql.default_socket	no value	no value
mysql.default_user	no value	no value
mysql.max_links	Unlimited	Unlimited
mysql.max_persistent	Unlimited	Unlimited
mysql.trace_mode	Off	Off

odbc
ODBC Support	enabled
Active Persistent Links 	0
Active Links 	0
ODBC library 	Win32

Directive	Local Value	Master Value
odbc.allow_persistent	On	On
odbc.check_persistent	On	On
odbc.default_db	no value	no value
odbc.default_pw	no value	no value
odbc.default_user	no value	no value
odbc.defaultbinmode	return as is	return as is
odbc.defaultlrl	return up to 4096 bytes	return up to
4096 bytes
odbc.max_links	Unlimited	Unlimited
odbc.max_persistent	Unlimited	Unlimited

overload
User-Space Object Overloading Support 	enabled

pcre
PCRE (Perl Compatible Regular Expressions) Support 	enabled
PCRE Library Version 	5.0 13-Sep-2004

session
Session Support 	enabled
Registered save handlers 	files user

Directive	Local Value	Master Value
session.auto_start	Off	Off
session.bug_compat_42	Off	Off
session.bug_compat_warn	On	On
session.cache_expire	180	180
session.cache_limiter	nocache	nocache
session.cookie_domain	no value	no value
session.cookie_lifetime	0	0
session.cookie_path	/	/
session.cookie_secure	Off	Off
session.entropy_file	no value	no value
session.entropy_length	0	0
session.gc_divisor	1000	1000
session.gc_maxlifetime	1440	1440
session.gc_probability	1	1
session.name	PHPSESSID	PHPSESSID
session.referer_check	no value	no value
session.save_handler	files	files
session.save_path	no value	no value
session.serialize_handler	php	php
session.use_cookies	On	On
session.use_only_cookies	Off	Off
session.use_trans_sid	Off	Off

standard
Regex Library 	Bundled library enabled
Dynamic Library Support 	enabled
Internal Sendmail Support for Windows 	enabled

Directive	Local Value	Master Value
assert.active	1	1
assert.bail	0	0
assert.callback	no value	no value
assert.quiet_eval	0	0
assert.warning	1	1
auto_detect_line_endings	0	0
default_socket_timeout	60	60
safe_mode_allowed_env_vars	PHP_	PHP_
safe_mode_protected_env_vars	LD_LIBRARY_PATH
LD_LIBRARY_PATH
url_rewriter.tags
a=href,area=href,frame=src,input=src,form=fakeentry
a=href,area=href,frame=src,input=src,form=fakeentry
user_agent	no value	no value

tokenizer
Tokenizer Support 	enabled

wddx
WDDX Support	enabled
WDDX Session Serializer 	enabled

xml
XML Support 	active
XML Namespace Support 	active
EXPAT Version 	1.95.6

zlib
ZLib Support 	enabled
Compiled Version 	1.1.4
Linked Version 	1.1.4

Directive	Local Value	Master Value
zlib.output_compression	Off	Off
zlib.output_compression_level	-1	-1
zlib.output_handler	no value	no value

Additional Modules
Module Name

Environment
Variable	Value

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

>Comment By: Franky Van Liedekerke (liedekef)
Date: 2007-11-27 12:53

Message:
Logged In: YES 
user_id=109671
Originator: NO

In fact, it is very strange that this works as is, as the name is a
required NOT NULL field ...
So I implemented the fix anyway, no harm in doing it.

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

Comment By: Matthew Gregg (greggmc)
Date: 2007-03-05 19:44

Message:
Logged In: YES 
user_id=14116
Originator: NO

allow_call_time_pass_reference = On
does need to be on, but the SQL is fine as is.

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

Comment By: Nobody/Anonymous (nobody)
Date: 2007-03-04 15:41

Message:
Logged In: NO 

I had the same problem too, but I don't think that the error has anything
to do with the problem.
Setting allow_call_time_pass_reference = On did solved some other
problemes although.
Line 329 of the file admin/include/functions/survey_update.php saves the
page break, but the sql query has an error.

$sql = "INSERT INTO ".$GLOBALS['ESPCONFIG']['question_table']."
(survey_id,type_id,position,content)
                VALUES ($sid, 99, $pos, 'break')";
is the original, but misses the field name, which hasn't got a default
value, so it has to be set.
Changing the line into:
$sql = "INSERT INTO ".$GLOBALS['ESPCONFIG']['question_table']."
(survey_id,name,type_id,position,content)
                VALUES ($sid, 'break', 99, $pos, 'break')";
will solve the problem.

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1537769&group_id=8956