search for: in: entire forum this post
you are here: root => Installing the Nodesforum => Installation Support => Errors installing
previous | page 2 of 4 | next
member since:
folders:
10
posts:
22
replies:
75
thanks for letting me know that the fix works ive already packed it in 1.026

wassaa


test: test
post #69 permalink
member since:
folders:
0
posts:
0
replies:
27
hope you can help again im now getting the following error message when i try to add my first post or folder:

there was an error creating the new folder in the database, please notify the amdin of the forum of this problem.

i am using my own login scripts which seem to have integrated no problem and after your last fix all my data base table are created the first time.

i have set the images and catch folders in my windows server to read/write/execute (scripts only) but still no joy.

i have also tried setting the permissions on the main forum folder to read/write/execute (scripts only)

if you have any ideas i would be grateful

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 #89 permalink
member since:
folders:
10
posts:
22
replies:
75
Hi jim.

sorry that you are still having difficulties.

first of all i must tell you that the fact that you are using your own user system and permissions on various folders are surely not related to this problem.

this error message means that when you have submitted your form with the info about the folder you wanted to create in it, when the script that handles this submission has tried to record the information in the database, the INSERT query has failed.

i have installed the forum on a few sites but have not yet seen this error, so for this reason i have difficulty seeing what could cause this problem. for that reason i would like you to give me more information on the problem.

on the file bod_add_folder.php around line 7, can you please change the line that says:

from:
code:
if($_nodesforum_create_folder_dberror==1)
{echo '<img src="'.$_nodesforum_warn_icon.'" style="vertical-align:text-bottom;border:none;" /> there was an error creating the new folder in the database, please notify the amdin of the forum of this problem.<br />';}



to:
code:
if($_nodesforum_create_folder_dberror==1)
{echo '<img src="'.$_nodesforum_warn_icon.'" style="vertical-align:text-bottom;border:none;" /> there was an error creating the new folder in the database, please notify the admin of the forum of this problem.<br />error: '.mysql_error().'<br />';}



and then try to create a folder again. and tell me what error message you are getting.

this change has been included in 1.030 so that if anyone else has these problems in the future it will give them more info right away

wassaa


test: test
post #93 permalink
member since:
folders:
0
posts:
0
replies:
27
hi thank for getting back so quick iv made the change to the file below is the error message:

there was an error creating the new folder in the database, please notify the admin of the forum of this problem.

i see you fixed the error message spelling but i still have the same issue

i hope this helped

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 #95 permalink
member since:
folders:
10
posts:
22
replies:
75
what i need to know is the part after that.

if you did apply the change it should say

there was an error creating the new folder in the database, please notify the admin of the forum of this problem.
error: important stuff here

theres gotta be at least the word "error:" on the line after
from <br />error: '.
and right after that mysql_error() should output the error that mysql has encountered

wassaa


test: test
post #96 permalink
member since:
folders:
0
posts:
0
replies:
27
hi all im getting is the below error

there was an error creating the new folder in the database, please notify the admin of the forum of this problem.
error:


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 #97 permalink
member since:
folders:
10
posts:
22
replies:
75
hi ok i see sorry about that i guess thats cos the database connection is closed after the pre_output.php so i cant use mysql_error() anymore.

can you please instead change

code:
{$_nodesforum_create_folder_dberror=1;}



to

code:
{echo mysql_error(); $_nodesforum_create_folder_dberror=1;}



in pre_add_folder.php on line 119

that should show us our error.

sorry that youre having these issues im really curious to figure out what causes that in your case.

i remember on your system we had to force the folders and posts table to be created as MyISAM. i suspect it might have something to do with that.

wassaa


test: test
post #98 permalink
member since:
folders:
0
posts:
0
replies:
27
ok i got this at the top of my page not after <br/>error:

Field 'deletion_time' doesn't have a default value

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 #99 permalink
member since:
folders:
10
posts:
22
replies:
75
ok looks like your db is more strict than what im used to work on. or maybe my db automatically assigns default values where there are not gimme a few minutes to look into that

wassaa


test: test
post #100 permalink
member since:
folders:
0
posts:
0
replies:
27
im running the following

PHP Version 5.2.9-2

IIS Version: 5.1

MYSQL server 5.0

though this may help

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 #101 permalink
member since:
folders:
10
posts:
22
replies:
75
yes i think i found the problem. it would be that your db is in strict mode mine isnt

wassaa


test: test
post #102 permalink
member since:
folders:
10
posts:
22
replies:
75
i think you could possibly fix this problem by opening pre_output.php and adding

