PHP
Forum software : phpBB
phpBB is the Internet forum package written in the PHP programming language. “phpBB” is an abbreviation of PHP Bulletin Board and it is free software. This free and very powerful piece of software is easy to install and manage and allows flexibility in terms of design and organization.
phpBB™ released its third major version. Version 3.0 incorporate a professional-quality modular design, high security, multiple-language interface, support for a multitude of database servers and complete layout customizations, all with a low implementation overhead.
phpBB3 provide administrators with more control over every part of the forum software, such as how it is display to management of user and group permissions. As a result, this improved functionality makes the administrative interface much more difficult, and new users have established it more intimidating than phpBB2.
phpBB3 require PHP 4.3.3 or later and is fully compatible with PHP 5.
phpBB3’s some major features include:
Modular design for Admin Control Panel, Moderator Control Panel, and User Control Panel.
Support for numerous database management systems, including MySQL, Microsoft SQL Server, Oracle, PostgreSQL, SQLite, Firebird, OpenLink Virtuoso, and other ODBC-accessible DBMS.
- It Support for unrestricted levels of subforums.
Ability to make custom-defined BBCode.
- Capability to make custom profile fields.
- It also provides permissions arrangement.
What is XAMPP?
XAMPP is a open, cross-platform web server, contains primarily the Apache HTTP Server, MySQL database, and interpreters for scripts written in the PHP and Perl programming languages.
XAMPP’s name is a short form for:
* X (denotes any operating system)
* Apache
* MySQL
* PHP
* Perl
Legitimately, XAMPP’s designers only proposed it to make use of this as a development tool for allowing website designers and programmers to check their jobs on their own computers with no access to the Internet. To create this as simple as possible, many essential safety features are disabled by default. In practice, XAMPP is occasionally used to serve web pages on the World Wide Web. A unique tool is provided with password to protect the most important parts of the package. XAMPP also provides support for creating and manipulating databases in MySQL and SQLite among others.
Fixing Error in live-chat
We are now trying to keep our site live, monitoring the online traffic 24X7 and supporting users who have any queries. Suddenly our live chat was down since this morning.
The error that kept coming up was “[SELECT username FROM livehelp_users WHERE sessionid=’4d821a82f66f87decb92b77394b20ed6′] ( 1016 : Can’t open file: ‘livehelp_users.MYI’. (errno: 145) )”
Then when I search in google for a solution I found this help in the http://webmaster-forums.code-head.com/showthread.php?t=29
It said that the problem could be one of the following reasons:
1 – Server crash; 2 – Hardware failure; 3 – A MySQL write process was interrupted;
and our livechat_users table got corrupted.
In our case I am sure it should be a MySQL write process being interrupted. Hence to fix the table I have used the query that was given in the forum,
Initally without reading the complete forum, I used PHPMyAdmin, a little hurry. Then I got read the complete forum and have a written a simple code
-> Created a connection to our database
-> used the two lines that was suggested in the forum.
And now the query is running. Our bad luck, suddenly our internet is prettly slow. We are just waiting for this script to get over so that we can start supporting you guys with full swing.
🙂 CIAO