E-Blah SQL Beta 2 - Print Topic

E-Blah SQL Beta 2 has been released. This release features several bug fixes, along with an installer that works a little better. The installer allows you to select which database you want to use (currently only MySQL and SQLite is available).

Download it and try it out! Let me know if you have issues installing or using it.

Download E-Blah SQL Beta 2

NOTE: After you convert your forum, go to Admin Center and rebuild the members list.

Also, it needs stressing that this is an EARLY BETA release and will contain bugs. This thread will have the fixes, so keep checking back. Also, Beta 3 will be released after enough bugs have been settled in the current release.

Cool.

I tried converting on this new release

I get following error when converting for "members". Rest of the board is converted fine. But members show to be "o" since I get the error below.

Code

Duplicate entry 'vasanth' for key 2

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 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

Hmm. Were there any members converted? Check the member list.

Quoted from Justin

Hmm. Were there any members converted? Check the member list.

Ya some 600+ members were converted out of 1400 ;D

Hmmm ... you may have some issues with some of your members.

Rebuild your members list, and then run it again with this fix.

In Install.pl add this:

Code

		next if($idcache{$member});
		$idcache{$member} = 1;

After:

Code

		GetMemberID($member) || next;

See if that'll fix it.

If you empty the members database, you should be able to call this:

Install.pl?page-finish/section-2/

That should convert JUST the members for you.

OK I solved that issue

Reason: there were two people registered by this name. I dont know how it might have happened. So I deleted one of them and regenerated member list.

Now I have a new message when I try to install :P

Code

Column 'registered' cannot be null

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 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

Add this:

Code

		$memberid{$member}{'registered'} = $memberid{$member}{'registered'} || 1;

After:

Code

		close(PMS);

That should fix it.

These are two scenarios that shouldn't happen often. :P There's really no error checking with the installer like there is in the actual software .

OK. I see some progress :P

Boards converted..

Members converted..

and after that it says FATAL ERROR again. Now It didn't give me any reason this time?

I go back to my forum and see that following things are missing Members: 0 Latest Member:

and below my template I see the following stuff is displayed always

Code

>./Prefs/cache/themeslist.pl (CACHE)
>./Prefs/cache/ranks.pl (CACHE)
>./Prefs/cache/categories.pl (CACHE)
>./Prefs/cache/boards.pl (CACHE)
>./Prefs/cache/stats.pl (CACHE)
>./Prefs/cache/censor.pl (CACHE)
>./Prefs/cache/smilies.pl (CACHE)

1 -> SELECT * FROM members WHERE `userid` = ? (1)
1 -> SELECT * FROM themeslist WHERE ()
1 -> SELECT * FROM ranks WHERE ()
1 -> SELECT * FROM categories WHERE ()
1 -> SELECT * FROM boards WHERE ()
1 -> SELECT * FROM activelist WHERE ()
1 -> SELECT * FROM stats WHERE ()
1 -> SELECT * FROM censorlist WHERE ()
1 -> SELECT * FROM banlist WHERE `user` LIKE ? OR `user` = ? OR `user` = ? (%24.216.26.112% ra@gmail.com 1)
2 -> SELECT * FROM members WHERE `userid` = ? OR `userid` = ? OR `userid` = ? OR `userid` = ? OR `userid` = ? OR `userid` = ? OR `userid` = ? OR `userid` = ? OR `userid` = ? OR `userid` = ? OR `userid` = ? OR `userid` = ? OR `userid` = ? (0 51 469 84 80 261 151 739 73 575 69 1251 6)
1 -> SELECT `board`,`visited` FROM memberlog WHERE `userid` = ? (1)
1 -> SELECT `smiley`,`url` FROM smileys WHERE ()

It's probably fine then. Just go and rebuild the members list. The latest member stats aren't there until you do that. Then go and chmod the cache directory 777. :)

Quoted from Justin

It's probably fine then. Just go and rebuild the members list. The latest member stats aren't there until you do that. Then go and chmod the cache directory 777. :)

I don't see rebuild member list option nor the cache directory :(

Oh, yeah. You don't really need those rebuild features anymore. :-/ You'll need to create a new member to get the count working again. You might can delete one to do it too. The stats are done funny, and should have never been removed from the way the flat-file version is done.

If you don't see the cache directory in Prefs, create it (cache NOT Cache) and CHMOD it. :)

I'll add the stats thing to my list to fix for the SQL version.

OK,

When I registered new member the member count was - 1

So I deleted it then it came back to normal i.e 1300+. So that issue is now fixed ;)

But I still see this below the template. any idea how I can get rid of it :P

Code

1 -> SELECT * FROM members WHERE `userid` = ? (1)
1 -> SELECT * FROM themeslist WHERE ()
1 -> SELECT * FROM ranks WHERE ()
1 -> SELECT * FROM categories WHERE ()
1 -> SELECT * FROM boards WHERE ()
1 -> SELECT * FROM activelist WHERE ()
1 -> SELECT * FROM stats WHERE ()
1 -> SELECT * FROM censorlist WHERE ()
1 -> SELECT * FROM banlist WHERE `user` LIKE ? OR `user` = ? OR `user` = ? (%24.216.26.112% ra@gmail.com 1)
2 -> SELECT * FROM members WHERE `userid` = ? OR `userid` = ? OR `userid` = ? OR `userid` = ? OR `userid` = ? OR `userid` = ? OR `userid` = ? OR `userid` = ? OR `userid` = ? OR `userid` = ? OR `userid` = ? OR `userid` = ? OR `userid` = ? (0 51 469 84 80 261 151 739 73 575 69 1251 6)
1 -> SELECT `board`,`visited` FROM memberlog WHERE `userid` = ? (1)
1 -> SELECT `smiley`,`url` FROM smileys WHERE ()

There is a small problem in the theme. I often see the menubars get moved.
I liked menubar from your previous format, that u had for x default, xblue, xred themes. Also the yellow color is a bit distracting for the overall blue theme ;). here is an attachment to show u how it behaves.

That's orange. :P And yeah, I'm not quite sure how to fix it. :-/

Only admins see that info. You can get rid of it though by changing $debug to 0 in Blah.pl. I recommend making sure the cache files aren't being written anymore though, because that means the caching system is working. ;) Much less queries when it works.

Ok everything in place now. Forum will be open to public in 30min. let's see how it goes ::)

In SQL code for "eblah_ranks" pcount is set to char(3) which would mean it will not allow to create groups for more people with more than 1000 posts.

It would be better to increase it to 6 or 7 :)

Bug No.1.
Looks like there is bug in "extra smiley code"

1. Extra Smilies are not showing up

2. Cannot delete extra smiley's once added

3. whenever trying to add new smilies, duplicate entries of previous smilies are created :P

Bug No.2.

When reputation is added, the percentage increased by 1% instead of 100%

Bug No.3.

Individual post count not increasing, where as overall post count for threads increasing.

More later.

#3:

Code

		if($username ne 'Guest' && $boards{$URL{'b'}}{'postcount'} eq '') { # Add a post count

Replace:

Code

		if($username ne 'Guest' && !$boards{$URL{'b'}}{'postcount'}) { # Add a post count

#1: I cannot reproduce it. It works on the version here and on my local computer. :-/

#2: Strangely, it's working fine for me? Make sure you have a replog table in eblah database, and see what is in it. It's working fine for me. I just can't reproduce it. :-/

Some things I found so far:

If you set a board up as a redirect, it doesn't work.
If you were using MD5 encryption with 10.2.5, it reverts to none when you upgrade.
You need to list what files and directories can be deleted after you upgrade to the SQL version.
Human verification doesn't work after upgrade.
Extensive Stats were lost in upgrade.
Extensive Stats graph insn't working.
Click logging is not staying up-to-date.
If you edit a board, it defaults the setting for the category back to Informational boards (or the top cat).
You have to register a new user and then delete them to get all user post info to show on Board Index. (already identified)
If the person that is the admin isn't user #1, they won't have adminrights when they convert their forum.
If you use the minimize arrow on the right side, it gives this error:

Code

Unknown column 'rank' in 'field list'

UPDATE `members` SET `rank` = ? WHERE `userid` = ?

I am sure there are other minor bugs, but those are the ones that I noticed right away. Still a great bunch of code.

-Craig.

Added to that list ...

Thanks for the code, #3 issue is now resolved.

Regarding #2 eblah_replog table is there. Following are present in it

userid userfixed rep time

Since you your making a MySQL version, any plans on a Joomla bridge? I've got to say, I use both Joomla & Eblah, I just wish I could integrate the login systems, or something of that sort.

For #1.

I made some progress on this. Instead of installing smilies as individual smilies. I installed them as a mod pack.

Now the smilies are shown nicely in the posts.

But the current problem is

when you click add more smiles in your post button, the page that opens up i.e http://www.eblah.com/forum/v-post/a-smilies/

doesn't show any smilies :-/

Any idea??

Bug No.4

RSS not working ::)

Yeah, RSS is one of those "not even started" things. lol

I'll have to look at the rest next week. Hopefully I can get those down. I may need to look at your forum to see about the smiley and reputation thing though. I can't reproduce it.

Quoted from Justin

Yeah, RSS is one of those "not even started" things. lol

I'll have to look at the rest next week. Hopefully I can get those down. I may need to look at your forum to see about the smiley and reputation thing though. I can't reproduce it.

OK. Keep RSS in your priority for next version ;)

