Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register
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

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.


  • Also after i update the plugin from backend i get this error

    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
  • Hi @choulio19 ,
    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
  • I remove your previous message, because it exposes your anydesk ID. All migration was done, but the warning on oc_purchases cause issue adding this ADD `repair_number` VARCHAR(20) DEFAULT NULL,
    So if you reinstall the system, just run this in sql tab

    ALTER TABLE `oc_purchases` ADD `repair_number` VARCHAR(20) DEFAULT NULL
    oc_purchaseitems` ADD `repair_number` VARCHAR(20) DEFAULT NULL

    Please play with all other features and let me know. I am adding your custom field
Sign In or Register to comment.


| Let's Build Together a Great App !
If you are a happy user, send me a coffee.
2015 - 2107 © m'Manager.
Powered by VanillaForums, Designed by ThemeSteam

Recent Donations

  • Joni Mueller from - 63€
  • HeyrmanD from - 25€
  • Patricia from - 10€
  • AskinSavascisi from - 3€
  • Get In Touch