1
script_fu
Cd base Optikool Version 1.32 ( Error number: 1054 )

Error number: 1054
Error message: Unknown column 'image_border' in 'field list'

I just installed this version on a Apache Server running Php5, MySQL 5 & XOOPS 2.0.18.1. When I click on Disc Manager to add New Artist this is the error I get above.

I had no problem adding new genre or even modifying them.

Any Ideas???

2
script_fu
Re: Cd base Optikool Version 1.32 ( Error number: 1054 )

I have a feeling that the error is in the sql file for the module. Do you see anything wrong with this?

# phpMyAdmin MySQL-Dump
# version 2.4.0
# http://www.phpmyadmin.net/ (download page)
#
# Server: localhost
# Date: 04-05-2003 00:28:51
# Version: 3.23.54
# Version PHP: 4.3.0
# Version Xoops: XOOPS 2.0
# --------------------------------------------------------

#
# Structure table for `cdbase_artists`
#

CREATE TABLE cdbase_artists (
  
id_art int(10unsigned NOT NULL auto_increment,
  
artist varchar(255) default NULL,
  
date_of_birth varchar(255) default NULL,
  
place_of_birth varchar(255) default NULL,
  
ethnic varchar(255) default NULL,
  
bio text,
  
image varchar(250) default NULL,
  
dropcap varchar(3),
  
dateadd int(10) default '0',
  
genre int(11unsigned default NULL,
  
url varchar(250) default NULL,
  
url_target varchar(5) default NULL,
  
similar varchar(250) default NULL,
  
gallery varchar(250) default NULL,
  
gallery_desc varchar(250) default NULL,
  
gallery_target varchar(5) default NULL,
  
movies varchar(250) default NULL,
  
movies_desc varchar(250) default NULL,
  
movies_target varchar(5) default NULL,
  
votes int(10unsigned NOT NULL default '0',
  
rating int(10unsigned NOT NULL default '0',
  
PRIMARY KEY  (id_art)
TYPE=MyISAM;
# --------------------------------------------------------

#
# Structure table for `cdbase_discs`
#

CREATE TABLE cdbase_discs (
  
id int(10unsigned NOT NULL auto_increment,
  
id_art int(10unsigned default NULL,
  
album varchar(255) default NULL,
  
image varchar(150) default NULL,
  
image_big varchar(150NOT NULL default '',
  
image2 varchar(150NOT NULL default '',
  
image2_big varchar(150NOT NULL default '',
  
year varchar(4) default NULL,
  
seal varchar(50) default NULL,
  
description text,
  
dateadd int(10) default NULL,
  
url_buy varchar(250) default NULL,
  
votes int(10unsigned NOT NULL default '0',
  
rating int(10unsigned NOT NULL default '0',
  
PRIMARY KEY (id)
TYPE=MyISAM;
# --------------------------------------------------------

#
# Structure table for `cdbase_gens`
#

CREATE TABLE cdbase_gens (
  
id_gen int(11unsigned NOT NULL auto_increment,
  
des varchar(100NOT NULL default '',
  
PRIMARY KEY  (id_gen)
TYPE=MyISAM;
# --------------------------------------------------------

#
# Base genre `cdbase_gens`
#

INSERT INTO cdbase_gens VALUES (1'General');

#
# Structure table for `cdbase_lyrics`
#

CREATE TABLE cdbase_lyrics (
  
id int(10unsigned NOT NULL auto_increment,
  
id_disc int(10unsigned NOT NULL default '0',
  
id_art int(10unsigned NOT NULL default '0',
  
num int(10unsigned NOT NULL default '0',
  
title varchar(250NOT NULL default '',
  
text text NOT NULL,
  
mp3 varchar(250NOT NULL default '',
  
PRIMARY KEY  (id),
  
KEY id_disc (id_disc)
TYPE=MyISAM;

3
optikool
Re: Cd base Optikool Version 1.32 ( Error number: 1054 )
  • 2008/7/17 16:05

  • optikool

  • Not too shy to talk

  • Posts: 154

  • Since: 2007/3/26


script_fu,

If you haven't already done so, modify cdbase_artist table and add the following...

`image_border` char(3) default NULL,

Hope this fixes your problem.

Optikool

4
Anonymous
Re: Cd base Optikool Version 1.32 ( Error number: 1054 )
  • 2010/9/5 8:26

  • Anonymous

  • Posts: 0

  • Since:


Can someone tell me where I can download this version of CDbase??

Is there a more recent version or better alternative available?

5
ghia
Re: Cd base Optikool Version 1.32 ( Error number: 1054 )
  • 2010/9/5 9:02

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


(for the PHP savvy) On Giorgione's Site

Login

Who's Online

224 user(s) are online (142 user(s) are browsing Support Forums)


Members: 0


Guests: 224


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits