E-Blah SQL Beta 2 - E-Blah Community

The E-Blah Developer
E-Blah Programmer

Posts: 15,196

Gender:

Male

Posts Per Day: 4.38

Reputation: 93.25%

Reputation Score: +304 / -22

Time Online: 37 days 19 hours 48 minutes

Location: Tallassee, AL

Age: 25

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.

I do installs for $25 and upgrades for $20.
Technical support is always free.

Donate to E-Blah!

My Websites: Revolution Reality (My Blog) | Portfolio

"But you, O Lord, are a compassionate and gracious God, slow to anger, abounding in love and faithfulness." — Psalm 86:15 NIV

Revision History (3 edits)

Justin - March 26, 2007, 5:48pm

Justin - March 24, 2007, 8:36am

Justin - March 23, 2007, 9:26pm

Logged

Offline

pakodi

March 23, 2007, 5:38pm

E-Blah Member

Posts: 121

Posts Per Day: 0.06

Reputation: 100.00%

Reputation Score: +3 / -0

Time Online: 2 days 14 hours 25 minutes

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

Logged

Offline

Reply: 1 - 40

Justin

March 23, 2007, 6:47pm

The E-Blah Developer
E-Blah Programmer

Posts: 15,196

Gender:

Male

Posts Per Day: 4.38

Reputation: 93.25%

Reputation Score: +304 / -22

Time Online: 37 days 19 hours 48 minutes

Location: Tallassee, AL

Age: 25

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

Logged

Offline

Reply: 2 - 40

pakodi

March 23, 2007, 6:54pm

E-Blah Member

Posts: 121

Posts Per Day: 0.06

Reputation: 100.00%

Reputation Score: +3 / -0

Time Online: 2 days 14 hours 25 minutes

Quoted from Justin

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

Ya some 600+ members were converted out of 1400

Logged

Offline

Reply: 3 - 40

Justin

March 23, 2007, 6:58pm

The E-Blah Developer
E-Blah Programmer

Posts: 15,196

Gender:

Male

Posts Per Day: 4.38

Reputation: 93.25%

Reputation Score: +304 / -22

Time Online: 37 days 19 hours 48 minutes

Location: Tallassee, AL

Age: 25

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.

Logged

Offline

Reply: 4 - 40

pakodi

March 23, 2007, 7:22pm

E-Blah Member

Posts: 121

Posts Per Day: 0.06

Reputation: 100.00%

Reputation Score: +3 / -0

Time Online: 2 days 14 hours 25 minutes

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

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

Logged

Offline

Reply: 5 - 40

Justin

March 23, 2007, 8:12pm

The E-Blah Developer
E-Blah Programmer

Posts: 15,196

Gender:

Male

Posts Per Day: 4.38

Reputation: 93.25%

Reputation Score: +304 / -22

Time Online: 37 days 19 hours 48 minutes

Location: Tallassee, AL

Age: 25

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.

There's really no error checking with the installer like there is in the actual software .

Logged

Offline

Reply: 6 - 40

pakodi

March 23, 2007, 9:19pm

E-Blah Member

Posts: 121

Posts Per Day: 0.06

Reputation: 100.00%

Reputation Score: +3 / -0

Time Online: 2 days 14 hours 25 minutes

OK. I see some progress

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

Logged

Offline

Reply: 7 - 40

Justin

March 23, 2007, 9:21pm

The E-Blah Developer
E-Blah Programmer

Posts: 15,196

Gender:

Male

Posts Per Day: 4.38

Reputation: 93.25%

Reputation Score: +304 / -22

Time Online: 37 days 19 hours 48 minutes

Location: Tallassee, AL

Age: 25

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.

Logged

Offline

Reply: 8 - 40

pakodi

March 23, 2007, 9:42pm

E-Blah Member

Posts: 121

Posts Per Day: 0.06

Reputation: 100.00%

Reputation Score: +3 / -0

Time Online: 2 days 14 hours 25 minutes

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

Logged

Offline

Reply: 9 - 40

Justin

March 23, 2007, 9:45pm

The E-Blah Developer
E-Blah Programmer

Posts: 15,196

Gender:

Male

Posts Per Day: 4.38

Reputation: 93.25%

Reputation Score: +304 / -22

Time Online: 37 days 19 hours 48 minutes

Location: Tallassee, AL

Age: 25

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.

Logged

Offline

Reply: 10 - 40

pakodi

March 23, 2007, 10:06pm

E-Blah Member

Posts: 121

Posts Per Day: 0.06

Reputation: 100.00%

Reputation Score: +3 / -0

Time Online: 2 days 14 hours 25 minutes

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

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.

This post contains attachments; to download them you must login.

Logged

Offline

Reply: 11 - 40

Justin

March 23, 2007, 10:16pm

The E-Blah Developer
E-Blah Programmer

Posts: 15,196

Gender:

Male

Posts Per Day: 4.38

Reputation: 93.25%

Reputation Score: +304 / -22

Time Online: 37 days 19 hours 48 minutes

Location: Tallassee, AL

Age: 25

That's orange.

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.

Logged

Offline

Reply: 12 - 40

pakodi

March 23, 2007, 11:01pm

E-Blah Member

Posts: 121

Posts Per Day: 0.06

Reputation: 100.00%

Reputation Score: +3 / -0

Time Online: 2 days 14 hours 25 minutes

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

Logged

Offline

Reply: 13 - 40

pakodi

March 23, 2007, 11:58pm

E-Blah Member

Posts: 121

Posts Per Day: 0.06

Reputation: 100.00%

Reputation Score: +3 / -0

Time Online: 2 days 14 hours 25 minutes

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

Logged

Offline