Messages

61

Mods & Plugins (Releases & Support) / Re: [MOD] All Comments (Alle Kommentare) V.1.1

« on: March 23, 2006, 07:17:53 AM »

Vano and Mawenzi, thanks alot guys! It works finally, really appreciate spending time to reply my posts. I am one happy webmaster! 

Btw, below the pics it says Anonymous, is it because i dont have the other two mods? Below is the link to my comments_all.php:
http://www.ktmrailwayfan.com/pics/comments_all.php

62

Mods & Plugins (Releases & Support) / Re: [MOD] All Comments (Alle Kommentare) V.1.1

« on: March 22, 2006, 04:27:54 PM »

Thanks again for your reply. After changing c.userid to c.user_id, i get a different error below:

Code: [Select]

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, u.user_id, u.user_level, u.username FROM 4images_images i, 4images_categories c LEFT JOIN phpbb_users u ON (u.user_id = i.user_id) WHERE i.image_id = 10341 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, u.user_id, u.user_level, u.username FROM 4images_images i, 4images_categories c LEFT JOIN phpbb_users u ON (u.user_id = i.user_id) WHERE i.image_id = 10327 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, u.user_id, u.user_level, u.username FROM 4images_images i, 4images_categories c LEFT JOIN phpbb_users u ON (u.user_id = i.user_id) WHERE i.image_id = 10366 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, u.user_id, u.user_level, u.username FROM 4images_images i, 4images_categories c LEFT JOIN phpbb_users u ON (u.user_id = i.user_id) WHERE i.image_id = 10366 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, u.user_id, u.user_level, u.username FROM 4images_images i, 4images_categories c LEFT JOIN phpbb_users u ON (u.user_id = i.user_id) WHERE i.image_id = 5605 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, u.user_id, u.user_level, u.username FROM 4images_images i, 4images_categories c LEFT JOIN phpbb_users u ON (u.user_id = i.user_id) WHERE i.image_id = 6231 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, u.user_id, u.user_level, u.username FROM 4images_images i, 4images_categories c LEFT JOIN phpbb_users u ON (u.user_id = i.user_id) WHERE i.image_id = 8544 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, u.user_id, u.user_level, u.username FROM 4images_images i, 4images_categories c LEFT JOIN phpbb_users u ON (u.user_id = i.user_id) WHERE i.image_id = 10366 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, u.user_id, u.user_level, u.username FROM 4images_images i, 4images_categories c LEFT JOIN phpbb_users u ON (u.user_id = i.user_id) WHERE i.image_id = 10324 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, u.user_id, u.user_level, u.username FROM 4images_images i, 4images_categories c LEFT JOIN phpbb_users u ON (u.user_id = i.user_id) WHERE i.image_id = 10366 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

I have changed all userid to user_id at comments_all.php. What could be the problem this time? Thanks.

63

Mods & Plugins (Releases & Support) / Re: [MOD] All Comments (Alle Kommentare) V.1.1

« on: March 21, 2006, 06:18:49 AM »

Thanks for the reply. I tried afew but it still doesn't seem to work. Below are my tables, any idea which one? Also, i have PHPBB integration, possible if it's in PHPBB table? Thanks for your replies, appreciate your help.

4images_4images
http://i1.tinypic.com/rvhlsi.jpg

4images_comments
http://i1.tinypic.com/rvhm2u.jpg

4images_users
http://i1.tinypic.com/rvhm4i.jpg

64

Mods & Plugins (Releases & Support) / Re: [MOD] All Comments (Alle Kommentare) V.1.1

« on: March 20, 2006, 07:17:12 PM »

Thanks. I thought that was for error.html. I manage to log in to my PHPMYADMIN but where am i suppose to search? phpbb_users or 4images_users?

65

Mods & Plugins (Releases & Support) / Re: [MOD] All Comments (Alle Kommentare) V.1.1

« on: March 19, 2006, 07:22:43 PM »

