As a rule, most users who find an error in the system indicating that the sort order differs from the system one are apparently working with the 1C package version 7.7. It is this that is most vulnerable not even in terms of the effects of viruses, but also in the area of ​​errors and failures that lie in the program code of the package itself. However, when you receive an error message stating that the sort order is different from the system, there is no need to panic. There are several simple solutions that can fix this problem quickly and permanently. In this case, at least two solutions can be applied.

Database error "The sort order is different from the system": what is the problem?

The problem itself is that the main program in the form of an executable file on the server or client machine cannot initialize the database (SQL).

As a result, connected user (child) terminals cannot access the database itself (although the main core of the program starts without problems). It is believed that access to the application itself is provided precisely at the level of the server version, which is responsible for connecting other user computers located on the local network. This is precisely where problems arise.

The sort order is different from the system one (Windows 7). What to do first?

It is believed that in release number 26 the ability to ignore database files was included. But you shouldn't rely on this service.

Non-existent object

It happens that an application, when launched, refers to a supposedly non-existent object in the form of the OrdNoChk.prm file, which seems to be located in the BIN folder of the program itself, installed in the system program files.

If a system message appears stating that the sort order is different from the system one, there is nothing easier than creating an empty file in this directory with the same name and replacement when saving, for example, in the same Notepad, which is included in the standard set of any Windows -systems. Another question here is that the standard text editor of the settings, containing the initial data, does not work when directly edited and subsequently applied in action.

Changing the database structure based on local data exchange

On the other hand, the problem that a failure occurs with a message indicating that the sort order of the installed one differs from the system one can be solved even by means of the installed program itself.

But here you should initially think about how advisable it is to use the tools and tools described below.

If an error occurs when it is reported that the sort order of the database differs from the system one, in the 1C application itself you should select the configuration section in which you need to go to administration, the code page of the information security tables and the current system installation item.

Conclusion

In principle, the message that the sort order in the 1C database differs from the system one can be deleted quite simply (or get rid of it forever). As practice shows, in the simplest case, you can simply create the empty object indicated above. After that, signaling that the sort order differs from the system one will no longer appear.

In fact, eliminating the problem is not limited to just these solutions. The fact is that in the 1C environment itself you can write scripts or create additional applets to control the entire system based on the same Visual Basic language using DVB format databases. Otherwise, the error associated with the appearance of the message indicated above can be eliminated quite simply, if you do not take into account flaws in the code of the program itself or viral influence. But this, I think, is not the worst thing. Sometimes the “crankiness” of users who do not know how to organize a database and connect it to an installed program can lead to this type of error appearing again and again.

You should also pay attention to the fact that when automatic data exchange of the platform itself with other databases is enabled, they must all have exactly the same encoding. If it is not installed for all databases, then the very question of importing and exporting data becomes, to put it mildly, meaningless. As a last resort, as mentioned above, encoding should be disabled. This is especially true for situations when different terminals have different versions of Windows installed, and even with different architectures. This can also lead to unpredictable consequences, to the point where it will be impossible to work with the program regarding simultaneous access to information.

The sort order set for the database does not match the system one

The cause of the error is a mismatch between the system settings and the 1C settings.
By the way, if the 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

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

As a last resort, it is sometimes recommended to disable sort order matching checking. To do this, you need to create a signal file named OrdNoChk.prm (with arbitrary content) in the infobase directory. But:
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.

Troubleshooting 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.

If an error occurs when connecting to the sql server, copy the windows/system32 files sqlsrv32.dll and sqlsrv32.rll from a computer with winXP to a computer with Vista (after having given permission to overwrite them)

You recently bought a new computer, installed 1C:Enterprise 7.7, transferred the database from the old computer, and your expectations for more comfortable work were overshadowed 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 a network, and you also use different versions of 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.

At the moment, few people use 1C version 7.7, but there are still organizations that, for one reason or another, cannot switch to newer platforms. In my practice, I haven’t seen configurations written in 7.7 for a long time. But just recently I had to deal with 7. In the process I encountered such a problem. When running on different versions of Windows, the same error constantly appears. Namely, the sort order set for databases differs from the system one. There are two ways to solve this; let’s look at each of them in more detail.

How to disable 1c code page checking

Changing the code table

The easiest way is to change the code page in the 1C program. To do this, launch the program in configurator mode. Next, go to Administration - Code page of information security tables.

In the window that appears, select + Current system installation and click OK.

After which the program should start, but there is one caveat: if users from different operating systems work in this configuration, for example Windows XP and Windows 7, then when starting on a different version you will need to do similar actions each time.

Disabling code page checking

This method is much better and simpler. You can disable code page checking in 1C. To do this, you need to create a file named ordnochk.prm and place it in the program folder at this path C:\Program Files\1Cv77\Bin. If you do not have a Bin directory, place the file in the directory above. C:\Program Files\1Cv77\

The 1C program is on a different path for me, so don’t pay attention to it. That’s all, if something doesn’t work out, write in the comments, I’ll try to answer and help everyone.

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 the 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.

Troubleshooting 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.