Print

[loupgarou]

I'm doing  a first time setup.

Apache 2.0.55
mysql 5.0.15
php 4.4.1
--
when creating an album, it gives me:

While executing query "INSERT INTO cpg135_albums (category, title, uploads, pos) VALUES ('0', 'New album', 'NO',  '1')" on 0

mySQL error: Field 'description' doesn't have a default value

--
in the database
mysql> desc cpg135_albums;
+---------------+------------------+------+
-------+
| Field         | Type             | Null |
       |
+---------------+------------------+------+
-------+
| aid           | int(11)          | NO   |
rement |
| title         | varchar(255)     | NO   |
       |
| description   | text             | NO   |
       |
| visibility    | int(11)          | NO   |
       |
| uploads       | enum('YES','NO') | NO   |
       |
| comments      | enum('YES','NO') | NO   |
       |
| votes         | enum('YES','NO') | NO   |
       |
| pos           | int(11)          | NO   |
       |
| category      | int(11)          | NO   |
       |
| pic_count     | int(11)          | NO   |
       |
| thumb         | int(11)          | NO   |
       |
| last_addition | datetime         | NO   |
       |
| stat_uptodate | enum('YES','NO') | NO   |
       |
| keyword       | varchar(50)      | YES  |
       |
+---------------+------------------+------+

so its quite obvious it seems to be scripting bug or something.. description is a mandatory field.

can't seem to find any solutions.

[Joachim Müller]

cpg1.3.5 currently isn't fully compatible with mySQL5.x

[heman]

so what options do we have for compatibility with mySQL 5?
do previous version so coppermine work with it? or is there a fix out?

[Nibbler]

You can use MySQL 5 with CPG 1.4 or use MySQL 4.x with CPG 1.3. There's no fix posted for 1.3 afaik.