1 Topic by roo (edited by roo 2005-01-17 18:42)

  • roo
  • Member
  • Offline
  • Registered: 2004-11-11
  • Posts: 28

Topic: Trouble with 1.2dev to 1.2 update

I followed the instructions for updating to 1.2, changing yahoo and aim, adding the o_regs_report field to the config, ensuring the o_default_user_group was there and set to 4, I replaced all the php, and cleared the php scripts from the cache directory.

Yet, I get errors.  Well, one error right now, hopefully there won't be others behind it.  I enabled debug, and this is what I get:

Specifically:

File: /bb/include/functions.php
Line: 45

PunBB reported: Unable to fetch user information

Database reported: Unknown column 'o.idle' in 'field list' (Errno: 1054)

Any ideas on getting over this hump?

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Trouble with 1.2dev to 1.2 update

Well, the upgrade instructions I provided were to upgrade from the beta to final, not from the earlier dev versions. That particular error is because your online table lacks the field 'idle'. I recommend that you install a fresh 1.2 install and compare the structure of that database to your dev version. I can't remember if there were any other database changes.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

3 Reply by roo

  • roo
  • Member
  • Offline
  • Registered: 2004-11-11
  • Posts: 28

Re: Trouble with 1.2dev to 1.2 update

Well, I added online.idle as a TINYINT(1) and that got me through that one.

Now I've got a new one.

File: /home/pennypac/public_html/bb/viewforum.php
Line: 42

PunBB reported: Unable to fetch forum info

Database reported: Unknown column 'f.sort_by' in 'field list' (Errno: 1054)

I'll start poking around again.

4 Reply by roo

  • roo
  • Member
  • Offline
  • Registered: 2004-11-11
  • Posts: 28

Re: Trouble with 1.2dev to 1.2 update

Thanks for the reply.  If it's just database differences, I'll try to squash them as I go.