[Beta 1.5.1RC1 & 1.4.1] Photo Gallery Mod

[dschwab9]

I'm still having problems uploading pics.  
I tried setting the full path, but nothing changed.
I still get a blank page after clicking upload.

Maybe removing the '.' did something?
But If I leave the '.' in, I get parse errors and the mod won't run.



http://www.swja.net/yabbse/gallery/

I had to rmove the "." also to get rid of the parse errors, but it hasn't caused any other problems.  I'm running PHP 4.2.1

[Nerd3d]

Yordy, your problem may be that the owner of the config file is changed (wrong). If the PhP process runs under a different user than the FTP you may not be able to delete the file (or change it) the only way I know of to fix this is to connect via telnet or SSH, logged in as root and delete the file that way. (Or chown the file to the FTP user)

chown command refrence

Free SSH client

If this is the problem and you don't have root access you may have to ask your ISP to delete the file or chown it for you.

P.S. This is a Linux/Unix thing this wouldn't apply to a Win32 server

[smacktalk]

I cant get past this:

Could not create a mySQL connection, please check the SQL values entered

MySQL error was : Access denied for user: '*****@*****' (Using password: YES)

[Spaceman-Spiff]

@ smacktalk: u should install the gallery in a subdirectory (prefered directory name is 'gallery') of the forum so it can find Settings.php in its parent directory

@ dschwab9: u're the 2nd person that reported this, a temporary fix is to change the $db_prefix . "gallery_album" into: "yabbse_gallery_album" (where yabbse_ is your db prefix)
i'll try to look into this issue again later...

@ Yordy: u cant even delete config.inc.php via FTP or your windows browser?
i dont know much about setting permissions in a windows server though... i know in *nix server, u'll need to have the file CHMOd 666 to be able to modify it via php

[babylonking]

am getting this error:

There was an error while processing a database query.
You can try to refresh the page by clicking here.

Error Returned

mySQL error: You have an error in your SQL syntax near '' at line 1

need help ? anyone!

[Spaceman-Spiff]

when did u get that message? when installing or doing something else?

[babylonking]

when i click on (gallery , Album List , Latest Uploads)
i get that error .........Gallery Settings link working fine but when i save changes i get this erorr.

While executing query "INSERT INTO  (aid, title, description, uploads, date) VALUES ('', 'babylon', '', 'YES', NOW())"

mySQL error: You have an error in your SQL syntax near '(aid, title, description, uploads, date) VALUES ('', 'babylon', '', 'YES', NOW()' at line 1

[JRCarr]

Spaceman-Spiff, I found the problem of a non-admin user not being able to delete their own comments.  In the delete.php file the following section:
   case 'comment':
      if ($AUTHORIZED){
         $query = "DELETE FROM {$CONFIG['TABLE_COMMENTS']} WHERE msg_id='$HTTP_GET_VARS[id]'";
      } else {
         $query = "DELETE FROM {$CONFIG['TABLE_COMMENTS']} WHERE msg_id='$HTTP_GET_VARS[id]' and author_id='$username'";
      }
Needs to have the variable in the "else" changed from "author_id" to msg_author".  The yabbse_gallery_comments Table contains the field msg_author not author_id.  Hope this helps any one else that have the problem.

Jack

[smacktalk]

@ smacktalk: u should install the gallery in a subdirectory (prefered directory name is 'gallery') of the forum so it can find Settings.php in its parent directory

I have it installed at www.myserver.com/forum/gallery

[Spaceman-Spiff]

thx jack for the fix

smacktalk, could u pls send me your url, so i can see the error msg, just IM me if u dont wanna give it out to public

[smacktalk]

thx jack for the fix

smacktalk, could u pls send me your url, so i can see the error msg, just IM me if u dont wanna give it out to public

Done. thanks

[dschwab9]

@ dschwab9: u're the 2nd person that reported this, a temporary fix is to change the $db_prefix . "gallery_album" into: "yabbse_gallery_album" (where yabbse_ is your db prefix)
i'll try to look into this issue again later...

Spaceman, I don't use a database prefixe for yabbse, my tables are simply "members", "messages", etc.
Could it be that the script can't handle a lack of db prefix?  ie: even if there is no prefix, something gets appended to the querries.
In my case, just deleting the dots made it work.

[Spaceman-Spiff]

the problem must've been in the installer then...

[dschwab9]

the problem must've been in the installer then...

The tables were created correctly, though.

[Yordy]

Yordy, your problem may be that the owner of the config file is changed (wrong). If the PhP process runs under a different user than the FTP you may not be able to delete the file (or change it) the only way I know of to fix this is to connect via telnet or SSH, logged in as root and delete the file that way. (Or chown the file to the FTP user)

chown command refrence

Free SSH client

If this is the problem and you don't have root access you may have to ask your ISP to delete the file or chown it for you.

P.S. This is a Linux/Unix thing this wouldn't apply to a Win32 server

I think you are right.
The host indeed runs a Linux server with Apache.
Damn, you guys are helpfull, thanks  
I will try to use tellnet or SSH to change it.
Thanks again.