My Gallery Code

[Leo]

Why I can't create an album ? I get error "Failed to create Album 'A test album'!

[SniffTheGlove]

This is an failure to in the MySQL operation,

Check you have the right code in db.inc (username, password etc) for your MySQL database.
Check you have already created the right database AlbumFolder with the right privileges.

Code Select Expand


include("db.inc");
$sql = "INSERT INTO AlbumFolder (AlbumDescription,AlbumDisplayDate) VALUES ('$AlbumDescription','$AlbumDisplayDate')";
$result = mysql_query($sql) or die("<h3>Album Error</h3><p><font class='smalltext'>Failed to create Album '$AlbumDescription'!<p><b><a href=javascript:history.go(-1)>Try again</a> or <a href='albums.htm'>Choose an album to view</a></b><br><p><a href='".$CopyrightSite."' target='_Blank'>".$Copyright."</a></font>");



[Leo]

Hmm... all the other pages that have "include("db.inc");" work, why not this one ? And the database is in place.

*Edit, I fixed it by renaming the database from "albumfolder" to "AlbumFolder". However I now get another error, when I try to view an album I get error "albums.htm" not found!

[SniffTheGlove]

Ahm the naming convention. That's like I said in my first post. This code was written and run on a Windows box and you're running under unix.


OK, as for album.htm there is a problem that I have noticed a few odd links back to albums.htm, so you will need to replace those links with pg_albums.php.  I must of missed thoses out when going through the code before uploading it on 6th October.

OK, now these links back albums.htm (now pg_albums.php) was only static links and not part of creating an album so I am at a miss that may be the problem. Did you use the zip file from my 6th October post for the code?

At what point do you get the error message, after clicking Submit Album or somewhere else?

let me know.

[MinasC]

does it support import of images i have uploaded in another server e.g. imageshack ??