Ongoing open beta (1.5.1) - Current Build: 45

[JRCarr]

Thank you, Recounting Boards took care of the problem.  Sometimes I don't think.

[Louis]

Sorry, it doesn't say that in my documentation. (I'll try to change it however.)

I had to do the following modifications (original marked with #) to the yse151.sql for compatibility with MySQL 3.22 - could you pls include this in the next release to ensure compatibility (3.22 doesn't support MyISAM tables and some other useful things):

Code Select Expand


#
# Table structure for table `calendar`
#

CREATE TABLE {$db_prefix}calendar (
#  id int(10) unsigned NOT NULL auto_increment,
 id int(10) unsigned NOT NULL default '0' auto_increment,
 id_board int(10) unsigned NOT NULL default '0',
 id_topic int(10) unsigned NOT NULL default '0',
 title char(30) NOT NULL default '',
 id_member int(10) unsigned NOT NULL default '0',
 month tinyint(4) NOT NULL default '0',
 day tinyint(4) NOT NULL default '0',
 year smallint(6) NOT NULL default '0',
 PRIMARY KEY (id),
 KEY idx_year_month (year, month)
) TYPE=MyISAM;

#
# Table structure for table `calendar_holiday`
#

CREATE TABLE {$db_prefix}calendar_holiday (
#  id int(10) unsigned NOT NULL auto_increment,
 id int(10) unsigned NOT NULL default '0' auto_increment,
 title char(30) NOT NULL default '',
 month tinyint(4) NOT NULL default '0',
 day tinyint(4) NOT NULL default '0',
#  year smallint(6) default NULL,
 year smallint(6) NOT NULL default '',
 PRIMARY KEY (id),
 KEY idx_month (month),
 KEY idx_year (year)
) TYPE=MyISAM;

# ....

#
# Table structure for table `categories`
#

CREATE TABLE {$db_prefix}categories (
#  ID_CAT tinyint(4) NOT NULL auto_increment,
 ID_CAT tinyint(4) NOT NULL default '0' auto_increment,
 name tinytext NOT NULL,
 memberGroups text,
 catOrder tinyint(4) NOT NULL default '0',
 PRIMARY KEY (ID_CAT),
 KEY catOrder (catOrder)
) TYPE=MyISAM;

# .....

#
# Table structure for table `instant_messages`
#

CREATE TABLE {$db_prefix}instant_messages (
 ID_IM bigint(20) NOT NULL auto_increment,
 ID_MEMBER_FROM int(11) NOT NULL default '0',
 ID_MEMBER_TO int(11) NOT NULL default '0',
 deletedBy int(11) NOT NULL default '-1',
 fromName tinytext NOT NULL,
 toName tinytext NOT NULL,
#  msgtime bigint(20) default NULL,
 msgtime bigint(20) NOT NULL default '0',
 subject tinytext,
 body text,
 readBy tinyint(4) NOT NULL default '0',
 PRIMARY KEY (ID_IM),
 KEY ID_MEMBER_FROM (ID_MEMBER_FROM),
 KEY ID_MEMBER_TO (ID_MEMBER_TO),
 KEY deletedBy (deletedBy),
 KEY msgtime (msgtime),
 KEY readBy (readBy)
) TYPE=MyISAM;

# ...

#
# Table structure for table `log_floodcontrol`
#

CREATE TABLE {$db_prefix}log_floodcontrol (
#  ip tinytext NOT NULL,
 ip varchar(16) NOT NULL default '0',
 logTime bigint(20) default NULL,
 PRIMARY KEY (ip(16))
) TYPE=MyISAM;

# ...

#
# Table structure for table `log_online`
#

CREATE TABLE {$db_prefix}log_online (
 identity int(11) unsigned NOT NULL,
#  logTime bigint(20) default NULL,
 logTime bigint(20) NOT NULL default '0',
 KEY logTime (logTime),
 PRIMARY KEY (identity)
) TYPE=MyISAM;

# ...

#
# Table structure for table `members`
#

CREATE TABLE {$db_prefix}members (
 ID_MEMBER int(10) unsigned NOT NULL auto_increment,
 memberName varchar(80) NOT NULL default '',
 realName tinytext,
 passwd tinytext NOT NULL,
 emailAddress tinytext,
#  dateRegistered bigint(20) default NULL,
 dateRegistered bigint(20) NOT NULL default '0',
 personalText tinytext,
#  memberGroup tinytext,
 memberGroup varchar(80) NOT NULL default '',
 gender tinytext,
 birthdate date NOT NULL default '0000-00-00',
 websiteTitle tinytext,
 websiteUrl tinytext,
 location tinytext,
 ICQ tinytext,
 AIM tinytext,
 YIM tinytext,
 hideEmail tinyint(4) default NULL,
 timeFormat tinytext,
 signature text,
#  posts int(11) default NULL,
 posts int(11) NOT NULL default '0',
 timeOffset float default NULL,
 avatar tinytext,
 im_ignore_list text,
 im_email_notify tinyint(4) NOT NULL default '0',
#  lastLogin bigint(20) default NULL,
 lastLogin bigint(20) NOT NULL default '0',
 karmaBad int(11) NOT NULL default '0',
 karmaGood int(11) NOT NULL default '0',
 usertitle tinytext,
#  lngfile tinytext,
 lngfile varchar(30) NOT NULL default '',
 notifyAnnouncements tinyint(4) NOT NULL default '1',
 notifyOnce tinyint(4) NOT NULL default '1',
 MSN tinytext,
 memberIP tinytext,
 secretQuestion tinytext NOT NULL,
 secretAnswer tinytext NOT NULL,
 PRIMARY KEY (ID_MEMBER),
 KEY memberName (memberName(30)),
 KEY dateRegistered (dateRegistered),
 KEY memberGroup (memberGroup(30)),
 KEY birthdate (birthdate),
 KEY posts (posts),
 KEY lastLogin (lastLogin),
 KEY lngfile (lngfile(30))
) TYPE=MyISAM;

# ...

#
# Table structure for table `messages`
#

CREATE TABLE {$db_prefix}messages (
 ID_MSG int(11) NOT NULL auto_increment,
 ID_TOPIC int(11) NOT NULL default '0',
 ID_MEMBER int(11) NOT NULL default '0',
 subject tinytext,
 posterName tinytext NOT NULL,
 posterEmail tinytext,
#  posterTime bigint(20) default NULL,
 posterTime bigint(20) NOT NULL default '0',
 posterIP tinytext NOT NULL,
 smiliesEnabled tinyint(4) NOT NULL default '1',
 modifiedTime bigint(20) default NULL,
 modifiedName tinytext,
 body text,
 icon tinytext,
 attachmentSize mediumint(9) NOT NULL default '0',
 attachmentFilename tinytext,
 PRIMARY KEY (ID_MSG),
 KEY ID_TOPIC (ID_TOPIC),
 KEY ID_MEMBER (ID_MEMBER),
 KEY posterTime (posterTime)
) TYPE=MyISAM;

# ...

#
# Table structure for table `settings`
#

CREATE TABLE {$db_prefix}settings (
#  variable tinytext NOT NULL,
 variable varchar(255) NOT NULL default '',
 value text NOT NULL,
 PRIMARY KEY (variable(30))
) TYPE=MyISAM;


Louis

[MORT]

Thank you, Recounting Boards took care of the problem.  Sometimes I don't think.

Welcome.

[Owdy]

I get lots of these:

Database Error: Lost connection to MySQL server during query
File: /www/int2000/a/*****/html/foorumi/Sources/Security.php
Line: 52

Any ideas?

[SDMR]

The print page function is not dealing with quote tags embedded within messages properly.  Other tags appear to be dealt with fine - it is just quote tags.  The script just output the YABBC quote tags.  And quoting works fine in normal board view.

e.g.

[qu0te author=Seb link=board=3;threadid=165;start=0#msg2038 date=1046438840]

Which is perfectly normal as far as I can tell.  (Obviously the 0 instead of o to stop parsing.)

I'm using build 42 and the board is at http://union.ic.ac.uk/mtsoc/bb5 .

[Zombie]

I have a question...........

I merged 2 topics, 1 topic had a poll.  When the merge finished, I lost the poll.  So I tried to split the topics and the poll was still gone.

Is this normal?  How do you merge 2 topics when 1 has a poll and still keep the poll?

[[Unknown]]

I've fixed the printpage thing in my secret project, but it's so different that I'll have to take a seperate look at the current release's to fix it... hwne I have time.

The next release will fix the merge polls issue.

-[Unknown]

[Owdy]

database backup feature is great. Can u ad restore feature also?

[[Unknown]]

database backup feature is great. Can u ad restore feature also?

Security risk.  If you want, you can request a mod, but I wouldn't dare put such a feature into YaBB SE.

Louis, are you sure there are that many problems?  What is the fully qualified version of your MySQL?

-[Unknown]

[queks]

Is this a bug ?

I cannot go into my IM if i choose to login for 1 hour.

[[Unknown]]

Current Build: 44

http://cbeta.yabbse.org/yabbse_1-5-1RC1B44.zip (use this is you do not have YaBB SE installed yet, and your server is not in safe mode.  Just run install.php after you upload the files.)
http://cbeta.yabbse.org/yabbse_1-5-1RC1B44_upgrade.zip (use this if you have version 1.4.0 through 1.5.0 installed currently.  Just upload the files and then run upgrade.php)
http://cbeta.yabbse.org/yabbse_1-5-1RC1B44_update.zip (use this if you have an older build of RC1 installed at the moment.  Upload all the files, and run the upgrade.php included.)
http://cbeta.yabbse.org/yabbse_1-5-1RC1B43_svenska.zip (use this in addition to an installer if you want to have the svenka language text and images.  Just upload the files.) unchanged since last build.
http://cbeta.yabbse.org/yabbse_1-5-1RC1B43_dutch.zip (use this in addition to an installer if you want to have the dutch language text and images. Just upload the files.) unchanged since last build.

Please understand, the safe mode install is NOT better than the standard install - it is ONLY for if your host has you in SAFE MODE. (which means they are limiting you.)
http://cbeta.yabbse.org/yabbse_1-5-1RC1B44_safe.zip (use this is you do not have YaBB SE installed yet, but your server is in safe mode. Just upload the files, and run install.php)

Some people came upon misplaced images in one of the previous builds.  To fix this, download this zip in addition to the update one above:
http://cbeta.yabbse.org/yabbse_1-5-1RC1B43_update_images.zip

44: (MergeThreads.php, Profile.php, SplitThreads.php, News.php)
- added pages to mergethreads.
- secret question can now have single quotes in it.
- news is now valid xhtml.
- new installer, merged with better error handling.
- split threads works with any subject now.

...

-[Unknown]

[c3uc3]

still having the login cookie problem.
Can't stay login forever.

Everytime I go to another url outside of the forum, when i go back to the forum on the same window, ask me to login again.

Changed cookie name before but it doesn 't work.

How come it works on this YaBB SE forum here?

Any advise?

[Gobalopper]

If Allow Email Notification? is turned off why do users that sign up have the im_email_notify turned on? The same goes for the email notify in the IM preferences, shouldn't it not show the yes option in that case?

[oscar2001]

Just updated to 44 and getting errors
My browser(ie6) just says error at the bottom.

This is what a member using earthlink is getting
Line: 233    Char: 45    Error:    Invalid character    Code: 0     URL: http://www.worldcichlids.com/yabbse/index.php

[oscar2001]

more

"Line:  22,  Char: 1,  Error:,  'bcolor' is unidefined,  Code: 0,  URL: http://www.worldcichlids.com/yabbse/index.php"

"Line: 53,  Char: 2,  Error: 'index' is undefined, Code: 0,  URL: http://www.worldcichlids.com/yabbse/index.php"


This has only happened since I updated from 43 to 44

Sort of reminds me of the errors I got with 1.5 before fixes were applied