[drupal-devel] Release critical bugs for March 16, 2005
Bbcode / bug reports email spam filtering does not "see" email addresses when they are NOT preceded by a word age: 8 weeks 4 days url: http://drupal.org/node/15654 Buddylist / bug reports SQL errors using HEAD from CVS age: 2 weeks 1 day url: http://drupal.org/node/18160 Chatbox / support requests Cron run kills Chat? age: 14 weeks 1 day url: http://drupal.org/node/14032 Drupal / bug reports Bypass access via comments age: 1 hour 36 min url: http://drupal.org/node/19009 New submit error, non-admin user, postgresql database age: 1 week 1 day url: http://drupal.org/node/18552 Module-specific taxonomony support breaks existing sites assigned: walkah age: 1 week 3 days url: http://drupal.org/node/18471 PHP 4.3.11 and upload in IE age: 3 weeks 4 days url: http://drupal.org/node/17595 When I delete a user, any forum in which s/he has commented also disappears. assigned: Jill6q age: 4 weeks 3 hours url: http://drupal.org/node/17428 Path module allows one to override existing (non-aliased) paths. age: 4 weeks 1 day url: http://drupal.org/node/17386 problems with admin/user/configure/permission and 4.5.2 age: 4 weeks 3 days url: http://drupal.org/node/17282 Published poll doesnt show up in poll block if in submission queue age: 5 weeks 6 days url: http://drupal.org/node/16671 Adding two custom blocks with the same name produces a sql warning age: 5 weeks 6 days url: http://drupal.org/node/16659 Cache-Control header not set age: 6 weeks 6 days url: http://drupal.org/node/16295 updates.inc deleting profile_data when updating age: 8 weeks 3 days url: http://drupal.org/node/15686 Change to sesssion.inc violates UID database constraint age: 8 weeks 3 days url: http://drupal.org/node/15666 problem with forum.module with postgresql v7.4.1 age: 9 weeks 2 days url: http://drupal.org/node/15412 forum.module problem with postgresql v7.4.1 age: 9 weeks 2 days url: http://drupal.org/node/15411 PHP 5 gives error when session table has no session assigned: adschar age: 9 weeks 2 days url: http://drupal.org/node/15399 postgresql error age: 9 weeks 6 days url: http://drupal.org/node/15175 Entering an empty title broke drupal age: 17 weeks 2 days url: http://drupal.org/node/12974 Argument NOT must be type boolean age: 17 weeks 2 days url: http://drupal.org/node/12950 Private downloads aren't working age: 19 weeks 5 days url: http://drupal.org/node/12267 Comments in approval queue still show up in tracker age: 21 weeks 4 days url: http://drupal.org/node/11647 Drupal / feature requests Request New Password Security age: 5 days 18 hours url: http://drupal.org/node/18719 Taxonomy module should use nodeapi 'load' age: 1 week 3 hours url: http://drupal.org/node/18631 Auto PHP memory maximisation age: 3 weeks 2 days url: http://drupal.org/node/17663 Don't reset existing password on request, prevent DoS password reset abuse age: 5 weeks 2 days url: http://drupal.org/node/16909 User info exposed to anonymous user age: 15 weeks 4 days url: http://drupal.org/node/13545 Allow named anchors to work without specifying full path to node age: 1 year 16 weeks url: http://drupal.org/node/4213 Drupal / support requests Fatal error: Unknown column 'headers' in 'field list' query assigned: Eagle-i age: 1 day 5 hours url: http://drupal.org/node/18928 Strange session behavior age: 3 days 16 hours url: http://drupal.org/node/18821 user redirected to homepage when logging in age: 1 week 5 days url: http://drupal.org/node/18381 Problem with Forums age: 9 weeks 4 days url: http://drupal.org/node/15299 Drupal / tasks atom.module working version to 4.5.0 assigned: hugoromano age: 19 weeks 6 hours url: http://drupal.org/node/12496 Consistency assigned: stefan nagtegaal age: 24 weeks 5 days url: http://drupal.org/node/11045 Postgres Compatibility Update assigned: adrian age: 25 weeks 2 days url: http://drupal.org/node/10945 Drupal.org maintenance / bug reports drupaldocs.org and large fonts age: 1 week 5 days url: http://drupal.org/node/18367 Drupal.org print preview crashes Mozilla age: 2 weeks 8 hours url: http://drupal.org/node/18248 Konqueror problem age: 5 weeks 2 days url: http://drupal.org/node/16913 screenshots : page not found age: 5 weeks 5 days url: http://drupal.org/node/16752 Large Fonts problems age: 5 weeks 6 days url: http://drupal.org/node/16664 Drupal.org maintenance / feature requests Plain text posting age: 4 weeks 2 days url: http://drupal.org/node/17335 Event / bug reports Events for March 31, 2005 not showing up in calendar view age: 2 days 1 hour url: http://drupal.org/node/18885 Doesn't work with i18n hack/module age: 2 weeks 1 day url: http://drupal.org/node/18145 search over fields.inc fields conceptual error age: 19 weeks 5 days url: http://drupal.org/node/12259 fields.inc screws up with multible multiselect fields age: 19 weeks 5 days url: http://drupal.org/node/12257 Still GMT/TZ issues with CVS age: 20 weeks 6 days url: http://drupal.org/node/11870 Time entry is GMT even when site default is not age: 21 weeks 4 days url: http://drupal.org/node/11630 Start Time of Event is NOT Preserved age: 38 weeks 6 days url: http://drupal.org/node/8565 Feature / bug reports Menu item not showing age: 23 weeks 5 days url: http://drupal.org/node/11210 File / bug reports segmentation fault related to filestore age: 1 year 24 weeks url: http://drupal.org/node/3001 Filebrowser / bug reports em.. out of root? age: 1 week 16 hours url: http://drupal.org/node/18596 Filestore / support requests File store module - Overwriting Filename....Help needed assigned: harishkm age: 50 weeks 11 hours url: http://drupal.org/node/6827 Unserialize error at line 104 age: 1 year 4 weeks url: http://drupal.org/node/5857 Filestore module- sql errors rectified assigned: harishkm age: 1 year 5 weeks url: http://drupal.org/node/5619 Filestore Module Problems unaddressed assigned: harishkm age: 1 year 7 weeks url: http://drupal.org/node/5365 Gallery / bug reports Mini applet can't find gallery at url / age: 4 days 5 hours url: http://drupal.org/node/18785 "Cannot modify header information" age: 1 week 3 days url: http://drupal.org/node/18457 Fatal error: Undefined class name 'galleryembed' age: 3 weeks 1 day url: http://drupal.org/node/17746 Gallery / support requests Can't Embed Gallery into Drupal age: 2 weeks 3 days url: http://drupal.org/node/18029 Goofy / bug reports Blocks with no name age: 5 weeks 3 days url: http://drupal.org/node/16860 Groups / bug reports Drupal-4.4-rc breaks registration setups and groups.module age: 1 year 4 days url: http://drupal.org/node/6392 Image / bug reports Cannot upload .jpgs age: 2 weeks 2 days url: http://drupal.org/node/18076 Wrongly formed html in image gallery age: 3 weeks 6 days url: http://drupal.org/node/17462 Image.Module does not know the correct filename age: 17 weeks 1 day url: http://drupal.org/node/13032 SAFE MODE Restriction in effect... age: 20 weeks 6 days url: http://drupal.org/node/11843 Uploading jpeg makes Imagemagick do high compression age: 22 weeks 3 days url: http://drupal.org/node/11445 Image module failing on Preview because of a blank node id age: 24 weeks 4 days url: http://drupal.org/node/11069 Similar problem with Directory Upload Slow age: 24 weeks 4 days url: http://drupal.org/node/11064 Node Aggregator / bug reports Import doesn't like XML/RSS feeds with no Title element age: 41 weeks 4 days url: http://drupal.org/node/8128 Node Aggregator / feature requests RSS items overwriting edited items age: 39 weeks 5 days url: http://drupal.org/node/8455 Notify / feature requests Notify.module ignores the true submission queue age: 1 year 20 weeks url: http://drupal.org/node/3765 Online / support requests Need Help age: 3 weeks 6 days url: http://drupal.org/node/17475 Pdfview / feature requests Internationalization support for PDF assigned: TheLibrarian age: 50 weeks 1 day url: http://drupal.org/node/6795 Project / bug reports Invalid link to release files age: 3 weeks 3 days url: http://drupal.org/node/17625 blank page after install age: 6 weeks 1 day url: http://drupal.org/node/16575 "Page Not Found" when trying to view issues or add new release age: 14 weeks 6 days url: http://drupal.org/node/13815 Project pages display only title and description age: 17 weeks 1 hour url: http://drupal.org/node/13082 Fatal error: Cannot use string offset as an array in includes/tablesort.inc on line 113 assigned: publian age: 23 weeks 6 days url: http://drupal.org/node/11187 Can't create new project with issue tracker age: 30 weeks 15 hours url: http://drupal.org/node/10148 Project / support requests Help with everything - nothing seems to work in the latest build age: 16 weeks 2 days url: http://drupal.org/node/13310 Taxonomy dhtml / bug reports javascrip downloads square.gif for every category age: 4 weeks 1 day url: http://drupal.org/node/17366 TrackBack / bug reports Sends trackbacks for unpublished nodes age: 7 weeks 2 hours url: http://drupal.org/node/16239 Overly aggressive age: 14 weeks 5 days url: http://drupal.org/node/13865 trackback borks google and every other search engine age: 19 weeks 2 days url: http://drupal.org/node/12388 User experience / bug reports user interface problem http://drupal.org/forum/1?from=25 age: 2 weeks 13 hours url: http://drupal.org/node/18237 User experience / tasks WorkFlow and Action Module age: 3 weeks 5 days url: http://drupal.org/node/17517 Weblink / bug reports node_access_join_sql() error assigned: pancho age: 1 week 20 min url: http://drupal.org/node/18646 Weblink / feature requests Display of child categories on the weblink directory default page age: 4 weeks 6 days url: http://drupal.org/node/17132 Display of child categories on the weblink directory default page age: 4 weeks 6 days url: http://drupal.org/node/17130
That makes for a _lot_ of critical bugs ... looks like we do need to organize a Bugfix Friday. ;) -- Dries Buytaert :: http://www.buytaert.net/
Op donderdag 17 maart 2005 07:26, schreef Dries Buytaert:
That makes for a _lot_ of critical bugs ... looks like we do need to organize a Bugfix Friday. ;)
Well, first a: bug-un-critical friday :) Far too many ppl mark issues as critical because *they* think they are, while for Drupal as whole they are not at all. Regards, Bèr -- [ Bèr Kessels | Drupal services www.webschuur.com ]
Well, first a: bug-un-critical friday :) Far too many ppl mark issues as critical because *they* think they are, while for Drupal as whole they are not at all.
While that might be true, do we have a set of guidelines for what constitutes a critical bug? When does something 'not work (tm)' in Drupal terms? /claus
I just spent two days trying to find out why database backups are not running. It would seem that naming database columns with a reserved word is the problem. Timestamp is used as a column name in about 15 instances. Phpmyadmin and mySQL adminstrator both take the reserved word literally and execute errors when trying to name a column with time when running the script. This is a basic database knowledge thing. Never should programming language, database or columntypes reserved words be used as column names. This use is present in 4.5.2 and 4.6 -- MySQL dump 8.22 -- -- Host: localhost Database: drupal_devel -- Server version 3.23.52-nt -- -- Table structure for table 'access' -- CREATE TABLE access ( aid tinyint(10) NOT NULL auto_increment, mask varchar(255) NOT NULL default '', type varchar(255) NOT NULL default '', status tinyint(2) NOT NULL default '0', PRIMARY KEY (aid) ) TYPE=MyISAM; -- -- Table structure for table 'accesslog' -- CREATE TABLE accesslog ( aid int(10) NOT NULL auto_increment, title varchar(255) default NULL, path varchar(255) default NULL, url varchar(255) default NULL, hostname varchar(128) default NULL, uid int(10) unsigned default '0', timestamp int(11) unsigned NOT NULL default '0', KEY accesslog_timestamp (timestamp), PRIMARY KEY (aid) ) TYPE=MyISAM; -- -- Table structure for table 'aggregator_category' -- CREATE TABLE aggregator_category ( cid int(10) NOT NULL auto_increment, title varchar(255) NOT NULL default '', description longtext NOT NULL, block tinyint(2) NOT NULL default '0', PRIMARY KEY (cid), UNIQUE KEY title (title) ) TYPE=MyISAM; -- -- Table structure for table 'aggregator_category_feed' -- CREATE TABLE aggregator_category_feed ( fid int(10) NOT NULL default '0', cid int(10) NOT NULL default '0', PRIMARY KEY (fid,cid) ) TYPE=MyISAM; -- -- Table structure for table 'aggregator_category_item' -- CREATE TABLE aggregator_category_item ( iid int(10) NOT NULL default '0', cid int(10) NOT NULL default '0', PRIMARY KEY (iid,cid) ) TYPE=MyISAM; -- -- Table structure for table 'aggregator_feed' -- CREATE TABLE aggregator_feed ( fid int(10) NOT NULL auto_increment, title varchar(255) NOT NULL default '', url varchar(255) NOT NULL default '', refresh int(10) NOT NULL default '0', checked int(10) NOT NULL default '0', link varchar(255) NOT NULL default '', description longtext NOT NULL, image longtext NOT NULL, etag varchar(255) NOT NULL default '', modified int(10) NOT NULL default '0', block tinyint(2) NOT NULL default '0', PRIMARY KEY (fid), UNIQUE KEY link (url), UNIQUE KEY title (title) ) TYPE=MyISAM; -- -- Table structure for table 'aggregator_item' -- CREATE TABLE aggregator_item ( iid int(10) NOT NULL auto_increment, fid int(10) NOT NULL default '0', title varchar(255) NOT NULL default '', link varchar(255) NOT NULL default '', author varchar(255) NOT NULL default '', description longtext NOT NULL, timestamp int(11) default NULL, PRIMARY KEY (iid) ) TYPE=MyISAM; -- -- Table structure for table 'authmap' -- CREATE TABLE authmap ( aid int(10) unsigned NOT NULL auto_increment, uid int(10) NOT NULL default '0', authname varchar(128) NOT NULL default '', module varchar(128) NOT NULL default '', PRIMARY KEY (aid), UNIQUE KEY authname (authname) ) TYPE=MyISAM; -- -- Table structure for table 'blocks' -- CREATE TABLE blocks ( module varchar(64) DEFAULT '' NOT NULL, delta varchar(32) NOT NULL default '0', status tinyint(2) DEFAULT '0' NOT NULL, weight tinyint(1) DEFAULT '0' NOT NULL, region tinyint(1) DEFAULT '0' NOT NULL, custom tinyint(2) DEFAULT '0' NOT NULL, throttle tinyint(1) DEFAULT '0' NOT NULL, visibility tinyint(1) DEFAULT '0' NOT NULL, pages text NOT NULL, types text NOT NULL ) TYPE=MyISAM; -- -- Table structure for table 'book' -- CREATE TABLE book ( nid int(10) unsigned NOT NULL default '0', parent int(10) NOT NULL default '0', weight tinyint(3) NOT NULL default '0', log longtext, PRIMARY KEY (nid), KEY parent (parent) ) TYPE=MyISAM; -- -- Table structure for table 'boxes' -- CREATE TABLE boxes ( bid tinyint(4) NOT NULL auto_increment, title varchar(64) NOT NULL default '', body longtext, info varchar(128) NOT NULL default '', format int(4) NOT NULL default '0', PRIMARY KEY (bid), UNIQUE KEY title (title), UNIQUE KEY info (info) ) TYPE=MyISAM; -- -- Table structure for table 'cache' -- CREATE TABLE cache ( cid varchar(255) NOT NULL default '', data longtext, expire int(11) NOT NULL default '0', created int(11) NOT NULL default '0', headers text, PRIMARY KEY (cid), INDEX expire (expire) ) TYPE=MyISAM; -- -- Table structure for table 'comments' -- CREATE TABLE comments ( cid int(10) NOT NULL auto_increment, pid int(10) NOT NULL default '0', nid int(10) NOT NULL default '0', uid int(10) NOT NULL default '0', subject varchar(64) NOT NULL default '', comment longtext NOT NULL, hostname varchar(128) NOT NULL default '', timestamp int(11) NOT NULL default '0', score mediumint(9) NOT NULL default '0', status tinyint(3) unsigned NOT NULL default '0', format int(4) NOT NULL default '0', thread varchar(255) NOT NULL, users longtext, name varchar(60) default NULL, mail varchar(64) default NULL, homepage varchar(255) default NULL, PRIMARY KEY (cid), KEY lid (nid) ) TYPE=MyISAM; -- -- Table structre for table 'node_last_comment' -- CREATE TABLE node_comment_statistics ( nid int(10) unsigned NOT NULL auto_increment, last_comment_timestamp int(11) NOT NULL default '0', last_comment_name varchar(60) default NULL, last_comment_uid int(10) NOT NULL default '0', comment_count int(10) unsigned NOT NULL default '0', PRIMARY KEY (nid), KEY node_comment_timestamp (last_comment_timestamp) ) TYPE=MyISAM; -- -- Table structure for table 'directory' -- CREATE TABLE directory ( 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, timestamp int(11) NOT NULL default '0', PRIMARY KEY (link) ) TYPE=MyISAM; -- -- Table structure for table 'files' -- CREATE TABLE files ( fid int(10) unsigned NOT NULL default '0', nid int(10) unsigned NOT NULL default '0', filename varchar(255) NOT NULL default '', filepath varchar(255) NOT NULL default '', filemime varchar(255) NOT NULL default '', filesize int(10) unsigned NOT NULL default '0', list tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (fid) ) TYPE=MyISAM; -- -- Table structure for table 'filter_formats' -- CREATE TABLE filter_formats ( format int(4) NOT NULL auto_increment, name varchar(255) NOT NULL default '', roles varchar(255) NOT NULL default '', cache tinyint(2) NOT NULL default '0', PRIMARY KEY format (format) ) TYPE=MyISAM; -- -- Table structure for table 'filters' -- CREATE TABLE filters ( format int(4) NOT NULL default '0', module varchar(64) NOT NULL default '', delta tinyint(2) DEFAULT '0' NOT NULL, weight tinyint(2) DEFAULT '0' NOT NULL, INDEX (weight) ) TYPE=MyISAM; -- -- Table structure for table 'flood' -- CREATE TABLE flood ( event varchar(64) NOT NULL default '', hostname varchar(128) NOT NULL default '', timestamp int(11) NOT NULL default '0' ) TYPE=MyISAM; -- -- Table structure for table 'forum' -- CREATE TABLE forum ( nid int(10) unsigned NOT NULL default '0', tid int(10) unsigned NOT NULL default '0', PRIMARY KEY (nid), KEY tid (tid) ) TYPE=MyISAM; -- -- Table structure for table 'history' -- CREATE TABLE history ( uid int(10) NOT NULL default '0', nid int(10) NOT NULL default '0', timestamp int(11) NOT NULL default '0', PRIMARY KEY (uid,nid) ) TYPE=MyISAM; -- -- Table structure for table 'locales_meta' -- CREATE TABLE locales_meta ( locale varchar(12) NOT NULL default '', name varchar(64) NOT NULL default '', enabled int(2) NOT NULL default '0', isdefault int(2) NOT NULL default '0', plurals int(1) NOT NULL default '0', formula varchar(128) NOT NULL default '', PRIMARY KEY (locale) ) TYPE=MyISAM; -- -- Table structure for table 'locales_source' -- CREATE TABLE locales_source ( lid int(11) NOT NULL auto_increment, location varchar(128) NOT NULL default '', source blob NOT NULL, PRIMARY KEY (lid) ) TYPE=MyISAM; -- -- Table structure for table 'locales_target' -- CREATE TABLE locales_target ( lid int(11) NOT NULL default '0', translation blob NOT NULL, locale varchar(12) NOT NULL default '', plid int(11) NOT NULL default '0', plural int(1) NOT NULL default '0', KEY lid (lid), KEY lang (locale), KEY plid (plid), KEY plural (plural) ) TYPE=MyISAM; -- -- Table structure for table 'menu' -- CREATE TABLE menu ( mid int(10) unsigned NOT NULL default '0', pid int(10) unsigned NOT NULL default '0', path varchar(255) NOT NULL default '', title varchar(255) NOT NULL default '', description varchar(255) NOT NULL default '', weight tinyint(4) NOT NULL default '0', type int(2) unsigned NOT NULL default '0', PRIMARY KEY (mid) ) TYPE=MyISAM; -- -- Table structure for table 'moderation_filters' -- CREATE TABLE moderation_filters ( fid int(10) unsigned NOT NULL auto_increment, filter varchar(255) NOT NULL default '', minimum smallint(6) NOT NULL default '0', PRIMARY KEY (fid) ) TYPE=MyISAM; -- -- Table structure for table 'moderation_roles' -- CREATE TABLE moderation_roles ( rid int(10) unsigned NOT NULL default '0', mid int(10) unsigned NOT NULL default '0', value tinyint(4) NOT NULL default '0', KEY idx_rid (rid), KEY idx_mid (mid) ) TYPE=MyISAM; -- -- Table structure for table 'moderation_votes' -- CREATE TABLE moderation_votes ( mid int(10) unsigned NOT NULL auto_increment, vote varchar(255) default NULL, weight tinyint(4) NOT NULL default '0', PRIMARY KEY (mid) ) TYPE=MyISAM; -- -- Table structure for table 'node' -- CREATE TABLE node ( nid int(10) unsigned NOT NULL auto_increment, type varchar(16) NOT NULL default '', title varchar(128) NOT NULL default '', uid int(10) NOT NULL default '0', status int(4) NOT NULL default '1', created int(11) NOT NULL default '0', changed int(11) NOT NULL default '0', comment int(2) NOT NULL default '0', promote int(2) NOT NULL default '0', moderate int(2) NOT NULL default '0', teaser longtext NOT NULL, body longtext NOT NULL, revisions longtext NOT NULL, sticky int(2) NOT NULL default '0', format int(4) NOT NULL default '0', PRIMARY KEY (nid), KEY node_type (type(4)), KEY node_title_type (title,type(4)), KEY status (status), KEY uid (uid), KEY node_moderate (moderate), KEY node_promote_status (promote, status), KEY node_created (created), KEY node_changed (changed), KEY node_status_type (status, type, nid) ) TYPE=MyISAM; -- -- Table structure for table `node_access` -- CREATE TABLE node_access ( nid int(10) unsigned NOT NULL default '0', gid int(10) unsigned NOT NULL default '0', realm varchar(255) NOT NULL default '', grant_view tinyint(1) unsigned NOT NULL default '0', grant_update tinyint(1) unsigned NOT NULL default '0', grant_delete tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (nid,gid,realm) ) TYPE=MyISAM; -- -- Table structure for table 'profile_fields' -- CREATE TABLE profile_fields ( fid int(10) NOT NULL auto_increment, title varchar(255) default NULL, name varchar(128) default NULL, explanation TEXT default NULL, category varchar(255) default NULL, page varchar(255) default NULL, type varchar(128) default NULL, weight tinyint(1) DEFAULT '0' NOT NULL, required tinyint(1) DEFAULT '0' NOT NULL, register tinyint(1) DEFAULT '0' NOT NULL, visibility tinyint(1) DEFAULT '0' NOT NULL, options text, KEY category (category), UNIQUE KEY name (name), PRIMARY KEY (fid) ); -- -- Table structure for table 'profile_values' -- CREATE TABLE profile_values ( fid int(11) unsigned default '0', uid int(11) unsigned default '0', value text, KEY uid (uid), KEY fid (fid) ); -- -- Table structure for table 'url_alias' -- CREATE TABLE url_alias ( pid int(10) unsigned NOT NULL auto_increment, src varchar(128) NOT NULL default '', dst varchar(128) NOT NULL default '', PRIMARY KEY (pid), UNIQUE KEY dst (dst) ) TYPE=MyISAM; -- -- Table structure for table 'permission' -- CREATE TABLE permission ( rid int(10) unsigned NOT NULL default '0', perm longtext, tid int(10) unsigned NOT NULL default '0', KEY rid (rid) ) TYPE=MyISAM; -- -- Table structure for table 'poll' -- CREATE TABLE poll ( nid int(10) unsigned NOT NULL default '0', runtime int(10) NOT NULL default '0', voters longtext NOT NULL, active int(2) unsigned NOT NULL default '0', PRIMARY KEY (nid) ) TYPE=MyISAM; -- -- Table structure for table 'poll_choices' Carl McDade
Carl, Just a quick thing: Could you please consider writing new mails instead of replying to old ones. your replies break the threads. Yesterday you did the same. Read more about mailinglist guidelines here: http://lists.drupal.org/listinfo/drupal-devel Bèr Op donderdag 17 maart 2005 10:51, schreef Carl McDade:
I just spent two days trying to find out why database backups are not running. It would seem that naming database columns with a reserved word is the problem. Timestamp is used as a column name in about 15 instances.
Phpmyadmin and mySQL adminstrator both take the reserved word literally and execute errors when trying to name a column with time when running the script.
This is a basic database knowledge thing. Never should programming language, database or columntypes reserved words be used as column names.
This use is present in 4.5.2 and 4.6
-- MySQL dump 8.22 -- -- Host: localhost Database: drupal_devel -- Server version 3.23.52-nt
-- -- Table structure for table 'access' --
CREATE TABLE access ( aid tinyint(10) NOT NULL auto_increment, mask varchar(255) NOT NULL default '', type varchar(255) NOT NULL default '', status tinyint(2) NOT NULL default '0', PRIMARY KEY (aid) ) TYPE=MyISAM;
-- -- Table structure for table 'accesslog' --
CREATE TABLE accesslog ( aid int(10) NOT NULL auto_increment, title varchar(255) default NULL, path varchar(255) default NULL, url varchar(255) default NULL, hostname varchar(128) default NULL, uid int(10) unsigned default '0', timestamp int(11) unsigned NOT NULL default '0', KEY accesslog_timestamp (timestamp), PRIMARY KEY (aid) ) TYPE=MyISAM;
-- -- Table structure for table 'aggregator_category' --
CREATE TABLE aggregator_category ( cid int(10) NOT NULL auto_increment, title varchar(255) NOT NULL default '', description longtext NOT NULL, block tinyint(2) NOT NULL default '0', PRIMARY KEY (cid), UNIQUE KEY title (title) ) TYPE=MyISAM;
-- -- Table structure for table 'aggregator_category_feed' --
CREATE TABLE aggregator_category_feed ( fid int(10) NOT NULL default '0', cid int(10) NOT NULL default '0', PRIMARY KEY (fid,cid) ) TYPE=MyISAM;
-- -- Table structure for table 'aggregator_category_item' --
CREATE TABLE aggregator_category_item ( iid int(10) NOT NULL default '0', cid int(10) NOT NULL default '0', PRIMARY KEY (iid,cid) ) TYPE=MyISAM;
-- -- Table structure for table 'aggregator_feed' --
CREATE TABLE aggregator_feed ( fid int(10) NOT NULL auto_increment, title varchar(255) NOT NULL default '', url varchar(255) NOT NULL default '', refresh int(10) NOT NULL default '0', checked int(10) NOT NULL default '0', link varchar(255) NOT NULL default '', description longtext NOT NULL, image longtext NOT NULL, etag varchar(255) NOT NULL default '', modified int(10) NOT NULL default '0', block tinyint(2) NOT NULL default '0', PRIMARY KEY (fid), UNIQUE KEY link (url), UNIQUE KEY title (title) ) TYPE=MyISAM;
-- -- Table structure for table 'aggregator_item' --
CREATE TABLE aggregator_item ( iid int(10) NOT NULL auto_increment, fid int(10) NOT NULL default '0', title varchar(255) NOT NULL default '', link varchar(255) NOT NULL default '', author varchar(255) NOT NULL default '', description longtext NOT NULL, timestamp int(11) default NULL, PRIMARY KEY (iid) ) TYPE=MyISAM;
-- -- Table structure for table 'authmap' --
CREATE TABLE authmap ( aid int(10) unsigned NOT NULL auto_increment, uid int(10) NOT NULL default '0', authname varchar(128) NOT NULL default '', module varchar(128) NOT NULL default '', PRIMARY KEY (aid), UNIQUE KEY authname (authname) ) TYPE=MyISAM;
-- -- Table structure for table 'blocks' --
CREATE TABLE blocks ( module varchar(64) DEFAULT '' NOT NULL, delta varchar(32) NOT NULL default '0', status tinyint(2) DEFAULT '0' NOT NULL, weight tinyint(1) DEFAULT '0' NOT NULL, region tinyint(1) DEFAULT '0' NOT NULL, custom tinyint(2) DEFAULT '0' NOT NULL, throttle tinyint(1) DEFAULT '0' NOT NULL, visibility tinyint(1) DEFAULT '0' NOT NULL, pages text NOT NULL, types text NOT NULL ) TYPE=MyISAM;
-- -- Table structure for table 'book' --
CREATE TABLE book ( nid int(10) unsigned NOT NULL default '0', parent int(10) NOT NULL default '0', weight tinyint(3) NOT NULL default '0', log longtext, PRIMARY KEY (nid), KEY parent (parent) ) TYPE=MyISAM;
-- -- Table structure for table 'boxes' --
CREATE TABLE boxes ( bid tinyint(4) NOT NULL auto_increment, title varchar(64) NOT NULL default '', body longtext, info varchar(128) NOT NULL default '', format int(4) NOT NULL default '0', PRIMARY KEY (bid), UNIQUE KEY title (title), UNIQUE KEY info (info) ) TYPE=MyISAM;
-- -- Table structure for table 'cache' --
CREATE TABLE cache ( cid varchar(255) NOT NULL default '', data longtext, expire int(11) NOT NULL default '0', created int(11) NOT NULL default '0', headers text, PRIMARY KEY (cid), INDEX expire (expire) ) TYPE=MyISAM;
-- -- Table structure for table 'comments' --
CREATE TABLE comments ( cid int(10) NOT NULL auto_increment, pid int(10) NOT NULL default '0', nid int(10) NOT NULL default '0', uid int(10) NOT NULL default '0', subject varchar(64) NOT NULL default '', comment longtext NOT NULL, hostname varchar(128) NOT NULL default '', timestamp int(11) NOT NULL default '0', score mediumint(9) NOT NULL default '0', status tinyint(3) unsigned NOT NULL default '0', format int(4) NOT NULL default '0', thread varchar(255) NOT NULL, users longtext, name varchar(60) default NULL, mail varchar(64) default NULL, homepage varchar(255) default NULL, PRIMARY KEY (cid), KEY lid (nid) ) TYPE=MyISAM;
-- -- Table structre for table 'node_last_comment' --
CREATE TABLE node_comment_statistics ( nid int(10) unsigned NOT NULL auto_increment, last_comment_timestamp int(11) NOT NULL default '0', last_comment_name varchar(60) default NULL, last_comment_uid int(10) NOT NULL default '0', comment_count int(10) unsigned NOT NULL default '0', PRIMARY KEY (nid), KEY node_comment_timestamp (last_comment_timestamp) ) TYPE=MyISAM;
-- -- Table structure for table 'directory' --
CREATE TABLE directory ( 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, timestamp int(11) NOT NULL default '0', PRIMARY KEY (link) ) TYPE=MyISAM;
-- -- Table structure for table 'files' --
CREATE TABLE files ( fid int(10) unsigned NOT NULL default '0', nid int(10) unsigned NOT NULL default '0', filename varchar(255) NOT NULL default '', filepath varchar(255) NOT NULL default '', filemime varchar(255) NOT NULL default '', filesize int(10) unsigned NOT NULL default '0', list tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (fid) ) TYPE=MyISAM;
-- -- Table structure for table 'filter_formats' --
CREATE TABLE filter_formats ( format int(4) NOT NULL auto_increment, name varchar(255) NOT NULL default '', roles varchar(255) NOT NULL default '', cache tinyint(2) NOT NULL default '0', PRIMARY KEY format (format) ) TYPE=MyISAM;
-- -- Table structure for table 'filters' --
CREATE TABLE filters ( format int(4) NOT NULL default '0', module varchar(64) NOT NULL default '', delta tinyint(2) DEFAULT '0' NOT NULL, weight tinyint(2) DEFAULT '0' NOT NULL, INDEX (weight) ) TYPE=MyISAM;
-- -- Table structure for table 'flood' --
CREATE TABLE flood ( event varchar(64) NOT NULL default '', hostname varchar(128) NOT NULL default '', timestamp int(11) NOT NULL default '0' ) TYPE=MyISAM;
-- -- Table structure for table 'forum' --
CREATE TABLE forum ( nid int(10) unsigned NOT NULL default '0', tid int(10) unsigned NOT NULL default '0', PRIMARY KEY (nid), KEY tid (tid) ) TYPE=MyISAM;
-- -- Table structure for table 'history' --
CREATE TABLE history ( uid int(10) NOT NULL default '0', nid int(10) NOT NULL default '0', timestamp int(11) NOT NULL default '0', PRIMARY KEY (uid,nid) ) TYPE=MyISAM;
-- -- Table structure for table 'locales_meta' --
CREATE TABLE locales_meta ( locale varchar(12) NOT NULL default '', name varchar(64) NOT NULL default '', enabled int(2) NOT NULL default '0', isdefault int(2) NOT NULL default '0', plurals int(1) NOT NULL default '0', formula varchar(128) NOT NULL default '', PRIMARY KEY (locale) ) TYPE=MyISAM;
-- -- Table structure for table 'locales_source' --
CREATE TABLE locales_source ( lid int(11) NOT NULL auto_increment, location varchar(128) NOT NULL default '', source blob NOT NULL, PRIMARY KEY (lid) ) TYPE=MyISAM;
-- -- Table structure for table 'locales_target' --
CREATE TABLE locales_target ( lid int(11) NOT NULL default '0', translation blob NOT NULL, locale varchar(12) NOT NULL default '', plid int(11) NOT NULL default '0', plural int(1) NOT NULL default '0', KEY lid (lid), KEY lang (locale), KEY plid (plid), KEY plural (plural) ) TYPE=MyISAM;
-- -- Table structure for table 'menu' --
CREATE TABLE menu ( mid int(10) unsigned NOT NULL default '0', pid int(10) unsigned NOT NULL default '0', path varchar(255) NOT NULL default '', title varchar(255) NOT NULL default '', description varchar(255) NOT NULL default '', weight tinyint(4) NOT NULL default '0', type int(2) unsigned NOT NULL default '0', PRIMARY KEY (mid) ) TYPE=MyISAM;
-- -- Table structure for table 'moderation_filters' --
CREATE TABLE moderation_filters ( fid int(10) unsigned NOT NULL auto_increment, filter varchar(255) NOT NULL default '', minimum smallint(6) NOT NULL default '0', PRIMARY KEY (fid) ) TYPE=MyISAM;
-- -- Table structure for table 'moderation_roles' --
CREATE TABLE moderation_roles ( rid int(10) unsigned NOT NULL default '0', mid int(10) unsigned NOT NULL default '0', value tinyint(4) NOT NULL default '0', KEY idx_rid (rid), KEY idx_mid (mid) ) TYPE=MyISAM;
-- -- Table structure for table 'moderation_votes' --
CREATE TABLE moderation_votes ( mid int(10) unsigned NOT NULL auto_increment, vote varchar(255) default NULL, weight tinyint(4) NOT NULL default '0', PRIMARY KEY (mid) ) TYPE=MyISAM;
-- -- Table structure for table 'node' --
CREATE TABLE node ( nid int(10) unsigned NOT NULL auto_increment, type varchar(16) NOT NULL default '', title varchar(128) NOT NULL default '', uid int(10) NOT NULL default '0', status int(4) NOT NULL default '1', created int(11) NOT NULL default '0', changed int(11) NOT NULL default '0', comment int(2) NOT NULL default '0', promote int(2) NOT NULL default '0', moderate int(2) NOT NULL default '0', teaser longtext NOT NULL, body longtext NOT NULL, revisions longtext NOT NULL, sticky int(2) NOT NULL default '0', format int(4) NOT NULL default '0', PRIMARY KEY (nid), KEY node_type (type(4)), KEY node_title_type (title,type(4)), KEY status (status), KEY uid (uid), KEY node_moderate (moderate), KEY node_promote_status (promote, status), KEY node_created (created), KEY node_changed (changed), KEY node_status_type (status, type, nid) ) TYPE=MyISAM;
-- -- Table structure for table `node_access` --
CREATE TABLE node_access ( nid int(10) unsigned NOT NULL default '0', gid int(10) unsigned NOT NULL default '0', realm varchar(255) NOT NULL default '', grant_view tinyint(1) unsigned NOT NULL default '0', grant_update tinyint(1) unsigned NOT NULL default '0', grant_delete tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (nid,gid,realm) ) TYPE=MyISAM;
-- -- Table structure for table 'profile_fields' --
CREATE TABLE profile_fields ( fid int(10) NOT NULL auto_increment, title varchar(255) default NULL, name varchar(128) default NULL, explanation TEXT default NULL, category varchar(255) default NULL, page varchar(255) default NULL, type varchar(128) default NULL, weight tinyint(1) DEFAULT '0' NOT NULL, required tinyint(1) DEFAULT '0' NOT NULL, register tinyint(1) DEFAULT '0' NOT NULL, visibility tinyint(1) DEFAULT '0' NOT NULL, options text, KEY category (category), UNIQUE KEY name (name), PRIMARY KEY (fid) );
-- -- Table structure for table 'profile_values' --
CREATE TABLE profile_values ( fid int(11) unsigned default '0', uid int(11) unsigned default '0', value text, KEY uid (uid), KEY fid (fid) );
-- -- Table structure for table 'url_alias' --
CREATE TABLE url_alias ( pid int(10) unsigned NOT NULL auto_increment, src varchar(128) NOT NULL default '', dst varchar(128) NOT NULL default '', PRIMARY KEY (pid), UNIQUE KEY dst (dst) ) TYPE=MyISAM;
-- -- Table structure for table 'permission' --
CREATE TABLE permission ( rid int(10) unsigned NOT NULL default '0', perm longtext, tid int(10) unsigned NOT NULL default '0', KEY rid (rid) ) TYPE=MyISAM;
-- -- Table structure for table 'poll' --
CREATE TABLE poll ( nid int(10) unsigned NOT NULL default '0', runtime int(10) NOT NULL default '0', voters longtext NOT NULL, active int(2) unsigned NOT NULL default '0', PRIMARY KEY (nid) ) TYPE=MyISAM;
-- -- Table structure for table 'poll_choices'
Carl McDade Regards, Bèr -- [ Bèr Kessels | Drupal services www.webschuur.com ]
Sorry, I did not think the mail server scanned the headers that deeply. I will fix my client accordingly. Carl Bèr Kessels wrote:
Carl,
Just a quick thing: Could you please consider writing new mails instead of replying to old ones. your replies break the threads. Yesterday you did the same. Read more about mailinglist guidelines here: http://lists.drupal.org/listinfo/drupal-devel
Bèr
Op donderdag 17 maart 2005 10:51, schreef Carl McDade:
I just spent two days trying to find out why database backups are not running. It would seem that naming database columns with a reserved word is the problem. Timestamp is used as a column name in about 15 instances.
Phpmyadmin and mySQL adminstrator both take the reserved word literally and execute errors when trying to name a column with time when running the script.
This is a basic database knowledge thing. Never should programming language, database or columntypes reserved words be used as column names.
This use is present in 4.5.2 and 4.6
-- MySQL dump 8.22 -- -- Host: localhost Database: drupal_devel -- Server version 3.23.52-nt
-- -- Table structure for table 'access' --
CREATE TABLE access ( aid tinyint(10) NOT NULL auto_increment, mask varchar(255) NOT NULL default '', type varchar(255) NOT NULL default '', status tinyint(2) NOT NULL default '0', PRIMARY KEY (aid) ) TYPE=ISAM;
-- -- Table structure for table 'accesslog' --
CREATE TABLE accesslog ( aid int(10) NOT NULL auto_increment, title varchar(255) default NULL, path varchar(255) default NULL, url varchar(255) default NULL, hostname varchar(128) default NULL, uid int(10) unsigned default '0', timestamp int(11) unsigned NOT NULL default '0', KEY accesslog_timestamp (timestamp), PRIMARY KEY (aid) ) TYPE=ISAM;
-- -- Table structure for table 'aggregator_category' --
CREATE TABLE aggregator_category ( cid int(10) NOT NULL auto_increment, title varchar(255) NOT NULL default '', description longtext NOT NULL, block tinyint(2) NOT NULL default '0', PRIMARY KEY (cid), UNIQUE KEY title (title) ) TYPE=ISAM;
-- -- Table structure for table 'aggregator_category_feed' --
CREATE TABLE aggregator_category_feed ( fid int(10) NOT NULL default '0', cid int(10) NOT NULL default '0', PRIMARY KEY (fid,cid) ) TYPE=ISAM;
-- -- Table structure for table 'aggregator_category_item' --
CREATE TABLE aggregator_category_item ( iid int(10) NOT NULL default '0', cid int(10) NOT NULL default '0', PRIMARY KEY (iid,cid) ) TYPE=ISAM;
-- -- Table structure for table 'aggregator_feed' --
CREATE TABLE aggregator_feed ( fid int(10) NOT NULL auto_increment, title varchar(255) NOT NULL default '', url varchar(255) NOT NULL default '', refresh int(10) NOT NULL default '0', checked int(10) NOT NULL default '0', link varchar(255) NOT NULL default '', description longtext NOT NULL, image longtext NOT NULL, etag varchar(255) NOT NULL default '', modified int(10) NOT NULL default '0', block tinyint(2) NOT NULL default '0', PRIMARY KEY (fid), UNIQUE KEY link (url), UNIQUE KEY title (title) ) TYPE=ISAM;
-- -- Table structure for table 'aggregator_item' --
CREATE TABLE aggregator_item ( iid int(10) NOT NULL auto_increment, fid int(10) NOT NULL default '0', title varchar(255) NOT NULL default '', link varchar(255) NOT NULL default '', author varchar(255) NOT NULL default '', description longtext NOT NULL, timestamp int(11) default NULL, PRIMARY KEY (iid) ) TYPE=ISAM;
-- -- Table structure for table 'authmap' --
CREATE TABLE authmap ( aid int(10) unsigned NOT NULL auto_increment, uid int(10) NOT NULL default '0', authname varchar(128) NOT NULL default '', module varchar(128) NOT NULL default '', PRIMARY KEY (aid), UNIQUE KEY authname (authname) ) TYPE=ISAM;
-- -- Table structure for table 'blocks' --
CREATE TABLE blocks ( module varchar(64) DEFAULT '' NOT NULL, delta varchar(32) NOT NULL default '0', status tinyint(2) DEFAULT '0' NOT NULL, weight tinyint(1) DEFAULT '0' NOT NULL, region tinyint(1) DEFAULT '0' NOT NULL, custom tinyint(2) DEFAULT '0' NOT NULL, throttle tinyint(1) DEFAULT '0' NOT NULL, visibility tinyint(1) DEFAULT '0' NOT NULL, pages text NOT NULL, types text NOT NULL ) TYPE=ISAM;
-- -- Table structure for table 'book' --
CREATE TABLE book ( nid int(10) unsigned NOT NULL default '0', parent int(10) NOT NULL default '0', weight tinyint(3) NOT NULL default '0', log longtext, PRIMARY KEY (nid), KEY parent (parent) ) TYPE=ISAM;
-- -- Table structure for table 'boxes' --
CREATE TABLE boxes ( bid tinyint(4) NOT NULL auto_increment, title varchar(64) NOT NULL default '', body longtext, info varchar(128) NOT NULL default '', format int(4) NOT NULL default '0', PRIMARY KEY (bid), UNIQUE KEY title (title), UNIQUE KEY info (info) ) TYPE=ISAM;
-- -- Table structure for table 'cache' --
CREATE TABLE cache ( cid varchar(255) NOT NULL default '', data longtext, expire int(11) NOT NULL default '0', created int(11) NOT NULL default '0', headers text, PRIMARY KEY (cid), INDEX expire (expire) ) TYPE=ISAM;
-- -- Table structure for table 'comments' --
CREATE TABLE comments ( cid int(10) NOT NULL auto_increment, pid int(10) NOT NULL default '0', nid int(10) NOT NULL default '0', uid int(10) NOT NULL default '0', subject varchar(64) NOT NULL default '', comment longtext NOT NULL, hostname varchar(128) NOT NULL default '', timestamp int(11) NOT NULL default '0', score mediumint(9) NOT NULL default '0', status tinyint(3) unsigned NOT NULL default '0', format int(4) NOT NULL default '0', thread varchar(255) NOT NULL, users longtext, name varchar(60) default NULL, mail varchar(64) default NULL, homepage varchar(255) default NULL, PRIMARY KEY (cid), KEY lid (nid) ) TYPE=ISAM;
-- -- Table structre for table 'node_last_comment' --
CREATE TABLE node_comment_statistics ( nid int(10) unsigned NOT NULL auto_increment, last_comment_timestamp int(11) NOT NULL default '0', last_comment_name varchar(60) default NULL, last_comment_uid int(10) NOT NULL default '0', comment_count int(10) unsigned NOT NULL default '0', PRIMARY KEY (nid), KEY node_comment_timestamp (last_comment_timestamp) ) TYPE=ISAM;
-- -- Table structure for table 'directory' --
CREATE TABLE directory ( 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, timestamp int(11) NOT NULL default '0', PRIMARY KEY (link) ) TYPE=ISAM;
-- -- Table structure for table 'files' --
CREATE TABLE files ( fid int(10) unsigned NOT NULL default '0', nid int(10) unsigned NOT NULL default '0', filename varchar(255) NOT NULL default '', filepath varchar(255) NOT NULL default '', filemime varchar(255) NOT NULL default '', filesize int(10) unsigned NOT NULL default '0', list tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (fid) ) TYPE=ISAM;
-- -- Table structure for table 'filter_formats' --
CREATE TABLE filter_formats ( format int(4) NOT NULL auto_increment, name varchar(255) NOT NULL default '', roles varchar(255) NOT NULL default '', cache tinyint(2) NOT NULL default '0', PRIMARY KEY format (format) ) TYPE=ISAM;
-- -- Table structure for table 'filters' --
CREATE TABLE filters ( format int(4) NOT NULL default '0', module varchar(64) NOT NULL default '', delta tinyint(2) DEFAULT '0' NOT NULL, weight tinyint(2) DEFAULT '0' NOT NULL, INDEX (weight) ) TYPE=ISAM;
-- -- Table structure for table 'flood' --
CREATE TABLE flood ( event varchar(64) NOT NULL default '', hostname varchar(128) NOT NULL default '', timestamp int(11) NOT NULL default '0' ) TYPE=ISAM;
-- -- Table structure for table 'forum' --
CREATE TABLE forum ( nid int(10) unsigned NOT NULL default '0', tid int(10) unsigned NOT NULL default '0', PRIMARY KEY (nid), KEY tid (tid) ) TYPE=ISAM;
-- -- Table structure for table 'history' --
CREATE TABLE history ( uid int(10) NOT NULL default '0', nid int(10) NOT NULL default '0', timestamp int(11) NOT NULL default '0', PRIMARY KEY (uid,nid) ) TYPE=ISAM;
-- -- Table structure for table 'locales_meta' --
CREATE TABLE locales_meta ( locale varchar(12) NOT NULL default '', name varchar(64) NOT NULL default '', enabled int(2) NOT NULL default '0', isdefault int(2) NOT NULL default '0', plurals int(1) NOT NULL default '0', formula varchar(128) NOT NULL default '', PRIMARY KEY (locale) ) TYPE=ISAM;
-- -- Table structure for table 'locales_source' --
CREATE TABLE locales_source ( lid int(11) NOT NULL auto_increment, location varchar(128) NOT NULL default '', source blob NOT NULL, PRIMARY KEY (lid) ) TYPE=ISAM;
-- -- Table structure for table 'locales_target' --
CREATE TABLE locales_target ( lid int(11) NOT NULL default '0', translation blob NOT NULL, locale varchar(12) NOT NULL default '', plid int(11) NOT NULL default '0', plural int(1) NOT NULL default '0', KEY lid (lid), KEY lang (locale), KEY plid (plid), KEY plural (plural) ) TYPE=ISAM;
-- -- Table structure for table 'menu' --
CREATE TABLE menu ( mid int(10) unsigned NOT NULL default '0', pid int(10) unsigned NOT NULL default '0', path varchar(255) NOT NULL default '', title varchar(255) NOT NULL default '', description varchar(255) NOT NULL default '', weight tinyint(4) NOT NULL default '0', type int(2) unsigned NOT NULL default '0', PRIMARY KEY (mid) ) TYPE=ISAM;
-- -- Table structure for table 'moderation_filters' --
CREATE TABLE moderation_filters ( fid int(10) unsigned NOT NULL auto_increment, filter varchar(255) NOT NULL default '', minimum smallint(6) NOT NULL default '0', PRIMARY KEY (fid) ) TYPE=ISAM;
-- -- Table structure for table 'moderation_roles' --
CREATE TABLE moderation_roles ( rid int(10) unsigned NOT NULL default '0', mid int(10) unsigned NOT NULL default '0', value tinyint(4) NOT NULL default '0', KEY idx_rid (rid), KEY idx_mid (mid) ) TYPE=ISAM;
-- -- Table structure for table 'moderation_votes' --
CREATE TABLE moderation_votes ( mid int(10) unsigned NOT NULL auto_increment, vote varchar(255) default NULL, weight tinyint(4) NOT NULL default '0', PRIMARY KEY (mid) ) TYPE=ISAM;
-- -- Table structure for table 'node' --
CREATE TABLE node ( nid int(10) unsigned NOT NULL auto_increment, type varchar(16) NOT NULL default '', title varchar(128) NOT NULL default '', uid int(10) NOT NULL default '0', status int(4) NOT NULL default '1', created int(11) NOT NULL default '0', changed int(11) NOT NULL default '0', comment int(2) NOT NULL default '0', promote int(2) NOT NULL default '0', moderate int(2) NOT NULL default '0', teaser longtext NOT NULL, body longtext NOT NULL, revisions longtext NOT NULL, sticky int(2) NOT NULL default '0', format int(4) NOT NULL default '0', PRIMARY KEY (nid), KEY node_type (type(4)), KEY node_title_type (title,type(4)), KEY status (status), KEY uid (uid), KEY node_moderate (moderate), KEY node_promote_status (promote, status), KEY node_created (created), KEY node_changed (changed), KEY node_status_type (status, type, nid) ) TYPE=ISAM;
-- -- Table structure for table `node_access` --
CREATE TABLE node_access ( nid int(10) unsigned NOT NULL default '0', gid int(10) unsigned NOT NULL default '0', realm varchar(255) NOT NULL default '', grant_view tinyint(1) unsigned NOT NULL default '0', grant_update tinyint(1) unsigned NOT NULL default '0', grant_delete tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (nid,gid,realm) ) TYPE=ISAM;
-- -- Table structure for table 'profile_fields' --
CREATE TABLE profile_fields ( fid int(10) NOT NULL auto_increment, title varchar(255) default NULL, name varchar(128) default NULL, explanation TEXT default NULL, category varchar(255) default NULL, page varchar(255) default NULL, type varchar(128) default NULL, weight tinyint(1) DEFAULT '0' NOT NULL, required tinyint(1) DEFAULT '0' NOT NULL, register tinyint(1) DEFAULT '0' NOT NULL, visibility tinyint(1) DEFAULT '0' NOT NULL, options text, KEY category (category), UNIQUE KEY name (name), PRIMARY KEY (fid) );
-- -- Table structure for table 'profile_values' --
CREATE TABLE profile_values ( fid int(11) unsigned default '0', uid int(11) unsigned default '0', value text, KEY uid (uid), KEY fid (fid) );
-- -- Table structure for table 'url_alias' --
CREATE TABLE url_alias ( pid int(10) unsigned NOT NULL auto_increment, src varchar(128) NOT NULL default '', dst varchar(128) NOT NULL default '', PRIMARY KEY (pid), UNIQUE KEY dst (dst) ) TYPE=ISAM;
-- -- Table structure for table 'permission' --
CREATE TABLE permission ( rid int(10) unsigned NOT NULL default '0', perm longtext, tid int(10) unsigned NOT NULL default '0', KEY rid (rid) ) TYPE=ISAM;
-- -- Table structure for table 'poll' --
CREATE TABLE poll ( nid int(10) unsigned NOT NULL default '0', runtime int(10) NOT NULL default '0', voters longtext NOT NULL, active int(2) unsigned NOT NULL default '0', PRIMARY KEY (nid) ) TYPE=ISAM;
-- -- Table structure for table 'poll_choices'
Carl McDade Regards, Bèr
I did not think the mail server scanned the headers that deeply. I will fix my client accordingly.
It is not your client, it is you. If you hit 'reply', then what other can you expect from your client, then sending a *reply*? If you hit *new mail* then you guess, what will happen! Goba
I admitted it was me . I did not have drupal-devel address set which is why I was using the reply button. Moving on... There is also a problem with using this kind of syntax in the SQL that also may cause problems in the future. "timestamp" use for identification $sql = "SELECT DISTINCT(n.nid), f.tid, n.title, n.sticky, u.name, u.uid, n.created AS timestamp, n.comment AS comment_mode, l.last_comment_timestamp, IF(l.last_comment_uid, cu.name, l.last_comment_name) as last_comment_name, l.last_comment_uid, l.comment_count AS num_comments FROM {node} n ". node_access_join_sql() .", {node_comment_statistics} l, {users} cu, {term_node} r, {users} u, {forum} f WHERE n.status = 1 AND l.last_comment_uid = cu.uid AND n.nid = l.nid AND n.nid = r.nid AND r.tid = $check_tid AND n.uid = u.uid AND n.nid = f.nid AND ". node_access_where_sql(); Carl McDade
Op donderdag 17 maart 2005 12:01, schreef Karoly Negyesi:
Carl Bčr Kessels wrote:
Carl, Bér STOP IMMEDIATELY QUOTING A GIGALONG MESSAGE!
Wooops. Sorry. :( My call, I did not read the nmessage, for I was not commenting on the content, hence I did not notice it was that long. Again: sorry! Regards, Bèr -- [ Bèr Kessels | Drupal services www.webschuur.com ]
participants (7)
-
Bèr Kessels -
Carl McDade -
Claus Rasmussen -
Dries Buytaert -
drupal-devel@drupal.org -
Gabor Hojtsy -
Karoly Negyesi