Case Sensitive

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jwashburn
    Member
    • Apr 2006
    • 99

    Case Sensitive

    I ran my test migration on my local windows XP box with no problems, now that I am doing production, I have run into a problem.

    ImpEx Database errormysql error: Invalid SQL:
    SELECT * FROM forum_MEMBERS
    ORDER BY MEMBER_ID

    I tested it with PHPMYADMIN and sure enough it doesnt work, because its case sensitive.

    If I use the query below it works fine in phpmyadmin, so I am guessing impex will work. How do I make that change

    ImpEx Database errormysql error: Invalid SQL:
    SELECT * FROM forum_members
    ORDER BY MEMBER_ID
  • jwashburn
    Member
    • Apr 2006
    • 99

    #2
    Since there are only about 20 tables, I just renamed my tables and imported from there. No biggie

    Comment

    • Jerry
      Senior Member
      • Dec 2002
      • 9137
      • 1.1.x

      #3
      What source system and database type ?
      I wrote ImpEx.

      Blog | Me

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...