Escaped from IF @ last! Help required getting to PhpBB3 :(

This is an archive of the phpBB 2.0.x convertors forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
G0DSPEED
Registered User
Posts: 18
Joined: Tue Oct 07, 2008 3:50 pm

Escaped from IF @ last! Help required getting to PhpBB3 :(

Post by G0DSPEED »

Afternoon lads,

Well after what seemed eternity I have been supplied with a dump of my IF IPB 1.3 forum (200 users - 4000 ish posts)

There was of course only one choice of board software :D The host i've gone to has phpbb3 available on a fantastico install so I need to get from IPB 1.3 to that.

Unfortunately my knowledge in the myslq/php field is zero. I pressume by looking around these forums that the route I require is IPB1.3 > phpBB2 > phpBB3

I've installed wamp onto my laptop and followed the first part of the instructions here:

phpbb2 xp install

Plonked an unzipped phpbb2 directory into the www folder and run the phpbb2 startup page.

Here's where the first problems arise -
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'bb2admin'@'localhost' (using password: YES) in C:\wamp\www\phpBB2\db\mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in C:\wamp\www\phpBB2\db\mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in C:\wamp\www\phpBB2\db\mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database
Double checked everything that was entered at the myslq creation dos window, seems to add up, also selected myslq 4.x/5.x for the database type.

As mentioned this is all totally new to me so even a reply saying that the conversion process i'm attempting is correct would be appreciated.

My plan is obviously to get a phpbb2 forum onto my lappy - run the ipb converter and other python scripts from the crawlerconverters file i downloaded, save the database, then install phpbb3 and convert again.

Help! :lol:
G0DSPEED
Registered User
Posts: 18
Joined: Tue Oct 07, 2008 3:50 pm

Re: Escaped from IF @ last! Help required getting to PhpBB3 :(

Post by G0DSPEED »

Overcome the error I was getting that I quoted above - Now have phpbb2 installed and admin access :)

Now need to start the conversion process from IPB 1.3 upto phpbb2.
G0DSPEED
Registered User
Posts: 18
Joined: Tue Oct 07, 2008 3:50 pm

Re: Escaped from IF @ last! Help required getting to PhpBB3 :(

Post by G0DSPEED »

Appears the database .sql dump I have does'nt contain the 'tables'

Does anyone have a IPB v1.3 default 'tables' file that I can import into phpmyadmin??
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: Escaped from IF @ last! Help required getting to PhpBB3 :(

Post by D¡cky »

Have you hugged someone today?
G0DSPEED
Registered User
Posts: 18
Joined: Tue Oct 07, 2008 3:50 pm

Re: Escaped from IF @ last! Help required getting to PhpBB3 :(

Post by G0DSPEED »

D¡cky wrote:IPB database structure, http://dicky.askmaggymae.com/files/ibf_2_phpbb2.sql
Thanks for that Dicky.

So roughly now I've got the

.sql tables file
.sql data dump file

I've created a database in phpmyadmin and imported the table file which gives me 62 tables. Then imported the database.sql but i'm now getting the error that table 'ibf_stats' does'nt exist which by looking down the list of tables in phpmyadmin is true!

Difference in tables from v1.3 or 1.3.1?

And I thought it was going oh so well!
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: Escaped from IF @ last! Help required getting to PhpBB3 :(

Post by D¡cky »

When do you get the error that 'ibf_stats' doesn't exist? My convertor doesn't look for that table, so you really shouldn't need it.
Have you hugged someone today?
G0DSPEED
Registered User
Posts: 18
Joined: Tue Oct 07, 2008 3:50 pm

Re: Escaped from IF @ last! Help required getting to PhpBB3 :(

Post by G0DSPEED »

You'll have to excuse all my noobness concerning this whole process btw :)

I was under the impression I need to import the ipb tables and the old forum datadump into the phpbb database via phpmyadmin before letting the converter loose on it all.

I get the error message a little while into importing the datadump of the old board.

Here is the message I got from invisionfree concerning using the datadump (they are assuming i'm still going to be using v1.3 but just with another host)
Be sure you have a freshly installed IPB (v1.3.x) with the default mysql table prefix (ibf_).
Next empty the following tables on the fresh install (again make sure the install is using the prefix ibf_):
ibf_badwords
ibf_posts
ibf_calendar_events
ibf_categories
ibf_contacts
ibf_emoticons
ibf_forums
ibf_groups
ibf_members
ibf_messages
ibf_moderators
ibf_polls
ibf_stats
ibf_titles
ibf_topics
ibf_tracker
ibf_voters
ibf_cache_store
ibf_forum_perms
ibf_topic_mmod
ibf_validating;

or you can use these queries:
So it will be expecting a ibf_stats table.
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: Escaped from IF @ last! Help required getting to PhpBB3 :(

Post by D¡cky »

I am not sure where ibf_stats came from, whether it is from a different version or a modification, but as I said, ibf_stats is not needed for the conversion, so either remove it from the backup sql file or manually create the table so the data can be inserted.
Have you hugged someone today?
G0DSPEED
Registered User
Posts: 18
Joined: Tue Oct 07, 2008 3:50 pm

Re: Escaped from IF @ last! Help required getting to PhpBB3 :(

Post by G0DSPEED »

D¡cky wrote:so either remove it from the backup sql file or manually create the table so the data can be inserted.
I would if I could but feel my noobness and not having a clue might hinder me!

The converter I downloaded ready to use is ib2phpBB_1_3b btw, is that the correct one to use once I sort this stats error?

Cheers for your time in replying

G
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: Escaped from IF @ last! Help required getting to PhpBB3 :(

Post by D¡cky »

G0DSPEED wrote:
D¡cky wrote:so either remove it from the backup sql file or manually create the table so the data can be inserted.
I would if I could but feel my noobness and not having a clue might hinder me!
make a copy of your backup.sql file so you have a backup in case anything goes wrong.
Open the file with a text editor, but not Notepad
Find and remove the lines that start with INSERT INTO ibf_stats, or it may be INSERT IGNORE INTO ibf_stats
G0DSPEED wrote:The converter I downloaded ready to use is ib2phpBB_1_3b btw, is that the correct one to use once I sort this stats error?

Cheers for your time in replying

G
Yes, that is the correct convertor
Have you hugged someone today?
User avatar
ric323
Former Team Member
Posts: 22910
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: Escaped from IF @ last! Help required getting to PhpBB3 :(

Post by ric323 »

D¡cky wrote:...Open the file with a text editor, but not Notepad
...
@GODSPEED
Have a look here for suitable editors: Knowledge Base - Tools needed to set up and customise phpBB
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions
G0DSPEED
Registered User
Posts: 18
Joined: Tue Oct 07, 2008 3:50 pm

Re: Escaped from IF @ last! Help required getting to PhpBB3 :(

Post by G0DSPEED »

Ok deleted the relevant stats line from the database, loaded it up again but now have this error
MySQL said:

#1054 - Unknown column 'dmg' in 'field list'
????

searched through the file and this is the context of the line:
INSERT IGNORE INTO ibf_topics (tid, title, description, state, posts, starter_id, start_date, last_poster_id, last_post, icon_id, starter_name, last_poster_name, poll_state, last_vote, views, forum_id, approved, pinned, moved_to, dmg) VALUES ('1028','Help Needed','','open','
Obviously its not in full - just so you get the idea.

Thanks again for your input :)
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: Escaped from IF @ last! Help required getting to PhpBB3 :(

Post by D¡cky »

I don't know why your table structure is different, but, in any case, the easiest thing to do is add the field. Run this query in phpMyAdmin

Code: Select all

ALTER TABLE ibf_topics ADD dmg VARCHAR( 255 ) NULL
Have you hugged someone today?
G0DSPEED
Registered User
Posts: 18
Joined: Tue Oct 07, 2008 3:50 pm

Re: Escaped from IF @ last! Help required getting to PhpBB3 :(

Post by G0DSPEED »

I can see the 'query' option in phpmyadmin but can't grasp where to put the line you've posted.

I put it into the box 'SQL query on database' and submit query but get the error at the top 'You have to choose at least one column to display'

My apologies :roll:
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: Escaped from IF @ last! Help required getting to PhpBB3 :(

Post by D¡cky »

You have to click the SQL tab, not the Query tab.

Executing SQL Queries in phpMyAdmin
Have you hugged someone today?
Locked

Return to “[2.0.x] Convertors”