I search the forums, not much help unfortunately, fortunately for everyone else, I had some very sensitive data that I really needed to get to, so I plugged away until everything worked. I love this app, hope to see more features soon! Great job to all the developers.
This is my 10 step process to resolving the "exports error after upgrading" Hope someone finds it helpful.
1)From the SimpleInvoice Dashboard, Select BACKUP DATABASE NOW 2)Open the SQL script and comment out the “CREATE TABLE” blocks. If you had upgraded from previsous versions, there are some tables thats aren't used anymore, ignore errors. At this point the sql script should be a bunch of insert statements. 2)Using FTP, grab your config.ini file in the /config folder. Back it up for later. You should also backup the tmp\database_backups 3)Now wipe out the SimpleInvoices directory and upload the latest version, I used the http://simpleinvoices.googlecode.com/files/simpleinvoices.2010.1.zip version. 4)I used phpMyAdmin, drop all the tables in your database. 5)Go to the “Import” tab and select the /databases/mysql/Full_Simple_Invoices.sql file and execute it. 6)Now click on the “Structure” tab and check all the tables and chose to Empty all the tables data. 7)You should have all the tables without any data at this point. 8)Click on the “SQL” tab and “paste” your modified sql file with all the inserts. Execute this statement. 9)Go back to your config.ini file and change your database settings to work with you db. 10)Make sure to add the correct folder permissions to the /tmp, that's it!
