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 (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.
- Ticket ID
- 451
- Created
- Saturday 31 December, 2005 19:47:03 GMT-0000
by Unknown - LastModif
- Sunday 03 June, 2007 19:55:43 GMT-0000
Attachments
| filename | created | hits | comment | version | filetype | ||
|---|---|---|---|---|---|---|---|
| No attachments for this item | |||||||
;){kind=link}
;){kind=link}
- With Codemirror enabled or toggled Admins can't edit text-area field on doc.t.o
- Warning: strpos(): Empty needle in tiki-25.0/lib/cache/memcachelib.php on line 217
- Fatal error Uncaught TypeError in_array Argument #2 $haystack must be of type array, bool given in binderlib.php 49
- Remove version of wiki page fails
- Fatal error: Uncaught TypeError: in_array(): Argument #2 ($haystack)
;){kind=link}
;){kind=link}