VirtueMart Forum

VirtueMart 2 + 3 => Virtuemart Development and bug reports => Development & Testing => Topic started by: Milbo on March 04, 2012, 20:35:05 pm

Title: New pre subrelease VirtueMart 2.0.3.B update
Post by: Milbo on March 04, 2012, 20:35:05 pm
After the release is before the next release.

Here is our new release candidate. We just stabilised the code and fixed a small security issue. Created userfield plugin system for captcha, euvatchecker and simular (not in core yet). Small enhancements by 3rd party developers were added. We recommended for everyone to test the installation on a copy. This version should be more compatible to 2.0.0 templates then 2.0.2.
There is nothing special to take care of, just use the normal upgrade method provided by joomla (just install again).

-update b:
re-enabled the tableupdater, please execute the tool "update tables" to update your db layout.

-update a:
Better migration options


- new userfield plugin hooks..
- textarea as customfield.
- rised internal calculation precision
- overhauled pagination and ordering (no changes for templates !)
- added warnings
- some sef fixes
- some trigger fixes by 3rd party
- fixed light security issue
- adjusted data witha working example of dynamic child list
- small fixes, here and there

http://dev.virtuemart.net/attachments/download/392/com_virtuemart.2.0.3.b_extract_first.zip
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: vigier on March 04, 2012, 23:23:18 pm
Get the next errors when installing the AIO-part:
com_virtuemart_allinoneInstallerScript:: SHOW TABLES LIKE "%virtuemart_payment_plg_standard" tblsr_virtuemart_payment_plg_standard
com_virtuemart_allinoneInstallerScript:: VirtueMart2 update #__virtuemart_payment_plg_standard
createTable ERROR :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=CREATE TABLE IF NOT EXISTS `tblSR_virtuemart_payment_plg_standard` ( `id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT, `virtuemart_order_id` INT(1) UNSIGNED DEFAULT NULL, `order_number` CHAR(32) DEFAULT NULL, `virtuemart_paymentmethod_id` MEDIUMINT(1) UNSIGNED DEFAULT NULL, `payment_name` VARCHAR(5000), `payment_order_total` DECIMAL(15,5) NOT NULL DEFAULT '0.00000', `payment_currency` CHAR(3) , `cost_per_transaction` DECIMAL(10,2) DEFAULT NULL, `cost_percent_total` DECIMAL(10,2) DEFAULT NULL, `tax_id` SMALLINT(1) DEFAULT NULL, `created_on` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` int(11) NOT NULL DEFAULT 0, `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(11) NOT NULL DEFAULT 0, `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `locked_by` int(11) NOT NULL DEFAULT 0) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
com_virtuemart_allinoneInstallerScript:: SHOW TABLES LIKE "%virtuemart_payment_plg_payzen"
com_virtuemart_allinoneInstallerScript:: SHOW TABLES LIKE "%virtuemart_payment_plg_authorizenet"
com_virtuemart_allinoneInstallerScript:: SHOW TABLES LIKE "%virtuemart_payment_plg_paypal"
com_virtuemart_allinoneInstallerScript:: SHOW TABLES LIKE "%virtuemart_shipment_plg_weight_countries" tblsr_virtuemart_shipment_plg_weight_countries
com_virtuemart_allinoneInstallerScript:: VirtueMart2 update #__virtuemart_shipment_plg_weight_countries
createTable ERROR :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=CREATE TABLE IF NOT EXISTS `tblSR_virtuemart_shipment_plg_weight_countries` ( `id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT, `virtuemart_order_id` INT(11) UNSIGNED DEFAULT NULL, `order_number` CHAR(32) DEFAULT NULL, `virtuemart_shipmentmethod_id` MEDIUMINT(1) UNSIGNED DEFAULT NULL, `shipment_name` VARCHAR(5000), `order_weight` DECIMAL(10,4) DEFAULT NULL, `shipment_weight_unit` CHAR(3) DEFAULT 'KG' , `shipment_cost` DECIMAL(10,2) DEFAULT NULL, `shipment_package_fee` DECIMAL(10,2) DEFAULT NULL, `tax_id` SMALLINT(1) DEFAULT NULL, `created_on` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` int(11) NOT NULL DEFAULT 0, `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(11) NOT NULL DEFAULT 0, `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `locked_by` int(11) NOT NULL DEFAULT 0) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
com_virtuemart_allinoneInstallerScript:: SHOW TABLES LIKE "%virtuemart_custom_plg_textinput"
com_virtuemart_allinoneInstallerScript:: SHOW TABLES LIKE "%virtuemart_custom_plg_specification"
com_virtuemart_allinoneInstallerScript:: SHOW TABLES LIKE "%virtuemart_custom_plg_stockable"
com_virtuemart_allinoneInstallerScript:: SHOW TABLES LIKE "%virtuemart_arch_plg_virtuemart"
Installeren component is geslaagd

Kind regards,
Vigier
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: vigier on March 04, 2012, 23:25:40 pm
And the next errors after reloading my website using 2.0.3.

1)
Notice: Undefined property: stdClass::$virtuemart_category_id in C:\wamp\www\Joomla\components\com_virtuemart\views\virtuemart\tmpl\default_products.php on line 57
Call Stack
# Time Memory Function Location
1 0.0003 648312 {main}( ) ..\index.php:0
2 0.0718 9458032 JSite->dispatch( ) ..\index.php:42
3 0.0741 9532288 JComponentHelper::renderComponent( ) ..\application.php:187
4 0.0770 9671216 JComponentHelper::executeComponent( ) ..\helper.php:357
5 0.0773 9775816 require_once( 'C:\wamp\www\Joomla\components\com_virtuemart\virtuemart.php' ) ..\helper.php:388
6 0.1027 12161488 JController->execute( ) ..\virtuemart.php:103
7 0.1027 12161568 JController->display( ) ..\controller.php:754
8 0.1051 12463936 VirtueMartViewVirtueMart->display( ) ..\controller.php:715
9 0.2381 20808048 JView->display( ) ..\view.html.php:131
10 0.2381 20808048 JView->loadTemplate( ) ..\view.php:301
11 0.2391 20859560 include( 'C:\wamp\www\Joomla\components\com_virtuemart\views\virtuemart\tmpl\default.php' ) ..\view.php:742
12 0.2404 20863840 JView->loadTemplate( ) ..\default.php:38
13 0.2413 20953344 include( 'C:\wamp\www\Joomla\components\com_virtuemart\views\virtuemart\tmpl\default_products

2)
Warning: Invalid argument supplied for foreach() in C:\wamp\www\Joomla\libraries\joomla\html\html\select.php on line 504
Call Stack
# Time Memory Function Location
1 0.0003 648312 {main}( ) ..\index.php:0
2 0.2611 20998664 JSite->render( ) ..\index.php:48
3 0.2658 21310888 JDocumentHTML->render( ) ..\application.php:261
4 0.2658 21310888 JDocumentHTML->_renderTemplate( ) ..\html.php:433
5 0.2672 21374376 JDocumentHTML->getBuffer( ) ..\html.php:655
6 0.2672 21374992 JDocumentRendererModules->render( ) ..\html.php:371
7 0.2672 21376456 JDocumentRendererModule->render( ) ..\modules.php:39
8 0.2673 21378072 JModuleHelper::renderModule( ) ..\module.php:106
9 0.2688 21439976 include( 'C:\wamp\www\Joomla\modules\mod_virtuemart_currencies\mod_virtuemart_currencies.php' ) ..\helper.php:175
10 0.2696 21440888 require( 'C:\wamp\www\Joomla\modules\mod_virtuemart_currencies\tmpl\default.php' ) ..\mod_virtuemart_currencies.php:49
11 0.2697 21441320 JHtml::_( ) ..\default.php:8
12 0.2697 21442784 JHtml::call( ) ..\html.php:103
13 0.2697 21444792 call_user_func_array ( ) ..\html.php:222
14 0.2697 21445696 JHtmlSelect::genericlist( ) ..\html.php:222
15 0.2697 21447624 JHtmlSelect::options( )

3)
Notice: Undefined property: stdClass::$virtuemart_category_id in C:\wamp\www\Joomla\administrator\components\com_virtuemart\models\product.php on line 882
Call Stack
# Time Memory Function Location
1 0.0003 648520 {main}( ) ..\index.php:0
2 0.0830 11287840 JSite->dispatch( ) ..\index.php:42
3 0.0834 11290864 JComponentHelper::renderComponent( ) ..\application.php:187
4 0.0863 11430152 JComponentHelper::executeComponent( ) ..\helper.php:357
5 0.0866 11533832 require_once( 'C:\wamp\www\Joomla\components\com_virtuemart\virtuemart.php' ) ..\helper.php:388
6 0.1037 12735464 JController->execute( ) ..\virtuemart.php:103
7 0.1037 12735544 VirtueMartControllerProductdetails->display( ) ..\controller.php:754
8 0.1061 13114168 VirtueMartViewProductdetails->display( ) ..\productdetails.php:49
9 0.1763 20379056 VirtueMartModelProduct->getNeighborProducts( ) ..\view.html.php:140

 
4)
Notice: Undefined property: stdClass::$virtuemart_category_id in C:\wamp\www\Joomla\components\com_virtuemart\views\productdetails\tmpl\default.php on line 26
Call Stack
# Time Memory Function Location
1 0.0003 648520 {main}( ) ..\index.php:0
2 0.0830 11287840 JSite->dispatch( ) ..\index.php:42
3 0.0834 11290864 JComponentHelper::renderComponent( ) ..\application.php:187
4 0.0863 11430152 JComponentHelper::executeComponent( ) ..\helper.php:357
5 0.0866 11533832 require_once( 'C:\wamp\www\Joomla\components\com_virtuemart\virtuemart.php' ) ..\helper.php:388
6 0.1037 12735464 JController->execute( ) ..\virtuemart.php:103
7 0.1037 12735544 VirtueMartControllerProductdetails->display( ) ..\controller.php:754
8 0.1061 13114168 VirtueMartViewProductdetails->display( ) ..\productdetails.php:49
9 0.1871 21132584 JView->display( ) ..\view.html.php:284
10 0.1871 21132584 JView->loadTemplate( ) ..\view.php:301
11 0.1883 21288048 include( 'C:\wamp\www\Joomla\components\com_virtuemart\views\productdetails\tmpl\default.php' ) ..\view.php:742

