TDBF

There is a setting, what should happen if member clicks on the item link in Members -> Members Settings -> Profiles

In Pages, we can create a field with a type Number. The field is created as VARCHAR in MySQL. This does not allow us to sort by this field with correct alphanumeric order.
The sorting by this field results in:
1 10 2 42 9 You have to cast the values if ordered by this field
SELECT * FROM table_name ORDER BY CAST(field_name as SIGNED INTEGER) ASC EDIT: I mean the sorting in record feed block or getItemsWithPermission.

I have a Pages database where products are stored. 
I have defined two fields of type Number: Storage Place and Price. Both fields are required.
The list of what is not possible with the fields:
Sorting by these fields in record listing does not make sense as it sorts by characters and not by numbers Required does not make sense, as the fields are always pre-filled with 0  and stored with this value without an error message The database to reproduce the behavior on default Pages templates is attached.
The values I have entered to test are on the screenshot. This is a result of sorting by Storage Place. Sorting by Price does not change the order. 

Note: I know a technical background why this does not work. Please see this as a report from an end-user who tries to set up this kind of database in Pages.
Large_database.xml

It is always the same. Speaking about what is good is pretty dull. Complaining is so much easier. Let us complain, and you'll see the activity explosion in the thread. 

Can I Second this please.
I would have thought this would have been part of the export process since Pages templates would use CSS and JavaScript.

You're likely seeing something else - I can confirm that if a topic is truly linked to a database record, then the software intentionally blocks editing and merging on topics. If you need to edit it, you must edit the record, and when saved, the new contents is synchronized to the topic.

They are intended to be a direct copy of what is in the database record.  If you would like to see this changed, you're welcome to provide your feedback in our official Feature Suggestion forum for further evaluation.

What are you looking to edit exactly? It would be advised to update the Pages Database entry then re-sync the changes. This is intended functionality to not be able to edit directly.

Correct.
Must have been a glitch in the Matrix last night. 🙁 I originally had the quiz category set as min 5 and max 5 answers and then changed it to min 2 and max 5 answers and I would get the not enough answers error. Just tried it again on a different category and works fine.  I'm not sure why it would have done this, if it does it again I will do a bug trace on this.
 I created the quiz, the questions and answers and click on 'Allow play', however no Topic was created. I will test this laster and get back to you.

Hello.
You mean in the grid view on index, right? Just noticed it.
Can you elaborate? I'm able to add only 2 answers: 1, the right, and 2, the wrong:
 
The topic will be created only after you set the quiz as ready to people play. It won't create right after you create a quiz, which has no questions. This will call people's attention to an empty quiz. Is that the case?

I can certainly move this topic to our Feature Suggestion forum if you would like?

Yes, please.

A new version (4.6.11) has now been released which resolves this issue. Please upgrade to the latest release in order to get this fix.

It would be nice to see options to create multiple menus using menu manager and save them as separate positions to place where we want under some key.

I can confirm it. I've caught the bug with duplicate template too, deleting one and then loosing both. 