Where can i get the content? I cant find it on the frontpage. Please guide me, just basic ideas and i will try from there. My knowlegde on PHP and SQL is very limited. Thanks for the reply btw, appreciate it alot. 

66

Mods & Plugins (Releases & Support) / Re: [MOD] All Comments (Alle Kommentare) V.1.1

« on: March 19, 2006, 05:07:13 PM »

Thanks for the prompt reply. I will search for my column name. My comments_all.html is here http://www.ktmrailwayfan.com/pics/templates/default/comments_all.html . It's empty right? Sorry for bugging you guys, my knowledge on this is very limited.

67

Mods & Plugins (Releases & Support) / Re: [MOD] All Comments (Alle Kommentare) V.1.1

« on: March 19, 2006, 02:17:06 PM »

Sorry about it, i wont do that again. Thanks btw! 

I changed user_id to userid and i still get this error:

Code: [Select]

DB Error: Bad SQL Query: SELECT c.comment_id, c.image_id, c.userid, c.user_name AS comment_user_name, c.comment_headline, c.comment_text, c.comment_date FROM 4images_comments c LEFT JOIN 4images_images i ON (i.image_id = c.image_id) WHERE i.cat_id NOT IN (0, 0, 0) ORDER BY c.comment_date DESC LIMIT 0, 10
Unknown column 'c.userid' in 'field list'
I also get this error:

Code: [Select]

Template Error: Couldn't open Template ./templates/default/comments_all.html
Am i doing anything wrong? My link is http://www.ktmrailwayfan.com/pics/comments_all.php .  Thanks.

68

Mods & Plugins (Releases & Support) / Re: [MOD] All Comments (Alle Kommentare) V.1.1

« on: March 18, 2006, 07:56:33 PM »

I have a problem, i get database error. Is this something to do with my PHPBB integration? Below is my URL:

http://www.ktmrailwayfan.com/pics/comments_all.php

Thanks. 

69

Mods & Plugins (Releases & Support) / Re: [MOD] All Comments (Alle Kommentare) V.1.1

« on: March 18, 2006, 06:11:42 PM »

Thanks alot man!! 

70

Mods & Plugins (Requests & Discussions) / Simple Latest Comments page

« on: March 18, 2006, 09:15:08 AM »

Hey everyone. I am just wondering, how can i do a simple latest comments page? It's a separate page which will be linked from my mainpage(gallery ofcourse). I want to display the last 100 comments. Someone out there can help me? I would appreciate it alot! Thanks. Jason

71

Mods & Plugins (Releases & Support) / Re: [MOD] All Comments (Alle Kommentare) V.1.1

« on: March 18, 2006, 08:42:27 AM »

Will this mod work without this two:

[MOD] Universal Paging Class v1.1
[MOD] Paging for Comments


I dont want to add too many mods and have to reinstall them back when i change to new version. Thanks.

72

Mods & Plugins (Releases & Support) / Re: Integration 4images 1.7 / phpBB

« on: March 18, 2006, 08:25:00 AM »

I have a serious problem. When i visit my gallery first, it will log me off. For example, usually to visit my gallery, i log in at my forum, then click the link from there. If i visit the gallery without doing that, for example a friend emailed me a link from my gallery, then i click it, it auto log me off. Anyone knows why? I think something to do with the cookies. Thanks.

73

Mods & Plugins (Requests & Discussions) / Re: Integrating gallery in html page

« on: October 03, 2005, 07:43:04 PM »

I dont think so. Maybe if u change the extension to .php can? No idea.

74

Mods & Plugins (Requests & Discussions) / Re: What about list of last comments

« on: October 03, 2005, 07:41:04 PM »

I am looking for that mod too, cant seem to find it. It shows all New Comments on separate page and also a link to Comments Since last Visit. It's a great mod. 

75

Mods & Plugins (Releases & Support) / Re: [MOD] Last comments v1

« on: October 03, 2005, 07:05:48 PM »

Is this part 2? http://gallery.vano.org/en/showcomments


Cant wait, i will upgrade to 1.7.1 immediately after the release of part 2. Hehe.