5)
Notice: Undefined property: stdClass::$virtuemart_category_id in C:\wamp\www\Joomla\components\com_virtuemart\views\productdetails\tmpl\default.php on line 96
Call Stack
# Time Memory Function Location
1 0.0003 648520 {main}( ) ..\index.php:0
2 0.0830 11287840 JSite->dispatch( ) ..\index.php:42
3 0.0834 11290864 JComponentHelper::renderComponent( ) ..\application.php:187
4 0.0863 11430152 JComponentHelper::executeComponent( ) ..\helper.php:357
5 0.0866 11533832 require_once( 'C:\wamp\www\Joomla\components\com_virtuemart\virtuemart.php' ) ..\helper.php:388
6 0.1037 12735464 JController->execute( ) ..\virtuemart.php:103
7 0.1037 12735544 VirtueMartControllerProductdetails->display( ) ..\controller.php:754
8 0.1061 13114168 VirtueMartViewProductdetails->display( ) ..\productdetails.php:49
9 0.1871 21132584 JView->display( ) ..\view.html.php:284
10 0.1871 21132584 JView->loadTemplate( ) ..\view.php:301
11 0.1883 21288048 include( 'C:\wamp\www\Joomla\components\com_virtuemart\views\productdetails\tmpl\default.php' ) ..\view.php:742

