Help : The structure table contains obsolete data

Hello all , I have the error message when I use JchemBase :





JChem version : 5.0.2.1


JVM : Sun Microsystems Inc. 1.5.0_15


OS : i386 Linux 2.6.18-6-486


Stack trace:


------------


chemaxon.jchem.db.DatabaseSearchException: The structure table contains obsolete data. Please regenerate the table.


at chemaxon.jchem.db.JChemSearch.initTable(JChemSearch.java:2916)


at chemaxon.jchem.db.JChemSearch.init(JChemSearch.java:3580)


at chemaxon.jchem.db.JChemSearch.search1(JChemSearch.java:2436)


at chemaxon.jchem.db.JChemSearch.search(JChemSearch.java:2333)


at chemaxon.jchem.db.JChemSearch.access$2000(JChemSearch.java:126)


at chemaxon.jchem.db.JChemSearch$SearchThread.run(JChemSearch.java:535)





I don't understand what should I do to resoud this problem, Can anyone help me ? thank you very much !!!!!!!

Please see answer for Question #31 in our FAQ:





http://www.chemaxon.com/jchem/FAQ.html#regenerate





Best regards,


Szabolcs

Chris,





Your structure tables have been created with an older JChem version.


Please use JChem Manager for regenerate that tables.





See this: http://www.chemaxon.com/jchem/doc/admin/#regener





Regards: Edvard

Hi,





Please see these links:





http://www.chemaxon.com/jchem/FAQ.html#regenerate


(question 31.)





http://www.chemaxon.com/jchem/FAQ.html#upgrade





http://www.chemaxon.com/jchem/doc/admin/index.html#regener





http://www.chemaxon.com/forum/ftopic753.html





http://www.chemaxon.com/forum/ftopic362.html&highlight=regenerate+table





Please let us know if this does not help.





Best regards,





Szilard

thank you very much for your reply, but in fact , I have not install jchembase, I just use those exemples for substructure search, so , I think it is not the upgrade problem , here is the structure of my table :





create table Molecule(


IDmol int(10) not null auto_increment primary key ,


cd_structure long varbinary not null,


Smiles VARCHAR(64000) not null,


Formula varchar(1000) not null,


MassExact double not null,


Hash integer not null,


Flags varchar(20) not null,


Timestamp datetime not null,


cd_fp1 integer not null,


cd_fp2 integer not null,


cd_fp3 integer not null,


cd_fp4 integer not null,


cd_fp5 integer not null,


cd_fp6 integer not null,


cd_fp7 integer not null,


cd_fp8 integer not null,


cd_fp9 integer not null,


cd_fp10 integer not null,


cd_fp11 integer not null,


cd_fp12 integer not null,


cd_fp13 integer not null,


cd_fp14 integer not null,


cd_fp15 integer not null,


cd_fp16 integer not null );


and now I am blocked down here, can anyone help ? thanks

Chris,





please check and post me your table version nr. in your JChem property table.





Edvard

+------------------------------------------+------------+----------------+


| prop_name | prop_value | prop_value_ext |


+------------------------------------------+------------+----------------+


| table.Molecule.fingerprint.numberOfBits | 512 | 0 |


| table.Molecule.fingerprint.numberOfEdges | 6 | 0 |


| table.Molecule.fingerprint.numberOfOnes | 2 | 0 |


+------------------------------------------+------------+----------------+


3 rows in set (0.10 sec)

Hi,





It seems you are not creating the JChem table with either JChemManager, Instant JChem or the JChem API, do you ?


I hope that you understand we cannot provide support for problems external to our software.





Best regards,





Szilard

Szilard : yes , you are right , I didn't create the table with Jchem Manager.


now , I create a table with Jchem manager, and there is no more problem. Thank you so much!!!!!!!