You are not enjoying the benefits offered by registering. To register click here...
  
Forums | Prefs | Your Messages | Members | Recent | Search
Quick Search


Advanced Search
| Calendar | Doc | Dev' Blog! |
Chat (Alpha Version)

Guest, do not forget to login ( Register )
 Top > Forums > This Software > Support, FAQ, How-to's
 "Create Table" error when installing

Skin Selection:
 (2 pages) 12  
NeoDeGenero


Newbie
Group: Members
Posts: 8
Reputation: 0


Posted on Feb 6, 2008, 8:54 pm by NeoDeGenero
"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*
 
Top

Burning Ice

Local Hero
Group: Testers
Posts: 69
Reputation: 5


Posted on Feb 6, 2008, 11:56 pm by Burning Ice

My dear friend Mr. Google tells me that you need to use the MyISAM table type, seems to be the only one that supports Fulltext indexes...

Read this article to find out more!

Hope this will solve your problem...

Greetz.


You can do it if you really want it... - - - see my testforum (0.5.3)
 
Top

NeoDeGenero


Newbie
Group: Members
Posts: 8
Reputation: 0


Posted on Feb 7, 2008, 12:28 am by NeoDeGenero
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*
 
Top

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..?

 
Top

NeoDeGenero


Newbie
Group: Members
Posts: 8
Reputation: 0


Posted on Feb 9, 2008, 8:35 am by NeoDeGenero
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*
 
Top

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:

  • Open the MySQL configuration file by clicking on the WAMP menu item Config files→my.ini. Modify the following line from
default-storage-engine=INNODB

to

default-storage-engine=MYISAM

Let me know if this solves it ( or not! )

-C.



 
Top

NeoDeGenero


Newbie
Group: Members
Posts: 8
Reputation: 0


Posted on Feb 12, 2008, 8:34 pm by NeoDeGenero

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*
 
Top

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:
php Code:
  1.  
  2. // Security



After, add:
php Code:
  1.  
  2. $TEMPLATE->use_sub_dirs = !ini_get('safe_mode');



Save


Let us know...
 


Last edit by chris on Feb 12, 2008, 9:29 pm

 
Top

justtogetit


Newbie
Group: Members
Posts: 1
Reputation: 0


Posted on Feb 14, 2008, 7:33 am by justtogetit
I'm experiencing the same problem, that E_USER_THINGY i mean. I'm running xampp 1.6.6 on XP SP2. I made the change to index.php but it didn't work. Same error message. I have the problem on both 0.5.0 and nightly build.

I never liked smarties anyway.


Last edit by justtogetit on Feb 14, 2008, 7:41 am
 
Top

NeoDeGenero


Newbie
Group: Members
Posts: 8
Reputation: 0


Posted on Feb 14, 2008, 5:29 pm by NeoDeGenero

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*
 
Top

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:

php Code:
  1. $TEMPLATE->security = TRUE; // Pseudo-safe mode

Replace with:

php Code:
  1. $TEMPLATE->security = FALSE; // Pseudo-safe mode

Let us know... Sorry for the pain.



 
Top

NeoDeGenero


Newbie
Group: Members
Posts: 8
Reputation: 0


Posted on Feb 17, 2008, 5:31 pm by NeoDeGenero

*fingers crossed*
yeah it works! =D

thanks heaps!

 

hmmm, now i got the nested problem when i try to login/register
www.nextbbs.com/do_topic_title_A-few-issues-with-0-5-0_id_1212

ohwellz, i'll figure it out don't worry   =)

thanks again! ^__^


~Look Butterfly! *chases*
 
Top

chris

The Culprit
Group: Admins
Posts: 1,516
Reputation: 38


Posted on Feb 17, 2008, 9:36 pm by chris
Grrr I'll bet it has some connection to how locked up your setup is. Disable the chat for now, I will need to test with WAMP obviously.

 
Top

NeoDeGenero


Newbie
Group: Members
Posts: 8
Reputation: 0


Posted on Feb 19, 2008, 5:02 pm by NeoDeGenero
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*
 
Top

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

 
Top

 (2 pages) 12 - Flat Mode | Threaded Mode  
Quick Jump: