Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • March 23, 2005 at 3:03 pm in reply to: problem in after moving to high php/msql #17221
    terrymechan
    Member

    thanks

    I'll take this away now as it is not a sqlyog problem

    regds

    terry mechan

    http://www.morgle.com

    March 23, 2005 at 2:01 pm in reply to: problem in after moving to high php/msql #17219
    terrymechan
    Member

    According to the docs, the limit should be 1000 not 500.

    If 500 has been set by default, then apparently it can be re-compiled

    here is an extract from the manual on http://help.scibit.com/mysql/manual_Table_types.html

    The maximum key length is 500 bytes by default, and 1000 bytes as of MySQL 4.1.2. This can be changed by recompiling. For the case of a key longer than 250 bytes, a larger key block size than the default of 1024 bytes is used.

    MY ISP provider doesn't know how to do this. Can you offer any help pse

    March 23, 2005 at 12:28 pm in reply to: problem in after moving to high php/msql #17217
    terrymechan
    Member

    thanks for the information

    I have reduced the length of some of my field in a test table so that the full text index is below the 500 allowed and now I can copy

    my isp owner is not so familiar with trimmings.

    Any idea on where he would need to go to increase the maximum mysql key length allowable

    I'd like to take it up to 650 to keep the integrity of my user inputs the same

    rgds

    tjm

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)