I think I have a problem with my vendor table in database. Please can you give me a sql-export from this table?
No, its not the table. I installed a new clear system. Just Joomla and VM. There is the same problem.
No Shop Currency defined! Go to http://www.mydomain.de/administrator/index.php?option=com_virtuemart&view=user&task=editshop
Yes and what is the problem with it? You must define a default shop currency, should we set that by default to $? hmm why not to € or pound and then others will come and say it must be yuan and so on. So it there is not default defined and you just should do it. btw the error message itself contains the right link todo that.
:-) You are 100% right, but this is not the point. If I choose the currency "Euro"and click on "save" - nothing happens. No changes on this page can be saved.
okey,
Then go to tools updatesMigration, use on the second tab the Set store owner. You dont need to enter an ID, when you want to set yourself as storeowner.
Ok, I have made it. Now the Vendor tab is not there. But you see the error message on products list.
I sent you backend login via private message.
Hi could you please tell us if you found a solution as I'm having the same problem
My config is Joomla 1.7 / virtuemart.1.9.8G
StephDSN, you have to choose a currency for the shop to work. Log in and choose one
I wish it were that simple -- I've scoured the whole back-end and can't seem to "select a currency". It's anything but intuitive at best, or there's a real problem at worst.
you guys are not going crazy, the same thing has happened to me.
fresh install of j1.7, virtuemart 1.9.8.rc2g. was receiving no currency defined messages so went to set the shop default currency but the values would not save. followed the steps that milbo provided below to transfer shop owner to myself which appeared to work correctly, but now the shop settings (where the default currency options were previously) are no longer available. it just shows the user form for my own personal details. even after setting myself as a superuser/storeadmin, whenever i go to the shop menu it takes me to the shoppers area.
something is not working as it should be :|
to clarify...
i click on the link in this message - No Shop Currency defined! Go to http://orion/joomla/administrator/index.php?option=com_virtuemart&view=user&task=editshop
it takes me to - Shopper [ Edit ] Super User
Quote from: AngelusWebDesign on September 22, 2011, 00:57:36 AM
I wish it were that simple -- I've scoured the whole back-end and can't seem to "select a currency". It's anything but intuitive at best, or there's a real problem at worst.
Why you do not use the link provided in the message tellling you that you have to setup your store currency? More intuitiv is not possible with current technic.
The problem is in general with the G version, which has a small error, when you try to use it without sampeldata.
Use the new files from the svn and use the database update tool, or use the the sampeldata.
And yes, a shopowner is a user with the atttribute shopper, so the edit shop view, points you to the user edit
Ok, wanted to set myself as a 'shopper' and clicked on my name in the customer/shopper list.
The following error appears:
QuoteUnknown column 'id' in 'order clause' SQL=SELECT o.*, CONCAT_WS(' ',u.first_name,u.middle_name,u.last_name) AS order_name ,m.payment_name AS payment_method FROM hpls_virtuemart_orders o
LEFT JOIN hpls_virtuemart_order_userinfos u
ON u.virtuemart_order_id = o.virtuemart_order_id AND u.address_type="BT"
LEFT JOIN hpls_virtuemart_paymentmethods m
ON o.payment_method_id = m.virtuemart_paymentmethod_id WHERE u.virtuemart_user_id = 43 AND o.virtuemart_vendor_id = "1" ORDER BY id DESC
is also fixed in the svn
same bug here , I am using only euro
I assume I can set this thread to solved? Is it now working for you in the H version?
First: sorry for replying to an 'old' post.
I'm testing the latest 2.0.0-RC-2H beta release.
The problems concerning 'not-saving the Shop Currency settings' as described in this thread still occur when not installing the sample data.
I thought this might be helpful sharing to the dev guys.
Why sorry, I just asked for it some hours ago.
Strange is that I did exactly that today,... we even made the error not to write something into the store name field, so it throwed an error, but stored the vendor address, we just added the vendor store name and it worked.
Please look on the second tab also to fill every information
Just did a fresh 2.0.0-RC-2H install and filled in all the required fields.
No errors showed up this time :)
( This morning I updated my test install from G to H.
Now I tested on a fresh H install. Could have made the difference. )
Anyway, this bug seems to be fixed nicely!
Thanks Milbo.
ahh, great, good to hear
If you still get same error message:
Then go to: Tools->Tools Migration->Reset All tables and do fresh install after that go to Migration Tab and migrate old data.
Then create new vendor and you are off to go
Quote from: Milbo on October 11, 2011, 13:48:50 PM
I assume I can set this thread to solved? Is it now working for you in the H version?
Milbo, I'm having the same problem using 1.9.8 RCi. Fresh install of both Joomla and VM. It seems we can do only one of two things. If we save default currency, then we are not able to save 'additional informations' (store name, etc.) for some reason. This should work without installing sample data. Can we enter the data directly to the DB table? If so, where do I look for it?
Thanks!
i have just done a fresh install of 2.0.0-RC-2i on my joomla 1.7 site and have spent about 4 hours trawling through the forums trying to fix my issues!! the vendor tab has disappeared, the currency is not saved and there is a thumbnail issue...
do you have an actual date for the stable release of a bug free virtuemart compatible with joomla 1.7 or should i look at an alternative shopping cart?
thanks
I have the same problem. Installed a clean version of Joomla 1.7.2 and VirtueMart 1.9.8.RCi.
I set the currency and saved this. And now the vendor tab is disappeared but the error message about the currency not.
Anybody know how to solve this problem ?
yeah use the new version please http://dev.virtuemart.net/attachments/download/331/virtuemart1.9.8.RC2J_extract_first.zip
The new problem is another then told one. The problem in version i is that the information user_is_vendor gets lost when storing vendor data.
The trouble is still the same with RC2M release ...
How can we install sample data, it seams for some guys it solved the trouble ?
I have no access to back admin, and i have always :
No Shop Currency defined! Contact the administrator, if your are one go to http://"myurl"/administrator/index.php?option=com_virtuemart&view=user&task=editshop
and after if i click : Fatal error: Call to undefined method JLanguage::getBackwardLang() in /www/administrator/components/com_virtuemart/compat.joomla1.5.php on line 78
Quote from: scoody on November 22, 2011, 17:07:39 PM
and after if i click : Fatal error: Call to undefined method JLanguage::getBackwardLang() in /www/administrator/components/com_virtuemart/compat.joomla1.5.php on line 78
^^^ that is a virtuemart 1.1 file
Was this a migration?
It's not a 1.1 file, "This file provides compatibility for VirtueMart on Joomla! 1.0.x and Joomla! 1.5"
It's not a migration it's a fresh install of last release "virtuemart1.9.8.RC2M_extract_first.zip" on a fresh install of joomla 1.7.3 ...
My releases :
VirtueMart Administration Composant 1.9.8M October 2011
VirtueMart_allinone Administration Composant 1.9.8m February 2011
VirtueMart Category Site Module 1.9.8 February 2011
Virtuemart Currency Selector Site Module 1.9.8 February 2011
VirtueMart Manufacturers Site Module 1.9.8 February 2011
VirtueMart Products Site Module 1.9.8 February 2011
VirtueMart Search Product Site Module 1.9.8 February 2011
VirtueMart Shopping Cart Site Module 1.9.8 February 2011
There is no compat.joomla1.5.php file in virtuemart1.9.8.RC2M - I just double checked!
attached screenshots of 1.1 and 2.0
[attachment cleanup by admin]
so i have deleted in ftp mode all the admin/component folder for virtuemart and all the joomla component virtuemart.
I download again the last release of virtuemart, install , i have the error it can construct the admin menu for virtumart, but now it works ...
I just miss now the admin link for virtuemart !
=> why did i get this phpfile in my 2.0 package ???
I think you are using cpanel, look here another one had that problem also http://forum.virtuemart.net/index.php?topic=91409.msg307949#msg307949
You can fix the bug of the missing vendor-tab / "No Shop Currency defined!"-message by simply using this SQL-statement (taken from the file "install \ install_sample_data.sql") :
INSERT IGNORE INTO `#__virtuemart_vendor_medias` (`id`,`virtuemart_vendor_id`, `virtuemart_media_id`) VALUES (NULL, 1, 15);
With other words, adding a row to the table "xxx_virtuemart_vendor_medias" with the values
virtuemart_vendor_id = 1
virtuemart_media_id = 15
solves the bug without installing the sample-data.
I am not sure how you did this. Could you clarify the steps a bit?
Bruce
I tried modifying the database as describd and it did not help. Ironically I scrupped the VM database and re-installed VM i an effort to migrate the images along with the other data. That part was succesafull but now I have the no currency defined problem again. I am using 2.01N over J2.5.1.
Bruce
It took a long time to fix this. Not even sure what i did right, but after follwing step detailed above I went into the vituemart_users table and changed the "user_is_vendor" box for the administrator from 0 to 1. I then went to the shoopers tab for the aminstrator and suddently the vendor tab appeared where it was not visible before. The currency USD was already selected and when I clicked "save" the error messages no longer appeared. Yikes!
Bruce
Please I need help too. I also get the error that no shop currency is defined.
It shows up the link to fix it but once I input my parameters in the admin backend , it just shows me a blank page.
Please how do I fix this?
I followed the steps that i detailed starting with adding the database entry as described several posts back. I am not even sure if I could retrace my steps if the problem ocurred again. Do you know how to use phpMyAdmin to modify entries in your database tables? That is kind of a necessary first step if you are going to fix this yourself.
I think the key was that the super admin needs to be defined as the shop owner/vendor. In the mogration this does not always happen automatically so you may need to manually correct this. Se my post below how I did this. After doign that I went into the "Shop" tab under admin and the "vendor" tab was visible where it was not before in addition to "additional information" and "general user information". In the venodr view the currence was show as US Dollar but I hot the save button and the warnings were no more. Hope this helps.
Bruce
guys what you are doing? Please use the tools we have provided for cases like this http://dev.virtuemart.net/projects/virtuemart/wiki/Tools
Install the latest version over the old one, use the database updater and renew config by file and it should work.
Hello Milbo, I tried your suggestions but instead I get this error from my backend
Server error
The website encountered an error while retrieving http://www.smssenda.com/sms/administrator/index.php. It may be down for maintenance or configured incorrectly.
Please what do I do next?
Milbo, I tried using those tools in different ways on multiple occasion and they did not work. I finally fixed it by trial and error as detailed above.
Bruce
Bruce, did your trial and error also include running the SQL query deesen talked about? Because I've also played by the book but I still errors and blank pages.
Deesen sql cannot really work. It is just attaching a media to a vendor. When you have a missing vendor tab the right method is to set "user_is_vendor" to 1 of your user.
Yes, that is what I did too.
Bruce
I have the same problem!! I cant believe than severals months of testing with VM and still not work...
I fill ALL the info, clean install and when I try to add the info in the vendor and aditional information tab the same error plus:
vmError: WARNREG_EMAIL_INUSE
wich email???
Joomla 2.5.2 and VM 2.0.2
mlacunza this is not an error, it is a message that you have to choose something. We cannot set it to euro or dollar, yen, rubbel or whatever. You must define the currency of your shop.
And Warnreg email in use is a joomla message.
Hi,
sorry to stress this issue but my migration hangs on this point, too. As soon as I click the link, I end up in the user account of the shop admin with two tabs named "general userinfo" and "additional info" (I have the German version, so the real names might be a bit different in English).
In both tabs there is no item to set the shop currency. Where do I have to look?
Thanks
Andreas
Ok, what I did now:
Install the new version. Install sample data. Then the admin can see the currency infos in his profile. There is a third tab. Good. Curreny was auto-set to EUR. Surprise!
Then install the aio component. After that I got several errors which I have found a solution for by googling the error messages. So the system works with the sample data.
Then migrate. => No currency defined! => No third tab in the admin profile!
Please dear developers : Several familiy-incomes depend on my working shop. I suppose, I'm not the only person having this migration problems. Please provide a fix or a tip how to proceed.
Thanks & greetings from Germany
Andreas
What i did was:
Go into the database, select you user and make sure it has 1 in the vendor field. In other words set the vendor manually in the database. After this a vendor tab came available and the shop currency could be set.
Mayby I didn't set a vendor in the old version (before migrating).
Hope this helps
Hi,
thanks for the hint. I'm a step further now ;-)
First -> disable all other shop vendors (admin-users) except "admin" in the old VM.
Second -> "admin" has to be the user typ "shopper" not "admin" or "shopowner" what worked well in VM 1.x
Then migrate (but via sample data, not direct!)
That gave me the vendor tab BUT (grrrrr) the Save button there is not working in my case. So I cold select a currency but pressing Save had no effect at all. That was only the case for the admin-user. All other customers could be modified and saved.
Third -> Edit vendor table by hand; set currency from 0 to 47 (Euro in my case) did the trick
Sorry but this migration is a nightmare!
Cheers
Andreas
Same problem here and I have an idea on the problem but no solutions...
The table created vendor_fr_fr (in my case) don't content the field vendor_currency.
I did the migration this way : Installing langage pack before megrating, because when I did this the other way, all the products categories and products was not displayed when the administrator and joomla frontend are tuned to the langage I want.
I still not have solution, I'm not mysql coder.
Hope those informations to be usefull to improve the migrator tool.
-- You can run this SQL query on database to insert the Shop Vendor directly to database using phpMyAdmin
-- Change Vendor Company name and Nr.62 to correct user id. Currency 47 is EUR.
-- Dumping data for table `jos_virtuemart_vendors`
INSERT INTO `jos_virtuemart_vendors` (`virtuemart_vendor_id`, `vendor_name`, `vendor_currency`, `vendor_accepted_currencies`, `vendor_params`, `created_on`, `created_by`, `modified_on`, `modified_by`, `locked_on`, `locked_by`) VALUES
(1, 'Company LTD', 47, '47', 'vendor_min_pov="0.00"|vendor_min_poq=1|vendor_freeshipment=0|vendor_address_format=""|vendor_date_format=""|', '0000-00-00 00:00:00', 0, '2012-01-01 10:10:10', 62, '0000-00-00 00:00:00', 0);
And here are the relevant Inserts to Company (sample) data in the default English (and sample for Finnish.)
Remember to replace the table prefix jos_ with your custom table prefix before using these otherwise you wont see any change.
--
-- Dumping data for table `jos_virtuemart_vendors_en_gb`
--
INSERT INTO `jos_virtuemart_vendors_en_gb` (`virtuemart_vendor_id`, `vendor_store_desc`, `vendor_terms_of_service`, `vendor_legal_info`, `vendor_store_name`, `vendor_phone`, `vendor_url`, `slug`) VALUES
(1, '', '<p>Terms of delivery</p>', '', 'Company LTD', '', 'http://www......net', 'company');
--
-- Dumping data for table `jos_virtuemart_vendors_fi_fi`
--
INSERT INTO `jos_virtuemart_vendors_fi_fi` (`virtuemart_vendor_id`, `vendor_store_desc`, `vendor_terms_of_service`, `vendor_legal_info`, `vendor_store_name`, `vendor_phone`, `vendor_url`, `slug`) VALUES
(1, '', 'Toimitusehdot', 'Yhtio Oy', '', 'http://www......fi', 'yhtio');
Lol guys, what ya doing?
agrupe:
You must just do the migration as the mainvendor, that means you must be superuser.
The main vendor is usually automatically the guy installing vm. So you should login as the shopowner and superuser of your vm1 shop and then do the migration.
iciInfo, I am sorry, but I do not understand what the currency has todo with the language tables. The currency is stored in the virtuemart_vendors table. It is not depending on the language, so why it should be there, then?
Sorry Milbo. Your suggestions just don't work.
I have to agree with Agrupe. This migration to v2 is just pure nightmare.
As far as I can see the problem arises with the admin user being linked with the VM2 Vendor.
That is simply just a terrible idea because v1 created it's own user data tables in VM and its bound to cause all these different errors we can see cropping up.
As far as I can see there is no easy solution for this.
You either get a page that is missing the "Save" button all together (and all CSS disapears) or you get a page that does not have "currency" tab (but does have CSS formatting) and no way to change currency except with a database tool.
(http://www.internet-content.net/virtuemart2_upgrade_bug_shop_edit.png)
(http://www.internet-content.net/virtuemart2_upgrade_bug_currency_edit.png)