core: Unknown or invalid schema signature

[StaNov]

I just downloaded latest version (1.8.0.2) and uploaded it to my webhosting.

The installation keeps telling me this:

core: Unknown or invalid schema signature (6de40a4d5bad7a2923e769a4db1ff3b9 .. 833a0f36e10d073fb9e7fb3c8db4e8ef)

Running:
PHP	5.3
MySQL	5.6.14

I have googled solution for osticket 1.7, but it was not suitable for me.

Thanks for help.

[greezybacon]

This generally happens when you upload osTicket to a Windoze server via FTP in ASCII mode. If that's the case for you, re-upload the files in binary mode

[StaNov]

That worked. Thanks a lot 👍

[angelleye]

Hmmm...I'm getting this on Windows, but I used git clone. Any idea why that wouldn't work for me?

Seems to have worked fine when I downloaded the zip and extracted manually.

[greezybacon]

Re-upload the files with your FTP client set to BINARY mode

[angelleye]

I didn't upload or use FTP. I used Git clone.

[greezybacon]

It's a newline issue with the files. Perhaps you git is configured strangely where it isn't honoring the file formats in the upstream repo

[vikas-DabKick]

I downloaded it as zip and installed as per procedure no problem has occured.. but when I tried to install using a cloned copy I faced this problem

download the code as a zip file and unzip and try to install.

[ntozier]

@vikas-DabKick cross posting. Naughty.
I'm quite sure that you did not download 1.8.0.2 since it has not been available for download at osticket.com/download for around 2 years now. Please download current from http://osticket.com/download and try again.

[amitarunabh]

Just change the second part of signatures in the file-
include\upgrader\streams\core.sig

[stamminator]

Just change the second part of signatures in the file-
include\upgrader\streams\core.sig

This worked for me. I pasted in the second signature that it was failing to match against. I truly have no clue what I'm doing, but hey, "it worked"!
¯\_(ツ)_/¯

[andriitukai]

Just change the second part of signatures in the file-
include\upgrader\streams\core.sig

This worked for me. I pasted in the second signature that it was failing to match against. I truly have no clue what I'm doing, but hey, "it worked"!
¯_(ツ)_/¯

that worked, thanks

[ghost]

I downloaded it as zip and installed as per procedure no problem has occured.. but when I tried to install using a cloned copy I faced this problem

download the code as a zip file and unzip and try to install.

same for me.

[JediKev]

@augustineashal

I assume that when you cloned the repo you did not switch to the appropriate branch. In this case you'd clone it and use the 1.16.x branch as this contains the latest release v1.16.1.

Cheers.

[JediKev]

@sbocel

The Schema Signature is an MD5 hash of the setup/inc/streams/core/install-mysql.sql file. As new database tables and columns are added/modified/removed the aforementioned file changes so that new installs have the new, updated schema (structure). Naturally, when the file changes the MD5 hash changes. So you can think of it as like a serial number for a specific database schema. Now, with this in mind, we use the Schema Signature to check what your schema is and when you go to upgrade we can see what database patches/tasks need to be ran.

Cheers.