Block timeout in installation causes uninstall error
Permalink
I have a C5 site Currently Running 5.7.3.1 in which I tried to install Vivid-store. During the install I had a timeout issue. Now I can neither install nor uninstall and the cart does not work. The site is live athttp://www.ojuve.com but the store is not visible in the dashboard.
I tried manually adding tables that erred out during the uninstall process. Then it wants fields and data.
It just occurred to me to copy tables from another site to make the install work or the uninstall work. I have another site with a blank install just like this would be. I will try that.
Last error page is as follows.
An exception occurred while executing 'SELECT t0.smtID AS smtID1, t0.smtHandle AS smtHandle2, t0.smtName AS
smtName3, t0.pkgID AS pkgID4 FROM VividStoreShippingMethodTypes t0 WHERE t0.smtHandle = ? LIMIT 1' with params
["flat_rate"]: SQLSTATE[42S02]: Base table or view not found: 1146 Table
'i1220483_conc1.VividStoreShippingMethodTypes' doesn't exist
After downloading the 3.01 Vivid Store package and unzipping in the packages directory uninstall does not show anything. The Uninstall button is highlighted in red, no working icon. No nothing. No error screens like above.
In looking at the table structure of the other site which has a blank vivid store installed, there is a lot to rebuild to make sure the cart is there enough to work or to uninstall and install again. Wish I had made a backup before installing. I have installed this block at least three times before with no troubles so I did not expect any this time.
Thanks in Advance for any help or insight.
I tried manually adding tables that erred out during the uninstall process. Then it wants fields and data.
It just occurred to me to copy tables from another site to make the install work or the uninstall work. I have another site with a blank install just like this would be. I will try that.
Last error page is as follows.
An exception occurred while executing 'SELECT t0.smtID AS smtID1, t0.smtHandle AS smtHandle2, t0.smtName AS
smtName3, t0.pkgID AS pkgID4 FROM VividStoreShippingMethodTypes t0 WHERE t0.smtHandle = ? LIMIT 1' with params
["flat_rate"]: SQLSTATE[42S02]: Base table or view not found: 1146 Table
'i1220483_conc1.VividStoreShippingMethodTypes' doesn't exist
After downloading the 3.01 Vivid Store package and unzipping in the packages directory uninstall does not show anything. The Uninstall button is highlighted in red, no working icon. No nothing. No error screens like above.
In looking at the table structure of the other site which has a blank vivid store installed, there is a lot to rebuild to make sure the cart is there enough to work or to uninstall and install again. Wish I had made a backup before installing. I have installed this block at least three times before with no troubles so I did not expect any this time.
Thanks in Advance for any help or insight.
Have you tried to modify the version number from 3.0.1 to something higher in the package's controller and then try to upgrade to see if it adds the missing tables?
Tried that. Good idea. It did not work.
I ended up using the SQL from the other site to generate the tables and data missing from the erred install. It was only two tables I found out.
I then uninstalled.
I installed again. The cart would still not function. Ir installed but the products page in the dashboard never showed.
I finally gave up. Deleted the old site and installed a fresh c5 and installed the shopping cart. Worked.
Not the best solution. Worked for me as the original site had little in it.
I ended up using the SQL from the other site to generate the tables and data missing from the erred install. It was only two tables I found out.
I then uninstalled.
I installed again. The cart would still not function. Ir installed but the products page in the dashboard never showed.
I finally gave up. Deleted the old site and installed a fresh c5 and installed the shopping cart. Worked.
Not the best solution. Worked for me as the original site had little in it.
