MySQL Error : Query Error - SELECT * FROM songs WHERE album_id=1904 AND id<> Error Number: 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 '' at line 1 Date : Fri, November 21, 2008 20:48:14 IP : 38.103.63.56 Browser : CCBot/1.0 (+http://www.commoncrawl.org/bot.html) Referer : PHP Version : 4.4.9 OS : Linux Server : Apache/1.3.41 (Unix) mod_log_bytes/1.2 mod_bwlimited/1.4 mod_auth_passthrough/1.8 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.7a Server Name : lyricsden.com
PHP Version 4.4.9 |
| System | Linux ls909.hostito.com 2.6.9-42.0.10.ELsmp #1 SMP Tue Feb 27 10:11:19 EST 2007 i686 |
| Build Date | Sep 12 2008 11:19:57 |
| Configure Command | './configure' '--enable-bcmath' '--enable-calendar' '--enable-discard-path' '--enable-ftp' '--enable-gd-native-ttf' '--enable-libxml' '--enable-magic-quotes' '--enable-sockets' '--prefix=/usr' '--with-curl=/opt/curlssl/' '--with-freetype-dir=/usr' '--with-gd' '--with-imap=/opt/php_with_imap_client/' '--with-imap-ssl=/usr' '--with-jpeg-dir=/usr' '--with-kerberos' '--with-libxml-dir=/opt/xml2/' '--with-mcrypt=/opt/libmcrypt/' '--with-mhash=/opt/mhash/' '--with-png-dir=/usr' '--with-pspell' '--with-ttf' '--with-xpm-dir=/usr/X11R6' '--with-zlib' '--with-zlib-dir=/usr' |
| Server API | CGI |
| Virtual Directory Support | disabled |
| Configuration File (php.ini) Path | /usr/local/lib/php.ini |
| PHP API | 20020918 |
| PHP Extension | 20020429 |
| Zend Extension | 20050606 |
| Debug Build | no |
| Zend Memory Manager | enabled |
| Thread Safety | disabled |
| Registered PHP Streams | php, http, ftp, compress.zlib |
| 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 | error_log | error_log |
| error_prepend_string | no value | no value |
| error_reporting | 2039 | 2039 |
| expose_php | On | On |
| extension_dir | /usr/local/lib/php/extensions/no-debug-non-zts-20020429 | /usr/local/lib/php/extensions/no-debug-non-zts-20020429 |
| 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 | .:/usr/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php |
| log_errors | On | On |
| log_errors_max_len | 1024 | 1024 |
| magic_quotes_gpc | On | On |
| magic_quotes_runtime | Off | Off |
| magic_quotes_sybase | Off | Off |
| max_execution_time | 30 | 30 |
| max_input_nesting_level | 500 | 500 |
| max_input_time | 60 | 60 |
| open_basedir | no value | no value |
| output_buffering | no value | no value |
| output_handler | no value | no value |
| post_max_size | 80M | 80M |
| precision | 12 | 12 |
| register_argc_argv | On | On |
| 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 | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i |
| 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 | 200M | 200M |
| upload_tmp_dir | no value | no value |
| user_dir | no value | no value |
| variables_order | EGPCS | EGPCS |
| xmlrpc_error_number | 0 | 0 |
| xmlrpc_errors | Off | Off |
| y2k_compliance | On | On |
| BCMath support | enabled |
| Calendar support | enabled |
| ctype functions | enabled |
| CURL support | enabled |
| CURL Information | libcurl/7.19.0 OpenSSL/0.9.7a zlib/1.2.1.2 libidn/0.5.6 |
| FTP support | enabled |
| GD Support | enabled |
| GD Version | bundled (2.0.28 compatible) |
| FreeType Support | enabled |
| FreeType Linkage | with freetype |
| GIF Read Support | enabled |
| GIF Create Support | enabled |
| JPG Support | enabled |
| PNG Support | enabled |
| WBMP Support | enabled |
| XBM Support | enabled |
| IMAP c-Client Version | 2004 |
| SSL Support | enabled |
| Kerberos Support | enabled |
| mcrypt support | enabled |
|---|---|
| version | >= 2.4.x |
| 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 |
| MHASH support | Enabled |
| MHASH API Version | 20060101 |
| MySQL Support | enabled |
|---|---|
| Active Persistent Links | 1 |
| Active Links | 1 |
| Client API version | 3.23.49 |
| MYSQL_MODULE_TYPE | builtin |
| MYSQL_SOCKET | /var/tmp/mysql.sock |
| MYSQL_INCLUDE | no value |
| MYSQL_LIBS | no value |
| 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 |
| User-Space Object Overloading Support | enabled |
| PCRE (Perl Compatible Regular Expressions) Support | enabled |
| PCRE Library Version | 7.7 2008-05-07 |
| Revision | $Revision: 1.51.2.4.2.4 $ |
| PSpell Support | enabled |
| Session Support | enabled |
| Registered save handlers | files user |
| 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_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.name | PHPSESSID | PHPSESSID |
| session.referer_check | no value | no value |
| session.save_handler | files | files |
| session.save_path | /tmp | /tmp |
| session.serialize_handler | php | php |
| session.use_cookies | On | On |
| session.use_only_cookies | Off | Off |
| session.use_trans_sid | Off | Off |
| Sockets Support | enabled |
| Regex Library | Bundled library enabled |
| Dynamic Library Support | enabled |
| Path to sendmail | /usr/sbin/sendmail -t -i |
| 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 Support | enabled |
| XML Support | active |
| XML Namespace Support | active |
| EXPAT Version | 1.95.6 |
| ZLib Support | enabled |
| Compiled Version | 1.2.1.2 |
| Linked Version | 1.2.1.2 |
| Directive | Local Value | Master Value |
|---|---|---|
| zlib.output_compression | Off | Off |
| zlib.output_compression_level | -1 | -1 |
| zlib.output_handler | no value | no value |
| Module Name |
|---|
| ionCube Loader |
| Variable | Value |
|---|---|
| DOCUMENT_ROOT | /home/lyricsde/public_html |
| GATEWAY_INTERFACE | CGI/1.1 |
| HTTP_ACCEPT | Accept: application/xhtml+xml,text/html;q=0.9,text/plain; |
| HTTP_ACCEPT_CHARSET | ISO-8859-1,utf-8;q=0.7,*;q=0.7 |
| HTTP_ACCEPT_ENCODING | gzip |
| HTTP_ACCEPT_LANGUAGE | en-us,en;q=0.5 |
| HTTP_CACHE_CONTROL | no-cache |
| HTTP_CONNECTION | close |
| HTTP_HOST | lyricsden.com |
| HTTP_PRAGMA | no-cache |
| HTTP_USER_AGENT | CCBot/1.0 (+http://www.commoncrawl.org/bot.html) |
| PATH | /bin:/usr/bin |
| QUERY_STRING | new_a=song2&path=/d/dandy-warhols/&song=Be-in.html;Featuring_Kia_Jefferies_Quot;_&album=Dandy_Warhols_Come_Down |
| REDIRECT_QUERY_STRING | new_a=song2&path=/d/dandy-warhols/&song=Be-in.html;Featuring_Kia_Jefferies_Quot;_&album=Dandy_Warhols_Come_Down |
| REDIRECT_STATUS | 200 |
| REDIRECT_UNIQUE_ID | SSdk3kH@NmIAAHmTmsE |
| REDIRECT_URL | /d/dandy-warhols/Dandy_Warhols_Come_Down/Be-in.html;Featuring_Kia_Jefferies_Quot;_.html |
| REMOTE_ADDR | 38.103.63.56 |
| REMOTE_PORT | 45018 |
| REQUEST_METHOD | GET |
| REQUEST_URI | /d/dandy-warhols/Dandy_Warhols_Come_Down/Be-in.html;Featuring_Kia_Jefferies_Quot;_.html |
| SCRIPT_FILENAME | /home/lyricsde/public_html/index.php |
| SCRIPT_NAME | /index.php |
| SERVER_ADDR | 65.254.54.98 |
| SERVER_ADMIN | webmaster@lyricsden.com |
| SERVER_NAME | lyricsden.com |
| SERVER_PORT | 80 |
| SERVER_PROTOCOL | HTTP/1.1 |
| SERVER_SIGNATURE | <ADDRESS>Apache/1.3.41 Server at lyricsden.com Port 80</ADDRESS> |
| SERVER_SOFTWARE | Apache/1.3.41 (Unix) mod_log_bytes/1.2 mod_bwlimited/1.4 mod_auth_passthrough/1.8 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.7a |
| UNIQUE_ID | SSdk3kH@NmIAAHmTmsE |
| Variable | Value |
|---|---|
| PHP_SELF | /index.php |
| _REQUEST["new_a"] | song2 |
| _REQUEST["path"] | /d/dandy-warhols/ |
| _REQUEST["song"] | Be-in.html;Featuring_Kia_Jefferies_Quot;_ |
| _REQUEST["album"] | Dandy_Warhols_Come_Down |
| _GET["new_a"] | song2 |
| _GET["path"] | /d/dandy-warhols/ |
| _GET["song"] | Be-in.html;Featuring_Kia_Jefferies_Quot;_ |
| _GET["album"] | Dandy_Warhols_Come_Down |
| _SERVER["DOCUMENT_ROOT"] | /home/lyricsde/public_html |
| _SERVER["GATEWAY_INTERFACE"] | CGI/1.1 |
| _SERVER["HTTP_ACCEPT"] | Accept: application/xhtml+xml,text/html;q=0.9,text/plain; |
| _SERVER["HTTP_ACCEPT_CHARSET"] | ISO-8859-1,utf-8;q=0.7,*;q=0.7 |
| _SERVER["HTTP_ACCEPT_ENCODING"] | gzip |
| _SERVER["HTTP_ACCEPT_LANGUAGE"] | en-us,en;q=0.5 |
| _SERVER["HTTP_CACHE_CONTROL"] | no-cache |
| _SERVER["HTTP_CONNECTION"] | close |
| _SERVER["HTTP_HOST"] | lyricsden.com |
| _SERVER["HTTP_PRAGMA"] | no-cache |
| _SERVER["HTTP_USER_AGENT"] | CCBot/1.0 (+http://www.commoncrawl.org/bot.html) |
| _SERVER["PATH"] | /bin:/usr/bin |
| _SERVER["QUERY_STRING"] | new_a=song2&path=/d/dandy-warhols/&song=Be-in.html;Featuring_Kia_Jefferies_Quot;_&album=Dandy_Warhols_Come_Down |
| _SERVER["REDIRECT_QUERY_STRING"] | new_a=song2&path=/d/dandy-warhols/&song=Be-in.html;Featuring_Kia_Jefferies_Quot;_&album=Dandy_Warhols_Come_Down |
| _SERVER["REDIRECT_STATUS"] | 200 |
| _SERVER["REDIRECT_UNIQUE_ID"] | SSdk3kH@NmIAAHmTmsE |
| _SERVER["REDIRECT_URL"] | /d/dandy-warhols/Dandy_Warhols_Come_Down/Be-in.html;Featuring_Kia_Jefferies_Quot;_.html |
| _SERVER["REMOTE_ADDR"] | 38.103.63.56 |
| _SERVER["REMOTE_PORT"] | 45018 |
| _SERVER["REQUEST_METHOD"] | GET |
| _SERVER["REQUEST_URI"] | /d/dandy-warhols/Dandy_Warhols_Come_Down/Be-in.html;Featuring_Kia_Jefferies_Quot;_.html |
| _SERVER["SCRIPT_FILENAME"] | /home/lyricsde/public_html/index.php |
| _SERVER["SCRIPT_NAME"] | /index.php |
| _SERVER["SERVER_ADDR"] | 65.254.54.98 |
| _SERVER["SERVER_ADMIN"] | webmaster@lyricsden.com |
| _SERVER["SERVER_NAME"] | lyricsden.com |
| _SERVER["SERVER_PORT"] | 80 |
| _SERVER["SERVER_PROTOCOL"] | HTTP/1.1 |
| _SERVER["SERVER_SIGNATURE"] | <ADDRESS>Apache/1.3.41 Server at lyricsden.com Port 80</ADDRESS> |
| _SERVER["SERVER_SOFTWARE"] | Apache/1.3.41 (Unix) mod_log_bytes/1.2 mod_bwlimited/1.4 mod_auth_passthrough/1.8 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.7a |
| _SERVER["UNIQUE_ID"] | SSdk3kH@NmIAAHmTmsE |
| _SERVER["PHP_SELF"] | /index.php |
| _SERVER["argv"] | Array
(
[0] => new_a=song2&path=/d/dandy-warhols/&song=Be-in.html;Featuring_Kia_Jefferies_Quot;_&album=Dandy_Warhols_Come_Down
)
|
| _SERVER["argc"] | 1 |
| _ENV["DOCUMENT_ROOT"] | /home/lyricsde/public_html |
| _ENV["GATEWAY_INTERFACE"] | CGI/1.1 |
| _ENV["HTTP_ACCEPT"] | Accept: application/xhtml+xml,text/html;q=0.9,text/plain; |
| _ENV["HTTP_ACCEPT_CHARSET"] | ISO-8859-1,utf-8;q=0.7,*;q=0.7 |
| _ENV["HTTP_ACCEPT_ENCODING"] | gzip |
| _ENV["HTTP_ACCEPT_LANGUAGE"] | en-us,en;q=0.5 |
| _ENV["HTTP_CACHE_CONTROL"] | no-cache |
| _ENV["HTTP_CONNECTION"] | close |
| _ENV["HTTP_HOST"] | lyricsden.com |
| _ENV["HTTP_PRAGMA"] | no-cache |
| _ENV["HTTP_USER_AGENT"] | CCBot/1.0 (+http://www.commoncrawl.org/bot.html) |
| _ENV["PATH"] | /bin:/usr/bin |
| _ENV["QUERY_STRING"] | new_a=song2&path=/d/dandy-warhols/&song=Be-in.html;Featuring_Kia_Jefferies_Quot;_&album=Dandy_Warhols_Come_Down |
| _ENV["REDIRECT_QUERY_STRING"] | new_a=song2&path=/d/dandy-warhols/&song=Be-in.html;Featuring_Kia_Jefferies_Quot;_&album=Dandy_Warhols_Come_Down |
| _ENV["REDIRECT_STATUS"] | 200 |
| _ENV["REDIRECT_UNIQUE_ID"] | SSdk3kH@NmIAAHmTmsE |
| _ENV["REDIRECT_URL"] | /d/dandy-warhols/Dandy_Warhols_Come_Down/Be-in.html;Featuring_Kia_Jefferies_Quot;_.html |
| _ENV["REMOTE_ADDR"] | 38.103.63.56 |
| _ENV["REMOTE_PORT"] | 45018 |
| _ENV["REQUEST_METHOD"] | GET |
| _ENV["REQUEST_URI"] | /d/dandy-warhols/Dandy_Warhols_Come_Down/Be-in.html;Featuring_Kia_Jefferies_Quot;_.html |
| _ENV["SCRIPT_FILENAME"] | /home/lyricsde/public_html/index.php |
| _ENV["SCRIPT_NAME"] | /index.php |
| _ENV["SERVER_ADDR"] | 65.254.54.98 |
| _ENV["SERVER_ADMIN"] | webmaster@lyricsden.com |
| _ENV["SERVER_NAME"] | lyricsden.com |
| _ENV["SERVER_PORT"] | 80 |
| _ENV["SERVER_PROTOCOL"] | HTTP/1.1 |
| _ENV["SERVER_SIGNATURE"] | <ADDRESS>Apache/1.3.41 Server at lyricsden.com Port 80</ADDRESS> |
| _ENV["SERVER_SOFTWARE"] | Apache/1.3.41 (Unix) mod_log_bytes/1.2 mod_bwlimited/1.4 mod_auth_passthrough/1.8 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.7a |
| _ENV["UNIQUE_ID"] | SSdk3kH@NmIAAHmTmsE |
|
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. |