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.    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.    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.

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.    Correct it, and you'll be good to go.  

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

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.

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.  

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

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.

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

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.