I have problem installing Q2A to my Godaddy hosting.

Question

Hello everyone.

I have a problem trying to install Q2A to my site.

PS : I have did it to my old hosting (free one) and was everything great , also everything is okay i can install via localhost.

Now i got problems to do it via my godaddy server. I did it everything correctly but when it goes to Create Database Including User Managment i cant move to next step.Nothing appers after clicking there.

Last log from error_log.

[11-Jun-2014 00:59:37 UTC] PHP Question2Answer MySQL query error 1146: Table 'quee_db.qa_options' doesn't exist - Query: (SELECT 'options' AS selectkey, title, content FROM qa_options) UNION ALL (SELECT 'time', 'db_time', UNIX_TIMESTAMP(NOW()))

Answer 1

Probably you have installed some third-party plugins in the qa-plugins directory before the db has been setup.

These plugins are trying to access to the qa_options table before it is created.

Remove any third party plugins (those not coming with the default q2a distribution) and try to exec again the setup process.

Comments

Thanks for the responde.

What you call third-part plugins? I downloaded the latest site from official site and didn't added any new plugin from directory.

Anyway i removed all plugins from that qa-plugins directory , and i still cant go to next step ?

Any suggestion please?

---

what's the error in your error_log now ?

---

No difference , same error_log.

---

- if you check on the GoDaddy's panel the details of your database ( http://support.godaddy.com/help/article/39/viewing-your-databases-details ), do you see the database named : "quee_db" ?
- can you access to your database (for instance with phpadmin) and check if there are no tables at all ? Or only the qa_option is missing ?
- What happens if you manually exec :
www.yourq2asite.com/index.php?qa=install
?

---

Check also with your hosting provider that your database user has ALL the following permissions :
CREATE, ALTER, DELETE, INSERT, SELECT, UPDATE, LOCK TABLES

---

Thanks again for trying to help me buddy.

 - No i don't see any database with that name.
- I can access to my database but shared godaddy hosting doesnt provide me to give super-user access to the user but ofcourse they give me permissions to create databases. Is something wrong with their server for not letting me to do it , becouse another kind of scripts i can do well installation. There are not tables found in that database.
- If i open www.site.com and click "Create database Including User Menagment" nothing goes to next step just goes here "/index.php?qa=install" and nothing if i click again and again nothing happens.

I am sure my user have all permissions to do it , becouse i have arleady created tables before via wordpress or another script used.

---

I am feeling retired , tried a lot of ways but cannot find the way to do it , i wish somebody from developers of Q2A can find me a way to do it.

---

Checking directly on your website the error is a "406 not acceptable", due to mod_security. Have you contacted your hosting provider ? The rule that blocks the http request (originated by the click on the install button) should be disabled

---

They say they have no permissions to give me permission to edit mod_security in shared hosting but they let me to do tricks in my .htaccess.

I disabled the mod_security via .htaccess and still didnt worked.

---

If they are using mod_security v. 2, it is not possible to disable it using the .htaccess file , but the directives have to be included in the apache vhost section.
http://www.internetblog.org.uk/post/485/how-to-turn-off-modsecurity-for-a-site/
You should talk with godaddy about this issue.
I do not know if on cpanel you are able to modify it by yourself (some hosting providers give this possibility : http://www.inmotionhosting.com/support/website/modsecurity/disable-mod-security-via-modsec-manager )

Answer 2

Does your MYSQL user have privileges to create table?

http://stackoverflow.com/questions/11946012/how-to-add-super-privileges-to-mysql-database

Comments

Thanks for the responde.

Ofcourse the user have privileges to create tables , but in shared hosting of godaddy cannot give super-privileges to a user.

I talked with the departament and they say the user have priviliges to create tables.