This website is deprecated, and remains online only for historic access to old issues and docs for historic versions of Virtualmin. It has been unmaintained for several years, and should not be relied on for up-to-date information. Please visit www.virtualmin.com instead.

I don't know if you are aware of this problem ...

4 posts / 0 new

Topic locked

Last post

#1 Tue, 03/03/2009 - 06:32

Anonymous

I don't know if you are aware of this problem ...

Using the Edit Databases facility:

When trying to edit a table field length I always get this error:

Failed to save field : SQL alter table adverts modify caption varchar(200) not null default none failed : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'none' at line 1

#2 Thu, 03/05/2009 - 12:42

andreychek

Yeah, you shouldn't get SQL errors when using Virtualmin :-)

I'd go ahead and file a bug report regarding that.

Thanks!
-Eric

#3 Thu, 03/05/2009 - 13:05 (Reply to #2)

Joe

It's possible to do things in the fields that could trigger SQL errors (Webmin doesn't do SQL syntax or type checking, and leaves it up to the database to do so)...so it's not impossible to get SQL errors when using the module (and it wouldn't indicate a bug in many cases). But, in this case, it does sound like a bug worth filing.

Note also that if you have the Perl MySQL module installed, the robustness and performance of Webmin's MySQL module is usually better (though it also occasionally has had its own bugs).

--

Check out the forum guidelines!

#4 Tue, 03/10/2009 - 07:27

Davvit

I have decided not to use it.

I will just write little php scripts to modify my database if I need to.

Topic locked