just don't have BDB
support compiled in. If you do a "show table status" you'll see that the
tables you just created with type=bdb actually are MyISAM or ISAM.
--
Tomi Junnila [EMAIL PROTECTED]
http://www.badzilla.net/~topeju/
Electronics and Information Technology,
Universi
raded from a 3.22.x version? When was not a
reserved word in 3.22, but is so in 3.23. There have been a few hints how to
both circumvent and fix this in 3.23, just search the archives. The thread
was called something like "3.22 databases in 3.23 cause problems with fields
named 'when'".
--
ll to make sure you get a proper handle, and if not, just don't try to
do anything else with mysql (or prefix all of them with @, which isn't
probably a very good idea for debugging).
--
Tomi Junnila [EMAIL PROTECTED]
http://www.badzilla.net/~topeju/
Electronics and Information Technology,
"when" with something else, and finally drop the table and run the
text file into mysql.
Another way to do this might be with "create table temporary_table ({fields
valid in 3.23}) select {fields from old table with aliases} from old_table"
but I haven't tried this myself.
--
inserted into the same
table, but this insert was rolled back so the record should not be
there.
Fix:
Not known.
Submitter-Id: submitter ID
Originator:
Organization:
Tomi Junnila [EMAIL PROTECTED]
http://www.badzilla.net/~topeju/
Electronics and Information
wledgeable people (I can't remember that offhand and
I do need to go and eat now).
--
Tomi Junnila [EMAIL PROTECTED]
http://www.badzilla.net/~topeju/
Electronics and Information Technology,
University of Turku, Finland
-
Befo
e most efficient way would be to rethink your table format to
have positive ratings as +1, neutrals as 0, and negatives as -1. Then you
could simply sum them all up without needing to subtract anything.
--
Tomi Junnila [EMAIL PROTECTED]
http://www.badzilla.net/~topeju/
Electronics and In
table status; # Ensure it actually is BDB
set autocommit=0;
begin;
insert into tt (id) values (55);
rollback;
select * from tt; # Earlier this didn't result in anything, nowadays it does
# have the row id=55
--
Tomi Junnila [EMAIL PROTECTED]
http://www.badzilla.net/~topeju