19 Oct
By: Kimberly
i got an error when i changed it SQL ERROR [ mysqli ] Access denied for user ‘forums_2′@’10.3.36.3′ (using password: YES) [1045] An Mysql error occurred while fetching this page. Please contact an administrator if this problem persists. syntax error, unexpected $end in /mounted-storage/home70c/sub002/sc41020-JIPV/claneasycompany.com/forums/config.php on line 18 now when i changed it back i get this damm whats happening anyone know whats going on phpbb experts?
anyone have any idea where to start looking if my capcha’s don’t work? they are attempting to be rendered, but not getting shown
how can I put php into a .tpl file? php and {php} are not recognised php2 phpbb2
how come whenever somebody posts a sticky or poll phpbb3 doesnt put the sticky or poll prefix in?
hi all i’m testing phpbb3 and Description field seems not to be shown for categories but only forforums i’d like to add this Description text just after Category title and before the link to the first included forum
i thought there werent categories in phpbb3
well
In phpBB3 there are no categories, everything is forum based. Each forum can have an unlimited number of sub-forums and you can determine whether each may be posted to or not (i.e. whether it acts like an old category). Here you can add, edit, delete, lock, unlock individual forums as well as set certain additional controls. If your posts and topics have got out of sync you can also resynchronise a forum. You need to copy or set appropr thats straight from the adm
well when i create a forum the first field asks for the forum type forum / category / link
ah ok
but maybe yes the database uses the same table for all
i think (but i can be wrong)
that when the type is “category”
the Description field is not used
just the title
(i’m using default skin)
perhaps i just need to add a field tag in template files
perhaps i need also to patch php 5 files for that
dunno
a little bit of help to say where i have to dig would be great
i think i found :
need to add this to forumlist_body.html
!– IF forumrow.S_IS_CAT –
{forumrow.FORUM_DESC}
!– ENDIF –
sorry all for the noise
could this change be interesting for several people ?
is it worth a tiny patch ?
I am using phpbb over the internet.I log in as an administrator, and can get to the pages i need to see. However, I cannot log into the Administrator panel. I am using a Mac (if that makes a difference) On attempting to enter the administration panel it asks me to log in and then re-authenticate im using Safari and have also tried Firefox any advice would be most welcome oph..I have also deleted all my cookies
cache/sql_1c83820bbed533022ce6d69342a3f3b22.php which does not exist? any one able to explain why it is trying to call this file? odd issue resolved it’self
I am using phpbb over the internet.I log in as an administrator, and can get to the pages i need to see. However, I cannot log into the Administrator panel. I am using a Mac (if that makes a difference) On attempting to enter the administration panel it asks me to log in and then re-authenticate im using Safari and have also tried Firefox .I have also deleted all my cookies
after re-authentication does the admin panel appear ?
no
or does phpbb keep on asking for authentication ?
i just get the logn and password entry box yes it does that
perhaps check your cookie management policy if your browser blocks cookies from the phpbb site
i have deleted all my cookies
that’s not what i said you to look at
tried safari/Firefox and IE on a virgin PC with XP i am set to accept cookkies always
then i guess there is a configuration issue on the hosting box
oh.we use lunarpages to host it, so i guess you suggest i contact them
do you have access to your web server and php error log ?
um..not sure..but probably il look
could be a good point to start
not really where to start looking though
hey why i cant create a backup of ma forum (i am admin in this)
anyone know why a captcha imagfe would not be showing on a new host?
just tried contacting the hosting company and they won’t talk to me about any 3rd party issues!
WHITE PAGE on the index, anybody have a idea or a tools ?
is there a telephone support number for phpbb?
ok thanks cya next time all bots
No
anyone know why phpbb 2.x doesn’t work with php 5?
it works, but its unsuported
ok, that’s what I thought, any ideas why it’s unsupported?
Because its written for php 3 and 4 and not for php5
k
Is it possible to embed sound in posts in phpbb 2.0?
to work, for some reason.
Or rather, it works when previewing the post, but in the actual post, it’s just a line of text.
You would need a MOD
For regular HTML?
From what I recll of the 2.0.22 HTML parsing system, it would be close to impossible to get that tag to work HTML should not be used in posts
Why not?
If you want to use HTML, then you should make a separate page Boards use BBCode
But there isn’t a BBCode equivalent that I know of.
If you enable all HTML, you will spend more time cleaning up after others than using it http://www.phpbb.com/mods/db/index.php?i=browse&mode=group:category&sub=bbcode
Ah. Thank you very much. I think I got what I was looking for.
hi everyone, why do admin permissions set to “never” not affect the user? i set some things to “never” but he is still allowed to do the stuff i denied phpbb3 btw, sorry i forgot
hey folks
Ok got two small question with phpbb2 can I use php5 in it and if so how do I activate it so I can anyone?
anyone know where the function that creates new users and/or that generates new passwords is in phpbb3RC5?
Hello, How do i clear my user database i come back and my site if full of spam bots
[aL]Storm: You want to delete all Users?
Yes Exept me i have set all the forums out ready come back everyhting full of spam
ok Do you use phpmyadmin?
Um no but i can how do i delete them in that? Also how do i upgrade to 3.0 without nakin everythin as thts supposed to reduce spam
If you want to delete all Users exept yourself you may switch do sql
how?
mom
im in phpmy admin
yes
ive found all the users but there aint a check box its clear all
ok
then that will clear mine
you need to click on “Show” in the top of the site or “List” ?
anyone know where the function that creates new users and/or that generates new passwords is in phpbb3RC5?
yh i got Full Texts Rows username 1 aparker 1 armanidomko 1 asbmdeblia 1 Asomeartys 1 AssinnW 1 automatedtradingma
sry, my phpmyadmin is in German, so i don’t know the titles in the english version
ok
you see your own account
and all the bots?
and the checkboxes?
no check boxes
also no image that looks like an “X” ?
um nop
or a link in the bottom of the list “mark all” ?
thrs one that syas drop but i dont want that
mom
nop trs also empty but i dont wnt tht ither
2;”
2;
how?
Where you found “list”/”show” (whatever :P) there is a link, named “SQL”? isn’t it?
ye
click on it and you will get a white textarea..^^
yep
your user table is named “phpbb_users” ?
yep
ok, so the sql should look like this:
i think my db is called eye4youa_phpb1 and the table is called pbb
the db name is irrelevant
*phpbb oki yh Tell me exactly what to type plz
the column including your user ids is named “user_id” - right?
yus
2;
… and all users with an id higher than 2 will be deleted
You’re not deleteing users straight from the database are you?
why not?
ok
stop
oh shit
why not?
i have one user
it should work
378 how do i stop him
Because it will leave a bunch of bad references.
he was the last one registerd no 878 sorry i need to remove 2-877
how would you delete the users?
http://nian.aprs.net/phpbb/toolkit/
I need help… i accidentally removed a Mysql user and now my PhPbb is not accessible SQL ERROR [ mysql4 ] Access denied for user ‘trinster_rene’@'localhost’ (using password: YES) [1045] i recreated the user but still a no go
You’ll need to remake the database user. Did you update config.php with any new names/passwords?
no
Unless the new user has the same name and password as the previous, you’ll need to update it.
let me check config.php
If a user is a member of 4 groups, and one of them, Global Moderators, I have set to having a mailbox of 500 messages, why does him tell him max of 50? 50 is the general board setting
THANK YOU! it worked by updating the config.php
oh, and in addition to the question about 50 messages.. why when someone deletes their messages does it tell them they’re stored?
anyone know where the function that creates new users and/or that generates new passwords is in phpbb3RC5?
i think everyone is out to dinner so again… I have the general PMB setting at 50 messages, a user who is in 4 groups, two of them having defined PMB limits, one of 200 and one of 500, and his PMB tells him his limit is 50…why?
does anyone know how i can completely backup the forum and move it to a new domain? is there a link somewhere on the website
I need help please
Just ask
I have this guy who used to be an admin on my forums
http://www.phpbb.com/kb/article/how-to-move-a-phpbb-20x-board-to-a-new-server/
oo dang
and i removed him and banned him of the fourms…but to day
cya
today he was able to post..and somehow was able to remove his ip of the ban list
its what im looking for but is there one for the new 3.0?
he doesnt have access to phpadmin..or cpanel? is there some backdoor? please help i have Version Powered by phpBB 2.0.22
did you delete old account ? premission
yea i delted it
It’s the same process for 3.0
he was also admin he can know your access right ?
now whne i went into php admin..there is a annyomus user..can i delte that with out messing anything up
gotcha thanks noxwizard
you think that is a back door into admin no i changed all my passwords and i banned his ips
Did you check the IP to see if it was the EXACT same IP as before? He could be using a proxy to get around the ip ban.
but somehow he was able to unban all his ips..but i know 100% he cant get into cpanel even if he is
if someone is a member of multiple groups, which group setting trumps the others, the most restrictive, or least?
shell access ?
how did he remove his old ips off the list no he cant…my host is hyped..and they say we dont have that access so he wouldnt be able to have that access
so you can see all other admin accounts
my templete provide is surreal-media..told me to talk to you
its not possible to hide any new made account
yea..its only me that is the thing the account name he used..when i went to go delete it..it wasnt htere so he posted..then delted his account? so how is he getting into admin…
Do you have phpMyAdmin?
yea im on it righyt now…
Pull up everyone who has Admin. This should do it: SELECT * FROM phpbb_users WHERE user_level = 1;
i’m under the impression it’s that the most permission trumps the least
Affordable blog web hosting solution
Have you tried changing is Default Usergroup to see if it makes a difference?
? im on phpbb_users
Did you run the command I gave you?
now if i slect browse..it will show me all users he isnt on there
is there any other side-effect of changing the default group I should know about?
how do i run that command
you click SQL and enter it in the box
k
It should just tell it what color to show, and which group is pre-selected on the Groups tab in his profile.
shows just me
noxwizard:ok innocent stuff…i’ll try
This one might be a bit out there, but see if there’s a remote access host listed on the databases page, other than 192.168.1.% and localhost.
were do i go for that
Is this cPanel?
right now im on phpmyadmin
Access Hosts are listed on the databases page.
im on the homepage of phpadmin..says locla host version and say server version server is unix and user is that it
Not in phpMyAdmin, on the databases page.
i dont understand were is the database page
In your website’s control panel.
in the cpanel
btw what kind of error is this ? Cannot attach to services manager service 3050:service_mgr is not defined during the install
Yes. There’s a database button. Click it and scroll all the way down. There should be a heading called “Access Hosts”
3.x ver phpBB-3.0.RC5
mysql database?
Yes
darkkiller firebird firebird 2.0
what is that i went in to its showing my database for the site what is firebird 2.0
ah sorry
Above the link to phpMyAdmin
just a little mistake .P
? nox above the lin to phpmyadmin ok no there is only the local host
ok
so after chanign cpanel password..im trying to figure out how is still getting into it..what other way is there
Do you have the admin toolkit on your server?
so who could explain me anyway ? btw what kind of error is this ? Cannot attach to services manager service 3050:service_mgr is not defined
admin tool kit? whould that be in cpanel
No, it’s a standalone script for phpBB. You would know if you put it on.
no surreal-media installed the fourms…since its there template i have phpbb admin only on the forums anything else?
that did it, the default group setting…though I don’t know that the group a user is visibly identified with should be able to set the number of messages…could be mutually exclusive. anyway..when he deletes messages, why does it say they’re stored instead of deleted?
I don’t know at the moment. Try banning his email address. Then it would be a hassle to re-register. If it keeps happening, you may want to submit an IIT report and let the phpBB team see how he’s getting in. You might check the permission setting for: “Can remove private messages from own folder” hrm, just missed him
anyone know where the function that creates new users and/or that generates new passwords is in phpbb3RC5?
login as admin and go in users & groups there you can i guess add and change
my date is showing up wrong i have set my time zone but its showing the date as one day behind is the date and time based off the servers date and time?
Yes
yes
Yes
ok so the server is showing the wrong date and time well the american date and time and im in aus
Unless you set your timezone as +12 and it’s really -12
nah
that works, just contact your host..
the date is one day behind for some reason
anyone know where the function that creates new passwords with the forgot password link is in phpbb3RC5?
why arent my ranks updating when i change the default user group? like i have a rank for each user group and it doesnt change from the old when when i move them to another default group ? i would be good if you could just use an option in each users rank profile such as “use default user group rank” otherwise it doesnt change when i move them to another group for some reason though marshalrusty when say i set the time zone from +9 to +10 it only go’s up 10 minutes in time time and not an hour
Can we get a link to your board?
yeah claneasycompany.com/forums
anyone know where the function that creates new passwords with the forgot password link is in phpbb3RC5?
For utc+10 its right Same with the day
well its friday the 14th here in aus and thats +`0 +10* and its showing up as thursday the 14th thursday the 13th sorry
quick question if i want to move the forum to an entire new server do i have to use toe old mysql db?
yep
omg
the database has all the posts and everything
what if i made a backup
yep
on the forums system thin
if its over 2 mb’s use phpmyadmin to export it and bigdump to import it
you can do that
forums backup thing works too
so its like the same thing?
but you most liikely will need to use bigdump to import it
the mysql and the forum backup er
so whats the date and time showing up for youjames?
say i want to use the forum backup would i just install a fresh php board and then run the backup?
no just copy the databse to a new server than change the database info in config.php
yea but the thing is.. i dont know where to upload the database to…
upload the databse to the new server
the db is called mtaphpbb3forum.sql
the back you made of the old one yeah
yah but where do i put it like public_html or something?
so make a backup of that and then upload it to the new databse in your hosts admin controls
yea the problem with that is they want the backup as a .gz file and mines a .sql
have u still got access to the old databse?
the .sql one?
yeah
i have access to em all
to make another backup compressed in .gz well just do that then
ahh shit problem with that is i dont think the old server works anymore
oh ok ummm
i wouldnt be able to get back on and make a new backup
the .sql file isnt the database it is a text copy of the database, not the database itself
oh i have that .sql and something called backup_1189717748_b17298630d8d824c.sql
just use 7zip on windows to compress it to a .gz or use gzip if you are on a linux machine
7zip can make it from .sql to .gz? im a newb
it might be able to. im not sure but you can load the .sql file directly to the database yes it can make gz files
ok so i opened the .sql in 7zip am i looking to save it somehow as a .gz?
yes
im not sure how.. im looking around 7zip for something like “file saveas” or do i just rename it with .gz following it
.sql is like a text file.. gz is a compression like zip and rar..
yea i have the original forum files the stuff in /forums and all right
in phpbb3 where are the {VALUE} options defined?
where can i find that..
Sorry..eating, Um.. eTiger13_ , for templates?..
for admin menus specifically im looking for {S_FORM_OPTIONS} from acp_users.html on line 71
.html , thats a template file.. So those are defined in a php file.. \ lang file
which one. im assuming in the php files the VALUE part has to be somewhere to be defined but when i search for that i get nothing
includes/ and since its a admin part.. most likely includes/acp Ah, heh.. eating fast.. um, S_ prefix defines.. um.. forget.. fiield or somethin blah
looks like its actually pulling those from the db do you know where the function that creates new passwords with the forgot password link is in phpbb3RC5? i need to change it so it actually creates new passwords that follow the forums passwords rules
hey anyone here?
always !ask
Dont Ask to Ask Just Ask
how much space will I need to host a fairly active forum ?
space is irrelvant its database space
sorry?
the forum uses very little disk space
yea, i mean for the database
as the majority of the data is stored on the database in theory you should not ahve a s**t enought hosting pacakge to run out of space
if i was to buy hosting for a fairly active forum..what should i be looking at ? how much GB traffic ? how much MB space ?
well my 7gb space only ran out coz of all the podcasts…… like i said space db wise is not an issue, maybe one of the devs can tell you how big the phpbb forum is
phpbb forum wont be too large i was refering to the database
i mean the phpbb.com forum
also, any webhost suggestions ? reliable with good support?
i cant say in the channel
any i have never had too look
on my personal i have infinite everything and the other i dont pay for
For webhost discussions, go to: http://webhostingtalk.com
can u PM me that ?
yea i checked there
my hoster isnt looking hanif hes my friend and not commercial in nature
oh ok phpbb 3 is stable ?
technicall no its release candidate 5 last time i checked
runs fine for the 3 sites i run it on live
i see what kind of hosting do you use ?
rasies* damn my spelling raises*
sorry if its not allowed
both i and Noxwizard said so we were trying to be subtle
i apologize
no need
I’ve got a large problem than usual. I have a tree structure of groups (in terms of hierarchy). The level just under global moderator each also have their own group, and are also of course Registered Members. The higher level has a PMB limit of 500, but they weren’t showing that, they were still showing the Registered Member number. So I changed their default group to the high-level group…. …One thing that seems to have happened is that all of their profiles no long have an avatar. why would changing a user’s default group delete their avatar? and how do I relate the .jpg name in the database backup for a user’s avatar to the huge filenames in the uploaded avatars that bear no resemblance?
Changing a user’s group has nothing to do with the avatar, so that should make no difference whatsoever I don’t understand your second question. The avatar filename stored should be the filename of the avatar
no, all the filenames in the upload directory are like 211caece90cf93bb063288060cbdfe0b_108.jpg, and none of the avatar names in the db are like that well, this whole group of people had avatars until i changed their default group to a group with an avatar, now the avatar entry in their profiles is blank i had changed their default group to a group that coincidentally has an avatar, because this group allowed more PMBs, then they all complained that this group’s avatar was showing instead of their individual ones, so I deleted the group avatar, now they have no individual one in their profiles
so the little site/forum description that appears on the top.. how do you change that in the admin panel? i don’t see a setting for it… also to change yourname.com
ganoush, what version phpbb?
3 R5 RC5 i updated the value in the config table thinking it would do soemthing but no dice.
its in general config in the acp
ok
you need to purge your cahce cache* if you do it manuall via the tables
ohk cache eh? interesting ok i’ll try it i want to have a tv forum for certain prime time shows. i know its been done but i want control
I have a quick question if anyone could help me I want to create a login field in flash for the main page of my website how can I take what the user enters and log them into the forums? or is that possible
i guess you would have to do a post get the response. if its good, then redirect
they left
if not say bad user/pass ahh
upgraded from 2.0.21 to 2.0.22 via the code changes and when i attempt to run update_to_latest.php, i get “Please read: INSTALL.html before attempting to update.” searched the forums, but most the time the fix for people is they aren’t running it from an install dir, but i already am.. so not sure what else
doc-: can we have a link to the forum please?
just figured it out, i had my config file renamed and buried under a more secure path, but the update file doesn’t request the location, it just assumes it’s in the root of phpbb under the name config perhaps there’s a way to replace the line ” include($phpbb_root_path . ‘config.’.$phpEx); ” in the update file with something that calls the path and name info for the config file as set in the common.php, but i dunno.. thx anyways
hello people
hi
i have a question about phpbb3 it is possible to show last topics (e.g. 3 or 5) in main forum list (under each forum) http://www.tourdom.ru/forum/ for a axample what i mean *example
Secure jdk web host
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Feb | ||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| 8 | 9 | 10 | 11 | 12 | 13 | 14 |
| 15 | 16 | 17 | 18 | 19 | 20 | 21 |
| 22 | 23 | 24 | 25 | 26 | 27 | 28 |
| 29 | 30 | 31 | ||||
Leave a reply
You must be logged in to post a comment.