UseBB Community

The official board for UseBB help and discussion

• UseBB Community » UseBB Announcements » UseBook 0.1 Released

UseBook 0.1 Released

Page: 1

Author Post
Samuel
#1 Sat May 21, 2005 8:30 am
Member
Registered: Apr 2004
Posts: 192
Location: Brussels Belgium
Good news, Usebook 0.1 just got released today. This version is not functional and may contain bugs and security flaws, thats why it is very important that you report any error you get so that I can solve the problem for the release of 0.2. Test the software on your machine and play around with the settings a bit so that we can find every bug before the functional 0.2 release plannend some time next month.

Please do not test this version in a public environment
_______________
« Last edit by Samuel on Sat May 21, 2005 10:29 am. »
Samuel
#2 Sat May 21, 2005 10:29 am
Member
Registered: Apr 2004
Posts: 192
Location: Brussels Belgium
Released : http://sourceforge.net/project/showfiles.php?group_id=139968&package_id=153521&release_id=330643
_______________
« Last edit by Dietrich on Sat Jun 04, 2005 10:37 pm. »
angro
#3 Sun May 22, 2005 3:31 pm
Member
Registered: Apr 2005
Posts: 75
Location: turnhout
In your SQL statement I have to delete the part 


 ENGINE=MyISAM DEFAULT CHARSET=latin1
.

Myphpadmin seems not to accept it. Table is by default MyIsam, Charset ??


Where do you want such items announced ? Here or in the usebook forum or in the bug part ?
Dietrich
#4 Sun May 22, 2005 4:34 pm
Developer
Registered: Apr 2004
Posts: 2202
Location: Belgium
angro wrote
In your SQL statement I have to delete the part 


 ENGINE=MyISAM DEFAULT CHARSET=latin1
.

Myphpadmin seems not to accept it. Table is by default MyIsam, Charset ??

I believe that part is from MySQL 4.1/5.0. It should not be in the file.
_______________
--Dietrich (developer)
UseBB roadmap, dev mailing list & weblog
bastya_elvtars
#5 Mon May 23, 2005 2:53 am
Member
Registered: Mar 2005
Posts: 196
Location: Hungary
This is a known issue, an incompatibility between MySQL 4.0 and 4.1
_______________
Long Live Rock n' Roll!
angro
#6 Mon May 23, 2005 6:12 am
Member
Registered: Apr 2005
Posts: 75
Location: turnhout
bastya_elvtars wrote
This is a known issue, an incompatibility between MySQL 4.0 and 4.1


If so, I propose to Kidkiler to have two sql statements in the version. Don't know if it is needed for sql4.1, if not, work like 4.0
_______________
Always Looking to the Bright Side of Life but also the Dark side of the Moon ;)
Dietrich
#7 Mon May 23, 2005 11:00 am
Developer
Registered: Apr 2004
Posts: 2202
Location: Belgium
I guess the CREATE TABLE query for MySQL 3.23 will also work on 4.0 and 4.1?

As with UseBB, MySQL 3.23 is the minimal requirement (and it works, I've tested it with 3.23), and it should be for UseBook too.
_______________
--Dietrich (developer)
UseBB roadmap, dev mailing list & weblog
bastya_elvtars
#8 Mon May 23, 2005 12:27 pm
Member
Registered: Mar 2005
Posts: 196
Location: Hungary
angro wrote
bastya_elvtars wrote
This is a known issue, an incompatibility between MySQL 4.0 and 4.1


If so, I propose to Kidkiler to have two sql statements in the version. Don't know if it is needed for sql4.1, if not, work like 4.0


It can be exported with latest versions of myadmin. Dunno how, please search for this message on Google. You have to tick something, I remember. :P
_______________
Long Live Rock n' Roll!
Samuel
#9 Mon May 23, 2005 2:58 pm
Member
Registered: Apr 2004
Posts: 192
Location: Brussels Belgium
Fixed in CVS, just remove the "DEFAULT CHARSET=latin1"
_______________
Dietrich
#10 Mon May 23, 2005 3:00 pm
Developer
Registered: Apr 2004
Posts: 2202
Location: Belgium
Does it still work on MySQL 3.23?
_______________
--Dietrich (developer)
UseBB roadmap, dev mailing list & weblog
angro
#11 Mon May 23, 2005 3:04 pm
Member
Registered: Apr 2005
Posts: 75
Location: turnhout
Quote
SQL-query :

CREATE TABLE `usebook_login` (
`admin` varchar(50) NOT NULL default '',
`ip` varchar(15) NOT NULL default '',
`time` int(10) NOT NULL default '0'
) ENGINE=MyISAM

MySQL said:

You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 5

Back


just tested, not enough, we have to delete myisam too
_______________
Always Looking to the Bright Side of Life but also the Dark side of the Moon ;)
Samuel
#12 Mon May 23, 2005 3:05 pm
Member
Registered: Apr 2004
Posts: 192
Location: Brussels Belgium
Make sure you dont delete the ";", I think thats the part causing trouble.
_______________
angro
#13 Mon May 23, 2005 3:06 pm
Member
Registered: Apr 2005
Posts: 75
Location: turnhout
Quote
Your SQL-query has been executed successfully
SQL-query :
CREATE TABLE `usebook_login` (
`admin` varchar(50) NOT NULL default '',
`ip` varchar(15) NOT NULL default '',
`time` int(10) NOT NULL default '0'
) ;
CREATE TABLE `usebook_posts` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(15) NOT NULL default '',
`mail` varchar(55) NOT NULL default '',
`site` varchar(75) NOT NULL default '',
`post` text NOT NULL,
`date` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ;


worked well
_______________
Always Looking to the Bright Side of Life but also the Dark side of the Moon ;)
angro
#14 Mon May 23, 2005 3:07 pm
Member
Registered: Apr 2005
Posts: 75
Location: turnhout
Kidkiller wrote
Make sure you dont delete the ";", I think thats the part causing trouble.



I thought so myself, but tested it agian, didn't work out, last time it did, see my post above
_______________
Always Looking to the Bright Side of Life but also the Dark side of the Moon ;)
Samuel
#15 Mon May 23, 2005 3:12 pm
Member
Registered: Apr 2004
Posts: 192
Location: Brussels Belgium
fixed again :) lol
thanks for the help
_______________
Dietrich
#16 Mon May 23, 2005 3:35 pm
Developer
Registered: Apr 2004
Posts: 2202
Location: Belgium
In MySQL 4.1 they use ENGINE, replacing with TYPE should work.
TYPE=MyISAM;
_______________
--Dietrich (developer)
UseBB roadmap, dev mailing list & weblog
angro
#17 Thu May 26, 2005 5:58 pm
Member
Registered: Apr 2005
Posts: 75
Location: turnhout
Quote
In MySQL 4.1 they use ENGINE, replacing with TYPE should work.


I tried it out on MySQL 3.23.54

Quote
Your SQL-query has been executed successfully
SQL-query :
CREATE TABLE `usebook_login` (
`admin` varchar(50) NOT NULL default '',
`ip` varchar(15) NOT NULL default '',
`time` int(10) NOT NULL default '0'
) TYPE=MyISAM;
CREATE TABLE `usebook_posts` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(15) NOT NULL default '',
`mail` varchar(55) NOT NULL default '',
`site` varchar(75) NOT NULL default '',
`post` text NOT NULL,
`date` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
_______________
Always Looking to the Bright Side of Life but also the Dark side of the Moon ;)

Page: 1

• UseBB Community » UseBB Announcements » UseBook 0.1 Released

UseBB Community is powered by UseBB 1 Forum Software