BTW:
Hope the above information helps you developing a stable 2.0.3.
Kind regards,
Vigier
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: smimish on March 05, 2012, 00:09:51 am
Pagination is completely broken.
VM 2.0.3 + Joomla 2.5.1.
The language of the shop is Russian.
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: lipes on March 05, 2012, 01:51:37 am
Do not try to go to Product Categories and do some Ordering and Save hitting the Disk ..
you'll get all your work f..... cked....  argh... :'(

I have added 323 categories before and now i'm having big problems to get this like it was.
i cant do nothing!
This was the problem nr 9 that i've also reported here: http://forum.virtuemart.net/index.php?topic=99052.0

..................
UPDATE: SOLVED -> PRESS the Ordering link in the left of the Disk
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: Milbo on March 05, 2012, 02:05:13 am
vigier did you used the latest aio? or the aio before the core? I tried to understand the error but looks for me impossible. The error with the missing category, hmmm. Normal products must have a category. I wonder how you show them. With single joomla menu items? We can remove the notice, not big deal, just so.

smimish, what means the pagination is broken? I worked on it heavily the last days.

prolipes, sorry but in the posts stands "We recommended for everyone to test the installation on a copy". What happens when you change the ordering? I hope you understood that every category as its own order for its subcategories.
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: lipes on March 05, 2012, 02:56:15 am
Hi Milbo
I am still testing the VM on localhost (ampps) and build the site for my parents at the same time ...
I understand, no problem ..
Worse is that I was ordained and now I have to see how it was again...
The Product Categories Ordering dont let me change the number, and I can not give a logical explanation for what I see, if I try to put 1,2,3,4 .... it seems that do something, but others they maintain the same position ... is very strange because i have to many categories (Display #200) per page ..
if i change 10 per page its more understandable... I've write the same order 1,2,3,4 (etc) and i saw that he gives another numbers to that Product Categories that i never write.. its strange this!
..............................
UPDATE: SOLVED -> PRESS the Ordering link in the left of the Disk
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: beipink on March 05, 2012, 04:36:12 am
Hello Max,
I was wondering if you know when the below issues will be addressed.
Just installed VM2.0.3 and both problems are still there.

products URL with SEO enabled
http://forum.virtuemart.net/index.php?topic=98584.0 also reported here http://forum.virtuemart.net/index.php?topic=99014.0

and the re-ordering of products from back-end
http://forum.virtuemart.net/index.php?topic=96049.msg315706#msg315706

Thank you
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: peebee on March 05, 2012, 06:41:59 am
Looks like something might be missing in the 2.0.3 AIO upgrade when it comes to the currency converter module?

Warning: Invalid argument supplied for foreach() in
/home/xxxxxx/public_html/xxxxxx/libraries/joomla/html/html/select.php on line 504

No currency options displayed in module?  Checked currencies in shop config and all looks good.

Rolled back to 2.0.2 and everything working OK again.
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: Milbo on March 05, 2012, 10:35:08 am
Hello Peebee, this is very strange, we tested the installation on 5 servers, one server had the problem with currency module. Interesting, you changed to 2.0.2 and it is gone. joomla version?

if i change 10 per page its more understandable... I've write the same order 1,2,3,4 (etc) and i saw that he gives another numbers to that Product Categories that i never write.. its strange this!
As I said. Make 4 categories, you can order them. Create a subcategory and it has its own order.
Cat1 ordering1
cat2 ordering2
cat3 ordering3

But
Cat 1 ordering 1
-subcat 1 ordering 1
-subcat 2 ordering 2
-subcat 3 ordering 3
Cat 2 ordering 2

I think the ordering is okey. It is just not absolute, it is relative to each parent category
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: smimish on March 05, 2012, 11:11:28 am
Milbo, apologies, the pagination is working.
The following is broken: under the category view, if you try to change the number of displayed products on a page, it will either not work or will jump to a higher level category. This is broken...
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: osp on March 05, 2012, 11:20:00 am
Looks like something might be missing in the 2.0.3 AIO upgrade when it comes to the currency converter module?

Warning: Invalid argument supplied for foreach() in
/home/xxxxxx/public_html/xxxxxx/libraries/joomla/html/html/select.php on line 504

No currency options displayed in module?  Checked currencies in shop config and all looks good.

Rolled back to 2.0.2 and everything working OK again.

Peebe, better localization of the error is needed. What is your Joomla ver, which VM modules are active and eventually in which component/module error occurs.
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: lipes on March 05, 2012, 16:02:53 pm
Milbo:
At first time i've created 10 Principal Categories to put them in the main menu of the site..
Cat1, cat 2, cat 3, cat4 ....
Then i've put many subcategories inside them...
and the last thing that i've remember (i think) its that the ordering are with the number 0 in all
When i've clicked in the disk to test a different position the problems started...
For example I'm trying to change this:
Cat1 ordering1
cat2 ordering2
to:
Cat1 ordering2
cat2 ordering1
I hit the save disk... and I can see that the number change but they stay in the same place (same rows) ... the cat2 with the ordering1 dont go to top.. and cat1 ordering2 dont go down... and it's the same problem with the sub categories... the ordering is so confusing that its like: 4,7,6,3,1,16,14,12,9,41,33,40,32,23,22,21,5,42,10,29,19,34,2,8,20,36,39,18,17,31,15,38,37,30,28,35,13,11,26,25,24,27 (for cat1 ordering2)... for cat2 is the same confusion problem with the numbers... until the last cat10 !! :-/
...................................
UPDATE: SOLVED -> PRESS the Ordering link in the left of the Disk
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: Milbo on March 05, 2012, 16:42:41 pm
Works for me, I did a test with 500 categories and they have subcategories with 3rd level, works. There are no errors for the subcategories, right. But you can just write it manually, works. So it is not completly nice done, but I cant find any bug.

smimish, I just tested and your problem is SEF related
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: Studio 42 on March 05, 2012, 16:58:39 pm
Milbo:
At first time i've created 10 Principal Categories to put them in the main menu of the site..
Cat1, cat 2, cat 3, cat4 ....
Then i've put many subcategories inside them...
and the last thing that i've remember (i think) its that the ordering are with the number 0 in all
When i've clicked in the disk to test a different position the problems started...
For example I'm trying to change this:
Cat1 ordering1
cat2 ordering2
to:
Cat1 ordering2
cat2 ordering1
I hit the save disk... and I can see that the number change but they stay in the same place (same rows) ... the cat2 with the ordering1 dont go to top.. and cat1 ordering2 dont go down... and it's the same problem with the sub categories... the ordering is so confusing that its like: 4,7,6,3,1,16,14,12,9,41,33,40,32,23,22,21,5,42,10,29,19,34,2,8,20,36,39,18,17,31,15,38,37,30,28,35,13,11,26,25,24,27 (for cat1 ordering2)... for cat2 is the same confusion problem with the numbers... until the last cat10 !! :-/
Hi,
Try to click on 'ordering' colum to see the right ordering
Vm2 permit change ordering if you have ordering by name for eg.
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: Studio 42 on March 05, 2012, 17:01:57 pm

2)
Warning: Invalid argument supplied for foreach() in C:\wamp\www\Joomla\libraries\joomla\html\html\select.php on line 504
Call Stack
# Time Memory Function Location
1 0.0003 648312 {main}( ) ..\index.php:0
2 0.2611 20998664 JSite->render( ) ..\index.php:48
3 0.2658 21310888 JDocumentHTML->render( ) ..\application.php:261
4 0.2658 21310888 JDocumentHTML->_renderTemplate( ) ..\html.php:433
5 0.2672 21374376 JDocumentHTML->getBuffer( ) ..\html.php:655
6 0.2672 21374992 JDocumentRendererModules->render( ) ..\html.php:371
7 0.2672 21376456 JDocumentRendererModule->render( ) ..\modules.php:39
8 0.2673 21378072 JModuleHelper::renderModule( ) ..\module.php:106
9 0.2688 21439976 include( 'C:\wamp\www\Joomla\modules\mod_virtuemart_currencies\mod_virtuemart_currencies.php' ) ..\helper.php:175
10 0.2696 21440888 require( 'C:\wamp\www\Joomla\modules\mod_virtuemart_currencies\tmpl\default.php' ) ..\mod_virtuemart_currencies.php:49
11 0.2697 21441320 JHtml::_( ) ..\default.php:8
12 0.2697 21442784 JHtml::call( ) ..\html.php:103
13 0.2697 21444792 call_user_func_array ( ) ..\html.php:222
14 0.2697 21445696 JHtmlSelect::genericlist( ) ..\html.php:222
15 0.2697 21447624 JHtmlSelect::options( )

Hi,
Seems you don't have set the currencies in VM2.
It's an error, but i mean if vm2 is right set this error don't appear.
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: lipes on March 05, 2012, 17:11:10 pm
Electrocity: Damm it.. you solve the problem of the Ordering with your suggestion...
I'm so accustomed to VM1 that it does update automatically that ordering that i dont see this was a link to do something.. now i will have to ordering categories again.. and press it to see it in a correct way.
Thanks!

Milbo sorry
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: Studio 42 on March 05, 2012, 17:56:55 pm
I have added a fix in SVN files for category pagination in SEF problems.
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: icemangs on March 05, 2012, 19:08:53 pm
Hi,

after upgrade from 2.0.2 to 2.0.3. i cant see any products in frontend.
In the backend i can see the products.

Does anyone know why?

icemangs

Edit: product categories >> in column Products for show products in products categories>> display errors:

vmError: exeSortSearchListQuery Column 'virtuemart_product_id' in order clause is ambiguous SQL=SELECT SQL_CALC_FOUND_ROWS * FROM `jos_virtuemart_products_de_de` as l JOIN `jos_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `jos_virtuemart_product_categories` ON p.`virtuemart_product_id` = `jos_virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `jos_virtuemart_categories_de_de` as c ON c.`virtuemart_category_id` = `jos_virtuemart_product_categories`.`virtuemart_category_id` WHERE ( `jos_virtuemart_product_categories`.`virtuemart_category_id` = 22) ORDER BY virtuemart_product_id DESC LIMIT 0, 10
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: peebee on March 05, 2012, 22:33:30 pm
Hello Peebee, this is very strange, we tested the installation on 5 servers, one server had the problem with currency module. Interesting, you changed to 2.0.2 and it is gone. joomla version?

Thanks for the reply Milbo. 

Running Joomla 2.5.1. I've downloaded and installed a fresh copy of VM 2.0.3 and have exactly the same error in the currency module.  Roll back to 2.0.2 and it's gone again? I do note that the server the installation is on is running PHP 5.2.17 and not 5.3.x.  Is that possibly the issue?  Sadly, host is not cooperating with upgrade of php at the moment.

I see you mention "we tested the installation on 5 servers, one server had the problem with currency module".  Did you resolve the issue with that installation or were you able to isolate the problem?

Thanks again for your time and help.
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: xevi on March 05, 2012, 23:23:08 pm
thanks for the update Milbo,

I tried the update in a clean installation copy and everything worked fine. (Joomla 2.5.1 + Virtuemart from 2.0.2 to 2.0.3).

However, when I migrated in a copy I have some personalized categories, products ... I get the follwoing errors when installing the aio component.

Note: I have not set-up any payment method yet.


com_virtuemart_allinoneInstallerScript:: SHOW TABLES LIKE "%virtuemart_payment_plg_standard" hot_virtuemart_payment_plg_standard
com_virtuemart_allinoneInstallerScript:: VirtueMart2 update #__virtuemart_payment_plg_standard
createTable ERROR :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=CREATE TABLE IF NOT EXISTS `arq_virtuemart_payment_plg_standard` ( `id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT, `virtuemart_order_id` INT(1) UNSIGNED DEFAULT NULL, `order_number` CHAR(32) DEFAULT NULL, `virtuemart_paymentmethod_id` MEDIUMINT(1) UNSIGNED DEFAULT NULL, `payment_name` VARCHAR(5000), `payment_order_total` DECIMAL(15,5) NOT NULL DEFAULT '0.00000', `payment_currency` CHAR(3) , `cost_per_transaction` DECIMAL(10,2) DEFAULT NULL, `cost_percent_total` DECIMAL(10,2) DEFAULT NULL, `tax_id` SMALLINT(1) DEFAULT NULL, `created_on` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` int(11) NOT NULL DEFAULT 0, `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(11) NOT NULL DEFAULT 0, `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `locked_by` int(11) NOT NULL DEFAULT 0) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
com_virtuemart_allinoneInstallerScript:: SHOW TABLES LIKE "%virtuemart_payment_plg_payzen"
com_virtuemart_allinoneInstallerScript:: SHOW TABLES LIKE "%virtuemart_payment_plg_authorizenet"
com_virtuemart_allinoneInstallerScript:: SHOW TABLES LIKE "%virtuemart_payment_plg_paypal"
com_virtuemart_allinoneInstallerScript:: SHOW TABLES LIKE "%virtuemart_shipment_plg_weight_countries" hot_virtuemart_shipment_plg_weight_countries
com_virtuemart_allinoneInstallerScript:: VirtueMart2 update #__virtuemart_shipment_plg_weight_countries
createTable ERROR :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=CREATE TABLE IF NOT EXISTS `arq_virtuemart_shipment_plg_weight_countries` ( `id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT, `virtuemart_order_id` INT(11) UNSIGNED DEFAULT NULL, `order_number` CHAR(32) DEFAULT NULL, `virtuemart_shipmentmethod_id` MEDIUMINT(1) UNSIGNED DEFAULT NULL, `shipment_name` VARCHAR(5000), `order_weight` DECIMAL(10,4) DEFAULT NULL, `shipment_weight_unit` CHAR(3) DEFAULT 'KG' , `shipment_cost` DECIMAL(10,2) DEFAULT NULL, `shipment_package_fee` DECIMAL(10,2) DEFAULT NULL, `tax_id` SMALLINT(1) DEFAULT NULL, `created_on` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` int(11) NOT NULL DEFAULT 0, `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(11) NOT NULL DEFAULT 0, `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `locked_by` int(11) NOT NULL DEFAULT 0) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
com_virtuemart_allinoneInstallerScript:: SHOW TABLES LIKE "%virtuemart_custom_plg_textinput"
com_virtuemart_allinoneInstallerScript:: SHOW TABLES LIKE "%virtuemart_custom_plg_specification"
com_virtuemart_allinoneInstallerScript:: SHOW TABLES LIKE "%virtuemart_custom_plg_stockable"
com_virtuemart_allinoneInstallerScript:: SHOW TABLES LIKE "%virtuemart_arch_plg_virtuemart"
Installing component was successful.


anyway, the front-end seems to work pretty well.

hope this info is usefull.
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: observ3r on March 05, 2012, 23:33:00 pm
i also had a similar issue with my last upgrade from 2.0.1 to 2.0.2

namely-> when i did a clean install my issue went away

joomla 2.5.1 vm 2.0.2

rgds
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: enock on March 06, 2012, 00:49:27 am
Upgrade a copy J2.5.1 VM2.02 - all products (4400) not showing - in backend get this error

vmError: exeSortSearchListQuery Incorrect key file for table '/tmp/#sql_58b8_0.MYI'; try to repair it SQL=SELECT SQL_CALC_FOUND_ROWS * FROM `mag_virtuemart_products_en_au` as l JOIN `mag_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `mag_virtuemart_product_categories` ON p.`virtuemart_product_id` = `mag_virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `mag_virtuemart_categories_en_au` as c ON c.`virtuemart_category_id` = `mag_virtuemart_product_categories`.`virtuemart_category_id` ORDER BY `mag_virtuemart_product_categories`.`ordering` DESC LIMIT 0, 10

Tried the above and got

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQL=SELECT SQL_CALC_FOUND_ROWS * FROM `mag_virtuemart_products_en_au` as l JOIN ' at line 1
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: Milbo on March 06, 2012, 00:54:32 am
Edit: product categories >> in column Products for show products in products categories>> display errors:

vmError: exeSortSearchListQuery Column 'virtuemart_product_id' in order clause is ambiguous SQL=SELECT SQL_CALC_FOUND_ROWS * FROM `jos_virtuemart_products_de_de` as l JOIN `jos_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `jos_virtuemart_product_categories` ON p.`virtuemart_product_id` = `jos_virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `jos_virtuemart_categories_de_de` as c ON c.`virtuemart_category_id` = `jos_virtuemart_product_categories`.`virtuemart_category_id` WHERE ( `jos_virtuemart_product_categories`.`virtuemart_category_id` = 22) ORDER BY virtuemart_product_id DESC LIMIT 0, 10

Thx, I think found it.


createTable ERROR :Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=CREATE TABLE IF NOT EXISTS `arq_virtuemart_shipment_plg_weight_countries` ( `id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT, `virtuemart_order_id` INT(11) UNSIGNED DEFAULT NULL, `order_number` CHAR(32) DEFAULT NULL, `virtuemart_shipmentmethod_id` MEDIUMINT(1) UNSIGNED DEFAULT NULL, `shipment_name` VARCHAR(5000), `order_weight` DECIMAL(10,4) DEFAULT NULL, `shipment_weight_unit` CHAR(3) DEFAULT 'KG' , `shipment_cost` DECIMAL(10,2) DEFAULT NULL, `shipment_package_fee` DECIMAL(10,2) DEFAULT NULL, `tax_id` SMALLINT(1) DEFAULT NULL, `created_on` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` int(11) NOT NULL DEFAULT 0, `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(11) NOT NULL DEFAULT 0, `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `locked_by` int(11) NOT NULL DEFAULT 0) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


Hmm we tried to find the problem today already, we found this and that small problem, fixed them, but we did not find out the problem with this error message, because we dont have it. It is just missing the primary key, which should be always added (and is in our case).
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: klezmer41 on March 06, 2012, 00:59:06 am
I tried out the product re-ordering, and have found some strange errors. The arrows were inaccessible until I added integers to the text fields and then clicked the disk icon.

Then the arrows only seemed to jack up ordering. For example the Garden Tools (4) only had an arrow to decrease its weight.

[attachment cleanup by admin]
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: maxispin on March 06, 2012, 11:11:38 am
TAKE BACKUPS BEFORE YOU TEST NEW VERSIONS!
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: Milbo on March 06, 2012, 12:59:16 pm
I tried out the product re-ordering, and have found some strange errors. The arrows were inaccessible until I added integers to the text fields and then clicked the disk icon.

Then the arrows only seemed to jack up ordering. For example the Garden Tools (4) only had an arrow to decrease its weight.

Interesting, I must admit I was not aware of this feature before. This feature is by its nature also complex to handle. Atm we do not store an ordering per category and product. So when a product is in more than one category, it will have the wrong ordering in one category, because it stores only one value per product.
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: beipink on March 06, 2012, 15:21:10 pm
This feature is by its nature also complex to handle.
Hi Max,
I guess this has to be addressed at some stage sooner or later :)
Just out of curiosity, How was this handled in VM 1?
...as far as i remember  products ordering for a single category worked pretty well in VM1.
of course VM1 was far from being perfect. it could reorder products only in 1 category.
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: vigier on March 06, 2012, 18:28:26 pm
vigier did you used the latest aio? or the aio before the core? I tried to understand the error but looks for me impossible. The error with the missing category, hmmm. Normal products must have a category. I wonder how you show them. With single joomla menu items? We can remove the notice, not big deal, just so.
Hi Milbo,
I first installed the core, then the aio. The first time I installed VM I forgot the aio, since then I never forget it. Since my site has only 1 categorie, I found it useless to use categories. I'll logon to my other computer to change the site to use a category. I'll give you an update this evening.


