I have been working for a few weeks now for a good step by step or how to document to install InvoicePlane in Windows Server 2012 and IIS.
With the directions that are out their I still have been unable to even get the installation to run.
I am able to install MySQL, I am able to get PHP downloaded and what I believe to be installed.
I than take and create the Blank DB in MySQL, than I go and extract the InvoicePlane file into the wwwroot directory on the server.
Once I do that I can’t get any further. I am unable to get the setup/Install to run when I navigate to http://localhost/setup.
Does anyone have a better install walk through, or would be willing to walk through it with me and create one with me at the same time? Any info or more description on how to get the install completed would be helpful. Thanks.
I have made no other changes to any of the files that are inside the “Invoices” folder, I assumed I did not need to go in and configure any other files as the setup that should run would allow me to enter the DB name and or connection but I never get to the setup screen I always get one of the above errors.
If you want to use InvoicePlane you have to follow these requirements:
A webserver / webhost with the following specifications:
PHP > 5.3.0
MySQL > 4.x
mCrypt Extension activated (How-To)
and a modern and up-to-date web browser.
Makes Sense I recreated this using MYSQL, and I am able to connect now and move through the setup.
I get to the piece in the setup upgrade_tables and I get the following error:
Error Number: 1364
Field 'family_id' doesn't have a default value
# Move lookup items to products INSERT INTO ip_products (product_name, product_description, product_price) SELECT item_name, item_description, item_price FROM ip_item_lookups;
Filename: C:\inetpub\wwwroot\system\database\DB_driver.php
Line Number: 331
Any idea anyone had this before. I also went and completly deleted the invoice_plane database and than recreated it and that did not fix the issue.
I viewed the links and I did see where this could be an issue, I did turn the strict mode off and I did replace the .sql code and now I get this error,
A Database Error Occurred
Error Number: 1067
Invalid default value for 'family_id'
# Module "products" CREATE TABLE IF NOT EXISTS `ip_products` ( `product_id` int(11) NOT NULL AUTO_INCREMENT, `family_id` int(11) NOT NULL DEFAULT '', `product_sku` varchar(15) NOT NULL DEFAULT '', `product_name` varchar(50) NOT NULL, `product_description` longtext NOT NULL, `product_price` float(10,2) NOT NULL, `purchase_price` float(10,2) NOT NULL DEFAULT '', `tax_rate_id` int(11) NOT NULL DEFAULT '', PRIMARY KEY (`product_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Filename: C:\inetpub\wwwroot\system\database\DB_driver.php
Line Number: 331
Not the same error as the user in the post did after he made the change but It did not solve the issue.
This is what I would recommend, start with a fresh clean copy of the Invoiceplane download.
No script changes to the .sql files.
Make sure MySQL is not in strict mode, restart the MySQL Service for good measure
Then create a brand new schema in MySQL and attempt to install.
I ran into issues when I was upgrading v1.1 to v1.2 where if an error was thrown half way through the upgrade. I had to completely restore the schema to v1.1.
Otherwise the upgrade script would continue to throw errors and never complete.
Yes I just completed this, and this is what I got at the upgrade_table
Error Number: 1364
Field 'family_id' doesn't have a default value
# Move lookup items to products INSERT INTO ip_products (product_name, product_description, product_price) SELECT item_name, item_description, item_price FROM ip_item_lookups;
Filename: C:\inetpub\wwwroot\system\database\DB_driver.php
Line Number: 331
Again I have not altered the .SQL file at all.
I removed the Schema and removed the files from IIS, redownloaded and than extraced the files to the root of IIS. went into IIS stopped and atted the rewrite rule then started IIS
than edited MySQL so that strict mode was off, than I went and rebooted and created a new DATABASE
than went and ran through the setup and it error with the above
Thank you for all of your help. This seemed to have fixed my issue. I went and Started with a clean download as you said and than ran the command from your second link. Than I created the new Schema and I was able to move past. I now have IP setup and working.
I appreciate all of your time and effort. Thanks for the help!
@rtirak Sorry I wasn’t able to reply back to you earlier, I’m glad its working for you.
I would highly recommend that you make a backup of the MySQL database before you attempt to upgrade for future versions, just in case you run in any errors.
This is what worked for me with Windows Server 2012r2. In IIS Manager, followed to my IP website, opened URL Rewrite module and imported the .htaccess file from the IP folder. The line “RewriteBase /sub_directory” was highlighted in red as an error. Removed that entire line from the imported rule, everything went green, applied changes and finally closed. Restarted the IIS.