FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


SQL Error while installing PHPBB





GameFreak
I was trying to install PHPBB and I got this Error after I submitted my form:
Quote:

An error occurred trying to update the database
Duplicate entry '1' for key 1


Can somebody help me out here? What exactly does this mean?
yjwong
Do you have existing tables in the database? Drop the database and recreate it again. It might be caused by an incomplete previous installation. If you are installing phpBB on Frihost, I think you could use the Fantastico software provided with cPanel.
Diablosblizz
Not everybody has Cpanel anymore (not me). But do drop the database and remake it.
GameFreak
Actually, I have tried deleting the database and re-installing it .... but it still happens, I'm really frustrated ..... please help me!
Diablosblizz
Okay here:

1. Delete phpbb forum directory.
2. Delete mysql database
3. Download the "9ZIP" file type from the downloads section on phpbb.com.
4. Upload the downloaded file
5. Click Extract, and extract it into the directory you want.
6. Recreate the mysql database
7. Install phpbb

This is a great way to install phpbb without extracting the files onto your hard drive. I think this will work, if you are using frihost.

If you are not using frihost please follow these steps:

1. Delete phpbb forum directory.
2. Delete mysql database
3. Download the ZIP file type.
4. Extract all the files onto your server
5. Recreate mysql database
6. Install phpbb.

I hope this helps.
Related topics
Getting database connection error while installing wordpress
Error while installing Webapp
Sql Error: 1017. Missing all the indexes files of phpbb
Error while creating the SQL table pls help
Error Upon Installing phpBB 3.0.2
Help: SQL error after uploading new files(thread updated)
[man] SQL Error : 1054 Unknown column \'session_admin\ en DB
some weird error while installing phpbb2
SQL ERROR [ mysql4 ] - due to hosting? -
Strange SQL error
Error while opening a topic
SQL ERROR [ mysqli ]
While installing phpBB...
Willing to install
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.