DROP TABLE IF EXISTS `kbarticles`;
CREATE TABLE `kbarticles`(`approved` VARCHAR(5) ,`ArticleID` INT AUTO_INCREMENT,`Category` VARCHAR(50) ,`DateCreated` DATE ,`Problem` LONGTEXT ,`Solution` LONGTEXT ,`Title` VARCHAR(250) ,`Views` INT ,PRIMARY KEY (`ArticleID`));
DROP TABLE IF EXISTS `kbcategories`;
CREATE TABLE `kbcategories`(`Category` VARCHAR(50) ,`CategoryID` INT AUTO_INCREMENT,PRIMARY KEY (`CategoryID`));
DROP TABLE IF EXISTS `kbcomments`;
CREATE TABLE `kbcomments`(`access` VARCHAR(50) ,`ArticleID` INT ,`comment` LONGTEXT ,`CommentID` INT AUTO_INCREMENT,`email` VARCHAR(250) ,PRIMARY KEY (`CommentID`));
DROP TABLE IF EXISTS `kbusers`;
CREATE TABLE `kbusers`(`email` VARCHAR(50) ,`fullname` VARCHAR(50) ,`password` VARCHAR(50) ,`username` VARCHAR(50) ,PRIMARY KEY (`email`));
INSERT INTO `kbarticles`(`ArticleID`,`DateCreated`,`Views`,`Title`,`Problem`,`Solution`,`Category`,`approved`) VALUES(2,'2007-4-24 0:0:0',4,'Error: Operation must use an updateable query','Microsoft OLE DB Provider for ODBC Drivers error \'80004005\'rr[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. /tablename\_edit.asp, line xxx ','The solution to this problem can be found here:rhttp://xlinesoft.com/asprunner/docs/troubleshooting\_\_operation\_must\_use\_an\_updateable\_query\_\_errors.htm ','ASPRunnerPro','1');
INSERT INTO `kbarticles`(`ArticleID`,`DateCreated`,`Views`,`Title`,`Problem`,`Solution`,`Category`,`approved`) VALUES(3,'2007-4-24 0:0:0',1,'ASPRunnerPro/PHPRunner doesnt start ','Tryed to install ASPRunner Professional on a windows 2003 server but when I try to launch the program it will not run , nothing happens. ','Please try the following:r1. Proceed to Start->Settings->Control panel->System.r2. On the Advanced tab, under Performance, click Settings. r3. On the Data Execution Prevention tab, use one of the following procedures: Click \"Turn on DEP for essential Windows programs and services only\" r4. Click OK two times. rrRun ASPRunnerPro again to see if it runs okay.rrMore info: rhttp://www.microsoft.com/technet/security/prodtech/windowsxp/depcnfxp.mspx#EQD ','General','1');
INSERT INTO `kbarticles`(`ArticleID`,`DateCreated`,`Views`,`Title`,`Problem`,`Solution`,`Category`,`approved`) VALUES(4,'2007-4-24 0:0:0',1,'How to set image as a background ','Is there a way to change the display on list page? Instead of bgcolor I would like to display image. Can I change this in the style sheet (CSS)? ','Modify include/style.css to set an image as a background.rrbody r{rbackground-image:rurl(\'bgdesert.jpg\')r} ','General','1');
INSERT INTO `kbarticles`(`ArticleID`,`DateCreated`,`Views`,`Title`,`Problem`,`Solution`,`Category`,`approved`) VALUES(5,'2007-4-24 0:0:0',1,'Incorrect include\_path PHP option ','Warning:rmain(include/locale.php): failed to open stream: No such file or directory in /tmp/disk/home/webmaster/Files/WWW/NewUsers/include/Users\_functions.phpron line 2rrWarning: main(): Failed openingr\'include/locale.php\' for inclusion (include\_path=\':/usr/lib/php/pear\') in /tmp/disk/home/webmaster/Files/WWW/NewUsers/include/Users\_functions.php','you have unusual setting for \"include\_path\" PHP configuration option.rPlease change include\_path setting in your php.ini file to:r<if Unix>rinclude\_path=\".:/usr/lib/php/...\"r<if Windows>rinclude\_path=\".;c:\\php\\...\"rrThen restart your web server.','PHPRunner',NULL);
INSERT INTO `kbarticles`(`ArticleID`,`DateCreated`,`Views`,`Title`,`Problem`,`Solution`,`Category`,`approved`) VALUES(6,'2007-4-24 0:0:0',0,'Warning: session\_start... ','Warning: session\_start... ','To make your pages working do the following:r- open with any text editor file c:\\windows\\php.inir- find the string started with session.save\_path= r- make sure this directory existsr- make sure Internet Information Server or Apache account has read/write permissions on this directoryr- Make sure that in php.ini file \"session.save\_handler\" is set to \"files\"r----------------------------------------r. [Session]r; Handler used to store/retrieve data.rsession.save\_handler = files r----------------------------------------','PHPRunner',NULL);
INSERT INTO `kbarticles`(`ArticleID`,`DateCreated`,`Views`,`Title`,`Problem`,`Solution`,`Category`,`approved`) VALUES(7,'2007-4-22 0:0:0',0,'How to set default values to a date field in advanced search.','How to set default values to a date field in advanced search with \"between\" condition so we can show only records updated within the last two days?','You can do this by adding the following three lines in the beginning of list page right before rSession.LCID = 1033 line.rrSession(\"SearchOption\_\" & strTableName & \"\_DateField\") = \"Between\"rSession(\"SearchFor1\_\" & strTableName & \"\_DateField\") = FormatDatetime(DateAdd(\"d\", -2, now()),2)rSession(\"SearchFor2\_\" & strTableName & \"\_DateField\") = FormatDatetime(now(), 2)r','ASPRunnerPro','1');
INSERT INTO `kbarticles`(`ArticleID`,`DateCreated`,`Views`,`Title`,`Problem`,`Solution`,`Category`,`approved`) VALUES(8,'2007-4-25 0:0:0',0,'How to setup link to advanced search results page',' I am wondering if there is a way to save advanced searches so that it\'s easy to view the database based on certain criteria without having to enter the critera each time? Just a simple way to bookmark/link the search results page would suit my needs','You will need to make a change on advanced search page to see generated URL. rrTo dipslay parameters open ...\_search.asp in text editor and change FORM tag to use GET instead of POST. Do required search and copy URL. Change form back to POST. Use this URL to setup direct link to advanced search results.','ASPRunnerPro',NULL);
INSERT INTO `kbcategories`(`CategoryID`,`Category`) VALUES(1,'ASPRunner');
INSERT INTO `kbcategories`(`CategoryID`,`Category`) VALUES(2,'ASPRunnerPro');
INSERT INTO `kbcategories`(`CategoryID`,`Category`) VALUES(3,'General');
INSERT INTO `kbcategories`(`CategoryID`,`Category`) VALUES(4,'PHPRunner');
INSERT INTO `kbcomments`(`CommentID`,`ArticleID`,`email`,`comment`,`access`) VALUES(1,2,'jane@test.com','my comment','test');
INSERT INTO `kbcomments`(`CommentID`,`ArticleID`,`email`,`comment`,`access`) VALUES(2,2,'admin','admin','admin');
INSERT INTO `kbusers`(`username`,`password`,`email`,`fullname`) VALUES('admin','admin','admin@admin.com','admin');
INSERT INTO `kbusers`(`username`,`password`,`email`,`fullname`) VALUES('test','test','test@test.com','test user');
