1 Topic by kalle11 (edited by kalle11 2009-04-21 02:51)

  • Registered: 2004-09-09
  • Posts: 84

Topic: Trouble with migrating database from 1.2 to 1.3.2

An error was encountered

--------------------------------------------------------------------------------

The error occurred on line 1357 in /home/customer/domain.org/public_html/punbb/include/functions.php

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

Very thankful for any solution

line 1357=     $result = $forum_db->query_build($query) or error(__FILE__, __LINE__);


EDIT: Altered topic subject //Slavok

  • Slavok
  • PunBB Developer
  • Offline
  • From: Russia
  • Registered: 2008-06-11
  • Posts: 1,238

Re: Trouble with migrating database from 1.2 to 1.3.2

What version of Forum do you use? What extensions have you got installed? What actions led to this error?

Slavok's Website

3 Reply by kalle11 (edited by kalle11 2009-04-21 07:46)

  • Registered: 2004-09-09
  • Posts: 84

Re: Trouble with migrating database from 1.2 to 1.3.2

Slavok wrote:

What version of Forum do you use? What extensions have you got installed? What actions led to this error?

punbb 1.32   no extentions installed

I tried to copy tables fram one database (where punbb 1.2 was) to another database.

4 Reply by KeyDog (edited by KeyDog 2009-04-21 08:28)

  • KeyDog
  • KeyDog
  • Global Moderator
  • Offline
  • Registered: 2008-12-12
  • Posts: 1,693

Re: Trouble with migrating database from 1.2 to 1.3.2

btw: topic title is a bit useless big_smile
"trouble migrating database/tables from 1.2 to 1.32" might be more appropriate

5 Reply by kalle11 (edited by kalle11 2009-04-21 11:39)

  • Registered: 2004-09-09
  • Posts: 84

Re: Trouble with migrating database from 1.2 to 1.3.2

ok
I have one database with 1.2 and another database with 1.33
what tables from 1.2 must I copy to the database with 1.33 to get all users, post eg.?

6 Reply by MattF

  • MattF
  • Senior Member
  • Offline
  • From: South Yorkshire, England
  • Registered: 2007-03-15
  • Posts: 1,956

Re: Trouble with migrating database from 1.2 to 1.3.2

You install 1.3* over the existing 1.2 installation. Hence the term upgrade. As always, make backups before doing anything.

MattF's Website

  • Registered: 2004-09-09
  • Posts: 84

Re: Trouble with migrating database from 1.2 to 1.3.2

MattF wrote:

You install 1.3* over the existing 1.2 installation. Hence the term upgrade. As always, make backups before doing anything.

I tried to do so now, but get this errror:
The error occurred on line 1518 in /home/domain.org/public_html/10/punbb/admin/install.php

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

  • Registered: 2004-09-09
  • Posts: 84

Re: Trouble with migrating database from 1.2 to 1.3.2

on my way.... I think anyway.... when I upgrade I get this text.

Unable to fetch guest information. The tabel 'punbbusers' must contain an entry with id = 1 that
represents anonymous users....

where in punbbusers do I write (and what) ?

  • Registered: 2004-09-09
  • Posts: 84

Re: Trouble with migrating database from 1.2 to 1.3.2

I give up... I have tried the most, cant get  1.3 with my old information from 1.2

10 Reply by Slavok

  • Slavok
  • PunBB Developer
  • Offline
  • From: Russia
  • Registered: 2008-06-11
  • Posts: 1,238

Re: Trouble with migrating database from 1.2 to 1.3.2

Follow these instructions:

  • Make a backup of your existing database.

  • Restore all forum tables in the new DB, which you want to use for 1.3.3.

  • In config.php of the installed forum replace the value of $db_name to the new DB for 1.3.3. Change $db_username and $db_password if needed.

  • Follow these instructions.

Report here the results of your attempt.

Slavok's Website