Add user error when domain data stored in MySQL

Please post here if you have problems in using Wing FTP Server.

Add user error when domain data stored in MySQL

Postby Gregry » Thu Apr 01, 2010 9:30 am

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.
Gregry
 
posts 7
 
joined Tue Mar 30, 2010 1:29 am

Re: Add user error when domain data stored in MySQL

Postby FTP » Thu Apr 01, 2010 9:37 am

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.
FTP
Site Admin
 
posts 1232
 
joined Tue Sep 29, 2009 6:09 am

Re: Add user error when domain data stored in MySQL

Postby Gregry » Fri Apr 02, 2010 12:52 am

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
Gregry
 
posts 7
 
joined Tue Mar 30, 2010 1:29 am

Re: Add user error when domain data stored in MySQL

Postby FTP » Fri Apr 02, 2010 3:36 am

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".
FTP
Site Admin
 
posts 1232
 
joined Tue Sep 29, 2009 6:09 am

Re: Add user error when domain data stored in MySQL

Postby Gregry » Sat Apr 03, 2010 12:59 am

I made it.
For the database name MUST BE "wftp_database", other name cannot work!
......
Gregry
 
posts 7
 
joined Tue Mar 30, 2010 1:29 am


Return to Support

Who is online

Users browsing this forum: No registered users and 4 guests