phpBB Gallery

nickvergessen · Post by **nickvergessen** » Tue Mar 30, 2010 10:35 am

silverstorm wrote:
panzerfaust wrote:I have two gallery tabs in the user control panel-how do I delete one?
same thing happen in my forum too.

That was asked several times:
Go to ACP > System > Administration-Control-Panel > MODs>

There you can delete one of them.

Parkpre · Post by **Parkpre** » Tue Mar 30, 2010 11:56 am

Hi,
Apologies if I have posted this in the wrong place. I have just installed this phpBB Gallery MOD but there are a few glitches for me. This one is puzzling me though.

When I click "Who is online" from the board index I receive this error, which has only happened since installing the MOD.

General Error
SQL ERROR [ mysqli ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' s.session_album_id FROM phpbb_users u, phpbb_sessions s WHERE u.user_id = s.s' at line 1 [1064]

SQL

SELECT u.user_id, u.username, u.username_clean, u.user_type, u.user_colour, s.session_id, s.session_time, s.session_page, s.session_ip, s.session_browser, s.session_viewonline, s.session_forum_id, , s.session_album_id FROM phpbb_users u, phpbb_sessions s WHERE u.user_id = s.session_user_id AND s.session_time >= 1269949773 AND s.session_user_id <> 1 ORDER BY s.session_time DESC

BACKTRACE

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

FILE: viewonline.php
LINE: 131
CALL: dbal_mysqli->sql_query()

Any help greatly appreciated

nickvergessen · Post by **nickvergessen** » Tue Mar 30, 2010 12:14 pm

Seems like you have 2 commas in a row on that query.

Should be viewonline.php line 125 near the end.

Parkpre · Post by **Parkpre** » Tue Mar 30, 2010 12:36 pm

That's great, many thanks for the quick reply! I should be more careful copy / pasting next time

Fantom3D · Post by **Fantom3D** » Tue Mar 30, 2010 2:46 pm

After successful installation of gallery mod I have troubles with registration of new users. After filling all fields they see such error:

Code: Select all

SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR user_id IN (1110, 276, 2)' at line 2 [1064]

SQL

SELECT user_id, username, user_email, user_lang, user_jabber, user_notify_type FROM phpbb_users OR user_id IN (1110, 276, 2)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->sql_error()

FILE: includes/functions_dap.php
LINE: 505
CALL: dbal_mysql->sql_query()

FILE: includes/ucp/ucp_register.php
LINE: 437
CALL: dap->notify_admin_dupe_ips()

FILE: includes/functions_module.php
LINE: 507
CALL: ucp_register->main()

FILE: includes/functions_module.php
LINE: 802
CALL: p_master->load_active()

FILE: ucp.php
LINE: 71
CALL: p_master->load()

Gallery is working fine.
forum version: 3.0.6
mysql verison: 5.0.89
You can see this trouble on my forum - http://abonentik.ru/ucp.php?mode=register

MarlyNL · Post by **MarlyNL** » Tue Mar 30, 2010 4:21 pm

I'm using the gallery mod.
It's a very nice MOD.

Is it possible to split up this mod?
So that I us one host for the Forum + Gallery.
And a Second host for the images it self?

Because my first is low on space.
And my second host has 5gb un-used space.

If anyone can help me, thanks.

Dekster · Post by **Dekster** » Tue Mar 30, 2010 4:52 pm

This Founder-thingy... only founders can see the options tab for the gallery under "MODs". Is there any easy way to make this show for any administrator, not Founders only?

Parkpre · Post by **Parkpre** » Tue Mar 30, 2010 6:02 pm

Hi, I'm getting the following error when uploading larger images. I've set the upload size limit to 15mb and still receive this message for images of 1mb. Thanks in advance for any help

Code: Select all

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 13056 bytes) in /mnt/web7/20/63/51971863/htdocs/fishyfishy/forum/gallery/includes/functions_image.php on line 164

bibiken · Post by **bibiken** » Tue Mar 30, 2010 8:05 pm

Hi Nick,
Everything works fine fore me. However, I don't know how to set permission that each user can only used his/her own images. People try to use others' images, and I don't want that happens at all. Lots of my customers are complaining.
Please help me out!
Thanks a lot!

nickvergessen · Post by **nickvergessen** » Tue Mar 30, 2010 9:35 pm

Dekster wrote:This Founder-thingy... only founders can see the options tab for the gallery under "MODs". Is there any easy way to make this show for any administrator, not Founders only?

Set the permissions for the administrators properly.

Parkpre wrote:Hi, I'm getting the following error when uploading larger images. I've set the upload size limit to 15mb and still receive this message for images of 1mb. Thanks in advance for any help

This is about the memory_limit, not the max_filesize

bibiken wrote:However, I don't know how to set permission that each user can only used his/her own images. People try to use others' images, and I don't want that happens at all. Lots of my customers are complaining.

What do you mean by use?

Parkpre · Post by **Parkpre** » Tue Mar 30, 2010 10:35 pm

nickvergessen wrote:
Parkpre wrote:Hi, I'm getting the following error when uploading larger images. I've set the upload size limit to 15mb and still receive this message for images of 1mb. Thanks in advance for any help
This is about the memory_limit, not the max_filesize

Thanks for the reply. So the memory_limit is not part of the gallery mod?
I want users to be able to upload any picture file and the gallery to resize this automatically.
Where could I go for support for this?
Cheers

craig175 · Post by **craig175** » Tue Mar 30, 2010 11:53 pm

Hi again,
I have a problem when creating a new Album. I haven't tried this since upgrading to 1.0.5, but when I tried today I got the following error:

General Error
SQL ERROR [ mysql4 ]

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

SQL

INSERT INTO phpbb_gallery_albums (parent_id, album_type, album_status, album_parents, album_name, album_desc, album_desc_uid, album_desc_options, album_desc_bitfield, album_image, album_watermark, album_sort_key, album_sort_dir, display_subalbum_list, display_on_index, display_in_rrc, left_id, right_id) VALUES (0, 1, 0, '', 'Real World Images', '', '', 7, '', '', 0, '', '', 1, 1, 1, 3, 4)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/acp/acp_gallery_albums.php
LINE: 896
CALL: dbal_mysql->sql_query()

FILE: includes/acp/acp_gallery_albums.php
LINE: 140
CALL: acp_gallery_albums->update_album_data()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_gallery_albums->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

Board url www.taskforce72.org/phpbb/
PHPBB version 3.0.7 PL1
MYSQL Version 5.0.89

The problem doesn't effect the board operation but it is stopping me create new albums

Does anyone have an idea how to fix this please

Cheers

nickvergessen · Post by **nickvergessen** » Wed Mar 31, 2010 1:57 am

Seems like you updated the files, but did not run the Update to the database with the install/

craig175 · Post by **craig175** » Wed Mar 31, 2010 3:51 am

Hi nickvergesson, the install was run, in fact I did it twice when I was trying to fix the update message, it was still there even after the upgrade.

Should I try running the install again?

Cheers

nickvergessen · Post by **nickvergessen** » Wed Mar 31, 2010 12:08 pm

But in the update tab please

advertisements