|
Joined: Oct 2007
Posts: 54 Likes: 2
Journeyman
|
Journeyman
Joined: Oct 2007
Posts: 54 Likes: 2 |
Hello, I try to install UBB.Threads 7.4. But I become this Error: UBB Message We encountered a problem. The reason reported was
Script: Line#: SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 37 SQL Error #: 1064 Query: create table ubbt_FORUMS ( FORUM_TITLE text, FORUM_DESCRIPTION text, FORUM_ID int(9) unsigned auto_increment primary key, FORUM_PARENT int(9) unsigned, FORUM_POSTS int(9) unsigned default '0', FORUM_LAST_POST_TIME int(11) unsigned, FORUM_CREATED_ON int(11) unsigned, FORUM_IS_MODERATED tinyint(1) unsigned default '0', CATEGORY_ID int(4) unsigned default '1' not null, FORUM_TOPICS int(9) unsigned default '0', FORUM_SORT_ORDER int(4) unsigned, FORUM_DEFAULT_TOPIC_AGE int(4) unsigned, FORUM_CUSTOM_HEADER int(1) unsigned, FORUM_STYLE mediumint(4) not null default '0', FORUM_LAST_POST_ID int(9) unsigned default '0', FORUM_LAST_TOPIC_ID int(9) unsigned, FORUM_LAST_POSTER_ID int(9) default '1', FORUM_LAST_POSTER_NAME varchar(64), FORUM_LAST_POST_SUBJECT text, FORUM_LAST_POST_ICON varchar(30), FORUM_IMAGE varchar(255), FORUM_IS_ACTIVE tinyint(1) default '1' not null, FORUM_ISLAND_INSERT mediumint(5) not null default '0', FORUM_IS_RSS tinyint(1) not null default '0', FORUM_RSS_TITLE varchar(255), FORUM_SHOW_INTRO tinyint(1) not null default '0', FORUM_INTRO_TITLE varchar(255), FORUM_IS_TEASER tinyint(1) not null default '0', FORUM_IS_GALLERY tinyint(1) not null default '0', FORUM_ACTIVE_POSTS tinyint(1) default '1', FORUM_POSTS_COUNT tinyint(1) default '1', FORUM_SORT_FIELD varchar(10), FORUM_SORT_DIR varchar(4), INDEX CAT_NDX (CATEGORY_ID), INDEX ACTIVE_NDX (FORUM_IS_ACTIVE) ) TYPE=MyISAM
Please click back to return to the previous page. I use PHP 5.3 and MySQL 5.3.34 Can you help me please? Thank you.
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
1. install 7.5.8, instead 2. if you MUST do ubb 7.4, edit instal/createtable.php ( replace TYPE= with ENGINE= )
|
|
|
|
Joined: Oct 2007
Posts: 54 Likes: 2
Journeyman
|
Journeyman
Joined: Oct 2007
Posts: 54 Likes: 2 |
1. install 7.5.8, instead I have only access until 7.4. 2. if you MUST do ubb 7.4, edit instal/createtable.php ( replace TYPE= with ENGINE= ) It works thank you for help me.
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
7.4 has security problems. you can get hacked.
|
|
|
|
Joined: Oct 2007
Posts: 54 Likes: 2
Journeyman
|
Journeyman
Joined: Oct 2007
Posts: 54 Likes: 2 |
And wich version is safe (until 7.4)? Or I have to do buy a new license?
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
get 7.5.8
essentially, anything less than 7.5.7 is insecure
why invite hackers?
|
|
|
|
Joined: Jun 2006
Posts: 16,300 Likes: 116
|
Joined: Jun 2006
Posts: 16,300 Likes: 116 |
Bugs and Security Patches (not to mention feature changes and additions) are added in each version; the latest version is the only one without any identified security issues.
|
|
|
|
Joined: Oct 2007
Posts: 54 Likes: 2
Journeyman
|
Journeyman
Joined: Oct 2007
Posts: 54 Likes: 2 |
Ok, thank you. I have now purchase access to updates for the next year and make update to 7.5.8 now.
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
Good move
|
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
|