|
|
DB Error Component Wont Install
|
|
|
|
DB Error - 2007/02/23 12:00
The plugin installed o.k. however the following message is what I received when I tried to install the component.
SQL Error DB function failed with error number 1074
Too big column length for column 'description' (max = 255). Use BLOB instead SQL=CREATE TABLE IF NOT EXISTS `jos_gmaps_maps` ( `id` int(11) NOT NULL auto_increment, `title` varchar(30) NOT NULL, `description` varchar(300) NOT NULL, `overlay1` int(11) NOT NULL, `overlay2` int(11) NOT NULL, `overlay3` int(11) NOT NULL, `overlay4` int(11) NOT NULL, `overlay5` int(11) NOT NULL, `properties` varchar(5000), PRIMARY KEY (`id`) )
SQL =
CREATE TABLE IF NOT EXISTS `jos_gmaps_maps` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(30) NOT NULL,
`description` varchar(300) NOT NULL,
`overlay1` int(11) NOT NULL,
`overlay2` int(11) NOT NULL,
`overlay3` int(11) NOT NULL,
`overlay4` int(11) NOT NULL,
`overlay5` int(11) NOT NULL,
`properties` varchar(5000),
PRIMARY KEY (`id`)
)
The administrator has disabled public write access.
|
|
|
Re:DB Error - 2007/02/23 12:09
This like because you are using a 4.0.x version of MySQL. I have tested this under 4.4.x and 5.x. 4.0. versions do not appear to support varchar datatypes greater than 255. I didn't want to use a TEXT or BLOB field for columns that for the most part were not going to be that large.
Chris
The administrator has disabled public write access.
|
|
|
Re:DB Error - 2007/02/23 13:26
Hi Chris
Thanks for responding. Then I guess the only way to make gmap component work is to have my webhost changed or have him upgrade to mysql version 4.4 or 5
Is this correct?
Thanks
The administrator has disabled public write access.
|
|
|
Re:DB Error - 2007/02/23 14:21
Chris,
I believe the problem was resolved in MySQL 4.1 based on the research I found. Rather than upgrading to 4.4, you may ask to upgrade to 4.1 which would have a lesser impact on your site.
Chris
The administrator has disabled public write access.
|
|
|
Re:DB Error - 2007/02/23 14:54
The version that is running is 4.1.10 That should work according to your last reply.
The administrator has disabled public write access.
|
|
|
Re:DB Error - 2007/02/23 15:55
I'll have to research this further. My next build will change the datatype to TEXT which will resolve backward compatibility for older versions of MySQL. I'll update the site this weekend.
The administrator has disabled public write access.
|
|
|
Re:DB Error - 2007/02/23 17:55
Thank you. I will look forward to it. Take care.
Sincerely
Chris Gallacher
The administrator has disabled public write access.
|
|
|
Re:DB Error - 2007/02/23 21:28
I am having a similar problem. DB field not big enough.
I tried to recreat it to give you the exact message but retrying the installation generated a message that the directory was being used by another component. I tried to delete it but because of teh nobody user ownership I could not.
Here's my system info-
PHP version = 4.3.10 apache
Webserver = Apache/1.3.37
Database = mysql 4.0.17-log, lock.system=flock
Thanks
G
The administrator has disabled public write access.
|
|
|
Re:DB Error - 2007/02/23 23:50
This appears to be the most prevelent problem I'm seeing. Thanks for the feedback!
Keep an eye out this weekend. I'll do my best to get a fix out there for this.
The administrator has disabled public write access.
|
|
|
Re:DB Error - 2007/02/24 19:52
I am watching the site for the fix for this. I love this component and hope to implement it soon. Thank you for all of the work you are doing.
Rogerville Mom
The administrator has disabled public write access.
|
|
