Using 1.9.3 we're suddenly unable to successfully create new Test Projects with consistent DB records.
The nodes_hierarchy table gets a new entry with a new id, for example 102020.
The mysql_insert_id, however is, for example 8545055, and that becomes the id value for the testprojects table.
The new Test Project is therefore not found by the SQL join between those two tables: nodes_hierarchy & testprojects.
We recently went well over 100,000 nodes in our nodes_hierarchy table and the last successfully created Test Project has an id value of 100295 appearing in both nodes_hierarchy & testprojects.
Has anyone seen something similar or have any thoughts? thanks!
issue with auto increment value from nodes_hierarchy table
Moderators: Amaradana, TurboPT, TL Developers
Re: issue with auto increment value from nodes_hierarchy tab
first time see this error reported
silly question: have you checked if MySQL have some limitations on autoincremented ID ?
can you provide your db for tests ?
(contact testlink.helpme@gmail.com)
silly question: have you checked if MySQL have some limitations on autoincremented ID ?
can you provide your db for tests ?
(contact testlink.helpme@gmail.com)