Closed (fixed)
Project:
Fileshare
Version:
4.7.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Reporter:
Created:
8 Jul 2006 at 22:19 UTC
Updated:
1 Aug 2006 at 21:28 UTC
Jump to comment: Most recent file
Installing this module, i got the following error :
user warning: Invalid default value for '_thumbs' query: CREATE TABLE node_fileshare ( vid INT(4) UNSIGNED DEFAULT '0' NOT NULL , nid INT(4) UNSIGNED DEFAULT '0' NOT NULL , _filepath VARCHAR(255) NOT NULL , _thumbs BOOL DEFAULT 'FALSE' NOT NULL , _modify BOOL DEFAULT 'FALSE' NOT NULL , PRIMARY KEY (vid,nid) ) TYPE = MYISAM /*!40100 DEFAULT CHARACTER SET utf8 */ in....
also, TYPE=MYISAM is deprecated
so I updated the creation code as this in my fileshare.mysql file
CREATE TABLE node_fileshare (
vid INT(4) UNSIGNED DEFAULT '0' NOT NULL ,
nid INT(4) UNSIGNED DEFAULT '0' NOT NULL ,
_filepath VARCHAR(255) NOT NULL ,
_thumbs BOOL DEFAULT FALSE NOT NULL ,
_modify BOOL DEFAULT FALSE NOT NULL ,
PRIMARY KEY (vid,nid) ) ENGINE = MYISAM /*!40100 DEFAULT CHARACTER SET utf8 */
no more error.
| Comment | File | Size | Author |
|---|---|---|---|
| #3 | unquote-mysql.patch.txt | 781 bytes | dman |
Comments
Comment #1
JamieR commentedThank you. I'm a postgreSQL guy, so any help fine tuning the MySQL is appreciated. I'll update the repository soon.
Comment #2
JamieR commentedI just removed the whole spec of 'MYISAM' cvs updated.
Comment #3
dman commentedStill broken.
Looks like you quoted the 'FALSE' values.
--- on preview I see it's full of tabs. You may not care, but coding standards stop confusion when patching.
Here's my version of the same task It doesn't have the ability to delete, and it doesn't have its own database table, but it doesn't cause errors in IE either. (touchwood)
Comment #4
JamieR commentedThanks for the feedback - I updated the version in cvs and did some code cleanup.
But where was your module when I went looking a couple months ago! I never would have made this if that was around! Grrr...
And if you want to lend a hand debugging the IE errors feel free... ;) I should have a windows environment up in VMware on my Linux machine soon though... so I can troubleshoot IE in a couple weeks.
Comment #5
(not verified) commentedComment #6
blalond commentedI got this to work using phpMyAdmin: