Search - Unclassified NewsBoard

topic: Is the development halted? in the forum: Support › General support

spaceman

2009-02-06, 23:47 #1

Member since Sep 2004 · 295 posts
Group memberships: Members

Show profile ·

Link to this post

Subject: Is the development halted?

This is a great innovative forum and best I've ever used (was using Blackboard before renamed to unclassified).
Frequently check on this site for any update but too bad it doesn't post any update since last version 1.6.4 back on 2007.

Come on guys, we love this forum!!

BlackBoard > FUDForum > Invision > phpBB2

topic: How to decode mysql database password? in the forum: Support › General support

spaceman

2006-05-09, 19:54 #2

Member since Sep 2004 · 295 posts
Group memberships: Members

Show profile ·

Link to this post

In reply to post ID 1912

Recently I've received many emails concerning how I decode mysql password.

In fact I'm not able to decode the password, the solution I used was insert a new password (not encoded) into board.conf.php and after that change it from Admin area of the forum. Once password was changed from Admin, it's being encoded again in board.conf.php!

BlackBoard > FUDForum > Invision > phpBB2

topic: Moving server: Database password? in the forum: Support › General support

spaceman

2005-11-23, 22:04 #3

Member since Sep 2004 · 295 posts
Group memberships: Members

Show profile ·

Link to this post

In reply to post ID 4843

Update: My forum has been successfully restored! Thanks to Yves for pointing me in the right direction

BlackBoard > FUDForum > Invision > phpBB2

topic: Moving server: Database password? in the forum: Support › General support

spaceman

2005-11-23, 18:25 #4

Member since Sep 2004 · 295 posts
Group memberships: Members

Show profile ·

Link to this post

In reply to post ID 4842

Thanks I'll try that now.

P/s: How is one seen as a SQL keyword?

User,Group,Action,Thread,Forum - keywords?

BlackBoard > FUDForum > Invision > phpBB2

This post was edited on 2005-11-23, 18:27 by spaceman.

topic: Moving server: Database password? in the forum: Support › General support

spaceman

2005-11-23, 18:01 #5

Member since Sep 2004 · 295 posts
Group memberships: Members

Show profile ·

Link to this post

In reply to post ID 4839

Quote by psz:
My guess: Regular Expression Search & Replace.

Hmm...Can you explain in detail? I can't get what you mean....Thanks!

BlackBoard > FUDForum > Invision > phpBB2

topic: Moving server: Database password? in the forum: Support › General support

spaceman

2005-11-23, 17:59 #6

Member since Sep 2004 · 295 posts
Group memberships: Members

Show profile ·

Link to this post

In reply to post ID 4838

Ok here I attached the (front) part from the database dump backup, that was claimed error while restoring. Can you point out and explain how to fix it? Thanks a zillion for your generous help!!

-- MySQL dump 9.11
--
-- Host: localhost Database: this_forum
-- ------------------------------------------------------
-- Server version 4.0.22-standard

--
-- Table structure for table `bb1_ACL`
--

DROP TABLE IF EXISTS bb1_ACL;
CREATE TABLE bb1_ACL (
ID int(10) unsigned NOT NULL default '0',
User int(10) unsigned NOT NULL default '0',
Group int(10) unsigned NOT NULL default '0',
Action smallint(5) unsigned NOT NULL default '0',
Thread int(10) unsigned NOT NULL default '0',
Forum int(10) unsigned NOT NULL default '0',
Grant int(11) NOT NULL default '0',
Enabled tinyint(1) NOT NULL default '0',
PRIMARY KEY (ID),
UNIQUE KEY User (User,Group,Action,Thread,Forum)
) TYPE=MyISAM;

--
-- Dumping data for table `bb1_ACL`
--

INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (1,0,0,33,0,0,1,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (2,0,1,82,0,0,1,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (3,0,2,83,0,0,1,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (4,0,3,84,0,0,1,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (5,0,0,35,0,14,1,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (6,0,0,34,0,14,1,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (22,0,0,47,0,13,1,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (21,0,0,35,0,13,1,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (9,0,0,8,0,0,1,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (10,0,0,9,0,0,1,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (11,0,3,44,0,0,1,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (12,0,3,45,0,0,1,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (13,0,0,35,0,10,1,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (14,0,0,34,0,10,1,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (20,0,0,34,0,13,1,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (25,0,4,34,0,17,1,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (18,0,0,47,0,10,1,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (19,0,0,47,0,14,1,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (24,0,1,35,0,17,0,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (26,0,4,35,0,17,1,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (27,0,4,82,0,0,1,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (28,0,4,37,0,17,1,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (29,0,0,47,0,0,1,1);
INSERT INTO bb1_ACL (ID, User, Group, Action, Thread, Forum, Grant, Enabled) VALUES (30,0,0,10,0,0,1,1);

--
-- Table structure for table `bb1_ForumWatch`
--

DROP TABLE IF EXISTS bb1_ForumWatch;
CREATE TABLE bb1_ForumWatch (
Forum int(10) unsigned NOT NULL default '0',
User int(10) unsigned NOT NULL default '0',
Mode tinyint(3) unsigned NOT NULL default '0',
Flags tinyint(3) unsigned NOT NULL default '0',
LastVisited int(11) NOT NULL default '0',
LastNotify int(11) NOT NULL default '0',
PRIMARY KEY (Forum,User),
KEY Forum (Forum),
KEY User (User)
) TYPE=MyISAM;

--
-- Dumping data for table `bb1_ForumWatch`
--

INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (8,16,1,0,0,1121965218);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (8,87,1,0,0,1121965218);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,114,1,0,0,1122282811);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,170,1,0,0,1122282811);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,186,1,0,0,1122282811);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (11,106,0,0,0,1097778413);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,165,1,0,0,1122282811);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,479,0,0,0,1097839152);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,540,0,0,0,1098059494);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,498,0,0,0,1108514439);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,462,0,0,0,0);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (11,26,0,0,0,0);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (8,39,0,0,0,0);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,329,0,0,0,1099367261);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (8,498,1,0,0,1121965218);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (11,498,1,0,0,1122230430);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (8,52,0,0,0,1099431903);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,522,1,0,0,1122282811);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,984,0,0,0,1110645029);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,1062,1,0,0,1122282811);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (11,1087,1,0,0,1122230430);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (2,803,0,0,0,0);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (8,9,0,0,0,1102940965);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,1662,1,0,0,1122282811);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (11,2001,1,0,0,1122230430);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (13,984,1,0,0,1121630346);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (8,2228,0,0,0,0);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,651,1,0,0,1122282811);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (11,2736,1,0,0,1122230430);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (4,583,0,0,0,0);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,1412,0,0,0,0);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,3055,1,0,0,1122282811);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (8,2752,1,0,0,1121965218);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,3079,1,0,0,1122282811);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,536,0,0,0,0);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,549,1,0,0,1122282811);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (13,3186,0,0,0,0);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,3200,1,0,0,1122282811);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,787,0,0,0,1118620922);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (17,3200,1,0,0,1118869000);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (8,2280,1,0,0,1121965218);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,3448,0,0,0,1119210830);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (17,3550,1,0,0,0);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,2871,1,0,0,0);
INSERT INTO bb1_ForumWatch (Forum, User, Mode, Flags, LastVisited, LastNotify) VALUES (10,1891,0,0,0,0);
.
.
.

BlackBoard > FUDForum > Invision > phpBB2

topic: Moving server: Database password? in the forum: Support › General support

spaceman

2005-11-23, 17:41 #7

Member since Sep 2004 · 295 posts
Group memberships: Members

Show profile ·

Link to this post

In reply to post ID 4837

CPanel backup tool is almost the same as phpMyAdmin. And I did backup twice to make sure nothing goes wrong. By the way I have successfully restored other backed up database but not this one.

Anyway can you kindly tell me how to fix manually by hand? Maybe "Search and Replace" would come in handy in this case? As I really couldn't reach my old host now....how sad...

BlackBoard > FUDForum > Invision > phpBB2

topic: Moving server: Database password? in the forum: Support › General support

spaceman

2005-11-23, 17:28 #8

Member since Sep 2004 · 295 posts
Group memberships: Members

Show profile ·

Link to this post

In reply to post ID 4834

Do you mean backslash like \"Group\" ??

By the way I don't think the database is invalid. I backed it up using CPanel backup tool and I checked the contents inside the .gz file everything looks just fine. So how can it be invalid?

Please is there a workaround to this problem? Because I can't get back to my old host now

Thank you very much!!

BlackBoard > FUDForum > Invision > phpBB2

This post was edited on 2005-11-23, 17:29 by spaceman.

topic: Moving server: Database password? in the forum: Support › General support

spaceman

2005-11-23, 07:47 #9

Member since Sep 2004 · 295 posts
Group memberships: Members

Show profile ·

Link to this post

In reply to post ID 4828

While restoring the old Mysql databse I got these errors, what does they mean?

Some of the queries were not executed properly. Technical information about the queries:

