X3Photo Gallery Forums

arnaudduluoz · 10 Dec 2013, 03:26

Hi everybody,

I installed powerPack successfully and I first want to congratulate its creator. But I encounter two different problems :

1) I have a problem with the SQL manager. I think I've filled the form in with good informations but nithing happens when I validate it and I still have the same message :

Couldn't connect to MySQL database.
Check Host name, User name and Password!

I've checked the informations with my hoster and it seems that they're valids : Host name : localhost ; username : the username of my SQL database ; password : my password ; database name : imagevue (name given to the database I created especially).
Can someone help me with this ?

2) I have another problem with the blur effect that may appear when I open the news module or the comments module. Instead of this, my background becomes grey. You can have a look at the problem by visiting my site : http://www.arnaudduranthon.fr.

Thank you in advance for your help,

Best regards,

Arnaud

arnaudduluoz · 15 Dec 2013, 11:33

Up... Can someone help me ?

I just want to add that the blur effects seems to work sometimes... One time it works, another it doesn't... Weird !

Thanks

Arnaud

Artur · 16 Dec 2013, 10:01

Hello.

If you have access to your SQL panel, download ->this<- file and import it to your SQL.
It will install for you tables "Votes" and "Guestbook".

As for the grey background. It happens when the page contains any link or image with http:// in front (it may be even icon in your menu loaded via http)

arnaudduluoz · 16 Dec 2013, 12:16

Hi Artur,

Thank you very much for your help.

1 - The problem with the blur effect seems to be resolved, by removing the http:// link of the logo.

2 - I installed the tables in my SQL base. Unfortunately the problem is not resolved and, when I try to access the guestbook, the following message appears in a red box :

Access denied for user 'arnaudduranthon'@'localhost' (using password: YES) !

I've checked all the informations in the SQLdata.php file and everything seems to be quite good... I don't understand why the connection between my site and the SQL database doesn't work. Do you have any idea of where the problem might come from ?

Thanks a lot for your help,

Arnaud

Artur · 16 Dec 2013, 12:28

This SQL information says:
The password is worng, or specified username don't have rights to access this database.

Try to open file: extras/userFiles/SQLdata.php and check if there's everything ok.
Some of the hosting providers attaching to server requests additional informations (like website statistics script)

arnaudduluoz · 17 Dec 2013, 09:49

Hi Artur,

The SQL problem has been resolved by adding a .php file at root containing this code :

<meta charset="UTF-8">
<?php
	
	/* Fichier de test créé par HostArea */
	$sql = mysql_connect("localhost","username","password") or die("Erreur de connexion au serveur MySQL!");
	$db = mysql_select_db("databasename") or die("Erreur de sélection de la base de données!");
	
	if($sql){
		echo "Connexion à MySQL réussie!";
	}
	if($db){
		echo "Sélection de la base réussie!";
	}
	
?>

My hoster helped me to find the problem and created this file to facilitate the connection. I can't explain why it's working now, but it is...

Thanks a lot for your help,

Arnaud

X3Photo Gallery Forums

SQL problem6 posts

SQL problem

Re: SQL problem

Re: SQL problem

Re: SQL problem

Re: SQL problem

Re: SQL problem