XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Modules Support forums / 
  3. Module troubleshooting 
  4.  / Cd base Optikool Version 1.32 ( Error number: 1054 )
Register
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?

le="color: #000000"><?php # 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(10) unsigned 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(11) unsigned 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(10) unsigned NOT NULL default '0', rating int(10) unsigned NOT NULL default '0', PRIMARY KEY (id_art) ) TYPE=MyISAM; # -------------------------------------------------------- # # Structure table for `cdbase_discs` # CREATE TABLE cdbase_discs ( id int(10) unsigned NOT NULL auto_increment, id_art int(10) unsigned default NULL, album varchar(255) default NULL, image varchar(150) default NULL, image_big varchar(150) NOT NULL default '', image2 varchar(150) NOT NULL default '', image2_big varchar(150) NOT 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(10) unsigned NOT NULL default '0', rating int(10) unsigned NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM; # -------------------------------------------------------- # # Structure table for `cdbase_gens` # CREATE TABLE cdbase_gens ( id_gen int(11) unsigned NOT NULL auto_increment, des varchar(100) NOT 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(10) unsigned NOT NULL auto_increment, id_disc int(10) unsigned NOT NULL default '0', id_art int(10) unsigned NOT NULL default '0', num int(10) unsigned NOT NULL default '0', title varchar(250) NOT NULL default '', text text NOT NULL, mp3 varchar(250) NOT 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: 0


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

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Donat-O-Meter

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