*

Author Topic: [bug SMF] Install error v2.22  (Read 12268 times)

Offline SgtMic

  • Moderator
  • Sr. Member
  • *
  • Posts: 343
  • Ummmmm, OK?
[bug SMF] Install error v2.22
« on: March 20, 2008, 11:57:06 PM »
SMF or Treasury error?

I get this error after installing:

Database Error
Unknown column 'group_id' in 'field list'
File: /home/fastsqua/public_html/forum/Packages/temp/install.php
Line: 320

Initiated by Bugger (Original Entry) - Comments Here Please.
« Last Edit: March 22, 2008, 03:03:54 PM by Resourcez »
There is nothing deadlier than a US Marine and his rifle.
A close second is a US Marine and his K-BAR.

Offline Resourcez

  • Administrator
  • Hero Member
  • *
  • Posts: 1425
    • Resourcez
Re: Install error
« Reply #1 on: March 21, 2008, 12:30:17 AM »
hmm, I'm assuming SMF2 and v2.22

SMF 2 beta3 public?
Fresh install of both?

I'm not sure that it will fix that but I've fixed some more functions that SMF changed in the beta3 public version - download 2.22 again and see if that changes anything?
« Last Edit: March 21, 2008, 02:11:25 AM by Resourcez »
If you have everything under control, you're not moving fast enough.
• Apache 2.2.24 • PHP 5.3.24 • MySQL 5.1.68 •

Offline SgtMic

  • Moderator
  • Sr. Member
  • *
  • Posts: 343
  • Ummmmm, OK?
Re: Install error
« Reply #2 on: March 21, 2008, 05:02:33 AM »
SMF 2 beta3 and v2.22
I just downloaded v2.22 last night.

Both were installed onto current forum.

I could do a vanilla install and try it on that.
There is nothing deadlier than a US Marine and his rifle.
A close second is a US Marine and his K-BAR.

Offline Resourcez

  • Administrator
  • Hero Member
  • *
  • Posts: 1425
    • Resourcez
Re: Install error
« Reply #3 on: March 21, 2008, 10:07:27 AM »
Okay, but what was the "current" forum?

If "current" was 1.1.4 and Treasury > 2.05 then I can understand a problem occurring, as v2.22 simply doesn't cater for more advanced versions.
If you have everything under control, you're not moving fast enough.
• Apache 2.2.24 • PHP 5.3.24 • MySQL 5.1.68 •

Offline SgtMic

  • Moderator
  • Sr. Member
  • *
  • Posts: 343
  • Ummmmm, OK?
Re: Install error
« Reply #4 on: March 21, 2008, 02:23:15 PM »
The forum was 2.0 beta 2 upgraded from 1.1.4.
Treasury was the the 1st release for smf 2.0.
There is nothing deadlier than a US Marine and his rifle.
A close second is a US Marine and his K-BAR.

Offline SgtMic

  • Moderator
  • Sr. Member
  • *
  • Posts: 343
  • Ummmmm, OK?
Re: Install error
« Reply #5 on: March 21, 2008, 02:37:32 PM »
Installed 2.22 on a vanilla install of 2.0 beta 3.

No errors at all. So that's not an issue.

There is nothing deadlier than a US Marine and his rifle.
A close second is a US Marine and his K-BAR.

Offline SgtMic

  • Moderator
  • Sr. Member
  • *
  • Posts: 343
  • Ummmmm, OK?
Re: Install error
« Reply #6 on: March 21, 2008, 02:43:46 PM »
Looking at the forum database, I see these:

smf_smf_treas_config          
smf_smf_treas_donations    
smf_smf_treas_registry    
smf_smf_treas_targets


smf_treas_config          
smf_treas_donations    
smf_treas_registry    
smf_treas_targets

I remember seeing something in the bugger about smf_smf.
There is nothing deadlier than a US Marine and his rifle.
A close second is a US Marine and his K-BAR.

Offline Resourcez

  • Administrator
  • Hero Member
  • *
  • Posts: 1425
    • Resourcez
Re: Install error
« Reply #7 on: March 21, 2008, 02:48:06 PM »
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.
« Last Edit: March 21, 2008, 02:49:50 PM by Resourcez »
If you have everything under control, you're not moving fast enough.
• Apache 2.2.24 • PHP 5.3.24 • MySQL 5.1.68 •

