Environment #1:
Joomla 3.4.0
VirtueMart 3.0.6.2
MySQL 5.5.40-36.1
PHP 5.5.22
max_execution_time 30
memory_limit 256M
This is a fully configured and functioning site, including Virtuemart.
Environment #2:
Joomla 3.4.1
VirtueMart 3.0.7
MySQL 5.5.40-36.1
PHP 5.5.22
max_execution_time 30
memory_limit 256M
Consists of an unconfigured Joomla core plus unconfigured Virtuemart.
= = = = =
Environment #1 started out with Virtuemart 3.0.4, I then upgraded it to 3.0.6.2, the first time it failed, but after restoring my backup and trying again, it eventually worked. When I tried to upgrade Virtuemart 3.0.6.4, eventually I got the error: "405 Not Allowed". If I drop the session and relogin to the administrator, I get a mile long list of "alterColumns alterKey not finished, please rise execution time and update tables again" types errors again. I've repeated the cycle with each of the subsequent updates to Virtuemart: 3.0.6.4, 3.0.7, and 3.0.7.2. I've tried a variety of scenarios, upgrading the core Joomla to 3.4.1, and then Virtuemart, upgrading to varying releases of Virtuemart, all with the same results.
I then tried to create a minimalist instance - Environment #2. First I tried to load Joomla 3.4.1 and Virtuemart 3.0.6.4 and encountered the same problem during the install process. Following a forum suggestion, I eventually created an wampp installation on my PC, loaded Joomla 3.4.1 and Virtuemart 3.0.7 (plus AIO). The installation process appeared to go well, so I backed it up with AkeebaBackup and moved it back to my development server. I logged into the server version, attempted to modify and save the first word of the Virtuemart shop down message and save it. After several seconds, it eventually timed out with a mile long list of:
alterColumns alterKey not finished, please rise execution time and update tables again
compareUpdateTable alterKey not finished, please rise execution time and update tables again
I then tried invoking the "Install or if necessary update tables" under Virtuemart > Tools > DB Tools, same problem.
And as a last ditch effort, I tried to upgrade it to 3.0.7.2, same results
At this point, it's been impossible for me to upgrade my system past VirtueMart 3.0.6.2, which is obviously unacceptable.
I've turned on vmdebug and don't see any errors.
Any one have any other suggestions? (Please don't suggest increasing the max_execution_time, I don't have access to it, and the hosting provider won't do it. Plus, I don't see why a 'minor' upgrade should all of a sudden start causing such problems).
it does sound like your execution time is too short ..
If your host won't raise it my response would be to vote with my feet and change host..
other wise why not Akeeba-> install locally xamp-> upgrade etc -> check-> akeeba-> install complete on host
Or won't akeeba run on the host either?
The expand the jpa locally -> upload to server- run installer
Changing hosting services is not at an option at this time.
With respect to using using xampp
- it makes it rather difficult for multiple people to be able to do the work
- makes it difficult to do maintenance when I don't have access to my 'staging' PC
- if you'll check my notes, even doing that did not solve the problem, to re-iterate:
... moved it back to my development server. I logged into the server version, attempted to modify and save the first word of the Virtuemart shop down message and save it. After several seconds, it eventually timed out with a mile long list of:
alterColumns alterKey not finished, please rise execution time and update tables again
compareUpdateTable alterKey not finished, please rise execution time and update tables again
Any other ideas?
don't follow your answer - your complaining that you can't update
this is a one time process - do it on Xamp and then ftp it back up - where's the problem?
Who needs to collaborate?
the other errors you mention - what have they to do with updating? There is no auto update script that fires when you do some admin...
So what is causing the administrator\components\com_virtuemart\helpers\tableupdater.php script to run again (which is where these messages come from) when you say you just saved an admin task?
But - if you want to stay with a crap host then that is your decision - but don't complain when the results are disappointing..
Am always amazed how people cling to a duff host like an old sick favourite uncle... when the obvious solution is to get a good one.. (uncle &/or host)
I have the same problems with VM...
Can you give us a real and concrete solution for this?
post 2 ???????
Аnd I have the same problem. I have not yet found a solution.
Actually I dont think the host is the problem. I think the problem is your slow upload. So uploading and executing the script takes too long.
Furthermore your host seem to prevent the higher execution time set by the script. So one solution is to upload and extract the package to a tmp folder and use the "local install" option.
Quote from: Milbo on May 20, 2015, 17:08:33 PM
Actually I dont think the host is the problem. I think the problem is your slow upload. So uploading and executing the script takes too long.
Furthermore your host seem to prevent the higher execution time set by the script. So one solution is to upload and extract the package to a tmp folder and use the "local install" option.
I did this. Uploaded the whole package, tried to install from web, unpacked the package to the temp. Everytime I have the same notice:
QuoteWarning
compareUpdateTable alterKey not finished, please rise execution time and update tables again
alterColumns alterKey not finished, please rise execution time and update tables again
compareUpdateTable alterKey not finished, please rise execution time and update tables again
alterColumns alterKey not finished, please rise execution time and update tables again
compareUpdateTable alterKey not finished, please rise execution time and update tables again
alterColumns alterKey not finished, please rise execution time and update tables again
compareUpdateTable alterKey not finished, please rise execution time and update tables again
alterColumns alterKey not finished, please rise execution time and update tables again...........
Same issue with last two versions. (3.0.8 and now 3.0.9)
Using Joomla: 3.4.1.
Using Host: Hostgator
PHP Version: 5.4
max_execution_time: 180 (can change but 30 was always fine besides basic settings changes should not time out)
Changing basic settings, for example " Use only as catalogue " causes a timeout/405 Error
Did not use to do that prior to 3.0.8.
Do not not know what to do next.
Any luck wsffa ? .. and anybody else ?
Tried to update again to 3.0.9 through upload, extract to temp and install, still the same error after 5 minutes of installing.
Hi!
I have the same problem, but not with installation but rather when saving the config. I am running the latest joomla and VM. It is making using VM impossible.
Any ideas?
Thanks
By the way this started after the installation of tcpdf not sure if it has anything to do with the error
Quote from: wsffa on April 12, 2015, 22:44:27 PM
After several seconds, it eventually timed out with a mile long list of:
alterColumns alterKey not finished, please rise execution time and update tables again
compareUpdateTable alterKey not finished, please rise execution time and update tables again
I then tried invoking the "Install or if necessary update tables" under Virtuemart > Tools > DB Tools, same problem.
And as a last ditch effort, I tried to upgrade it to 3.0.7.2, same results
At this point, it's been impossible for me to upgrade my system past VirtueMart 3.0.6.2, which is obviously unacceptable.
I've turned on vmdebug and don't see any errors.
VM is doing table updates. This table updates are meant to go one-way, that means downgrading your VM can lead to lost data. So when you tried to update to a version and you get "please rise execution time and update tables again". Then just follow the hint and go to the tools, use "Install or if necessary update tables" again. The process itself needs for the sample data just 1-2 seconds. What we do is optimising the table layout for enhanced speed. If you have a big database it can take a bit longer, in that case => just use the tool again. The messages should change and indicate a progress, else there is another problem.
And as I mentioned before, in your case I think it is just the upload time. Remind if you have 30 seconds execution time and it takes 25 seconds to upload the package, joomla/VM has only 5 seconeds left to execute. The update takes usually 5 seconds, the rest is upload time.
I have the same issue using hostgator and vm 3.0.8 and higher versions. I get 504 timeout error when saving configuration changes and trying to install/update table changes. I get an error and warning when uploading images for new products.
1054 Unknown column 'file_class' in 'field list' SQL=INSERT INTO `cueap_virtuemart_medias` (`virtuemart_media_id`,`virtuemart_vendor_id`,`file_title`,`file_description`,`file_meta`,`file_class`,`file_mimetype`,`file_type`,`file_url`,`file_url_thumb`,`published`,`file_is_downloadable`,`file_is_forSale`,`file_is_product_image`,`shared`,`file_params`,`file_lang`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES ('0','1','GolfTournament5.png','','','','image/png','product','images/stories/virtuemart/product/GolfTournament5.png','','1','0','0','0','0','','','2015-06-12 14:56:52','484','2015-06-12 14:56:52','484')
Warning
compareUpdateTable alterKey not finished, please rise execution time and update tables again
alterColumns alterKey not finished, please rise execution time and update tables again
alterColumns alterKey not finished, please rise execution time and update tables again
compareUpdateTable alterKey not finished, please rise execution time and update tables again
alterColumns alterKey not finished, please rise execution time and update tables again
alterColumns alterKey not finished, please rise execution time and update tables again
compareUpdateTable alterKey not finished, please rise execution time and update tables again
alterColumns alterKey not finished, please rise execution time and update tables again
alterColumns alterKey not finished, please rise execution time and update tables again
compareUpdateTable alterKey not finished, please rise execution time and update tables again
alterColumns alterKey not finished, please rise execution time and update tables again
alterColumns alterKey not finished, please rise execution time and update tables again
compareUpdateTable alterKey not finished, please rise execution time and update tables again
alterColumns alterKey not finished, please rise execution time and update tables again
alterColumns alterKey not finished, please rise execution time and update tables again
compareUpdateTable alterKey not finished, please rise execution time and update tables again
alterColumns alterKey not finished, please rise execution time and update tables again
http://docs.virtuemart.net/manual/tools-menu/70-tools-migration.html
Hi Milbo,
Thank you for such a great extension! I just wanted to give you some information about how I was able to solve the database warning message. I was able to correct the database but I could not use the tool "Install or if necessary update tables". It would give the same 405 error. Instead I used the tool, "Reset all tables and install sample data", which ran to completion within seconds. I had to rebuild my store categories, products and settings but it worked.
My question is related to the differences between the two tools. I assume that the tool that worked, "Reset all tables and install sample data", uses some of the same code to reset the tables but then does extra work by installing sample data. What do you think would cause the tool "Install or if necessary update tables" to not run to completion and the other "Reset all tables and install sample data" to work perfectly when the ladder probably has much more work involved to complete its tasks?
Joomla 3.4.1
Virtuemart 3.0.8
Thanks again,
RS
Running these did nothing. I have increased the max_execution_time to 300 and it still does nothing. I am not even updating, this is a fresh install and I get these errors ANY time I save the configuration. This is a bit ridiculous that there are over a thousand views on all the topics related to this and still no solutions that work.
I have also run in to this issue - however mine is a 504 Gateway Timeout
When it happened the first time I noticed that quite a few error messages appeared in the front end and a few things we missing in the backend such as order statuses (only pending option was available), vm menu items & shopper groups, etc.
I uploaded via FTP and tried Installing from Directory. I ran in to the same timeout issue, however I noticed most of the errors and missing elements from the backend were fixed. Order Statuses (except Pending) were still missing though. So it would seem that the update/install made it further through before timing out.
I then thought that it might be database related, so I tried "Install of if necessary update tables" & then received a 504 timeout again. I have used the same hosting (siteground) on multiple sites with virtuemart and other extensions that might be on the "heavier" end of execution time requirements & haven't had this problem with a VM install before. I find it odd that it's only just started occurring (for me) with 3.0.9 & 3.0.9.4.
Not sure if that helps shed any further light on the potential issue. Curious to hear if anyone else in this thread has solved their problems yet.
----- UPDATE -----
I manually imported install.sql, install_essential_data.sql & install_required_data.sql in to my database (via phpmyadmin) and that seemed to resolve most of my issues. I just had to copy the "_virtuemart_orderstates" values again to fix the order status issue.
I know that this might just be MY particular issue, however I thought it could be helpful. If I had to guess I'd say whatever issue was causing the timeout for me, may have been related to the SQL database edits during install.
OMG - Happening to me too.
This install through phpAdmin you speak of, is it relatively easy to do?
Ran the "install/update button" a few times - it takes a good 5 minutes of the browser loading until the error comes back by the way - AND after manually increasing via provider a-la support Ticket and all. But ran it a few times and made note of the error on tip line. It's the same one each time; so doesn't like progress is being made despite the time-out runs out.
Before max execution was 30.
Increased to 300.
Mem limit 128M.
vm 3.0.9
Joomla 3.3.6
You should be using Joomla 3.4.3
What host are you using?
Just upgraded to J3.4.3 and am running the "install or if necessary update" function in another window. It's still loading while I type.
I'm with "Host Monster" ... Have given them a username/login to try and run the update task on their end - maybe they can run it locally or something. Have used previous Virtuemart versions for years; first sign of a problem has been this on my brand new site - AFTER entering like nearly 300 products. Ugh.
The other window is still loading. Will post reply when it finishes.
INteresting.
Atfer updating Joomla, and running the VM database update if necessary thing i get:
[an error occurred while processing this directive]
Then, hit "back" in browser and the usual long string of "rise execution time" errors are there.
ALSO, now, NEW error shows up when adding a new product:
1054 Unknown column 'file_class' in 'field list' SQL=INSERT INTO `qqk3m_virtuemart_medias` (`virtuemart_media_id`,`virtuemart_vendor_id`,`file_title`,`file_description`,`file_meta`,`file_class`,`file_mimetype`,`file_type`,`file_url`,`file_url_thumb`,`published`,`file_is_downloadable`,`file_is_forSale`,`file_is_product_image`,`shared`,`file_params`,`file_lang`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES ('0','1','Presto-Bottle.jpg','','','','image/jpeg','product','images/stories/virtuemart/product/Presto-Bottle.jpg','','1','0','0','0','0','','','2015-07-22 05:50:52','42','2015-07-22 05:50:52','42')
Product was saved, image was not. I'm guessing this may have to do with the tables not getting fully updated in database.
No word back from host support ticket on whether they were able to login and try running on their end.
hello,
I am running into this problem as backwardsfish (Error 1054 when trying to upload a product image) as well as Nginx/Not Allowed errors when trying to save configuration. Increasing max execution time is not an option.
Ran VM3.0.9 on Joomla 3.4.3. Nginx/Not Allowed errors when trying to save configuration. I re-installed Joomla (3.4.3) and installed VM 2.9.8 and I could update configurations, upload product photos, etc quickly & flawlessly. Updated to VM 3.0.9 and sluggishness & not allowed errors re-appear when I tried to make a configuration change. tried to install/update data to no avail.
The install also gave an error, but I can upload the package and install from directory next time. I did not install sample data and only have 2 products, no orders, invoices, etc--in other words, not much data.
Host = Hostgator.
PHP=5.4.38
Any insight would be appreciated.
Interesting. So maybe I could "downgrade" VM and get back to a functioning system but the sounds of things....
I'm committed to Joomla at this point, as well as my host - so seems like my only option.
Are we the only ones upgrading? Darnit, why why why did I upgrade?! :-\ :'(
Does anyone reading this have a functioning UPGRADED 3.0.9 version of VM? Or are all the functioning copies mentioned in previous posts fresh/sample data installs?
I have updated a lot of VM sites to 3.0.9 and now to 3.0.9.4 with no issues. With way in excess of 50,000 downloads of 3.0.9 the few reports of issues are almost all installs on Hostgator and now one on Hostmonster. As I have never used those hosts I have no idea how their packages are set up, but one potential cause of failure for shared hosting on gator has been identified: http://support.hostgator.com/articles/cpanel/php-settings-that-cannot-be-changed
The full thread is there at http://forum.virtuemart.net/index.php?topic=129761
thanks Mr Hill,
that is most helpful. indeed, i know that hostgator doesn't allow shared customers to alter certain php settings. i didn't think it would affect me this much.
can you please indicate a host(s) where vm version 3.0.x has been successful? and what is the max execution time setting that is appropriate?
your thoughts are most appreciated.
lisa
I use United Hosting (http://www.unitedhosting.com/) servers and have never had an installation issue. For Joomla 3 - I use the following settings in local php.ini
max_execution_time = 120
memory_limit = 256M
; File Uploads ;
upload_max_filesize = 32M
post_max_size = 32M
Thank-you for the info. Very interesting re host and I figured as much with so many downloads that this must be a rather isolated problem. I'll read into the thread you recommended, get in touch with my host and report back any progress (or lack thereof!)
Host Monster has increased my max execution from 30 to 300 already but still getting the error. I've asked them to increase memory to see if that helps.
hi backwardsfish,
please let me know if the memory_limit increase helps. unfortunately, the host that Mr. Hill uses is in the UK. I'm in the US. I contacted Hostgator and they won't budge on increasing max_execution_time (unless of course, I upgrade to a VPS package). i'll likely be looking for another host for the production site.
I saw a list of hosts on virtuemart's site...I'll be making some inquiries.
United Hosting do have servers in the US as well as the UK, I have US clients hosted there.
I confirmed my settings as max_execution 300 and max_memory 256MB.
Still receiving error.
compareUpdateTable alterKey not finished, please rise execution time and update tables again
alterColumns alterKey not finished, please rise execution time and update tables again
It's worth pointing out that the store seems to function okay EXCEPT adding pictures to new products or modifying pictures of existing products. Although I also see "Max messages reached" so there could be a TON of un-updated tables that haven't been read yet on simple testing.
Quote from: brentonking on July 14, 2015, 01:38:45 AM
----- UPDATE -----
I manually imported install.sql, install_essential_data.sql & install_required_data.sql in to my database (via phpmyadmin) and that seemed to resolve most of my issues. I just had to copy the "_virtuemart_orderstates" values again to fix the order status issue.
I know that this might just be MY particular issue, however I thought it could be helpful. If I had to guess I'd say whatever issue was causing the timeout for me, may have been related to the SQL database edits during install.
This seems to be a solution. Logging into phpmyAdmin to take a peek around. Any advice? Brentonking?
I manually imported with myPHPadmin as mentioned by BrentonKing. But got a duplicate entry error. Deleted the table mentioned in duplicate. Imported again. Images still giving error but now more specifically, a missing column error on save. Went to the table, manually added the column ("file_class" for the record) images now saving ok.
Shop seems to function. Won't know for sure till it's tested a bit more. "install update tables STILL give a "increase execution time" error and I think I've given it more than enough time and memory in settings through my ISP so something must be wonky with that specific command for my setup. Hopefully there aren't any more missing columns.
BUT, I do also see a new green message box "Database Updated" under all the yellow errors that I either never noticed previous, or wasn't there. So perhaps it is complete?
These errors ALSO come up if I try to re-install the component via a local directory vs upload through browser.
Assume no news is good news from me on this topic going forward. Thanks everybody!
@Mr. Hill: I will take another look at United Hosting, since you've indicated they have US servers.
@backwardsfish: what concerns me is that you shouldn't be getting any database errors at all. i'm so rusty w/ VM, but my limited experience w/ older versions of VM were quite error-free and smooth. if your host allowed the increases to execution time & memory and VM is still not behaving well, then I'm still scratching my head about VM 3.0.9. i may pay for one month of hosting somewhere else to see how things go.
Quote from: ultravelvet on July 23, 2015, 20:47:39 PM
can you please indicate a host(s) where vm version 3.0.x has been successful? and what is the max execution time setting that is appropriate?
Use this link http://virtuemart.net/download
Scroll down to see our recommended hosters.
Hello,
sory i speak bad english.
I have the same problem and I do not understand why.
504 error when I install virtuemart. Like if I use the table repair tool.
When I go through PHPmyadmin to install tables by hand, some tables in the script are still missing on the server.
Joomla! 3.8.13
VirtueMart 3.4.2
max_execution_time 600
memory_limit 512M
post_max_size 128M
upload_max_filesize 1G
Current PHP version: 7.2
Hosting Mochahost.com
I do not know how to deal with this anymore.
My host says that the problem comes from the component.
com_tcpdf_1.0.5.zip and com_virtuemart_ext_aio.zip installs itself without any problem as well as other components.
there may be a problem with a component? RSfirwall for example?
Do you have a solution ?
Thank you
As we have said in this post .. your host is not suitable if u are having these problems...
All hosts are not created equal .. some are not fit for purpose..
If your host won't fix this then find a decent host
Hello,
I see withe my host.
there is a new problem !
when I install the component I no longer have a 504 error but a gray window that opens to say that there is an error (see photo). strange because the other components are installed without problem.
Do you have a solution ?
Thank's lot
It is pointless asking the same question in different ways .. the answer remains .. your server/host
No one else has these problems
Hello,
My host said :
" The problem is due to the fact that your cpanel account reaches hosting limits, the exact error is as follows:
Wed Oct 31 02: 31: 42.588938 2018: error pid 2961 mod_hostinglimits: Error on LVE, enter: LVE (1844) HANDLER (fcgid-script) HOSTNAME (phenixinstitut.com) URL (/index.php) TID (2961) errno ( 7) Read more: http: // e. cloudlinux.com/MHL-E2BIG min_uid (1000) "
My plan :
Physical Memory Usage
123.46 MB / 4 GB ( 3% )
CPU Usage
3 / 100 ( 3% )
Number Of Processes
1 / 200 ( 1% )
do you think their answer is right?
Is there a solution to this problem?
thank you :)
Quote from: Rene.C on October 31, 2018, 16:34:47 PM
Is there a solution to this problem?
Yes, as already advised, get a better host.