[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!
Scam Warning
User avatar
nickvergessen
Former Team Member
Posts: 4397
Joined: Mon Apr 30, 2007 5:33 pm
Location: Stuttgart, Germany
Name: Joas Schilling
Contact:

Re: [Beta] phpBB Gallery 0.4.1 (including TS Gallery converter)

Post by nickvergessen »

yes, just follow the steps of the contrib/convert.xml
No Support via PM
toomedic
Registered User
Posts: 141
Joined: Tue Apr 15, 2008 6:31 am

Re: [Beta] phpBB Gallery 0.4.1 (including TS Gallery converter)

Post by toomedic »

I had trouble with this Mod, My mysql database is prefixed different than "phpbb_" Has anyone else had this happen? Is there just sql changes one can do to make this work when your database is prefixed different? rather than run the install program?
User avatar
ameisez
Registered User
Posts: 1166
Joined: Sun Nov 04, 2007 7:04 am

Re: [Beta] phpBB Gallery 0.4.1 (including TS Gallery converter)

Post by ameisez »

What sort of error do you have? Mine is also not phpbb_ but mine is just fine.
PHPBB on HOSTGATOR SERVER. MY PERSONAL CHOICE ;)
Need phpBB images and buttons? HIRE ME
my MOD: BB3 Media Player | a phpbb based media player
User avatar
Bruno36
Registered User
Posts: 287
Joined: Fri Mar 02, 2007 2:16 pm
Location: france
Name: bruno astie
Contact:

Re: [Beta] phpBB Gallery 0.4.1 (including TS Gallery converter)

Post by Bruno36 »

Hello!

J'ai installer phpBB Gallery 0.5.0

When I click http://www.scooter-chinois-4t.com/gallery/index.php I receive an error
Erreur générale
SQL ERROR [ mysql4 ]

Erreur de syntaxe pr�s de ') ORDER BY c.comment_id DESC LIMIT 4' � la ligne 6 [1064]

SQL

SELECT c.*, i.* FROM phpbb_gallery_comments c LEFT JOIN phpbb_gallery_images i ON c.comment_image_id = i.image_id WHERE i.image_album_id = '1' ) ORDER BY c.comment_id DESC LIMIT 4

BACKTRACE

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

FILE: includes/db/mysql.php
LINE: 221
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()

FILE: gallery/includes/functions_recent.php
LINE: 213
CALL: dbal->sql_query_limit()

FILE: gallery/index.php
LINE: 140
CALL: recent_gallery_images()
Last edited by Bruno36 on Sat Mar 07, 2009 12:34 pm, edited 1 time in total.
Excuse me for my poor English, I speak french
Bruno36
User avatar
ameisez
Registered User
Posts: 1166
Joined: Sun Nov 04, 2007 7:04 am

Re: [Beta] phpBB Gallery 0.4.1 (including TS Gallery converter)

Post by ameisez »

Did you finish the installer (and all DIY instructions) successfully from the install instruction?
PHPBB on HOSTGATOR SERVER. MY PERSONAL CHOICE ;)
Need phpBB images and buttons? HIRE ME
my MOD: BB3 Media Player | a phpbb based media player
User avatar
Bruno36
Registered User
Posts: 287
Joined: Fri Mar 02, 2007 2:16 pm
Location: france
Name: bruno astie
Contact:

Re: [Beta] phpBB Gallery 0.4.1 (including TS Gallery converter)

Post by Bruno36 »

Yes the mod was installed successfully.
No error message
Excuse me for my poor English, I speak french
Bruno36
User avatar
nickvergessen
Former Team Member
Posts: 4397
Joined: Mon Apr 30, 2007 5:33 pm
Location: Stuttgart, Germany
Name: Joas Schilling
Contact:

Re: [Beta] phpBB Gallery 0.4.1 (including TS Gallery converter)

Post by nickvergessen »

just remove the db stuff an install 0.4.1
0.5.0 is not supported (ment for the testers only) thats why it has unsupported in its file name and is not mentioned as last/current version everywhere! :?
No Support via PM
Darkwander
Registered User
Posts: 108
Joined: Mon Aug 23, 2004 5:15 pm

Re: [Beta] phpBB Gallery 0.4.1 (including TS Gallery converter)

Post by Darkwander »

I am getting the following error when i try and delete a certain image, however i have deleted 5 others without a problem.
General Error
SQL ERROR [ mysql4 ]

Out of range value adjusted for column 'user_images' at row 1 [1264]

SQL

UPDATE phpbb_gallery_users SET user_images = user_images - 1 WHERE user_id = '81'

BACKTRACE


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

FILE: gallery/includes/functions.php
LINE: 512
CALL: dbal_mysql->sql_query()

FILE: gallery/mcp.php
LINE: 228
CALL: handle_image_counter()
Darkwander
Registered User
Posts: 108
Joined: Mon Aug 23, 2004 5:15 pm

Re: [Beta] phpBB Gallery 0.4.1 (including TS Gallery converter)

Post by Darkwander »

Greetings;

Also have another issue on another forum;

this comes up in the "User control panel"
» UCP_GALLERY_SETTINGS
» UCP_GALLERY_PERSONAL_ALBUMS
» UCP_GALLERY_WATCH
» UCP_GALLERY_FAVORITES
I was wondering if anyone could tell me where abouts this has gone wrong,
User avatar
nickvergessen
Former Team Member
Posts: 4397
Joined: Mon Apr 30, 2007 5:33 pm
Location: Stuttgart, Germany
Name: Joas Schilling
Contact:

