Random pictures

[sydawn]

Hello

sorry for that...

I keep getting:

An unexpected error occured. Please try again later.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\videohold\includes\db_mysql.php on line 116

Anywhere else?

[thunderstrike]

Is happen only that page ?

[sydawn]

Hello

Yes, only that page, on the home page it works fine but I dont need it there

[thunderstrike]

Can say if cat ID on cat table have it too on image table ? (All of them same) . Random SQL query say i.cat_id = c.cat_id.

[sydawn]

Hello

I am not quite sure I understand what you are saying, is that in reference to Categories?

[thunderstrike]

CATEGORIES_TABLE - > cat_id
IMAGES_TABLE - > cat_id

have all match cat_id with both table ?

Random SQL query say in code - > i.cat_id = c.cat_id two of cat_id must match same (CATEGORIES_TABLE + IMAGES_TABLE).

[sydawn]

Hi

I put that in the SQL query, the tables I got from my Phpmyadmin and are below

http://66.79.166.100/image%20cat.JPG

http://66.79.166.100/cat%20cat.JPG

I really appreciate you helping me out, Im proficient on most things but SQL etc just gets to me 

[thunderstrike]

Good but select structure. Just left - Browse and post screenshots another. 

Get there good. Keep at it.

[sydawn]

Hmmmm

Ok, these are the views from the browse of the tables:

http://66.79.166.100/image.htm

http://66.79.166.100/category.htm

 

[thunderstrike]

See 4 activate cats (1,2,3,4) but rest in IMAGES_TABLE compare CATEGORIES_TABLE not there. All image activate. Good.

This MOD check permission for view cats. Do you perm the cats too from ACP ? Can be prob if no.

[sydawn]

Hi

Yes in ACP the categories are permitted  (in Category settings correct)

I am getting annoyed with this package, so I may just go back to Joomla, not your fault, but its an important part, Joomla I can set this type of thing up in 5 mins no problems.

 

[thunderstrike]

Ok so change:

$sql = "SELECT 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".$additional_sql.", c.cat_name".get_user_table_field(", u.", "user_name")."
        FROM ".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c
        LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id)
        WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (".get_auth_cat_sql("auth_viewcat", $cat_id).")

[sydawn]

Thanx

I changed that and the problem is still there 

[thunderstrike]

Just see thing:

WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (".get_auth_cat_sql("auth_viewcat", $cat_id).")

replace:

WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND (i.cat_id NOT IN (".get_auth_cat_sql("auth_viewimage", "NOTIN").", ".get_auth_cat_sql("auth_viewcat", "NOTIN")."))

know not much for this MOD but hope works.

[sydawn]

Hello

Alas...no joy...What I will do is start again on a fresh install, there are ALOT of mods on this one. Is it working for you at the moment?