Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

WordPress

Posted by samer riachi
samer riachi
1,328 Points

I get error when installing wordpress. How can i fix that?

I get : Could not make the query numbered : 30 MySQL Error No : 1064 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 '1, 1, now(), now(), 'WordPress is an award-winning web software, used by million' at line 1

2 Answers

Erin Zygaitis
Erin Zygaitis
8,460 Points
Erin Zygaitis
Erin Zygaitis
8,460 Points

I had this same problem yesterday. I was using Wed Hosting for Students. I opened a support ticket with them and they fixed the problem in a few hours. I found no way to fix it myself.

Here is their reply: Hi,

We are reinstalling our auto installer suite, which should solve the problem. Our apologies for the inconvenience. We'll let you know as soon as we've tested a WP install on your account.

Thanks! Support

Web Hosting for Students

samer riachi
samer riachi
1,328 Points

Oh you are a hero ! Thanks for your reply , i sat 3 hours trying to figure it out yesterday . I tried again now and It just worked :) . Cheers

Gloria Dwomoh
Gloria Dwomoh
13,116 Points
Gloria Dwomoh
Gloria Dwomoh
13,116 Points

I answered a similar question earlier so i'd post that.

Are you doing the manual install? If yes, it says " You have an error in your SQL syntax" so somewhere when creating the database some query was written wrongly. Either try finding the bug or do the 1 click install (if you have done it already then wordpress is already installed.) You can also check out this post for more tips on what others tried to do to solve that issue, but overall it says you have a syntax error so finding that might be the solution.

samer riachi
samer riachi
1,328 Points

Thanks for your reply. Sorry I amvery new to that. But in the video i notice they say to contact my hosting company for "one click wordpress install". In that case is Cpanel my hosting company or who?

Gloria Dwomoh
Gloria Dwomoh
13,116 Points

No your hosting company is the place/website that you access cpanel from. Where is that? Also have you done the 1 click one? Are you in the 5 min one?

samer riachi
samer riachi
1,328 Points

I am following the steps in the videos given by the course. I assume my host would be webhostingforstudents.com . Do you think I should contact them ?

Gloria Dwomoh
Gloria Dwomoh
13,116 Points

In the website it says "Unfortunately we cannot provide phone support or support for 3rd party services and software. We would love to, but our student level prices don't allow us to at this time." Your hosting does provide the 1 click install, when you log into it...the user interface you see with the several icons and tools is the cPanel. There should be an icon called "WordPress". The instructor shows how it is done so try rewatching the video.

samer riachi
samer riachi
1,328 Points

I watched the video few times already, and I am following it step by step . Still getting the same error. I am doing the 5 min one, I dont know where the 1 click one is . Any ideas?

Gloria Dwomoh
Gloria Dwomoh
13,116 Points

This is the WordPress 1 Click install.

Ps if you have issues findinf cPanel, upload a screenshot of what you see when you log into your hosting account at the student webhosting. Maybe I can help you figure out your cpanel.