Hi everyone, I have a problem I'd like to see if anyone can help me with please.
During setup the script cant find mysql database that does exist and I asked my hosting provider to help and our conversation is below.
miketa: Hello! How may I help you?
Visitor32750: please help. i have a webstore script that is asking me for What is the database host? The database host can be in the form of a host name, such as 'db1.myserver.com', or as an IP-address, such as '192.168.0.1'.
miketa: try localhost
Visitor32750: tried it
Visitor32750: says database does not exist
miketa: well what database name, database username and database password are you using?
Visitor32750: "private information given"
miketa: your database login is working fine
miketa: tell me where the script is please
miketa: pro8.abac.com is the name of the server
Visitor32750: "I told miketa where the script is"
miketa: both pro8.abac.com and localhost should work
Visitor32750: ill try pro8.abac.com
miketa: where is the configuration file?
Visitor32750: "I told miketa where the file was"
miketa: aare you trying to use root as login?
Visitor32750: no
Visitor32750: i installed this script into a test folder to try it out
miketa: ok what are you putting in the different fileds at the link you gave me?
miketa: the Database Host Database Username Database Password Database Name is what im interested in
Visitor32750: pro8.abac.com "username private" "password private"
Visitor32750: ive tried localhost
Here is where he finds the problem
miketa: 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 'upgrade_exceptions' at line 1
miketa: in:
miketa: [DROP TABLE IF EXISTS zen_ upgrade_exceptions;]
miketa: thats the error that i get
miketa: that means that localhost is working fine
miketa: and you have a problem with your tables
Visitor32750: ok so there is an error in the script
Visitor32750: right?
miketa: yes
miketa: or rather in the tables
miketa: not too sure what is this thing trying to do
Visitor32750: thank you ill get with the author immediately
miketa: but it is getting to the tables
Visitor32750: you have been a great help.
miketa: thank you
miketa: have a nice day
Bookmarks