I'm trying to install phpbb3 now when I reach 'Create database tables' stage before the 'final stage' I get this error...

what is it?


A fatal and unrecoverable database error has occurred. This may be because the specified user does not have appropriate permissions to CREATE TABLES or INSERT data, etc. Further information may be given below. Please contact your hosting provider in the first instance or the support forums of phpBB for further assistance.

install_install.php [ 1181 ]

SQL : CREATE TABLE phpbb_*attachments ( attach_id mediumint(8) UNSIGNED NOT NULL auto_increment, post_msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, in_message tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, is_orphan tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, physical_filename varchar(255) DEFAULT '' NOT NULL, real_filename varchar(255) DEFAULT '' NOT NULL, download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, attach_comment text NOT NULL, extension varchar(100) DEFAULT '' NOT NULL, mimetype varchar(100) DEFAULT '' NOT NULL, filesize int(20) UNSIGNED DEFAULT '0' NOT NULL, filetime int(11) UNSIGNED DEFAULT '0' NOT NULL, thumbnail tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (attach_id), KEY filetime (filetime), KEY post_msg_id (post_msg_id), KEY topic_id (topic_id), KEY poster_id (poster_id), KEY is_orphan (is_orphan) ) CHARACTER SET `utf8` COLLATE `utf8_bin`

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*attachments ( attach_id mediumint(8) UNSIGNED NOT NULL auto_increment, post_m' at line 1

Have you created a database, username and applied user privileges first from your control panel?

Please give your site address if you require help as outlined in the rules.

yes created . site address is innovation-ptc.vndv.com

i can connect to the database but the problem occurred at the 2nd last stage

here is the screen shot

Sure you have applied all the privileges to the database user?

If you are 100% sure you have, then it is probably a server side error with MySQL and requires an admin to investigate.

see if it all right. see the screen shot

Ok the error is perhaps server-side. I know there have been some issues with MySQL recently that the admins are currently fixing so the problem will most likely be gone in a few days.

Things you might want to try until an admin helps out:
•Delete phpBB3 files and databases. Reupload phpBB and create a new database/user (keep to one character) and try again.
•Wait a couple of days and see if the issue resolves itself.
•If you can't wait, create a new hosting account.