Error when uploading any joomla component

Asked by:
Doubs / 5 Points
Time:
2013-01-05 4:00 pm EST
Category:
Joomla
Hits:
584
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!

To ask this user for more information, please first login.

To submit an answer, please login.

ANSWERS

0

ScottM
Staff
16,266 Points
2013-01-07 6:35 pm EST
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

To submit a comment on this answer, please first login.

Want to share this Question?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Need More Help?

Help 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.
}