| Error message phpbb3 RC7 installation | |
Posted: 11/13/2007 2:32 AM |
|
|
|
|
Citation |
Posts |
487 |
Word Cnt. |
35,729 |
BDay |
Oct 3 |
Sign |
Libra |
Sex |
|
|
|
|
Joined: Oct 29, 2006
Local time: 11:32 AM
Location: Klang, Malaysia
|
|
|
|
|
|
i have error msg when i want to install the phpbb3
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 [ 1165 ]
SQL : CREATE TABLE /forumattachments ( 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 '/forumattachments ( attach_id mediumint(8) UNSIGNED NOT NULL auto_increment, p' at line 1
|
|
|
|
|
Back to Top |
|
|
| Re: Error message phpbb3 RC7 installation | |
Posted: 11/13/2007 5:14 AM |
|
|
|
|
Citation |
Posts |
1253 |
Word Cnt. |
68,166 |
BDay |
Nov 9 |
Sign |
Scorpio |
Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 11:32 AM
|
|
|
|
|
|
Is the first bit saying you don't have permissions? Would that be why you get the rest? |
|
|
|
|
Back to Top |
|
|
| Re: Error message phpbb3 RC7 installation | |
Posted: 11/14/2007 11:32 AM |
|
|
|
|
Citation |
Posts |
487 |
Word Cnt. |
35,729 |
BDay |
Oct 3 |
Sign |
Libra |
Sex |
|
|
|
|
Joined: Oct 29, 2006
Local time: 11:32 AM
Location: Klang, Malaysia
|
|
|
|
|
|
Karen wrote:
|
Is the first bit saying you don't have permissions? Would that be why you get the rest?
|
Huh,why don't have permissions ??? Issit which file i need to set the permissions ?
Im not understand about this...... |
|
|
|
|
Back to Top |
|
|
| Re: Error message phpbb3 RC7 installation | |
Posted: 11/14/2007 11:43 AM |
|
|
|
|
Sparrow |
Posts |
33 |
Word Cnt. |
951 |
BDay |
N/A |
Sign |
N/A |
Sex |
|
|
|
|
Joined: Apr 29, 2007
Local time: 6:32 AM
|
|
|
|
|
|
No, this means that your host doesn't allow you to create the tables, unless you can use the root account of the database, or contact the your server provider, you won't be able to install. |
|
|
|
|
Back to Top |
|
|
| Re: Error message phpbb3 RC7 installation | |
Posted: 11/15/2007 10:52 AM |
|
|
|
|
Citation |
Posts |
487 |
Word Cnt. |
35,729 |
BDay |
Oct 3 |
Sign |
Libra |
Sex |
|
|
|
|
Joined: Oct 29, 2006
Local time: 11:32 AM
Location: Klang, Malaysia
|
|
|
|
|
|
Jasso wrote:
|
No, this means that your host doesn't allow you to create the tables, unless you can use the root account of the database, or contact the your server provider, you won't be able to install.
|
....need to contact my host provider then only can solve this problem? But before this i has success to install the phpbb3 RC5 version.That are not asking me contact my host or do anything and i can use the RC5 version board.I think i dont want to install the RC7 version again since i is lazy and don't know how to contact my host provider .... Anyway thank your all help me to anwser this question.
|
|
|
|
|
Back to Top |
|
|
| Information | |
|