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

**URL:** <https://forum.virtualmin.com/t/i-dont-know-if-you-are-aware-of-this-problem/32059>\
**Category:** Virtualmin\
**Created:** [March 3, 2009, 12:32pm UTC](https://forum.virtualmin.com/t/i-dont-know-if-you-are-aware-of-this-problem/32059 "2009-03-03T12:32:39Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![system](https://cdn.forum.virtualmin.com/uploads/default/original/2X/c/cd96d761e326db4b2bef94886a639109bd7a8e76.svg) [@system](https://forum.virtualmin.com/u/system)\
**Post date:** [March 3, 2009, 12:32pm UTC](https://forum.virtualmin.com/t/i-dont-know-if-you-are-aware-of-this-problem/32059/1 "2009-03-03T12:32:39Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Eric](https://cdn.forum.virtualmin.com/letter_avatar_proxy/v4/letter/e/898d66/32.png) [@Eric](https://forum.virtualmin.com/u/Eric)\
**Post date:** [March 5, 2009, 6:42pm UTC](https://forum.virtualmin.com/t/i-dont-know-if-you-are-aware-of-this-problem/32059/2 "2009-03-05T18:42:01Z")

</div>

Yeah, you shouldn’t get SQL errors when using Virtualmin 🙂

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

Thanks!  
-Eric

---

<div class="post-metadata">

**Author:** ![Joe](https://cdn.forum.virtualmin.com/user_avatar/forum.virtualmin.com/joe/32/9_2.png) [@Joe](https://forum.virtualmin.com/u/Joe)\
**Post date:** [March 5, 2009, 7:05pm UTC](https://forum.virtualmin.com/t/i-dont-know-if-you-are-aware-of-this-problem/32059/3 "2009-03-05T19:05:19Z")

</div>

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).

---

<div class="post-metadata">

**Author:** ![system](https://cdn.forum.virtualmin.com/uploads/default/original/2X/c/cd96d761e326db4b2bef94886a639109bd7a8e76.svg) [@system](https://forum.virtualmin.com/u/system)\
**Post date:** [March 10, 2009, 12:27pm UTC](https://forum.virtualmin.com/t/i-dont-know-if-you-are-aware-of-this-problem/32059/4 "2009-03-10T12:27:15Z")

</div>

I have decided not to use it.

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

---

<div class="post-metadata">

**Author:** ![system](https://cdn.forum.virtualmin.com/uploads/default/original/2X/c/cd96d761e326db4b2bef94886a639109bd7a8e76.svg) [@system](https://forum.virtualmin.com/u/system)\
**Post date:** [April 30, 2020, 5:45am UTC](https://forum.virtualmin.com/t/i-dont-know-if-you-are-aware-of-this-problem/32059/5 "2020-04-30T05:45:25Z")

</div>

Closed on April 30, 2020, 5:45am UTC


