1
vimana
Debaser 0.92 installation problem
  • 2006/12/30 21:40

  • vimana

  • Just popping in

  • Posts: 20

  • Since: 2005/1/26


i downloaded debaser 0.92_frankblack. When I try to install it i have this message:

Installing debaser

Invalid default value for 'added'

Unable to install debaser. Error(s):


and i found this in debug mode:

le="color: #000000"><?php CREATE TABLE xoops_debaser_files ( xfid int(11) NOT NULL auto_increment, filename text NOT NULL, added int(10) NOT NULL default '', title varchar(50) NOT NULL default '', artist varchar(50) NOT NULL default '', album varchar(50) NOT NULL default '', year int(4) NOT NULL default '', addinfo text NOT NULL default '', track int(3) NOT NULL default '', genre varchar(50) NOT NULL default '', length varchar(50) NOT NULL default '', bitrate varchar(50) NOT NULL default '', link varchar(100) NOT NULL default '', frequence varchar(50) NOT NULL default '', rating double(6,4) NOT NULL default '0.0000', votes int(11) NOT NULL default '0', approved int(1) NOT NULL default '0', fileext varchar(4) NOT NULL default '', weight int(10) NOT NULL default '0', hits int(11) unsigned NOT NULL default '0', views int(11) unsigned NOT NULL default '0', PRIMARY KEY (xfid) ) TYPE=MyISAM Error number: 1067 Error message: Invalid default value for 'added'


I'm running XOOPS 2.0.16
some time ago I installed debaser on an old site and i didn't have any problem.

I'm not very good in php but maybe someone can help me.
Thanks

2
frankblack
Re: Debaser 0.92 installation problem
  • 2006/12/30 21:44

  • frankblack

  • Just can't stay away

  • Posts: 830

  • Since: 2005/6/13


Edit the sql-file of debaser. Remove default '' where the field's type is int.

3
vimana
Re: Debaser 0.92 installation problem
  • 2006/12/30 21:56

  • vimana

  • Just popping in

  • Posts: 20

  • Since: 2005/1/26


Great thanks now it works
and thanks for the module too it's fantastic

i think maybe it's better upgrade the file at sourceforge.net

cheers

4
corbin
Re: Debaser 0.92 installation problem
  • 2009/6/17 17:43

  • corbin

  • Just popping in

  • Posts: 15

  • Since: 2006/11/28


installing debaser 0.92 on XOOPS 2.3 i got the same problem than supra : so i take every default '' off until the installation seems correct.

now i can upload a file with "single upload", see it working correctly in a pop up with "Show files sorted by categories" but in the public pages, i get "category[1]" but impossible to see it, only this message : "there are currently no files available for this category" !?
(permissions seem correct in system / modules / debaser for the webmaster and in debaser itself)

5
frankblack
Re: Debaser 0.92 installation problem
  • 2009/6/21 10:21

  • frankblack

  • Just can't stay away

  • Posts: 830

  • Since: 2005/6/13


bad,bad,bad debaser.

Edit genre.php and change (about line 55) this:
le="color: #000000"><?php mysql_real_escape_string($gid)

into this:
le="color: #000000"><?php ".mysql_real_escape_string($gid)."


Tip of the day: Did you know that debaser is an ananym? Re-order the characters and you'll get badseer. Don't ask for a serious explanation.

6
corbin
Re: Debaser 0.92 installation problem
  • 2009/6/22 9:15

  • corbin

  • Just popping in

  • Posts: 15

  • Since: 2006/11/28


thank you for your answer.

about the tip, would you mean there is a better one ? ... or it's only a joke ?

7
frankblack
Re: Debaser 0.92 installation problem
  • 2009/6/22 9:34

  • frankblack

  • Just can't stay away

  • Posts: 830

  • Since: 2005/6/13


Just a joke! Happens sometimes if I have to much spare time

8
corbin
Re: Debaser 0.92 installation problem
  • 2009/6/22 10:23

  • corbin

  • Just popping in

  • Posts: 15

  • Since: 2006/11/28


because i tried Video Tube v1.82 and i got problems too !

9
frankblack
Re: Debaser 0.92 installation problem
  • 2009/6/22 10:25

  • frankblack

  • Just can't stay away

  • Posts: 830

  • Since: 2005/6/13


Embedding multimedia is not so easy as it seems to be. Perhaps one day I will release the next version of debaser. It's on the way, but there are a few obstacles...

10
corbin
Re: Debaser 0.92 installation problem
  • 2009/6/22 10:29

  • corbin

  • Just popping in

  • Posts: 15

  • Since: 2006/11/28


.. which are ?

Who's Online

820 user(s) are online (762 user(s) are browsing Support Forums)


Members: 0


Guests: 820


more...

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!

Latest GitHub Commits