- Posts: 7
- Thank you received: 0
Upgrading from J 1.5 to J 2.5, using PHPMyAdmin
- tonyburgos
- Topic Author
- Offline
- New Member
Less
More
11 years 2 months ago #1432
by tonyburgos
Upgrading from J 1.5 to J 2.5, using PHPMyAdmin was created by tonyburgos
Hello, I have seen this post:
solidsystem.it/how-to-and-tutorials/149-...es-to-joomla-17.html
but I'm updating my Joomla site using a different tool (SPUpgrade).
After I upgraded my site, I moved the 3 customproperties tables from my J 1.5 site and imported them into my new J 2.5 site (using PHPMyAdmin), after I did that, I installed CP 2.3.5 (build180). It seems like things are working fine (I still have to test a little more), so, my question is:
what do you think of my migrating process, is it OK to do it like I did?
or did I break something and I'll have trouble with CP?
If my migration process is wrong, could you please tell me what steps should I follow to do it again? remember I don't use JUpgrade,
Thanks
After I upgraded my site, I moved the 3 customproperties tables from my J 1.5 site and imported them into my new J 2.5 site (using PHPMyAdmin), after I did that, I installed CP 2.3.5 (build180). It seems like things are working fine (I still have to test a little more), so, my question is:
what do you think of my migrating process, is it OK to do it like I did?
or did I break something and I'll have trouble with CP?
If my migration process is wrong, could you please tell me what steps should I follow to do it again? remember I don't use JUpgrade,
Thanks
Please Log in or Create an account to join the conversation.
- andrea_4g
- Offline
- Administrator
Less
More
- Posts: 1122
- Thank you received: 163
11 years 2 months ago #1433
by andrea_4g
Replied by andrea_4g on topic Upgrading from J 1.5 to J 2.5, using PHPMyAdmin
The procedure you followed is fine, as long as the articles kept their original ids after the migration.
In fact the table structure for Custom Properties is the same for the latest J 1.5 packages and the latest J 2.5 versions.
In fact the table structure for Custom Properties is the same for the latest J 1.5 packages and the latest J 2.5 versions.
Please Log in or Create an account to join the conversation.
- tonyburgos
- Topic Author
- Offline
- New Member
Less
More
- Posts: 7
- Thank you received: 0
11 years 2 months ago #1434
by tonyburgos
Replied by tonyburgos on topic Upgrading from J 1.5 to J 2.5, using PHPMyAdmin
ok, good to know.
thanks
thanks
Please Log in or Create an account to join the conversation.
- tonyburgos
- Topic Author
- Offline
- New Member
Less
More
- Posts: 7
- Thank you received: 0
11 years 2 months ago #1435
by tonyburgos
Replied by tonyburgos on topic PROBLEM Upgrading from J 1.5 to J 2.5, PHPMyAdmin
Actually, the J 1.5 and the J 2.5 DB seem to be different, please take a look at the following error message I got when trying to assign access = public to a property (see attached image):
Error while saving: TableCpfield: :store failed
Unknown column 'required' in 'field list' SQL=UPDATE `xxxxxxx_custom_properties_fields` SET `name`='location',`label`='Location',`field_type`='select',`modules`='',`published`='1',`required`='0',`access`='1',`ordering`='1' WHERE `id`='1'
so, the "required" field is missing, what other fields out there could be missing?
did you compare both DB structures?
could you advise how to fix this issue?
Thanks!
Error while saving: TableCpfield: :store failed
Unknown column 'required' in 'field list' SQL=UPDATE `xxxxxxx_custom_properties_fields` SET `name`='location',`label`='Location',`field_type`='select',`modules`='',`published`='1',`required`='0',`access`='1',`ordering`='1' WHERE `id`='1'
so, the "required" field is missing, what other fields out there could be missing?
did you compare both DB structures?
could you advise how to fix this issue?
Thanks!
Please Log in or Create an account to join the conversation.
- tonyburgos
- Topic Author
- Offline
- New Member
Less
More
- Posts: 7
- Thank you received: 0
11 years 2 months ago #1436
by tonyburgos
Replied by tonyburgos on topic PROBLEM Upgrading from J 1.5 to J 2.5, PHPMyAdmin
attaching image, it seems like it didn't attach
Please Log in or Create an account to join the conversation.
- andrea_4g
- Offline
- Administrator
Less
More
- Posts: 1122
- Thank you received: 163
11 years 2 months ago #1437
by andrea_4g
Replied by andrea_4g on topic Upgrading from J 1.5 to J 2.5, using PHPMyAdmin
I do confirm that:
- most recent CP version for J1.5: 2.0.5
- most recent CP version for J2.5: 2.3.5
have exactly the same table structure.
- most recent CP version for J1.5: 2.0.5
- most recent CP version for J2.5: 2.3.5
have exactly the same table structure.
Please Log in or Create an account to join the conversation.
Time to create page: 0.184 seconds