Simple Invoices logo
    • CommentAuthorykolabhai
    • CommentTimeMar 24th 2008 edited
     permalink
    HI

    Quick reports shows incorrect debtor on hosted server. Localhost show fine

    I am using wamp5 on localhost.

    hosted server has php 5.1.6 and mysql 5

    Regards
    Yusuf
    • CommentAuthorykolabhai
    • CommentTimeMar 27th 2008 edited
     permalink
    Hi Justin

    Any fix or ideas to this problem

    Regard
    Yusuf
    • CommentAuthorjustin
    • CommentTimeMar 27th 2008 edited
     permalink
    Hey Yusuf,

    hmm.. are they running the same verions of Simple Invoices - with the same info in the db?

    only thing that may cause that is if one is using mysql 4 (as there is some conditional stuff in that page based on db version)- but it doesnt look like it as mentioned wamp5 and mysql5

    Cheers

    Justin
    • CommentAuthorykolabhai
    • CommentTimeMar 28th 2008 edited
     permalink
    Justin

    same ver of Simple invoices and mysql is ver 5. I dudmped the db and loaded on the localhost so db in is the same and it not working


    Regards
    Yusuf
    • CommentAuthorjustin
    • CommentTimeApr 1st 2008 edited
     permalink
    Hey Yusuf,

    if its the same db and same versions of everything than im not really sure

    anyone else seen this?

    Cheers

    Justin
    • CommentAuthorykolabhai
    • CommentTimeApr 7th 2008 edited
     permalink
    help!!!!
    • CommentAuthorjustin
    • CommentTimeApr 7th 2008 edited
     permalink
    only other thougth is to delete the contents in ./cache

    smarty caches the content into the ./cache dir to make page views quicker

    try it and let us know

    cheers

    justin
    • CommentAuthorykolabhai
    • CommentTimeApr 8th 2008 edited
     permalink
    Hi Justin

    Ok this is what i have done

    1. I deleted the content in cache it did not work
    2. I backed up the db deleted the the program and the db. reloaded the software and db guess what she not work.
    3. I restored the db on localhost backed it up and restored on my host she still not work.

    I will mail you my db and see what you get on your side

    Regards
    Yusuf
    • CommentAuthorykolabhai
    • CommentTimeApr 9th 2008 edited
     permalink
    Hi Justin

    I found the problem There was discrepencies with the mysql server and client on my host server so I loaded the db on mysql 4 and it sorted out .

    Thks
    Yusuf
    • CommentAuthorjustin
    • CommentTimeApr 9th 2008 edited
     permalink
    Hey Yusuf,

    can you detail the discrepancies? may help others in the future

    Cheers

    Justin
    • CommentAuthorykolabhai
    • CommentTimeApr 10th 2008 edited
     permalink
    Hi Justin

    I checked the phpadmin page i noce thaat the server version of mysql was 5 but the client version on the server was ver 4.

    I changed to mysql 4 on the server then all was well

    Regards
    Yusuf
    • CommentAuthorjustin
    • CommentTimeApr 10th 2008 edited
     permalink
    ok, thansk for the update Yusuf

    Cheers

    Justin