|
|
| Viewing: "Create Table" error when installing - |
NeoDeGenero
Newbie
Group: Members
Posts: 8
Reputation: 0

|
|
| |
"Create Table" error when installing
|
Hi, i looked through the first two pages of this support section, and the faq section and couldn't find this problem that i had when i tried to install NextBBS on a test computer (my laptop, using WAMP)
Inserting all required data in the database.
Failure! - Reported Error:
Sorry, unable to run query:
CREATE TABLE `bb_posts` ( `post_ID` int(11) NOT NULL auto_increment, `topic` int(10) default NULL, `post_title` varchar(255) default NULL, `post_description` varchar(255) default NULL, `text` mediumtext, `post_date` int(10) default NULL, `author_id` int(10) default NULL, `author_name` varchar(100) default NULL, `author_edit` varchar(100) default NULL, `post_icon_id` int(10) default NULL, `richtext` tinyint(1) default '0', `server` int(10) default NULL, `trackbacks` int(10) default '0', `from_ip_address` varchar(16) default NULL, `picture` tinyint(1) default '0', `edit_date` int(10) default NULL, PRIMARY KEY (`post_ID`), KEY `topic` (`topic`), KEY `post_date` (`post_date`), KEY `author_id` (`author_id`), KEY `server` (`server`), KEY `trackbacks` (`trackbacks`), KEY `from_ip_address` (`from_ip_address`), KEY `server_topic` (`server`,`topic`), FULLTEXT KEY `post_title` (`post_title`), FULLTEXT KEY `post_title_2` (`post_title`,`text`)) ; |
I then went into phpMyAdmin and attempted to do the query manually:
Error
SQL query:
CREATE TABLE `bb_posts` (
`post_ID` int( 11 ) NOT NULL AUTO_INCREMENT ,
`topic` int( 10 ) default NULL ,
`post_title` varchar( 255 ) default NULL ,
`post_description` varchar( 255 ) default NULL ,
`text` mediumtext,
`post_date` int( 10 ) default NULL ,
`author_id` int( 10 ) default NULL ,
`author_name` varchar( 100 ) default NULL ,
`author_edit` varchar( 100 ) default NULL ,
`post_icon_id` int( 10 ) default NULL ,
`richtext` tinyint( 1 ) default '0',
`server` int( 10 ) default NULL ,
`trackbacks` int( 10 ) default '0',
`from_ip_address` varchar( 16 ) default NULL ,
`picture` tinyint( 1 ) default '0',
`edit_date` int( 10 ) default NULL ,
PRIMARY KEY ( `post_ID` ) ,
KEY `topic` ( `topic` ) ,
KEY `post_date` ( `post_date` ) ,
KEY `author_id` ( `author_id` ) ,
KEY `server` ( `server` ) ,
KEY `trackbacks` ( `trackbacks` ) ,
KEY `from_ip_address` ( `from_ip_address` ) ,
KEY `server_topic` ( `server` , `topic` ) ,
FULLTEXT KEY `post_title` ( `post_title` ) ,
FULLTEXT KEY `post_title_2` ( `post_title` , `text` )
)
MySQL said:
#1214 - The used table type doesn't support FULLTEXT indexes |
According to MySQL's page: dev.mysql.com/doc/refman/5.0/en/error-messages-server.html
Error: 1214 SQLSTATE: HY000 (ER_TABLE_CANT_HANDLE_FT)
Message: The used table type doesn't support FULLTEXT indexes
|
ummmm, help please><
thanks in advanced!
~neo
Last edit by NeoDeGenero on Feb 6, 2008, 8:55 pm
~Look Butterfly! *chases*

|
| |
|
Burning Ice
Local Hero
Group: Testers
Posts: 69
Reputation: 5

|
|
| |
|
NeoDeGenero
Newbie
Group: Members
Posts: 8
Reputation: 0

|
THanks for that Burning Ice =)
ive encountered another problem,
I'm doing this with phpMyAdmin,
Checking my storage engines,
I have MyISAM table type available to me, however, when i click on Server Variable and Settings under table type it says InnoDB.
When i go to the home page and create a blank DB, they are in InnoDB format by default.
I know that query creates a MyISAM table,
[code]CREATE TABLE t (i INT) ENGINE = MYISAM;[/code]
but by default, new tables are created in InnoDB =/
Do you know how do i change this?
Cheers!
~neo
~Look Butterfly! *chases*
|
| |
|

Posted on Feb 8, 2008, 5:18 pm by chris
|
chris
The Culprit
Group: Admins
Posts: 1,516
Reputation: 38

|
Posted on Feb 8, 2008, 5:18 pm by chris
| |
|
Wow what kind of setup do you have?
Typically when you issue a command specifying a given engine and another is used, it means that the engine your requested is not installed.
I have no idea you could even offer MySQL without MyIsam..?
|
| |
|
NeoDeGenero
Newbie
Group: Members
Posts: 8
Reputation: 0

|
ops, forgot to login, there goes my post lol.
Okay, roughly from what i typed, btw me = newb at MySQL, i generally use coldfusion
anyway, i'm using WAMP and installed as their default settings. I did change one thing, iirc, i think it was to enable a rewrite function or something.
I'm not exactly sure about the setup, i went through MySQL's ini file, did a search for table, didn't show up,
so i went through the options in PhpMyAdmin, no luck either
i guess i'll prob have to go bug the people at WAMP,
unless there's other information that i can provide for you guys to work on.
oh btw, thanks for all the help so far! =)
~Look Butterfly! *chases*
|
| |
|

