0
Hi Germinal,
I'm getting our new site live in the upcoming weeks. At the same time, I will upgrade to the latest version of IM on the new site. While trying to find out on which version we currently use on the old site, I noticed that I do not see a version number mentioned when looking at the Invoice Manager component via Extensions > Extension Manager > Manage > Invoice Manager.
Is there any other location I would be able to find this info ? I'm trying to find out what upgrade path to follow.
Thanks,
Mario
I'm getting our new site live in the upcoming weeks. At the same time, I will upgrade to the latest version of IM on the new site. While trying to find out on which version we currently use on the old site, I noticed that I do not see a version number mentioned when looking at the Invoice Manager component via Extensions > Extension Manager > Manage > Invoice Manager.
Is there any other location I would be able to find this info ? I'm trying to find out what upgrade path to follow.
Thanks,
Mario
Accepted Answer
0
just FYI, seems that the fields your missing are all these from 1.4.0 version. here's a quick MySQL help:
ALTER TABLE `#__invoices_invoices` ADD `language` VARCHAR(255) NOT NULL;
ALTER TABLE `#__invoices_invoices` ADD `last_sent` DATETIME NOT NULL;
ALTER TABLE `#__invoices_invoices` MODIFY `computed_total` DECIMAL(12,4) NOT NULL;
ALTER TABLE `#__invoices_invoices` MODIFY `discount` DECIMAL(12,4) NOT NULL;
ALTER TABLE `#__invoices_items` MODIFY `value` DECIMAL(12,4) NOT NULL;
ALTER TABLE `#__invoices_items` MODIFY `discount` DECIMAL(12,4) NOT NULL;
ALTER TABLE `#__invoices_items` MODIFY `tax` DECIMAL(12,4) NOT NULL;
ALTER TABLE `#__invoices_taxes` ADD `checked` TINYINT(1) NOT NULL;
ALTER TABLE `#__invoices_taxes` MODIFY `value` DECIMAL(12,4) NOT NULL;
ALTER TABLE `#__invoices_templateitems` MODIFY `value` DECIMAL(12,4) NOT NULL;
ALTER TABLE `#__invoices_templateitems` MODIFY `tax` DECIMAL(12,4) NOT NULL;
ALTER TABLE `#__invoices_invoices` ADD `language` VARCHAR(255) NOT NULL;
ALTER TABLE `#__invoices_invoices` ADD `last_sent` DATETIME NOT NULL;
ALTER TABLE `#__invoices_invoices` MODIFY `computed_total` DECIMAL(12,4) NOT NULL;
ALTER TABLE `#__invoices_invoices` MODIFY `discount` DECIMAL(12,4) NOT NULL;
ALTER TABLE `#__invoices_items` MODIFY `value` DECIMAL(12,4) NOT NULL;
ALTER TABLE `#__invoices_items` MODIFY `discount` DECIMAL(12,4) NOT NULL;
ALTER TABLE `#__invoices_items` MODIFY `tax` DECIMAL(12,4) NOT NULL;
ALTER TABLE `#__invoices_taxes` ADD `checked` TINYINT(1) NOT NULL;
ALTER TABLE `#__invoices_taxes` MODIFY `value` DECIMAL(12,4) NOT NULL;
ALTER TABLE `#__invoices_templateitems` MODIFY `value` DECIMAL(12,4) NOT NULL;
ALTER TABLE `#__invoices_templateitems` MODIFY `tax` DECIMAL(12,4) NOT NULL;
Responses (9)
-
Accepted Answer
-
Accepted Answer
0Hi Germinal,
On the new site, I definitely see 1.4.7 as version being mentioned in the spot that it should be.
I don't dare to install the latest version on the old site as I'm afraid I might break it and I need it as a source and as my invoicing portal until the new site goes live.
Would I be able to tell by looking at something in the database ?
I think it's a 1.3.x version, but not completely sure... It may as well be a 1.4.x version but don't know how to tell
Cheers,
Mario -
Accepted Answer
-
Accepted Answer
-
Accepted Answer
0OK !
In the meantime, I have exported the #_invoices_xxxxx tables from the 1.3.x/1.4.0 version and imported them into the 1.4.7 version. There are a few things I need to sort out which I took note of in the past.
I have seen an error message which I'm not sure it is related to my migration or not. I do see there are quite some additional lines in the en-GB.com_invoices.ini file so wil l will first make sure both en-GB and nl-BE ini files are identical and present. Also noticed that I'm seeing English output on the Flemish frontpage, but also here not sure it is related to outstanding work with language files. Will get back on this once I have covered them all and if the issue persists...
Thanks,
Mario -
Accepted Answer
0Hi Germinal,
I have updated the flemish language file I used for my old installation with the new lines present in the 1.4.7 ini file.
Flemish front-end is not correctly displaying text in Flemish.
I do have an error:
I cannot place it immediately - maybe you can ?
This happens when I open an existing invoice, and click save (w/ or w/o making changes). The changes made (if any) are not being saved.
I see this behavior when saving an invoice, a quote and taxes (see screenshot below)
How I did the migration
- I exported the #_invoices_xxxx tables from the 1.3.x/1.4.0 version.
- I updated the resulting sql file so that it matched the DB name and the tables prefix.
- Installed the 1.4.7 component, recurring invoices plugin en offline payments plugin on the new site.
- Enabled both plugins and configured the offline payments plugin
- Imported the previously exported and updated sql file into the MySQL: No errors. Checked the IM main screen: all data is there.
- Noticed already here that there's above error when saving an invoice in the 1.4.7 installation.
- Since not all was completed, continued updating the language files en updated a few other files in regards to thousands separator and hyphenation of amounts (things we spoke about in the past).
- After all above updates: went again to check whether the issue was still there: yes
Any idea what is causing this ?
Let me know if you need access to the site to verify things...
Thanks,
Mario -
Accepted Answer
0the problem with this update is that you missed some of the new fields in some DB tables.
what's causing this is missing fields in the DB. (actually, the error shows says exactly that, with the name of the field)
what I would do: make a separate (test) installation of invoice manager 1.4.7 (1.4.8 actually, we just upgraded it!) and check the DB. you will see all new fields.
then just go and add the missing fields into your current IM installation. -
Accepted Answer
Your Reply
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »