Installation issue

A place to discuss and receive support for the Web Auction application.

Installation issue

Postby vyam » Sat Aug 27, 2011 9:13 am

SELECT COUNT(*) as num FROM (select p.*,current_high_bid from products p left join (select product_id,max(bid_amount) as current_high_bid from bids group by product_id) as b on p.product_id=b.product_id) as `products`
Fatal error: View's SELECT contains a subquery in the FROM clauseSELECT COUNT(*) as num FROM (select p.*,current_high_bid from products p left join (select product_id,max(bid_amount) as current_high_bid from bids group by product_id) as b on p.product_id=b.product_id) as `products`On line 128 of file C:\new-xampp-installation\xampp\htdocs\auction\dataface\Dataface\QueryTool.php in function printStackTrace()
On line 531 of file C:\new-xampp-installation\xampp\htdocs\auction\dataface\Dataface\QueryTool.php in function Dataface_QueryTool(products,Resource id #14,array(products,list,list,0,0,30,list,product_categories asc))
On line 1322 of file C:\new-xampp-installation\xampp\htdocs\auction\dataface\Dataface\Application.php in function loadResult(products,Resource id #14,array(products,list,list,0,0,30,list,product_categories asc))
On line 1351 of file C:\new-xampp-installation\xampp\htdocs\auction\dataface\Dataface\Application.php in function getResultSet()
On line 1534 of file C:\new-xampp-installation\xampp in C:\new-xampp-installation\xampp\htdocs\auction\dataface\Dataface\QueryTool.php on line 128


I got above error after installation, am using PHP 5.2.1, MYSQL 5.0.33. Please hep me to resolve this.
vyam
 
Posts: 5
Joined: Sat Aug 27, 2011 9:08 am

Re: Installation issue

Postby shannah » Sun Aug 28, 2011 6:38 am

What version of web auction are you using?
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Re: Installation issue

Postby vyam » Wed Aug 31, 2011 3:38 am

I am using Webauction 0.3.7
vyam
 
Posts: 5
Joined: Sat Aug 27, 2011 9:08 am

Re: Installation issue

Postby vyam » Wed Aug 31, 2011 4:28 am

I have same issue with webauction 0.3.10.. Please advise to resolve it.

Thanks,
Kiran Vyamsani
vyam
 
Posts: 5
Joined: Sat Aug 27, 2011 9:08 am

Re: Installation issue

Postby vyam » Wed Aug 31, 2011 6:10 am

I have pasted my PHPINFO, please et me know if I need to correct any thing.


PHP Version 5.2.1


System Windows NT KIRAN-PC 6.0 build 6001
Build Date Feb 7 2007 23:10:31
Configure Command cscript /nologo configure.js "--enable-snapshot-build" "--with-gd=shared"
Server API Apache 2.0 Handler
Virtual Directory Support enabled
Configuration File (php.ini) Path C:\new-xampp-installation\xampp\apache\bin\php.ini
PHP API 20041225
PHP Extension 20060613
Zend Extension 220060519
Debug Build no
Thread Safety enabled
Zend Memory Manager enabled
IPv6 Support enabled
Registered PHP Streams php, file, data, http, ftp, compress.zlib, https, ftps, zip
Registered Stream Socket Transports tcp, udp, ssl, sslv3, sslv2, tls
Registered Stream Filters convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, zlib.*

This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
with Zend Extension Manager v1.0.11, Copyright (c) 2003-2006, by Zend Technologies
with Zend Optimizer v3.2.2, Copyright (c) 1998-2006, by Zend Technologies

________________________________________
PHP Credits
________________________________________
Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference On On
allow_url_fopen On On
allow_url_include Off Off
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_globals_jit On On
auto_prepend_file no value no value
browscap C:\new-xampp-installation\xampp\php\browscap\browscap.ini C:\new-xampp-installation\xampp\php\browscap\browscap.ini
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 6135 6135
expose_php On On
extension_dir C:\new-xampp-installation\xampp\php\ext\ C:\new-xampp-installation\xampp\php\ext\
file_uploads On On
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:\new-xampp-installation\xampp\php\pear\ .;C:\new-xampp-installation\xampp\php\pear\
log_errors Off Off
log_errors_max_len 1024 1024
magic_quotes_gpc On On
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
mail.force_extra_parameters no value no value
max_execution_time 900 900
max_input_time 120 120
memory_limit 128M 128M
open_basedir no value no value
output_buffering no value no value
output_handler no value no value
post_max_size 16M 16M
precision 12 12
realpath_cache_size 16K 16K
realpath_cache_ttl 120 120
register_argc_argv On On
register_globals Off Off
register_long_arrays On On
report_memleaks On On
report_zend_debug 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 32M 32M
upload_tmp_dir C:\new-xampp-installation\xampp\tmp C:\new-xampp-installation\xampp\tmp
user_dir no value no value
variables_order EGPCS EGPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
zend.ze1_compatibility_mode Off Off

apache2handler
Apache Version Apache/2.2.4 (Win32) DAV/2 mod_ssl/2.2.4 OpenSSL/0.9.8d mod_autoindex_color PHP/5.2.1
Apache API Version 20051115
Server Administrator admin@localhost
Hostname:Port localhost:80
Max Requests Per Child: 0 - Keep Alive: on - Max Per Connection: 100
Timeouts Connection: 300 - Keep-Alive: 5
Virtual Server No
Server Root C:/new-xampp-installation/xampp/apache
Loaded Modules core mod_win32 mpm_winnt http_core mod_so mod_actions mod_alias mod_asis mod_auth_basic mod_authn_default mod_authn_file mod_authz_default mod_authz_groupfile mod_authz_host mod_authz_user mod_cgi mod_dav mod_dav_fs mod_dir mod_env mod_include mod_info mod_isapi util_ldap mod_log_config mod_mime mod_negotiation mod_rewrite mod_setenvif mod_status mod_ssl mod_autoindex_color mod_php5

Directive Local Value Master Value
engine 1 1
last_modified 0 0
xbithack 0 0

Apache Environment
Variable Value
HTTP_HOST localhost
HTTP_USER_AGENT Mozilla/5.0 (Windows; U; Windows NT 6.0; en-GB; rv:1.9.2.16) Gecko/20110319 Firefox/3.6.16 ( .NET CLR 3.5.30729) SearchToolbar/1.2
HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_LANGUAGE en-gb,en;q=0.5
HTTP_ACCEPT_ENCODING gzip,deflate
HTTP_ACCEPT_CHARSET ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_KEEP_ALIVE 115
HTTP_CONNECTION keep-alive
HTTP_REFERER http://localhost/xampp/navi.php
HTTP_COOKIE dataface__lang=en; ba1f60ec9b903a3c4f778f88583bb69c=84fa1d280dec05ee194308f55cfc3109
PATH C:\Perl\site\bin;C:\Perl\bin;C:\new-xampp-installation\xampp\htdocs\cacti;C:\Program Files\PC Connectivity Solution\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files\Diskeeper Corporation\Diskeeper\;C:\Program Files\Common Files\Roxio Shared\DLLShared\;C:\Program Files\Common Files\Roxio Shared\DLLShared\;C:\Program Files\Common Files\Roxio Shared\9.0\DLLShared\;C:\Program Files\Common Files\Lenovo;C:\Program Files\ThinkPad\ConnectUtilities;C:\Program Files\Lenovo\Client Security Solution;C:\Program Files\QuickTime\QTSystem\;C:\Program Files\Smart Projects\IsoBuster;C:\java5.0\jdk\bin;C:\java\bin;C:\Program Files\SSH Communications Security\SSH Secure Shell
SystemRoot C:\Windows
COMSPEC C:\Windows\system32\cmd.exe
PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
WINDIR C:\Windows
SERVER_SIGNATURE <address>Apache/2.2.4 (Win32) DAV/2 mod_ssl/2.2.4 OpenSSL/0.9.8d mod_autoindex_color PHP/5.2.1 Server at localhost Port 80</address>
SERVER_SOFTWARE Apache/2.2.4 (Win32) DAV/2 mod_ssl/2.2.4 OpenSSL/0.9.8d mod_autoindex_color PHP/5.2.1
SERVER_NAME localhost
SERVER_ADDR 127.0.0.1
SERVER_PORT 80
REMOTE_ADDR 127.0.0.1
DOCUMENT_ROOT C:/new-xampp-installation/xampp/htdocs
SERVER_ADMIN admin@localhost
SCRIPT_FILENAME C:/new-xampp-installation/xampp/htdocs/xampp/phpinfo.php
REMOTE_PORT 50960
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING no value
REQUEST_URI /xampp/phpinfo.php
SCRIPT_NAME /xampp/phpinfo.php

HTTP Headers Information
HTTP Request Headers
HTTP Request GET /xampp/phpinfo.php HTTP/1.1
Host localhost
User-Agent Mozilla/5.0 (Windows; U; Windows NT 6.0; en-GB; rv:1.9.2.16) Gecko/20110319 Firefox/3.6.16 ( .NET CLR 3.5.30729) SearchToolbar/1.2
Accept text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language en-gb,en;q=0.5
Accept-Encoding gzip,deflate
Accept-Charset ISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive 115
Connection keep-alive
Referer http://localhost/xampp/navi.php
Cookie dataface__lang=en; ba1f60ec9b903a3c4f778f88583bb69c=84fa1d280dec05ee194308f55cfc3109
HTTP Response Headers
X-Powered-By PHP/5.2.1
Keep-Alive timeout=5, max=98
Connection Keep-Alive
Transfer-Encoding chunked
Content-Type text/html

bcmath
BCMath support enabled

calendar
Calendar support enabled

com_dotnet
COM support enabled
DCOM support disabled
.Net support enabled

Directive Local Value Master Value
com.allow_dcom 0 0
com.autoregister_casesensitive 1 1
com.autoregister_typelib 0 0
com.autoregister_verbose 0 0
com.code_page no value no value
com.typelib_file no value no value

ctype
ctype functions enabled

curl
cURL support enabled
cURL Information libcurl/7.16.0 OpenSSL/0.9.8d zlib/1.2.3

date
date/time support enabled
Timezone Database Version 2006.16
Timezone Database internal
Default timezone America/Chicago

Directive Local Value Master Value
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.583333 90.583333
date.sunset_zenith 90.583333 90.583333
date.timezone no value no value

dom
DOM/XML enabled
DOM/XML API Version 20031129
libxml Version 2.6.26
HTML Support enabled
XPath Support enabled
XPointer Support enabled
Schema Support enabled
RelaxNG Support enabled

exif
EXIF Support enabled
EXIF Version 1.4 $Id: exif.c,v 1.173.2.5.2.11 2007/01/23 00:23:17 iliaa Exp $
Supported EXIF Version 0220
Supported filetypes JPEG,TIFF

filter
Input Validation and Filtering enabled
Revision $Revision: 1.52.2.38 $

Directive Local Value Master Value
filter.default unsafe_raw unsafe_raw
filter.default_flags no value no value

ftp
FTP support enabled

gd
GD Support enabled
GD Version bundled (2.0.28 compatible)
FreeType Support enabled
FreeType Linkage with freetype
FreeType Version 2.1.9
T1Lib Support enabled
GIF Read Support enabled
GIF Create Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled

gettext
GetText Support enabled

hash
hash support enabled
Hashing Engines md2 md4 md5 sha1 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru gost adler32 crc32 crc32b haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5

iconv
iconv support enabled
iconv implementation "libiconv"
iconv library version 1.9

Directive Local Value Master Value
iconv.input_encoding ISO-8859-1 ISO-8859-1
iconv.internal_encoding ISO-8859-1 ISO-8859-1
iconv.output_encoding ISO-8859-1 ISO-8859-1

imap
IMAP c-Client Version 2004
SSL Support enabled

json
json support enabled
json version 1.2.1

libxml
libXML support active
libXML Version 2.6.26
libXML streams enabled

mbstring
Multibyte Support enabled
Multibyte string engine libmbfl
Multibyte (japanese) regex support enabled
Multibyte regex (oniguruma) version 4.4.4
Multibyte regex (oniguruma) backtrack check On

mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.

Directive Local Value Master Value
mbstring.detect_order no value no value
mbstring.encoding_translation Off Off
mbstring.func_overload 0 0
mbstring.http_input pass pass
mbstring.http_output pass pass
mbstring.internal_encoding no value no value
mbstring.language neutral neutral
mbstring.strict_detection Off Off
mbstring.substitute_character no value no value

mcrypt
mcrypt support enabled
Version 2.5.7
Api No 20021217
Supported ciphers cast-128 gost rijndael-128 twofish arcfour cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes
Supported modes cbc cfb ctr ecb ncfb nofb ofb stream

Directive Local Value Master Value
mcrypt.algorithms_dir no value no value
mcrypt.modes_dir no value no value

mime_magic
mime_magic support

Directive Local Value Master Value
mime_magic.debug Off Off
mime_magic.magicfile C:\new-xampp-installation\xampp\php\extras\magic.mime C:\new-xampp-installation\xampp\php\extras\magic.mime

ming
Ming SWF output library enabled
Version 0.3beta1

mssql
MSSQL Support enabled
Active Persistent Links 0
Active Links 0
Library version 7.0

Directive Local Value Master Value
mssql.allow_persistent On On
mssql.batchsize 0 0
mssql.compatability_mode Off Off
mssql.connect_timeout 5 5
mssql.datetimeconvert On On
mssql.max_links Unlimited Unlimited
mssql.max_persistent Unlimited Unlimited
mssql.max_procs Unlimited Unlimited
mssql.min_error_severity 10 10
mssql.min_message_severity 10 10
mssql.secure_connection Off Off
mssql.textlimit Server default Server default
mssql.textsize Server default Server default
mssql.timeout 60 60

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

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

mysqli
MysqlI Support enabled
Client API library version 5.0.33
Client API header version 5.0.33
MYSQLI_SOCKET /tmp/mysql.sock

Directive Local Value Master Value
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.reconnect 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

openssl
OpenSSL support enabled
OpenSSL Version OpenSSL 0.9.8d 28 Sep 2006

pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 6.7 04-Jul-2006

pdf
PDF Support enabled
PDFlib GmbH Version 5.0.3
PECL Version 2.1.1
Revision $Revision: 1.151 $

PDO
PDO support enabled
PDO drivers mssql, mysql, sqlite2

pdo_mssql
PDO Driver for MSSQL DB-lib enabled
Flavour MSSQL_70

pdo_mysql
PDO Driver for MySQL, client library version 5.0.33

Reflection
Reflection enabled
Version $Id: php_reflection.c,v 1.164.2.33.2.33 2007/01/01 09:36:05 sebastian Exp $

session
Session Support enabled
Registered save handlers files user sqlite
Registered serializer handlers php php_binary wddx

Directive Local Value Master Value
session.auto_start Off Off
session.bug_compat_42 On On
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_httponly Off Off
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 100 100
session.gc_maxlifetime 1440 1440
session.gc_probability 1 1
session.hash_bits_per_character 4 4
session.hash_function 0 0
session.name PHPSESSID PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path C:\new-xampp-installation\xampp\tmp C:\new-xampp-installation\xampp\tmp
session.serialize_handler php php
session.use_cookies On On
session.use_only_cookies Off Off
session.use_trans_sid 0 0

SimpleXML
Simplexml support enabled
Revision $Revision: 1.151.2.22.2.20 $
Schema support enabled

soap
Soap Client enabled
Soap Server enabled

Directive Local Value Master Value
soap.wsdl_cache 1 1
soap.wsdl_cache_dir C:\new-xampp-installation\xampp\tmp C:\new-xampp-installation\xampp\tmp
soap.wsdl_cache_enabled 1 1
soap.wsdl_cache_limit 5 5
soap.wsdl_cache_ttl 86400 86400

sockets
Sockets Support enabled

SPL
SPL support enabled
Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RegexIterator, RuntimeException, SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException

SQLite
SQLite support enabled
PECL Module version 2.0-dev $Id: sqlite.c,v 1.166.2.13.2.6 2007/01/01 09:36:07 sebastian Exp $
SQLite Library 2.8.17
SQLite Encoding iso8859

Directive Local Value Master Value
sqlite.assoc_case 0 0

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=,fieldset= a=href,area=href,frame=src,input=src,form=,fieldset=
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
libxml2 Version 2.6.26

xmlreader
XMLReader enabled

xmlrpc
core library version xmlrpc-epi v. 0.51
php extension version 0.51
author Dan Libby
homepage http://xmlrpc-epi.sourceforge.net
open sourced by Epinions.com

xmlwriter
XMLWriter enabled

xsl
XSL enabled
libxslt Version 1.1.17
libxslt compiled against libxml Version 2.6.26
EXSLT enabled
libexslt Version 0.8.13

Zend Optimizer
Optimization Pass 1 enabled
Optimization Pass 2 enabled
Optimization Pass 3 enabled
Optimization Pass 4 enabled
Optimization Pass 9 disabled
Zend Loader disabled
License Path no value
Obfuscation level 0

zip
Zip enabled
Extension Version $Id: php_zip.c,v 1.1.2.27 2007/01/29 15:25:06 pajoye Exp $
Zip version 2.0.0
Libzip version 0.7.1

zlib
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.3
Linked Version 1.2.3

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
ALLUSERSPROFILE C:\ProgramData
APPDATA C:\Users\kiran\AppData\Roaming
CATALINA_HOME C:\Tomcat 5.0
CLASSPATH C:\java\jre\lib\rt.jar;C:\Tomcat 5.0\common\lib\servlet-api.jar;
CLASS_PATH C:\java5.0\jdk\lib
CommonProgramFiles C:\Program Files\Common Files
COMPUTERNAME KIRAN-PC
ComSpec C:\Windows\system32\cmd.exe
FP_NO_HOST_CHECK NO
HOMEDRIVE C:
HOMEPATH \Users\kiran
JAVA_HOME C:\java5.0\jdk
LOCALAPPDATA C:\Users\kiran\AppData\Local
LOGONSERVER \\KIRAN-PC
NUMBER_OF_PROCESSORS 2
OS Windows_NT
Path C:\Perl\site\bin;C:\Perl\bin;C:\new-xampp-installation\xampp\htdocs\cacti;C:\Program Files\PC Connectivity Solution\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files\Diskeeper Corporation\Diskeeper\;C:\Program Files\Common Files\Roxio Shared\DLLShared\;C:\Program Files\Common Files\Roxio Shared\DLLShared\;C:\Program Files\Common Files\Roxio Shared\9.0\DLLShared\;C:\Program Files\Common Files\Lenovo;C:\Program Files\ThinkPad\ConnectUtilities;C:\Program Files\Lenovo\Client Security Solution;C:\Program Files\QuickTime\QTSystem\;C:\Program Files\Smart Projects\IsoBuster;C:\java5.0\jdk\bin;C:\java\bin;C:\Program Files\SSH Communications Security\SSH Secure Shell
PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE x86
PROCESSOR_IDENTIFIER x86 Family 6 Model 23 Stepping 6, GenuineIntel
PROCESSOR_LEVEL 6
PROCESSOR_REVISION 1706
ProgramData C:\ProgramData
ProgramFiles C:\Program Files
PROMPT $P$G
PUBLIC C:\Users\Public
QTJAVA C:\Program Files\Java\jre1.6.0_02\lib\ext\QTJava.zip
RoxioCentral C:\Program Files\Common Files\Roxio Shared\9.0\Roxio Central33\
RR C:\Program Files\Lenovo\Rescue and Recovery
SESSIONNAME Console
SMA C:\Program Files\ThinkVantage\SMA\
SWSHARE C:\SWSHARE
SystemDrive C:
SystemRoot C:\Windows
TEMP C:\Users\kiran\AppData\Local\Temp
TMP C:\Users\kiran\AppData\Local\Temp
TPCCommon C:\PROGRA~1\THINKV~1\PrdCtr
TVT C:\Program Files\Lenovo
TVTCOMMON C:\Program Files\Common Files\Lenovo
TVTPYDIR C:\Program Files\Common Files\Lenovo\Python24
USERDOMAIN Kiran-PC
USERNAME kiran
USERPROFILE C:\Users\kiran
VS80COMNTOOLS C:\Program Files\Microsoft Visual Studio 8\Common7\Tools\
windir C:\Windows
AP_PARENT_PID 6496

PHP Variables
Variable Value
_REQUEST["dataface__lang"] en
_REQUEST["ba1f60ec9b903a3c4f778f88583bb69c"] 84fa1d280dec05ee194308f55cfc3109
_COOKIE["dataface__lang"] en
_COOKIE["ba1f60ec9b903a3c4f778f88583bb69c"] 84fa1d280dec05ee194308f55cfc3109
_SERVER["HTTP_HOST"] localhost
_SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (Windows; U; Windows NT 6.0; en-GB; rv:1.9.2.16) Gecko/20110319 Firefox/3.6.16 ( .NET CLR 3.5.30729) SearchToolbar/1.2
_SERVER["HTTP_ACCEPT"] text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-gb,en;q=0.5
_SERVER["HTTP_ACCEPT_ENCODING"] gzip,deflate
_SERVER["HTTP_ACCEPT_CHARSET"] ISO-8859-1,utf-8;q=0.7,*;q=0.7
_SERVER["HTTP_KEEP_ALIVE"] 115
_SERVER["HTTP_CONNECTION"] keep-alive
_SERVER["HTTP_REFERER"] http://localhost/xampp/navi.php
_SERVER["HTTP_COOKIE"] dataface__lang=en; ba1f60ec9b903a3c4f778f88583bb69c=84fa1d280dec05ee194308f55cfc3109
_SERVER["PATH"] C:\Perl\site\bin;C:\Perl\bin;C:\new-xampp-installation\xampp\htdocs\cacti;C:\Program Files\PC Connectivity Solution\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files\Diskeeper Corporation\Diskeeper\;C:\Program Files\Common Files\Roxio Shared\DLLShared\;C:\Program Files\Common Files\Roxio Shared\DLLShared\;C:\Program Files\Common Files\Roxio Shared\9.0\DLLShared\;C:\Program Files\Common Files\Lenovo;C:\Program Files\ThinkPad\ConnectUtilities;C:\Program Files\Lenovo\Client Security Solution;C:\Program Files\QuickTime\QTSystem\;C:\Program Files\Smart Projects\IsoBuster;C:\java5.0\jdk\bin;C:\java\bin;C:\Program Files\SSH Communications Security\SSH Secure Shell
_SERVER["SystemRoot"] C:\Windows
_SERVER["COMSPEC"] C:\Windows\system32\cmd.exe
_SERVER["PATHEXT"] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
_SERVER["WINDIR"] C:\Windows
_SERVER["SERVER_SIGNATURE"] <address>Apache/2.2.4 (Win32) DAV/2 mod_ssl/2.2.4 OpenSSL/0.9.8d mod_autoindex_color PHP/5.2.1 Server at localhost Port 80</address>
_SERVER["SERVER_SOFTWARE"] Apache/2.2.4 (Win32) DAV/2 mod_ssl/2.2.4 OpenSSL/0.9.8d mod_autoindex_color PHP/5.2.1
_SERVER["SERVER_NAME"] localhost
_SERVER["SERVER_ADDR"] 127.0.0.1
_SERVER["SERVER_PORT"] 80
_SERVER["REMOTE_ADDR"] 127.0.0.1
_SERVER["DOCUMENT_ROOT"] C:/new-xampp-installation/xampp/htdocs
_SERVER["SERVER_ADMIN"] admin@localhost
_SERVER["SCRIPT_FILENAME"] C:/new-xampp-installation/xampp/htdocs/xampp/phpinfo.php
_SERVER["REMOTE_PORT"] 50960
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["QUERY_STRING"] no value
_SERVER["REQUEST_URI"] /xampp/phpinfo.php
_SERVER["SCRIPT_NAME"] /xampp/phpinfo.php
_SERVER["PHP_SELF"] /xampp/phpinfo.php
_SERVER["REQUEST_TIME"] 1314795987
_SERVER["argv"] Array
(
)
_SERVER["argc"] 0
_ENV["ALLUSERSPROFILE"] C:\ProgramData
_ENV["APPDATA"] C:\Users\kiran\AppData\Roaming
_ENV["CATALINA_HOME"] C:\Tomcat 5.0
_ENV["CLASSPATH"] C:\java\jre\lib\rt.jar;C:\Tomcat 5.0\common\lib\servlet-api.jar;
_ENV["CLASS_PATH"] C:\java5.0\jdk\lib
_ENV["CommonProgramFiles"] C:\Program Files\Common Files
_ENV["COMPUTERNAME"] KIRAN-PC
_ENV["ComSpec"] C:\Windows\system32\cmd.exe
_ENV["FP_NO_HOST_CHECK"] NO
_ENV["HOMEDRIVE"] C:
_ENV["HOMEPATH"] \Users\kiran
_ENV["JAVA_HOME"] C:\java5.0\jdk
_ENV["LOCALAPPDATA"] C:\Users\kiran\AppData\Local
_ENV["LOGONSERVER"] \\KIRAN-PC
_ENV["NUMBER_OF_PROCESSORS"] 2
_ENV["OS"] Windows_NT
_ENV["Path"] C:\Perl\site\bin;C:\Perl\bin;C:\new-xampp-installation\xampp\htdocs\cacti;C:\Program Files\PC Connectivity Solution\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files\Diskeeper Corporation\Diskeeper\;C:\Program Files\Common Files\Roxio Shared\DLLShared\;C:\Program Files\Common Files\Roxio Shared\DLLShared\;C:\Program Files\Common Files\Roxio Shared\9.0\DLLShared\;C:\Program Files\Common Files\Lenovo;C:\Program Files\ThinkPad\ConnectUtilities;C:\Program Files\Lenovo\Client Security Solution;C:\Program Files\QuickTime\QTSystem\;C:\Program Files\Smart Projects\IsoBuster;C:\java5.0\jdk\bin;C:\java\bin;C:\Program Files\SSH Communications Security\SSH Secure Shell
_ENV["PATHEXT"] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
_ENV["PROCESSOR_ARCHITECTURE"] x86
_ENV["PROCESSOR_IDENTIFIER"] x86 Family 6 Model 23 Stepping 6, GenuineIntel
_ENV["PROCESSOR_LEVEL"] 6
_ENV["PROCESSOR_REVISION"] 1706
_ENV["ProgramData"] C:\ProgramData
_ENV["ProgramFiles"] C:\Program Files
_ENV["PROMPT"] $P$G
_ENV["PUBLIC"] C:\Users\Public
_ENV["QTJAVA"] C:\Program Files\Java\jre1.6.0_02\lib\ext\QTJava.zip
_ENV["RoxioCentral"] C:\Program Files\Common Files\Roxio Shared\9.0\Roxio Central33\
_ENV["RR"] C:\Program Files\Lenovo\Rescue and Recovery
_ENV["SESSIONNAME"] Console
_ENV["SMA"] C:\Program Files\ThinkVantage\SMA\
_ENV["SWSHARE"] C:\SWSHARE
_ENV["SystemDrive"] C:
_ENV["SystemRoot"] C:\Windows
_ENV["TEMP"] C:\Users\kiran\AppData\Local\Temp
_ENV["TMP"] C:\Users\kiran\AppData\Local\Temp
_ENV["TPCCommon"] C:\PROGRA~1\THINKV~1\PrdCtr
_ENV["TVT"] C:\Program Files\Lenovo
_ENV["TVTCOMMON"] C:\Program Files\Common Files\Lenovo
_ENV["TVTPYDIR"] C:\Program Files\Common Files\Lenovo\Python24
_ENV["USERDOMAIN"] Kiran-PC
_ENV["USERNAME"] kiran
_ENV["USERPROFILE"] C:\Users\kiran
_ENV["VS80COMNTOOLS"] C:\Program Files\Microsoft Visual Studio 8\Common7\Tools\
_ENV["windir"] C:\Windows
_ENV["AP_PARENT_PID"] 6496

PHP License
This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact license@php.net.
vyam
 
Posts: 5
Joined: Sat Aug 27, 2011 9:08 am

Re: Installation issue

Postby shannah » Wed Aug 31, 2011 7:55 pm

This appears to be a bug in that version of MySQL.
http://bugs.mysql.com/bug.php?id=25897

To improve performance, Xataface attempts to create a view for queries. It fails silently if there is a problem creating the view. Unfortunately, this bug in MySQL causes subsequent queries that don't even use a view to fail after the creation of the view fails.

To fix this you can either upgrade or patch your version of MySQL, or disable Xataface's proxy views. Instructions for patching mysql are in the mysql bug report:
http://bugs.mysql.com/bug.php?id=25897

You can turn off Xataface proxy views by adding:
Code: Select all
define('XATAFACE_DISABLE_PROXY_VIEWS',1);

to the beginning of your index.php file.

-Steve
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Re: Installation issue

Postby vyam » Thu Sep 01, 2011 12:09 pm

Thanks, its worked for me.
vyam
 
Posts: 5
Joined: Sat Aug 27, 2011 9:08 am


Return to Web Auction Discussion

Who is online

Users browsing this forum: No registered users and 19 guests

cron
Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved