Page 1 of 1

Add user error when domain data stored in MySQL

Posted: Thu Apr 01, 2010 9:30 am
by Gregry
Version:3.3.5

When I connect MySQL successfully, I just add a new user, but failed, and logs for the domain said:

[01] Thu, 01 Apr 2010 17:18:10 Mysql database is closed.
[01] Thu, 01 Apr 2010 17:18:10 Mysql database connected successfully.
[10] Thu, 01 Apr 2010 17:18:38 Database query error: Column count doesn't match value count at row 1.

The database schema of MySQL is copied from system help: http://127.0.0.1:5466/help/english/index.html

I just checked database schema and MySQL status and so on, but no help. I dont know whether this is a bug.

Re: Add user error when domain data stored in MySQL

Posted: Thu Apr 01, 2010 9:37 am
by FTP
First, please upgrade to the latest version 3.4.2.
You needn't to create database schema by yourself, Wing FTP Server will create it aotumatically when configuring mysql connection setting.

Re: Add user error when domain data stored in MySQL

Posted: Fri Apr 02, 2010 12:52 am
by Gregry
Sorry, I upgraded version to 3.4.2, but nothing were changed.
It should be, but when I finished the MySQL information, NO tables were created and Logs still says:

[01] Fri, 02 Apr 2010 08:49:58 Mysql database connected successfully.
[01] Fri, 02 Apr 2010 08:49:58 Domain has been started.
[01] Fri, 02 Apr 2010 08:49:59 FTP server starts listening on port 4000. IP 127.0.0.1, *.*.*.*
[01] Fri, 02 Apr 2010 08:49:59 FTPS server starts listening on port 990. IP 127.0.0.1, *.*.*.*
[01] Fri, 02 Apr 2010 08:49:59 HTTP server starts listening on port 88. IP 127.0.0.1, *.*.*.*
[01] Fri, 02 Apr 2010 08:49:59 HTTPS server starts listening on port 443. IP 127.0.0.1, *.*.*.*
[01] Fri, 02 Apr 2010 08:49:59 SFTP(SSH) server starts listening on port 22. IP 127.0.0.1, *.*.*.*
[10] Fri, 02 Apr 2010 08:50:17 Database query error: Column count doesn't match value count at row 1.

(I replaced my true IP addr with *.*.*.*)

Row "Database query error...." occured when I submitted on add user by using MySQL

Re: Add user error when domain data stored in MySQL

Posted: Fri Apr 02, 2010 3:36 am
by FTP
Hi,

I have tested with Mysql database again, it seems no problem for adding user.

I suggest you delete the old database and table schemas, then just create a new database "wftp_database".

Then goto "Domain -> Settings -> Database Storage", select "mysql database", click on "OK".

Re: Add user error when domain data stored in MySQL

Posted: Sat Apr 03, 2010 12:59 am
by Gregry
I made it.
For the database name MUST BE "wftp_database", other name cannot work!
......