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.
cpg1.3.5 currently isn't fully compatible with mySQL5.x
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?
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.