Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Trouble with adding an album  (Read 2536 times)

0 Members and 1 Guest are viewing this topic.

JCDenton

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Trouble with adding an album
« on: April 04, 2006, 05:21:52 pm »

I have had no problems until today trying to add an album to a category. I created a new category today but when trying to add an album I get an error message - 'There was an error while processing a database query.'
Here is the error -

Critical error

There was an error while processing a database query.

While executing query "INSERT INTO cd2006_albums (category, title, uploads, pos) VALUES ('7', '1440x900', 'NO', '1')" on 0 mySQL error: Field 'description' doesn't have a default value


File: D:\cpg144\include\functions.inc.php - Line: 248


Any ideas? ???
« Last Edit: April 05, 2006, 12:52:10 am by TranzNDance »
Logged

Nibbler

  • Guest
Re: Trouble with adding an album
« Reply #1 on: April 04, 2006, 05:40:56 pm »

What version are you using ? Update to latest stable version, currently 1.4.4
Logged

JCDenton

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Trouble with adding an album
« Reply #2 on: April 04, 2006, 05:45:38 pm »

I have been using the stable version for awhile now. I have had no problems in the past - it is only today that this error occured.

VERSION INFO :
------------------
PHP version: 4.3.10 - OK
------------------
mySQL version: 5.0.19-nt
------------------
Coppermine version: 1.4.4(stable)
Logged

JCDenton

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Trouble with adding an album
« Reply #3 on: April 04, 2006, 11:55:35 pm »

Surfing through the forums I see that someone else is having the exact same difficulty - http://forum.coppermine-gallery.net/index.php?topic=28854.0;topicseen

I have tried checking and repairing all the tables in my database (though I do not think it is a DB issue as all other functions that query the DB seem to update without error)

The only other thing that I can think of is that I restarted my web server this morning - I checked the MYSQL logs though and everything shutdown and came up fine without any error, my Apache logs report everything fine as well. I have not added any new software to my machine or made any configuration changes.

If anyone else has any idea as to what is going on it would be greatly appreciated.
Logged

Nibbler

  • Guest
Re: Trouble with adding an album
« Reply #4 on: April 04, 2006, 11:59:34 pm »

The update script has code to correct that, it that didnt work then run the query manually.

Code: [Select]
ALTER TABLE cd2006_albums CHANGE `description` `description` TEXT NOT NULL default '';
Logged

JCDenton

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Trouble with adding an album
« Reply #5 on: April 05, 2006, 12:05:58 am »

Thanks Nibbler, you are a genious!  That worked perfectly.
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 20 queries.