Jump to ID:
Multimedia

Project Home

Documents

Discussions

Wiki

Project Info
Forum Topic - Aviage MME release 20.14 - Database schema mismatch: (4 Items)
   
 
 
Aviage MME release 20.14 - Database schema mismatch  
Hi,

We have tried updating our Aviage Mulitimedia Suite from v20.13 to v20.14 and when for example we plug in a USB memory 
stick with audio media files on it, during the database automatic synchronisation process we recieve the error:

Database Schema versions mismatched
File:mme.sql Database:main expected:30 got:<not found> File:mme_library.sql Database:mme_library expected:12 got:<not 
found> File:mme_temp.sql Database:mme_temp expected:7 got:<not found>


Does anyone know why we received this error?  It appears that some of the SQL libraries/binaries were not updated in the
 20.14 patch.


Regards,
Radek.


Re: Aviage MME release 20.14 - Database schema mismatch  
Radek Pesina wrote:
> Database Schema versions mismatched
> File:mme.sql Database:main expected:30 got:<not found> File:mme_library.sql Database:mme_library expected:12 got:<not 
found> File:mme_temp.sql Database:mme_temp expected:7 got:<not found>
> 
> Does anyone know why we received this error?  It appears that some of the SQL libraries/binaries were not updated in 
the 20.14 patch.

If the sql files weren't updated the expected result would show 
"expected:<new_version> got:<old_version>", but the result here says 
"not found".

I suspect that means you're either running the MME with a -V argument 
and qdb isn't running, or qdb is running but the .sql files weren't 
loaded (or aren't valid).

If you're looking at the source look at services/mme/lib/mme.c and 
lib/sql.c for references to the function sql_verify_database_versions().

-- 
Ryan J. Allen
QNX Software Systems
Re: Aviage MME release 20.14 - Database schema mismatch  
I'm guessing that your real database files have 0 size (see your qdb.cfg file for where you have pointed to create them)
.

Best delete the database files and see if QDB can create them again when you start it.  Run with verbosity on QDB to get
 more error output.  Make sure you're not putting the database files onto a CIFS, NFS, or /dev/shmem, none of those are 
supported.
Re: Aviage MME release 20.14 - Database schema mismatch  
Okay thanks, yes this problem was caused by some of the .sql files were missing. The folder name db which contains the 
necessary .sql files has gone for some reason after updating Aviage Multimedia Suite from 20.13 to 20.14. I think 
Momentics needs to be re-installed on the PC used as it has shown some abnormal behaviour which is not occurring on 
other installs.

Cheers,
Radek.