[BETA] Photo Gallery 0.1.0

[griever]

How exactly do I run it? I noticed that in instructions but I cannot find a means to run the query. I'm using FileZilla to upload all my files to the server.

[dravekx Dravek]

ok handy! lol. I started to install and got this message on when running the gallery_db.php:

Code: Select all

SQL ERROR [ mysqli ]
Field 'gallery_desc' doesn't have a default value [1364]
SQL
INSERT INTO phpbb_gallery (gallery_name) VALUES ('Member Galleries')
BACKTRACE
FILE: ncludes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()

FILE: allery_db.php
LINE: 273
CALL: dbal_mysqli->sql_query()

[Handyman]

ok, open up gallery_db.php

FIND

Code: Select all

$sql_ary = array(
    'gallery_name'    => 'Member Galleries',
);
 

REPLACE WITH

Code: Select all

$sql_ary = array(
    'gallery_name'    => 'Member Galleries',
    'gallery_desc'    => 'Member Galleries',
);
 

Then run it again. (this was a change in one of the RC's since I made this)

[dravekx Dravek]

Got it! Ive tested your gallery on a couple different themes to see how it reacts. Honestly, the only change that needs to be made is the WHERE style_name in gallery.php and it will work. I dont know if your cool with that or not... The only issues I see are the missing upload button after install, the header issue with the bom file, the database install, and the never ending reading you must accomplish to figure out whats wrong. lol.

[Handyman]

Got it! Ive tested your gallery on a couple different themes to see how it reacts. Honestly, the only change that needs to be made is the WHERE style_name in gallery.php and it will work. I dont know if your cool with that or not... The only issues I see are the missing upload button after install, the header issue with the bom file, the database install, and the never ending reading you must accomplish to figure out whats wrong. lol.

First, make sure prosilver is installed on your board.
This MOD will not work if you don't have prosilver installed.

After you make sure prosilver is installed, for the upload image, run this query
Make sure to change the phpbb_ to your table prefix BEFORE you run this query

Code: Select all

UPDATE phpbb_styles_imageset_data
   SET imageset_id = (SELECT imageset_id FROM phpbb_styles_imageset WHERE imageset_name = 'prosilver') WHERE image_name = 'button_upload'

[dravekx Dravek]

okay... I copy/pasted that code into the SQL query in phpadmin and clicked go. It says "something has changed" and I exit phpadmin. I purged the cache and dont see an upload button yet.

what do you mean by Make sure to change the phpbb_ to your table prefix? Should the button_upload be inside phpbb_styles_imageset_data or phpbb_styles_imageset? The imageset_id for button_upload is set to 0, should it be 1?

*slow and steady wins the race*

[Handyman]

okay... I copy/pasted that code into the SQL query in phpadmin and clicked go. It says "something has changed" and I exit phpadmin. I purged the cache and dont see an upload button yet.

what do you mean by Make sure to change the phpbb_ to your table prefix? Should the button_upload be inside phpbb_styles_imageset_data or phpbb_styles_imageset? The imageset_id for button_upload is set to 0, should it be 1?

*slow and steady wins the race*

run this

Code: Select all

SELECT imageset_id
   FROM phpbb_styles_imageset
   WHERE imageset_name = 'prosilver';

and this

Code: Select all

SELECT *
   FROM phpbb_styles_imageset_data
   WHERE image_name = 'button_upload';

and let me know what each outputs.

[dravekx Dravek]

#1) MySQL returned an empty result set (i.e. zero rows). (Query took 0.0016 sec)

#2) Showing rows 0 - 0 (1 total, Query took 0.0360 sec) (647 - button_upload - button_upload.gif - en - 25 - 96 - 1)[/b]

[Handyman]

#1) MySQL returned an empty result set (i.e. zero rows). (Query took 0.0016 sec)

#2) Showing rows 0 - 0 (1 total, Query took 0.0360 sec) (647 - button_upload - button_upload.gif - en - 25 - 96 - 1)[/b]

it would appear that you don't have prosilver installed on your forum

[dravekx Dravek]

Ahhh... Fixed the upload button... I just needed to set the imageset_id to the correct number. (also had to install the prosilver theme) hahaha. Amazing! Now to see if it works:

I select an image, click submit and get this:

SQL ERROR [ mysqli ]

Field 'gallery_desc' doesn't have a default value [1364]

SQL

INSERT INTO phpbb_gallery (user_id, parent_id, gallery_name, gallery_photos, gallery_last_update_time) VALUES ('2', '1', 'dravekx', 1, 1195764617)

BACKTRACE

FILE: ncludes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()

FILE: ncludes/functions_gallery.php
LINE: 886
CALL: dbal_mysqli->sql_query()

FILE: ncludes/gallery/gallery_main.php
LINE: 645
CALL: upload_attachment()

FILE: ncludes/functions_module.php
LINE: 471
CALL: gallery_main->main()

FILE: allery.php
LINE: 52
CALL: p_master->load_active()