Re: [Beta] phpBB Gallery 0.4.1 (including TS Gallery converter)

Post by nickvergessen »

Darkwander wrote:Greetings;

Also have another issue on another forum;

this comes up in the "User control panel"
» UCP_GALLERY_SETTINGS
» UCP_GALLERY_PERSONAL_ALBUMS
» UCP_GALLERY_WATCH
» UCP_GALLERY_FAVORITES
I was wondering if anyone could tell me where abouts this has gone wrong,
You are missing a language file (mods/info_ucp_gallery.php)
Darkwander wrote:I am getting the following error when i try and delete a certain image, however i have deleted 5 others without a problem.
General Error
SQL ERROR [ mysql4 ]

Out of range value adjusted for column 'user_images' at row 1 [1264]

SQL

UPDATE phpbb_gallery_users SET user_images = user_images - 1 WHERE user_id = '81'

BACKTRACE


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

FILE: gallery/includes/functions.php
LINE: 512
CALL: dbal_mysql->sql_query()

FILE: gallery/mcp.php
LINE: 228
CALL: handle_image_counter()
run this sql before deleting, I think I already fixed that in SVN

Code: Select all

UPDATE phpbb_gallery_users SET user_images = user_images + 1 WHERE user_id = '81'
No Support via PM
Darkwander
Registered User
Posts: 108
Joined: Mon Aug 23, 2004 5:15 pm

Re: [Beta] phpBB Gallery 0.4.1 (including TS Gallery converter)

Post by Darkwander »

nickvergessen wrote:
Darkwander wrote:Greetings;

Also have another issue on another forum;

this comes up in the "User control panel"
» UCP_GALLERY_SETTINGS
» UCP_GALLERY_PERSONAL_ALBUMS
» UCP_GALLERY_WATCH
» UCP_GALLERY_FAVORITES
I was wondering if anyone could tell me where abouts this has gone wrong,
You are missing a language file (mods/info_ucp_gallery.php)
That is what i thought so i uploaded the file again, however still happening.
Darkwander
Registered User
Posts: 108
Joined: Mon Aug 23, 2004 5:15 pm

Re: [Beta] phpBB Gallery 0.4.1 (including TS Gallery converter)

Post by Darkwander »

Darkwander wrote:I am getting the following error when i try and delete a certain image, however i have deleted 5 others without a problem.
General Error
SQL ERROR [ mysql4 ]

Out of range value adjusted for column 'user_images' at row 1 [1264]

SQL

UPDATE phpbb_gallery_users SET user_images = user_images - 1 WHERE user_id = '81'

BACKTRACE


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

FILE: gallery/includes/functions.php
LINE: 512
CALL: dbal_mysql->sql_query()

FILE: gallery/mcp.php
LINE: 228
CALL: handle_image_counter()
run this sql before deleting, I think I already fixed that in SVN

Code: Select all

UPDATE phpbb_gallery_users SET user_images = user_images + 1 WHERE user_id = '81'
Thanks that worked.
Darkwander
Registered User
Posts: 108
Joined: Mon Aug 23, 2004 5:15 pm

Re: [Beta] phpBB Gallery 0.4.1 (including TS Gallery converter)

Post by Darkwander »

Darkwander wrote:
nickvergessen wrote:
Darkwander wrote:Greetings;

Also have another issue on another forum;

this comes up in the "User control panel"
» UCP_GALLERY_SETTINGS
» UCP_GALLERY_PERSONAL_ALBUMS
» UCP_GALLERY_WATCH
» UCP_GALLERY_FAVORITES
I was wondering if anyone could tell me where abouts this has gone wrong,
You are missing a language file (mods/info_ucp_gallery.php)
That is what i thought so i uploaded the file again, however still happening.
I re-uploaded all the language files just to make sure, still doing it.
Darkwander
Registered User
Posts: 108
Joined: Mon Aug 23, 2004 5:15 pm

Re: [Beta] phpBB Gallery 0.4.1 (including TS Gallery converter)

Post by Darkwander »

Darkwander wrote:
Darkwander wrote:
nickvergessen wrote:
Darkwander wrote:Greetings;

Also have another issue on another forum;

this comes up in the "User control panel"
» UCP_GALLERY_SETTINGS
» UCP_GALLERY_PERSONAL_ALBUMS
» UCP_GALLERY_WATCH
» UCP_GALLERY_FAVORITES
I was wondering if anyone could tell me where abouts this has gone wrong,
You are missing a language file (mods/info_ucp_gallery.php)
That is what i thought so i uploaded the file again, however still happening.
I re-uploaded all the language files just to make sure, still doing it.
just also noticed that in the admin panel under Mods, they are doing the same thing;
You are logged in as:
Darkwander [ Logout ][ ACP Logout ]

PHPBB_GALLERY
ACP_GALLERY_OVERVIEW

ACP_GALLERY_CONFIGURE_GALLERY

ACP_GALLERY_MANAGE_ALBUMS

ACP_GALLERY_ALBUM_PERMISSIONS

ACP_IMPORT_ALBUMS

ACP_GALLERY_CLEANUP
Darkwander
Registered User
Posts: 108
Joined: Mon Aug 23, 2004 5:15 pm

Re: [Beta] phpBB Gallery 0.4.1 (including TS Gallery converter)

Post by Darkwander »

I fixed it by uploading the files that i edited again, i was it was something in "Includes" directory.
Locked

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