Download now

Everything, except for the ban panel and moderator log, should work.  Banning users works, but you will not be able to unban them from E-Blah.

The converter works, but may not work fully.  CHMOD Settings.pl 666 before installing.  If you get any errors on the first page of Install.pl, the Settings.pl values are located at the top of Install.pl, change them so they work.  :P  X2 theme is automatically selected during install, make sure it is installed in the blahdocs directory (located in the install package -- it's a FULL install package).

If you have any issues with the version post them here.  Please let me know what version of DBI you have installed (the first page of the install will let you know).  The converter will add the userid 1 to the Administrators group, if your user ID is not 1, you will need to change it by editing it in the ranks table (with phpMyAdmin or something).

Note that while it's in beta, that doesn't mean there will ever be a final.  I feel it's safe to use, but you still may want to do daily backups of the MySQL database.  If you lose data, it's your fault.  :P  Personally, I'd feel safe in using it.  I'm not even close to being an expert at MySQL, so some of the queries could make your server blow up.  So be prepared for that.  Injection shouldn't be a problem at all, however.  The biggest issue you may find is a software error page with the SQL query in it.  Again, report that here.

Finally, to sum it all up: this has been released because some users wanted it.  It may get complete.  It may not.  If you find a huge bug and want to use it [E-Blah] but can't, there's still the main version.  ;)  Oh, and it's been tested with DBI version 1.47 and MySQL 4 and 5 Beta.

Thanks for the beta release. I will test this weekend. ;D

I gave it a try on my personal linkstation web server.

Quoted Text

You have the available MySQL modules installed for E-Blah to work properly. Your DBI version is 1.46; please make a note of it!

Quoted Text

Software error:
Can't call method "do" on an undefined value at EBlah/SQL.pm line 328.

Software error:
Can't call method "prepare" on an undefined value at EBlah/SQL.pm line 179.

Software error:
Can't call method "prepare" on an undefined value at EBlah/SQL.pm line 179, <CATS> line 1

??) Forgive my n00bness with MySQL.

Edit: I removed it completely instead. :(

This occurs because you did not enter the correct MySQL login information or database (the stuff you enter on the first page).  I probably should have added an error to say the login was a failure.  :P  Correct it, and you'll be good to go.  :)

Ok gave it a try, here are the problems that I get :P

When  I try New Install

Quoted Text

There was an error with creating tables.
Content-type: text/html
Software error:

Table 'db198385182.eblah_members' doesn't exist

INSERT INTO `eblah_members` (`sn`,`password`,`email`,`registered`) VALUES (?,?,?,?)

By the way my DBI version is 1.32. ;D

Is there a way you can look and see if eblah_members exists on the db198385182 database?

Actually it didn't get created.  Can you check and see if any of the tables were created?

Quoted from Justin

Is there a way you can look and see if eblah_members exists on the db198385182 database?

Actually it didn't get created.  Can you check and see if any of the tables were created?

I checked the database no table was created.

I'll have to give you something to find out what happens when it tries to add it to the database later today if I can ...

pakodi, replace this with the one in the EBlah directory.

It should give you what the error was now with the tables being created.

VinnyJ, you can also use this.  It'll tell you about the SQL login error now.  :P

I tried again, this time.. with the correct login info.. the user I used before didn't have privileges  :X

Software error:
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 'DEFAULT CHARSET=latin1' at line 9
CREATE TABLE `eblah_activelist` (
  `user` varchar(25) NOT NULL,
  `guest` tinyint(1) NOT NULL DEFAULT '0',
  `time` int(11) NOT NULL,
  `view` varchar(10) DEFAULT NULL,
  `boardid` int(10) DEFAULT NULL,
  `messageid` int(10) DEFAULT NULL,
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 at EBlah/SQL.pm line 329.

Software error:
Table 'blargh.eblah_members' doesn't exist

INSERT INTO `eblah_members` (`userid`,`password`,`sn`,`email`,`posts`,`admintxt`,`avatar`,`personaltxt`,`sex`,`icq`,`aim`,`msn`,
`skype`,`sig`,`hidemail`,`registered`,`dob`,`dateformat`,`hideonline`,`sitename`,`siteurl`,`location`,`timeformat`,`status`,`validation`,
`ml`,`theme`,`yim`,`lastactive`,`hidesum`,`notify`,`dst`,`avatarupload`,`shownewonly`,`lng`,`showsig`,`ownavatar`,`pmdisable`,`censor`,
`pmpopup`,`reputation`,`timeonline`,`md5upgrade`,`blockedusers`,`rndsid`,`avatarsize`,`lastvisit`,`timezone`,`lastpost`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

Software error:
Table 'blargh.eblah_categories' doesn't exist

INSERT INTO `eblah_categories` (`id`,`parent`,`order`,`name`,`permissions`,`description`) VALUES (?,?,?,?,?,?)


Hmmm, either I'm converting 10.2 wrong or I set up my linkstation's MySQL, PHP, and Apache installs wrong.
I've been doing this for like a week, out of curiousity after reading the linkstationwiki. :B

No, it's right.  I'll try to fix it ... it's a bug.

Redownload the entire package.  It should work now.

Quoted from Justin

Redownload the entire package.  It should work now.

Tested it. I get this error.

Quoted Text

All tables created.
Content-type: text/html
Software error:

Can't locate object method "last_insert_id" via package "DBI::db" (perhaps you forgot to load "DBI::db"?) at EBlah/SQL.pm line 186.

I checked the database, all tables were created successfully unlike before. Getting close :P

I tried a clean install.. No errors. Awesome. I can log in use the forum etc.


Then, I 'DROPPED' the Database and created a new blank one.
Erased the eblah install I just did, Copied the files from the beta1 archive again.
Did the CHMOD 666 on Setup.pl
I tried a 10.2 conversion install, it went through all steps.
At the end received a fatar error that, it can't be converted at this time.
Went to Blah.pl via web browser, everything works. Though, I had to log in using the encrypted Password string, not my REAL unencrypted password.

Now, there's text at the footer of the forum under the Query stats.
Edited my email out, below.

Quoted Text

/mnt/share/www/blahdocs/template/X2/template.html (TEMP)

1 -> SELECT * FROM members WHERE `userid` = ? (1)
1 -> SELECT * FROM activelist WHERE ()
1 -> SELECT * FROM banlist WHERE `user` LIKE ? OR `user` = ? OR `user` = ? (%192.168.1.1% myemail@email.com 1)
2 -> SELECT * FROM members WHERE `userid` = ? OR `userid` = ? OR `userid` = ? OR `userid` = ? OR `userid` = ? (0 9 15 2 35)
1 -> SELECT `board`,`visited` FROM memberlog WHERE `userid` = ? (1)

Actually, Nevermind.. I changed my password and it removed the text... Seems to be good now.

Yeah, those stats at the bottom are just debug stuff.  :)  I see you converted the forum.  ;D

Quoted from pakodi

Tested it. I get this error.


I checked the database, all tables were created successfully unlike before. Getting close :P

I think this is because it's too old.  There MAY be another way to get the last inserted ID.  I'll have to check -- which as of yet, am yet to find.  Your DBI version is VERY old though.

Right now, you can upgrade:  http://search.cpan.org/~timb/DBI-1.53/

The version you are using is from December 2002.  :P  Four years old.

Quoted from pakodi

Tested it. I get this error.


I checked the database, all tables were created successfully unlike before. Getting close :P

Actually, a quick find found the answer.  ;D  Now Craig should be able to use it too.

Craig's downloading it right now:)

Hey, it installs!  But I get this error when I try to create a board:

Software error:
called with 18 bind variables when 0 are needed

UPDATE `boards` SET  WHERE


For help, please send mail to the webmaster (webmaster@beta.blahdocs.com), giving this error message and the time and date of the error.

Quoted from Craig

Hey, it installs!  But I get this error when I try to create a board:

Software error:
called with 18 bind variables when 0 are needed

UPDATE `boards` SET  WHERE


For help, please send mail to the webmaster (webmaster@beta.blahdocs.com), giving this error message and the time and date of the error.

We have the first bug.  :P  I thought I tested that, but I obviously didn't.

Redownload and reupload ManageForum.pl and it should work.  :)  Sorry about that.  It was a small bug -- and I don't think this will be the case for the rest of this beta experience.  lol

Yup, that fixed it:)  Working like a champ now.  http://www.beta.blahdocs.com/cgi-bin/forum/Blah.pl

Oh, there is one other bug with new installs involving the Install setup.  After you set up your forum, it gives you the link to delete the setup.pl file.  If you click that, it starts to run the Upgrade forum Sub:)  Might want to fix that one too:)

-Craig

Eh?  I didn't think I added that.

That link doesn't work, btw.

Not sure it ever will as of now.  :P

The link works now:)

Registration was kinda weird ... lol.

Quoted from Justin

I think this is because it's too old.  There MAY be another way to get the last inserted ID.  I'll have to check -- which as of yet, am yet to find.  Your DBI version is VERY old though.

Right now, you can upgrade:  http://search.cpan.org/~timb/DBI-1.53/

The version you are using is from December 2002.  :P  Four years old.

I have asked for an upgrade, usually they take 24hrs to respond, so I will keep my fingers crossed. ;D

Quoted from Justin

Actually, a quick find found the answer.  ;D  Now Craig should be able to use it too.

