I found this: Values in VARCHAR columns are variable-length strings. The length can be specified as 1 to 255 before MySQL 4.0.2, 0 to 255 as of MySQL 4.0.2, and 0 to 65,535 as of MySQL 5.0.3. (The maximum actual length of a VARCHAR in MySQL 5.0 is determined by the maximum row size and the character set you use. The maximum effective length is 65,532 bytes.)
But its not really an issue, I just wanted to have bigger values for something, but its not really required. So, to upgrade do # cat docs/upgrade/mysql/jffnms-0.8.2-to-0.8.3.mysql.diff* | grep -v 3000 I'll update it for the new release. Thanks for reporting. Javier kimdowo wrote: > 0.8.3-rc1 upgrade error > > hi all > > [EMAIL PROTECTED] jffnms]# cat > docs/upgrade/mysql/jffnms-0.8.2-to-0.8.3.mysql.diff* | mysql -u jffnms > -pjffnms jffnms > ERROR 1074 at line 3: Too big column length for column 'value' (max = > 255). Use BLOB instead > [EMAIL PROTECTED] jffnms]# rpm -qa |grep my > mysql-3.23.58-1.80 > mod_auth_mysql-1.11-10 > php-mysql-4.2.2-8.0.8 > libdbi-dbd-mysql-0.6.5-2 > mysql-server-3.23.58-1.80 > mysql-devel-3.23.58-1.80 > > do I need upgrade db ? > thanks > > > _______________________________________________ > jffnms-users mailing list > jffnms-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jffnms-users -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Javier Szyszlican, Project Leader, JFFNMS [EMAIL PROTECTED] I hope JFFNMS or I were helpful to you, if you can, please donate at http://jffnms.org/donate _______________________________________________ jffnms-users mailing list jffnms-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jffnms-users
