Web-Site-Scripts.com - MS SQL https://www.web-site-scripts.com/knowledge-base/category/105 en-us KnowlageBase RSS Generator If you're using MSSQL 2005 https://www.web-site-scripts.com/knowledge-base/article/AA-00693 If you're using MSSQL 2005, please insert this as a second line to the /admin/config.inc.php file (KMP must be already installed):

define('MAX_INSERT_ROWS', 1);

The file will look similar to this then:

<?php
define('MAX_INSERT_ROWS', 1);
    // --- Debug settings ---
    // General application debug
    define('KMP_DEBUG', 0);               // 1 to enable, 0 to disable

Save the config.inc.php file.

]]> Tue, 27 Sep 2011 16:01:38 +0000 https://www.web-site-scripts.com/knowledge-base/article/AA-00693 Full-Text Indexing (MSSQL) https://www.web-site-scripts.com/knowledge-base/article/AA-00654 Full-Text Indexing must be enabled on the MSSQL server, otherwise search function in KMP wouldn't work. It is also recommended to have it enabled before you install KMP.

By default Full-Text Indexing is enabled on SQL Server 2005/2008. To find out if it is true for your server, please do the following checks.

If you prefer MS SQL Express

Please note that MS SQL Express also has Full-Text Indexing feature, you would just need to use the MS SQL Express with Advanced Services package.

You can download MS SQL Express here:

When asked, select the SQLEXPRADV package - that's the MS SQL Express with Advanced Services package that you need:


Check if Full-Text Filter Daemon is Running

Go to Start > Control Panel > Administrative Tools > Services.


You should see there SQL Full-text Filter Daemon Launcher (SQLSERVERNAME) for SQL 2008, or SQL Server FullText Search (SQLSERVERNAME) for SQL 2010.

Its status should be Started.

If this service is not running, just start it and make it start automatically. This will solve the issue and no re-installation is necessary.

If you cannot find this service, check if Full-Text Filter Daemon is installed. For that, go to Start > All Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager.


Find the "SQL Full-text Filter Daemon Launcher" service here. If it is not running, launch it and setup it to start Automatically.

If this service is not shown here, then Full-text Filter Daemon is simply not installed in this SQL instance.

Run SQL setup and update this instance. On the "Feature Selection" step you need to select the "Full-Text Search" option.


If you haven't installed KMP yet, you can go on and install it now (you can skip the remaining part of this guide).

If you had installed KMP prior to enabling the Full-Text Indexing feature, there are two ways to enable search in KMP:

  • re-install KMP
  • add required KMP database tables to the full-text search catalog (keep reading to learn how to do that)

Full-Text Index is Now Enabled. How to Add KMP Tables to the Full-Text Catalog?

Please note!

This step is needed if you enabled Full-Text Indexing feature after installing KMP and you do not want to reinstall it. If you have enabled this feature before installing KMP, feel free to continue the installation process. You're fine.

OK. You finally enabled all full-text options on your SQL server and search function is not working correctly yet. You want to get search working, but you do not want to re-install KMP because of this.

You can add required database tables and columns to the full text catalog manually, without reinstalling KMP.

In SQL Server Management Studio check if the Full-Text Catalog named "kmp_fulltext_catalog" already exists. For this, go to Storage > Full Text Catalogs page in your database structure and check if "kmp_fulltext_catalog" exists there.


You can see on my screenshot that the mentioned catalog already exists. If it doesn't exist on your SQL server, you can create it: Right-click on Full Text Catalogs > New Full Text Catalog..., then provide the name for it in the window that opens: "kmp_fulltext_catalog" (without quotes), and save it by clicking OK. No need to change anything else.

Let's add the required tables and columns to the catalog now.

Right-click on it > Properties.

Go to the Tables/Views page.

Right now the catalog should look like this (notice the empty list on the right Table/view objects assigned to the catalog. If this list is not empty for some reason, then probably you do not have to proceed because full text catalog is just fine and should work normally - try searching something in KMP to make sure).


If the list on the right is empty, then you should start adding the following tables and columns to the index:

Table Columns
 dbo.drafts  plain_text, question
 dbo.faq_article_templates  plain_text, title
 dbo.faq_categories  cat_name, meta_description, meta_keywords
 dbo.faq_statistics  feedback
 dbo.faq_visitors_comments  visitor_comment, visitor_subject
dbo.search_index   back_end_custom_fields, comments, front_end_custom_fields, meta_description, meta_keywords, plain_text, question
 dbo.terms  term, term_description

To add a table to the Full Text Catalog simply select this table on the left and click on the -> button. It will be added to the list on the right.

To add columns to the Full Text Catalog select the relevant table in the list on the right and mark checkboxes for these columns below.

For example, this screenshot shows the look of the dbo.drafts table and its columns in the catalog.


Be attentive to add every table and column and then click OK to save the catalog.

You can now check the search function, it should work correctly.

]]> Mon, 04 Apr 2011 15:08:21 +0000 https://www.web-site-scripts.com/knowledge-base/article/AA-00654 Migration from MySQL to MS SQL https://www.web-site-scripts.com/knowledge-base/article/AA-00615 This guide explains how to migrate KMP from MySQL to MS SQL with keeping your data. This guide can also be used if you're migrating from one MS SQL server to another.

  1. Ensure that the Full-Text Indexing feature is installed on the MS SQL server.
  2. Install a fresh KMP v6.0.1 or higher instance using a new empty MS SQL database (see The installation guide for details).
  3. Update the old instance of KMP to the v6.0.1 or higher (see The update guide for details). Please note that both instances must be of the same version!
  4. Make a database dump of the upgraded instance of KMP: go to Administration > Database Backups and click "Create Dump". This could take several minutes. Please do not interrupt the process.



  5. Copy the following folders through from the upgraded instance of KMP to the new one:

    /admin/attaches/

    /admin/media_store/

    /admin/systembackups/


  6. Go to Administration > Database Backups in the new KMP instance, sort dumps by and click "Restore" for the most recent database dump. Dump restoring could take quite a lot of time (several hours). That's fine. Please do not interrupt the process.



  7. Give a good test to a new instance running on MS SQL: check that all your articles, attachments, images, users, etc. were moved properly. Please do not delete the old KMP instance until you're sure that the new instance is up and running with all your data safe.

]]> Mon, 27 Dec 2010 10:19:41 +0000 https://www.web-site-scripts.com/knowledge-base/article/AA-00615 Database extensions for PHP (MySQL, Microsoft SQL) https://www.web-site-scripts.com/knowledge-base/article/AA-00595 KMP uses MySQL or MS SQL database to store most of its data. You would need to have a database driver (realized as a PHP extension) to enable KMP connect to a database server. Chose the link below which matches your web server operation system and desired database type.



]]> Mon, 29 Nov 2010 17:10:02 +0000 https://www.web-site-scripts.com/knowledge-base/article/AA-00595