code:
mysql_query("SET @@SESSION.sql_mode = ''");



on line 172 after
code:
mysql_select_db($_nodesforum_db_name,$conn);

at line 171

wassaa


test: test
post #103 permalink
member since:
folders:
10
posts:
22
replies:
75
that will force your database to be in more normal mode for the execution of the forum.

in the meantime im gonna fool around in strict mode to see if i can change the script to pass in strict mode.

well pls let me know if that works

wassaa


test: test
post #104 permalink
member since:
folders:
0
posts:
0
replies:
27
well you came through again, the fix has worked i can now create new folders and edit them also

many 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 #105 permalink
member since:
folders:
10
posts:
22
replies:
75
thanks for trying it out. i guess im gonna add this line and add it to the new version of the download to make sure that in the future everybody runs the script in the same mysql mode that it was written for.


http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html​

wassaa


test: test
post #106 permalink
member since:
folders:
0
posts:
0
replies:
27
Hi Envis, im getting a few problems with the forum now I have uploaded my site from the testing server.

New location: Hostpapa server www.recyclemefree.com/forum.php feel free to create a new account and give it a try.

I am running version 1.049 just updated but had the same issues on the previous version.

The forum search does not seam to work it returns: no results matching ………. This is something I missed on the testing server so the problem has always been there

And now when I try to upload an avatar in .png I get: incorrect file type. the allowed file types are jpg, gif and png (image/jpeg, image/pjpeg, image/gif and image/png).

But works with a .jpg

I have set the images and catch folders to 777 thinking it was just permissions but has not helped.

The avatar upload works fine on the testing server.

for sum reason i also now have 2 image folders inside the main image folder and not from the upgrade i just tried copying the original avatar into both folders and now my avatar is displaying so i know which folder the forum is useing, but i still can not upload a new one without the above error

I am also getting the following error when i try to update my signature: (it does still update though even with the error message)

Warning: Cannot modify header information - headers already sent by (output started at /home/cika5584/public_html/recyclemefree.com/db_connect.inc.​php:17) in /home/cika5584/public_html/recyclemefree.com/forum/pre_edit_​post.php on line 137


Have you got any ideas?

Many thanks


Jim

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 #149 permalink
member since:
folders:
10
posts:
22
replies:
75
Hi.

i see the error when you change the signature. according to the error message this happens because some part of your site produces output before the "pre_output.php" of the forum is run. according to the message it would be db_connect.inc.php and it appears that this "db_connect.inc.php" is writing a <br /> on the page according to what i can see on the source, causing output before the pre_output.

about uploading a png i was able to do that. can you upload that png avatar here on this forum so i can see if theres anything special about it? http://www.recyclemefree.com/forum.php?_nodesforum_node=u26​

about the search i tried it and it was working as expected for me. example your first posts says: "keep the topic relevant to environmental" and if i search the whole forum for "keeping the topic relevant" it finds that post http://www.recyclemefree.com/forum.php?_nodesforum_search=k​eeping+the+topic+relevant&_nodesforum_search_spectre=0&_node​sforum_node=6 so there again i would need you to provide me a more specific example that does not work as expected, so that i can see the error in action.

also i notice that your server has magic quotes enabled but you must have set magic quotes to off in the forum config causing quotes and double quotes to be escaped in double, in turn causing backslashes to appear in front of quotes and double quotes in the posts. you will need to set $_nodesforum_magic_quotes_on_or_off to 'on' in the forum config to match your server's config

wassaa


test: test
post #152 permalink
member since:
folders:
0
posts:
0
replies:
27
Hi

Thanks for getting back to me, ok I have changed it so the output file is befor my db_connect script and the error seems to have gone, I have turned on magic quotes thanks for pointing that out and as for the image i tried to use it on your forum as my avatar but i have the same problem i think it must just be that 1 image im not to sure why though as it works on my testing server strange but not to worrie.

As for the search i was trying to search by user name not part of a post i guess its just how the search is setup.

A change of subject do you keep the body page the same for each update like the config as i have changed the layout and i dont wont to have to change it each time a new version comes out.

I also got this error message:

Warning: unlink(forum/images/_827200/avatars/forum1__1_1271919107.jpg​) [function.unlink]: No such file or directory in /home/cika5584/public_html/recyclemefree.com/forum/pre_forum​_options.php on line 53




many 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 #153 permalink
member since:
folders:
10
posts:
22
replies:
75
quote from jim on post #153
Hi

