Welcome to the E-Blah Community!
We would like to welcome you to our community and invite you to register an account or login.
Being a registered member is important, as it gives you several advantages over the normal Guest status. After registering you will be able to download files and images, post messages, and access member-only portions of the forum - just to name a few. Registration is quick and simple, and only takes about a minute of your time.

E-Blah Community    Informational    News  ›  E-Blah SQL Beta 2
Users Browsing Forum
No Members and 7 Guests

E-Blah SQL Beta 2  This thread currently has 7,373 views. Print
3 Pages 1 2 3 » Recommend Thread
Justin
March 23, 2007, 12:39pm Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 15,252
Gender: Male
Posts Per Day: 2.45
Reputation: 93.31%
Reputation Score: +307 / -22
Time Online: 39 days 5 hours 58 minutes
Location: Tallassee, AL
Age: 32
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.


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
Site Site Private Message Private message
pakodi
March 23, 2007, 5:38pm Report to Moderator Report to Moderator
E-Blah Member
Posts: 121
Posts Per Day: 0.02
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
Private Message Private message Reply: 1 - 40
Justin
March 23, 2007, 6:47pm Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 15,252
Gender: Male
Posts Per Day: 2.45
Reputation: 93.31%
Reputation Score: +307 / -22
Time Online: 39 days 5 hours 58 minutes
Location: Tallassee, AL
Age: 32
Hmm.  Were there any members converted?  Check the member list.


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
Logged Offline
Site Site Private Message Private message Reply: 2 - 40
pakodi
March 23, 2007, 6:54pm Report to Moderator Report to Moderator
E-Blah Member
Posts: 121
Posts Per Day: 0.02
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
Private Message Private message Reply: 3 - 40
Justin
March 23, 2007, 6:58pm Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 15,252
Gender: Male
Posts Per Day: 2.45
Reputation: 93.31%
Reputation Score: +307 / -22
Time Online: 39 days 5 hours 58 minutes
Location: Tallassee, AL
Age: 32
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.


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
Logged Offline
Site Site Private Message Private message Reply: 4 - 40
pakodi
March 23, 2007, 7:22pm Report to Moderator Report to Moderator
E-Blah Member
Posts: 121
Posts Per Day: 0.02
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
Private Message Private message Reply: 5 - 40
Justin
March 23, 2007, 8:12pm Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 15,252
Gender: Male
Posts Per Day: 2.45
Reputation: 93.31%
Reputation Score: +307 / -22
Time Online: 39 days 5 hours 58 minutes
Location: Tallassee, AL
Age: 32
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 .


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
Logged Offline
Site Site Private Message Private message Reply: 6 - 40
pakodi
March 23, 2007, 9:19pm Report to Moderator Report to Moderator
E-Blah Member
Posts: 121
Posts Per Day: 0.02
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
Private Message Private message Reply: 7 - 40
Justin
March 23, 2007, 9:21pm Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 15,252
Gender: Male
Posts Per Day: 2.45
Reputation: 93.31%
Reputation Score: +307 / -22
Time Online: 39 days 5 hours 58 minutes
Location: Tallassee, AL
Age: 32
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.  


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
Logged Offline
Site Site Private Message Private message Reply: 8 - 40
pakodi
March 23, 2007, 9:42pm Report to Moderator Report to Moderator
E-Blah Member
Posts: 121
Posts Per Day: 0.02
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
Private Message Private message Reply: 9 - 40
Justin
March 23, 2007, 9:45pm Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 15,252
Gender: Male
Posts Per Day: 2.45
Reputation: 93.31%
Reputation Score: +307 / -22
Time Online: 39 days 5 hours 58 minutes
Location: Tallassee, AL
Age: 32
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.


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
Logged Offline
Site Site Private Message Private message Reply: 10 - 40
pakodi
March 23, 2007, 10:06pm Report to Moderator Report to Moderator
E-Blah Member
Posts: 121
Posts Per Day: 0.02
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.



Logged Offline
Private Message Private message Reply: 11 - 40
Justin
March 23, 2007, 10:16pm Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 15,252
Gender: Male
Posts Per Day: 2.45
Reputation: 93.31%
Reputation Score: +307 / -22
Time Online: 39 days 5 hours 58 minutes
Location: Tallassee, AL
Age: 32
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.


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
Logged Offline
Site Site Private Message Private message Reply: 12 - 40
pakodi
March 23, 2007, 11:01pm Report to Moderator Report to Moderator
E-Blah Member
Posts: 121
Posts Per Day: 0.02
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
Private Message Private message Reply: 13 - 40
pakodi
March 23, 2007, 11:58pm Report to Moderator Report to Moderator
E-Blah Member
Posts: 121
Posts Per Day: 0.02
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
Private Message Private message Reply: 14 - 40
3 Pages 1 2 3 » Recommend Thread
Print

E-Blah Community    Informational    News  ›  E-Blah SQL Beta 2