Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-5104

"A fatal and unrecoverable database error has occurred" during install at "Create dat

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Resolution: Invalid
    • 3.0.RC2
    • None
    • Installation system
    • None
    • PHP Environment: PHP Version 5.2.0
      Database: MySQL 5.0.24a

    Description

      The problem is already best described in this post...

      http://www.phpbb.com/community/viewtopic.php?f=67&t=549827&p=3084421#p3084421

      The full error message I recieve
      [quote]
      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 [ 1177 ]

      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`

      Table 'phpbb_attachments' already exists
      [quote]

      I'm currently running PHP 5.2.0, however, this has also been tried on PHP Version 4.3.10. When I get this the only thing that shows up is a white screen, I have to view -> source to actually see the error above. SQL has full admin w/ remote access enabled. I've done numerous 2.xx PHPBB installs and 2-3 PHPBB3 beta installs, all successful. I can't find anything to suggest that this error is user related.

      Attachments

        Activity

          People

            Kellanved Kellanved [X] (Inactive)
            DarkArchon DarkArchon [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: