[RC] phpBB Gallery 1.0.4 (including TS Gallery converter)

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment!
Anti-Spam Guide
cisco007
Translator
Posts: 129
Joined: Mon Jul 14, 2008 1:49 am
Contact:

Re: [RC] phpBB Gallery 1.0.1 (including TS Gallery converter)

Post by cisco007 »

I have that after this!

Code: Select all

		case 'critical':
			$log_type = LOG_CRITICAL;
			$sql_forum = '';
		break;
Image
pj.maybe
Registered User
Posts: 49
Joined: Sun Dec 28, 2008 3:55 pm

Re: [RC] phpBB Gallery 1.0.1 (including TS Gallery converter)

Post by pj.maybe »

Hi,

I've been having some problems restoring my board, it started with this error :

ERROR 1062 (23000) Duplicate entry for key 2

which I am sure has nothing to do with this lovely gallery mod but I am prettu sure I have found a way past that particular error now. However, when I restore my latest problem seems to have something to do with this mod, can I please get some advice on how to move forward?

A full account of what I have been doing can be found here :

http://www.phpbb.com/community/viewtopi ... &t=1611465

But for the sake of tired eyes everywhere the specific error I am dealing with at the moment reads thus :

Code: Select all

General Error
SQL ERROR [ mysqli ]

Unknown column 'display_in_rrc' in 'field list' [1054]

SQL

SELECT album_id, parent_id, album_name, album_type, left_id, right_id, album_user_id, display_in_rrc FROM phpbb_gallery_albums ORDER BY album_user_id ASC, left_id ASC

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/cache.php
LINE: 447
CALL: dbal_mysqli->sql_query()

FILE: gallery/includes/permissions.php
LINE: 42
It manifests itself when I click a username to go to the memberlist, I know it is most likely something I am doing incorrectly but cannot for the life of me figure out what that is.

Help?
aakash83
Registered User
Posts: 8
Joined: Thu Apr 09, 2009 7:44 pm

Re: [RC] phpBB Gallery 1.0.1 (including TS Gallery converter)

Post by aakash83 »

hi

I am recieving this error message after installing gallery mod 1.0.1. I am using phpbb 3.0.5.
I have made a fresh installation of phpbb on localhost.
When I click on teh gallery link on index page it shows me the following error.

Error Message is

General Error
SQL ERROR [ mysqli ]

Table 'php5.phpbb_gallery_users' doesn't exist [1146]

SQL

SELECT * FROM phpbb_gallery_users WHERE user_id = 2

BACKTRACE


FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: gallery/includes/functions.php
LINE: 43
CALL: dbal_mysqli->sql_query()

FILE: gallery/includes/common.php
LINE: 24
CALL: include('gallery/includes/functions.php')

FILE: gallery/index.php
LINE: 28
CALL: include('gallery/includes/common.php')

Please help me.
Thanks
free video tutorials ,ebooks ,windows tips
www.vupages.com
Mr.Victor
Registered User
Posts: 91
Joined: Tue Oct 23, 2007 8:17 pm

Re: [RC] phpBB Gallery 1.0.1 (including TS Gallery converter)

Post by Mr.Victor »

I have ratings enabled but I don't see anywhere to rate a photo. I made sure all permissions are correct also. Any help here?
User avatar
nickvergessen
Former Team Member
Posts: 4397
Joined: Mon Apr 30, 2007 5:33 pm
Location: Stuttgart, Germany
Name: Joas Schilling
Contact:

Re: [RC] phpBB Gallery 1.0.1 (including TS Gallery converter)

Post by nickvergessen »

Mr.Victor wrote:I have ratings enabled but I don't see anywhere to rate a photo. I made sure all permissions are correct also. Any help here?
You can not rate your own images.
aakash83 wrote:I am recieving this error message after installing gallery mod 1.0.1. I am using phpbb 3.0.5.
I have made a fresh installation of phpbb on localhost.
When I click on teh gallery link on index page it shows me the following error.
Seems like you missed to run the install/update on that board

@pj.maybe: seems like your backup is not the same version as the files
No Support via PM
Mr.Victor
Registered User
Posts: 91
Joined: Tue Oct 23, 2007 8:17 pm

Re: [RC] phpBB Gallery 1.0.1 (including TS Gallery converter)

Post by Mr.Victor »

Wow. I didn't realize you can't rate your own images. No wonder. Only one other person has uploaded pictures. I have uploaded the majority of what's on the board so I'm looking at my own photos trying to figure out what's going on. Thanks, photo ratings is working just fine. :oops:
MydnyteSyn
Registered User
Posts: 383
Joined: Sun Oct 07, 2007 10:02 am

Re: [RC] phpBB Gallery 1.0.1 (including TS Gallery converter)

Post by MydnyteSyn »

Where can I download the mod that lets me put random images from this gallery on my canver portal?
superj707
Registered User
Posts: 1136
Joined: Thu Feb 26, 2009 12:20 am

Re: [RC] phpBB Gallery 1.0.1 (including TS Gallery converter)

Post by superj707 »

I have a little bit of custom member stuff saved in the phpbb_users table that loads into each members profile memberlist_view.html page

I want to also load this onto some of the gallery html pages...

here is how the html code looks..

<!-- IF SOME_STUFF -->
{SOME_STUFF}
<!-- ENDIF -->


And to make this work I use this in memberlist.php
'SOME_STUFF' => trim(addslashes($member['some_stuff'])),


What do I add to get {SOME_STUFF} to work in some of the gallery html pages ?

I think I need a line similar to the one for memberlist.php only used somewhere in album.php.

thank you so very much in advance.




update: I tried this in album.php and it works !!

Code: Select all

	
		
	// for custom profile matching
	$sql = 'SELECT * FROM ' . USERS_TABLE . ' WHERE user_id = ' . $album_data['album_user_id'];

		$result = $db->sql_query($sql);
		$row = $db->sql_fetchrow($result);
		
		$template->assign_vars(array(
		
		
			'SOME_STUFF'     => trim(addslashes($row['some_stuff'])),

		));

		$db->sql_freeresult($result);
		// End for custom profile matching
		
Last edited by superj707 on Fri Jul 17, 2009 6:47 pm, edited 3 times in total.
superj707
Registered User
Posts: 1136
Joined: Thu Feb 26, 2009 12:20 am

Re: [RC] phpBB Gallery 1.0.1 (including TS Gallery converter)

Post by superj707 »

please, one of the expert php gurus here have a look... I bet making {SOME_STUFF} work is really easy.
Figuring this out one time will help be to figure out so much. As of now I am confused about how to make a simple mysql query properly.

If you don't understand what I am trying to do but have php skills please ask... I will jump on the chance to get some help from you.

thanks again.
User avatar
nickvergessen
Former Team Member
Posts: 4397
Joined: Mon Apr 30, 2007 5:33 pm
Location: Stuttgart, Germany
Name: Joas Schilling
Contact:

Re: [RC] phpBB Gallery 1.0.1 (including TS Gallery converter)

Post by nickvergessen »

Please ask for support in the "Support Forum" or "MOD Writers Discussion", not in this MOD Topic
No Support via PM
superj707
Registered User
Posts: 1136
Joined: Thu Feb 26, 2009 12:20 am

Re: [RC] phpBB Gallery 1.0.1 (including TS Gallery converter)

Post by superj707 »

nickvergessen wrote:Please ask for support in the "Support Forum" or "MOD Writers Discussion", not in this MOD Topic

NM I figured it out anyway.
krisbfunk
Registered User
Posts: 150
Joined: Mon Jul 10, 2006 1:47 am

Re: [RC] phpBB Gallery 1.0.1 (including TS Gallery converter)

Post by krisbfunk »

I'm coming from a large Full Album Pack gallery on phpbb2. Is there an existing migration tool that will convert this'?
User avatar
nickvergessen
Former Team Member
Posts: 4397
Joined: Mon Apr 30, 2007 5:33 pm
Location: Stuttgart, Germany
Name: Joas Schilling
Contact:

Re: [RC] phpBB Gallery 1.0.1 (including TS Gallery converter)

Post by nickvergessen »

yes, just see contrib/convert.xml for more information
No Support via PM
superj707
Registered User
Posts: 1136
Joined: Thu Feb 26, 2009 12:20 am

Re: [RC] phpBB Gallery 1.0.1 (including TS Gallery converter)

Post by superj707 »

wondering if someone can help me figure out how to add support for the universal no avatar mod ?

http://www.phpbb.com/community/viewtopi ... &t=1098215
lexie
Registered User
Posts: 1
Joined: Sat Jul 18, 2009 9:28 pm

Re: [RC] phpBB Gallery 1.0.1 (including TS Gallery converter)

Post by lexie »

I dont understand how to install the gallary, can anyone help?
Locked

Return to “[3.0.x] MODs in Development”