Noob here..

alokbagga · Beginner Joined: Aug 28, 2008 Posts: 7

Hello,

I have installed Gallery 2 why Fantastico and its on mydomain.com/gallery 2 but the actual path is home/abc/public_html/gallery2/ (root/gallery)

similar is the case with Phpbb3 I have installed why Simple scripts its on mydomain.com but its actual path is home/abc/public_html/ (root)

the table names do not have "phbb_" prefix..

could you please tell me what changes are to be done..now.. I tried installing it and made changes to the best of (non-existent) abilities thrice and it didn't work... and I have hadto reinstall both again

Thanks..

AdBot

madpinger · Beginner Joined: Aug 27, 2008 Posts: 12

What step are you refering to ?

If your talking about the sql code you need to run for your phpbb3 database, just change the prefix for them, like this (going by what you said, they do not have the phbb_ prefix):

Code: ›
CREATE TABLE gallery2_data (
g2i_dataName varchar(255) NULL, g2i_dataValue TEXT NULL
) CHARACTER SET 'utf8' COLLATE 'utf8_bin';

INSERT INTO gallery2_data (g2i_dataName, g2i_dataValue) VALUES ('g2i_exportData', NULL);

INSERT INTO config (config_name, config_value, is_dynamic) VALUES ('g2i_fullPath', '', 0);
INSERT INTO config (config_name, config_value, is_dynamic) VALUES ('g2i_embedUri', '', 0);
INSERT INTO config (config_name, config_value, is_dynamic) VALUES ('g2i_g2Uri', '', 0);
INSERT INTO config (config_name, config_value, is_dynamic) VALUES ('g2i_activeAdminId', '', 0);
INSERT INTO config (config_name, config_value, is_dynamic) VALUES ('g2i_link', '', 0);
INSERT INTO config (config_name, config_value, is_dynamic) VALUES ('g2i_allLinks', '', 0);
INSERT INTO config (config_name, config_value, is_dynamic) VALUES ('g2i_allLinksAlbums', '', 0);
INSERT INTO config (config_name, config_value, is_dynamic) VALUES ('g2i_allLinksLimit', '', 0);

ALTER TABLE users ADD user_gallery VARCHAR( 10 ) NULL DEFAULT NULL;

The instalation instructions covers the path details. If your unsure tho, just drop us a line.

Hope thats what you was wanting to know.
l8rs

alokbagga · Beginner Joined: Aug 28, 2008 Posts: 7

I made the changes in SQL but the problem is after running automatic config..
The gallery didn't display any image.. the link so generated was
mydomain.com/v/picture.jpg.html while the pictures were stored in /home/abc/public_html/g2image/(or something)

I ran manual config etc. after autmoatic config and tried to set the paths to the best of my knowledge but after that I couldn't log in to the phpbb3 forum

PS:
Access URL of phpbb3: http://www.mydomain.com/
access url of gallery: http://mydomain.com/gallery2/
This is the URL your visitors will type in to view your site.
Server Path of Phpbb3: /home1/abc/public_html/
Server Path of Gallery 2:/home1/abc/public_html/gallery2/
SQL DB name of both Gallery2 and Phpbb3 are defined by Fantastico and Simple Scripts (As abc_pbb01 and abc_gllr01)

alokbagga · Beginner Joined: Aug 28, 2008 Posts: 7

CREATE TABLE gallery2_data (
g2i_dataName varchar(255) NULL, g2i_dataValue TEXT NULL
) CHARACTER SET 'utf8' COLLATE 'utf8_bin';# MySQL returned an empty result set (i.e. zero rows).

INSERT INTO gallery2_data (g2i_dataName, g2i_dataValue) VALUES ('g2i_exportData', NULL);# Affected rows: 1

INSERT INTO config (config_name, config_value, is_dynamic) VALUES ('g2i_fullPath', '', 0);# Affected rows: 1

INSERT INTO config (config_name, config_value, is_dynamic) VALUES ('g2i_embedUri', '', 0);# Affected rows: 1

INSERT INTO config (config_name, config_value, is_dynamic) VALUES ('g2i_g2Uri', '', 0);# Affected rows: 1

INSERT INTO config (config_name, config_value, is_dynamic) VALUES ('g2i_activeAdminId', '', 0);# Affected rows: 1

INSERT INTO config (config_name, config_value, is_dynamic) VALUES ('g2i_link', '', 0);# Affected rows: 1

INSERT INTO config (config_name, config_value, is_dynamic) VALUES ('g2i_allLinks', '', 0);# Affected rows: 1

INSERT INTO config (config_name, config_value, is_dynamic) VALUES ('g2i_allLinksAlbums', '', 0);# Affected rows: 1

INSERT INTO config (config_name, config_value, is_dynamic) VALUES ('g2i_allLinksLimit', '', 0);# Affected rows: 1

ALTER TABLE users ADD user_gallery VARCHAR( 10 ) NULL DEFAULT NULL;# Affected rows: 52

//was the result of DQL query ..

madpinger · Beginner Joined: Aug 27, 2008 Posts: 12

loosk like it ran to me.

If your unsure, browse your db and see that the values have been stored.

alokbagga · Beginner Joined: Aug 28, 2008 Posts: 7

Fanatastico Deluxe installed Gallery 2 was the culprit... Nuked Gallery worked alright.. I am manually installing Gallery 2 and shall report.. Thanks MP Smile

madpinger · Beginner Joined: Aug 27, 2008 Posts: 12

ya, you gotta have gallery2 installed b4 you embed it.

Hope it works out for ya.

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1044

alokbagga wrote: › mydomain.com/v/picture.jpg.html while the pictures were stored in /home/abc/public_html/g2image/(or something)

You needed to disable the rewrite module in the gallery acp for starters...

alokbagga · Beginner Joined: Aug 28, 2008 Posts: 7

Tried reinstalling.. followed all instructions but now getting this problem during auto configs's export user operation...

Parse error: syntax error, unexpected ';', expecting T_FUNCTION in /home1/abc/public_html/includes/acp/auth.php on line 1294

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1044

You've made an error in the mods to the auth.php file...

alokbagga · Beginner Joined: Aug 28, 2008 Posts: 7

checked rechecked. and re rechecked..
now it says..
Parse error: syntax error, unexpected ';', expecting T_FUNCTION in /home1/abc/public_html/includes/acp/auth.php on line 1332

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1044

I would suggest getting a clean auth.php file and doing the mods over, especially the ones before line 1332. Smile

alokbagga · Beginner Joined: Aug 28, 2008 Posts: 7

Did that too.. But to no avail.. decided to go for an umpteenth reinstall of both ... I won't give up.. Exclamation