I have sent PM check it.

I plan on looking at some of these issues soon. I do have a question though, is the extensive stats working great?

I believe everything is fixed so far.

Code

1. Fixed registration bug where stats cache wasn't cleared
2. Fixed registration bug where it wouldn't show you the welcome page
3. Fixed post counting issue
4. Fixed installation issues
5. Fixed parent cat bug while editing board
6. Fixed roll-up/down on Board Index
7. Fixed hot thread label issues
8. SQL driver bug patched

Craig, board direction works but it wasn't showing correctly. I've fixed that. MD5 will be required for the SQL version. That should be included in the documentation (that it needs to be converted BEFORE the upgrade or else it won't work). I'll really just add the support in Settings.pl (so you can still use it without MD5), but I highly recommend using MD5. There will be a warning in Setup. I don't recommend installing the SQL version in the same directory as the normal version. :P Install, and then move. ;) Human verification does work, make sure you have the font file in the prefs directory. :) The stats are an unfortunate loss. :( GD probably isn't installed for the graph? It's working here. Click log is cached. They are still be counted.

Got to go now ...

Quoted from Justin

I plan on looking at some of these issues soon. I do have a question though, is the extensive stats working great?

It is working fine as of now.

For some reason the graph never worked for me in flatfile version, I don't see a graph now too, but I am not bothered about it.

One thing that you could add to it if possible is " most users online today". Is this was stripped off? in mysql verssion or was it planned for the future versions.

Yes, it was stripped from the extensive stats because I wanted to keep select queries down, and I'd have to do another select just to see the old max number for the day. It was a waste to do a query when it wasn't "essential". Of course, I'm no expert at MySQL so I may just be paranoid. :P

Quoted from Justin

Yes, it was stripped from the extensive stats because I wanted to keep select queries down, and I'd have to do another select just to see the old max number for the day. It was a waste to do a query when it wasn't "essential". Of course, I'm no expert at MySQL so I may just be paranoid. :P

Oh that was one thing I used to like a lot. hmm :P

Are you planning in future some thing like a database backup option from the admin panel for sql version. ;D

Not in the immediate future, but later on probably.

Quoted from Justin

Craig, board direction works but it wasn't showing correctly. I've fixed that. MD5 will be required for the SQL version. That should be included in the documentation (that it needs to be converted BEFORE the upgrade or else it won't work). I'll really just add the support in Settings.pl (so you can still use it without MD5), but I highly recommend using MD5. There will be a warning in Setup. I don't recommend installing the SQL version in the same directory as the normal version. :P Install, and then move. ;) Human verification does work, make sure you have the font file in the prefs directory. :) The stats are an unfortunate loss. :( GD probably isn't installed for the graph? It's working here. Click log is cached. They are still be counted.

Got to go now ...

How would I do an upgrade of an existing forum if I don't do the upgrade in the old directory? Do I just move the messages, boards, and users to a new directory? Hmmm...didn't think of that:) The font is in the Prefs directory...I fixed it. It was damaged (probably because I uploaded in ascii). That is fixed now.

As for what I can delete, can I delete these:
BHits dir
Hits dir
Active.txt
Attachments.txt
BMail.txt
Censor.txt
ClickLog.txt
ELog.txt
Events.txt
Events2.txt
IpLog.txt
MaxLog.txt
MessageIcons.txt
Moderator.log
Names.txt
PortalConf.pl
PortalModules.pl
PortalSet.pl
Ranks.txt
Refer.txt
ReportPM.txt
RTemp.txt
Sids.sid
smiley.txt
Smililes.txt
ThemesList.txt
Version.txt

Do I need to keep any of those?

Oh, and where do I get the fixed version, and do I just upgrade it like I did my 10.2.5 version?

Thanks,
-Craig

GD was working with 10.2.5, so I am not sure why it isn't working now with the SQL version. Seems a bit odd actually. Also, why you say it is working here, what do you mean?

** EDIT ** It wasn't working...that was my other site :B. I had to upload Graph.pm to the GD directory to get it to work. All is fine with that now. So there is no way to get the old stats back?
-Craig.

No, old stats are forever gone. :(

You can remove everything but the files that are in the install that are in the Prefs directory (like RTemp.txt).

Are the fixes some where for me to download :P

What about BHits and Hits? Do I still need those?

Also, you do realize that there is no reason why RTemp.txt and News.txt couldn't be moved over to the database right? Actually, now that I think about it those should be either in the template directory, or in the database. My point to this is that you could get rid of the Prefs directory with the SQL directory if the BHits and Hits directory are not needed any more:) font.ttf could be moved to the GD directory for the human verify, and I have no idea what ips.txt is used for:) so I assume that could be moved somewhere else too...or gotten rid of :-/.

-Craig.

Print Topic - Archive