Error messages...

[Garfizh]

DB Error: Bad SQL Query: SELECT DISTINCT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, u.user_name, c.cat_name FROM photos_images i, photos_users u, photos_categories c WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND u.user_id = i.user_id AND c.cat_id = i.cat_id ORDER BY RAND()
You have an error in your SQL syntax near 'RAND()' at line 4

I think this is due to mySQL version that my host has.. 3.22.23b Any fix or any way to get around it? What does those mySQL query do anyway?

I also found 1 bug which I hope Jan could rectify .. it's posted at..

http://www.4homepages.de/forum/viewtopic.php?t=721

I also wanted to ask how can I remove the "sign up" link from the page? I don't want to let others sign up at their own will, and will instead add members manually on my own Is it possible to add a "Log Out" option at the control panel? If so, how?

Thanks!

[Garfizh]

Erm? Jan? Is that a bug?

Anyone? hello? hehe..sorry, I kinda check in everyday to see if any reply, but no one did..even Jan

[Kentorch]

no i don't think so, b4 i had this problem too but when i move host, its gone, so i think it maybe bc' of the sql server high load in ur host? i don't know

[Jan]

Your MySQL version is lower than required. Change

Code: [Select]

define('SHOW_RANDOM_CAT_IMAGE', 1);
to

Code: [Select]

define('SHOW_RANDOM_CAT_IMAGE', 0);
in "includes/constants.php

Greets Jan

[Garfizh]

Thanks Jan! You're MARVELOUS! It works again.. *hugs* hehe!

Ooh..new version! I hope the bug i mentioned is fixed! Yahoo!

One thing though, I noticed, when I place my images in "data/media" folder, after adding the images, the program creates a duplicate/COPY the images to the folder called "1" and leaves the original one at "data/media". Is this suppose to be this way? Cause if we have 10,000 images and if we just copy them..the size will double up having it MOVE to the new location seems more feasible What do you think?