Author Topic: vmError: TableInvoices COM_VIRTUEMART_INVOICE_NUMBER empty  (Read 9747 times)

Vlad44b

  • Beginner
  • *
  • Posts: 31
vmError: TableInvoices COM_VIRTUEMART_INVOICE_NUMBER empty
« on: December 31, 2013, 19:27:33 pm »
When I try deleting order I got:
vmError: TableInvoices COM_VIRTUEMART_INVOICE_NUMBER пустое. Это поле является обязательным, пожалуйста, введите ваши данные.

In English:
vmError: TableInvoices COM_VIRTUEMART_INVOICE_NUMBER empty. This field is required, please enter your details.

Joomla! 2.5.17
VM 2.0.26a (translate Russian)
PHP 5.4

Vlad44b

  • Beginner
  • *
  • Posts: 31
Re: vmError: TableInvoices COM_VIRTUEMART_INVOICE_NUMBER empty
« Reply #1 on: December 31, 2013, 19:39:31 pm »
The same problem with version PHP 5.5  :(

shopper999

  • Beginner
  • *
  • Posts: 35
Re: vmError: TableInvoices COM_VIRTUEMART_INVOICE_NUMBER empty
« Reply #2 on: January 04, 2014, 16:21:58 pm »
OK, I think the error messages are confusing:

On deleting the order from the list, I get:
Code: [Select]
vmError: TableInvoices The given COM_VIRTUEMART_INVOICE_NUMBER is empty. This field is obligatory, please enter your data and store again.

In german it says
Code: [Select]
vmError: TableInvoices Der angegebene COM_VIRTUEMART_INVOICE_NUMBER existiert bereits.
which means: The Invoice number already exists.

This is a hint, that you try to delete an order, for which there is already an invoice genereated!

And indeed, in the DB table, there is an invoice for this order number!

OK, I could solve my problem!

My problem was: I copied the CMS for testing purposes, and I didn't copy the already created PDF invoices, too.

Please make sure, that the PDF invoices are in the correct filesystem-path, so they can be deleted on deleting the order.


Try again. I do not get any more errors, now.

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9942
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: vmError: TableInvoices COM_VIRTUEMART_INVOICE_NUMBER empty
« Reply #3 on: January 04, 2014, 16:46:10 pm »
That makes indeed sense, because invoices are only stored as pdfs and created from orders.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

picard

  • Beginner
  • *
  • Posts: 1
Re: vmError: TableInvoices COM_VIRTUEMART_INVOICE_NUMBER empty
« Reply #4 on: January 06, 2014, 18:42:10 pm »
Hi,

I ran into the same problem. The folder was not set correct. Now I have a lot of "test orders" which I want to delete. But the system prevents me due to the error message above. There are now pdfs at all. How to solve this one?

best regards
picard

Vlad44b

  • Beginner
  • *
  • Posts: 31
Re: vmError: TableInvoices COM_VIRTUEMART_INVOICE_NUMBER empty
« Reply #5 on: January 07, 2014, 13:19:48 pm »
Quote
Please make sure, that the PDF invoices are in the correct filesystem-path, so they can be deleted on deleting the order.

Excuse me but where setting PDF invoices filesystem-path?

shopper999

  • Beginner
  • *
  • Posts: 35
Re: vmError: TableInvoices COM_VIRTUEMART_INVOICE_NUMBER empty
« Reply #6 on: January 07, 2014, 13:51:16 pm »
Configuration -> Configuration -> Templates -> Safe Path

This should be a path outside your Document-Root.

Vlad44b

  • Beginner
  • *
  • Posts: 31
Re: vmError: TableInvoices COM_VIRTUEMART_INVOICE_NUMBER empty
« Reply #7 on: January 08, 2014, 10:11:26 am »
Configuration -> Configuration -> Templates -> Safe Path

This should be a path outside your Document-Root.

This path is set for me by my hosting provider. On my hosting such a rule:
/home/my FTP Login/site address/vmfiles/
After press Save - VM shows that this settings are correct.

shopper999

  • Beginner
  • *
  • Posts: 35
Re: vmError: TableInvoices COM_VIRTUEMART_INVOICE_NUMBER empty
« Reply #8 on: January 08, 2014, 10:19:12 am »
Are there any PDFs in that directory?

Vlad44b

  • Beginner
  • *
  • Posts: 31
Re: vmError: TableInvoices COM_VIRTUEMART_INVOICE_NUMBER empty
« Reply #9 on: January 08, 2014, 10:35:55 am »
My steps today:
1. Clean folder /vmfiles/invoices
2. Create order.
3. Delete order.
ALL FINE

1. Create new order.
2. Create PDF invoice of this order (press and save on my comp).
3. Delete order.
Result:
vmError: TableInvoices COM_VIRTUEMART_INVOICE_NUMBER empty...



shopper999

  • Beginner
  • *
  • Posts: 35
Re: vmError: TableInvoices COM_VIRTUEMART_INVOICE_NUMBER empty
« Reply #10 on: January 08, 2014, 10:45:49 am »
My steps today:
1. Clean folder /vmfiles/invoices
2. Create order.
3. Delete order.
ALL FINE

1. Create new order.
2. Create PDF invoice of this order (press and save on my comp).

At this step, please have a look at the folder. Is the pdf there (before deleting the order)?
If there is no pdf, perhaps, the folder has the wrong permissions, so the webserver cannot write in that folder to store the pdf.

If you try to delete an order, VM tries to delete a pdf, which is not there.

Vlad44b

  • Beginner
  • *
  • Posts: 31
Re: vmError: TableInvoices COM_VIRTUEMART_INVOICE_NUMBER empty
« Reply #11 on: January 08, 2014, 11:05:07 am »
Quote
At this step, please have a look at the folder. Is the pdf there (before deleting the order)?
Yes I see pdf there.
folder permissions /vmfiles = "777"
folder permissions /vmfiles/invoices = "777"

After delete order I got vmError: TableInvoices and pdf still there in folder /vmfiles/invoices

Vlad44b

  • Beginner
  • *
  • Posts: 31
Re: vmError: TableInvoices COM_VIRTUEMART_INVOICE_NUMBER empty
« Reply #12 on: January 10, 2014, 18:55:19 pm »
The same problem in 2.0.26d   :'(

shopper999

  • Beginner
  • *
  • Posts: 35
Re: vmError: TableInvoices COM_VIRTUEMART_INVOICE_NUMBER empty
« Reply #13 on: January 10, 2014, 21:36:51 pm »
Is there anything in the Server Logfile?? PHP errors??

Vlad44b

  • Beginner
  • *
  • Posts: 31
Re: vmError: TableInvoices COM_VIRTUEMART_INVOICE_NUMBER empty
« Reply #14 on: January 10, 2014, 22:34:29 pm »
Is there anything in the Server Logfile?? PHP errors??

Just warns after delete order:
[Fri Jan 10 23:20:02 2014] [warn] [client 178.94.83.247] mod_fcgid: stderr: PHP Strict Standards:  Declaration of JParameter::loadSetupFile() should be compatible with JRegistry::loadSetupFile() in /home/t1WD4d9i20935/bestshop.um.la/libraries/joomla/html/parameter.php on line 512, referer: http://bestshop.um.la/index.php/vasha-korzina/checkout
[Fri Jan 10 23:20:02 2014] [warn] [client 178.94.83.247] mod_fcgid: stderr: PHP Strict Standards:  Declaration of VirtueMartModelMedia::store() should be compatible with VmModel::store(&$data) in /home/t1WD4d9i20935/bestshop.um.la/administrator/components/com_virtuemart/models/media.php on line 439, referer: http://bestshop.um.la/index.php/vasha-korzina/checkout
[Fri Jan 10 23:20:02 2014] [warn] [client 178.94.83.247] mod_fcgid: stderr: PHP Strict Standards:  Non-static method mod_vp_era_vm_product::addtocart() should not be called statically in /home/t1WD4d9i20935/bestshop.um.la/modules/mod_vp_era_vm_product/tmpl/default.php on line 151, referer: http://bestshop.um.la/index.php/vasha-korzina/checkout

Please check PM.