z3n

Getting this error, not sure how to fix. @-RAW- SELECT count(*) FROM `awards_awards` WHERE award_cat_id = IS NULL IPS\Db\Exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IS NULL' at line 1 (1064) #0 /patch/to/forums/public_html/forum/system/Db/Select.php(356): IPS\_Db->preparedQuery('/*IPS\\Helpers\\T...', Array, true) #1 /patch/to/forums/public_html/forum/system/Db/Select.php(418): IPS\Db\_Select->runQuery() #2 /patch/to/forums/public_html/forum/system/Db/Select.php(339): IPS\Db\_Select->rewind() #3 /patch/to/forums/public_html/forum/system/Helpers/Table/Db.php(312): IPS\Db\_Select->first() #4 /patch/to/forums/public_html/forum/system/Helpers/Table/Table.php(466): IPS\Helpers\Table\_Db->getRows(Array) #5 /patch/to/forums/public_html/forum/applications/awards/modules/front/awards/awards.php(75): IPS\Helpers\Table\_Table->__toString() #6 /patch/to/forums/public_html/forum/system/Dispatcher/Controller.php(97): IPS\awards\modules\front\awards\_awards->manage() #7 /patch/to/forums/public_html/forum/applications/awards/modules/front/awards/awards.php(25): IPS\Dispatcher\_Controller->execute() #8 /patch/to/forums/public_html/forum/system/Dispatcher/Dispatcher.php(129): IPS\awards\modules\front\awards\_awards->execute() #9 /patch/to/forums/public_html/forum/index.php(13): IPS\_Dispatcher->run() #10 {main} NVM, I fixed the issue.

What about the new features, such as filters etc?

@fosters How is it going? Any news?

Did you fix the issue that messing up the Page's databases?

Any update on 1.1?

I am not sure if this has been mentioned before as I don't really have time to look back through this thread as I am at work. I was doing some debugging on my forums as I have been having issues with the "Pages" application. My issue was certain database settings were not saving when I saved them and after disabling and trying one application at a time I found that "Advanced Tags & Prefixes" is the application that is causing the problem. More indepth with the issue I was having: I would create a database, select a custom key, and change how the database is displayed "categories or not etc" When I would save the database, it would use the old database key, and the display settings would not save, every time I tried to change the settings the outcome was the same. After disabling the prefix app, it works fine now. I hope you are able to resolve this issue as I have plans to use this application but my databases working correctly is more important atm.

So let me get this right, I am making a user group for donors on my site, but here is how I want it to work. User A Donates -> If they donated within the amount range selected for the promotion to donor it checks to see if their primary group is NOT one of the excluded groups here: If their primary rank is one of the excluded groups, it changes their secondary to donor? Is that how it works>?

Would it be possible to change it from "Approve or Ban" to "Approve or Delete". I would prefer to just delete the account if my admins can't contact member to begin the joining process, and sometimes people just go afk. I want them to be able to register again in the case that we delete their registration.

Do you have any plans to support the rules application? I would love to automate a donation medal with some conditions via the rules app.

Any ETA on version 1.1?

That seems to have fixed it. Thanks!

Hey, where can i adjust where the post cabinet is displayed. Right now it is kind of hiding lol.

I sent you the login details, will appreciate the help.

After I heard my admin was unable to add/edit forms, I made a user group to test, I gave it full admin permissions, access to everything and my test account can not edit/add forms either, I have no clue what is preventing it. The only person that can do it is me, and I assume it is because I have the super admin account...

So since I have upgrade my forums to 4.1.7, I uninstalled the Forms app, and then redownloaded and installed the new one for 4.1 and now only I (the main admin) am able to make/edit forms in the acp. I have double and triple checked the administrator permissions and the settings are enabled so other admins can edit/make forms but for some reason they are not able to, all they see is the view form button beside the forms. When they click on "Add Form" nothing happens. Am I missing something?