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

mia5793’s picture

Oh 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);
}
}

mia5793’s picture

hass’s picture

1. 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?

hass’s picture

Please also provide the CREATE statement of your current sections_data table.

hass’s picture

Priority: Critical » Normal
Status: Active » Postponed (maintainer needs more info)
hass’s picture

Status: Postponed (maintainer needs more info) » Fixed

No feedback, issue seems to be solved.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.