View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000177 | HTML & PERL | Bug Report - Database | public | 2005-05-14 17:47 | 2006-01-16 16:12 |
| Reporter | petriw | Assigned To | exp | ||
| Priority | normal | Severity | crash | Reproducibility | have not tried |
| Status | resolved | Resolution | fixed | ||
| Summary | 0000177: Using ignore on all group select boxes causes null in database. | ||||
| Description | http://anidb.info/perl-bin/animedb.pl?show=creq&do.showhist=1&creq.id=139848 This breaks aom and it's now also crept into the dump files, please recreate. Suggested solution: Set gid column to NOT NULL. Set gid column to default 0. ^^; | ||||
| Tags | No tags attached. | ||||
|
|
this seems to become a daily problem. 3 times in 2 weeks. considering the update is 3 times per week that means 50%. quite a bad value.... |
|
|
was this the problem for aom not starting around 22.7.05? if yes then this should be fixed as soon as possibe. |
|
|
Oh dear, I thought that ignore in all group fields was the normal way to add a `no group' file... |
|
|
it seems like it happened again ... *bump* |
|
|
could anyone check if this does still happen? |
|
|
right now aom is working (the latest release) so it seems like it's fixed (in case there's still a corrupted entry in the db. if there isn't then there's no way how i could check if it still breaks aom ^^ ) thanx a lot |
|
|
This bug doesn't affect aom anymore and hasn't for quite a while. So you can't use aom to test it. |
|
|
Can someone not run a query on the file table to see if there are any nulls in group? Should be trivial task for either exp or petri. |
|
|
SELECT id FROM filetb WHERE gid IS NULL; id ---- (0 rows) I already checked that before, what I was interested in is if it is possible to produce new entries with gid NULL atm. |
|
|
Ah. 'no' then, not via the normal interface. I can *try* and sneak a null in, if you like :D |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2005-05-14 17:47 | petriw | New Issue | |
| 2005-05-17 22:31 | DerIdiot | Note Added: 0000465 | |
| 2005-07-25 20:38 | Tomynocker | Note Added: 0000622 | |
| 2005-07-25 21:58 | pelican | Note Added: 0000629 | |
| 2005-07-28 00:25 | Tomynocker | Note Added: 0000641 | |
| 2005-08-14 13:42 | exp | Note Added: 0000647 | |
| 2005-08-16 21:46 | Tomynocker | Note Added: 0000650 | |
| 2005-08-16 21:47 | Tomynocker | Note Edited: 0000650 | |
| 2005-08-16 21:48 | Tomynocker | Note Edited: 0000650 | |
| 2005-08-17 06:28 | petriw | Note Added: 0000651 | |
| 2005-08-18 16:00 | Rar | Note Added: 0000652 | |
| 2005-08-21 09:50 | exp | Note Added: 0000658 | |
| 2005-08-22 02:15 | Rar | Note Added: 0000663 | |
| 2006-01-16 11:42 | DerIdiot | Status | new => resolved |
| 2006-01-16 11:42 | DerIdiot | Resolution | open => fixed |
| 2006-01-16 11:42 | DerIdiot | Assigned To | => DerIdiot |
| 2006-01-16 16:12 | DerIdiot | Assigned To | DerIdiot => exp |
