Help with PHPBB

Soldato
Joined
18 Oct 2002
Posts
17,641
Location
Cambridge
I have moved some forums into my personal webspace and imported the sql database but i think i'm still unable to view them because some of the General Config options aren't relevant on my site. I can't find which file specifies what domain name and script path is to be used and obviously can't load the forums admin section. Does anyone know where this info is stored?
 
Check the phpbb_config table in your database. You'll be able to edit the values for cookie_domain and cookie_path (assuming that's what you're after) in there :).
 
Thanks that table had the domain name in it. I've stumbled across another problem though which i hadn't noticed before. I have imported the sql structure but when i try and import the data it comes up with the following error:

SQL query:

INSERT INTO phpbb_search_wordlist( word_text, word_id, word_common )
VALUES (

'applyíng', '19435', '0'
);



MySQL said:

#1062 - Duplicate entry 'applyíng' for key 1

None of the tables after the one that errored are populated.
 
Beansprout said:
Ouch, that's a character set conflict. It's interpreting that as "applying".

Meaning :confused:.

EDIT

From what i can tell that table is basically an index for searching. I've deleted all the references from the text file (don't have access to phpmyadmin on the original site) and it seems to have gotten further on the upload. Not sure of the implications of not filling the table though.

EDIT 2
Keeps bloody timing out now too, the file is around 16mb and doesn't import much over 5. How can i get round this without exporting the tables individually?
 
Last edited:
CliffyG said:
Keeps bloody timing out now too, the file is around 16mb and doesn't import much over 5. How can i get round this without exporting the tables individually?
Upload the sql file and ask your host to import it for you :)

As for the search table error...I'd just ignore it. Probably not the best solution but hey, if it works...
 
I think the long way round would be opening the text file and splitting it into smaller chunks for upload. Probably would be a lot quicker than getting my host to do it and as it's pretty important that i get it turned around asap after i switch off the forums in the old location it looks like my only way forward :(.
 
Depends who your host is.

Small companies are much better than the big ones for custom things like this. But you never know until you ask.

How about e-mailing them then starting it yourself too, so you're covered either way :)
 
Back
Top Bottom