Wizard Hangs at install_gallery/logininfo.php

I have deleted the tables in the database, reloaded a fresh copy of gallery files several times on the server. The installation wizard hangs at the same spot ... I get the database info put in and it actually does create the tables in the database, then it displays a blank page next "logininfo.php"

?? What am I doing wrong? I added the error display code and this is the error:

Fatal error: Call to undefined function mysql_set_charset() in /home/trader/public_html/gallery/Connections/powergallery.php on line 10

What version of my sql does your host have running? It will need to be MySQL 5.2.3 or greater.

version 5.0.77 Hmmm... So, I can't use the gallery at all?

Hi,

I also got that error (using MySQL 5.0.51a), so deleted the lines referring to mysql_set_charset() ,

$powergallery = mysql_pconnect($hostname_powergallery,
 $username_powergallery, $password_powergallery) or trigger_error(mysql_error(),E_USER_ERROR);
?>

at least it let me continue the installation, although I did get a few ascii characters inserted in the image descriptions, I assume it is connected.

I deleted the line that refers to the character set in the connection file. Got through the install. Admin page can up and said to add a gallery in order to use adming. I tried to add gallery and nothing happened.

I added back the character set line in the connection file, and the page went blank. Took it out again ... still stuck at add a gallery.

Could you add the error display code to the top of the page that you are currently stuck on?

At some point in my install I had a problem with 'free MySql results' code at the bottom of the page in question (which I deleted in order to continue).

Please note that I am an imbecile when it comes to PHP, (it all looks as if it's in code to me), and that Jason will undoubtedly have a better solution. I only post this as a) it worked for me, and b) your gallery isn't working anyway.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/trader/public_html/gallery/admin_gallery/choosegallery.php on line 59

Hi Sandy,

OK, I didn't get that error when I installed PG. What version of PowerGallery are you using, PowerGallery 121?

My 'mysql_num_rows' function comes at line 55 of my choosegallery.php page, and is part of the SELECT statement (from which it gets the number of rows in the query). The 'mysql_num_rows' error can not be caused by your version of MySql/PHP (I don't think) - as the function was around for at least PHP4. Perhaps you could try re-downloading the solution and uploading a fresh version of that page.

As I say, my PHP is dismal, but the only reason I can think of that the error is occurring is that the SELECT query isn't connecting with the database. I assume that setup has created the database OK.

I will do another setup on another (but similar) server later, and remember to make notes of any extra steps I take. I will post back if anything occurs to me.

Hiya Jason,

Just for info, the requirements as listed in the PowerGallery page are that version of MySql should be 5+ (which suggests that Sandy's and my setups should be OK!) Also step one, the requirements check, gives all green lights.

I'll try this and see what happens.

Hiya,

Here is a full list of actions on a new install:

---------------------------------------

PowerGallery 2.1.0 Install : MySql version 5.0.51a

1. Uploaded files into folder 'Gallery' in root.
2. Followed steps up to and including DB details screen, and entered relevant info.
3 logininfo.php error message:

Fatal error: Call to undefined function mysql_set_charset() in /home/users/uksXXXXXX/html/xxxxxxxxx.com/gallery/Connections/powergallery.php on line 10

mysql_set_charset('utf8',$powergallery);

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/users/uks66585/html/yeractual.com/gallery/admin_gallery/global.php on line 37

Warning: Cannot modify header information - headers already sent by (output started at /home/users/uksXXXXX/html/xxxxxxxxx.com/gallery/admin_gallery/global.php:37) in /home/users/uks66585/html/yeractual.com/gallery/admin_gallery/index.php on line 6

mysql_free_result($result);