reserved keyword "reads" for column name used in few tables
- Status
- Closed
- Subject
- reserved keyword "reads" for column name used in few tables
- Category
- Error
- Feature
- Database MySQL (MyISAM)
Article - Resolution status
- Fixed or Solved
- Rating
- Description
CREATE TABLE tiki_articles(
articleId int( 8 ) NOT NULL AUTO_INCREMENT ,
.
.
reads int( 14 ) default NULL ,
.
.
KEY reads( reads ) ,
KEY author( author( 32 ) ) ,
FULLTEXT KEY ft( title, heading, body )
) TYPE = MYISAM AUTO_INCREMENT =1cause
- 1064 - 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 'reads int(14) default NULL,
votes int(8) default NULL,
points int(14) defaul' at line 28- Importance
- 5
- Priority
- 25
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is currently unavailableUnable to connect to show2.tiki.org. Please let us know of the problem so that we can do something about it. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is currently unavailableUnable to connect to show.tikiwiki.org. Please let us know of the problem so that we can do something about it. Thanks.
- Ticket ID
- 451
- Created
- Saturday 31 December, 2005 19:47:03 UTC
by Unknown - LastModif
- Sunday 03 June, 2007 19:55:43 UTC