Title: Database Bug Last modified: February 15, 2020 --- # Database Bug * Resolved [Philip Faster](https://wordpress.org/support/users/philipfaster/) * (@philipfaster) * [6 years, 3 months ago](https://wordpress.org/support/topic/database-bug-2/) * I try using this ERP for testing first, only for the accounting module. then I got several bugs or errors. * **BUG 1**(I can’t reproduce it) 1. When I create a new vendor, then it saved as a “null null” name. I don’t know why, but then I delete it. Then, I’m trying to re-adding it. It says “email already used” or similar like that (there is no vendor in the list) * **BUG 2** 1. Trying I create a very same new vendor from list, then click add new 2. it should give message “email already used” or similar, but nothing 3. The add new vendor form still appear, if I click cancel, the page show circular animation forever 4. then I have to refresh the page, its back to normal, and no data changed * **BUG 3** trying to reset WP ERP database I got the DB cleaner from [https://github.com/wp-erp/erp-cleaner/](https://github.com/wp-erp/erp-cleaner/) 1. I deactivate WP ERP, 2. then activating ERP Database Cleaner, and then deactivating it 3. reactivating WP ERP 4. going through the initial wizard 5. success * the bug is when I open the product category on accounting module, the list is not deleted. It still there. - This topic was modified 6 years, 3 months ago by [Philip Faster](https://wordpress.org/support/users/philipfaster/). - This topic was modified 6 years, 3 months ago by [Philip Faster](https://wordpress.org/support/users/philipfaster/). Viewing 5 replies - 1 through 5 (of 5 total) * [Mehedi Hasan](https://wordpress.org/support/users/thebengalboy/) * (@thebengalboy) * [6 years, 3 months ago](https://wordpress.org/support/topic/database-bug-2/#post-12441668) * Hello [@philipfaster](https://wordpress.org/support/users/philipfaster/) * **BUG 1**(I can’t reproduce it) * I’m not sure why this happened to you but as I checked in multiple testing sites, it’s working fine to us. Maybe there is any other problem causing the issue or a conflict with any plugin or theme? * It’s saying ’email already used’ because when you create a vendor, it creates a user account and maybe this why showing that error. Have you checked if there is any wp user with that email? * **BUG 2** * This is really unusual case and I’m really not sure what can be the reason! Can you share a screencast, please? Also, is there an error on the console? * **BUG 3** * WP ERP Cleander is to reset the HR and CRM only. As we revamped the new accounting system, the cleaner doesn’t have the new tables. * However, if you can clean the database tables for WP ERP, then I’d recommend to clean the tables and try once again. Also, you can contact us directly if you need help from us cleaning the tables. All the WP ERP tables starting with the prefix ‘erp’. * Thanks * Thread Starter [Philip Faster](https://wordpress.org/support/users/philipfaster/) * (@philipfaster) * [6 years, 2 months ago](https://wordpress.org/support/topic/database-bug-2/#post-12459380) * HI… * **BUG 1(I can’t reproduce it)** Maybe I could create a new thread later, if I could reproduce it again… so we could ignore this for now… * **BUG 2** Here’s how to reproduce: 1. create or add new vendor, for example “ test one” with email “test@test.com” 2. click add new, and the new vendor will show up… **(do not refresh the page)** 3. re-add very same vendor, “test one” with email “test@test.com” 4. click add new, then nothing happens… if I click cancel, then a circular icon will animate forever… * **console: ** Download the Vue Devtools extension for a better development experience: [https://github.com/vuejs/vue-devtools](https://github.com/vuejs/vue-devtools)** vendor.js:13:86756** _Object _{ id: Getter & Setter, first_name: Getter & Setter, last_name: Getter & Setter, email: Getter & Setter, company: Getter & Setter, phone: Getter & Setter, website: Getter & Setter, notes: Getter & Setter, mobile: Getter & Setter, fax: Getter & Setter, … } **admin.js:1:335243** [vue-router] missing param for named route “DynamicTrnLoader”: Expected “id” to be defined**( 2) vendor.js:18:178** Error: Request failed with status code 400 **vendor.js: 18:42221** * this is what the “object” contains: “{\”id\”:3,\”first_name\”:\”test\”,\”last_name\”:\” one\”,\”email\”:\”test@test.com\”,\”company\”:\”\”,\”phone\”:\”\”,\”website\”:\”\”,\” notes\”:\”\”,\”mobile\”:\”\”,\”fax\”:\”\”,\”other\”:null,\”photo_id\”:null,\” photo\”:null,\”billing\”:{\”first_name\”:\”test\”,\”last_name\”:\”one\”,\”street_1\”:\”\”,\” street_2\”:\”\”,\”city\”:\”\”,\”state\”:null,\”postal_code\”:\”\”,\”country\”: null,\”email\”:\”test@test.com\”,\”phone\”:\”\”},\”namespace\”:\”erp/v1\”,\”rest_base\”:\” accounting/v1/vendors\”,\”_links\”:{\”self\”:{\”href\”:\”[its my url]/erp/v1/ accounting/v1/vendors/3\”},\”collection\”:{\”href\”:\”[its my url]/erp/v1/accounting/ v1/vendors\”}}}” * **BUG 3** _WP ERP Cleander is to reset the HR and CRM only. _ I see… then, no problem…. * best regards, - This reply was modified 6 years, 2 months ago by [Philip Faster](https://wordpress.org/support/users/philipfaster/). * [Mehedi Hasan](https://wordpress.org/support/users/thebengalboy/) * (@thebengalboy) * [6 years, 2 months ago](https://wordpress.org/support/topic/database-bug-2/#post-12469449) * Hello [@philipfaster](https://wordpress.org/support/users/philipfaster/) * Unfortunately, it’s not happening to me! Once I create a Vendor, the page reloads itself automatically and then if I try to create a new Vendor with the same email, it shows a warning, like this: [https://prnt.sc/r6dszk](https://prnt.sc/r6dszk) * After creating a Vendor, if the page doesn’t reload to you automatically, then you are having any other problem on your site which is preventing the auto-reloads. * Thanks * Thread Starter [Philip Faster](https://wordpress.org/support/users/philipfaster/) * (@philipfaster) * [6 years, 2 months ago](https://wordpress.org/support/topic/database-bug-2/#post-12469481) * hi… * in BUG 2, I could reproduce many times with that… and it will resolve if I manually reload the page. I don’t know, but my site is working correctly with other plugins which auto-reload page after any actions. * best regards, * [Mehedi Hasan](https://wordpress.org/support/users/thebengalboy/) * (@thebengalboy) * [6 years, 2 months ago](https://wordpress.org/support/topic/database-bug-2/#post-12471605) * As I said, the problem may persist on your site somehow that can be based on the site environment or anything else. Here is the screencast how we are getting in the sites we have tested: [https://d.pr/v/oqtCw6](https://d.pr/v/oqtCw6) * So, no, it’s not a bug actually 🙂 Viewing 5 replies - 1 through 5 (of 5 total) The topic ‘Database Bug’ is closed to new replies. * ![](https://ps.w.org/erp/assets/icon-256x256.gif?rev=3439413) * [ERP: Complete HR, Accounting & CRM Suite with WooCommerce CRM Support](https://wordpress.org/plugins/erp/) * [Frequently Asked Questions](https://wordpress.org/plugins/erp/#faq) * [Support Threads](https://wordpress.org/support/plugin/erp/) * [Active Topics](https://wordpress.org/support/plugin/erp/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/erp/unresolved/) * [Reviews](https://wordpress.org/support/plugin/erp/reviews/) * 5 replies * 2 participants * Last reply from: [Mehedi Hasan](https://wordpress.org/support/users/thebengalboy/) * Last activity: [6 years, 2 months ago](https://wordpress.org/support/topic/database-bug-2/#post-12471605) * Status: resolved