Line #23: 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 'Group int(10) unsigned NOT NULL default '0',
Action smallint(
Line #29: 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 'Group, Action, Thread, Forum, Grant, Enabled) VALUES (1,0,0,33,
Line #30: 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 'Group, Action, Thread, Forum, Grant, Enabled) VALUES (2,0,1,82,
Line #31: 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 'Group, Action, Thread, Forum, Grant, Enabled) VALUES (3,0,2,83,
Line #32: 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 'Group, Action, Thread, Forum, Grant, Enabled) VALUES (4,0,3,84,
Line #33: 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 'Group, Action, Thread, Forum, Grant, Enabled) VALUES (5,0,0,35,
Line #34: 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 'Group, Action, Thread, Forum, Grant, Enabled) VALUES (6,0,0,34,
.
.
.

Please help me!! Thanks.

BlackBoard > FUDForum > Invision > phpBB2

topic: Moving server: Database password? in the forum: Support › General support

spaceman

2005-11-23, 05:11 #10

Member since Sep 2004 · 295 posts
Group memberships: Members

Show profile ·

Link to this post

Subject: Moving server: Database password?

Hello, I'm moving my Unclassified Newsboard to a new server but I couldn't figure out how to fill in db_pass as in board.conf.php because it was in encrypted form. Now I'm with a new database, username and password. Can anybody help me on this issue? Thanks in advance! :-)

P/s: Currently my db_pass (in board.conf.php) is b64:XXXXXXXXXXXX. How can I fill in the new password?

BlackBoard > FUDForum > Invision > phpBB2

topic: About version 1.6... (The pre-1.6 thread!) in the forum: News and announcements

spaceman 2005-10-03, 19:12 #11

Member since Sep 2004 · 295 posts
Group memberships: Members

Show profile ·

Link to this post

In reply to post ID 3866

Whoa!... What a huge release!

All the features are fine tuned, smooth and colorful. But one bug when I'm posting this reply, the vertical scrollbar of this textarea (when posting reply) keeps hiding and reappears for every character typed in...

P/s: For your information, WinXP Pro and IE 6.0.

Overall it's a great great release! :-D

BlackBoard > FUDForum > Invision > phpBB2

topic: About version 1.6... (The pre-1.6 thread!) in the forum: News and announcements

spaceman 2005-08-14, 20:42 #12

Member since Sep 2004 · 295 posts
Group memberships: Members

Show profile ·

Link to this post

In reply to post ID 3482

By the way, can you reveal what are the MAJOR (or upgraded) features added to v1.6? Thanks a lot!

BlackBoard > FUDForum > Invision > phpBB2

topic: About version 1.6... (The pre-1.6 thread!) in the forum: News and announcements

spaceman 2005-08-14, 20:40 #13

Member since Sep 2004 · 295 posts
Group memberships: Members

Show profile ·

Link to this post

In reply to post ID 3479

Looks great!! The layout design is exquisite. Can't wait for the final version to be release. My friend and me are planning to build a forum on our newly registered domain, and we're still in the middle of choosing the right forum software. Maybe we'll just wait for this version;)

BlackBoard > FUDForum > Invision > phpBB2

topic: Next BIG suggestion! (Regarding sticky topics) in the forum: Support › Ideas and suggestions

spaceman

2005-05-12, 03:31 #14

Member since Sep 2004 · 295 posts
Group memberships: Members

Show profile ·

Link to this post

In reply to post ID 2907

Thanks a lot!

It could be one of the best add-ons of all, since I don't need to create another subforum(s) just to keep track of those old sticky topics (so they won't flood the first page)! I'll let the "Highlighting" do the job after all!

Glad to hear that it'll be in version 1.5.4! Just can't wait till it's release... must be full of surprises!

BlackBoard > FUDForum > Invision > phpBB2

topic: Next BIG suggestion! (Regarding sticky topics) in the forum: Support › Ideas and suggestions

spaceman

2005-05-11, 02:56 #15

Member since Sep 2004 · 295 posts
Group memberships: Members

Show profile ·

Link to this post

In reply to post ID 2901

Quote by Yves:
OK, first I thought you meant some kind of Thread Highlighting, that shows a thread in the list with a different colour, much like important threads, but with no special ordering.

Ok my original idea was this ^^ Thread Highlighting ^^, but visitors and/or users have the option to list all highlighted threads through a hyperlink somewhere above the topics overview table, visible to them. I'm glad you get my idea well...

P/s: By the way, I DON'T LIKE thread rating too! It's rather useless if nobody cares to vote/rate on the threads they see.

Thank you again!

BlackBoard > FUDForum > Invision > phpBB2

All posts by spaceman (295)

Special queries