I cant login to admin

[ador]

Please help, cant login to my zencart admin.

The store is working, customers can login. but no admins can login. i get this message;
2013 Lost connection to MySQL server during query
in:
[select * from coupon_gv_queue where release_flag='N']

Nothing was changed or messed with that i know of. one day it was working- next day it stopped.

Any help with this is appreciated

Ador

[TheOracle]

Which version of:

Zen-Cart
PHP
mySQL

are you currently using ?

[Kim]

Is the catalog side of the shop working?

[ador]

Which version of:

Zen-Cart
PHP
mySQL

are you currently using ?

thank you,
i am at zen cart Version 1.3.0.2
php 4.1.22-standard

I do not know my sql version , i am sure it is pretty recent. i will try and get that asap.
I am sorry i did not include this info to start with.
Thanks,
Ador

[ador]

Is the catalog side of the shop working?

Yes it is. the catalog store is working, users can login. it is just the admin login, cant login get that same error each time.

thank you,
Ador

[TheOracle]

I do not know my sql version , i am sure it is pretty recent.

A good way to start with be by uploading your zc_install/techsupp.php file into a random folder on your server and execute it. From there, all the related infos should be output for you. Once finished with it, remove the file and folder from your server for your own safety.

All you need to do is to paste them here before the next step.

[ador]

thans, hers what i got, i could not post all of it, was too large, i hope this has the right info;

* MySQL Version Reported =
* PHP MySQL Support = ON
* PHP PostGres SQL Support = ON

PHP Info

* PHP version: 4.4.6
* PHP API version= apache
* PHP Safe Mode= OFF
* PHP Register Globals = OFF
* PHP set_time_limit (max execution time) = 240
* PHP Disabled Functions = dl,system,exec,passthru,shell_exec
* PHP open_basedir =
* PHP Sessions Support = ON
* PHP session.auto_start = OFF
* PHP session.use_trans_sid = OFF
* PHP session.save_path = /tmp
* PHP Magic_Quotes_Runtime = OFF
* PHP Output Buffering (gzip) = OFF
* PHP GD Support = ON
* PHP ZLIB Support = ON
* PHP OpenSSL Support = ON
* PHP CURL Support = ON
* PHP File Uploads = ON
* PHP File Upload Max Size = 10M
* PHP Post Max Size = 8M
* PHP File Upload TMP Dir = /tmp
* PHP XML Support = ON
* PHP FTP Support = ON
* PHP PFPRO Support = OFF
* PHP Sendmail_FROM =
* PHP Sendmail_PATH = /usr/sbin/sendmail -t -i
* PHP SMTP Settings = localhost
* PHP include_path = .:/hsphere/shared/apache/libexec/php4ext/php/


mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 4.1.15
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient

Directive Local Value Master Value
mysql.allow_persistent Off Off
mysql.connect_timeout 60 60
mysql.default_host localhost localhost
mysql.default_password no value no value
mysql.default_port 3306 3306
mysql.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off

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 On On
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 dl,system,exec,passthru,shell_exec dl,system,exec,passthru,shell_exec
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 /hsphere/local/var/httpd/logs/php_error.log /hsphere/local/var/httpd/logs/php_error.log
error_prepend_string no value no value
error_reporting 2039 2039
expose_php Off Off
extension_dir /hsphere/shared/apache/libexec/php4ext/ /hsphere/shared/apache/libexec/php4ext/
file_uploads On On
gpc_order GPC GPC
highlight.bg #FFFFFF #FFFFFF
highlight.comment #FF9900 #FF9900
highlight.default #0000BB #0000BB
highlight.html #000000 #000000
highlight.keyword #007700 #007700
highlight.string #DD0000 #DD0000
html_errors Off Off
ignore_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off
include_path .:/hsphere/shared/apache/libexec/php4ext/php/ .:/hsphere/shared/apache/libexec/php4ext/php/
log_errors On On
log_errors_max_len 1024 1024
magic_quotes_gpc Off On
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
max_execution_time 240 240
max_input_time 240 240
memory_limit 33554432b 64M
open_basedir no value no value
output_buffering no value no value
output_handler no value no value
post_max_size 8M 64M
precision 12 12
register_argc_argv On On
register_globals Off Off
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 On On
unserialize_callback_func no value no value
upload_max_filesize 10M 64M
upload_tmp_dir /tmp /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 Optimizer
Optimization Pass 1 enabled
Optimization Pass 2 enabled
Optimization Pass 3 enabled
Optimization Pass 4 enabled
Optimization Pass 9 enabled
Zend Loader enabled

[TheOracle]

Client API version 4.1.15

Looks like this one.

The definite solution here would be to upgrade Zen-Cart to the latest version. Several bug fixes are included.

In the mean time, I would suggest to clear out your SQL sessions table (if using it). Also to clear out your session cache from FTP. Then, close your browser (clear cookies, temp files and history). Re-load your admin section. Will it work ?

[ador]

hi!
i had some appointments today, i really appreciate all of your help with my issue.
heres; whats going on with my site. i flushed and dumped all my cookies, and flushed sessions and still could not log in to my admin.
So i started the upgrade today. i installed a clean install of the latest zen cart, with a fresh database into another directory. and I can not log in to that one either. it seemed like it wanted to log me in, and then gave me the exact same error about the coupon uque flag= n .

could this mean its with my sql server afterall
thanks,
Ador