forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Installation & Setup => Topic started by: loupgarou on November 14, 2005, 09:21:29 am

Title: New Album gives: mySQL error: Field 'description' doesn't have a default value
Post by: loupgarou on November 14, 2005, 09:21:29 am

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.

Title: Re: New Album gives: mySQL error: Field 'description' doesn't have a default val
Post by: Joachim Müller on November 14, 2005, 09:23:41 am

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

Title: Re: New Album gives: mySQL error: Field 'description' doesn't have a default value
Post by: heman on November 16, 2005, 09:15:51 am

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?

Title: Re: New Album gives: mySQL error: Field 'description' doesn't have a default value
Post by: Nibbler on November 16, 2005, 05:20:56 pm

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.