Thanks for getting back to me, ok I have changed it so the output file is befor my db_connect script and the error seems to have gone, I have turned on magic quotes thanks for pointing that out and as for the image i tried to use it on your forum as my avatar but i have the same problem i think it must just be that 1 image im not to sure why though as it works on my testing server strange but not to worrie.

As for the search i was trying to search by user name not part of a post i guess its just how the search is setup.

A change of subject do you keep the body page the same for each update like the config as i have changed the layout and i dont wont to have to change it each time a new version comes out.

I also got this error message:

Warning: unlink(forum/images/_827200/avatars/forum1__1_1271919107.jpg​) [function.unlink]: No such file or directory in /home/cika5584/public_html/recyclemefree.com/forum/pre_forum​_options.php on line 53




many thanks



yes the search only searches post and folders titles and texts at the moment. im adding searching by username to my todo list

i was initially trying to never change the body.php exactly for that reason but 1 day theres something i really needed to add there (1.034) but later on i actually removed that change and went back to the original body.php (1.045). and so far since that there was never any change to the body.php except in 1.047 when i had to add a
code:
a_function_that_is_only_in_the_pre_output();

at the beginning of the code for a security update. so i dont know how old your body.php is but if its older than 1.047 then i recommend that you just add the
code:
a_function_that_is_only_in_the_pre_output();

at the beginning of your body.php like that:

code:
<?php
a_function_that_is_only_in_the_pre_output();



echo '<script type="text/javascript" src="'.$_nodesforum_code_path.'_nodesforum_js.js"></script>';



echo '<style type="text/css">

.class_nodesforum_bgcolor1 {color:'.$_nodesforum_text_color.';background-color:'.$_nodesforum_background_color1.';background-image:url("'.$_nodesforum_mysterypath.'/gradios2.png");background-position:bottom;background-repeat:repeat-x;vertical-align:top;}
.class_nodesforum_bgcolor2 {color:'.$_nodesforum_text_color.';background-color:'.$_nodesforum_background_color2.';background-image:url("'.$_nodesforum_mysterypath.'/gradios2.png");background-position:bottom;background-repeat:repeat-x;vertical-align:top;}
.class_nodesforum_inner {padding-left:4px;padding-right:4px;background-image:url("'.$_nodesforum_mysterypath.'/gradios.png");background-repeat:repeat-x;}
.class_nodesforum_bgcolor3 {color:'.$_nodesforum_.........................




im planning to eventually make a chart of the updates and whether any of them contains a change in either config.php or the database structure but there was no such change yet except just a few *optional settings added in the config.php yet. but i guess i will probably include body.php in that chart too now. but i havent made the chart yet...


quote
I also got this error message:

Warning: unlink(forum/images/_827200/avatars/forum1__1_1271919107.jpg​) [function.unlink]: No such file or directory in /home/cika5584/public_html/recyclemefree.com/forum/pre_forum​_options.php on line 53


that means a problem when trying to delete your old picture. the forum deletes your old picture when you successfully upload a new one. if you can check in you avatars folder and check if you see a picture named forum1__1_1271919107.jpg.

  • if it is there then that would be a permission problem. maybe a problem with how php needs to be able to read and write in the images folder or maybe just 1 guess if you moved that picture from another server when you changed server it could cause the "owner" of this file to be the user of your ftp you upload it with, causing the problem which shouldnt happen if the pic had been updated by php. but thats just a supposition.
  • if it is there then that means a bug. lets cross our fingers it was a 1 time bug and if not let me know and ill investigate.


also about that mysterious png that is only recognized on your old server i made a tiny change to bod_forum_options.php so that now if an uploaded avatar isnt accepted because the mime type isnt one of the accepted ones the server will tell the user what is the detected mime type(released in 1.050 and thats the only change between 1.049 and 1.050 so you can update from 1.049 to 1.050 only by updating your bod_forum_options.php)



wassaa


test: test
post #154 permalink
member since:
folders:
0
posts:
0
replies:
27
Hi envis,
I have changed the body to include a_function_that_is_only_in_the_pre_output(); I have also updated bod_forum_options.php so I guess im on version 1.050 now.

The image forum1__1_1271919107.jpg. is not in the said folder I have a question though I have 6 image folders under the main image folder and each folder has 2 sub folder which are named avatar and minipics im guessing the forum is creating the folders as i am not is this what should be happening?.

I think it could be something to do with the fact im uploading my site to 2 domains the .com and . org (both sites run from the same database but have separate root directories) and some where along the way extra folder have been created i need to find a way to share the images folder across both sites.

Again thanks for all your help

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 #155 permalink
please login to reply
previous | page 2 of 4 | next

moderators of this post

al (level: ∞)
powered by Nodesforum