I'm betting this error is unique to me as no one else has mentioned it. I'm wondering if it because of my use of custom fields?
I downloaded the new RC 1.9.8i and tried to install it but every time I do I get this:
(BTW I am updating form RC 1.9.8H)
JDatabaseMySQL::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLUMN `product_order_levels`' at line 1 SQL=ALTER TABLE `jml_virtuemart_products` DROP COLUMN `product_order_levels` COLUMN `product_order_levels`
Callstack:
Call stack
# Function Location
1 JAdministrator->dispatch() /hermes/bosweb/web139/b1391/ipg.collegekidscom/public_html/joomla_cms/administrator/index.php:47
2 JComponentHelper::renderComponent() /hermes/bosweb/web139/b1391/ipg.collegekidscom/public_html/joomla_cms/administrator/includes/application.php:153
3 require_once() /hermes/bosweb/web139/b1391/ipg.collegekidscom/public_html/joomla_cms/libraries/joomla/application/component/helper.php:156
4 JController->execute() /hermes/bosweb/web139/b1391/ipg.collegekidscom/public_html/joomla_cms/administrator/components/com_akeeba/akeeba.php:167
5 AkeebaControllerInstaller->realinstall() /hermes/bosweb/web139/b1391/ipg.collegekidscom/public_html/joomla_cms/libraries/joomla/application/component/controller.php:679
6 AkeebaModelInstaller->realInstall() /hermes/bosweb/web139/b1391/ipg.collegekidscom/public_html/joomla_cms/administrator/components/com_akeeba/controllers/installer.php:172
7 JInstaller->install() /hermes/bosweb/web139/b1391/ipg.collegekidscom/public_html/joomla_cms/administrator/components/com_akeeba/models/installer.php:219
8 JInstallerComponent->install() /hermes/bosweb/web139/b1391/ipg.collegekidscom/public_html/joomla_cms/libraries/joomla/installer/installer.php:385
9 JInstallerComponent->update() /hermes/bosweb/web139/b1391/ipg.collegekidscom/public_html/joomla_cms/libraries/joomla/installer/adapters/component.php:141
10 com_virtuemartInstallerScript->update() /hermes/bosweb/web139/b1391/ipg.collegekidscom/public_html/joomla_cms/libraries/joomla/installer/adapters/component.php:821
11 com_virtuemartInstallerScript->alterTable() /hermes/bosweb/web139/b1391/ipg.collegekidscom/public_html/joomla_cms/tmp/install_4e9ed4419244a/install/script.virtuemart.php:184
12 JDatabaseMySQLi->query() /hermes/bosweb/web139/b1391/ipg.collegekidscom/public_html/joomla_cms/tmp/install_4e9ed4419244a/install/script.virtuemart.php:265
13 JError::raiseError() /hermes/bosweb/web139/b1391/ipg.collegekidscom/public_html/joomla_cms/libraries/joomla/database/database/mysqli.php:535
14 JError::raise() /hermes/bosweb/web139/b1391/ipg.collegekidscom/public_html/joomla_cms/libraries/joomla/error/error.php:215
BTW on a side note I moved my development to my local machine recently in an effort to connect my project with the SVN but I'm having trouble merging the Virtuemart SVN with my Local install of Joomla! If anyone knows how to do this in eclipse or could point me in the right direction it could be helpful. Do I simply copy the files from the SVN after check out and drop them into the project or can I check them out directly into the project using Subclipse? (Should this be in a separate post somewhere else?)