Hi Folks,
a client has just reported a strange error that has been appearing since updating to 2.0.8e (although that may be unrelated).
When clicking "Save" or "Save & Close" in the "Configuration" screen they get the following message repeated down the screen seven times:
Info: alterColumns alterKey not finished, please rise execution time and update tables again
Info: compareUpdateTable alterKey not finished, please rise execution time and update tables again
Info: alterColumns alterKey not finished, please rise execution time and update tables again
Info: compareUpdateTable alterKey not finished, please rise execution time and update tables again
Info: alterColumns alterKey not finished, please rise execution time and update tables again
Info: compareUpdateTable alterKey not finished, please rise execution time and update tables again
Info: alterColumns alterKey not finished, please rise execution time and update tables again
Info: compareUpdateTable alterKey not finished, please rise execution time and update tables again
Info: alterColumns alterKey not finished, please rise execution time and update tables again
Info: compareUpdateTable alterKey not finished, please rise execution time and update tables again
Info: alterColumns alterKey not finished, please rise execution time and update tables again
Info: compareUpdateTable alterKey not finished, please rise execution time and update tables again
Info: alterColumns alterKey not finished, please rise execution time and update tables again
Info: compareUpdateTable alterKey not finished, please rise execution time and update tables again
I've taken a copy of the site with Akeeba and set it up on our dev server the problem still appears. Can anyone provide some background as to what could be causing this? I'll try and track it down in Eclipse but that will have to wait until we get some other jobs out of the way.
[EDIT]
I forgot to mention the response is immediately presented the timeout doesn't actually appear to be the cause. The live server has a max_execution_time value of 30 while the dev server has a value of 60 and in both you get the error messages immediately you click the button.
Cheers
Craig
Did you try to update the tables by clicking on 'Tools' - 'Tools & Migration' - 'Install Tables or if necessary update them' already?
For those of you working on a Windows development environment, using ini_get/set with max_execution_time doesn't work on Windows. On my development server, I had to hard code $this->maxScriptTime at line 46 of helpers/tableupdater.php. After that, table updates worked.
Change:
$this->maxScriptTime = ini_get('max_execution_time')*0.90-1;
To:
$this->maxScriptTime = 300*0.90-1;
Hello Alwarren,
I am developing on a windows machine and for me it works there. I think it is maybe some server directive.
I have been frustrated with the same issue on a Windows environment, but the suggested change that alwarren suggested worked for me as well. The result timeout I get when debugging is "-1" rather than the 300-5%.
Unfortunately, when you do an upgrade, it changes the file before the DB updates and then fails again. I had to go into the zip file and update the TableUpdater.php file BEFORE the upgrade. Is does appear that the ini_get/set are not working properly.
Thanks alwarren.
Error:
alterColumns alterKey not finished, please rise execution time and update tables again
compareUpdateTable alterKey not finished, please rise execution time and update tables again
As soon as I changed my "Virtuemart-2-Joomla-3-Bootstrap/administrator/components/com_virtuemart/helpers/tableupdater.php" code to this one I was able to start saving my configuration and my tables updated perfectly and I did not get any more errors.
You should not use this code. It is 5 years old!
Hello,
I have this problem with our new site. I am not able to upload the product picture as as I am getting this error
Then I followed this post and went to "install or update" option inside the configuration/tools, but i still get this error
alterColumns alterKey not finished, please rise execution time and update tables again
in my php.ini i set up a max execution time of 300 seconds but still the problem persist.
Please any idea how to fix this?
Thank you!
@itftaiwan:
Which versions of Joomla and VM do you use?
Are you trying to upload an image with several megabytes in size?
Which method do you use to upload the image?
Do you have 'automatically create thumbnails' enabled in VM configuration?
Do the 300 seconds show up in your Joomla > System information > PHP Settings?
Thank you for your reply..
I am using Joomla 3.6.2 and VM 3.0.14
no the images are only 200k. It is a new site, i have created all the products and descriptions but i cannot upload the "icon" image of the product.
What i do is: Products/Product images/ then under i got the upload file:"please choose fie"
When i upload the file from here i get this error:
An error has occurred
1054 Unknown column 'file_class' in 'field list' SQL=INSERT INTO `#__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','purple85.jpg','','','','image/jpeg','product','images/stories/virtuemart/product/purple85.jpg','','1','0','0','0','0','','','2016-09-12 03:10:32','139','2016-09-12 03:10:32','139')
I have asked my hosting to change the php.ini to 300 seconds, i checked and it was changed.
I have already disable "Enable Dynamic Thumbnail Resizing" but still does not work
Thanks a lot for your help!
has nothing to do with timeouts etc
this is the problem
Unknown column 'file_class' in table #__virtuemart_medias -- it should be there -- try the vm table updater in VM tools
Install or if necessary update tables
:-\ Yes, that is what i do.
When uploading I get this 1054 error. Then i read in this forums to go to tools and "install or update tables if necessary"
Then when doing so i get this error
alterColumns alterKey not finished, please rise execution time and update tables again
and that is why i was trying to fix the execution time :)
In that case if the server can't handle it I would just manually add the field by phpmyadmin
...plus maybe also run 'Repair table' and 'optimize table' from phpmyadmin...
I installed all the web in another hosting and i do not get that error anymore.
I do not understand why but the host cannot handle it
As discussed many times on here all hosts are not created equal .. in fact IMHO some are definitely not fit for purpose...