This article will discuss the cause of the error. "The sort order set for the database is different from the system one!" in 1C:Enterprise 7.7, as well as a way to eliminate it.

0. About the error

2. Changing the IS code page

If you work in 1C:Enterprise locally, or use 1C running any version, this error can be corrected as follows:

We launch 1C:Enterprise in configurator mode, then select the item “ Administration» — « IS code page».

In the window that opens, select from the list, at the very bottom “ +Current system installation " and click " OK».

We wait for the re-indexing to finish and calmly work with the information base.

3. Create the ordnochk.prm file

If users work with 1C:Enterprise 7.7. from computers on the network running different Windows versions(for example Windows XP and Windows 7), or you work with one database on different computers, let’s say at home and in the office, if the database is located on removable media, then you should create a file “ ordnochk.prm" and place it in the root folder with 1C:Enterprise installed (by default it is " C:\Program Files\1Cv77\BIN\"). This file will disable sort checking.

It's not that difficult to create. Create an empty file using Notepad and rename it to ordnochk.prm, with .txt on .prm

It should be remembered that when solving an error in this way, a problem may arise in displaying reports, and the order of the lines may not be entirely correct. Besides, this method not acceptable if a system of distributed information bases is used.

Did this article help you?

After installing 1C version 7.7 on a computer and launching it, the error “The sort order set for the database differs from the system one!” usually appears, what should you do in this case?

This problem can be solved in two ways:

1. Method

• You must ensure that the platform number is 7.7.
• Launch 1c. Select the desired information base and open it in the “Configurator” mode.
• Menu “Administration” -> “Code page of information security tables”.
• In the “Code page of information security tables” window, open the item “Current system installation” -> OK.
• The message “When changing the code page, the indexes of all data tables in the Information Base will be rebuilt!” will appear on the screen! Do you want to change the code page?" Click the “Yes” button.
• To the message “The code page has been changed!” click OK.
• Close the “Configurator” and launch the Information Base in normal 1C:Enterprise mode.

If several Information Bases turn out to be inoperative, then it is necessary to perform this procedure with each of these databases.

2. Method

• Launch text editor, for example, the Notepad editor.
• Then select “Save As” from the “File” menu. In the window that opens, click “File type”, select “All files”, and specify the file name as: OrdNoChk.prm. Save this file to the root directory information base, or to the 1C program directory (this file can be downloaded below).
• Launch the 1C program. In the Program Window, select the desired Infobase and click the “Change” button.
• In the window that opens, specify the path to the previously saved file, the 1c program is ready to launch.

If there are several Information Bases, then you need to place the OrdNoChk.prm file in each of them in this way.

Important: For beginners in 1C it will be easier to use the second option, since there is no need to perform actions with the information base and configuration.
For any actions, including the error “The sort order set for the database differs from the system one!” c information security or configuration, it is always recommended to create backups so that you can recover lost data.

Have you recently purchased new computer, installed 1C:Enterprise 7.7, transferred the database from the old computer and are waiting for more comfortable work darkened by the inscription on the screen:

This error occurs when the NT6 and 1C code tables do not match. There are 2 main ways to solve this problem.

1. If you work locally, on one computer and you do not need to periodically transfer the database to other computers, then the easiest way is to change the code page of the infobase, as shown in the figure below.

To do this, launch 1C:Enterprise in configurator mode, then select the item “ Administration» - « IS code page" And in the window that opens, select from the list, at the very bottom “ +Current system installation " and click " OK».

We wait for re-indexing, close the configurator and you can continue working, your data will not change or be lost.

2. This method should be used if in 1C:Enterprise 7.7. work on the network, and are still used different versions Windows (for example, Windows XP and Windows 7), or you work with one database on different computers, for example at home and in the office, in the case where the database is located on removable media.

The solution is also quite simple, you need to create a file “ ordnochk.prm"in any editor, for example in the same notepad. This file may be empty or may contain the line “Hello”, in this case it does not matter, the main thing is the correct file name.

It must be placed in the root folder with 1C:Enterprise installed (by default it is “ C:\Program Files\1Cv77\BIN\"). This file will disable sort checking.

If you have a network version and 1C:Enterprise is installed on each computer, then you need to place this file on each computer, this is important.

That's it, enjoy your work.

1C: what to do if the message “The sort order set for the database differs from the system one!” appears

The cause of the error is a mismatch between the system settings and the 1C settings.
By the way, if operating system is localized and the regional settings are set correctly, then when installing 1C its settings will be brought into line with the system ones.

Checking the settings are correct

I. System settings (for localized Russified version of Windows)

1. Open Start - Settings - Control Panel - Regional and Language Options.

2. On the Regional Settings tab, the drop-down list should be Russian.

3. On the Languages ​​tab – More details... – Languages ​​and text input services dialog box – Options tab – The default input language should be Russian-Russian.

4. On the Advanced tab there should be – Russian.

II. 1C settings

2. In the drop-down list In mode, select – OK.

4. In the Code page of infobase tables window, the drop-down list should contain – 1251 – Russian, Belarusian, Bulgarian and Serbian languages.

Notes

1. If you are using the DIMB component (distributed infobase management), - when sort order checking is disabled - you SHOULD NOT use characters of any alphabets other than Latin in the three-letter identifier of infobases included in the distributed database.

2. It should be borne in mind that disabling the sort order identity check can lead to unexpected results - for the user of the 1C program! – the order of lines, for example, when generating reports.

Fixing the error in Windows Vista

If you are using Windows Vista, then get rid of the message “The sort order set for the database is different from the system one!” the above methods will not work.

For this:

1. Launch the 1C program. In the Launch 1C window, select the desired information base.

2. In the drop-down list In mode, select Configurator – OK.

3. The Configurator will launch. Select menu Administration – Code page of information security tables...

4. In the Code page of infobase tables window, in the drop-down list, select + Current system installation – OK.

5. In the Configurator window with the message “When changing the code page, the indexes of all infobase data tables will be rebuilt! Do you want to change the code page?" click Yes.

6. After a certain period of time, depending on the size of the information security, the Configurator window will appear with the message “Code page has been changed!”, click OK.

7. Close the Configurator, you can work with the infobase.

8. To work with other information security systems, change the code page of information security tables in the same way.