Forum Replies Created
-
In reply to: Topics created, posts counted, but no posts shown
hey asboyd do you have phpmyadmin or any other database management? if so select the database and go to execute and execute the same exact code that gave u the error… should be the same as mine. Only this time change the last line to:
ENGINE = MYISAM DEFAULT CHARACTER SET 'utf8';
basically changing TYPE to ENGINE. That will correct everything. good luck.
PS thanks to Super Artsy in the topic below for posting the solution.
https://bbpress.org/forums/topic/db-posts-table-not-installing?replies=4#post-86225
In reply to: Topics created, posts counted, but no posts shownhey asboyd do you have phpmyadmin or any other database management? if so select the database and go to execute and execute the same exact code that gave u the error… should be the same as mine. Only this time change the last line to:
ENGINE = MYISAM DEFAULT CHARACTER SET 'utf8';
basically changing TYPE to ENGINE. That will correct everything. good luck.
PS thanks to Super Artsy in the topic below for posting the solution.
https://bbpress.org/forums/topic/db-posts-table-not-installing?replies=4#post-86225
In reply to: DB Posts Table Not Installingthank you a lot man it worked for me.
In reply to: DB Posts Table Not Installingthank you a lot man it worked for me.
In reply to: DB Posts Table Not Installingwhat file exactly do i change that in?
In reply to: DB Posts Table Not Installingwhat file exactly do i change that in?
In reply to: Topics created, posts counted, but no posts shownhey guys its a database problem where the table for posts arent being created any1 have any ideas why? this is the error im getting:
SQL ERROR!
>>> Database: xxxxxxxx (127.0.0.1)
>>>>>> CREATE TABLE IF NOT EXISTS
bb_posts
(post_id
bigint(20) NOT NULL auto_increment,forum_id
int(10) NOT NULL default 1,topic_id
bigint(20) NOT NULL default 1,poster_id
int(10) NOT NULL default 0,post_text
text NOT NULL,post_time
datetime NOT NULL default ‘0000-00-00 00:00:00’,poster_ip
varchar(15) NOT NULL default ”,post_status
tinyint(1) NOT NULL default 0,post_position
bigint(20) NOT NULL default 0,PRIMARY KEY (
post_id
),KEY
topic_time
(topic_id
,post_time
),KEY
poster_time
(poster_id
,post_time
),KEY
post_time
(post_time
),FULLTEXT KEY
post_text
(post_text
)) TYPE = MYISAM DEFAULT CHARACTER SET ‘utf8’;
>>>>>> 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 ‘TYPE = MYISAM DEFAULT CHARACTER SET ‘utf8” at line 16
In reply to: Topics created, posts counted, but no posts shownhey guys its a database problem where the table for posts arent being created any1 have any ideas why? this is the error im getting:
SQL ERROR!
>>> Database: xxxxxxxx (127.0.0.1)
>>>>>> CREATE TABLE IF NOT EXISTS
bb_posts
(post_id
bigint(20) NOT NULL auto_increment,forum_id
int(10) NOT NULL default 1,topic_id
bigint(20) NOT NULL default 1,poster_id
int(10) NOT NULL default 0,post_text
text NOT NULL,post_time
datetime NOT NULL default ‘0000-00-00 00:00:00’,poster_ip
varchar(15) NOT NULL default ”,post_status
tinyint(1) NOT NULL default 0,post_position
bigint(20) NOT NULL default 0,PRIMARY KEY (
post_id
),KEY
topic_time
(topic_id
,post_time
),KEY
poster_time
(poster_id
,post_time
),KEY
post_time
(post_time
),FULLTEXT KEY
post_text
(post_text
)) TYPE = MYISAM DEFAULT CHARACTER SET ‘utf8’;
>>>>>> 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 ‘TYPE = MYISAM DEFAULT CHARACTER SET ‘utf8” at line 16