How to modify a SQL query? And other Qs.

xespok · Beginner Joined: Mar 14, 2008 Posts: 1

Hi,

I'll give it a try to integrate my preexisting gallery2 and the newly installed phpBB3. (Both seem to work as standalone programs.)

I am not a programmer, so it will be not so easy for me.

I try to follow the instructions, and deactivated the URL rewrite module in gallery 2.

Q1?

I am stuck right after that. When I try to execute the SQL queries, I go down with this message..

Query:
CREATE TABLE phpbb_gallery2_data (
g2i_dataName varchar(255) NULL, g2i_dataValue TEXT NULL
) CHARACTER SET 'utf8' COLLATE 'utf8_bin';

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 ''utf8'COLLATE 'utf8_bin'' at line 1

Some specs of my MySQL: phpMyAdmin 2.4.0, MySQL 4.0.16 running on localhost.

Please advise how to rewrite the first line to suit my MySQL.

Q2:
File Copy

1.

Copy: root/gallery2.php
To: gallery2.php

2.

Copy: root/g2helper.php
To: g2helper.php

3.

Copy: root/adm/G2EmbedDiscoveryUtilities.php
To: adm/G2EmbedDiscoveryUtilities.php

4.

Copy: root/adm/style/acp_gallery2.html
To: adm/style/acp_gallery2.html

5.

Copy: root/g2image/*.*
To: g2image/*.*

6.

Copy: root/includes/acp/acp_gallery2.php
To: includes/acp/acp_gallery2.php

7.

Copy: root/includes/acp/info/acp_gallery2.php
To: includes/acp/info/acp_gallery2.php

Root here obviously means my path to phpBB3?

Q3?

If I understand right, I'll have to download certain files from my server, modify them with a text editor and reupload them.

Is there any reason why the modified files are already not provided in the gallery 2 integration package?

Thx.

AdBot

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

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

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 ''utf8'COLLATE 'utf8_bin'' at line 1

Remove " CHARACTER SET 'utf8' COLLATE 'utf8_bin'" from the query. It's only good for mysql4.1+

Quote: › Root here obviously means my path to phpBB3?

Root is where the files are in the integration, the "to" part is to your phpbb root directory.

Quote: › If I understand right, I'll have to download certain files from my server, modify them with a text editor and reupload them.

That's right. I'm just curious...if mysql is running on localhost, aren't your phpbb files on your local computer also?

Quote: › Is there any reason why the modified files are already not provided in the gallery 2 integration package?

Because it's a "mod" package like any other phpbb mod package. The reason it doesn't include premodded files has been answered several times already. Basically because it's that much more work to maintain and it won't work for those that use other mods anyway.

deephouse · Beginner Joined: Feb 07, 2008 Posts: 1

This is great info, i had the same questions pretty much.

Web Hosting India