2)
Warning: Invalid argument supplied for foreach() in C:\wamp\www\Joomla\libraries\joomla\html\html\select.php on line 504
Call Stack
# Time Memory Function Location
1 0.0003 648312 {main}( ) ..\index.php:0
2 0.2611 20998664 JSite->render( ) ..\index.php:48
3 0.2658 21310888 JDocumentHTML->render( ) ..\application.php:261
4 0.2658 21310888 JDocumentHTML->_renderTemplate( ) ..\html.php:433
5 0.2672 21374376 JDocumentHTML->getBuffer( ) ..\html.php:655
6 0.2672 21374992 JDocumentRendererModules->render( ) ..\html.php:371
7 0.2672 21376456 JDocumentRendererModule->render( ) ..\modules.php:39
8 0.2673 21378072 JModuleHelper::renderModule( ) ..\module.php:106
9 0.2688 21439976 include( 'C:\wamp\www\Joomla\modules\mod_virtuemart_currencies\mod_virtuemart_currencies.php' ) ..\helper.php:175
10 0.2696 21440888 require( 'C:\wamp\www\Joomla\modules\mod_virtuemart_currencies\tmpl\default.php' ) ..\mod_virtuemart_currencies.php:49
11 0.2697 21441320 JHtml::_( ) ..\default.php:8
12 0.2697 21442784 JHtml::call( ) ..\html.php:103
13 0.2697 21444792 call_user_func_array ( ) ..\html.php:222
14 0.2697 21445696 JHtmlSelect::genericlist( ) ..\html.php:222
15 0.2697 21447624 JHtmlSelect::options( )

