I've upgraded a few sites to 1.11.4 now, and have noticed a common problem. When I try to access system maintenance in the admin, the page will not load. I usually get a time-out or a server error that says:
HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while the server was attempting to fulfill the request.
This is the error generated in my php error log:
PHP Fatal error: Call to a member function FetchRow() on a non-object in /path/to/site/admin/systemmaintenance.php on line 246
This is the snippet of code starting at line 246:
while ($contentpiece = $allcontent->FetchRow()) {
$pages[] = $contentpiece["content_name"];
if (trim($contentpiece["content_alias"]) == "" && $contentpiece['type'] != 'separator') {
$withoutalias[] = $contentpiece;
}
if (!in_array($contentpiece["type"], $simpletypes)) {
$invalidtypes[] = $contentpiece;
}
//print_r($contentpiece);
}
"System Maintenence" not loading after upgrade to 1.11.4
-
- Support Guru
- Posts: 8169
- Joined: Tue Oct 19, 2004 6:44 pm
- Location: Fernie British Columbia, Canada
Re: "System Maintenence" not loading after upgrade to 1.11.4
if that expression fails you have more serious problems.... like 'no content pages', or a serious database integrity problem.
if you have no content pages, create at least one.
if you have one or more content pages, do a database repair, or a restore from backup.
if you have no content pages, create at least one.
if you have one or more content pages, do a database repair, or a restore from backup.
Follow me on twitter
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
Re: "System Maintenence" not loading after upgrade to 1.11.4
Thanks for the tips, but I am still struggling. This has happened with several sites now that i have gone back and double checked. New sites are fine, but various sites I have upgraded won't load the system maint tab.
It is definitely not 'no content' pages. There are plenty of those.
I got hollered at by my webhost for running a check table query on all tables. Apparently they don't like that because it bogs down the server resources. When I try to access the tab on various sites, I often just get a connection timeout. That makes me wonder if this CHECK query is taking too long. I do not know what would have happened to make each database messed up during the upgrades. I followed the standard procedures each time.
I found this block of code in the system main file and commented it out. The tab loads now, but something does seem wrong on the database, b/c one time I got the tab to load on a fluke try, and it told me there were 196 Structural errors detected in tables: (list of a bunch tables here)
/*
$query = "CHECK TABLE " . MakeCommaList($tables);
//echo $query;
$checkarray = $db->GetArray($query);
//print_r($checkarray);
$errortables = array();
foreach ($checkarray as $check) {
if (isset($check["Msg_text"]) && $check["Msg_text"] != "OK") {
$errortables[] = $check["Table"];
}
}
$smarty->assign("errorcount", count($errortables));
if (count($errortables) > 0) {
$smarty->assign("errortables", implode(",", $errortables));
}
*/
It is definitely not 'no content' pages. There are plenty of those.
I got hollered at by my webhost for running a check table query on all tables. Apparently they don't like that because it bogs down the server resources. When I try to access the tab on various sites, I often just get a connection timeout. That makes me wonder if this CHECK query is taking too long. I do not know what would have happened to make each database messed up during the upgrades. I followed the standard procedures each time.
I found this block of code in the system main file and commented it out. The tab loads now, but something does seem wrong on the database, b/c one time I got the tab to load on a fluke try, and it told me there were 196 Structural errors detected in tables: (list of a bunch tables here)
/*
$query = "CHECK TABLE " . MakeCommaList($tables);
//echo $query;
$checkarray = $db->GetArray($query);
//print_r($checkarray);
$errortables = array();
foreach ($checkarray as $check) {
if (isset($check["Msg_text"]) && $check["Msg_text"] != "OK") {
$errortables[] = $check["Table"];
}
}
$smarty->assign("errorcount", count($errortables));
if (count($errortables) > 0) {
$smarty->assign("errortables", implode(",", $errortables));
}
*/
Re: "System Maintenence" not loading after upgrade to 1.11.4
One other thing, I am trying to repair tables one by one in my DB admin, and some tables says I think that relates to InnoDB tables. "The storage engine for the table doesn't support repair"
The MyISAM tables seem fine for repairing.
The MyISAM tables seem fine for repairing.
Re: "System Maintenence" not loading after upgrade to 1.11.4
Last thing to add, when I open some of the tables the system said had structural errors (for instance, content_seq), a little error appears that says: "No index defined!"
Is this normal.
Is this normal.
-
- Forum Members
- Posts: 11
- Joined: Sun Jan 06, 2013 6:28 pm
Re: "System Maintenence" not loading after upgrade to 1.11.4
It is normal. Some tables do not have an index.jomoweb wrote:A little error appears that says: "No index defined!"
Is this normal.