#2006 reserved words in mysql table

v1.9.2
closed-fixed
nobody
5
2006-09-20
2005-12-19
HalaszG
No

Hi

The db/tiki-1.9-mysql.sql incompatible with
mysql-server 5, because 'reasd' is reserved word in new
mysql server. See here:
http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

Regards

Gabor HALASZ

Discussion

  • Danny Staple

    Danny Staple - 2006-03-24

    Logged In: YES
    user_id=748225

    The word reasd is not found in the file, or on the specified
    website:
    danny@orion:~/dev> grep -i reasd
    ~/public_html/db/tiki-1.9-mysql.sql
    danny@orion:~/dev>

    I presume you meant the reserved word reads, whcih is
    mentioned on the above website. And appears in the file:

    danny@orion:~/dev>danny@orion:~/dev> grep -ni \\breads\\b
    ~/public_html/db/tiki-1.9-mysql.sql
    361: reads int(14) default NULL,
    371: KEY reads (reads),
    3081: reads int(14) default NULL,
    danny@orion:~/dev>

    I suspect here (looking at context) that these are to do
    with the number of times something has been read, and maybe
    should be replaced (in future tikis, and with an upgrade
    script) with the term read_count or something.

    Danny

     
  • Oliver Hertel

    Oliver Hertel - 2006-09-20

    Logged In: YES
    user_id=21633

    'reads' fixed to 'nbreads' in 1.9.4 or 1.9.5.

     
  • Oliver Hertel

    Oliver Hertel - 2006-09-20
    • status: open --> closed-fixed
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks