Forum Suggestions/Bugs

[Reach Term]

I can make a group where the rep system is disabled for them.
That includes giving and receiving just for them.

Thank you; however, No offence to people who do like it. To me, it's just boost people's egos, people would abuse it(A la groups of people repping one another to make them look good) and it's a troll tool. It's what I've seen and it's something that is most likely happen regardless of the clean of jobs you guys would have to do.

[Dark-Assassin]

I can make a group where the rep system is disabled for them.
That includes giving and receiving just for them.

Thank you; however, No offence to people who do like it. To me, it's just boost people's egos, people would abuse it(A la groups of people repping one another to make them look good) and it's a troll tool. It's what I've seen and it's something that is most likely happen regardless of the clean of jobs you guys would have to do.

I understand your point but unfortunately it's not my call.
Anyway, the group is set up.
You should be able to join it here: http://zandronum.com/forum/usercp.php?action=usergroups

[Reach Term]

True enough; Also I've joined...

[Qent]

Apparently it doesn't actually work yet....

[Dark-Assassin]

Hmm, you may have to set it as your Display group.
Anyway, i've set it for you Reach Term.

[VortexCortex]

Does the search page work for anyone else? If so, then there's some permission settings bug with the search (or users like myself are purposefully disallowed). If not, then you have a bug.

I also noticed that searching in the member page returns no results when it should.

I had a similar problem with phpBB 3.0.9.

My problems were two-fold.
First, I needed to enable the MySQL index:
ACP > Server Configuration sidebar > Search Settings > Search backend: [ fulltext mysql v ]

Secondly, the above admin page has/had incorrect instructions.

Search page system load limit:
If the 1 minute system load exceeds this value the search page will go offline, 1.0 equals ~100% utilisation of one processor. This only functions on UNIX based servers.

This is blatantly wrong, as you'll note if you look into the code itself. The field is actually treated as a percentage (0% to 100%) not a scalar (0.0 to 1.0). Thus, the number 1.0 actually equals 1% utilization of one processor.

Setting the value to 10 or 30 instead of 0.1 or 0.3 alleviated my issue.

I did attempt to file a bug report against 3.0.9, but was prevented by glaring bugs in their bug reporting system... WTF, indeed.

[Reach Term]

Is it possible to create an adults or maturely required sub forums in off topic? I would love to bring back the opinionated discussion a while back. However, the sub forums is viewed publicly but only those who have shown great deal of maturely can post it.

[Dark-Assassin]

@VortexCortex: The search system seems to work for even my test account with default user permissions.
Also this is MyBB with PostgreSQL, not PHPBB with MySQL.
I generally didn't like the idea of Postgre, especially as I and a few others had to manually fix sql queries.

@Reach Term: Most possibly not. It would be a hard thing to manage the the reason why it failed the last time is because of the immature people started showing up.
Also it would be one hell of a thing to manage.

[VortexCortex]

@VortexCortex: The search system seems to work for even my test account with default user permissions.

It's now working for me as well. However, I assure you that identical actions yielded no results at the time of my post -- My autocomplete history ensures it wasn't a typo on my part.

I've not looked into MyBB deeply, but it seems just as much a steaming pile of PHP as phpBB is. For instance, clicking this link
Results in a page with this data:

MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
42601 - ERROR: syntax error at or near "TTR" LINE 1: DELETE TTR.* FROM fork_threadsread AS TTR ^
Query:
DELETE TTR.* FROM fork_threadsread AS TTR INNER JOIN fork_threads AS TT ON TT.tid = TTR.tid WHERE TTR.uid = '362' AND TT.fid IN (20,44)

Please contact the MyBB Group for support.

At least for me...

I generally didn't like the idea of Postgre, especially as I and a few others had to manually fix sql queries.

Postgre is superior to MySQL in nearly every way. However, my business software supports several backends flawlessly; I realize different DBs have different commands. It's redarding that the MyBB group doesn't have the DB interaction layer abstracted. Blame the crap software, not the database.

[Dark-Assassin]

The SQL problem is fault on my part.
I tried to install the "View Unread Posts" addon but it's incompatible with PostgreSQL.

