• Registered: 2005-07-30
  • Posts: 12

Topic: PunBB 1.1.7, BLOG:CMS Edition

Not so sure it is a bug.  I have Blog CMS installed along with PunBB 1.1.7 Blog CMS Edition.  Since Blog CMS went to requiring MySQL 4 I have been unable to upgrade as my hosts are using Mysql 3.23.17 and do not intend to upgrade at the moment.
I would however like to upgrade PuBB.  I downloaded 1.2.6, read the instal notes and downloaded 1.2 and followed the instructions to upgrade from 1.1.*.  When running the 11_to_12_update.php file I get the error message

"PunBB reported: Version mismatch. This script updates version 1.1 and 1.1.1 and 1.1.2 and 1.1.3 and 1.1.4 and 1.1.5 to version 1.2. The database 'euroauto' doesn't seem to be running a supported version."

Is there anyway I can upgrade my forums?

  • Gizzmo
  • Senior Member
  • Offline
  • From: Earth, Milkyway Galaxy
  • Registered: 2004-01-27
  • Posts: 762

Re: PunBB 1.1.7, BLOG:CMS Edition

how did you have punbb 1.1.7 installed, that version doesnt exist

3 Reply by hcgtv

  • hcgtv
  • hcgtv
  • Senior Member
  • Offline
  • From: Charlotte, NC
  • Registered: 2004-06-25
  • Posts: 1,991

Re: PunBB 1.1.7, BLOG:CMS Edition

PunBB 1.1.7 is a Radek special build.

I would wait for him to reply to your post at the Blog:CMS forum or upgrade to the latest Blog:CMS release that has PunBB 1.2.6 already.

PHPCrossRef . TXP Make . TXP Themes . TXP Tags . TXP Planet . We Love TXP

hcgtv's Website

  • Registered: 2005-07-30
  • Posts: 12

Re: PunBB 1.1.7, BLOG:CMS Edition

I can`t upgrade Blog CMS.  Every version since the one I have installed requires Mysql 4.  None of the webhosts I use have any plans to upgrade to Mysql 4.  They are all using Mysql  3.23.17.

  • Registered: 2005-07-30
  • Posts: 12

Re: PunBB 1.1.7, BLOG:CMS Edition

Ok simply went to the mysql table and changed the version number according to Radek.

Ok.  i tried that and get the following when running the upgrade script to update to punbb1.2

File: /home/www/euroauto/forum/11_to_12_update.php
Line: 127

PunBB reported: Unable to create table forum_perms. Please check MySQL permissions and try again.

Database reported: Table 'forum_perms' already exists (Errno: 1050)

  • Registered: 2005-07-30
  • Posts: 12

Re: PunBB 1.1.7, BLOG:CMS Edition

I`m still having trouble with this.  I have tested installing the latest Blog CMS and punbb on a server with mysql 3.23.56 and it works ok but I still cannot get punbb1.1.7 converted.  If I change the config table "version" from 1.1.7 to anything else like 1.1 or 1.1.5 and run the upgrade script to upgrade to 1.2 i still get the same error message saying that the script can only convert punbb 1.1, 1.5 etc

any ideas?

7 Reply by Paul

  • Paul
  • Senior Member
  • Offline
  • From: Wales, UK.
  • Registered: 2003-08-13
  • Posts: 3,089

Re: PunBB 1.1.7, BLOG:CMS Edition

Your problem seems to be that the odd version of PunBB you are running has tables which were only added to the official version in v1.2. When the updater finds them it cannot create the new tables because they already exist when they shouldn't. For example, the table "forum_perms" doesn't exist in v1.1.5 but it does in v1.2. Whoever wrote your version of PunBB either added his own features or jumped the gun a bit and added features from the beta version of 1.2.

8 Reply by Aughavey (edited by Aughavey 2005-10-05 00:40)

  • Registered: 2005-07-30
  • Posts: 12

Re: PunBB 1.1.7, BLOG:CMS Edition

thanks for the reply

bans               
categories      
censoring      
config
forums   
posts      
ranks      
reports      
search_matches      
search_results      
search_words      
subscriptions      
topics      
users

these seem to be the tables i have in the database regarding pubbb 1.1.7
the forum perms must have been from the test install of newer version
i started from scratch again with 1.1.7 installed the upgrade script says it cannot upgrade my version only 1.1, 1.5 etc even if i rename the version in the config table and delete the contents of cache directory.

any suggestions?

are there any conversion tools to say phpbb which i could try and then convert back to punbb2?

9 Reply by Paul

  • Paul
  • Senior Member
  • Offline
  • From: Wales, UK.
  • Registered: 2003-08-13
  • Posts: 3,089

Re: PunBB 1.1.7, BLOG:CMS Edition

If you open the update script in your text editor you will see the first line is a list of supported versions. You could just try adding 1.1.7 to the list.

  • Registered: 2005-07-30
  • Posts: 12

Re: PunBB 1.1.7, BLOG:CMS Edition

Ok...I seem to have the forum_perm table in my sql dump.
Deleted that changed the first line of the upgrade script and ran it and got the following error:

File: /home/www/ulterDfi/forum/11_to_12_update.php
Line: 185

PunBB reported: Unable to alter DB structure.

Database reported: Duplicate column name 'language' (Errno: 1060)


So I started from scratch again but deleted line 185 of the upgrade script and so far it seems to have worked.