frame
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Sign In RegisterHowdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
Hello m'Managerians !
What do you think m'Manager 2.0 should be ? What features SHOULD or MUST be implemented right now ! Request or Vote here
What do you think m'Manager 2.0 should be ? What features SHOULD or MUST be implemented right now ! Request or Vote here
Db error on first install
Hi. Nice work 
I just bought your plugin.
I try to install the version 2 (clean install) to start work but always i get this error.
A Database Error Occurred
Error Number: 1060
Duplicate column name 'proforma_number'
ALTER TABLE oc_proforma CHANGE COLUMN invoice_number proforma_number varchar(20)
Filename: libraries/EzSQL_codeigniter.php
Line Number: 110
On refresh system works but i dont know if this a problem for later use.
Thanks
I just bought your plugin.
I try to install the version 2 (clean install) to start work but always i get this error.
A Database Error Occurred
Error Number: 1060
Duplicate column name 'proforma_number'
ALTER TABLE oc_proforma CHANGE COLUMN invoice_number proforma_number varchar(20)
Filename: libraries/EzSQL_codeigniter.php
Line Number: 110
On refresh system works but i dont know if this a problem for later use.
Thanks
Comments
Error Number: 1005
Can't create table `mydb_invoice`.`oc_proformaitems` (errno: 150 "Foreign key constraint is incorrectly formed")
ALTER TABLE `oc_proformaitems` ADD CONSTRAINT `fk_proforma` FOREIGN KEY (`proforma_number`) REFERENCES `oc_proforma` (`proforma_number`) ON DELETE CASCADE ON UPDATE NO ACTION
Filename: libraries/EzSQL_codeigniter.php
Line Number: 112
As you are starting fresh, maybe will be better to fix initial issue. Clear your browser cache, then remove your database tables. there is a constraint on invoices and purchases. So, select and delete all will not remove them. This is for security. You can use the sql file in install/assets/
Or you can tell me when we can do a Anydesk session to assist. Let me know
So if you reinstall the system, just run this in sql tab
ALTER TABLE `oc_purchases` ADD `repair_number` VARCHAR(20) DEFAULT NULLoc_purchaseitems` ADD `repair_number` VARCHAR(20) DEFAULT NULLPlease play with all other features and let me know. I am adding your custom field
Eric