Drupalites,
I have finally managed to upgrade from 4.3.2 to 4.4.0. I was also receiving the default theme error, which I have overcome thanks to Marvin error in upgrade from 4.3 to 4.4 which detailed the method to correct that issue.
I notice now when I try and administer filters, the following messages appear:
user error: Table 'banshee_drpl1.filters' doesn't exist
query: SELECT * FROM filters ORDER BY weight ASC in /home/banshee/public_html/includes/database.mysql.inc on line 97.user error: Table 'banshee_drpl1.filters' doesn't exist
query: DELETE FROM filters in /home/banshee/public_html/includes/database.mysql.inc on line 97.user error: Table 'banshee_drpl1.filters' doesn't exist
query: INSERT INTO filters (module, weight) VALUES ('filter', 0) in /home/banshee/public_html/includes/database.mysql.inc on line 97.user error: Table 'banshee_drpl1.filters' doesn't exist
query: SELECT * FROM filters ORDER BY weight ASC in /home/banshee/public_html/includes/database.mysql.inc on line 97.
Does anyone have any advice as to how I can remedy these messages? Is there some SQL I can cut and paste into PhpMyAdmin to fix this fairly easily? I know nothing about MySQL or Drupal really for that matter, so please be kind!
Comments
Run these commands: CREATE
Run these commands:
CREATE TABLE filters (
module varchar(64) NOT NULL default '',
weight tinyint(2) DEFAULT '0' NOT NULL,
KEY weight (weight)
) TYPE=MyISAM;
If other tables are missing, you can have a look at database.mysql file into drupal/database directory.
CIAO
Matteo
mailto:webmaster@cantincoro.org
Thank you Matteo
Matteo,
Thank you for your advice. It worked like a charm. It is the speedy reply from experienced Drupal users such as yourself, that make Drupal the premier CMS [IMHO] out there.
Ciao for now!
Um?
Did you run update.php? That table should be created when you run the update.
Not on update.php for 4.4
It is not on update.php for 4.4, but it is on database.mysql, on 4.4 distribution. I think it is an error...
Matteo
mailto:webmaster@cantincoro.org
function update_78()
At least in my 4.4 it's there: database/updates.inc.
Update.php did not create the missing table.
Yes Steven, I did run update.php. The table was not created as part of that operation.