Page 1 of 1

MySQL / PHP5 / Apache Installation

Posted: Thu Sep 03, 2009 11:03 pm
by sjj1805
Procedure for most Linux Installations but in particular SUSE.

MySql
Apache 2
PHP

Posted: Mon Sep 07, 2009 2:53 pm
by sjj1805
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

Posted: Mon Sep 07, 2009 4:22 pm
by Stephen
PHP 5

Instructions for installation of PHP5 in Windows are in the download folder
M:\\setupdisks\\PHP 5

Posted: Mon Sep 07, 2009 4:26 pm
by Stephen
PHPBB3
Downloaded files
M:\\setupdisks\\FullWebServer&Forum

Instructions

Posted: Mon Sep 07, 2009 6:30 pm
by Stephen

Posted: Mon Sep 07, 2009 6:32 pm
by Stephen
TUTORIAL: How to install PHP and MySQL on IIS

http://www.ozzu.com/programming-forum/t ... 56303.html

Posted: Tue Sep 08, 2009 7:35 am
by sjj1805

Posted: Tue Sep 08, 2009 7:36 am
by sjj1805

Posted: Tue Sep 08, 2009 8:24 pm
by sjj1805
Working PHPBB3 forum.

Callisto

Serendipity - Blog Software

Posted: Tue Sep 15, 2009 2:14 am
by Stephen
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