Re: [phpOpenTracker-general] Problems with split_tables 1.0.1

This is a multi-part message in MIME format.
--------------070404010901060506060905
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
X-MIME-Autoconverted: from 8bit to quoted-printable by bat.berlios.de id j4U8p1m16740

Hello L=E9onard,

I've also upgraded my data but the split_tables.php needed a little=20
enhancement :)

I've attached the version which worked for me (I think, it was a while ag=
o).

The things I've changed:
* the schemes in the beginning
* the "insert into..." syntax

HTH

Andreas

L=E9onard Wauters schrieb:

> Hello,
>
> Im' migrating an old phpOpenTracker system (1.2.0) to 1.5.0 with=20
> merge_tables.
> I found the split_tables script, and planned to use it. So, first, I=20
> made a copy and an upgrade of the existing database with the=20
> 1_2_X_to_1_3_0.sql script.
> After that, I ran split_tables.php. It didn't effectively worked, look=20
> at the tables it has created :



--------------070404010901060506060905
Content-Type: application/x-php;
 name="split_table.ai.php"
Content-Disposition: inline;
 filename="split_table.ai.php"
Content-Transfer-Encoding: base64

IyEvdXNyL2xvY2FsL2Jpbi9waHAgLUNxCjw/cGhwCi8vCi8vICstLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0r
Ci8vIHwgcGhwT3BlblRyYWNrZXIgLSBUaGUgV2Vic2l0ZSBUcmFmZmljIGFuZCBWaXNpdG9y
IEFuYWx5c2lzIFNvbHV0aW9uICB8Ci8vICstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rCi8vIHwgQ29weXJp
Z2h0IChjKSAyMDAwLTIwMDMgU2ViYXN0aWFuIEJlcmdtYW5uLiBBbGwgcmlnaHRzIHJlc2Vy
dmVkLiAgICB8Ci8vICstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rCi8vIHwgVGhpcyBzb3VyY2UgZmlsZSBp
cyBzdWJqZWN0IHRvIHRoZSBwaHBPcGVuVHJhY2tlciBTb2Z0d2FyZSBMaWNlbnNlLCB8Ci8v
IHwgVmVyc2lvbiAxLjAsIHRoYXQgaXMgYnVuZGxlZCB3aXRoIHRoaXMgcGFja2FnZSBpbiB0
aGUgZmlsZSBMSUNFTlNFLiB8Ci8vIHwgSWYgeW91IGRpZCBub3QgcmVjZWl2ZSBhIGNvcHkg
b2YgdGhpcyBmaWxlLCB5b3UgbWF5IHJlYWQgaXQgb25saW5lICB8Ci8vIHwgYXQgaHR0cDov
L3d3dy5waHBvcGVudHJhY2tlci5kZS9saWNlbnNlLmh0bWwuICAgICAgICAgICAgICAgICAg
ICAgICB8Ci8vICstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rCi8vCi8vICRJZDogc3BsaXRfdGFibGVzLnBo
cCx2IDEuNCAyMDAzLzEyLzA1IDA1OjQ3OjAwIGJlcmdtYW5uIEV4cCAkCi8vCgpyZXF1aXJl
ICcuLi8uLi8uLi9waHBPcGVuVHJhY2tlci5waHAnOwoKJGFjY2Vzc2xvZ1NjaGVtYSA9CiJD
UkVBVEUgVEFCTEUgJXMgKAogICBgYWNjZXNzbG9nX2lkYCBpbnQoIDExICkgTk9UIE5VTEwg
ZGVmYXVsdCAnMCcsCiAgIGB0aW1lc3RhbXBgIGludCggMTAgKSB1bnNpZ25lZCBOT1QgTlVM
TCBkZWZhdWx0ICcwJywKICAgYGRvY3VtZW50X2lkYCBpbnQoIDExICkgTk9UIE5VTEwgZGVm
YXVsdCAnMCcsCiAgIGBleGl0X3RhcmdldF9pZGAgaW50KCAxMSApIE5PVCBOVUxMIGRlZmF1
bHQgJzAnLAogICBgZW50cnlfZG9jdW1lbnRgIHRpbnlpbnQoIDEgKSB1bnNpZ25lZCBOT1Qg
TlVMTCBkZWZhdWx0ICcwJywKICAgYHdlZWtkYXlgIHRpbnlpbnQoIDEgKSB1bnNpZ25lZCBO
T1QgTlVMTCBkZWZhdWx0ICcwJywKICAgYGhvdXJgIHRpbnlpbnQoIDIgKSB1bnNpZ25lZCBO
T1QgTlVMTCBkZWZhdWx0ICcwJywKICAgS0VZIGFjY2Vzc2xvZ19pZCAgIChhY2Nlc3Nsb2df
aWQpLAogICBLRVkgdGltZXN0YW1wICAgICAgKHRpbWVzdGFtcCksCiAgIEtFWSBkb2N1bWVu
dF9pZCAgICAoZG9jdW1lbnRfaWQpLAogICBLRVkgZXhpdF90YXJnZXRfaWQgKGV4aXRfdGFy
Z2V0X2lkKQogKSAlczsiOwoKJHZpc2l0b3JzU2NoZW1hID0KIkNSRUFURSBUQUJMRSAlcyAo
CiAgIGBhY2Nlc3Nsb2dfaWRgIGludCggMTEgKSBOT1QgTlVMTCBkZWZhdWx0ICcwJywKICAg
YHZpc2l0b3JfaWRgIGludCggMTEgKSBOT1QgTlVMTCBkZWZhdWx0ICcwJywKICAgYGNsaWVu
dF9pZGAgaW50KCAxMCApIHVuc2lnbmVkIE5PVCBOVUxMIGRlZmF1bHQgJzAnLAogICBgb3Bl
cmF0aW5nX3N5c3RlbV9pZGAgaW50KCAxMSApIE5PVCBOVUxMIGRlZmF1bHQgJzAnLAogICBg
dXNlcl9hZ2VudF9pZGAgaW50KCAxMSApIE5PVCBOVUxMIGRlZmF1bHQgJzAnLAogICBgaG9z
dF9pZGAgaW50KCAxMSApIE5PVCBOVUxMIGRlZmF1bHQgJzAnLAogICBgcmVmZXJlcl9pZGAg
aW50KCAxMSApIE5PVCBOVUxMIGRlZmF1bHQgJzAnLAogICBgdGltZXN0YW1wYCBpbnQoIDEw
ICkgdW5zaWduZWQgTk9UIE5VTEwgZGVmYXVsdCAnMCcsCiAgIGByZXR1cm5pbmdfdmlzaXRv
cmAgdGlueWludCggMSApIHVuc2lnbmVkIE5PVCBOVUxMIGRlZmF1bHQgJzAnLAogICBgd2Vl
a2RheWAgdGlueWludCggMSApIHVuc2lnbmVkIE5PVCBOVUxMIGRlZmF1bHQgJzAnLAogICBg
aG91cmAgdGlueWludCggMiApIHVuc2lnbmVkIE5PVCBOVUxMIGRlZmF1bHQgJzAnLAogICBQ
UklNQVJZIEtFWSAgICAgKGFjY2Vzc2xvZ19pZCksCiAgIEtFWSBjbGllbnRfdGltZSAoY2xp
ZW50X2lkLCB0aW1lc3RhbXApLAogICBLRVkgYG9zX3VhYCAoIGBvcGVyYXRpbmdfc3lzdGVt
X2lkYCAsIGB1c2VyX2FnZW50X2lkYCApICwKICAgS0VZIGBob3N0X2lkYCAoIGBob3N0X2lk
YCApICwKICAgS0VZIGByZWZlcmVyX2lkYCAoIGByZWZlcmVyX2lkYCApCiApICVzOyI7Cgok
Y29uZmlnID0gJnBocE9wZW5UcmFja2VyX0NvbmZpZzo6Z2V0Q29uZmlnKCk7CgpzcGxpdFRh
YmxlKCdhY2Nlc3Nsb2cnLCAkY29uZmlnWydhY2Nlc3Nsb2dfdGFibGUnXSk7CnNwbGl0VGFi
bGUoJ3Zpc2l0b3JzJywgICRjb25maWdbJ3Zpc2l0b3JzX3RhYmxlJ10pOwoKZnVuY3Rpb24g
c3BsaXRUYWJsZSgkdHlwZSwgJG5hbWUpIHsKICAkZGIgPSAmcGhwT3BlblRyYWNrZXJfREI6
OmdldEluc3RhbmNlKCk7CgogIGlmICghaXNfYSgkZGIsICdwaHBPcGVuVHJhY2tlcl9EQl9t
eXNxbF9tZXJnZScpKSB7CiAgICByZXR1cm4gcGhwT3BlblRyYWNrZXI6OmhhbmRsZUVycm9y
KAogICAgICAnTXlTUUwgTWVyZ2UgVGFibGVzIEhhbmRsZXIgbm90IGNvbmZpZ3VyZWQuJywK
ICAgICAgRV9VU0VSX0VSUk9SCiAgICApOwogIH0KCiAgJHRhYmxlcyA9IGFycmF5KCk7Cgog
ICRkYi0+cXVlcnkoCiAgICBzcHJpbnRmKAogICAgICAnU0VMRUNUIE1JTih0aW1lc3RhbXAp
IEFTIGZpcnN0X2VudHJ5LAogICAgICAgICAgICAgIE1BWCh0aW1lc3RhbXApIEFTIGxhc3Rf
ZW50cnkKICAgICAgICAgRlJPTSAlcycsCgogICAgICAkbmFtZQogICAgKQogICk7CgogIGlm
ICgkcm93ID0gJGRiLT5mZXRjaFJvdygpKSB7CiAgICAkZG9uZSAgICAgPSBmYWxzZTsKCiAg
ICAkbW9udGggICAgPSBkYXRlKCduJywgJHJvd1snZmlyc3RfZW50cnknXSk7CiAgICAkeWVh
ciAgICAgPSBkYXRlKCdZJywgJHJvd1snZmlyc3RfZW50cnknXSk7CgogICAgJGVuZE1vbnRo
ID0gZGF0ZSgnbicsICRyb3dbJ2xhc3RfZW50cnknXSk7CiAgICAkZW5kWWVhciAgPSBkYXRl
KCdZJywgJHJvd1snbGFzdF9lbnRyeSddKTsKCiAgICB3aGlsZSAoISRkb25lKSB7CiAgICAg
ICRzdGFydCA9IG1rdGltZSggMCwgIDAsICAwLCAkbW9udGgsIDEsICR5ZWFyKTsKICAgICAg
JGVuZCAgID0gbWt0aW1lKDIzLCA1OSwgNTksICRtb250aCwgZGF0ZSgndCcsICRzdGFydCks
ICR5ZWFyKTsKCiAgICAgICRuZXdUYWJsZSA9ICRuYW1lIC4gJ18nIC4gJHllYXIgLiBzcHJp
bnRmKCclMDJkJywgJG1vbnRoKTsKCSAgI2VjaG8gJG5ld1RhYmxlLiIgbnQgPGJyPiI7CiAg
ICAgICR0YWJsZXNbXSA9ICRuZXdUYWJsZTsKCiAgICAgJGRiLT5xdWVyeSgKICAgICAgICBz
cHJpbnRmKAogICAgICAgICAgJHR5cGUgPT0gJ2FjY2Vzc2xvZycgPyAkR0xPQkFMU1snYWNj
ZXNzbG9nU2NoZW1hJ10gOiAkR0xPQkFMU1sndmlzaXRvcnNTY2hlbWEnXSwKICAgICAgICAg
ICRuZXdUYWJsZQogICAgICAgICAgc3ByaW50ZigKICAgICAgICAgICAgJzs8YnI+SU5TRVJU
IElOVE8gJy4kbmV3VGFibGUuJwoJCQkgPGJyPlNFTEVDVCAqCiAgICAgICAgICAgICAgIEZS
T00gJXMKICAgICAgICAgICAgICBXSEVSRSB0aW1lc3RhbXAgQkVUV0VFTiAlZCBBTkQgJWQg
PGJyPicsCgogICAgICAgICAgICAkbmFtZSwKICAgICAgICAgICAgJHN0YXJ0LAogICAgICAg
ICAgICAkZW5kCiAgICAgICAgICApCiAgICAgICAgKSwKICAgICAgICBmYWxzZSwKICAgICAg
ICB0cnVlLAogICAgICAgIGZhbHNlLAogICAgICAgIGZhbHNlCiAgICAgICk7CgogICAgICBp
ZiAoJG1vbnRoID09ICRlbmRNb250aCAmJgogICAgICAgICAgJHllYXIgID09ICRlbmRZZWFy
KSB7CiAgICAgICAgJGRvbmUgPSB0cnVlOwogICAgICB9CgogICAgICBlbHNlIGlmICgkbW9u
dGggPCAxMikgewogICAgICAgICRtb250aCsrOwogICAgICB9IGVsc2UgewogICAgICAgICRt
b250aCA9IDE7CiAgICAgICAgJHllYXIrKzsKICAgICAgfQogICAgfQoKICAgICRkYi0+cXVl
cnkoCiAgICAgIHNwcmludGYoCiAgICAgICAgJ0RST1AgVEFCTEUgJXMnLAoKICAgICAgICAk
bmFtZQogICAgICApCiAgICApOwoKICAgICRkYi0+X2NyZWF0ZU1lcmdlVGFibGUoCiAgICAg
ICRuYW1lLAogICAgICAkdHlwZSwKICAgICAgJHRhYmxlcwogICAgKTsKICB9Cn0KCi8vCi8v
ICJwaHBPcGVuVHJhY2tlciBlc3NlbnlhLCBndWwgbWVsZXR5YTsKLy8gIFNlYmFzdGlhbiBj
YXJuZXJvbiBQSFAuIgovLwoKPz4K
--------------070404010901060506060905--