Tried converting a saved hacked phpbb board to smf

Started by causedujour, December 23, 2005, 12:05:59 AM

Previous topic - Next topic

causedujour

used the converter, used the upgrade...

Got these errors after running the upgrade

Upgrading...
Creating new tables and inserting default data... Unsuccessful!
This query:
ALTER TABLE phpbb_themes
CHANGE COLUMN ID_MEMBER ID_MEMBER mediumint(8) NOT NULL default '0';
Caused the error:

Unknown column 'ID_MEMBER' in 'phpbb_themes'

Unsuccessful!
This query:
ALTER TABLE phpbb_themes
CHANGE COLUMN value value text NOT NULL default '';
Caused the error:

Unknown column 'value' in 'phpbb_themes'

Unsuccessful!
This query:
INSERT IGNORE INTO phpbb_themes
VALUES
(0, 1, 'name', 'SMF Default Theme'),
(0, 1, 'theme_url', 'hxxp:www.heathenhandbook.com/publicforum/Themes/default'), [nonactive]
(0, 1, 'images_url', 'hxxp:www.heathenhandbook.com/publicforum/Themes/default/images'), [nonactive]
(0, 1, 'theme_dir', '/home/heathe8/public_html/publicforum/Themes/default'),
(0, 1, 'allow_no_censored', '0'),
(0, 1, 'additional_options_collapsable', '1');
Caused the error:

Column count doesn't match value count at row 1


Can you advise what my next steps should be to fix (I'm so green!)? Thanks in advance.

causedujour

Forgot to add this...this is the error I receive when I try to go to the index.php page

Unknown column 'variable' in 'field list'

Fizzy

So you're saying that you installed 1.0.5 then converted from phpbb and then upgraded to 1.1 RC1 ?

If so, why are you using "phpbb_" as your database prefix?
To avoid confusion it would be better to leave the phpbb side of the database alone and install 1.0.5 with the default prefix of "smf_"

Have you tried running repair_settings?

What is repair_settings?
"Reality is merely an illusion, albeit a very persistent one." - A.E.


causedujour

Bear with me as I only know enough to be very dangerous, and not enough to fix anything. ;)

I installed the SMF 1.1 RC1 and then wanted to hook it up to use the old database from a forum that used phpbb when it was installed. The existing databae already had the prefix phpbb...should I have renamed it? I used the converting file, then the upgrade file (in my attempts to fix it) and also ran the repair settings thing, but almost everything came up with the "recommended" path.

Just not sure what to do from here.

Fizzy

So if you have SMF 1.1 RC1 installed then what are you trying to upgrade to?

Try running the install of 1.1 RC1 again but this time let the database prefix stay as the default SMF_
"Reality is merely an illusion, albeit a very persistent one." - A.E.


causedujour

Should I still do that if the database already exists with the phpbb_ prefixes and there is another existing database on our site that uses the smf defaults?

Fizzy

Don't touch the phpbb_ database tables as you need that to convert FROM, just re-install all of the SMF files and tables :)
"Reality is merely an illusion, albeit a very persistent one." - A.E.


causedujour

First, thanks so much for continuing to reply to my posts, I really am most grateful.

I tried that, and now I get this error when I attempt to view the index.php file

Unknown column 'data' in 'field list'

Fizzy

Quote from: causedujour on December 23, 2005, 06:57:02 PM
Unknown column 'data' in 'field list'

You're not seeing the SMF database.

If you want to PM me with your paths, logins and passwords for FTP, Admin Panel and CPanel I'll gladly have a look for you and I'll try see what the problem is

:)
"Reality is merely an illusion, albeit a very persistent one." - A.E.


Fizzy

Now sorted.

Problem:

SMF had overwritten PHPBB tables due to wrong DB prefix during SMF install.

Solution:

Restores phpbb2 files and DB, re-installed SMF and converted.
"Reality is merely an illusion, albeit a very persistent one." - A.E.


Advertisement: