Nawid wrote:I'm getting a SQL error whenever I want to post something (topic, reply, post, quote, etc etc)
Below is the error... Could someone please help me ?
Code: Select all
Algemene fout
SQL ERROR [ mysqli ]
Unknown column 'username' in 'field list' [1054]
That's because you are also using the old version of the "mod to the mod"....being notifications of new topics into the mchat table.
The previous version of the mchat stored user_id, username and user_colour into the mchat table, which wasn't necessarily the best way (eg a user could change user colour or even username).
The current version stores the user_id in the mchat table and then pulls the information from the users table that matches that user_id.
Let's use this as an example...you have a user who is a moderator that makes a chat, his user colouring due to "mod" status is green. If you then remove that individual from mod status, the user would have two colours if another message was made by that user. One being green, when he/she used to be in the moderator group, and one being the same as a registered user. Same would happen with name if the name was to change.
The new version, once the page is refreshed after the change (user name or colour), will make it so that the users name would show as similar throughout the forum....same as the colouring of that user.
Did that make any sense? FWIW, you can't use "mods of the mod" that were made for the previous version, but in the contrib folder of the new version, there are edits to make to files (like notification of new topics

) so that the previous functionalities will be the same. Pruning is now available in the 1.2.12 version as well as proper redirecting if on the custom page and hit the clean button, etc., etc.
Also, previously, if there were "disallowed" bbcodes set, the previous version wouldn't parse those bbcodes (eg, if bold was disallowed bolding "lorem ipsum decum showmetehmoney" would show up as this (ignore the space)
lorem ipsum decum showmetehmoney)
It wouldn't parse the bbcode but leave the code for the bbcode in the message of the chat...so you would see a post like
Code: Select all
[b]lorem ipsum decum showmetehmoney[/b]
What happens in this version? The bbcode tag is stripped from the message if disallowed, so, again using the [ b] tag, [ b]lorem ipsum decum showmetehmoney[/b] would show up as this "lorem ipsum decum showmetehmoney" Just the message is left without the bbcode tag that the user tried to use eventhough disallowed.
A lot of changes have been made to try and make the mod more complete have been made, hence the DEV status. None of us have anything "personal" against AllCity and have no idea why he/she was banned, we're just trying to make an already great mod just a tad bit better.
PS Does anyone know javascript by chance? Cuz I sure as heck don't. Not that I'm not willing to learn, but....
