Error Saving Products in quote Issue

GFitch
GFitch
Offline
0
Hello

I have just upgraded to the latest version of Invoice Manager and the products will not load when I try to create a new Quote or Invoice. Once the Save button is pressed, the system freezes in the 'saving' cycle, and I have to exit the software back into joomla admin to escape.

Also non of my previous quotes or invoices are showing up in either the Quote or Invoice areas?

Can you point me in the right direction please?

Thanks
Responses (10)
  • Accepted Answer

    Wednesday, August 24 2016, 05:38 PM - #Permalink
    0
    hello

    can you please try to simply REFRESH the page? this way the new JS files will be reloaded from browser cache.
    The reply is currently minimized Show
  • Accepted Answer

    GFitch
    GFitch
    Offline
    Thursday, August 25 2016, 08:17 AM - #Permalink
    0
    Hello

    Thanks for the reply - Yes I cleared cache both in the browser and within Joomla before adding items to a quote. This had no effect.

    I then created a full quote with 6 new items and clicked the save button. This just froze the screen again. I clicked the 'refresh' browser
    function on the browser toolbar; and this deleted all the new data entered in the quote, including the proposed recipient details.

    I repeated the quote creation and simply clicked the refresh and F5 but this just deleted the data in the recipient fields (obviously as the data had not been saved in the first place).

    The process of opening the Invoice Manager and moving between the various tabs within is extremely slow. I have re-installed the programe and I note that there is now an error message displayed: See screen-shot attached.

    Please advise. - Many thanks
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, August 25 2016, 02:55 PM - #Permalink
    0
    hello,

    i see. ok, please send me joomla backend access and I'll take a look ASAP.

    PS: I'm out of town right now and I have limited internet connection, so I may not be able to answer right away...
    The reply is currently minimized Show
  • Accepted Answer

    GFitch
    GFitch
    Offline
    Thursday, August 25 2016, 08:51 PM - #Permalink
    0
    Hi

    Thanks for the contact, OK I have set you up as a temporary super-user as requested:

    http://fitchmarketing.com/administrator/index.php
    Username: Germinal
    Password: Germinal6325

    Cheers
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, August 27 2016, 05:20 PM - #Permalink
    0
    hello,

    well, basically it looks like something went wrong during the installation and a DB field (at least 1) is missing.

    this field is called tax_id and it's from the table #__invoices_items and its and INT(11)

    do you have access to phpMyAdmin and think you can add it yourself?
    The reply is currently minimized Show
  • Accepted Answer

    GFitch
    GFitch
    Offline
    Sunday, August 28 2016, 12:17 PM - #Permalink
    0
    Hello Support

    Yes I do have access to phpMyAdmin; let me know exactly what fields I need to create and Ill have a go; failing that, do you think a complete re-install will do the trick?

    Cheers.
    The reply is currently minimized Show
  • Accepted Answer

    Monday, August 29 2016, 02:29 PM - #Permalink
    0
    hello,

    well, for starters, the field I mentioned earlier is the one causing the error...
    if you create that one, does it keep doing the same?
    The reply is currently minimized Show
  • Accepted Answer

    GFitch
    GFitch
    Offline
    Monday, August 29 2016, 11:00 PM - #Permalink
    0
    Thanks for your reply - Noted.

    I have attached 3 x screen-shots which relate to the SQL table in question. As I am fairly new at SQL editing, please confirm the comments I have made on each screen-shot, to confirm/correct my assumptions before I carry out the correction.

    Thanks for your assistance
    The reply is currently minimized Show
  • Accepted Answer

    GFitch
    GFitch
    Offline
    Wednesday, August 31 2016, 03:36 PM - #Permalink
    0
    Hi Support

    Just added the missing field: however this still failed - when I tried to re-import the Invoice Manager component the same error was presented as before: (see note timed / dated: Thursday, August 25 2016, 08:17 AM above).

    Thanks for your assistance.
    Attachments:
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, August 31 2016, 06:47 PM - #Permalink
    0
    ok thanks.

    I'm trying to access your site again but it asks for password. you can send it privately to me at support@ joomlathat.com if you want.
    The reply is currently minimized Show
Your Reply