jlhaslip
Apr 21 2007, 05:54 PM
The forum has been up and running for about a year and a half. It has been through numerous server upgrades, etc, including the recent HDD change, but for some reason, just this week it started throwing this error: QUOTE Could not obtain post/user information.
DEBUG MODE
SQL Error : 145 Table './jlhaslip_phpbb2/phpbb_posts_text' is marked as crashed and should be repaired
SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 576 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 25, 25
Line : 398
File : viewtopic.php Any ideas? I did the mysql "repair" thing in the cpanel, but that didn't work. I do have a backup. Should I do the restore from a backup? or is this a mysql problem that will persist? I could not find this error by number in the mysql documentation. They start at #1000, so I am lost about the error number, too.
Comment/Reply (w/o sign-up)
Saint_Michael
Apr 21 2007, 09:13 PM
I can't remember or not but doesn't phpbb have a repair feature like ipb does with it's DB within it's admin panel? By the looks of it I would say it's a specific file and DB so instead of doing a full restore on a back up see if you can patch the phpbb_post_text db and then upload the viewtopic.php file. Of course if the patches don't work then go with the full restore and see if it happens again. I did do some searching although not the same DB but the response the next person gives could help out: http://www.phpbb.com/community/viewtopic.p...9128&hilit=.
Comment/Reply (w/o sign-up)
jlhaslip
Apr 21 2007, 09:42 PM
Indeed it did. Seems that I had a bad Database record (just one) in that table. All fixed up now, thanks to that script they provided. Funny that I didn't find it on my search for the fix. Thanks, SM.
Comment/Reply (w/o sign-up)
Saint_Michael
Apr 21 2007, 10:12 PM
I took a long shot and it did pay off, awesome! I assume that you used different keywords then I did? I just Google SQL Error : 145 and it was the second site it listed that gave me the post about what to do more or less  . Although the post mentioned that it worked he didn't mention which link he used. Should be a good idea to post that smae link as well haslip so everyone who is using an old phpbb board can use it if or when a error happens.
Comment/Reply (w/o sign-up)
jlhaslip
Apr 21 2007, 11:57 PM
I simply snagged the php script and followed the instructions. Seems there was one bad row in the Database and the mysql/phpadmin Repair that I had tried earlier in the week never found or fixed the problem, whereas this script did. I'll keep this Topic open in case anyone else needs the link.
Comment/Reply (w/o sign-up)
Similar Topics
Keywords : phpbb2, 17, mysql, problems, week, started
- Mccodes With Mysql! [resolved]
I need help with this topic (6)
Mysql Server Down
(10) mysql (5.0.51a-community) failed What is happening? And btw, sometimes I get a message: could not
connect with mysql server. I use joomla 1.5 . but now, the server is down as shown on Server
status... please help....
Mysql Database Not Working
(3) well i'm getting an error message(a databass connection warning) for all of the parts of my site
that connects to a mysql database i check my database users pertmissions and i try to do the repair
database thing and it's still not woeking. am i the only person having this or is it an overall
trap17 issue and how do i fix it.....
Host Problems
Need some help (7) Hey, recently ive applied and been accepted for a host. Now, i set up an account and then tried to
get to the access panel.. Didnt worked... I thought it might be because of my domain, so i got
another 15 credits and transferred the domain.. Now, i try clicking on "cPanel Login", but it wont
even open it.. It just says "error by loading page"... whats going ? ive lost 45 credits already
/sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" />....
It Went Well For A While
MySQL problem back in all its glory. (5) Some time ago I had a stubborn problem when trying to access one of the interactive pages on my
website and getting the following error: QUOTE Warning: fopen() : open_basedir restriction in
effect. File(include/errors.xml) is not within the allowed path(s):
(/home/mrdee:/usr/lib/php:/usr/local/lib/php:/tmp) in
/home/mrdee/public_html/admin/include/commonfunctions.php on line 682 Warning:
fopen(include/errors.xml) : failed to open stream: Operation not permitted in
/home/mrdee/public_html/admin/include/commonfunctions.php on line 682 Cannot open XML data file:
incl....
Problems?!
{user: alex1985] (1) Hi, I got some problems mainly related to connection issue. Firstly, I can connect to FTP server to
upload files. Secondly, I can not access cpanel account, it does not accept my registered data, the
one which is totally right. I do not what happened because it was working fine before. ....
How Do I Find My Mysql Password? [resolved]
Cannot access my MySQL (5) After all the recent problems, my account has been restored. I have setup my parked domain agin, and
that works fine. However, I can no longer access my MySQL databases (I can from PHPMyAdmin, but
that's all). I had to create a new user for my databases, and created the user with exactly the
same username and password I had before, but some of my web pages do not let me access the pages I
have associated with my databases. Where could i find out what my DB password is? (Although I am as
good as sure I am using the right one). I have tried my old password, the new c....
Remote Access Mysql
(8) Is it possible to directly access my local database from my website? For example, if somebody
submits info on my website, the info they submitted would be transferred to my local database
directly. Is that possible? And if so, how do I set that up? The reason I don't want to upload
my database to my subdomain is because it would be difficult to keep the website database and my
local database in sync . . . or is there a way to do that? Thanks for any replies.....
The Capitalization Filter
Problems with it (0) I've noticed that on a lot of topics, The topic's title has been maimed a little, like in
the case of "Guitar Hero Iii" or "Php And Mysql Question". The current world filter decapitalizes
all but the first letter of the word, which is capitalized. This is a problem, and although the
capitalization filter is good, I've proposed a few corrections: 1. For words that begin with a
capitalized letter, do not change the word. 2. Notwithstanding item 3, for the words, "the", "and",
"of", "in", and any other preposition or article that is 3 letters long or shorter, ....
Strange Site Problems
(2) This morning i ran out of credits, but I immediately got them back up to 7. All day I've been
trying my site, and it keeps timing out, and on the odd occasion comes up with a MySQL error. I was
just able to login to my cpanel, and my space usage was 550mb. Yesterday is was approximately 256mb,
and i didnt upload anything. I had to delete files to get it back down to 470, but I cant find what
has made it so big. Now I get a MySQL error on my forum. What do I do?....
Problems Adding An Email Account
(3) Hello, I am trying to add an email account, but I'm having problems. When I go into my Cpanel
and attempt to add an email account I get a message similar to "the account you are trying to
create, You have exceeded the maximum number of email accounts , with the password password
has been created successfully" And, of course, no email account is created. I know I am not
approaching any of my limits (Especially not on email accounts, since it's unlimited) so I'm
getting a bit confused. It may also be worth knowing that I have added email accounts in ....
Problems With Ftp Access
(1) Well topic title says its all I have problem with ftp access to my account here on trap17 so if
anyone has experienced similar issues lately. The problem is when I try to log on it disconnects me
from the server. I am using filezilla however I have tried to access trough file manager and it
works fine though it is not the same protocol. I must admit I have deleted some folders recently
however I am quite certain that it is all connected to the joomla installation and not some system
files but if there is some specified folder for ftp could you plese write down so I cou....
Question About The Upgrade And The Mysql Usage ?
question about the upgrade and the mysql usage? (3) thanks for the upgrade but i do have question about it QUOTE Domain name zam.trap17.com
Hosting package Beta Subdomains 3 / 99 Parked Domains 0 / 9 Addon Domains 3 / 9 Mysql databases
1 / 99 PostgreSQL Databases 0 / 99 Disk usage 14.25 / 500.00 MB MySQL Disk usage 0.82 MB
Disk space available 485.75 MB Bandwidth (this month) 6.59 / 10240 MB Email accounts: 1 / 99
Email forwarders: 1 / unlimited Autoresponders: 0 / unlimited Email filters 0 / unlimited
Mailing lists: 0 / 99 FTP accounts 3 / 99 1-Bandwidth (this month) 6.59 / 10240 MB ....
Domain Change Problems
(2) Hey. Today I decided to change my default domain to a subdomain; I kinda needed a personal website
but I don't have the time to spend 5 hours waiting for the Uni.CC name servers to set up.
Anyway, I collected a couple more hosting credits to that I had enough to change it, and changed my
default domain to http://minik.trap17.com/ . It changed my new domain to go to my public_html
directory and I checked and the addon domains were still working. I got annoyed at having so many
folders in the public_html directory so I deleted all but the important folders. I then g....
Is The Server Ok?
FTP and loading problems. (1) At the time of writing this (01:12 GMT) I seem to have problems FTPing to my site (Time out
problems), and, to a lesser extent, page loading problems. I just wanted tocheck whether the servers
are OK or whether the problem is on my end. Please let me know if you can. ....
Suspended Account Problems
(4) I had to go on a trip with my school and my hosting account became suspended while I was away. I
have posted and my account has been re-activated, but I can't get rid of the redirect. Current
Redirects .* http://xisto.com/suspended.page/ (permanent) It shows that ^^ and I've tried
several times but I can't get rid of it. Any help please?....
Control Panel Will Not Let Me In [resolved]
Login problems (4) I am frantically trying to get into my Trap 17 control panel. I tried to get into the login screen
by typing: http://www.trap17.com:2082 and indeed, the login screen comes up. I then type in my
username (mrdee, or should it be my trap 17 domain)? I then also enter my correct password, what
hapeens then is that the login screen keeps popping up again. I have no idea what I am doing wrong.
Can anyone help me please? Thanks in advance. ....
File Manager Problems
(3) Alright, I figured out the edit html windows need to be refreshed each time opening them for them to
show the last updates so you don't just work off the old, un-updated version and mess everything
up (which really should get fixed). The problem that most annoys me though is when I try deleting
files and the File Manager doesn't delete them. I try uploading updated files over them and it
doesn't update them, but just keeps the old ones there. It's getting really annoying. And
when I try deleting stuff from the Trash Can, it never deletes it. Sometime....
Error Code In Subscriptions Page
problems subscribing to topics (5) I'm seeing some weird warning message show up at the top of my page when I go into "my
controls," then load my topic subscriptions page. At the top of the page, the following code appears
several times: IPB WARNING in_array() : Wrong datatype for second argument (Line: 2711 of
/sources/action_public/usercp.php) I'm guessing maybe that has something to do with the fact
I'm having problems subscribing to my topics and posts? Thanks in advance for your help.....
Is It Possible To Access The Mysql Remotely?
(10) I like to experiment with a lot of things and I was thinking of making a sort of instant messenger
in Python, but I want to let people have actual accounts so I need to be able to access the mySQL
remotely. If that's not possible, are we allowed to run Python scripts on the server?....
Problems After Changing Domain
(14) Hi, i have recently bough a top level domain from GoDaddy.com and now I am having a few problems
with it. I first changed the domain name with the domain name changer scirpt thing here at trap and
then i set the nameservers at godaddy. It told me that this can take up to 48 hours but i think
thats only the maximum because from some people ive talked to they told me that it usualy only takes
a few hours. So now i have waited a few days(MORE than 48 hours!!) and I still dont have my site
like it should be. This is a very urgent problem since i cant acces my site at all i....
Installing Apache, Mysql, Phpmyadmin Locally
Solving the "php_mbstring.dll missing" (5) Since Trap17's CP provide the individual site's owner with goodies like MySql and
PhpMyAdmin, chances are some will want to make use of them. Well, it's fine enough to get that
on one's host (Gee! Thanks a lot, Trap17...) Knowing how the usual geek react, it might be
expected that most people considering to make use of a database on their site will want to do most
of the tedious job of developing and testing on their own local system before sending the wrapped-up
result on their domain/subdomain. This involves four basic steps (sorry for the compuwizs, ....
Help Moving Mysql Files To A New Host
IPB files (2) Well, my partners on my forum has decided to move our site to a newer host. A paid one to be exact.
And we did that already. Now all we need to do is move our forum over to the new host. We want to
do this without losing all of our posts and other data. I know it has something to do with the MySQL
files but I don't really understand it. Some help would be appreciated. We are running Invision
Power Board 1.3.1 final Also, we're thinking about upgrading our board to a newer version of
IPB because we heard that its better in more ways than one. But then again, it....
Problems With Outlook Express
My email configuration isn't working (8) Does anyone have a clue as to why my outgoing email isn't working with Outlook express? I can
get incoming mail, but I'm getting an error when I try to send email. I followed the
configuration instructions, but it still isn't working correctly. I get an error everytime.....
Sending Mail Problems
Outlook Express (11) I am using my dot com email through Outlook Express. I have no problem in recieving Emails through.
However if I reply to the Email it can not send before there is an Error. The Error message is
below: QUOTE Your server has unexpectedly terminated the connection. Possible causes for this
include server problems, network problems, or a long period of inactivity. Account:
'mail.zaccynetwork.com (2)', Server: 'mail.zaccynetwork.com', Protocol: SMTP, Port:
25, Secure(SSL): No, Socket Error: 10053, Error Number: 0x800CCC0F This happens with all 6 acc....
Setting Up A Remote Mysql Connection
Need help! (3) Okay... I'm hosted here on Trap17. I would like to connect to a remote MySQL database located on
another server... can someone walk me through what I need to do to set this up, or if it can even be
done? Thank you in advance!....
Mysql Database Setup : Setting Up Mysql Database
Guide to use MySQL database in your site (7) A SMALL INTRODUCTION TO DATABASE ============================= I have seen that many members have
problems with Database. Here is a small INFO which should give you the IDEA. mySQL is a DATABASE
server. You can access it using the link in Cpanel. Cpanel can be accessed by
"www.YOUR-SITE.com/Cpanel" There you have 4 Main Options :- 1> CREATE A DATABASE 2> CREATE A USER
3> ADD USER TO DATABASE 4> PHPMYADMIN CREATE : IT ALLOWS YOU TO CREATE A DATABASE CREATE USER
: IT ALLOWS YOU TO CREATE A USER. USING THIS, YOU CAN ACCESS THE DATABASE. A DATABASE CANNOT BE....
MYSQL Settings
(5) I am going to edit my mysql settings. Before i had freesql.org but that's slow. So now i
created one here. What is the host? What must i put in the server.....
Sign In Problems
um.. yeah (2) When I typed in my login and password it gave me this QUOTE Forbidden You don't have
permission to access /_private/ on this server. Additionally, a 404 Not Found error was encountered
while trying to use an ErrorDocument to handle the request.
-------------------------------------------------------------------------------- Apache/1.3.31
Server at www.ss9.trap17.com Port 80 I even went into my pm box to make sure it was the login
name and pw that admin gave me and tried it again. I am thinking it might be the fact that I am at
school and these comps ....
Problems with PHPBB & my Access to files :S
(4) Ok another problem i'm having.. prolly my fault but ok.. i go to uploud my avatar on my forums
and it says this after i click submit Warning: copy(./images/avatars/486273215410e356f445f1.jpg):
failed to open stream: Permission denied in /home/zipmc/public_html/Forum/includes/usercp_avatar.php
on line 227 Warning: Cannot modify header information - headers already sent by (output started at
/home/zipmc/public_html/Forum/includes/usercp_avatar.php:227) in
/home/zipmc/public_html/Forum/includes/page_header.php on line 474 Warning: Cannot modify header
information - h....
Looking for phpbb2, 17, mysql, problems, week, started
|
Searching Video's for phpbb2, 17, mysql, problems, week, started
See Also,
|
advertisement
|
|
