Installing VM 2.9.8 on Joomla 3.3.1 crashed site

[bk175xt]

Hello Everyone,
I did a bevy of stupid things tonight, but here's the full rundown:

Tonight, I planned to install VirtueMart 2.9.8 on a live site. I didn't take a full backup first, assuming my incremental backups were working(they weren't; always test your backups). First, i applied an update to Joomla to go from Joomla 3.2.4 to Joomla 3.3.1. I did some testing and it was working fine. Then i proceeded to download the VirtueMart2.9.8_Joomla_2.5.22-Stable-Full_Package.zip from the test site and i went to the extension manager and uploaded and installed the ZIP. Once i did this, the site and back end are completely inaccessible.

The Main Page and all subpages show:
Error: 500 - Unknown column 'a.title_alias' in 'field list' SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM jos_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM jos_content AS a LEFT JOIN jos_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS ua ON ua.id = a.created_by LEFT JOIN jos_users AS uam ON uam.id = a.modified_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid = 19 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-07-08 02:54:33') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-07-08 02:54:33') ORDER BY c.lft, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created LIMIT 0, 9

The Back End shows:
Fatal error: Call to undefined method JHtml::getJSObject() in /home/wslsorg/public_html/libraries/cms/html/bootstrap.php on line 476

Line 476 of bootstrap.ini simply says "$options = JHtml::getJSObject($opt);" and the bootstrap.ini wasn't edited by the upgrade, so i figure it's pointing to something elsewhere, but i'm not sure where.

I am not quite sure where to go from here. I am hoping someone here will have some suggestions on things to try, so i can get the site back up soon. I truly appreciate any help you may have.

[bk175xt]

Additional Information: I am using Rockettheme Chapelco Gantry Template, if that matters at all. Additionally, the website is wsls.org.

[GJC Web Design]

Then i proceeded to download the VirtueMart2.9.8_Joomla_2.5.22-Stable-Full_Package.zip and i went to the extension manager and uploaded and installed the ZIP

but this incls. Joomla 2.5.22 in the pack!!!!   amazed you got it to install on a J3.3!!! even as an extension surely it fails?

I really think your buggered - you could troubleshoot this for weeks if you really did install this whole package (is it installable? thought it had to be run like a clean Joomla install)

Personally I would stop while your ahead and start saving as much as you can of tables and folders etc and start afresh - considering that 2.9.8 is still a test release sequence and hasn't been officially approved as stable for J3.3 why are you even doing this - ?

[bk175xt]

Then i proceeded to download the VirtueMart2.9.8_Joomla_2.5.22-Stable-Full_Package.zip and i went to the extension manager and uploaded and installed the ZIP

but this incls. Joomla 2.5.22 in the pack!!!!   amazed you got it to install on a J3.3!!! even as an extension surely it fails?

I really think your buggered - you could troubleshoot this for weeks if you really did install this whole package (is it installable? thought it had to be run like a clean Joomla install)

Personally I would stop while your ahead and start saving as much as you can of tables and folders etc and start afresh - considering that 2.9.8 is still a test release sequence and hasn't been officially approved as stable for J3.3 why are you even doing this - ?

Great questions all around, haha. Thanks for the reply. I suppose I wasn't aware that 2.5.22 was also included in the package, but i should have done more research on the file name. I did find a backup from March that will cause me to lose a fair bit of work, but it may be a better alternative than troubleshooting all of the issues I may have. I guess now that you say it, i'm surprised that it would run from the extension manager and install Joomla over my existing instance. It even updated the version in cPanel!

[GJC Web Design]

amazed it ran and didn't throw up errors

yes - think your far better off with the old backup and try and save the latest DB tables