phpBB problems [moved]

[shamrocks]

Do anyone know how I can contact someone to try and help me with my issue? Here is the story.

Our website forums (phpbb) have been hacked on several occasions, so I decided to download the most recent phpbb (forums) and install that. However thats where the problem lies. I placed the new forums under 'Public_html/STHS/forums' whereas the old forums sit in 'Public_html/forums'. I enter the same data in the new installation as in the old one, minus the table prefix, which has been changed from 'phpbb_' to 'sths_', but I get the following errors:

An error occurred trying to update the database

Could not insert board_startdate :: INSERT INTO sths_config (config_name, config_value) VALUES ('board_startdate', 1153917656) :: 888 :: /home/geixhlbz/public_html/STHS/forums/install/install.php

Could not insert default_lang :: INSERT INTO sths_config (config_name, config_value) VALUES ('default_lang', 'english') :: 895 :: /home/geixhlbz/public_html/STHS/forums/install/install.php

Could not insert default_lang :: UPDATE sths_config SET config_value = '[email protected]' WHERE config_name = 'board_email' :: 912 :: /home/geixhlbz/public_html/STHS/forums/install/install.php

Could not insert default_lang :: UPDATE sths_config SET config_value = '/STHS/forums/' WHERE config_name = 'script_path' :: 912 :: /home/geixhlbz/public_html/STHS/forums/install/install.php

Could not insert default_lang :: UPDATE sths_config SET config_value = '80' WHERE config_name = 'server_port' :: 912 :: /home/geixhlbz/public_html/STHS/forums/install/install.php

Could not insert default_lang :: UPDATE sths_config SET config_value = 'www.xhl.biz' WHERE config_name = 'server_name' :: 912 :: /home/geixhlbz/public_html/STHS/forums/install/install.php

Could not update admin info :: UPDATE sths_users SET username = 'shamrocks', user_password='235c39cc4618b6d5b81de493b518f05d', user_lang = 'english', user_email='[email protected]' WHERE username = 'Admin' :: 923 :: /home/geixhlbz/public_html/STHS/forums/install/install.php

Could not update user_regdate :: UPDATE sths_users SET user_regdate = 1153917656 :: 930 :: /home/geixhlbz/public_html/STHS/forums/install/install.php

I am trying to get help on phpbb message board and it seems that they point towards Cpanel for the problem. Can anyone help?

 

[nickp666]

have you assigned privelidges over the database to the user you are logging in with?

Normally when you get errors like the above its because the user doesnt have insert or update privelidges, if the user is assigned correctly, check the permissions on the tables themselves

 

[shamrocks]

have you assigned privelidges over the database to the user you are logging in with?

Normally when you get errors like the above its because the user doesnt have insert or update privelidges, if the user is assigned correctly, check the permissions on the tables themselves

Thanks for your response Nickp666.
The user has ALL Privileges, so that is not the problem. Any other ideas?

 

[nickp666]

have you confirmed this by looking in the mysql user tables rather than just the cpanel mysql applet?

Other things that could cause it are used quota, permissions on the database files themselves - /var/lib/mysql

 

[NightStorm]

Some of the suggestions I am finding through google are:
- Try creating a new database, instead of using an existing one
- Make sure that, if the table prefixes are different, you are doing a new install and not a database update
- Try a clean install, and then import the data from the older board (phpBB offers import scripts on their site)
- Make sure that the install script is creating the tables. If it doesn't create the tables, it can't populate them. Try importing the .sql file from your phpMyAdmin (when logged in as the user) and see if it creates the tables and populates them when done directly. This will help you find the exact location of the problem (permissions, or whatever).
- Use Fantastico or the cPanel script installer to put phpBB on your site (I don't suggest this, as both are currently outdated unless you make your own packages)
And finally, which is the best suggestion of them all...
- Dump phpBB and use a forum with less exploits available like SMF or vBulletin. They both support migrating phpBB data into them, and are more secure than phpBB is.

There are loads of topics about this at http://www.phpbb.com/phpBB/index.php... surely you have checked there though, right?

 

[shamrocks]

have you confirmed this by looking in the mysql user tables rather than just the cpanel mysql applet?

Other things that could cause it are used quota, permissions on the database files themselves - /var/lib/mysql

Theres a different?
I look at the privileges in cpanel/MySQL database. Where would I find the mysql user tables?

 

[nickp666]

yeah, you can get to the mysql user tables via phpmyadmin at root level, however it would seem as if you have been trying to run a phpbb upgrade rather than new install which would cause the errors you are getting, try some of NightStorms checks if this is not the case

 

[shamrocks]

Answers are in RED.

Some of the suggestions I am finding through google are:
- Try creating a new database, instead of using an existing one:
ANS: Tried that, still didn't work

- Make sure that, if the table prefixes are different, you are doing a new install and not a database update
ANS: I got to install/install.php, and when I Fill out the table it says 'start install'

- Try a clean install, and then import the data from the older board (phpBB offers import scripts on their site)
ANS: What is this?

- Make sure that the install script is creating the tables. If it doesn't create the tables, it can't populate them. Try importing the .sql file from your phpMyAdmin (when logged in as the user) and see if it creates the tables and populates them when done directly. This will help you find the exact location of the problem (permissions, or whatever).
ANS: Where do I check to see if the install script is creating the tables? Which .sql file would I be looking to import when in phpMyAdmin?

- Use Fantastico or the cPanel script installer to put phpBB on your site (I don't suggest this, as both are currently outdated unless you make your own packages)
ANS: I uploaded all files and folders to Cpanel myself.

And finally, which is the best suggestion of them all...
- Dump phpBB and use a forum with less exploits available like SMF or vBulletin. They both support migrating phpBB data into them, and are more secure than phpBB is.
ANS: Will give it a try.

There are loads of topics about this at http://www.phpbb.com/phpBB/index.php... surely you have checked there though, right?
ANS: I've been ALL over that, and basically said to check with my host, which I'm assuming is Cpanel.

 

[shamrocks]

yeah, you can get to the mysql user tables via phpmyadmin at root level, however it would seem as if you have been trying to run a phpbb upgrade rather than new install which would cause the errors you are getting, try some of NightStorms checks if this is not the case

As far as I know it is a new install, cause it says START INSTALL at the bottom of where I fill in the database information.
I'm assuming that I go to Cpanel and in mysql database at the bottom I can get to phpmyadmin?

 

[shamrocks]

Do I go into Databases to get to the user tables?

 

[shamrocks]

Thanks for all your help, but I FINALLY found me problem. I didn't have some files uploaded to my server.
STUPID mistake I know.
Thanks again for you responses.