Welcome to Geeklog, Anonymous Friday, May 24 2024 @ 12:57 am EDT

Geeklog Forums

Bad field names - Database reserved words.


I don't know too much about the new Geeklog 2 but wanted to comment on the current 1.4.2. Please use better field names! Just a few I found just starting to use Geeklog are field names like "Date" and "Comment". These are reserved words in many applications and are just terrible in general to use as a field name. I'm sure there are more. Go to this reserved word checker site http://www.petefreitag.com/tools/sql_reserved_words_checker/ and check the names against it. Thanks

Status: offline


Forum User
Full Member
Registered: 08/04/03
Posts: 1298
I remember Mambo having used MySQL reserved words and they had terrible problems e.g. when sombody did an automatic backup through cpanel.

All times are EDT. The time is now 12:57 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content