Hey I would really appreciate any help on this,
I added the Sections module & started getting this on all admin pages:
user warning: Unknown column 'theme' in 'field list' query: SELECT sid, name, path, status, visibility, theme, weight FROM sections_data WHERE status = 1 ORDER BY weight in /web/bie-enviro-beta/drupal-5.7/includes/database.mysql.inc on line 172.
And when I enter info to create a new section, I click submit but nothing happens. Just goes back to initial "sections" admin page w/the same 2 default sections that were there before. Please help me fix this!
~Mia
Comments
Comment #1
mia5793 commentedOh and here's the database.myspl file for that area
/**
* Fetch one result row from the previous query as an object.
*
* @param $result
* A database query result resource, as returned from db_query().
* @return
* An object representing the next row of the result. The attributes of this
* object are the table fields selected by the query.
*/
function db_fetch_object($result) {
if ($result) {
return mysqli_fetch_object($result);
}
}
/**
* Fetch one result row from the previous query as an array. <-- line 172 here
*
* @param $result
* A database query result resource, as returned from db_query().
* @return
* An associative array representing the next row of the result. The keys of
* this object are the names of the table fields selected by the query, and
* the values are the field values for this result row.
*/
function db_fetch_array($result) {
if ($result) {
return mysqli_fetch_array($result, MYSQLI_ASSOC);
}
}
/**
* Determine how many result rows were found by the preceding query.
*
* @param $result
* A database query result resource, as returned from db_query().
* @return
* The number of result rows.
*/
function db_num_rows($result) {
if ($result) {
return mysqli_num_rows($result);
}
}
Comment #2
mia5793 commentedComment #3
hass commented1. Are you using the DEV version or the latest official release?
2. Have you upgraded or installed from scratch? If true - what version?
3. If you have upgraded - have you executed the update.php?
Comment #4
hass commentedPlease also provide the CREATE statement of your current sections_data table.
Comment #5
hass commentedComment #6
hass commentedNo feedback, issue seems to be solved.