Add user error when domain data stored in MySQL

Please post here if you have problems in using Wing FTP Server.
Post Reply
Gregry
Posts: 7
Joined: Tue Mar 30, 2010 1:29 am

Add user error when domain data stored in MySQL

Post 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.
FTP
Site Admin
Posts: 2072
Joined: Tue Sep 29, 2009 6:09 am

Re: Add user error when domain data stored in MySQL

Post 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.
Gregry
Posts: 7
Joined: Tue Mar 30, 2010 1:29 am

Re: Add user error when domain data stored in MySQL

Post 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
FTP
Site Admin
Posts: 2072
Joined: Tue Sep 29, 2009 6:09 am

Re: Add user error when domain data stored in MySQL

Post 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".
Gregry
Posts: 7
Joined: Tue Mar 30, 2010 1:29 am

Re: Add user error when domain data stored in MySQL

Post by Gregry »

I made it.
For the database name MUST BE "wftp_database", other name cannot work!
......
Post Reply