7 {{ upvoteCount | shortNum }}
7 {{ upvoteCount | shortNum }}

MySQL Error Help

by fenixraine
6 replies
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
#error #mysql
  • Profile picture of the author DireStraits
    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...

    TYPE=MyISAM
    ... need to be replaced with:

    ENGINE=MyISAM
    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)
    {{ DiscussionBoard.errors[6230638].message }}
  • Profile picture of the author Fahmzie
    Thats true.

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

    So get ready to spend $37
    {{ DiscussionBoard.errors[6232354].message }}
  • Profile picture of the author fenixraine
    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
    {{ DiscussionBoard.errors[6232510].message }}
  • Profile picture of the author ivankristianto
    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
    {{ DiscussionBoard.errors[6234212].message }}
    • Profile picture of the author fenixraine
      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
      {{ DiscussionBoard.errors[6234769].message }}
      • Profile picture of the author DireStraits
        Originally Posted by fenixraine View Post

        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
        It's not likely a script, per se, that you're looking for but a database file, probably with a .sql file-extension, like I say.

        Easiest thing to do, perhaps, would be to run a wildcard *.sql search on the local folder containing your script using your OS's search function.

        If you find it, make the change mentioned above to the appropriate file (remember to replace all instances, not just the first one), save it, and upload it to the appropriate place, overwriting the version on your host's server. Then try to install the script again.
        {{ DiscussionBoard.errors[6234796].message }}

Trending Topics