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
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
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:
- I use Joomla 2.5.1.
- I don't use categories. Added this because I see a few things about Category_id in the errors
Hope the above information helps you developing a stable 2.0.3.
Kind regards,
Vigier
Pagination is completely broken.
VM 2.0.3 + Joomla 2.5.1.
The language of the shop is Russian.
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
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.
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
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
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.
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?
Quote from: prolipes on March 05, 2012, 02:56:15 AM
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
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...
Quote from: 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.
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.
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
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
Quote from: prolipes 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 !! :-/
Hi,
Try to click on 'ordering' colum to see the right ordering
Vm2 permit change ordering if you have ordering by name for eg.
Quote from: vigier on March 04, 2012, 23:25:40 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.
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
I have added a fix in SVN files for category pagination in SEF problems.
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
Quote from: 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?
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.
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.
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
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
Quote from: icemangs on March 05, 2012, 19:08:53 PM
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.
Quote from: xevi on March 05, 2012, 23:23:08 PM
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).
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]
TAKE BACKUPS BEFORE YOU TEST NEW VERSIONS!
Quote from: 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.
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.
Quote from: Milbo on March 06, 2012, 12:59:16 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.
Quote from: 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.
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.
Quote from: Electrocity on March 05, 2012, 17:01:57 PM
Quote from: vigier on March 04, 2012, 23:25:40 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.
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
Thanks guys, 2.0.3a seems to have fixed the problem with SEO and selecting the number of products per page.
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.
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...
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
Can you give your site address?
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
Hi,
QuoteIs 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?
Hi alatalk - I am using the standard VM Payment plugin for this. Just tested again. No vendor email received. No customer email received.
I can confirm that the PayPal payment plugin is still not updating the order status to confirmed after a successful payment.
OpenGlobal
Quote from: vigier on March 06, 2012, 18:28:26 PM
Quote from: 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.
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.
Quote from: Electrocity on March 05, 2012, 17:01:57 PM
Quote from: vigier on March 04, 2012, 23:25:40 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.
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!
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
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".
Quote from: 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
This is working for us!
Quote from: Milbo on March 15, 2012, 13:07:48 PM
Quote from: 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
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...