php forum
php mysql forum
php mysql smarty
 
Page 2 of 3 < 1 2 3 >
Topic Options
#280272 - 10/07/04 09:56 PM Re: Importing the Database [Re: barbiro]
JoshPet Offline
I type Like navaho

Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
We have a list of errors and solutions posted here for reference:<br />http://www.ubbcentral.com/boards/showflat.php/Cat/0/Number/35663
_________________________
Joshua Pettit
www.JoshuaPettit.com
My abilities are for hire.

Top
#280273 - 10/07/04 10:48 PM Re: Importing the Database [Re: Daine]
ChAoS_dup1 Offline
Code Monkey

Registered: 11/15/02
Posts: 576
Loc: Great Northwest
Thanks Josh that will help.<br /><br />This error was not on that list though<br /><br /> The server encountered an internal error and was unable to complete your request.<br /><br />Error message:<br />Premature end of script headers: ubbthreads.php
_________________________
ChAoS
Emerald Forest Gaming Servers
Official STFU Thread


Top
#280274 - 10/07/04 10:56 PM Re: Importing the Database [Re: barbiro]
JoshPet Offline
I type Like navaho

Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
"SQL Error: Got error 127 from table handler" is in that post <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" /><br />Towards the bottom of the error section.<br /><br />[]<br />SQL ERROR: Unable to do query: Blah blah blah Got error 127 from table handler<br /><br />Error 127 = Unknown Error / Record File Crashed<br /><br /><br />You can generally look at what table or tables it was trying to Query and run the Repair Table command for that table.<br /><br />For example, if the query throwing the error is the w3t_Posts table, you can try entering this SQL Query:<br /><br />REPAIR TABLE w3t_Posts<br /><br /><br />If this does not work, you may need to ask your webhost to run myisamchk on your database. You can also try dumping and restoring the database with the mysqldump command.<br />[/]
_________________________
Joshua Pettit
www.JoshuaPettit.com
My abilities are for hire.

Top
#280275 - 10/07/04 11:02 PM Re: Importing the Database [Re: Daine]
ChAoS_dup1 Offline
Code Monkey

Registered: 11/15/02
Posts: 576
Loc: Great Northwest
I think you mis-understood. This is a new error that I get. The previous one was fixed by repairing w3t_Posts<br /><br />This error I get when trying to login or go to the Main Index<br /><br />Server error!<br /><br />The server encountered an internal error and was unable to complete your request.<br /><br />Error message:<br />Premature end of script headers: login.php<br /><br />If you think this is a server error, please contact the webmaster.<br />Error 500<br />emeraldforestseattle.nuclearfallout.net<br />Thu Oct 7 21:02:21 2004<br />Apache/2.0.50 (Unix)
_________________________
ChAoS
Emerald Forest Gaming Servers
Official STFU Thread


Top
#280276 - 10/07/04 11:23 PM Re: Importing the Database [Re: barbiro]
JoshPet Offline
I type Like navaho

Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
Ah- I understand now. You got by the post table error.<br /><br />Not sure why you're getting the new error. <br />I'd try re-uploading clean login.php login.tmpl and login.php language files, to make sure there's no corruption there.
_________________________
Joshua Pettit
www.JoshuaPettit.com
My abilities are for hire.

Top
#280277 - 10/08/04 02:44 PM Re: Importing the Database [Re: Daine]
ChAoS_dup1 Offline
Code Monkey

Registered: 11/15/02
Posts: 576
Loc: Great Northwest
Well I tried toing a REPAIR TABLE on the whole lot of them and that reduced my db from 30mb to 4mb-Thank God for backups
_________________________
ChAoS
Emerald Forest Gaming Servers
Official STFU Thread


Top
#280278 - 10/08/04 07:35 PM Re: Importing the Database [Re: barbiro]
ChAoS_dup1 Offline
Code Monkey

Registered: 11/15/02
Posts: 576
Loc: Great Northwest
Any idea what could have caused this? <br />Script: /usr/www/efs/ubbthreads/ubbt.inc.php <br />Line#: 491 <br />SQL Error: Can't open file: 'w3t_Online.MYD'. (errno: 145) <br />SQL Error #: 1016 <br />Query: REPLACE INTO w3t_Online (O_Username,O_Last,O_What,O_Board,O_Read,O_Type,O_Extra,O_Agent,O_Refer) VALUES ('-ANON-208.54.15.1','1097282232','index','','','a','','Mozilla/5.0 (Windows; U; Windows NT 5.0; rv:1.7.3) Gecko/20041001 Firefox/0.10.1','') <br /> <br /> <br />Now when I go to the tables It says this about that particular one <br /> <br /> w3t_Online Browse Select Insert Properties Drop Empty in use <br /> <br />and and seems the the file w3t_Online.MYD is no longer in the db folder. All I did was open the entrance page <img src="http://www.ubbdev.com/forum/images/graemlins/frown.gif" alt="" /> <br /> <br />SELECT FROM w3t_Users WHERE U_SQL-Hell > '1'; <br />1 results returned <br />ChAoS