Anyway, if the DB doesn't work with the software, I'd rather find a DB that does work than changing the software.
MyBB is originally designed to use the MySQL database software.
I've always used MySQL with MyBB and it has shown no problems.
I know PostgreSQL is said to be better, but backwards compatibility is what it seems to lack.

It seems the MyBB team are working on having it completely compatible with Postgre but since a few things still had to be fixed manually, it's not complete.
I have noticed this while editing the php files that they have multiple handlers.
And also 90% of the plugins are built for MySQL but some are built for both but I'd usually get the error:

Code: Select all

SQL Error:
22P02 - ERROR: invalid input syntax for integer: "NULL"

IMO If MySQL was used in the first place with a tight security setup, everything would have worked out better.
All that needs to be done is deny access to the mybb database from all users except possibly a user called mybb.
The mybb user can only modify and read the mybb database only. It also cannot be connected to at all.

I was pretty strict with my MySQL setup on my server but never ran into any troubles.
Same happens if I change 'NULL' to NULL or even ''.

In the end, using 2 things that aren't completely designed for each other or one for the other will end up causing problems.

Edit:

<Dark-Assassin> c, what are your arguments for PostgreSQL?
<Dark-Assassin> Except for the fact almost nothing is compatible and it doesn't fully follow the SQL syntax.
<c> Dark-Assassin: It's just a different RDB, in my experience, it has no benefit over mysql.
<c> Also I don't know many places where it is used
<c> Where mysql is pretty much everywhere
<c> So, while it's probably not worse, it's not better either.

[DevilHunter]

So.. Was this Email notification thing fixed yet? I really like that feature, because sometimes, I forget about the topic I posted in, and almost never check it afterwards.

[Dark-Assassin]

I cannot do anything about the mail system. It's up to whoever owns the account.

[VortexCortex]

Same happens if I change 'NULL' to NULL or even ''.

That's because they are not integers...

My point was that the myBB folks do not provide a back-end abstraction layer. Instead they have coded to, and tested their code with, MySQL.

Do you remember when there were websites that only worked with the MSIE extensions to JavaScript? That's MySQL... MySQL is the only database I've ever used that messes up it's own protocol and returns nonsensical results. It's not ACID compliant... which should be a fundamental requirement of any DB, IMO. postgresql is ACID compliant.

That said: If you insist on using a website that was designed for MSIE, and breaks with standards compliant browsers, then use MSIE... (but it's the site devs who are fools).
If you insist on using pile of PHP that was designed to be used with MySQL, and breaks with standards compliant databases, then use MySQL... (but it's the board devs who are fools).

[Blzut3]

Actually MyBB does have a DBAL for most common commands. It's just very naive (they apparently think implode is just fine and dandy for forming a query). I could fix the DBAL but apparently Dark-Assassin doesn't want me to.

<c> Also I don't know many places where it is used

How about zdoom.org?

[Dark-Assassin]

I never said I didn't want you to. You can if you want, but you'd also have to discuss it with the rest of the staff.

[Ijon Tichy]

Mind changing the colors of the text field on the new topic/reply page to something that's actually readable? White on very light blue is about as readable as the sun. White on dark grey (like with the quick post) would be much, much better.

[Dark-Assassin]

I reverted the text editor to it's defaults.

[Ijon Tichy]

I'd still prefer white on dark grey (or black), but that works too.

[Dark-Assassin]

Well, I'll probably have a poke, no promises though.

[DevilHunter]

Seems that Topic Notification is fixed.. Just got an email from one of the Topics I replied too. Thanks a bunch. :p

EDIT: seeing as nobody wants to reply after my post.. I wanna know if more themes will be added soon. ATM, the Current themes are ok, but some of them show up quotes as part of the post, not as its own window inside the post. I hope you know what I mean.. The lines that surround the Quote/Code/whateva box is nearly invisible, thus it messes me up.

I really like the Quick Edit thing, but when your on a shitty connection, its almost unbearable. I lost half my post because of it. Any chance we could, if anyone has it, edit the old Blue theme?? (you know, cut out the Skulltag Logo Part). I really liked that theme.