Hi,
Seems you don't have set the currencies in VM2.
It's an error, but i mean if vm2 is right set this error don't appear.
Before the update, the currency was set to EURO €, but I'll try to set it to Euro again and give you an update.

Kind regards, Vigier
Title: Re: New pre subrelease VirtueMart 2.0.3.A update
Post by: smimish on March 06, 2012, 21:02:32 pm
Thanks guys, 2.0.3a seems to have fixed the problem with SEO and selecting the number of products per page.
Title: Re: New pre subrelease VirtueMart 2.0.3.A update
Post by: peebee on March 06, 2012, 22:27:55 pm
Not sure what changes you made to the AIO in 2.0.3a but it also seems to have fixed the error;

"Warning: Invalid argument supplied for foreach() in
/home/xxxxxx/public_html/xxxxxx/libraries/joomla/html/html/select.php on line 504"
and no currencies being displaying in the module dropdown

which I was experiencing in the 2.0.3 currency converter module.  Thanks for the great work.
Title: Re: New pre subrelease VirtueMart 2.0.3.B update
Post by: freeme on March 07, 2012, 20:13:08 pm
Is it possible that with 2.0.3.b, no confirmation mails to the customer and to the vendor are sent out anymore?

Installed VM203b on J252 and made a test order: I see the confirmation page for the order on the website, but I am not getting the vendor or the customer confirmation email.

