Cyprus-Forum.com

[Hazza]

Does anyone have any knowlege of PHP and SQL?

I've been trying to convert an invisionboard 1.3.1 to phpbb but have been unsuccessful. Can anybody help me out on this one please?

[demetriou_74]

love to help but i have no idea what anyof that means

[cannedmoose]

Does anyone have any knowlege of PHP and SQL?

I've been trying to convert an invisionboard 1.3.1 to phpbb but have been unsuccessful. Can anybody help me out on this one please?

It's all Greek to me...

[metecyp]

I've been trying to convert an invisionboard 1.3.1 to phpbb but have been unsuccessful. Can anybody help me out on this one please?

Can you explain what specific problems you're having? I might be able to help.

[Hazza]

I've been trying to convert an invisionboard 1.3.1 to phpbb but have been unsuccessful. Can anybody help me out on this one please?

Can you explain what specific problems you're having? I might be able to help.

I'll start by saying I tried doing this live online, so thats probably a start of where things went cookoo for me.

I installed a fresh phpBB on the server and for database username and password, I entered the details from IPB, deleted the Install and Contrib folders and uploaded the convertor to the phpBB root.

I followed the instructions in the read me, then ran the ib2phpBB/index.php

Stage 1. phpBB config.php file has been found
MySQL Connection OK
Tests passed - Let's go for the conversion

Stage 2:

Code: Select all

Unable to delete guest user into members table
1146: Table 'schoolb_sbnet.sbnet_members' doesn't exist

DELETE FROM sbnet_members
           WHERE id = 0
All phpBB users are deleted.
IB Guest account fixed and phpBB Anonymouset account inserted.

Couldn't get the number of posts inside the users table
1146: Table 'schoolb_sbnet.sbnet_members' doesn't exist

SELECT COUNT(*) FROM sbnet_members

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/schoolb/public_html/phpBB2/ib2phpBB/conv_users.php on line 58
Number of users to convert : .

Couldn't get data from 'members'
1146: Table 'schoolb_sbnet.sbnet_members' doesn't exist

SELECT * FROM sbnet_members WHERE mgroup='4'

Couldn't get data from 'members'
1146: Table 'schoolb_sbnet.sbnet_members' doesn't exist

SELECT * FROM sbnet_members WHERE mgroup='1'

Couldn't get data from 'members'
1146: Table 'schoolb_sbnet.sbnet_members' doesn't exist

SELECT * FROM sbnet_members WHERE mgroup='Moderator'


And so on till the end.

The IPB still works, but I want the phpBB as its more secure and versatile IMO.

Any ideas where I have screwed up please mate?

Backed up the database to be on the safeside and that is around 12Meg Gzipped and 43Meg normal text mode, so it is fairly hefty.

[Piratis]

Well apparently the problem is that the table 'schoolb_sbnet.sbnet_members' doesn't exist

first make sure that this script can convert the versions you have.

Was everything done automatically or you had to enter some settings? E.g. MySQL database name/username/password, table prefix etc? Maybe you entered something wrongly.

[Hazza]

Well apparently the problem is that the table 'schoolb_sbnet.sbnet_members' doesn't exist

first make sure that this script can convert the versions you have.

Was everything done automatically or you had to enter some settings? E.g. MySQL database name/username/password, table prefix etc? Maybe you entered something wrongly.

This is confusing me now

I installed the phpBB from scratch to a new directory. I checked the conf_global.php on the IPB and copied the details down and entered them in the installation of phpBB. Same with the password. On the finish of the installation, it accepted what I had put down. I deliberately tried putting in the wrong details but kept getting the "Critical error. Could not connect to the database" message.

I am 100% certain that the details I have are correct. The convertor script is the only one on phpBB.com that can do it. Looking at some of the posts on the forum, not many people are having a problem, so its just me by the looks of it.

I would give up on it, but the IPB is getting old and frail now, yet the price that IPB want for their products simply isn't worth it. I've worked with phpBB forums on other projects and have found it so much more versatile on modifying it.

[cannedmoose]

This is confusing me now

You're not the only one...

[metecyp]

Hazza,

I'm not sure what the problem is. It can be anything. I usually try reinstalling and see what happens. It also helps to read the README files in full. Sorry not much of a help here.

[Hazza]

mete and piratis, thank you for the help.

I deleted the phpBB forum for the umpteenth time and re-installed it. I kept getting the same errors, but realised that it was me, not the software. I put in the database name and database username the wrong way round which is why I kept on getting the errors

Lost alot of posts in the subforums, so may put all the subforums into the main forums, then run the convertor again

Now I'm a happy bunny