SQL Beta 3 Table - Prefix Issue

Welcome, Guest.
Please login or register.

Home

Calendar

Welcome to the E-Blah Community!
We would like to welcome you to our community and invite you to register an account or login.
Being a registered member is important, as it gives you several advantages over the normal Guest status. After registering you will be able to download files and images, post messages, and access member-only portions of the forum - just to name a few. Registration is quick and simple, and only takes about a minute of your time.

E-Blah Community › Technical Support › Install Issues › SQL Beta 3 Table - Prefix Issue

Users Browsing Forum

No Members and 1 Guests

SQL Beta 3 Table - Prefix Issue This thread currently has 227 views.

1 Pages 1

Recommend Thread

vol7ron

April 9, 2008, 3:50pm

Report to Moderator

E-Blah Member

Posts: 106

Gender:

Male

Posts Per Day: 0.45

Reputation: 100.00%

Reputation Score: +9 / -0

Time Online: 1 days 58 minutes

Location: Washington DC

Age: 25

When installing the SQL E-Blah there are two things that need to be corrected in the Install.pl script.

1) Open up Install.pl for editing
2) Do a search for "eblah_boards"
3)You will find the line that reads like:

Code

        $sql = SQL->new();
	$sql->trans(qq~INSERT INTO eblah_boards VALUES (1, 1, 0, 'Chit chat about anything.', NULL, 'General Discussion', 'guest,validating,member', 'member,guest,validating', 'guest,validating,member', NULL, NULL, NULL, 'guest,member,validating', NULL, 'guest,member,validating', '', '', 'validating,guest,member', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL)~) or $error = 1;

4)Here you need to change the eblah_boards to ${forumprefix}boards

5)You have to do the same thing with eblah_categories that is two to three lines down. It will become ${forumprefix}categories

The final should look like this:

Code

        $sql = SQL->new();
	$sql->trans(qq~INSERT INTO ${forumprefix}boards VALUES (1, 1, 0, 'Chit chat about anything.', NULL, 'General Discussion', 'guest,validating,member', 'member,guest,validating', 'guest,validating,member', NULL, NULL, NULL, 'guest,member,validating', NULL, 'guest,member,validating', '', '', 'validating,guest,member', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL)~) or $error = 1;

	$sql = SQL->new();
	$sql->trans(qq~INSERT INTO ${forumprefix}categories VALUES (1, 0, 0, 'General Category', 'member,validating,guest', '')~) or $error = 1;

Both of these lines are found in the CreateUser subroutine, in case you're wondering. Also, these only affect install if you decide to use a different table prefix other than "eblah_" Personally, I like my table prefixes to begin with "tbl_"

Note if you're editing in a windows-based editor like Wordpad, you will most likely need to do a Dos2Unix on the file after you save, in order for it to run on the server. This will get rid of unseen windows-based characters stored when saving.

Increase vol7ron's Rating

Logged

Offline

Private message

1 Pages 1

Recommend Thread

E-Blah Community › Technical Support › Install Issues › SQL Beta 3 Table - Prefix Issue

Thread Tags

Beta 3 Install boards committee

View Tag Cloud