Another question

[goodguy20k]

I'm doing a db insert into my MySQL db. When I perform the command, it actually works, but I receive this error message in the log:

Code: Select all

2006/01/23 19:47:21.159 - [ SEVERE ] [id: 11] (DbManager.executeCommand): DbManager error during command execution: INSERT INTO userid (id, usr, pwd, email, ip, power) VALUES ('', 'test', 'test', 'test', '0.0.0.0', '1')


Any ideas? Also:

Code: Select all

var success = dbase.executeCommand(sql);
trace(success);


Returns false. Huh? If it actually places things in the db, why does it return false.

I think I'll ignore this for now so I can keep programming, but if you figure this out, let me know so I can get rid of this error and keep going.

Thanks!

[Lapo]

Humm... I am just guessing...

try using this SQL instead:

INSERT INTO userid (usr, pwd, email, ip, power) VALUES ('test', 'test', 'test', '0.0.0.0', '1')

Let me know if it works

[goodguy20k]

That worked great, thanks! Is that a bug, or just something I missed?

[Lapo]

No it's not a bug. I think the problem is that you pass the id as an empty string. Since the id is an autoincrement number it is better not to include it in the INSERT command and just let the database create its value.