#299 Update error
Hello,
With the MySQL module if you have a large number
for "Number of rows to display per page" in
the "Module Config" section (i.e. 200), updates made
to the table fail when there are in fact many output
rows. For example, if you have a table with 1000 rows
and you have "Number of rows to display per page" set
to 200 and click on the table details link and then
click "View Data," you have the option to check the
checkbox pertaining to any number of rows and then
click "Edit selected rows." When you do this, the
table renders again only with form text fields for the
rows that were selected to be edited. When you make
your edits and click "Save," the changes are not
committed to the database. This is happening in
Webmin 0.91. The changes made to the MySQL module in
0.92 do not seem to address this issue according to
the notes on the www.webmin.com site in the upgrades
section.
Logged In: YES
user_id=129364
Does this still happen if you only select a few rows
at a time for editing? I just tried edting 24 rows of a
large table at once, with no problems.
Also, which web browser are you using?
Logged In: NO
My browser was IE 5.5 at the time.
Logged In: YES
user_id=129364
Do you have DBI and DBD::mysql installed on this system?
If so, and if you are running webmin 0.92, the module will
make use of them to query/update the database. Otherwise
it tries to run the mysql client programs and parse their
output, which will fail when you have complex multi-line
data in your tables.