search for: in: entire forum this post
you are here: root => Installing the Nodesforum => Installation Support => Errors installing
page 1 of 4 | next
member since:
folders:
0
posts:
1
replies:
1

Errors installing

I cannot create the tables i get this error:

there was an error when attempting to create a table named _nodesforum_folders_and_posts.

what's up?
post #22 permalink
please login to reply
member since:
folders:
10
posts:
22
replies:
75
Hi and thank you for trying to install my forum.

turns out there was a problem in the auto-installer script that has occured in a previous fix (1.014)

i went ahead and attempted to install the forum on a new site and got the same problem, looked into the table installer script and found the problem and fixed it. fix is available in 1.019

sorry about that. pls grab 1.019 and try again

and thanks for warning me about this!

wassaa


test: test
post #25 permalink
a guest
Thanks for the quick response

Version 1.019 did create the tables.

However i'm still getting all this:

Notice: Undefined variable: _nodesforum_edit_creation_time in /Users/anunes/Sites/SPVOO/modules/nodesforum/pre_else.php on line 1095

Notice: Undefined index: ghost in /Users/anunes/Sites/SPVOO/modules/nodesforum/pre_folder_view​.php on line 19

Notice: Undefined variable: remember_parent_titles in /Users/anunes/Sites/SPVOO/modules/nodesforum/pre_folder_view​.php on line 151

Notice: Undefined variable: countadd in /Users/anunes/Sites/SPVOO/modules/nodesforum/pre_folder_view​.php on line 165

Notice: Undefined variable: _nodesforum_creator_publicname in /Users/anunes/Sites/SPVOO/modules/nodesforum/pre_folder_view​.php on line 193
forum options | my forum page | my posting history | moderation on my things

Notice: Undefined index: _nodesforum_search in /Users/anunes/Sites/SPVOO/modules/nodesforum/body.php on line 81

Notice: Undefined variable: _nodesforum_display_fapID in /Users/anunes/Sites/SPVOO/modules/nodesforum/bod_folder_view​.php on line 62
empty

Notice: Undefined index: _nodesforum_moderated_uniqueID in /Users/anunes/Sites/SPVOO/modules/nodesforum/bod_mod_forms.p​hp on line 82

Notice: Undefined index: _nodesforum_moderated_given_level in /Users/anunes/Sites/SPVOO/modules/nodesforum/bod_mod_forms.p​hp on line 84

Notice: Undefined variable: _nodesforum_display_banned_uniqueID in /Users/anunes/Sites/SPVOO/modules/nodesforum/bod_mod_forms.p​hp on line 193

Notice: Undefined index: _nodesforum_banned_uniqueID in /Users/anunes/Sites/SPVOO/modules/nodesforum/bod_mod_forms.p​hp on line 233

Notice: Undefined index: _nodesforum_banned_reason in /Users/anunes/Sites/SPVOO/modules/nodesforum/bod_mod_forms.p​hp on line 235

Notice: Undefined index: _nodesforum_delete_user in /Users/anunes/Sites/SPVOO/modules/nodesforum/bod_mod_forms.p​hp on line 262

Notice: Undefined variable: _nodesforum_display_banned_ip_ip in /Users/anunes/Sites/SPVOO/modules/nodesforum/bod_mod_forms.p​hp on line 279

Notice: Undefined index: _nodesforum_banned_ip in /Users/anunes/Sites/SPVOO/modules/nodesforum/bod_mod_forms.p​hp on line 321

Notice: Undefined index: _nodesforum_banned_ip_reason in /Users/anunes/Sites/SPVOO/modules/nodesforum/bod_mod_forms.p​hp on line 323

Notice: Undefined index: _nodesforum_delete_ip in /Users/anunes/Sites/SPVOO/modules/nodesforum/bod_mod_forms.p​hp on line 353


