Premiado

Bug Fix | MySQL/PHP Database

A fellow freelancer created a database for us to insert the Brazilian legislation in it. Brazilian laws have their own hierarchical structure, which was reproduced in the database. One of the levels of this hierarchy, called "incisos", is basically composed of a set of text extracts numbered in Roman numerals (I, II, III, IV etc.). The problem is that when we insert these text extracts in the database, they appear to be saved in a wrong order.

As far as I could notice, the bug appear after the tenth item is inserted. Fifteen items, following the Roman numeric order, should be reproduced like this:

I - lorem ipsum;

II - lorem ipsum;

III - lorem ipsum;

IV - lorem ipsum;

V - lorem ipsum;

VI - lorem ipsum;

VII - lorem ipsum;

VIII - lorem ipsum;

IX - lorem ipsum;

X - lorem ipsum;

XI - lorem ipsum;

XII - lorem ipsum;

XIII - lorem ipsum;

XIV - lorem ipsum;

XV - lorem ipsum.

At this point in time, the database automatically places the tenth and next items between the first and the second one, ending up like this:

I - lorem ipsum;

X - lorem ipsum;

XI - lorem ipsum;

XII - lorem ipsum;

XIII - lorem ipsum;

XIV - lorem ipsum;

XV - lorem ipsum.

II - lorem ipsum;

III - lorem ipsum;

IV - lorem ipsum;

V - lorem ipsum;

VI - lorem ipsum;

VII - lorem ipsum;

VIII - lorem ipsum;

IX - lorem ipsum;

If understanding the whole database structure is necessary to fix this bug, I can provide a thoroughly detailed explanation document.

Habilidades: Processamento de Dados, Javascript, MySQL, PHP, Arquitetura de software

Ver mais: freelancer roman, freelancer laws, freelancer ii, freelancer ending, database in freelancer, database for freelancer, roman iv, php database, mysql freelancer, ix, mysql inserted, fix bug freelancer, brazilian freelancer, php mysql bug fix, fix php database, database mysql php, php item point, database structure, mysql php database, database bug fix, order items database php, fix bug php, mysql hierarchical, hierarchical mysql, php mysql hierarchy

Acerca do Empregador:
( 7 comentários ) Rio de Janeiro, Brazil

ID do Projeto: #5096585

1 freelancer está ofertando em média $10 para este trabalho

vaquan

Hired by the Employer

$10 USD / hora
(10 Comentários)
5.4