p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 (http://p2p.wrox.com/forumdisplay.php?f=160)
-   -   Problems with chapter 13 cms (http://p2p.wrox.com/showthread.php?t=30633)

hooligan June 20th, 2005 09:29 AM

Problems with chapter 13 cms
 
Just got up to chapter 13 and i am getting an error message for the first script which sets up the tables. I followed the book correctly all from the start and it still seems to happen. Not sure what the error means,

I set up apache and mysql like the book said so to.

Here's the error

The used table type doesn't support FULLTEXT indexes

Thanks in advance


hooligan June 21st, 2005 02:25 AM

Anyone? It's actually pretty urgent. Just wondering why this would happen if i set up mysql php and apache and my dtabases exactly how the book says.


hooligan June 29th, 2005 05:49 AM

Anyone know? It has to have happened to someone else? I have followed the book to a t. I even used all the scripts that were provided and get the same error. I cant progress until this works.




hooligan June 29th, 2005 05:57 AM

I did just find this,

Only the MyISAM table type supports FULLTEXT indexes.

How do i change a table type? Or is this set up when i select my database type?


work_unit101 July 8th, 2005 09:51 AM

Try adding:
 ... ) TYPE = MyISAM";
at the end of your CREATE TABLE ... statement.


Quote:

quote:Originally posted by hooligan
 I did just find this,

Only the MyISAM table type supports FULLTEXT indexes.

How do i change a table type? Or is this set up when i select my database type?


101boxdevice

hooligan July 24th, 2005 12:15 AM

I just tried but not sure if i put it in correctly, the $sql variable is the $sql = <<<EOS type one so im not sure if i put it in correctly.

Here's the query

Code:

$sql = <<<EOS
CREATE TABLE IF NOT EXISTS cms_articles (
  article_id int(11) NOT NULL auto_increment,
  author_id int(11) NOT NULL default '0',
  is_published tinyint(1) NOT NULL default '0',
  date_submitted datetime NOT NULL default '0000-00-00 00:00:00',
  date_published datetime NOT NULL default '0000-00-00 00:00:00',
  title mediumtext NOT NULL default '',
  body mediumtext NOT NULL,
  PRIMARY KEY (article_id),
  KEY IdxArticle (author_id,date_submitted),
  FULLTEXT INDEX IdxText (title,body),
) TYPE = MyISAM;
EOS;
$result = mysql_query($sql)
  or die(mysql_error());


And i get this error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') TYPE = MyISAM' at line 12

Thanks in Advance


hooligan July 24th, 2005 12:19 AM

Just tried it again :) And it works thanks again. I left in a stupid comma at the end. Thanks again.



All times are GMT -4. The time now is 10:05 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.