Jump to content

SQL error on query Can't create table 'xuanyuan.xuan_access' (errno: 168)


Recommended Posts

hello, 

i just install prestashop get error, but i can install other php software in same mysql database.

SQL error on query Can't create table 'xuanyuan.xuan_access' (errno: 168)
thank you for help me.

Link to comment
Share on other sites

SQL-Server errors: http://www.sql-server-helper.com/error-messages/msg-1-500.aspx

 

You should contact your provider. Something wrong in your database at the moment you are trying to install. Perhaps some tables broken in it. For more information about the exact error you/your provider should read the error-logs of the server on which database is hosted.

Edited by selectshop.at (see edit history)
Link to comment
Share on other sites

For several reasons I don't suggest you to change the prefix of database tables. Some module developers use the standard which is ps_ and you will have problems when you want to buy/install non native modules.

 

You asked your provider to check the error-logs ?

Link to comment
Share on other sites

I am designer, I don't know about PHP code, and MySQL too, I use ps_ before, same error, I try to call this website, but speak French, my server provider only know about system. they don't know anything about presrshop. If you want help me check logs from server, maybe I text to you?

Link to comment
Share on other sites

As I told you, you should contact your provider, If neither standard (ps_) nor prefix change to whatever_ installs the Prestashop on your server, or delivers errors in your database it is a case for provider debug. His server has a problem and error_log of the server on which database is running should give you the reason why you cannot install. EWrror-logs are precisely and your provider should debug this error.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...