Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By tpete1k on
I am trying to update one module: fileshare module. I uploaded the new files to the fileshare folder and ran update.php to update the database and reseulted in a huge list of errors below. I have no idea what to do. Any help?
* user warning: Table 'geo_search_total' already exists query: CREATE TABLE geo_search_total ( word varchar(50) NOT NULL default '', count int(10) unsigned default NULL, PRIMARY KEY word (word) ) in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Can't DROP 'path'; check that column/key exists query: ALTER TABLE geo_blocks DROP path in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'visibility' query: ALTER TABLE geo_blocks ADD visibility tinyint(1) NOT NULL in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'pages' query: ALTER TABLE geo_blocks ADD pages text NOT NULL in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Multiple primary key defined query: ALTER TABLE sessions ADD PRIMARY KEY sid (sid) in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Table 'geo_flood' already exists query: CREATE TABLE geo_flood ( event varchar(64) NOT NULL default '', hostname varchar(128) NOT NULL default '', timestamp int(11) NOT NULL default '0' ); in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'aid' query: ALTER TABLE geo_accesslog ADD aid int(10) NOT NULL auto_increment, ADD PRIMARY KEY (aid) in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Unknown column 'votes' in 'field list' query: SELECT nid, votes, score, users FROM node in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Can't DROP 'votes'; check that column/key exists query: ALTER TABLE node DROP votes in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Can't DROP 'score'; check that column/key exists query: ALTER TABLE node DROP score in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Can't DROP 'users'; check that column/key exists query: ALTER TABLE node DROP users in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Table 'geo_vocabulary_node_types' already exists query: CREATE TABLE geo_vocabulary_node_types ( vid int(10) NOT NULL default '0', type varchar(16) NOT NULL default '', PRIMARY KEY (vid, type)) in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Unknown column 'nodes' in 'field list' query: SELECT vid, nodes FROM geo_vocabulary in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Can't DROP 'nodes'; check that column/key exists query: ALTER TABLE geo_vocabulary DROP nodes in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Unknown table 'geo_page' query: DROP TABLE geo_page in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'module' query: ALTER TABLE geo_vocabulary ADD module varchar(255) NOT NULL default '' in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Unknown column 'voters' in 'geo_poll' query: ALTER TABLE geo_poll CHANGE voters polled longtext in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Multiple primary key defined query: ALTER TABLE term_node ADD PRIMARY KEY (tid,nid) in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'tags' query: ALTER TABLE geo_vocabulary ADD tags tinyint(3) unsigned default '0' NOT NULL in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Can't DROP 'title'; check that column/key exists query: ALTER TABLE geo_boxes DROP INDEX title in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Table 'geo_contact' already exists query: CREATE TABLE geo_contact ( subject varchar(255) NOT NULL default '', recipients longtext NOT NULL default '', reply longtext NOT NULL default '' ) in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'login' query: ALTER TABLE users ADD login int(11) NOT NULL default '0' in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Unknown column 'changed' in 'users' query: ALTER TABLE users CHANGE COLUMN changed access int(11) NOT NULL default '0' in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'timer' query: ALTER TABLE geo_accesslog ADD timer int(10) unsigned NOT NULL default '0' in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Unknown column 'subject' in 'geo_contact' query: ALTER TABLE geo_contact CHANGE subject category VARCHAR(255) NOT NULL in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Multiple primary key defined query: ALTER TABLE geo_contact ADD PRIMARY KEY (category) in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'theme' query: ALTER TABLE geo_blocks ADD theme varchar(255) NOT NULL default '' in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Unknown column 'body' in 'field list' query: CREATE TABLE node_revisions SELECT nid, nid AS vid, uid, type, title, body, teaser, changed AS timestamp, format FROM node in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'log' query: ALTER TABLE node_revisions ADD log longtext in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'vid' query: ALTER TABLE node ADD vid int(10) unsigned NOT NULL default '0' in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'vid' query: ALTER TABLE geo_book ADD vid int(10) unsigned NOT NULL default '0' in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'vid' query: ALTER TABLE forum ADD vid int(10) unsigned NOT NULL default '0' in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Multiple primary key defined query: ALTER TABLE node_revisions ADD PRIMARY KEY vid (vid) in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate key name 'nid' query: ALTER TABLE node_revisions ADD KEY nid (nid) in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate key name 'uid' query: ALTER TABLE node_revisions ADD KEY uid (uid) in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Unknown column 'revisions' in 'field list' query: CREATE TABLE geo_old_revisions SELECT nid, type, revisions FROM node WHERE revisions != '' in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate key name 'nid' query: ALTER TABLE geo_book ADD KEY nid (nid) in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate key name 'nid' query: ALTER TABLE forum ADD KEY nid (nid) in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate entry 'node_revisions_vid' for key 1 query: INSERT INTO sequences (name, id) VALUES ('node_revisions_vid', 12) in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Unknown column 'log' in 'field list' query: SELECT nid, log FROM geo_book WHERE log != '' in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Can't DROP 'log'; check that column/key exists query: ALTER TABLE geo_book DROP log in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Can't DROP 'teaser'; check that column/key exists query: ALTER TABLE node DROP teaser in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Can't DROP 'body'; check that column/key exists query: ALTER TABLE node DROP body in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Can't DROP 'format'; check that column/key exists query: ALTER TABLE node DROP format in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Can't DROP 'revisions'; check that column/key exists query: ALTER TABLE node DROP revisions in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Can't DROP 'type'; check that column/key exists query: ALTER TABLE node_revisions DROP type in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'sid' query: ALTER TABLE geo_accesslog ADD sid varchar(32) NOT NULL default '' in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Table 'geo_search_dataset' already exists query: CREATE TABLE geo_search_dataset ( sid int(10) unsigned NOT NULL default '0', type varchar(16) default NULL, data longtext NOT NULL, KEY sid_type (sid, type) ) in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Incorrect table definition; there can be only one auto column and it must be defined as a key query: ALTER TABLE geo_contact DROP PRIMARY KEY in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'cid' query: ALTER TABLE geo_contact ADD COLUMN cid int(11) NOT NULL PRIMARY KEY auto_increment in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate key name 'category' query: ALTER TABLE geo_contact ADD UNIQUE KEY category (category) in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'weight' query: ALTER TABLE geo_contact ADD COLUMN weight tinyint(3) NOT NULL DEFAULT 0 in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'selected' query: ALTER TABLE geo_contact ADD COLUMN selected tinyint(1) NOT NULL DEFAULT 0 in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Table 'tg.geo_old_revisions' doesn't exist query: ALTER TABLE geo_old_revisions ADD done tinyint(1) NOT NULL DEFAULT 0 in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Table 'tg.geo_old_revisions' doesn't exist query: ALTER TABLE geo_old_revisions ADD INDEX (done) in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Table 'tg.geo_old_revisions' doesn't exist query: SELECT * FROM geo_old_revisions WHERE done = 0 AND type IN ('page', 'story', 'poll', 'book', 'forum', 'blog') ORDER BY nid DESC LIMIT 0, 20 in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Table 'tg.geo_old_revisions' doesn't exist query: ALTER TABLE geo_old_revisions DROP done in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Table 'geo_poll_votes' already exists query: CREATE TABLE geo_poll_votes ( nid int(10) unsigned NOT NULL, uid int(10) unsigned NOT NULL default 0, hostname varchar(128) NOT NULL default '', INDEX (nid), INDEX (uid), INDEX (hostname) ) in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Unknown column 'polled' in 'field list' query: SELECT nid, polled FROM geo_poll in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Can't DROP 'polled'; check that column/key exists query: ALTER TABLE geo_poll DROP polled in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Unknown table 'geo_directory' query: DROP TABLE geo_directory in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Table 'geo_client' already exists query: CREATE TABLE geo_client ( cid int(10) unsigned NOT NULL auto_increment, link varchar(255) NOT NULL default '', name varchar(128) NOT NULL default '', mail varchar(128) NOT NULL default '', slogan longtext NOT NULL, mission longtext NOT NULL, users int(10) NOT NULL default '0', nodes int(10) NOT NULL default '0', version varchar(35) NOT NULL default'', created int(11) NOT NULL default '0', changed int(11) NOT NULL default '0', PRIMARY KEY (cid) ) in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Table 'geo_client_system' already exists query: CREATE TABLE geo_client_system ( cid int(10) NOT NULL default '0', name varchar(255) NOT NULL default '', type varchar(255) NOT NULL default '', PRIMARY KEY (cid,name) ) in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Multiple primary key defined query: ALTER TABLE term_hierarchy ADD PRIMARY KEY (tid, parent) in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Table 'geo_file_revisions' already exists query: CREATE TABLE geo_file_revisions ( fid int(10) unsigned NOT NULL default 0, vid int(10) unsigned NOT NULL default 0, description varchar(255) NOT NULL default '', list tinyint(1) unsigned NOT NULL default 0, PRIMARY KEY (fid, vid) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Unknown column 'list' in 'field list' query: INSERT INTO geo_file_revisions SELECT DISTINCT fid , vid, description, list FROM geo_files_tmp in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
* user warning: Duplicate column name 'autocomplete' query: ALTER TABLE profile_fields ADD autocomplete TINYINT(1) NOT NULL AFTER visibility ; in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
Comments
they are warinings. before
they are warinings.
before you phsycially ran update.php did you make sure that a db change was even made ? if no database changes were made, and the module you are updating says "no updates" then there is no need to run update.php.
the only one that looks like a problem is
user warning: Unknown column 'list' in 'field list' query: INSERT INTO geo_file_revisions SELECT DISTINCT fid , vid, description, list FROM geo_files_tmp in /home/.nicolodeon/gtgftp/tld1.com/includes/database.mysql.inc on line 121.
which is letting you know that one of your modules isnt install directly. georss maybe ?