Gettomg am errpr. while trying to install phpbb3

[John Klyne]

...I was installing it, and it was up to the Create Database tables section...

It returned this error...

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 [ 1193 ]
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


I looked at the database it already has the necessary values and tables and such.


I also received another error when I went to my site.



"

General Error

SQL ERROR [ mysqli ]

Lost connection to MySQL server during query [2013]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists."

---------- Post added at 09:42 PM ---------- Previous post was at 09:40 PM ----------

Now I get a new error, after reinstalling everything...when I am installing it ends up at ...

General Error
SQL ERROR [ mysqli ]

Lost connection to MySQL server during query [2013]

SQL

INSERT INTO phpbb_log (user_id, log_ip, log_time, log_operation, log_data, log_type) VALUES (2, '69.175.104.34', 1279680035, 'LOG_INSTALL_INSTALLED', 'a:1:{i:0;s:9:\"3.0.7-PL1\";}', 0)

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions.php
LINE: 3224
CALL: dbal_mysqli->sql_query()

FILE: install/install_install.php
LINE: 1955
CALL: add_log()

FILE: install/install_install.php
LINE: 107
CALL: install_install->email_admin()

FILE: install/index.php
LINE: 409
CALL: install_install->main()

FILE: install/index.php
LINE: 286
CALL: module->load()

----
If anyone knows to fix this, it is greatly appreciated...I am offering 100 credits and rep to the one that solves my problem and it works for me. : )

Thank you.

 

[Brandon]

Delete and re-create the database and try again.

 

[John Klyne]

I delted the database and tried installing it again, I received another error...

SQL ERROR [ mysqli ]

MySQL server has gone away [2006]

SQL

SELECT COUNT(session_id) AS sessions FROM phpbb_sessions WHERE session_user_id = 1 AND session_time >= 1279719050

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/session.php
LINE: 800
CALL: dbal_mysqli->sql_query()

FILE: includes/session.php
LINE: 453
CALL: session->session_create()

FILE: install/install_install.php
LINE: 1923
CALL: session->session_begin()

FILE: install/install_install.php
LINE: 107
CALL: install_install->email_admin()

FILE: install/index.php
LINE: 409
CALL: install_install->main()

FILE: install/index.php
LINE: 286
CALL: module->load()

I will delete all my files, databases and such, and try one more time. I hope this works. Thank you for the help though Brandon.

----
Fixed... : ) Brandon thank you a lot for all your help.

-------------------

EDIT: I did download is successfully, but now there is another error....

General Error
SQL ERROR [ mysql4 ]

Lost connection to MySQL server during query [2013]

SQL

SELECT word, replacement FROM phpbb_words

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/cache.php
LINE: 82
CALL: dbal_mysql->sql_query()

FILE: includes/functions_content.php
LINE: 706
CALL: cache->obtain_word_list()

FILE: includes/functions_content.php
LINE: 421
CALL: censor_text()

FILE: includes/functions_display.php
LINE: 463
CALL: generate_text_for_display()

FILE: index.php
LINE: 28
CALL: display_forums()

I am sorry for what I may be doing wrong, but I do not know what it may be.

-----

Edit again, oh my god so many edits heh...I fixed it...I did not know it would not work if I made the forum folder be perfect instead of lagron.co.cc/forums ....

 

[DeadBattery]

Looks like it is working now.
Feel free to create another support thread through the account panel if you have any additional problems.
*****Thread Closed*****