MySQL / PHP5 / Apache Installation

Virtual PC and Virtual Box

Moderator: sjj1805

Post Reply
User avatar
sjj1805
Site Admin
Posts: 1194
Joined: Fri Oct 27, 2006 12:45 am
operating_system: Windows 10 Pro
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:

MySQL / PHP5 / Apache Installation

Post by sjj1805 » Thu Sep 03, 2009 11:03 pm

Procedure for most Linux Installations but in particular SUSE.

MySql
Apache 2
PHP

User avatar
sjj1805
Site Admin
Posts: 1194
Joined: Fri Oct 27, 2006 12:45 am
operating_system: Windows 10 Pro
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:

Post by sjj1805 » Mon Sep 07, 2009 2:53 pm

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

User avatar
Stephen
Site Admin
Posts: 6
Joined: Mon Aug 31, 2009 7:56 pm

Post by Stephen » Mon Sep 07, 2009 4:22 pm

PHP 5

Instructions for installation of PHP5 in Windows are in the download folder
M:\\setupdisks\\PHP 5
Last edited by Stephen on Mon Sep 07, 2009 5:03 pm, edited 1 time in total.

User avatar
Stephen
Site Admin
Posts: 6
Joined: Mon Aug 31, 2009 7:56 pm

Post by Stephen » Mon Sep 07, 2009 4:26 pm

PHPBB3
Downloaded files
M:\\setupdisks\\FullWebServer&Forum

Instructions

User avatar
Stephen
Site Admin
Posts: 6
Joined: Mon Aug 31, 2009 7:56 pm

Post by Stephen » Mon Sep 07, 2009 6:30 pm


User avatar
Stephen
Site Admin
Posts: 6
Joined: Mon Aug 31, 2009 7:56 pm

Post by Stephen » Mon Sep 07, 2009 6:32 pm

TUTORIAL: How to install PHP and MySQL on IIS

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

User avatar
sjj1805
Site Admin
Posts: 1194
Joined: Fri Oct 27, 2006 12:45 am
operating_system: Windows 10 Pro
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:

Post by sjj1805 » Tue Sep 08, 2009 7:35 am


User avatar
sjj1805
Site Admin
Posts: 1194
Joined: Fri Oct 27, 2006 12:45 am
operating_system: Windows 10 Pro
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:

Post by sjj1805 » Tue Sep 08, 2009 7:36 am


User avatar
sjj1805
Site Admin
Posts: 1194
Joined: Fri Oct 27, 2006 12:45 am
operating_system: Windows 10 Pro
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:

Post by sjj1805 » Tue Sep 08, 2009 8:24 pm

Working PHPBB3 forum.

Callisto

User avatar
Stephen
Site Admin
Posts: 6
Joined: Mon Aug 31, 2009 7:56 pm

Serendipity - Blog Software

Post by Stephen » Tue Sep 15, 2009 2:14 am

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

Post Reply