- Posts: 29
- Thank you received: 1
Any questions about Documents Sellers, post it here .
upgrade moving tables oddity in order date field
- Lisa Norman
- Topic Author
- Offline
- Junior Member
Less
More
11 years 11 months ago #23022
by Lisa Norman
upgrade moving tables oddity in order date field was created by Lisa Norman
Forgive me, I'm not the best with SQL.
I'm upgrading a site from 1.5 to 2.5 for a customer. I installed your latest version (purchased by the customer) for 1.5 on the old site, then did the upgrade. Installed the version for 2.5 on the new site. I then exported the _dms_ tables and imported them into the new database. WHEW!
And all my data is there! Yeah!
Except...
in the old site, the order date looks like: 12-17-2012
in the new site, the order date looks like: %12-%08-%2012
There are more sales than I feel comfortable manually editing the database. I'm also a little nervous that there may be other errors I'm not seeing yet.
Thoughts? Wisdom as to what I may have done wrong?
The dates are all still there and sort correctly. I'm not getting any errors... but I'm worried about this.
I'm upgrading a site from 1.5 to 2.5 for a customer. I installed your latest version (purchased by the customer) for 1.5 on the old site, then did the upgrade. Installed the version for 2.5 on the new site. I then exported the _dms_ tables and imported them into the new database. WHEW!
And all my data is there! Yeah!
Except...
in the old site, the order date looks like: 12-17-2012
in the new site, the order date looks like: %12-%08-%2012
There are more sales than I feel comfortable manually editing the database. I'm also a little nervous that there may be other errors I'm not seeing yet.
Thoughts? Wisdom as to what I may have done wrong?
The dates are all still there and sort correctly. I'm not getting any errors... but I'm worried about this.
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
11 years 11 months ago #23034
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re: upgrade moving tables oddity in order date field
Hi
1. The upgrade process you did is incorrect. You will need to import the database tables from Joomla 1.5 website into Joomla 2.5 website first, then install latest version of the extension to your Joomla 2.5 site. For now, please install latest version to your Joomla 2.5 site again .
2. For the format of the date, you will just need to go to Documents Seller -> Configuration, find the config option Date Format, change it (remove % character from the config option) and everything will work as expected .
Tuan
1. The upgrade process you did is incorrect. You will need to import the database tables from Joomla 1.5 website into Joomla 2.5 website first, then install latest version of the extension to your Joomla 2.5 site. For now, please install latest version to your Joomla 2.5 site again .
2. For the format of the date, you will just need to go to Documents Seller -> Configuration, find the config option Date Format, change it (remove % character from the config option) and everything will work as expected .
Tuan
Please Log in or Create an account to join the conversation.
Support
Documentation
Information
Copyright © 2024 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.