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:

CREATE TABLE xoops_debaser_files xfid int(11NOT NULL auto_incrementfilename text NOT NULLadded int(10NOT NULL default ''title varchar(50NOT NULL default ''artist varchar(50NOT NULL default ''album varchar(50NOT NULL default ''year int(4NOT NULL default ''addinfo text NOT NULL default ''track int(3NOT NULL default ''genre varchar(50NOT NULL default ''length varchar(50NOT NULL default ''bitrate varchar(50NOT NULL default ''link varchar(100NOT NULL default ''frequence varchar(50NOT NULL default ''rating double(6,4NOT NULL default '0.0000'votes int(11NOT NULL default '0'approved int(1NOT NULL default '0'fileext varchar(4NOT NULL default ''weight int(10NOT NULL default '0'hits int(11unsigned NOT NULL default '0'views int(11unsigned 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:
mysql_real_escape_string($gid)

into this:
".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 ?

Login

Who's Online

200 user(s) are online (135 user(s) are browsing Support Forums)


Members: 0


Guests: 200


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