site crash Upgrading to Joomla 3.3.1 and VirtueMart 2.9.8 - Joomla! Forum - community, help and support
hello everyone,
i did bevy of stupid things tonight, here's full rundown:
tonight, planned install virtuemart 2.9.8 on live site. didn't take full backup first, assuming incremental backups working(they weren't; test backups). first, applied update joomla go joomla 3.2.4 joomla 3.3.1. did testing , working fine. proceeded download virtuemart2.9.8_joomla_2.5.22-stable-full_package.zip test site , went extension manager , uploaded , installed zip. once did this, site , end inaccessible.
the main page , 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 a.created else a.modified end modified, a.modified_by, uam.name modified_by_name,case when a.publish_up = 0 a.created else a.publish_up end 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) readmore,case when badcats.id not null 0 else a.state end state,c.title category_title, c.path category_route, c.access category_access, c.alias category_alias,case when a.created_by_alias > ' ' a.created_by_alias else ua.name end author,ua.email author_email,( select max(contact.id) id jos_contact_details contact contact.published = 1 , contact.user_id = a.created_by) contactid,parent.title parent_title, parent.id parent_id, parent.path parent_route, parent.alias parent_alias,round(v.rating_sum / v.rating_count, 0) rating, v.rating_count rating_count,c.published, case when badcats.id null c.published else 0 end parents_published jos_content left join jos_content_frontpage fp on fp.content_id = a.id left join jos_categories c on c.id = a.catid left join jos_users ua on ua.id = a.created_by left join jos_users uam on uam.id = a.modified_by left join jos_categories parent on parent.id = c.parent_id left join jos_content_rating v on a.id = v.content_id left outer join (select cat.id id jos_categories cat join jos_categories parent on cat.lft between parent.lft , parent.rgt parent.extension = 'com_content' , parent.published != 1 group cat.id ) badcats on badcats.id = c.id a.access in (1,1) , c.access in (1,1) , case when badcats.id null a.state else 0 end = 1 , a.catid = 19 , (a.publish_up = '0000-00-00 00:00:00' or a.publish_up <= '2014-07-08 02:54:33') , (a.publish_down = '0000-00-00 00:00:00' or a.publish_down >= '2014-07-08 02:54:33') order c.lft, case when a.publish_up = 0 a.created else a.publish_up end desc , a.created limit 0, 9
the end shows:
fatal error: call undefined method jhtml::getjsobject() in /home/wslsorg/public_html/libraries/cms/html/bootstrap.php on line 476
line 476 of bootstrap.ini says "$options = jhtml::getjsobject($opt);" , bootstrap.ini wasn't edited upgrade, figure it's pointing elsewhere, i'm not sure where.
i not sure go here. hoping here have suggestions on things try, can site soon. appreciate may have. please let me know of more information may need.
i did bevy of stupid things tonight, here's full rundown:
tonight, planned install virtuemart 2.9.8 on live site. didn't take full backup first, assuming incremental backups working(they weren't; test backups). first, applied update joomla go joomla 3.2.4 joomla 3.3.1. did testing , working fine. proceeded download virtuemart2.9.8_joomla_2.5.22-stable-full_package.zip test site , went extension manager , uploaded , installed zip. once did this, site , end inaccessible.
the main page , 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 a.created else a.modified end modified, a.modified_by, uam.name modified_by_name,case when a.publish_up = 0 a.created else a.publish_up end 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) readmore,case when badcats.id not null 0 else a.state end state,c.title category_title, c.path category_route, c.access category_access, c.alias category_alias,case when a.created_by_alias > ' ' a.created_by_alias else ua.name end author,ua.email author_email,( select max(contact.id) id jos_contact_details contact contact.published = 1 , contact.user_id = a.created_by) contactid,parent.title parent_title, parent.id parent_id, parent.path parent_route, parent.alias parent_alias,round(v.rating_sum / v.rating_count, 0) rating, v.rating_count rating_count,c.published, case when badcats.id null c.published else 0 end parents_published jos_content left join jos_content_frontpage fp on fp.content_id = a.id left join jos_categories c on c.id = a.catid left join jos_users ua on ua.id = a.created_by left join jos_users uam on uam.id = a.modified_by left join jos_categories parent on parent.id = c.parent_id left join jos_content_rating v on a.id = v.content_id left outer join (select cat.id id jos_categories cat join jos_categories parent on cat.lft between parent.lft , parent.rgt parent.extension = 'com_content' , parent.published != 1 group cat.id ) badcats on badcats.id = c.id a.access in (1,1) , c.access in (1,1) , case when badcats.id null a.state else 0 end = 1 , a.catid = 19 , (a.publish_up = '0000-00-00 00:00:00' or a.publish_up <= '2014-07-08 02:54:33') , (a.publish_down = '0000-00-00 00:00:00' or a.publish_down >= '2014-07-08 02:54:33') order c.lft, case when a.publish_up = 0 a.created else a.publish_up end desc , a.created limit 0, 9
the end shows:
fatal error: call undefined method jhtml::getjsobject() in /home/wslsorg/public_html/libraries/cms/html/bootstrap.php on line 476
line 476 of bootstrap.ini says "$options = jhtml::getjsobject($opt);" , bootstrap.ini wasn't edited upgrade, figure it's pointing elsewhere, i'm not sure where.
i not sure go here. hoping here have suggestions on things try, can site soon. appreciate may have. please let me know of more information may need.
please check post: http://docs.joomla.org/how_to_restore_a ... omla_3.x.x should tell how revert old joomla 2.5.22.
Comments
Post a Comment