Re: [Tikiwiki-devel] Re: So we are limited for the number of "Available styles:"

[Flo G. <fl...@bi...>]

Why not create a table for that and store each available style in a row. 
There is no reason why this should be saved in tiki_preferences. A new 
table is "better" design and more flexible. You could later add a column 
"group" and allow available styles for each group. So the "developers" 
group can see new styles while the "users" group can only see the stable 
styles ...

Flo

P.S. text colums have different limits in different databases.

On Fri, 27 Aug 2004, Luis Fagundes wrote:

> Hi tikians!
> I had notice this when using the same technic for another (local) problem, 
> and solved by changing from varchar to text, as damian suggested. What would 
> be the consequences? There's no index or searchs by values there, so I think 
> there's no problem. Is that fine with other databases?
>
> batawata
>
>
> Marc Laporte wrote:
>
>> Hi Luis!
>> 
>> So we are limited for the number of "Available styles:"
>> 
>> What can we do to workaround this limitation?
>> 
>> Thanks!
>> 
>> 
>> <marclaporte> tiki-admin.php?page=login  I am getting    Warning: 
>> unserialize() failed at offset 251 of 250 bytes in 
>> tiki-admin_include_login.php on line 445
>> [19:35]<marclaporte> I cleared the cache: still not working
>> [19:35]<marclaporte> this test tiki has all the features activated
>> [19:35]<marclaporte> line 445 is $smarty->assign("available_styles", 
>> unserialize($tikilib->get_preference("available_styles")));
>> [19:36]<marclaporte> any ideas?
>> [19:37]<damian> have you setup any style restrictions?
>> [19:37]<damian> whats the value of available_styles in the 
>> tiki_preferences table?
>> [19:37]<marclaporte> yes, I had 4 (I think)
>> [19:39]<marclaporte> 
>> a:46:{i:0;s:10:"3dblue.css";i:1;s:7:"508.css";i:2;s:8:"akwa.css";i:3;s:13:"bluegreen.css";i:4;s:13:"bluemetal.css";i:5;s:10:"boreal.css";i:6;s:15:"classicblue.css";i:7;s:9:"codex.css";i:8;s:10:"damian.css";i:9;s:9:"dblue.css";i:10;s:11:"default.css"; 
>> [19:41]<marclaporte> missing curly backet ?  }   in that field
>> [19:41]<marclaporte> ahhhhh!
>> [19:42]<marclaporte> I found it!!
>> [19:42]<damian> yeay! marc the bughunter :)
>> [19:42]<damian> cue commit ???? :)
>> [19:42]<marclaporte> varchar(250)
>> [19:42]<marclaporte> needs to be higher !!
>> [19:42]<damian> mmm thats a bit poop :(
>> [19:43]<damian> definately probably changing to a text
>> [19:43]<damian> especially if you have a site with a lot of themes
>> [19:43]<damian> varchar has maximum of 255
>> 
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> Tikiwiki-devel mailing list
> Tik...@li...
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>