Edited by ChAoS (10/08/04 07:41 PM)
_________________________
ChAoS
Emerald Forest Gaming Servers
Official STFU Thread


Top
#280279 - 10/08/04 08:56 PM Re: Importing the Database [Re: barbiro]
ChAoS_dup1 Offline
Code Monkey

Registered: 11/15/02
Posts: 576
Loc: Great Northwest
I am getting closer- I had the host replace the files again and now I get this<br />Table 'w3t_Online' is read only<br /><br />So I emailed him back to change the permissions on the db.I also re-uploaded UBBThreads in ASCII (except images) just in case I didn't thr first time. Now I just wait
_________________________
ChAoS
Emerald Forest Gaming Servers
Official STFU Thread


Top
#280280 - 10/08/04 10:13 PM Re: Importing the Database [Re: barbiro]
ChAoS_dup1 Offline
Code Monkey

Registered: 11/15/02
Posts: 576
Loc: Great Northwest
I am still getting this <br /> The server encountered an internal error and was unable to complete your request.<br /><br />Error message:<br />Premature end of script headers: index.php<br /><br />If you think this is a server error, please contact the webmaster. <br /><br />At this point I am just going to try a fresh install and then maybe restoring a backup from the control panel. I am about ready to throw my hands up on this one. Thanks for all your help everyone <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />
_________________________
ChAoS
Emerald Forest Gaming Servers
Official STFU Thread


Top
#280281 - 10/08/04 10:29 PM Re: Importing the Database [Re: barbiro]
Medar Offline
Junior Member

Registered: 03/19/00
Posts: 571
Well I am reading along, but the latest errors you are getting is like nothing I have ever run into.<br /><br />But best of luck!

Top
#280282 - 10/10/04 02:44 PM Re: Importing the Database [Re: Intel -*RW*-]
ChAoS_dup1 Offline
Code Monkey

Registered: 11/15/02
Posts: 576
Loc: Great Northwest
I am going to try a fresh install of the Linux version.Maybe the fact that I zipped my Windows installed UbbThreads folder is the problem.
_________________________
ChAoS
Emerald Forest Gaming Servers
Official STFU Thread


Top
#280283 - 10/14/04 08:59 PM Re: Importing the Database [Re: barbiro]
ChAoS_dup1 Offline
Code Monkey

Registered: 11/15/02
Posts: 576
Loc: Great Northwest
How do I restore a db backup from the new control panel in 6.5?
_________________________
ChAoS
Emerald Forest Gaming Servers
Official STFU Thread


Top
#280284 - 10/14/04 09:45 PM Re: Importing the Database [Re: barbiro]
scroungr Offline
Old Hand

Registered: 10/17/03
Posts: 2409
Loc: Richmond, VA
No restore function for the database only a backup option you will need to manually do the import thru phpMyAdmin.
_________________________
Couchtomatoe - www.couch-tomatoe.cc
My abilities are for hire for installs, upgrades, custom themes and custom modifications.

Top
#280285 - 10/15/04 12:32 AM Re: Importing the Database [Re: 234234]
JoshPet Offline
I type Like navaho

Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
Yeah, generally if your database is d0rked up, you can't get to the admin panel anyway. <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />
_________________________
Joshua Pettit
www.JoshuaPettit.com
My abilities are for hire.

Top
#280286 - 10/15/04 03:37 AM Re: Importing the Database [Re: Daine]
ChAoS_dup1 Offline
Code Monkey

Registered: 11/15/02
Posts: 576
Loc: Great Northwest
This is really frustrating.The board runs fine on my windows machine.I can create and restore backups just fine but when I try to import it to this new host it just freezes.He has even tried to import it via shell with the same results.
_________________________
ChAoS
Emerald Forest Gaming Servers
Official STFU Thread


Top
#280287 - 10/15/04 05:52 PM Re: Importing the Database [Re: barbiro]
ChAoS_dup1 Offline
Code Monkey

Registered: 11/15/02
Posts: 576
Loc: Great Northwest
I think this may be a permissions issue because I can install a fresh copy of 6.5 that uses the database but has none of my stylesheets and look but when I do an upgrade I get the server 500 error now. <br /> <br />Error message: <br />Premature end of script headers: ubbthreads.php <br /> <br />And my host referred me to this <br /> <br />http://64.4.53.250/cgi-bin/linkrd?_lang=...%2dhosting%2316 <br /> <br /> <br />I have followed these instructions to the letterhttp://www.ubbcentral.com/support/docs/ubbthreads/UBBthreads_Unix_install.html...are these instructions up to date?


Edited by ChAoS (10/15/04 06:01 PM)

Top
#280288 - 10/15/04 06:15 PM Re: Importing the Database [Re: barbiro]
scroungr Offline
Old Hand

Registered: 10/17/03
Posts: 2409
Loc: Richmond, VA
Chaos tell ya what shoot one of us a PM and we will try and help ya out. we will need your mysql password and username as well as ftp rights so we can check permissions.. you can always change them later
_________________________
Couchtomatoe - www.couch-tomatoe.cc
My abilities are for hire for installs, upgrades, custom themes and custom modifications.

Top
#280289 - 10/15/04 09:16 PM Re: Importing the Database [Re: 234234]
ChAoS_dup1 Offline
Code Monkey

Registered: 11/15/02
Posts: 576
Loc: Great Northwest
I got it up-I did the fresh install of 6.5 and had the host copy the db files directly,then brought in my templates and configs and everything is working. One problem I am having though since my domain pointers arent working yet. Everyones avatards(sp hehe) are still trying to use emeraldforestseattle.com and right now I am currently at http://emeraldforestseattle.nuclearfallout.net I cant find out where to change this even though I have set the correct image/avatar path in the control panel.This is causing slow page loads and pegging the cpu at 100%


Edited by ChAoS (10/15/04 09:24 PM)
_________________________
ChAoS
Emerald Forest Gaming Servers
Official STFU Thread


Top
#280290 - 10/15/04 09:30 PM Re: Importing the Database [Re: barbiro]
Twisty Offline
Code Monkey

Registered: 09/26/03
Posts: 524
Try this ChAoS... <br /> <br />UPDATE w3t_Users <br />SET U_Picture = REPLACE(U_Picture, 'www.emeraldforestseattle.com','emeraldforestseattle.nuclearfallout.net');
_________________________
Twisty []http://www.mameworld.info/misc/nana2.gif[/]
MAMEWorld

Top
#280291 - 10/15/04 09:43 PM Re: Importing the Database [Re: smoknz28]
scroungr Offline
Old Hand

Registered: 10/17/03
Posts: 2409
Loc: Richmond, VA
yeah what twisty said <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />
_________________________
Couchtomatoe - www.couch-tomatoe.cc
My abilities are for hire for installs, upgrades, custom themes and custom modifications.

Top
Page 2 of 3 < 1 2 3 >


Moderator:  Gizmo 
Who's Online
0 registered (), 22 Guests and 11 Spiders online.
Key: Admin, Global Mod, Mod
Shout Box

Latest Posts
Forum 'Trader Ratings'.
by blaaskaak
Yesterday at 08:27 AM
Problems reading a lot of old posts here
by Ruben Rocha
11/18/08 04:33 PM
PhotoPost BB Code Popup
by Iann128
11/15/08 01:24 PM
Customization needed
by Gizmo
11/12/08 12:28 PM
Team UBBDev Rides Again!
by AllenAyres
11/11/08 02:16 PM
Active Topics.
by AllenAyres
11/11/08 02:13 PM
Looking for a simple upload script
by AllenAyres
11/11/08 02:12 PM
New Mods
Forum 'Trader Ratings'.
by McLemore
11/19/08 02:14 PM
[7.4] Keep log of custom title changes
by blaaskaak
10/27/08 07:51 AM
User Authentication Class
by
01/19/07 02:59 PM
Multiple Identity Detector
by
12/30/06 06:39 PM
PhotoPost BB Code Popup
by
11/06/06 05:43 PM
Newest Members
Begbie, cenk, MATTO, DougMMcts, tim Anderson
13361 Registered Users
Top Posters
AllenAyres 25448
JoshPet 11330
Rick 8372
LK 7396
Lord Dexter 6503
Greg Hard 5533
Charles Capps 5438

 

 

 
fusionbb message board php hacks