Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Error message when creating new album  (Read 4243 times)

0 Members and 1 Guest are viewing this topic.

Orlando-D

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 21
Error message when creating new album
« on: March 31, 2007, 05:45:41 pm »

Today I was trying to create a new album in my gallery and I got this error message:

There was an error while processing a database query

Does anyone know what that mean?  ??? I know that it means that is has something to do with my database, but I have no idea what to do?  ??? ???
« Last Edit: April 03, 2007, 08:35:50 am by Sami »
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Error message when creating new album
« Reply #1 on: March 31, 2007, 07:10:06 pm »

enable debug mode and post the actual error message

Orlando-D

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 21
Re: Error message when creating new album
« Reply #2 on: April 01, 2007, 01:28:15 am »

Critical error

There was an error while processing a database query.

Quote
While executing query "INSERT INTO cpg1410_albums (category, title, uploads, pos, description) VALUES ('0', 'Sweet Sacrifice Radio Promo CD', 'NO',  '1', '')" on 0

mySQL error: Unknown column 'uploads' in 'field list'

File: /www/free-site-host.com/a/m/y/amyleerockfaerie/htdocs/Gallery/include/functions.inc.php - Line: 249
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: Error message when creating new album
« Reply #3 on: April 01, 2007, 08:33:48 am »

Post a link to your gallery
Logged
‍I don't answer to PM with support question
Please post your issue to related board

Orlando-D

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 21
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: Error message when creating new album
« Reply #5 on: April 01, 2007, 07:45:49 pm »

Your gallery seems fine,
Try again see if problem solved ;)
Logged
‍I don't answer to PM with support question
Please post your issue to related board

Orlando-D

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 21
Re: Error message when creating new album
« Reply #6 on: April 01, 2007, 09:07:21 pm »

 :( nope......... still the same problem.
Maybe I can PM you the admin info, so you can take a look for yourself? Don't knwo if that would help.
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: Error message when creating new album
« Reply #7 on: April 02, 2007, 12:32:05 am »

gallery admin info is not helpful , you should check your cpg1410_albums table (mysql table) and see if it has the upload column or not , it's not normal !
Logged
‍I don't answer to PM with support question
Please post your issue to related board

Orlando-D

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 21
Re: Error message when creating new album
« Reply #8 on: April 02, 2007, 04:29:01 am »

aha, now I see. No it doesn't I think it may have been deleted by accident. I'm trying to recreate it, or restore, but I have no Idea how to. Maybe I should ask my webhost about this.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Error message when creating new album
« Reply #9 on: April 02, 2007, 08:12:06 am »

If the albums table is not there, you can re-create it using a query like this:
Code: [Select]
CREATE TABLE cpg1410_albums (
  aid int(11) NOT NULL auto_increment,
  title varchar(255) NOT NULL default '',
  description text NOT NULL,
  visibility int(11) NOT NULL default '0',
  uploads enum('YES','NO') NOT NULL default 'NO',
  comments enum('YES','NO') NOT NULL default 'YES',
  votes enum('YES','NO') NOT NULL default 'YES',
  pos int(11) NOT NULL default '0',
  category int(11) NOT NULL default '0',
  thumb int(11) NOT NULL default '0',
  keyword VARCHAR( 50 ),
  alb_password VARCHAR( 32 ),
  alb_password_hint TEXT,
  PRIMARY KEY  (aid),
  KEY alb_category (category)
) TYPE=MyISAM COMMENT='Used to store albums';
Run this query in phpMyAdmin or similar. If you have no idea how to do this, ask your webhost for support.
Logged

Orlando-D

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 21
Re: Error message when creating new album
« Reply #10 on: April 03, 2007, 04:59:58 am »

Thanks a lot. That code is basically what I needed to fix the problem. Thanks a lot.

Problem solved. :)
Logged
Pages: [1]   Go Up
 

Page created in 0.034 seconds with 20 queries.