The double smf prefix arises coz the SMF people made a significant change between beta 2.1 and beta 3, and that has since been addressed in the latest v2.22.

I'm not sure how you ended up with the missing group_id field, but the actual v2.22 there now is supposed to add any old missing field.

I would delete the smf_smf_ tables - they won't do anything, but just check your content in the smf_ tables is okay before doing that.

Resourcez Mar 21, 2008 21:04:36

Try as I may, I now believe that SMF 2 b3p has a bug - the db create function simply does not work as it is supposed to work, and does not "update" tables correctly for an extra field.

In fact it comes undone with the double prefix every time, which means they have screwed something in the code.

I've found the bug and the fix in their code and reported it, but it means there is no point in providing a Treasury release until the next SMF release.

In the interim, you could just add the group_id field to the smf_treas_donations table - it is smallint, size 5, not null default 0.

SgtMic Mar 22, 2008 00:31:31

I'll do it manually. Hopefully SMF will get their part squared away. Soon.

Resourcez Mar 22, 2008 01:02:04

We'll just have to wait for the next release and hope like hell they don't change the db abstraction layer yet again coz I'm getting damned sick of trouble shooting it with each round of changes.

I could bypass it but I don't want to start adding little bits here and there to compensate for what should work out of the box

The good news is that, when you fix the offending SMF file, it works quite nicely

SgtMic Mar 22, 2008 01:12:59

Does the group_id field need to be anywhere specific in the table? Or just inserted at the end?

Resourcez Mar 22, 2008 01:25:34

Anywhere will do - it actually happens to be the last, but order doesn't matter since I allocate data updates to specific fields.

The field is actually for events but I already had it in place for another purpose and wasn't using it, so its name isn't strictly correct for its application. When SMF eventually settles down, I'll rename it something more appropriate.