You are required to register before you can post. This is via a custom verification system. Please post any problems you are encountering here and I`ll do my best to respond as soon as I can. Please note that a reply WILL be posted to all queries, so do not double post. There are no guarantees
when a reply will appear but I do my best to answer all within 3/4 days max. Bumping topics won`t make the slightest difference.
IMPORTANT: Posts in English ONLY please, thank you! Any other languages will be ignored and your message deleted.
SEARCH: Use the search option to see if your question has been answered on the forum before. Or check the relevant script docs.
CUSTOMER: If you have purchased a commercial version of any of my software, using the contact option at the licence centre ensures a faster response.
AUTO DELETION: Accounts older than 5 days, with no posts or topics, are automatically deleted. Only register if you are thinking of posting.
PRIVATE MESSAGES: Private messages are currently disabled.
LINKS: Any links posted are 'NOFOLLOW' and will not be picked up by search engines.
You are not logged in.
Pages: 1
Ok...so I have gotten this error when trying to install the script....
Database Error - Check Back Later (If you are the site developer, enable "ENABLE_MYSQL_ERRORS" in the "control/connect.inc.php" file)
I don't have multiple stores or anything like that....any clues?
Thanks so much
Brenda
Offline
Ok...so I have gotten this error when trying to install the script....
Database Error - Check Back Later (If you are the site developer, enable "ENABLE_MYSQL_ERRORS" in the "control/connect.inc.php" file)
I don't have multiple stores or anything like that....any clues?
Thanks so much
Brenda
Brenda - I would still go and edit that file to Enable MYSQL Errors, this should print out a better error message than Database error. Once you get the error post back to forum and disable the MYSQL errors. It should only be turned on for troubleshooting database errors.
scarr
Offline
Hi thanks...
What should it be set to....1? It's now set to 0....
Thanks
Brenda
Offline
Yeah 1 should be to display MYSQL Error. Make the change and try the upgrade/install again. This time you should get a more detailed error, copy and paste that on the forum. Once you get the error message you can go ahead and disable that setting, you only want that enable when troubleshooting.
scarr
Offline
1 doesn't seem to enable the My SQL error properties....
Offline
Hi Brenda,
Most probably your connection information is incorrect or you have edited the connection file wrong, which is causing a fatal error.
When you changed the value to 1, did you re-upload the file? That should give you the exact error on screen.
Offline
Hi...thanks that did it...!
I didn't reupload the file...sorry....
At any rate this is the error that I received...
MYSQL DATABASE ERROR:
Code: 2005
Error: Unknown MySQL server host 'localhost..' (1)
File: /home1/nichola5/public_html/store/control/functions.php
Line: 33
Thank you...
Brenda
Offline
msbfrnj,
You may have to check with your hosting provider to find out what you need to put in the DB_Host instead of localhost. localhost should work in most cases but maybe they have it configured differently. I double checked my control/connect.inc.php file and I'm using the localhost.
my hosting provider is bluehost.com
scarr105
Offline
msbfrnj,
You may have to check with your hosting provider to find out what you need to put in the DB_Host instead of localhost. localhost should work in most cases but maybe they have it configured differently. I double checked my control/connect.inc.php file and I'm using the localhost.
my hosting provider is bluehost.com
scarr105
Correct. Some hosts have different connection hosts. In some cases an IP address, in others a different one completely. As Shane recommends check with your web host. Who is your website hosted with btw?
Offline
Bluehost is mine also...I will check with them. Although yesterday....they were thrown in a fit....they told me I didn't have to use the Php Wizard you supplied - just go to the Software Section in Cpanel and click on Php Config and click twice and you'll be fine. Wrong.... They changed their Php configuration or something two days ago.... They couldn't even figure out what their situation was to even help me.... But I'll check in with them on the local host thingy...
I'll let you know....
Thanks again
Brenda
Offline
Hi Brenda,
I never had too many issues with BlueHost if I`m honest. I`m sure the connection host used to be localhost, maybe its changed. According to their FAQ it is localhost, but that may be out of date.
Offline
Actually you're right....I've had very little problems with Bluehost in the past. They've always been very helpful.
At any rate on chat with Bluehost - after some back and forth the tech sd he couldn't help me, that this was "beyond his scope". But when I insisted that the error suggested something to do with the local host issue and asked could he please check with someone who maybe had more experience than he in this, he relented and asked someone else. He did come back and apologize and said that IT IS THE IP ADDRESS NOW!
He also gave me these instructions....
"You will need to white list your IP in your phpmyadmin.. and then use this IP 69.89.21.83 to login" As he further explained it....
"you go into the phpmyadmin and tell it that it is out to let this IP connect to this server remotely
[3:39:48 PM] your IP address from your personal computer.. not the servers IP
So....first of all...just put the ip address in where the local host was right? Second of all...I'm not sure what he means about connecting to the server remotely - from my IP address on my personal computer....HELP!! 
Thank You
Brenda
Offline
I don't think he is telling you the best way to do that, You can do everything you need to do right in Cpanel on bluehost. No need to connect directly from your PC. I wrote up a little how-to on how I got my stuff start way back when. It's assuming you are starting from the beginning so please read it through once and ask questions if you don't understand something.
I did this really quick, so please read through it to make sure you understand it.
Login to your bluehost account
When you get to the Cpanel page scroll down to the Database section
Click MYSQL DATABASES
Look and see if your cart database is listed in the Current Database list.
If not than you will need to create the database by using the Create New Database section at the top. Type name of cart database and click create.
Once the database is created go back to the current database list and make sure the new database is listed.
If you cart database is in the current database list than you just need to add a user to that database.
Now it's time to add a user to the new database. If you have current users listed you can use any of those accounts by selecting that user from the Add User To Database and selecting the database click add. On the next page select all and click add.
If you don't have a user you can create one by using the Creat New User. Once you create this new user you must add user to Database. On the next page select all and click add.
Now if you go back to the current list of Databases you should see the new database with the user field matching the new user for that database.
Now open the connection file for the cart. Please take note of the Database name that was created it will be xxxxxx_Databasename and your username will be xxxxx_User.
Making sure to plug the info into the right spots in the connection file. I would still try localhost first before the IP. I'm using bluehost right now and I use localhost.Offline
Not sure putting that in a code tag made it easy to read like I thought it would.
Login to your bluehost account
When you get to the Cpanel page scroll down to the Database section
Click MYSQL DATABASES
Look and see if your cart database is listed in the Current Database list.
If not than you will need to create the database by using the Create New Database section at the top. Type name of cart database and click create.
Once the database is created go back to the current database list and make sure the new database is listed.
If you cart database is in the current database list than you just need to add a user to that database.
Now it's time to add a user to the new database. If you have current users listed you can use any of those accounts by selecting that user from the Add User To Database and selecting the database click add. On the next page select all and click add.
If you don't have a user you can create one by using the Creat New User. Once you create this new user you must add user to Database. On the next page select all and click add.
Now if you go back to the current list of Databases you should see the new database with the user field matching the new user for that database.
Now open the connection file for the cart. Please take note of the Database name that was created it will be xxxxxx_Databasename and your username will be xxxxx_User.
Making sure to plug the info into the right spots in the connection file. I would still try localhost first before the IP. I'm using bluehost right now and I use localhost.
Offline
Hi...
I have checked what I did against what you said.... I had completed everything as stated. I also checked that database created and the database user. Everything matches.... I also tried the IP address (with and without periods in the number) I also did upload all changes to my server....
It seems now I'm getting a Http 500 internal error...
I should be trying to connect with this kind of path correct?
http://www.philandbrendanicholas.com/store/install/
Thanks
Brenda
Offline
Here is what my connect.inc.php looks like: (all values are made up)
define('DB_HOST', 'localhost');
define('DB_USER', 'talquin_user');
define('DB_PASS', 'Mypass123');
define('DB_NAME', 'talquin_cart');
define('DB_PREFIX', 'mc_');
if you were adding an IP instead of local host it would be:
define('DB_HOST', '168.75.150.125');
define('DB_USER', 'talquin_user');
define('DB_PASS', 'Mypass123');
define('DB_NAME', 'talquin_cart');
define('DB_PREFIX', 'mc_');Offline
Hi yes those are the values I had....
When I change the localhost to the IP address, this is the error report that I get...
MYSQL DATABASE ERROR:
Code: 1129
Error: Host 'box83.bluehost.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
File: /home1/nichola5/public_html/store/control/functions.php
Line: 33
When it's back to localhost this is what I get....
MYSQL DATABASE ERROR:
Code: 1044
Error: Access denied for user 'nichola5_leah'@'localhost' to database 'MaianCart'
File: /home1/nichola5/public_html/store/control/functions.php
Line: 36
P.S. that is my user and database name....
Any ideas?
thanks
brenda
Offline
Hi yes those are the values I had....
When I change the localhost to the IP address, this is the error report that I get...
MYSQL DATABASE ERROR:
Code: 1129
Error: Host 'box83.bluehost.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
File: /home1/nichola5/public_html/store/control/functions.php
Line: 33When it's back to localhost this is what I get....
MYSQL DATABASE ERROR:
Code: 1044
Error: Access denied for user 'nichola5_leah'@'localhost' to database 'MaianCart'
File: /home1/nichola5/public_html/store/control/functions.php
Line: 36P.S. that is my user and database name....
Any ideas?
thanks
brenda
I see that second error message sometime when I'm coding. Usually ends up that I'm trying to connect to a different Database than the one I think I'm tryingto connect to.
In this case if MaianCart is your database than in your connection file you should have 'nichola5_MaianCart' as the name of the Database. Bluehost will always add the nichola5_ in front of all users and databases.
Please double check the database name on the connection file if it says MaianCart change it to nichola5_MaianCart. Make the change if needed and reupload file.
scarr105
Offline
Mr. Scarr.....that was it...!! I have been playing with this thing for 3 or 4 days now..... Thank you sooooooo much!!
That's exactly what happened! Bluehost put the nichola5 in front of Maian Cart....I didn't in the connection file... Whew!!
Ok....onward.....
Again, thank you...
Brenda
Offline
No problem, David put together a great product and is very helpful when we have issues or questions, so please keep posting and helping others if and when you can. Just glad I was able to help.
Good luck,
scarr105
Offline
Glad you got it sorted Brenda and thanks for helping out Shane.
Offline
Thank You!!!
Offline
Pages: 1