It worked already before, haven´t change anything in the general Joomla eMail settings...
Title: Re: New pre subrelease VirtueMart 2.0.3.B update
Post by: Sophia23 on March 08, 2012, 13:02:12 pm
I still have the "Please enter a name" issue during registration with 2.0.3.b

Customers cant register, hence not buy anything and I wont be able to pay my rent.


Joomla 1.5.25
VM 2.0.3.b
Title: Re: New pre subrelease VirtueMart 2.0.3.B update
Post by: maxispin on March 08, 2012, 13:12:04 pm
Can you give your site address?
Title: Re: New pre subrelease VirtueMart 2.0.3.B update
Post by: alatak on March 08, 2012, 13:30:36 pm
Hi,

Quote
"Warning: Invalid argument supplied for foreach() in
/home/xxxxxx/public_html/xxxxxx/libraries/joomla/html/html/select.php on line 504"
and no currencies being displaying in the module dropdown
Fixed in the VirtueMart 2.0.3b

==> sorry was not included in 2.0.3b, but it is fixxed
Title: Re: New pre subrelease VirtueMart 2.0.3.B update
Post by: alatak on March 08, 2012, 14:25:50 pm
Hi,

Quote
Is it possible that with 2.0.3.b, no confirmation mails to the customer and to the vendor are sent out anymore?
which payment method are you using?
Title: Re: New pre subrelease VirtueMart 2.0.3.B update
Post by: freeme on March 08, 2012, 15:07:32 pm
Hi alatalk - I am using the standard VM Payment plugin for this. Just tested again. No vendor email received. No customer email received.
Title: Re: New pre subrelease VirtueMart 2.0.3.B update
Post by: OpenGlobal on March 10, 2012, 01:03:48 am
I can confirm that the PayPal payment plugin is still not updating the order status to confirmed after a successful payment.

