76 Reply by MattF

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

Re: Feedback on the update process

TYPE is only relevant to the column, however. I think that mismatch in documentation is just due to documentation becoming more indepth. But saying that, I don't still run a 7.* DB, so can't attest to it with all certainty. smile (Unless I get one installed to test). big_smile

MattF's Website

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Feedback on the update process

http://www.postgresql.org/about/news.277

ALTER TABLE can alter the data type of an existing column

That's the release notes for 8.0.0. wink

78 Reply by MattF

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

Re: Feedback on the update process

My apologies then. smile

MattF's Website

79 Reply by chali

  • From: Buenos Aires
  • Registered: 2006-01-20
  • Posts: 32

Re: Feedback on the update process

Hi smile

I'm testing the new 1.3RC version to get in shape for the update when the final version comes out.

I ran into this error:

Converting search word 30372 …
Converting search word 30373 …
An error was encountered

The error occurred on line 1073 in /home/chali/public_html/new_punbb/db_update.php

Database reported: Duplicate entry '¡¡¡¡¡¡¡¡¡¡' for key 1 (Errno: 1062).

Additional information:

- Mi forum is in spanish.
- With around 472385 posts
- URL: http://smashingpumpkins.com.ar/board/index.php

And I'm updating a copy of course.

I have some PHP knowledge and I'd ve glad to help in any debbuging.

Thanks

chali's Website

  • From: Russia
  • Registered: 2007-12-13
  • Posts: 642

Re: Feedback on the update process

chali wrote:

The error occurred on line 1073 in /home/chali/public_html/new_punbb/db_update.php

Database reported: Duplicate entry '¡¡¡¡¡¡¡¡¡¡' for key 1 (Errno: 1062).

Quick fix is altering 'UPDATE ' to 'UPDATE IGNORE '. Though I'm not sure it is completely safe.
Anyway, you can reindex forum after update.

We've reproduced this issue and will think of correct db_update.php fix.

Carpe diem

Anatoly's Website

81 Reply by chali

  • From: Buenos Aires
  • Registered: 2006-01-20
  • Posts: 32

Re: Feedback on the update process

I truncated the search index cache tables and everything went fine smile (and fast! for a 500k posts forum).
Looking forward for the final release!
Thanks Anatoly

chali's Website

  • Registered: 2010-02-09
  • Posts: 1

Re: Feedback on the update process

Good evening everybody,

this night we update our forum software from version 1.2.14 tot the newest version. We have do already this:

1. Upgrade from 1.2.14 --> 1.2.15
2. Upgrade from 1.2.15 --> 1.2.16
3. Upgrade from 1.2.16 --> 1.2.17
4. Upgrade from 1.2.17 --> 1.2.18
5. Upgrade from 1.2.18 --> 1.2.19
6. Upgrade from 1.2.19 --> 1.2.20

The next step what we have do is install version 3.0 release candidate. And we have used the update script from: db_update.php. Our forum haves 1.000.000 messages. The update URL said this:

http://localhost:8888/punbb/db_update.php?stage=conv_posts&req_old_charset=UTF-8%20UNICODE&req_per_page=300&start_at=1814101

What is the problem?  The forum don't have 1.814.101 messages lol ;-)

Kind regards, Diederik

Excuse me for my very bad english ;-)