This issue is both an annoyance and a bug, one affects the other imo.
Application: CMD/Pages Bug: Renaming a template can cause duplicate of a Database template when it's imported via Themes Designer Mode or when creating another the Database Template with the same name. Not only does this bug break your own naming guidelines, but it can cause duplicates of the same database template which will lead to issues when deleting one of the duplicates within Database Templates window.
How to reproduce.
Create a Pages Database Template: Go to Themes ACP and click on the Designer Mode button, Enable Designers' Mode and Click Next and wait until all templates are exported to disk, Now disable Designers Mode and Synchronize the changes leaving the files on server, Return to the Pages Templates window and edit the Database Template previously created, do not edit the name, but just save the template name as is. Enable Designers' Mode and Click Next and wait until all templates are exported to disk, Go to the server where your IPB install is and navigate to /themes/cms/database directory and rename the Database Template you created previously so that it is all lower case, Now disable Designers Mode and Synchronize the changes leaving the files on server, There should now be two version of the Database template that you created. If you remove one of them, both will be deleted. Solution.
The reason for this happening is two fold.
When you originally create a database template, there are limitations places of the Database Template Name which are: Please use only a-z and 0-9 without any special characters or spaces. The title must start with a letter or underscore. When you edit a Database Template, the name will be displayed differently, it will be title case and without any underscores and I can save with spaces regardless of the limitations in place: Please use only a-z and 0-9 without any special characters or spaces. The group name must start with a letter or underscore. You can use an underscore, which will show as a space when viewing templates. The issue lies within the function databaseTemplateGroupOptions() (file: cms/modules/admin/pages/templates.php Line: 1004 😞
form->add( new \IPS\Helpers\Form\Text( 'cms_database_group_name', \IPS\cms\Templates::readableGroupName( \IPS\Request::i()->group ), NULL, array( 'regex' => '/^([A-Z_][A-Z0-9_\.\s]+?)$/i' ), function( $val ) Issues
Group Name Change: \IPS\cms\Templates::readableGroupName( \IPS\Request::i()->group ) Is the first issue. This changes the group variable from 'my_template_name' to 'My Template Name'.
On line 1026: This line here:
$new = str_replace( ' ', '_', $values['cms_database_group_name'] ); Should be changed to
$new = str_replace( ' ', '_', mb_strtolower($values['cms_database_group_name'])); As you can see from this part of the function, $new is not set to be lower case as it should be which when saving the field to the database and this can cause conflicts with importing later.
if ( $values = $form->values() ) { $new = str_replace( ' ', '_', $values['cms_database_group_name'] ); if ( $new != \IPS\Request::i()->group ) { \IPS\Db::i()->update( 'cms_templates', array( 'template_group' => $new ), array( 'template_location=? and template_group=?', 'database', \IPS\Request::i()->group ) ); foreach( \IPS\cms\Templates::$databaseDefaults as $field => $template ) { \IPS\Db::i()->update( 'cms_databases', array( 'database_template_' . $field => mb_strtolower( $new ) ), array( 'database_template_' . $field . ' =?', \IPS\Request::i()->group ) ); } unset( \IPS\Data\Store::i()->cms_databases ); $this->findAndUpdateTemplates( $new, \IPS\Request::i()->group ); } \IPS\Output::i()->redirect( \IPS\Http\Url::internal( 'app=cms&module=pages&controller=templates' . ( isset( \IPS\Request::i()->t_location ) ? '&t_location=' . \IPS\Request::i()->t_location : '' ) ), 'saved' ); } Sorry for the long-winded approach to this issue. 😋

Yes, it is another reproducible bug in IP Addresses Tool 
No security holes. Just a combination of two bugs. Sorry for the panic!

*Warning RANT*
Tonight I decided to update all my database templates for this application mainly due to upgrading to PHP 8 and all the changes done to the templates over the last few updates.
Every time I go to do work on this, my heart always sinks because I detest working on the templates via the admin area. The first thing to happen tonight, I reverted one of the templates and it was gone, deleted, *poof* without a warning or anything.
This is usually the point where I say to myself; (Insert some swear words) it would be easier for me to write an application which would allow me to convert all my databases over to WordPress (I have done this before). However, I detest WordPress more mainly due to its lack of actual template system (The irony is not lost on me here) and not being able to tie users across both CMS's without jumping through hoops and costing a fortune.
I honestly have a total love hate relationship with this application. I love the power of it, but I hate the MANY bugs, flaws and the implementation of the templates area within the Pages ACP.
I have 100's of different templates for many different databases, and it is a PITA to navigate all because someone thought it was a neat idea to order them in order by the date the templates were last modified 😕 !!
Template Ordering
This is the default ordering of Database templates is to display templates by last edited. While this might be okay for a few templates, it's a bloody nightmare when you have 100's of different templates.
This is the default ordering for just the Database templates:

This the order after I wrote a plug-in to order database templates in a more readable form.

This is what I would have to content with when dealing with the default order in a working environment. There is no structure this at all and it's just a complete an utter eye sore and total mess. If you are wondering why there are spaces in my template names, it's because I changed the code to allow this.

This is the database templates ordered in a more readable order by name.

Parent Category for Database Templates.
Adding new Database templates is a nightmare as well. Instead of just being able to copy the default or a user database templates all in one go, I have to do this separately for Category List, Feature Lists, Recording listings etc etc. It is so time consuming having to do this over and over.
I would prefer to create Database Template Category and select all the different Template types for that Category using a multi-select option for this.
For example:

This way, if I need to copy database templates, then I just need to copy the parent and the children in one go.
Any one who has worked with the template system, knows how badly thought out this whole part is. Trying to copy, move, save,  rename, export and import templates is a total nightmare.
Template Naming
Also, the naming of templates goes against what you already have as the defaults database templates. You do not allow spaces in template names, yet your own templates uses them. Spaces are used for readability purposes, if you can use spaces in Theme Templates why change naming convention here?

Updates and QOL life changes.
This application has had no real love at all. It's basically the same as it was when version 4 was released. The only changes have been bug fixes and changes forced due to the core changes. I have seen many topics with feature requests to this Application and they go ignored time and time again.
The engine behind this application is really powerful, yet the front end templates are a complete and utter joke and have no value in the real word. If I wanted a forum clone, I would have used my forums instead. Out of the box, this application is disappointing. If it were not for people like @opentype doing a lot of good work with his templates etc, people would have dumped this application a long time ago as it is not what people expect from an Article Management system.
Will you give this Application some love and attention please!
My apologies for the rant...... I would rather have my nails pulled out one at a time than work on this application.

*Warning RANT*
Tonight I decided to update all my database templates for this application mainly due to upgrading to PHP 8 and all the changes done to the templates over the last few updates.
Every time I go to do work on this, my heart always sinks because I detest working on the templates via the admin area. The first thing to happen tonight, I reverted one of the templates and it was gone, deleted, *poof* without a warning or anything.
This is usually the point where I say to myself; (Insert some swear words) it would be easier for me to write an application which would allow me to convert all my databases over to WordPress (I have done this before). However, I detest WordPress more mainly due to its lack of actual template system (The irony is not lost on me here) and not being able to tie users across both CMS's without jumping through hoops and costing a fortune.
I honestly have a total love hate relationship with this application. I love the power of it, but I hate the MANY bugs, flaws and the implementation of the templates area within the Pages ACP.
I have 100's of different templates for many different databases, and it is a PITA to navigate all because someone thought it was a neat idea to order them in order by the date the templates were last modified 😕 !!
Template Ordering
This is the default ordering of Database templates is to display templates by last edited. While this might be okay for a few templates, it's a bloody nightmare when you have 100's of different templates.
This is the default ordering for just the Database templates:

This the order after I wrote a plug-in to order database templates in a more readable form.

This is what I would have to content with when dealing with the default order in a working environment. There is no structure this at all and it's just a complete an utter eye sore and total mess. If you are wondering why there are spaces in my template names, it's because I changed the code to allow this.

This is the database templates ordered in a more readable order by name.

Parent Category for Database Templates.
Adding new Database templates is a nightmare as well. Instead of just being able to copy the default or a user database templates all in one go, I have to do this separately for Category List, Feature Lists, Recording listings etc etc. It is so time consuming having to do this over and over.
I would prefer to create Database Template Category and select all the different Template types for that Category using a multi-select option for this.
For example:

This way, if I need to copy database templates, then I just need to copy the parent and the children in one go.
Any one who has worked with the template system, knows how badly thought out this whole part is. Trying to copy, move, save,  rename, export and import templates is a total nightmare.
Template Naming
Also, the naming of templates goes against what you already have as the defaults database templates. You do not allow spaces in template names, yet your own templates uses them. Spaces are used for readability purposes, if you can use spaces in Theme Templates why change naming convention here?

Updates and QOL life changes.
This application has had no real love at all. It's basically the same as it was when version 4 was released. The only changes have been bug fixes and changes forced due to the core changes. I have seen many topics with feature requests to this Application and they go ignored time and time again.
The engine behind this application is really powerful, yet the front end templates are a complete and utter joke and have no value in the real word. If I wanted a forum clone, I would have used my forums instead. Out of the box, this application is disappointing. If it were not for people like @opentype doing a lot of good work with his templates etc, people would have dumped this application a long time ago as it is not what people expect from an Article Management system.
Will you give this Application some love and attention please!
My apologies for the rant...... I would rather have my nails pulled out one at a time than work on this application.

Hi IPS,
Please can you fix the the Google Fonts integration as the new improved API has been out for some time now?
Themes > Core > Global > Global > includeCSS template:
{{if ( theme.headline_font && theme.headline_font !== 'default' ) || ( theme.body_font && theme.body_font !== 'default' ) }} {{if theme.headline_font == theme.body_font}} <link href="https://fonts.googleapis.com/css?family={expression="\IPS\Http\Url::encodeComponent( \IPS\Http\Url::COMPONENT_FRAGMENT, \IPS\Theme::i()->settings['body_font'] )"}:300,300i,400,400i,500,700,700i" rel="stylesheet" referrerpolicy="origin"> {{else}} {{if ( theme.headline_font && theme.headline_font !== 'default' )}} <link href="https://fonts.googleapis.com/css?family={expression="\IPS\Http\Url::encodeComponent( \IPS\Http\Url::COMPONENT_FRAGMENT, \IPS\Theme::i()->settings['headline_font'] )"}:300,300i,400,500,400i,700,700i" rel="stylesheet" referrerpolicy="origin"> {{endif}} {{if ( theme.body_font && theme.body_font !== 'default' )}} <link href="https://fonts.googleapis.com/css?family={expression="\IPS\Http\Url::encodeComponent( \IPS\Http\Url::COMPONENT_FRAGMENT, \IPS\Theme::i()->settings['body_font'] )"}:300,300i,400,400i,500,700,700i" rel="stylesheet" referrerpolicy="origin"> {{endif}} {{endif}} {{endif}} I know the old links are still compatible Google provid the new V2 links some time ago, they supposedly offer various improvements, new variable fonts, reduced latency, smaller code, display: swap etc.
The new link are similar to:
<link href="https://fonts.googleapis.com/css2?family=Inter:wght@300;400;500;700&display=swap" rel="stylesheet"> Or for the variable fonts versions:
<link href="https://fonts.googleapis.com/css2?family=Inter:wght@300..700&display=swap" rel="stylesheet"> <link href="https://fonts.googleapis.com/css2?family=Inter:slnt,wght@-10..0,300..700&display=swap" rel="stylesheet"> https://developers.google.com/fonts/docs/css2
https://web.dev/variable-fonts/
 
 
 

I already did this Daniel.
I was going to release it to the public, however due to a hard disk failure, cloud sync error and a drunken night in where I feed large quantities of alcohol into my floppy disk bay, I lost all the code.
You know, all the normally excu... issues we developers face daily.

I already did this Daniel.
I was going to release it to the public, however due to a hard disk failure, cloud sync error and a drunken night in where I feed large quantities of alcohol into my floppy disk bay, I lost all the code.
You know, all the normally excu... issues we developers face daily.

No need to edit template. Custom field would do the same 😉

Pay attention to Default Value! It has to be filled out in order of the field to be displayed.
 

 

Marc,
Thank you very much you are a gem!
 
Thank you,
Much appreciated, this install is from 3.4 and has a lot of entries from that version.