OpenGlobal
Title: Re: New pre subrelease VirtueMart 2.0.3
Post by: vigier on March 11, 2012, 18:33:46 pm
vigier did you used the latest aio? or the aio before the core? I tried to understand the error but looks for me impossible. The error with the missing category, hmmm. Normal products must have a category. I wonder how you show them. With single joomla menu items? We can remove the notice, not big deal, just so.
Hi Milbo,
I first installed the core, then the aio. The first time I installed VM I forgot the aio, since then I never forget it. Since my site has only 1 categorie, I found it useless to use categories. I'll logon to my other computer to change the site to use a category. I'll give you an update this evening.


2)
Warning: Invalid argument supplied for foreach() in C:\wamp\www\Joomla\libraries\joomla\html\html\select.php on line 504
Call Stack
# Time Memory Function Location
1 0.0003 648312 {main}( ) ..\index.php:0
2 0.2611 20998664 JSite->render( ) ..\index.php:48
3 0.2658 21310888 JDocumentHTML->render( ) ..\application.php:261
4 0.2658 21310888 JDocumentHTML->_renderTemplate( ) ..\html.php:433
5 0.2672 21374376 JDocumentHTML->getBuffer( ) ..\html.php:655
6 0.2672 21374992 JDocumentRendererModules->render( ) ..\html.php:371
7 0.2672 21376456 JDocumentRendererModule->render( ) ..\modules.php:39
8 0.2673 21378072 JModuleHelper::renderModule( ) ..\module.php:106
9 0.2688 21439976 include( 'C:\wamp\www\Joomla\modules\mod_virtuemart_currencies\mod_virtuemart_currencies.php' ) ..\helper.php:175
10 0.2696 21440888 require( 'C:\wamp\www\Joomla\modules\mod_virtuemart_currencies\tmpl\default.php' ) ..\mod_virtuemart_currencies.php:49
11 0.2697 21441320 JHtml::_( ) ..\default.php:8
12 0.2697 21442784 JHtml::call( ) ..\html.php:103
13 0.2697 21444792 call_user_func_array ( ) ..\html.php:222
14 0.2697 21445696 JHtmlSelect::genericlist( ) ..\html.php:222
15 0.2697 21447624 JHtmlSelect::options( )

Hi,
Seems you don't have set the currencies in VM2.
It's an error, but i mean if vm2 is right set this error don't appear.
Before the update, the currency was set to EURO €, but I'll try to set it to Euro again and give you an update.

Kind regards, Vigier
I did set the currency for the shop, but not "Accepted currency". This part is fixed now. Thnx!
Title: Re: New pre subrelease VirtueMart 2.0.3.B update
Post by: fmp.martins on March 14, 2012, 11:55:32 am
I'm unable to checkout without registering/authenticating in 2.0.2 stable and in 2.0.3b, as I've reported here http://forum.virtuemart.net/index.php?topic=99087.0
Title: Re: New pre subrelease VirtueMart 2.0.3.B update
Post by: fmp.martins on March 14, 2012, 16:11:29 pm
In 2.0.3b the "Email this to a friend" functionality:
(i) is not loading the defined template CSS, seems to load only genera.css.
(ii) is not i18n, showing only "info" and hard coded text (see note next point).
(iii)function  MailForm  in components\com_virtuemart\controllers\productdetails.php is not i18n, it has "YOU MUST LOGIN FIRST" hard coded, it should be "COM_VIRTUEMART_LOGIN_REQUIRED".
Title: Re: New pre subrelease VirtueMart 2.0.3.B update
Post by: Milbo on March 15, 2012, 13:07:48 pm
I can confirm that the PayPal payment plugin is still not updating the order status to confirmed after a successful payment.

OpenGlobal

This is working for us!
Title: Re: New pre subrelease VirtueMart 2.0.3.B update
Post by: freeme on March 15, 2012, 13:21:31 pm
I can confirm that the PayPal payment plugin is still not updating the order status to confirmed after a successful payment.

OpenGlobal

This is working for us!

OpenGlobal: I am having the same issue as you currently. PayPayl plugin is not updating the order status to confirmed after successful payment. I was trying that within the sandbox. However - I believe that there is no confirmation sent from Paypal to VM. Check, if that happened to you as well.

What I found in the Sandbox account is that the purchase is confirmed and deducted from the buyers account. But internally, the amount is not "approved" for the vendor. There is a functionality in Sandbox to "approve" it. But probably still no confirmation sent from Paypal to VM...