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.
Add user error when domain data stored in MySQL
-
- Posts: 7
- Joined: Tue Mar 30, 2010 1:29 am
-
- Site Admin
- Posts: 2084
- Joined: Tue Sep 29, 2009 6:09 am
Re: Add user error when domain data stored in MySQL
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.
You needn't to create database schema by yourself, Wing FTP Server will create it aotumatically when configuring mysql connection setting.
-
- Posts: 7
- Joined: Tue Mar 30, 2010 1:29 am
Re: Add user error when domain data stored in MySQL
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
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
-
- Site Admin
- Posts: 2084
- Joined: Tue Sep 29, 2009 6:09 am
Re: Add user error when domain data stored in MySQL
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".
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".
-
- Posts: 7
- Joined: Tue Mar 30, 2010 1:29 am
Re: Add user error when domain data stored in MySQL
I made it.
For the database name MUST BE "wftp_database", other name cannot work!
......
For the database name MUST BE "wftp_database", other name cannot work!
......