Joomla Virtuemart – Error: Module Not Registered.”store” is not a valid VirtueMart core module” solution
When installing VitueMart V1.1.6 if you receive the following error under the Update Log “Error: Module Not Registered.”store” is not a valid VirtueMart core module.” and the following error in the main box “You do not have permission to access the requested module.” this post might help you.
After much searching we found solution that seems to work. This is for who is using Joomla 1.5.x, VM 1.1.6 and MySQL 5.5.
The problem is the fact that MySQL 5.5 no longer supports the TYPE option, instead it uses the ENGINE option. So, when the VM 1.1.6 installation tries to create the DB tables, an error occurs and no tables are created.
Follow these steps:
1) Install the VM 1.1.6 as shown in the installation guide. Once you get to the window saying “Welcome to VirtueMart 1.1.6 stable” click either button. After a few seconds the installation will stop with the message “Error: Module Not Registered.”store” is not a valid VirtueMart core module.”
2) Make a copy of the file “virtuemart.installation.joomla.sql” that is located in the sql directory.
3) Edit the new file. Do global replace of “TYPE=” with “ENGINE=” and another global replace of “TYPE =” with “ENGINE =”.
4) Open your phpMyAdmin (PMA) frontend for MySQL. Find your website DB. If you scroll down, you’ll notice that some or all of the “jos_vm_xyz” tables are missing. In my case they were all missing. Select the “SQL” tab.
5) Copy the contents of your new installation.joomla.sql file. Paste the contents into the PMA window at the “SQL” tab. Hit the GO button.
6) You may get a syntax error regarding the “jos_vm_waiting_list” table (I did). I couldn’t figure out the problem so I simply copied the next section of text repeated step 5 with this last few lines of script. This means you won’t have the capability found in the “jos_vm_waiting_list” table.
7) If you want the sample data, open the file “virtuemart.sample_data.sql” copy the contents and repeat step 5.
| Print article | This entry was posted by admin on February 7, 2011 at 5:00 pm, and is filed under How to guides. Follow any responses to this post through RSS 2.0. You can leave a response or trackback from your own site. |
about 1 year ago
Thank very use full. Mysql 5.5 don’t support TIMESTAMP (XX), just dont just extra parametr.
about 12 months ago
Just modify the
`notify_date` timestamp(14) NOT NULL,
to
`notify_date` timestamp NOT NULL,
No parameters for the timestamp
about 11 months ago
Thanks ! It’s very effective ! I actually use the version 1.1.8 of Virtuemart.
about 10 months ago
Thanks for the help and time spent! Worked for me as well. The only thing I would advise is to actually do manual sql query including replacing TYPE with ENGINE as in the instructions AND editing TIMESTAMP line straight after installation and before actually pressing one of the buttons taking you to the shop.
about 10 months ago
thanks for this article. It really helped to solve the problem with VM 1.1.8
thanks!
about 10 months ago
This post is not clear on some things for people like me——-
Wheres the sql directory.
ans– to find sql directory ——–
1. First extract the VirtueMart_1.1.8-COMPLETE_PACKAGE.j15
2. then inside this you have to extract com_virtuemart_1.1.8.j15( this is to be installed in joomla, as we know)
3. inside this you will find admin_files.tar, extract this file, then you will get admin_files file again and again extract this then you will get the SQL DIRECTORY(specified in this post)
about 10 months ago
pls pls help. Ive already installed my site and its live, it wasnt until I enabled acesef (with VM) extension that I am now recieving this error :- Error: Module Not Registered.”http://www” is not a valid VirtueMart core module.i should say i built my site on my test site then used akeeba to transfer it across (worked 100% on other sites) and when I hover over the problematic link i get https://www.orangeghost.co.ul/register/http-wwwscripturedcouk-indexphpoption=com_userview=registeritemid=99. where is it getting my old site address for this link from. aaaaaaaaaaaaaaaaaaah. please could i have some simple instructions if you know the answer to this. I not a noob but its getting frustrating. cheers
about 10 months ago
Thank you!!! I appreciate you taking the time to present the solution to this problem. Also, thank you to the posters before me for the tips that complemented the solution. Now I can actually start learning more about VirtueMart with a functional demo site.
about 10 months ago
Thank you so much for writint clear instructions to solve this problem. And thank you to the person who submitted the TIMESTAMP solution. My VirtueMart is working now.
about 9 months ago
YES!! Its works.
I just want to add the location of the two sql files which is mentioned here. Both of the sql file (virtuemart.installation.joomla.sql and virtuemart.sample_data.sql) can be found at “yourJFolder\administrator\components\com_virtuemart\sql”
Thanks again!!
about 9 months ago
I have the same problem with you.
But I didn’t find the foder sql in com_vituemart, and in the foder com_vituemart doesn’t have classes foder?
Coud you tell me why? and HOw to solve it?
Thank you very much!
about 9 months ago
Muchas gracias por tomarse el tiempo para compartir esto , le estoy muy agredecido
about 9 months ago
Thank you for this solution, really helpful. Thank you very much..
about 9 months ago
Hi, many thanks for very usefull solution!! Everything is fine now and running!
about 8 months ago
MUCHAS GRACIAS, para la ultima parte recomiendo, utilizar el siguiente codigo
CREATE TABLE `jos_vm_waiting_list` (
`waiting_list_id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`notify_email` varchar(150) NOT NULL DEFAULT ”,
`notified` enum(‘0′,’1′) DEFAULT NULL,
`notify_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`waiting_list_id`),
KEY `product_id` (`product_id`),
KEY `notify_email` (`notify_email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
about 8 months ago
Hola, ¿ y sabe alguien porque el virtuemart no muestra los productos que tienen precio en euros, sino solamente en dollars?
gracias.
about 3 months ago
This is a valid and much appreciated post but the steps overlook the syntax error for creating the waiting_list table. Thank you Roka for submitting the correct syntax. For those who do not speak spanish, please refer to Roka’s post for the correct syntax for creating the jos_vm_waiting_list table. Or you can just copy the following and paste it into the sql tab section within PHPmyadmin. It’s all the same
## ——————————————————–
##
## Table structure for table `jos_vm_waiting_list`
##
CREATE TABLE `jos_vm_waiting_list` (
`waiting_list_id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`notify_email` varchar(150) NOT NULL DEFAULT ”,
`notified` enum(‘0′,’1′) DEFAULT NULL,
`notify_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`waiting_list_id`),
KEY `product_id` (`product_id`),
KEY `notify_email` (`notify_email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
##
## Dumping data for table `jos_vm_waiting_list`
##
about 2 months ago
thanks for your kind support, but i am not technical so i m not able to do below step, how to do it?
3) Edit the new file. Do global replace of “TYPE=” with “ENGINE=” and another global replace of “TYPE =” with “ENGINE =”.
about 2 months ago
Hi, i did it my self & now my virtueMart is working fine, i want to share it who are new to Joomla & SQL
i modified “virtuemart.installation.joomla.sql” with notepad & replaced “TYPE=” with “ENGINE=”
& copied the complete text/contents & pasted the contents into the PMA window at the “SQL” tab. Hit the GO button.
about 2 months ago
Nice information. It is helped me lot. Thanks for posting.