MySQL Error Help

by 6 replies
7
Hi all, I'm trying to install Ultimate Footer Ad (email php software) to my website, but I keep getting getting this error message

MySQL Error: 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 'TYPE=MyISAM' at line 7 (Database = XXXXX_XXXXXX)

I go to my php admin dashboard from Hostgator to look at it, but my new database has no tables, and i dont know how to write up one to update my mysql.

MySQL
  • Server: Localhost via UNIX socket
  • Server version: 5.5.21-55
  • Protocol version: 10
  • User: krystio@localhost
  • MySQL charset: UTF-8 Unicode (utf8)
I don't know if my version is out of date to this version of UFAv2.1


please help someone
#programming #error #mysql
  • From what I gather, the MySQL database the script is trying to import/install is outdated. Since MySQL 5, any parts in the database file that read...

    ... need to be replaced with:

    If you can find the file in question (it'll probably have a .sql file-extension), open it up in Notepad and use the "find and replace" to make these changes. Then you should find, hopefully, that the installer works okay.

    But it does sound like you're trying to install an old version of your script. See if there's a new version available and you shouldn't have this issue.

    (EDIT: Indeed, I've seen references to v3.04 on the 'net, so you're well and truly out of date, it seems. :p)
  • Thats true.

    TYPE keyword is deprecated (since 5.0) and not supported in MySQL5.5

    So get ready to spend $37
  • Hey thanks for the advice, the only bad part is now that this coding, or updating is beyond me... any links I can use to download an update, or video to watch how to update, or any willing programmers that can work out a deal with me here.. offers open
  • i think it's not very hard.
    you only need a free text editor, such as notepad++
    and replace all TYPE=MyISAM to ENGINE=MyISAM
    that's it
    • [1] reply
    • ok, I can do some code - once i find the script to edit then save I believe that'll resolve my doubts, but right now i'm not sure where to begin with looking for the script
      • [1] reply
Join the discussion

Next Topics on Trending Feed

  • 7

    MySQL Error Help

    Hi all, I'm trying to install Ultimate Footer Ad (email php software) to my website, but I keep getting getting this error message MySQL Error: 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 'TYPE=MyISAM' at line 7 (Database = XXXXX_XXXXXX)