Offline Resourcez

  • Administrator
  • Hero Member
  • *
  • Posts: 1425
    • Resourcez
Re: Install error
« Reply #8 on: March 21, 2008, 09:04:36 PM »
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.
« Last Edit: March 21, 2008, 09:58:36 PM by Resourcez »
If you have everything under control, you're not moving fast enough.
• Apache 2.2.24 • PHP 5.3.24 • MySQL 5.1.68 •

Offline SgtMic

  • Moderator
  • Sr. Member
  • *
  • Posts: 343
  • Ummmmm, OK?
Re: Install error
« Reply #9 on: March 22, 2008, 12:31:31 AM »
I'll do it manually.
Hopefully SMF will get their part squared away. Soon.
There is nothing deadlier than a US Marine and his rifle.
A close second is a US Marine and his K-BAR.

Offline Resourcez

  • Administrator
  • Hero Member
  • *
  • Posts: 1425
    • Resourcez
Re: Install error
« Reply #10 on: March 22, 2008, 01:02:04 AM »
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 :)
If you have everything under control, you're not moving fast enough.
• Apache 2.2.24 • PHP 5.3.24 • MySQL 5.1.68 •

Offline SgtMic

  • Moderator
  • Sr. Member
  • *
  • Posts: 343
  • Ummmmm, OK?
Re: Install error v2.22 (SMF bug)
« Reply #11 on: March 22, 2008, 01:12:59 AM »
Does the group_id field need to be anywhere specific in the table? Or just inserted at the end?
There is nothing deadlier than a US Marine and his rifle.
A close second is a US Marine and his K-BAR.

Offline Resourcez

  • Administrator
  • Hero Member
  • *
  • Posts: 1425
    • Resourcez
Re: Install error v2.22 (SMF bug)
« Reply #12 on: March 22, 2008, 01:25:34 AM »
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.
If you have everything under control, you're not moving fast enough.
• Apache 2.2.24 • PHP 5.3.24 • MySQL 5.1.68 •

Offline SgtMic

  • Moderator
  • Sr. Member
  • *
  • Posts: 343
  • Ummmmm, OK?
Re: Install error v2.22 (SMF bug)
« Reply #13 on: March 22, 2008, 03:22:56 AM »
Manually added the field and all is well.  :)


Just for reference, here was the error from the log:

Database Error: Unknown column 'group_id' in 'field list'


INSERT IGNORE INTO smf_treas_donations(id, user_id, business, txn_id, item_name, item_number, quantity, invoice, custom, tax, option_name1, option_seleczion1, option_name2, option_seleczion2, memo, payment_status, payment_date, txn_type, mc_gross, mc_fee, mc_currency, settle_amount, exchange_rate, first_name, last_name, address_street, address_city, address_state, address_zip, address_country, address_status, payer_email, payer_status, currency_symbol, group_id)
VALUES
(1, 1, 'wildman@mail.com', '88P702274X5188615', 'Donation', '222', '', '', 'Resourcez', '', '', 'Yes', '', '', '', 'Completed', 1195406212, 'web_accept', '2.00', '0.36', 'USD', '2.00', '1.00', '', '', '', '', '', '', '', '', '', '', '$', 0),
(2, 1, 'wildman@mail.com', '88P702274X5188616', 'Donation', '222', '', '', 'Resourcez', '', '', 'No', '', '', '', 'Completed', 1195406213, 'web_accept', '2.00', '0.36', 'USD', '2.00', '1.00', '', '', '', '', '', '', '', '', '', '', '$', 0),
(3, 1, 'wildman@mail.com', '88P702274X5188617', 'Donation', '222', '', '', 'Resourcez', '', '', 'Yes', '', '', '', 'Completed', 1195406214, 'web_accept', '2.00', '0.36', 'USD', '2.00', '1.00', '', '', '', '', '', '', '', '', '', '', '$', 0)
Apply Filter: Only show the errors from this file
File: /home/fastsqua/public_html/forum/Packages/temp/install.php
Line: 320
« Last Edit: March 23, 2008, 01:44:18 AM by SgtMic »
There is nothing deadlier than a US Marine and his rifle.
A close second is a US Marine and his K-BAR.

 

Please Support Us!

Something for Here
Donate with PayPal!
August Goal: $40.00
Due Date: Aug 31
Total Receipts: $0.00
Below Goal: $40.00
Site Currency: USD
 0%

Content