Author Topic: Home page errors  (Read 717 times)

Offline 214thCavalier

  • Silver Member
  • ****
  • Posts: 1929
Home page errors
« on: September 05, 2016, 12:55:28 PM »
As below the home page central window is displaying an error.

Error
Incorrect key file for table '/var/tmp/#sql2f6_143c000_3.MYI'; try to repair it SQL=SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' 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, a.language, 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,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 wd1sv_content AS a LEFT JOIN wd1sv_categories AS c ON c.id = a.catid LEFT JOIN wd1sv_users AS ua ON ua.id = a.created_by LEFT JOIN wd1sv_users AS uam ON uam.id = a.modified_by LEFT JOIN wd1sv_categories as parent ON parent.id = c.parent_id LEFT JOIN wd1sv_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM wd1sv_categories AS cat JOIN wd1sv_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 INNER JOIN wd1sv_content_frontpage AS fp ON fp.content_id = a.id WHERE CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2016-09-05 18:04:46') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-09-05 18:04:46') ORDER BY c.lft, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC LIMIT 0, 9

Offline BowHTR

  • Gold Member
  • *****
  • Posts: 2074
Re: Home page errors
« Reply #1 on: September 05, 2016, 01:29:38 PM »
Im getting it as well.

AH Supporter Since Tour 35

Offline Bizman

  • Plutonium Member
  • *******
  • Posts: 9690
Re: Home page errors
« Reply #2 on: September 05, 2016, 01:39:42 PM »
Just out of curiosity I went and checked the front page and lo and behold, the same. I'd say it's not at our end.

Offline Sloehand

  • Silver Member
  • ****
  • Posts: 874
Re: Home page errors
« Reply #3 on: September 05, 2016, 02:12:12 PM »
I just got it too.   

Also, it seems everyday that I try to log into AHIII, it tells me I'm out-of-date and I have to go through the 15 minute download and re-install.  Has happened last two days and today.  Looks like the same update each time.  What's up?
Jagdgeschwader 77

"You sleep safe in your beds because rough men stand ready in the night to visit violence on those who would do you harm."  - George Orwell
"Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety." - Benjamin Franklin

Offline BowHTR

  • Gold Member
  • *****
  • Posts: 2074
Re: Home page errors
« Reply #4 on: September 05, 2016, 02:21:48 PM »
I just got it too.   

Also, it seems everyday that I try to log into AHIII, it tells me I'm out-of-date and I have to go through the 15 minute download and re-install.  Has happened last two days and today.  Looks like the same update each time.  What's up?

Sounds like your using the AH Beta Icon and not the AHIII icon. Do a full version install from here: http://bbs.hitechcreations.com/smf/index.php/topic,380904.0.html
AH Supporter Since Tour 35

Offline The Fugitive

  • Plutonium Member
  • *******
  • Posts: 18230
      • Fugi's Aces Help
Re: Home page errors
« Reply #5 on: September 05, 2016, 02:26:39 PM »
Skuzzy goes on vacation and Hitech starts breaking stuff. First the ranks page and now the Home page  :neener:

Offline JimmyC

  • Platinum Member
  • ******
  • Posts: 5196
Re: Home page errors
« Reply #6 on: September 05, 2016, 03:30:04 PM »
Skuzzy Waits till the most crucial time to go on vacation   :headscratch:
when will he be back?
2 weeks?!
CO 71 "Eagle" Squadron RAF
"I'd rather have a bottle in front of me than a frontal lobotomy."