Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
PatrickRQ Posted June 1, 2023 Posted June 1, 2023 Hi IPS, In Pages, I create a new database and custom field on it, OrderID, used to order the records in DB, it is Number type, however is being sorted as text, that means we have 1 11 2 22 3 instead 1 2 3 11 22
Marc Posted June 1, 2023 Posted June 1, 2023 Could you let me know which database, so I can take a look?
PatrickRQ Posted June 1, 2023 Author Posted June 1, 2023 (edited) MySQL 5.6, InnoDB Edited June 1, 2023 by PatrickRQ
Jim M Posted June 1, 2023 Posted June 1, 2023 46 minutes ago, PatrickRQ said: MySQL 5.6, InnoDB Sorry, there may be some confusion. My colleague is asking for the Pages Database name, not your MySQL database version.
PatrickRQ Posted June 1, 2023 Author Posted June 1, 2023 This is custom Pages database, by default Pages app has no databases. I just created new pages database, and in Options selected OrderID field as the one used to order records.
Jim M Posted June 1, 2023 Posted June 1, 2023 You would indeed need to give the Pages Database a name. Please let us know what that is and we can take a look at your configuration: We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you.
PatrickRQ Posted June 1, 2023 Author Posted June 1, 2023 (edited) It really matters? I named the database Faq Edited June 1, 2023 by PatrickRQ
Jim M Posted June 1, 2023 Posted June 1, 2023 As mentioned, please provide access: We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you.
Marc Posted June 2, 2023 Posted June 2, 2023 Please bear with us on this. I have just tagged a developer on this as I believe it may be related to an issue which we are aware of.
PatrickRQ Posted June 2, 2023 Author Posted June 2, 2023 53 minutes ago, Marc Stridgen said: Please bear with us on this. I have just tagged a developer on this as I believe it may be related to an issue which we are aware of. Oh great. Is that mean I do not need to provide access anymore? Thanks!
Marc Posted June 2, 2023 Posted June 2, 2023 1 hour ago, PatrickRQ said: Oh great. Is that mean I do not need to provide access anymore? Thanks! For the minute no
Management Matt Posted July 3, 2023 Management Posted July 3, 2023 The ordering issue isn't the same as the GH issue. I think we've (tried) to fix the sorting issue before. If you can give Marc some more information, we can take a look.
PatrickRQ Posted July 3, 2023 Author Posted July 3, 2023 (edited) What other info you need? It looks like it sorts numbers as it would sort strings. If you will e.g. do two columns, VARCHAR and INT, and do ASC SORT.. the VARCHAR will get 1112223 and INT will get 1231122 Edited July 3, 2023 by PatrickRQ
Marc Posted July 3, 2023 Posted July 3, 2023 Sorry, Im a little confused as to what you mean there. Both of those are sorted correctly as the first is correctly sorted as text (as thats the type you are using), and the latter as a number
Management Matt Posted July 3, 2023 Management Posted July 3, 2023 We’d need access to your site and database to see what the query is. We do cast it int if it’s numeric so something is going wrong there.
Recommended Posts