Welcome to Geeklog Friday, July 10 2020 @ 07:05 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: 04/08/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 07:05 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