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
Googlebot and 1 Guests

E-Blah SQL Beta 2  This thread currently has 7,493 views. Print
3 Pages « 1 2 3 Recommend Thread
Justin
March 26, 2007, 7:28pm Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 15,080
Gender: Male
Posts Per Day: 6.43
Reputation: 93.42%
Reputation Score: +298 / -21
Time Online: 37 days 1 hours 13 minutes
Location: Tallassee, AL
Age: 22
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.  


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

  Donate to E-Blah!  

My Websites: Revolution Reality (My Blog)  |  MinistryTalk.com  |  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: 30 - 40
pakodi
March 26, 2007, 8:22pm Report to Moderator Report to Moderator
E-Blah Member
Posts: 121
Posts Per Day: 0.13
Reputation: 100.00%
Reputation Score: +3 / -0
Time Online: 2 days 14 hours 25 minutes
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.  


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

Logged Offline
Private Message Private message Reply: 31 - 40
pakodi
March 26, 2007, 8:30pm Report to Moderator Report to Moderator
E-Blah Member
Posts: 121
Posts Per Day: 0.13
Reputation: 100.00%
Reputation Score: +3 / -0
Time Online: 2 days 14 hours 25 minutes
Are you planning in future some thing like a database backup option from the admin panel for sql version.
Logged Offline
Private Message Private message Reply: 32 - 40
Justin
March 26, 2007, 8:31pm Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 15,080
Gender: Male
Posts Per Day: 6.43
Reputation: 93.42%
Reputation Score: +298 / -21
Time Online: 37 days 1 hours 13 minutes
Location: Tallassee, AL
Age: 22
Not in the immediate future, but later on probably.


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

  Donate to E-Blah!  

My Websites: Revolution Reality (My Blog)  |  MinistryTalk.com  |  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: 33 - 40
Craig
March 28, 2007, 11:13am Report to Moderator Report to Moderator

SQL Support Team
Posts: 3,619
Gender: Male
Posts Per Day: 2.07
Reputation: 97.73%
Reputation Score: +215 / -5
Time Online: 14 days 15 hours 11 minutes
Location: Germany
Age: 38
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.    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





Don't just ask a question.
Instead ask a question, give us a screen shot and post a link to your forum.
Help us help you make your forum better!


If I helped...increase my Reputation by clicking here.
Logged Offline
Site Site Private Message Private message ICQ ICQ Reply: 34 - 40
Craig
March 28, 2007, 11:24am Report to Moderator Report to Moderator

SQL Support Team
Posts: 3,619
Gender: Male
Posts Per Day: 2.07
Reputation: 97.73%
Reputation Score: +215 / -5
Time Online: 14 days 15 hours 11 minutes
Location: Germany
Age: 38
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 .  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.


Don't just ask a question.
Instead ask a question, give us a screen shot and post a link to your forum.
Help us help you make your forum better!


If I helped...increase my Reputation by clicking here.

Revision History (1 edits)
Craig  -  March 28, 2007, 11:44am
Logged Offline
Site Site Private Message Private message ICQ ICQ Reply: 35 - 40
Justin
March 28, 2007, 2:44pm Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 15,080
Gender: Male
Posts Per Day: 6.43
Reputation: 93.42%
Reputation Score: +298 / -21
Time Online: 37 days 1 hours 13 minutes
Location: Tallassee, AL
Age: 22
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).


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

  Donate to E-Blah!  

My Websites: Revolution Reality (My Blog)  |  MinistryTalk.com  |  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: 36 - 40
Craig
March 29, 2007, 12:40pm Report to Moderator Report to Moderator

SQL Support Team
Posts: 3,619
Gender: Male
Posts Per Day: 2.07
Reputation: 97.73%
Reputation Score: +215 / -5
Time Online: 14 days 15 hours 11 minutes
Location: Germany
Age: 38
Are the fixes some where for me to download


Don't just ask a question.
Instead ask a question, give us a screen shot and post a link to your forum.
Help us help you make your forum better!


If I helped...increase my Reputation by clicking here.
Logged Offline
Site Site Private Message Private message ICQ ICQ Reply: 37 - 40
Justin
March 29, 2007, 1:28pm Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 15,080
Gender: Male
Posts Per Day: 6.43
Reputation: 93.42%
Reputation Score: +298 / -21
Time Online: 37 days 1 hours 13 minutes
Location: Tallassee, AL
Age: 22
here



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



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

  Donate to E-Blah!  

My Websites: Revolution Reality (My Blog)  |  MinistryTalk.com  |  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: 38 - 40
Craig
March 29, 2007, 2:27pm Report to Moderator Report to Moderator

SQL Support Team
Posts: 3,619
Gender: Male
Posts Per Day: 2.07
Reputation: 97.73%
Reputation Score: +215 / -5
Time Online: 14 days 15 hours 11 minutes
Location: Germany
Age: 38
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.


Don't just ask a question.
Instead ask a question, give us a screen shot and post a link to your forum.
Help us help you make your forum better!


If I helped...increase my Reputation by clicking here.
Logged Offline
Site Site Private Message Private message ICQ ICQ Reply: 39 - 40
Justin
March 29, 2007, 6:08pm Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 15,080
Gender: Male
Posts Per Day: 6.43
Reputation: 93.42%
Reputation Score: +298 / -21
Time Online: 37 days 1 hours 13 minutes
Location: Tallassee, AL
Age: 22
Nah, Prefs is still lightly used.  Plus that's where Cache is at.  The two other directories are needed still as well.


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

  Donate to E-Blah!  

My Websites: Revolution Reality (My Blog)  |  MinistryTalk.com  |  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: 40 - 40
3 Pages « 1 2 3 Recommend Thread
Print

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