Posted on Feb 12, 2008, 3:01 am by chris
|
chris
The Culprit
Group: Admins
Posts: 1,516
Reputation: 38

|
Posted on Feb 12, 2008, 3:01 am by chris
| |
|
OK here is what Google has taught me so far:
Other people have complained about WAMP not wanting to use MYISAM: www.webdeveloper.com/forum/showthread.php?t=170288
Some people suggesting opening the configuration file and modifying it as follows:
default-storage-engine=INNODB
to
default-storage-engine=MYISAM
Let me know if this solves it ( or not! )
-C.
|
| |
|
NeoDeGenero
Newbie
Group: Members
Posts: 8
Reputation: 0

|
Hi Chris,
edited, restarted services, and yup thanks heaps that works! =)
Oh another problem i encountered is the following,
-
Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file in C:\wamp\www\NextBBS\Core\forums0.5.0\common.php on line 2518
Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file in C:\wamp\www\NextBBS\Core\forums0.5.0\common.php on line 2520
Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of xml_set_object(). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file in C:\wamp\www\NextBBS\Core\forums0.5.0\inputparser.php on line 186
---
WAMP sets it to off by default, easily enabled in php.ini
Just thought i'd let you know =p
*sigh*
you must really hate this n00b now ><
--
| Error type: |
E_USER_WARNING |
| Message: |
Smarty error: (secure mode) accessing "main.tpl" is not allowed |
| Location: |
C:\wamp\www\NextBBS\Core\forums0.5.0\smarty\Smarty.class.php (line: 1083) |
----
this is the one that's buggin me atm
where do i enable this 
~Look Butterfly! *chases*

|
| |
|

Posted on Feb 12, 2008, 9:27 pm by chris
|
chris
The Culprit
Group: Admins
Posts: 1,516
Reputation: 38

|
Posted on Feb 12, 2008, 9:27 pm by chris
| |
|
Oh...what the...? Secure mode? Wow: WAMP is completely locked shut.
OK, try this:
Open index.php in your favourite editor
Find:
After, add:
$TEMPLATE->use_sub_dirs = ! ini_get('safe_mode'); -
|
Save
Let us know...
Last edit by chris on Feb 12, 2008, 9:29 pm
|
| |
|
NeoDeGenero
Newbie
Group: Members
Posts: 8
Reputation: 0

|
Same with justtogetit,
let me try putting WAMP into safe mode. (Without your addition, and with)
1. Without the addition of the code, in WAMP Safe Mode
ie. PHP -> PHP Settings -> Safe Mode
Restart All Servces
| Error type: |
E_WARNING |
| Message: |
mysql_connect() [function.mysql-connect]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) |
| Location: |
C:\wamp\www\NextBBS\Core\forums0.5.0\adodb\drivers\adodb-mysql.inc.php (line: 354) |
huh? i dont have a user called system, okay, i'll try to add a admmin named system.
Okay, added user with all privs, and on any host with no password.
Restart Services *fingers Crossed*
Okay, now i got the original error message:
| Error type: |
E_USER_WARNING |
| Message: |
Smarty error: (secure mode) accessing "main.tpl" is not allowed |
| Location: |
C:\wamp\www\NextBBS\Core\forums0.5.0\smarty\Smarty.class.php (line: 1083) |
2. With the additional code, in PHP safemode
restarting all services
same error message:
| Error type: |
E_USER_WARNING |
| Message: |
Smarty error: (secure mode) accessing "main.tpl" is not allowed |
| Location: |
C:\wamp\www\NextBBS\Core\forums0.5.0\smarty\Smarty.class.php (line: 1083) |
T_______________________T
~Look Butterfly! *chases*

|
| |
|

Posted on Feb 15, 2008, 3:29 am by chris
|
chris
The Culprit
Group: Admins
Posts: 1,516
Reputation: 38

|
Posted on Feb 15, 2008, 3:29 am by chris
| |
|
Oh, my.
OK I think your MySQL issue was unrelated. No idea what it was about.
Regarding your safe mode issue:
Again, open index.php
Search for:
$TEMPLATE->security = TRUE; // Pseudo-safe mode
|
Replace with:
$TEMPLATE->security = FALSE; // Pseudo-safe mode
|
Let us know... Sorry for the pain.
|
| |
|
NeoDeGenero
Newbie
Group: Members
Posts: 8
Reputation: 0

|
|
| |
|

Posted on Feb 17, 2008, 9:36 pm by chris
|
NeoDeGenero
Newbie
Group: Members
Posts: 8
Reputation: 0

|
sorry for all the trouble,
i was just too lazy to install each app/server/hosting software by themselves, WAMP was much easier to manage. =p
~Look Butterfly! *chases*
|
| |
|

Posted on Feb 19, 2008, 8:43 pm by chris
|
chris
The Culprit
Group: Admins
Posts: 1,516
Reputation: 38

|
Posted on Feb 19, 2008, 8:43 pm by chris
| |
|
I just installed it on a test machine in order to try and reproduce the various issues you are seeing and so far I am impressed with the variety of options, especially when it comes to modules(!)
However this has been a rather painful experiment so far: when I open install.php, I see the page's contents because it doesn't recognize the php short tag ("<?") and install.php happens to be the only file where it has not been converted to the long tag ("<?php")
So, I opened the file and modified "<?" to read "<?php" and now I am getting this:
Parse error: syntax error, unexpected $end in C:\wamp\www\nbbs\install.php on line 891
It seems that I am now the one needing help
|
| |
|
Quick Jump:
|
|