Error when uploading any joomla component

Asked by:
Doubs Time:
2013-01-05 12:00 pm Category:
Joomla Hits:
229
Hello
I bought yesterday a hosting for a joomla website. I could easly publish it and started to work on it.
But the troubles started when I wanted to upload a component. Then I got a long error message "JInstaller::install: SQL Error. DB function failed with error number 1064.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 20 SQL=CREATE TABLE IF NOT EXISTS..................................."
And so for every component I tried to upload. I did some research and discover that one can fix it manually by editing sql file. But if I have to do that for every single component I will upload I just cannot.
Can you resolve this please?
Have a great day!

You must login before you can ask a follow up question.

You must login before you can submit an answer.

OTHER ANSWERS

0

ScottM
2013-01-07 2:35 pm
Hello Doubs,

It appears the reason is due to the components expecting a lower version of MySQL than the server has installed. We may be able to move you to another server that has an older version, or the .sql file can be edited to change the command 'TYPE=MyISAM' to 'ENGINE=MyISAM'.

Please let us know if you need any further assistance with the issue.

Best Regards,
Scott M

You must login before you can post a comment about this answer.
Like this Question?

Support Center Login

Have a Question?

If you need some help, submit your question to our Community! We guarantee a response within 60 minutes (8am - 9pm EST, Monday - Friday)

Recent Questions

  1. Site under brute force attack
  2. URLs in Installation of WordPress Don't Redirect
  3. Choosing a Directory With WordPress

Support Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.) 		Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.