Malcolm M Posted September 12, 2023 Share Posted September 12, 2023 Hi Folks 👋 Im trying to import from XenForo 2.2.13 to Invision Community v4.7.13. However I keep running into this error: 2V101/A IPS\convert\_Library::process: Out of range value for column ‘pf_position’ at row 1 Can someone help me with looking into this error? Link to comment Share on other sites More sharing options...
Miss_B Posted September 12, 2023 Share Posted September 12, 2023 3 hours ago, DeezSkittles said: IPS\convert\_Library::process: Out of range value for column ‘pf_position’ at row 1  This error usually happens when a value that is trying to be inserted/assigned has a larger range than the maximum value for datatype INT. Can you try to change the datatype of the column in question from INT to BIGINT and see if it would help?   Link to comment Share on other sites More sharing options...
Marc Stridgen Posted September 12, 2023 Share Posted September 12, 2023 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.  Malcolm M 1 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted September 12, 2023 Share Posted September 12, 2023 Speaking to my colleague, the display order for fields is set to a number on xenforo which is very very large. If you change that value in the database, it will correct the issue. You should not however change the IPS database Miss_B and Malcolm M 2 Link to comment Share on other sites More sharing options...
Miss_B Posted September 12, 2023 Share Posted September 12, 2023 Changing the datatype of the aforementioned field from INT to BIGINT most likely will solve the issue. Malcolm M 1 Link to comment Share on other sites More sharing options...
Stuart Silvester Posted September 12, 2023 Share Posted September 12, 2023 27 minutes ago, Miss_B said: Changing the datatype of the aforementioned field from INT to BIGINT most likely will solve the issue. Please stop telling people to change their database structure. That will cause more problems than it solves. Link to comment Share on other sites More sharing options...
Miss_B Posted September 12, 2023 Share Posted September 12, 2023 2 minutes ago, Stuart Silvester said: Please stop telling people to change their database structure. That will cause more problems than it solves. With all due respect, first of all I am not telling anyone to do anything. All I did was giving an advice, which in this case will solve the issue that the OP is having imo. Because if there are more values being inserted that have a larger range than the maximum value for the datatype INT, the aforementioned error will happen again and again. Anyways, I was just trying to help.   Link to comment Share on other sites More sharing options...
Driven 2 Services Posted September 12, 2023 Share Posted September 12, 2023 (edited) Go into the Xenforo admin panel. From there go Users -> Custom User Fields Click each custom field, and make sure the display order is between 0 and 65535. Invision uses a smallint value for the display order, which means the maximum value it can hold is 65535. Xenforo uses a regular int, which can hold a value up to 4,294,967,295. Edited September 12, 2023 by Driven 2 Services Corrected max value! Marc Stridgen, Stuart Silvester and Malcolm M 3 Link to comment Share on other sites More sharing options...
Malcolm M Posted September 12, 2023 Author Share Posted September 12, 2023 (edited) Hey folks 👋 Thanks for all the replies The solution that @Marc Stridgen and @Driven 2 Services solved my issue. It was the Custom Field display order in XenForo causing the issue. The import worked without a problem. Edited September 12, 2023 by DeezSkittles Tried quoting both the posts but I failed. Driven 2 Services and Marc Stridgen 2 Link to comment Share on other sites More sharing options...
Jim M Posted September 12, 2023 Share Posted September 12, 2023 Glad to hear you found a solution to your issue 🙂 Malcolm M 1 Link to comment Share on other sites More sharing options...
Recommended Posts