MySQL / PHP5 / Apache Installation
Moderator: sjj1805
- sjj1805
- Site Admin
- Posts: 1194
- Joined: Fri Oct 27, 2006 12:45 am
- motherboard: Hewlett Packard 2AF7
- system_drive: C
- 32bit or 64bit: 64 Bit
- processor: 2-90 gigahertz Intel Core i5 4460S
- ram: 8 GB
- video card: NVIDIA GeForce GT 705
- sound card: P40D100-4 NVIDIA High Definition Audio
- Hard_Drive_Capacity: 8 TB
- Location: Birmingham UK
- Contact:
- sjj1805
- Site Admin
- Posts: 1194
- Joined: Fri Oct 27, 2006 12:45 am
- motherboard: Hewlett Packard 2AF7
- system_drive: C
- 32bit or 64bit: 64 Bit
- processor: 2-90 gigahertz Intel Core i5 4460S
- ram: 8 GB
- video card: NVIDIA GeForce GT 705
- sound card: P40D100-4 NVIDIA High Definition Audio
- Hard_Drive_Capacity: 8 TB
- Location: Birmingham UK
- Contact:
Video Tutorial.
Install MySql on Windows
http://www.youtube.com/watch?v=1uYmkKU4ai0
The files have been downloaded and are located here
M:\\setupdisks\\MySQL
Install MySql on Windows
http://www.youtube.com/watch?v=1uYmkKU4ai0
The files have been downloaded and are located here
M:\\setupdisks\\MySQL
TUTORIAL: How to install PHP and MySQL on IIS
http://www.ozzu.com/programming-forum/t ... 56303.html
http://www.ozzu.com/programming-forum/t ... 56303.html
- sjj1805
- Site Admin
- Posts: 1194
- Joined: Fri Oct 27, 2006 12:45 am
- motherboard: Hewlett Packard 2AF7
- system_drive: C
- 32bit or 64bit: 64 Bit
- processor: 2-90 gigahertz Intel Core i5 4460S
- ram: 8 GB
- video card: NVIDIA GeForce GT 705
- sound card: P40D100-4 NVIDIA High Definition Audio
- Hard_Drive_Capacity: 8 TB
- Location: Birmingham UK
- Contact:
- sjj1805
- Site Admin
- Posts: 1194
- Joined: Fri Oct 27, 2006 12:45 am
- motherboard: Hewlett Packard 2AF7
- system_drive: C
- 32bit or 64bit: 64 Bit
- processor: 2-90 gigahertz Intel Core i5 4460S
- ram: 8 GB
- video card: NVIDIA GeForce GT 705
- sound card: P40D100-4 NVIDIA High Definition Audio
- Hard_Drive_Capacity: 8 TB
- Location: Birmingham UK
- Contact:
- sjj1805
- Site Admin
- Posts: 1194
- Joined: Fri Oct 27, 2006 12:45 am
- motherboard: Hewlett Packard 2AF7
- system_drive: C
- 32bit or 64bit: 64 Bit
- processor: 2-90 gigahertz Intel Core i5 4460S
- ram: 8 GB
- video card: NVIDIA GeForce GT 705
- sound card: P40D100-4 NVIDIA High Definition Audio
- Hard_Drive_Capacity: 8 TB
- Location: Birmingham UK
- Contact:
Serendipity - Blog Software
Description:
Error
SQL-query:
ALTER TABLE ibf_posts ADD FULLTEXT (
post
)
MySQL said:
#1214 - The used table type doesn't support FULLTEXT indexes
How to repeat:
Try installing IPB boards ^.^
Suggested fix:
Don't have one.
Wish to god I did.
[19 Nov 2004 7:19] Victoria Reznichenko
Hi,
Full-text search is supported only on MyISAM table type. What is the type of ibf_posts
table?
[14 Feb 2005 23:54] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[16 Nov 2007 22:16] Galicia Badillo
ALTER TABLE my_table ENGINE = MYISAM;
Do this before the FullText add, even if the engine database default is already MyISAM
[31 Aug 2008 15:39] Nadeem Akram
Goto /your_ipb_directory/install/sql/mysql_fulltext.php
and instead of:
<?php
$INDEX[] = "alter table ibf_posts ADD FULLTEXT(post)";
$INDEX[] = "alter table ibf_topics ADD FULLTEXT(title)";
?>
change it to:
<?php
$INDEX[] = "ALTER TABLE ibf_posts ENGINE = MYISAM";
$INDEX[] = "ALTER TABLE ibf_topics ENGINE = MYISAM";
$INDEX[] = "alter table ibf_posts ADD FULLTEXT(post)";
$INDEX[] = "alter table ibf_topics ADD FULLTEXT(title)";
?>
and it will install perfectly fine
IPB v2.0.0 btw
Error
SQL-query:
ALTER TABLE ibf_posts ADD FULLTEXT (
post
)
MySQL said:
#1214 - The used table type doesn't support FULLTEXT indexes
How to repeat:
Try installing IPB boards ^.^
Suggested fix:
Don't have one.
Wish to god I did.
[19 Nov 2004 7:19] Victoria Reznichenko
Hi,
Full-text search is supported only on MyISAM table type. What is the type of ibf_posts
table?
[14 Feb 2005 23:54] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[16 Nov 2007 22:16] Galicia Badillo
ALTER TABLE my_table ENGINE = MYISAM;
Do this before the FullText add, even if the engine database default is already MyISAM
[31 Aug 2008 15:39] Nadeem Akram
Goto /your_ipb_directory/install/sql/mysql_fulltext.php
and instead of:
<?php
$INDEX[] = "alter table ibf_posts ADD FULLTEXT(post)";
$INDEX[] = "alter table ibf_topics ADD FULLTEXT(title)";
?>
change it to:
<?php
$INDEX[] = "ALTER TABLE ibf_posts ENGINE = MYISAM";
$INDEX[] = "ALTER TABLE ibf_topics ENGINE = MYISAM";
$INDEX[] = "alter table ibf_posts ADD FULLTEXT(post)";
$INDEX[] = "alter table ibf_topics ADD FULLTEXT(title)";
?>
and it will install perfectly fine
IPB v2.0.0 btw