1
meme
snippets bugs
  • 2003/11/23 17:53

  • meme

  • Quite a regular

  • Posts: 271

  • Since: 2002/12/10


hi i use this modules as stories modules i have 127 stories
now when someone send any stories get this msg database error

need help plz


2
meme
Re: snippets bugs
  • 2003/11/23 19:51

  • meme

  • Quite a regular

  • Posts: 271

  • Since: 2002/12/10


catz this your time

3
meme
Re: snippets bugs
  • 2003/11/24 16:27

  • meme

  • Quite a regular

  • Posts: 271

  • Since: 2002/12/10


up

4
CBlue
Re: snippets bugs

Maybe you could copy your exact database error here so someone could know what the problem is and help you, meme.

5
meme
Re: snippets bugs
  • 2003/11/24 16:49

  • meme

  • Quite a regular

  • Posts: 271

  • Since: 2002/12/10


the problem its not from the database
the error from the module when you add any story you will get error msg ( sorry there are an error in database ) then redirect to the form again

i just want know if this module cant work with huge entry

note : i get this problem when the entry get huge about 1 MB

wow i have a big problem now the module now only for showing cant add any entry ( stories ) :(

6
Mithrandir
Re: snippets bugs

hmmm... 127... isn't that the limit for tinyint's? of what type is the database field of the storyID?

7
CBlue
Re: snippets bugs

Is there anyway that you could just archive some of your stories somewhere to free up space in the database to put more stories into?

8
meme
Re: snippets bugs
  • 2003/11/24 20:37

  • meme

  • Quite a regular

  • Posts: 271

  • Since: 2002/12/10


le="color: #000000"><?php CREATE TABLE xoops_snippets ( snippetID tinyint(4) NOT NULL auto_increment, catID tinyint(4) NOT NULL default '0', title varchar(75) NOT NULL default '0', body text NOT NULL, summary text NOT NULL, uid int(6) default '1', submit int(1) NOT NULL default '0', datesub int(11) NOT NULL default '1033141070', counter int(8) unsigned NOT NULL default '0', weight int(11) NOT NULL default '1', groupid varchar(255) NOT NULL default '1 2 3', rating double(6,4) NOT NULL default '0.0000', votes int(11) unsigned NOT NULL default '0', PRIMARY KEY (snippetID), UNIQUE KEY snippetID (snippetID), FULLTEXT KEY body (body) ) TYPE=MyISAM COMMENT='WF-Snippets by hsalazar, after Catzwolf';

do i need to make some fix with this table ?

9
ackbarr
Re: snippets bugs

good catch MithyT2, that's the exact problem.

meme - if you have access to phpmyadmin or the MySQL console try executing this in the XOOPS database:
le="color: #000000"><?php ALTER TABLE xoops_snippets MODIFY snippetID INT NOT NULL auto_increment;

10
meme
Re: snippets bugs
  • 2003/11/24 23:27

  • meme

  • Quite a regular

  • Posts: 271

  • Since: 2002/12/10


ackbarr
thanks it seems work now