Clean Install works  good ;D


But when I go for forum conversion I get this error.

Quoted Text

Current Forum Conversion Status ...
All tables created.
Members converted.
Software error:

Undefined subroutine &main::fopen called at /htdocs/testdb/Install.pl line 1249

Anyway I dont know if it has to do with the DBI version?.

Ignore that error, it was a bug.  It should work though.  :P

I'll have to give the new beta a test this weekend. Justin, did you update the beta download to have the latest fixed files you posted here?

Yes.  Yes, I did.  :)

Is anyone using it?  If so, how's it running ... ?

i get a 500 error when i try to run the install.pl
i am attempting a fresh install, downloaded directly to the server.  i tried deleting all htaccess files, and checked all permissions.  is there something else i need to install to use this?

use CGI::Carp fatalsToBrowser;

Move that up above use DBI; in Install.pl and see if you get an error with DBI.

Can't locate DBI.pm in @INC (@INC contains: C:/Perl/lib C:/Perl/site/lib .) at C:\websites\getjesus\eblahsql\forum\Install.pl line 40.
BEGIN failed--compilation aborted at C:\websites\getjesus\eblahsql\forum\Install.pl line 40.

i'm guessing DBI is either a module or an application that needs to be installed?

Yes, go to PPM and install DBI and the MySQL modules :).

excuse my ignorance, but PPM??  and where can i find the modules?

Start>Run>ppm, and then install the DBM modules.

doesn't work...i'm using apache xampp

Go into your Perl/bin directory and then run PPM from there, then.

Here's an SQLite version that works.

There is no install for it, just replace the SQL.pm file, and then go and add the database.db file where Blah.pl is.  You may need to change the directory via SQL.pm to database.db.  :P

Enjoy!

The converter DOES work with this, but the forum here is so large that the web version times out (SQLite is A LOT slower at adding new data).  I got about 3,000 members (with 24,000 PMs) converted in about 30 minutes (via the command line).  It's obviously not that great to do that for almost 100,000 rows.  Plus it's very hard disk intensive when doing that many writes.

That said, this version works fine, as far as I know.  I got it to post items and all.  Copy your Settings.pl from any regular install over to get this one to work (and don't run Install.pl).

l downloaded it and testing it. First of, it looks great, the installation worked out fine. When l entered the forum l saw this at the bottom. Not suppose to be like that l guess. (image 1)

When l tried to post l got the message that my email was invalid (Last image)

l would Love an sql version as we have problems with the fact that users are getting deleted because of server space. So l hope you will have it running soon Justin. Looking forward to it.

lol, just saw this

Yeah, I removed that part.  :P

Make sure your e-mail address is filled in.  Only admins will see the bottom stuff.  You need to CHMOD your cache directory 777.

:B working fine now ...

Uhu, we have a forum with almost 400 members and an average of 20 posts pr day ... Like l said there is the server issue with members getting deleted. Is it secure to use the converter at this point or should we wait?

The version is 10.1, do we need to upgrade before we can convert it?

It'd be good to upgrade to 10.2.5 first.  10.1 could delete members, as there was a bug.

It should be safe to convert the forum and start using it.  It'd be good to back everything up though, and see how the speed goes and all before you dedicate the forum to SQL only.   :P  I've not had any extensive testing on it yet, so you'll be the first one I do believe.  :)

ll try and convince the other admins ...lol

Quoted from outcast

:B working fine now ...

Uhu, we have a forum with almost 400 members and an average of 20 posts pr day ... Like l said there is the server issue with members getting deleted. Is it secure to use the converter at this point or should we wait?

The version is 10.1, do we need to upgrade before we can convert it?

Outcast show your forum after its converted. If you want to not post site link here. Please PM the link to me. ;)

Hi i just wanted to say that im in full support of a MYsql version.  I know a lot of forum admin sites pan eblah because its flatfile and they only use mysql.

I have read a few stating that the mysql release will isolate users but thats impossible IMO because a mysql version opens it up to those who so far have stayed away.

Im quite certian that the mysql version will take this board onto another level.

Quoted from will

Hi i just wanted to say that im in full support of a MYsql version.  I know a lot of forum admin sites pan eblah because its flatfile and they only use mysql.

I have read a few stating that the mysql release will isolate users but thats impossible IMO because a mysql version opens it up to those who so far have stayed away.

Im quite certian that the mysql version will take this board onto another level.

Well, it's in beta so we can see if it does anything.  :P

a noob question i know..

whats the advantage of an SQL version over the flat file version?

Flat:
- It's developed/worked on more.
- It's oldest.
- It's great for small/medium sized forums.

SQL:
- Scalable
- It's new, forked from the 10.2.
- It's better for all sized forums.