can you help??
Thanks
post #28 permalink
member since:
folders:
0
posts:
1
replies:
1
Is there an easy way to translate the forum to other languages?
post #29 permalink
member since:
folders:
10
posts:
22
replies:
75
Hi

about languages, im planning to make the french version for 2.0 sometime soon. for other languages im gonna need help though cos i only speak french and english at the moment...

but before i can use help with other languages i want to make the french version first because at this point im gonna make the language system, after it will be easy for a non-programmer to add more languages. maybe with luck some ppl might volunteer to make other languages. if not maybe trying to hire a translator. but at the moment im concentrating on building the "free hosted forum system" (i got my plan and it should be ready in a few days)...

-----------------

about these error messages you get i see that they are all notices of undeclared variable...

i guess what happens is that on all my servers (i have multiple websites scattered over 4 servers) i have these notices turned off so i never seen them and always freely compared undeclared variables without knowing that this caused a "notice"...

but i am guessing that the forum should work correctly under these errors right? (well assuming that you figured out the little twist that you have to first register a user and then put this user's uniqueID in your config.php to start administrating your forum...)


so anyways i think you can turn off these errors by changing the config of your php so that all these "notices" dont show.

but if you dont want to play with your php config i think theres a way to disable these notices from the code, so im gonna go ahead and look into how i can do that and try to add it to the forum script so we can get rid of these notices without requiring the user to change his php config.

wassaa


test: test
post #30 permalink
member since:
folders:
10
posts:
22
replies:
75
http://php.net/manual/en/errorfunc.configuration.php
http://www.php.net/manual/en/function.error-reporting.php

quote
in PHP 4 and PHP 5 the default value is E_ALL & E_NOTICE. This setting does not show E_NOTICE level errors. You may want to show them during development.
source: http://php.net/manual/en/errorfunc.configuration.php


quote
// Report all errors except E_NOTICE
// This is the default value set in php.ini
error_reporting(E_ALL ^ E_NOTICE);
source: http://www.php.net/manual/en/function.error-reporting.php

wassaa


test: test
post #31 permalink
member since:
folders:
10
posts:
22
replies:
75
so i have added a

code:
error_reporting(E_ALL ^ E_NOTICE);



at the beginning of the file pre_output.php and that should take care of the problem

i tested the new fix by adding a
code:
error_reporting(E_ALL);


at the top of the file on which i am including the development version of the forum; and that did make the forum show me all the notices that you are reporting.

then i added the
code:
error_reporting(E_ALL ^ E_NOTICE);


at the beginning of the pre_output.php file and the notices were gone.

i packed this little change in version 1.020 which is now available from the homepage

once again, thanks a lot for your useful feedback.

wassaa


test: test
post #32 permalink
a guest
I don't think its good programming practice to turn off error reporting but until i have time to check it further i used:
error_reporting(0)

And now i have another problem: Can't create forums or folders, no error the links just don't show up.

I would love to use your forum its the first one i used that can use my own user sys.


post #33 permalink
member since:
folders:
10
posts:
22
replies:
75
also instead of
code:
doing error_reporting(0);



you could just do
code:
error_reporting(E_ALL ^ E_NOTICE);



that will leave errors on but just turn off notices

as they say on this page: http://php.net/manual/en/errorfunc.configuration.php that is the default for php 4 and 5

wassaa


test: test
post #35 permalink
member since:
folders:
10
posts:
22
replies:
75
ok, to use the forum with your site's user system you gotta make sure of a few things

in the config.php
$_nodesforum_external_user_system_uniqueID_session_name must contain the name of the session variable in which you keep track of your users

so if for example you keep track of you users with a session variable like $_SESSION['userID'] then the variable $_nodesforum_external_user_system_uniqueID_session_name must contain "userID"

like this
code:
$_nodesforum_external_user_system_uniqueID_session_name='userID';




also note that if you use your own sites user system, the forum is gonna assume that you take care of starting the session yourself, so make sure that you include at least a
code:
session_start();


at the top of your page, and then you can also run any script that you normally run to deal with your user accounts if you have any (...script to auto login people from a cookie, script to logout banned users ect..)
then place the
code:
include('forumfolder/config.php');
include('forumfolder/pre_output.php');


after that



also in the config.php, $_nodesforum_external_user_system_table_name must contain the name of the table in which you keep your users information, it can be in a different database but it must be physically on the same server
example
code:
$_nodesforum_external_user_system_table_name='myuserstable';




$_nodesforum_external_user_system_user_uniqueID_rowname must contain the name of the column in your users table that contains the uniqueID of a user

$_nodesforum_external_user_system_publicname_rowname must contain the name of the column that contains the name for display of the user

and $_nodesforum_main_mod_uniqueID must contain the uniqueID of your user account on your site.

then you must login with your user account and go on the forum (make sure you have placed that
code:
session_start();

on the page of your forum)

also depending on what you want you can just include the header of your site on top of the forum (before the
code:
include('forumfolder/body.php');

). then you will want to chose "no" at $_nodesforum_show_login_logout_bar.

or alternatively you can chose "yes" at $_nodesforum_show_login_logout_bar and the forum will show its own login/logout menu on top, but since you are using your site's user system the register, login/logout links will point to your register login/logout pages and for that you must make sure to set these variables correctly on the config.php


code:
$_nodesforum_external_user_system_loginusername_session_name=''; //what is the name of the php session variable in which you keep the username or email that the user logged in with to be able to say "logged in as..."
$_nodesforum_external_user_system_login_link='/login'; //link to your login page from the forum
$_nodesforum_external_user_system_logout_link='/logout'; //link to your logout page from the forum
$_nodesforum_external_user_system_register_link='/register'; //link to your register page from the forum
$_nodesforum_external_user_system_profile_options_link='/options'; //link for logged in user to get to his profile options page from the forum





----------------

a little trick to help you figure out what is wrong, is it that you didnt specify your values correctly in config.php or is it that the forum is unable to find the SESSION of your user?

if you have set your variables correctly in config.php (including $_nodesforum_main_mod_uniqueID) the forum should show the name of your account on your site as the "moderator of this folder" on the root

if the name down there appears empty then either it is not reading your users table correctly (double check $_nodesforum_external_user_system_table_name, $_nodesforum_external_user_system_user_uniqueID_rowname and $_nodesforum_external_user_system_publicname_rowname) or either the uniqueID of the main mod is not correct (double check $_nodesforum_main_mod_uniqueID)

if the moderator thing down there show the name of your profile on your site but you dont have main moderator powers while beeing on the forum make sure that the user session is started on the page of the forum, that the unique indentifier of your user is set on a session variable and that the name of that session variable is set as $_nodesforum_external_user_system_uniqueID_session_name in the config

wassaa


test: test
post #37 permalink
member since:
folders:
10
posts:
22
replies:
75
here are some example of sites that are running the nodesforum working with their own user system

http://2meet4free.com/forum
http://globolister.com/forum
http://forum.videolister.org/

wassaa


test: test
post #38 permalink
member since:
folders:
10
posts:
22
replies:
75
im not 100% sure but i suspect that if you have set everything right in your config.php and you are logged in as you on your site already, the problem might just be that you did not include a
code:
session_start();

on top of your page.

the forum when working with your site user system assumes that you will take care of starting your session yourself, possibly do some verification/run scripts on it/maybe run an auto login from the cookies

and then after that include the forum

but at the very least you must at least start the session on top of the page in which you include the forum

also probably if you want to use your site's user system you might probably also want to show the same "header" (navigation menu) on top of the forum page than on top of the rest of the pages of your forum. every site is different but me on most of my site the login/logout links are usually located in this header. if your login/logout links are not in this header or you will not show your header then just set $_nodesforum_show_login_logout_bar='yes'; (which is already the default) to use the login/logout bar of the forum

wassaa


test: test
post #39 permalink
member since:
folders:
10
posts:
22
replies:
75
example of including the forum on a page and working with your site's user system:

code:
<?php
session_start();
//run any session related scripts here... auto-login from cookie? logout banned? record user's last pageload?...

include('nodesforum_folder/config.php');
include('nodesforum_folder/pre_output.php');

echo '<html>
<head>
<title>'.$_nodesforum_title.'</title>
</head>
<body>';
//display site header here, top and left side ads, ect...

include('nodesforum_folder/body.php');

//display page bottom here, right side and bottom ads, ect...
echo '</body>
</html>';
?>


wassaa


test: test
post #40 permalink
member since:
folders:
1
posts:
2
replies:
10
I have tried everything above but still having trouble.

I have it set $_nodesforum_use_external_user_system='yes';

My username shows up in the button as moderator but I still don't have moderator powers.
I tried with two different databases with the same results.

Here is what I have
code:
//-----------EXTERNAL USER SYSTEM SETTINGS (only needed if $_nodesforum_use_external_user_system=='yes')
$_nodesforum_external_user_system_site_name='The name of my site'; //the name of the main website from which we are using the user system
$_nodesforum_external_user_system_site_name_at_or_at_the='The name of my site'; //should we say at *main site name* or at the *main site name*
$_nodesforum_external_user_system_uniqueID_session_name='user_id'; //name of the php session variable in which you keep track of your users uniqueID
$_nodesforum_external_user_system_table_name='users'; //name of the users table
$_nodesforum_external_user_system_user_uniqueID_rowname='user_id'; //name of the column in which you store the users uniqueID in your users table
$_nodesforum_external_user_system_publicname_rowname='username'; //name of the column in which you store the users name or public name in your users table
$_nodesforum_external_user_system_show_registration_time='yes'; //does your users table contain a column where the registration time of the user is recorded (in unix timestamp format)
$_nodesforum_external_user_system_registration_time_rowname='reg_date'; //if yes what is the name of the column where the registration time of the user is recorded
$_nodesforum_external_user_system_userpage_link='/userpage?u='; //how should we build the links to the user pages on your main site (will take the value in this variable and will append the user uniqueID to it to build the link to the userpage)



To find out what the uniqueID_session_name was I opened a file that required me to be logged in and found this in the file.
quote
$session->value('user_id')

So I used it for both uniqueID_session_name and user_uniqueID_rowname.

Can you see anything that I may be doing wrong?
post #54 permalink
member since:
folders:
10
posts:
22
replies:
75
Hi oldreb.

thanks for trying out my script.

so according to what you are telling me i can see that the forum is correctly communicating with your users table because it got the right person and can read the name.

it looks like the problem has something to do with the session.

maybe it does not get started correctly on the page where you have your forum, or the name might not be user_id.

to troubleshoot that i suggest that you add a

code:
print_r($_SESSION);



at the bottom of a random page of your site where the login is working and also at the bottom of the page where the forum is included (if you are not including the forum in a page then that would be the index.php that is contained in the forum files).

this will allow you too see the session data that is following you and you will see right away all the names of the session variables and if they are following you on the page of the forum.

please let me know if this helps.

wassaa


test: test
post #55 permalink
member since:
folders:
1
posts:
2
replies:
10
Okay that did the trick.
What it was was that I needed to include the prefix.
So it had to be like this prefix_user_id.

Now it works great.
Thank you.

One more question do you mind if I change the looks of it around a little?

Thanks again
post #56 permalink
member since:
folders:
10
posts:
22
replies:
75
no i dont mind you can do what you want with the script.

if you come up with any improvements in the design id be interested in seeing.

glad to hear that you got it working.

be aware this is really a first version and theres a bunch of features and improvements to come in the future from my part too

wassaa


test: test
post #57 permalink
member since:
folders:
0
posts:
0
replies:
27
hi thanks for the time you have put in to this free forum im having a problem and getting the following error message

the connection to the database was successful but the query to read the posts and folders in your forum did not work. this could possibly be because you have not yet created the tables to run the forum..

this forum is trying to read the set of tables starting with "forum1_" which was not successful.

............and

there was an error when attempting to create a table named forum1__nodesforum_folders_and_posts.

error:
The used table type doesn't support FULLTEXT indexes

create new empty tables starting with "forum1_"





i have tried both with and without my sites own login/registration i get the same problem.

i have tried onndb & myisam database engine with the same affect

can you please help php and mysql is jsut out of my comfort zone

thanks

Recycling is Good for You Me and Our Planet.

Visit the Recycle Me Free website www.recyclemefree.com and take 5 minutes to think how you can help our planet.
post #61 permalink
member since:
folders:
10
posts:
22
replies:
75
assuming that your MySQL is version at least 3.23.23.

http://onlamp.com/pub/a/onlamp/2003/06/26/fulltext.html
http://forums.mysql.com/read.php?10,39454,39488

i suspect that for some reason tables by default on your db tables do not get created as MyISAM and thats a requirement for the FULLTEXT to work

http://bugs.mysql.com/bug.php?id=6713

i think you could possibly fix this error by opening the file "pre_create_tables.php" and changing the line 8 from

code:
if(mysql_query("CREATE TABLE ".$_nodesforum_db_table_name_modifier."_nodesforum_folders_and_posts (fapID int NOT NULL AUTO_INCREMENT, PRIMARY KEY(fapID), folder_or_post int NOT NULL, containing_folder_or_post varchar(102), creator_uniqueID varchar(100), creator_ip varchar(128), creation_time int NOT NULL, title varchar(1000), post longtext, allow_posting int NOT NULL, allow_guest_reply int NOT NULL, ancestry text, subfolders int NOT NULL, posts int NOT NULL, replies int NOT NULL, views int NOT NULL, last_post_postID int NOT NULL, last_post_user_uniqueID varchar(100), last_post_time int NOT NULL, sticky int NOT NULL, skeleton int NOT NULL, deletion_time int NOT NULL, disable_auto_smileys int NOT NULL, disable_auto_links int NOT NULL, FULLTEXT(title, post));"))



to

code:
if(mysql_query("CREATE TABLE ".$_nodesforum_db_table_name_modifier."_nodesforum_folders_and_posts (fapID int NOT NULL AUTO_INCREMENT, PRIMARY KEY(fapID), folder_or_post int NOT NULL, containing_folder_or_post varchar(102), creator_uniqueID varchar(100), creator_ip varchar(128), creation_time int NOT NULL, title varchar(1000), post longtext, allow_posting int NOT NULL, allow_guest_reply int NOT NULL, ancestry text, subfolders int NOT NULL, posts int NOT NULL, replies int NOT NULL, views int NOT NULL, last_post_postID int NOT NULL, last_post_user_uniqueID varchar(100), last_post_time int NOT NULL, sticky int NOT NULL, skeleton int NOT NULL, deletion_time int NOT NULL, disable_auto_smileys int NOT NULL, disable_auto_links int NOT NULL, FULLTEXT(title, post)) ENGINE = MYISAM;"))



the difference is that i added a " ENGINE = MYISAM" around the end

http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engin​e.html

this should force the table that needs FULLTEXT to be created as MyISAM.

im gonna add that line to the source file myself and test it, possibly add that change and pack it in the next version

thanks for your comment, please let me know if it helps

wassaa


test: test
post #63 permalink
member since:
folders:
0
posts:
0
replies:
27
dam your good i spent all yesterday trying to get this working thank you for you prompt fix keep up the great work

Recycling is Good for You Me and Our Planet.

Visit the Recycle Me Free website www.recyclemefree.com and take 5 minutes to think how you can help our planet.
post #67 permalink
please login to reply
page 1 of 4 | next

moderators of this post

al (level: ∞)
powered by Nodesforum