#67 error on installation

[Shehper]

hi,
i use PHPMyadmin for mysql database.. and i get this
error in query
---------------------
Error

SQL-query :

CREATE TABLE confirmations(

id int( 11 ) NOT NULL default '0',
user_id int( 11 ) NOT NULL default '0',
CHECK char( 32 ) default NULL
)

MySQL said:

You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version
for the right syntax to use near 'default NULL )' at line 3
---------------------
and if i check my mail url www.abc.com/mail/index.php
so i get this error

---------
Fatal error: Cannot redeclare print_array()
in /home/shehper/public_html/mail/class.mimepart.inc.php
on line 587
-------------
any idea plz ?
i really like yr script as seen on puicture and i want to
install it ..
popper.inc.php is under the root directory --> under the
www-->publichtml directory
regards

[deuce23]

Logged In: YES
user_id=997336

Check is a key word which is causing the error.

To work around. Delete the line in the script file and add it
manually afterwords.

or just create the table manually.

[Rene Stock]

Logged In: YES
user_id=1124567

I changed the field name CHECK to checker, as it appears it is
a MySQL keyword. Must change it as well in the
class.popper.inc.php sql statements for variable $query.

[Nobody/Anonymous]

Logged In: NO

CHECK char( 32 ) default NULL

The "check" is an key word in MySQL

[MrsAngelD]

Logged In: YES
user_id=1139017

itiz

I was trying to follow your advice but I'm pretty new to Php
could you help me understand what you mean more by

"Must change it as well in the
class.popper.inc.php sql statements for variable $query"

I opened the files and had a look but I wasn't sure what to
change. I would really like to use this program please help.

Thanks,
Angel

[Nobody/Anonymous]

Logged In: NO

CHECK is on the reserved words list so the most simple
solution is enclose it in in bacticks, i.e. `CHECK` ...

see http://dev.mysql.com/doc/mysql/en/legal-names.html

[Rene Stock]

Logged In: YES
user_id=1124567

Download the latest version - the field name has been
modified.